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:
PHP Code: 
ALTER  TABLE  `dle_usergroups`  ADD  `allow_vote` TINYINT( 1  )  NOT  NULL DEFAULT  '1'; 

6. Run command sql:
PHP Code: 
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

Code: 
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
Eddie Morra Reviewed by Eddie Morra on . 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