MySQL Fatal Error

[sSKKa]

Hi

guys help me when i am trying to edit usergroup in dle it giving me mysql error please check it out

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

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

Error Number:
1054

UPDATE dle_usergroups set group_name='Author', 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='50', max_foto='101', allow_files='1', allow_hide='1', allow_short='1', time_limit='0', rid='3', allow_fixed='0', allow_feed='1', allow_search='1', allow_poll='1', allow_main='1', captcha='0', icon='{THEME}/images/icon_3.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='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='', group_suffix='', allow_subscribe='1', allow_image_size='1', 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='0', admin_complaint='0' WHERE id='3'

waiting for experts reply

sSKKa Reviewed by sSKKa on 28th Oct 2011. MySQL Fatal Error Hi guys help me when i am trying to edit usergroup in dle it giving me mysql error please check it out MySQL Error! ------------------------ The Error returned was: Unknown column 'allow_vote' in 'field list' Rating: 5

[t3od0r]

try this in phpmyadmin

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

[sSKKa]

how to do it can you please guide me briefly

[t3od0r]

-open phpmyadmin
-click SQL (you will find the link on top of the page)
-paste the line there and execute

[sSKKa]

above one executed now it giving

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

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

Error Number:
1054

UPDATE dle_usergroups set group_name='Author', allow_cats='all', allow_adds='1', cat_add='all', allow_admin='0', 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='50', max_foto='101', allow_files='1', allow_hide='1', allow_short='1', time_limit='0', rid='3', allow_fixed='0', allow_feed='1', allow_search='1', allow_poll='1', allow_main='1', captcha='0', icon='{THEME}/images/icon_3.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='0', allow_image='1', max_signature='500', max_info='1000', admin_addnews='0', 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='', group_suffix='', allow_subscribe='1', allow_image_size='1', 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='0', admin_complaint='0' WHERE id='3'

[soft2050]

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

Execute the same as you did with above command

You must be using some plugin which you haven't successfully installed or a nulled incomplete release
</span></span>

[sSKKa]

giving same error

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

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

Error Number:
1054


@soft2050 then how to get rid of this error? what should i do?

[soft2050]

giving same error

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

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

Error Number:
1054


@soft2050 then how to get rid of this error? what should i do?

Must be your browser cache
Did you executed above command successfully?
If yes, then Did it came out with some error?
Try to clear cache and retry

[Arthur]

@SOFT
Sorry for going off topic but you should see this
http://www.dl4everything.com/site-ne...-articles.html

[soft2050]

@SOFT
Sorry for going off topic but you should see this
http://www.dl4everything.com/site-ne...-articles.html

Yeah! I am aware of that problem
I closed down my mysql server for some time
Thank you btw

after clear cache i did above method now its giving in phpmyadmin



and same error while doing setting in usergroup
MySQL Error!
------------------------

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

Error Number:
1054

Oopz! its admin_complaint
You can delete allow_complaint using phpmyadmin if you want

Execute this query:

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