Datalife Sql Fatal error 1054

[Eddie Morra]

I installed 9.4 DataLife version utf8.

After I imported the database from the control panel of the old version of DataLife 9.2 utf8,

Now I can not change settings in the all user groups, give me error:

MySQL Error!
------------------------

The Error returned was:
Unknown column 'allow_vote' in 'field list'

Error Number: 1054

UPDATE dle_usergroups set group_name='Members', allow_cats='all', allow_adds='1', cat_add='9,10,11,12,60,15,18,19,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,61,62,63,64,72,42,43,44,45,46,47,48,49,50,51,52,53,76,54,55,56,57,65,66,67,68,69,70,71,84,14,13,73,77,17,78,79,74,75,80,81,82,83', allow_admin='0', allow_addc='1', allow_editc='1', allow_delc='0', edit_allc='0', del_allc='0', moderation='0', allow_all_edit='0', allow_edit='0', allow_pm='1', max_pm='20', max_foto='101', allow_files='0', allow_hide='1', allow_short='1', time_limit='0', rid='4', allow_fixed='0', allow_feed='1', allow_search='1', allow_poll='1', allow_main='1', captcha='1', icon='{THEME}/images/icon_mbr.gif', allow_modc='0', allow_rating='1', allow_offline='0', allow_image_upload='1', allow_file_upload='1', allow_signature='1', allow_url='1', news_sec_code='1', allow_image='0', max_signature='500', max_info='1000', admin_addnews='0', admin_editnews='0', admin_comments='0', admin_categories='0', admin_editusers='0', admin_wordfilter='0', admin_xfields='0', admin_userfields='0', admin_static='0', admin_editvote='0', admin_newsletter='0', admin_blockip='0', admin_banners='0', admin_rss='0', admin_iptools='0', admin_rssinform='0', admin_googlemap='0', allow_html='1', group_prefix='', group_suffix='', allow_subscribe='1', allow_image_size='0', cat_allow_addnews='all', flood_news='0', max_day_news='3', force_leech='0', edit_limit='0', captcha_pm='1', max_pm_day='0', max_mail_day='0', admin_tagscloud='0', allow_vote='0', admin_complaint='0', news_question='0', comments_question='0' WHERE id='4' 

how to fix ?

Thanks

Eddie Morra Reviewed by Eddie Morra on 10th Dec 2011. Datalife Sql Fatal error 1054 I installed 9.4 DataLife version utf8. After I imported the database from the control panel of the old version of DataLife 9.2 utf8, Now I can not change settings in the all user groups, give me error: MySQL Error! ------------------------ The Error returned was: Rating: 5

[CameronS]

Make the PHP code this:

UPDATE dle_usergroups set group_name='Members', allow_cats='all', allow_adds='1', cat_add='9,10,11,12,60,15,18,19,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,61,62,63,64,72,42,43,44,45,46,47,48,49,50,51,52,53,76,54,55,56,57,65,66,67,68,69,70,71,84,14,13,73,77,17,78,79,74,75,80,81,82,83', allow_admin='0', allow_addc='1', allow_editc='1', allow_delc='0', edit_allc='0', del_allc='0', moderation='0', allow_all_edit='0', allow_edit='0', allow_pm='1', max_pm='20', max_foto='101', allow_files='0', allow_hide='1', allow_short='1', time_limit='0', rid='4', allow_fixed='0', allow_feed='1', allow_search='1', allow_poll='1', allow_main='1', captcha='1', icon='{THEME}/images/icon_mbr.gif', allow_modc='0', allow_rating='1', allow_offline='0', allow_image_upload='1', allow_file_upload='1', allow_signature='1', allow_url='1', news_sec_code='1', allow_image='0', max_signature='500', max_info='1000', admin_addnews='0', admin_editnews='0', admin_comments='0', admin_categories='0', admin_editusers='0', admin_wordfilter='0', admin_xfields='0', admin_userfields='0', admin_static='0', admin_editvote='0', admin_newsletter='0', admin_blockip='0', admin_banners='0', admin_rss='0', admin_iptools='0', admin_rssinform='0', admin_googlemap='0', allow_html='1', group_prefix='', group_suffix='', allow_subscribe='1', allow_image_size='0', cat_allow_addnews='all', flood_news='0', max_day_news='3', force_leech='0', edit_limit='0', captcha_pm='1', max_pm_day='0', max_mail_day='0', admin_tagscloud='0', admin_complaint='0', news_question='0', comments_question='0' WHERE id='4' 

[Eddie Morra]

How to make?

Make the PHP code this:

UPDATE dle_usergroups set group_name='Members', allow_cats='all', allow_adds='1', cat_add='9,10,11,12,60,15,18,19,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,61,62,63,64,72,42,43,44,45,46,47,48,49,50,51,52,53,76,54,55,56,57,65,66,67,68,69,70,71,84,14,13,73,77,17,78,79,74,75,80,81,82,83', allow_admin='0', allow_addc='1', allow_editc='1', allow_delc='0', edit_allc='0', del_allc='0', moderation='0', allow_all_edit='0', allow_edit='0', allow_pm='1', max_pm='20', max_foto='101', allow_files='0', allow_hide='1', allow_short='1', time_limit='0', rid='4', allow_fixed='0', allow_feed='1', allow_search='1', allow_poll='1', allow_main='1', captcha='1', icon='{THEME}/images/icon_mbr.gif', allow_modc='0', allow_rating='1', allow_offline='0', allow_image_upload='1', allow_file_upload='1', allow_signature='1', allow_url='1', news_sec_code='1', allow_image='0', max_signature='500', max_info='1000', admin_addnews='0', admin_editnews='0', admin_comments='0', admin_categories='0', admin_editusers='0', admin_wordfilter='0', admin_xfields='0', admin_userfields='0', admin_static='0', admin_editvote='0', admin_newsletter='0', admin_blockip='0', admin_banners='0', admin_rss='0', admin_iptools='0', admin_rssinform='0', admin_googlemap='0', allow_html='1', group_prefix='', group_suffix='', allow_subscribe='1', allow_image_size='0', cat_allow_addnews='all', flood_news='0', max_day_news='3', force_leech='0', edit_limit='0', captcha_pm='1', max_pm_day='0', max_mail_day='0', admin_tagscloud='0', admin_complaint='0', news_question='0', comments_question='0' WHERE id='4' 

[soft2050]

Go to phpmyadmin:

Execute these 2 commands:

ALTER  TABLE  `dle_usergroups`  ADD  `allow_vote` TINYINT( 1  )  NOT  NULL DEFAULT  '1'; 

ALTER  TABLE  `dle_usergroups`  ADD  `admin_complaint` TINYINT( 1  )  NOT  NULL DEFAULT  '0'; 

Your error will be fixed

[Eddie Morra]

Go to phpmyadmin:

Execute these 2 commands:

ALTER  TABLE  `dle_usergroups`  ADD  `allow_vote` TINYINT( 1  )  NOT  NULL DEFAULT  '1'; 

ALTER  TABLE  `dle_usergroups`  ADD  `admin_complaint` TINYINT( 1  )  NOT  NULL DEFAULT  '0'; 

Your error will be fixed

Now "Quick Links" (for clear cache) dont work return me error:

MySQL Error!
------------------------

The Error returned was:
Table 'database.dle_complaint' doesn't exist

Error Number:
1146

SELECT COUNT(*) as count FROM dle_complaint

[soft2050]

I think you didn't ran the upgrade and are simply using the script like that. Else the tables would have been automatically created through the upgrader

Run : www.mysite.com/upgrade/index.php to upgrade

[Eddie Morra]

i have reinstalled all


1. Clean database tables
2. Reinstall new copy of dle 9.4 utf8
3. Import the database (the original version of DLE 9.2 utf8)
4. after importing database run upgrades "mysites/upgrade/index.php"
5. Run command sql:

ALTER  TABLE  `dle_usergroups`  ADD  `allow_vote` TINYINT( 1  )  NOT  NULL DEFAULT  '1'; 

6. Run command sql:

ALTER  TABLE  `dle_usergroups`  ADD  `admin_complaint` TINYINT( 1  )  NOT  NULL DEFAULT  '0'; 

Sql responde: #1060 - Duplicate column name 'admin_complaint'

Now give me a new error if edit all user groups:

MySQL Error!
------------------------
The Error returned was:
Unknown column 'news_question' in 'field list'
Error Number:1054

UPDATE dle_usergroups set group_name='Uploader', allow_cats='all', allow_adds='1', cat_add='all', allow_admin='1', allow_addc='1', allow_editc='1', allow_delc='1', edit_allc='0', del_allc='0', moderation='1', allow_all_edit='0', allow_edit='1', allow_pm='1', max_pm='20', max_foto='200', allow_files='1', allow_hide='1', allow_short='1', time_limit='0', rid='4', allow_fixed='0', allow_feed='1', allow_search='1', allow_poll='1', allow_main='1', captcha='0', icon='{THEME}/images/icon_upl.gif', allow_modc='0', allow_rating='1', allow_offline='0', allow_image_upload='1', allow_file_upload='0', allow_signature='1', allow_url='1', news_sec_code='0', allow_image='1', max_signature='500', max_info='1000', admin_addnews='1', admin_editnews='1', admin_comments='0', admin_categories='0', admin_editusers='0', admin_wordfilter='0', admin_xfields='0', admin_userfields='0', admin_static='0', admin_editvote='0', admin_newsletter='0', admin_blockip='0', admin_banners='0', admin_rss='0', admin_iptools='0', admin_rssinform='0', admin_googlemap='0', allow_html='1', group_prefix='<b><span style=\"color:red\">', group_suffix='</span></b>', allow_subscribe='1', allow_image_size='0', cat_allow_addnews='all', flood_news='0', max_day_news='0', force_leech='0', edit_limit='0', captcha_pm='0', max_pm_day='0', max_mail_day='0', admin_tagscloud='0', allow_vote='1', admin_complaint='0', news_question='0', comments_question='0' WHERE id='6'

help me please

[NewEraCracker]

You should install the same DLE version database is for. Then upgrade to latest DLE.