Latest Announcemnent
New thread
Status
Not open for further replies.
S

sSKKa

Active Member
1,124
2010
141
0
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'
Click to expand...
waiting for experts reply
 
12 comments
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'
Click to expand...
 
PHP: 
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>
 
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?
 
sSKKa said:
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?
Click to expand...
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
 
after clear cache i did above method now its giving in phpmyadmin
#1060 - Duplicate column name 'allow_complaint'
Click to expand...


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

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

Error Number:
1054
 
Arthur said:
@SOFT
Sorry for going off topic but you should see this
http://www.dl4everything.com/site-news/316471-no-duplicate-articles.html
Click to expand...
Yeah! I am aware of that problem
I closed down my mysql server for some time
Thank you btw

sSKKa said:
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
Click to expand...
Oopz! its admin_complaint
You can delete allow_complaint using phpmyadmin if you want

Execute this query:
PHP: 
ALTER  TABLE  `dle_usergroups`  ADD  `admin_complaint` TINYINT( 1  )  NOT  NULL DEFAULT  '0'
 
i get same error with new installation of dle 9.4 (nulled dlviet) and old database dle 9.2

Give me error for all usergroup

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

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

Error Number:
1054
Code: 
UPDATE dle_usergroups set group_name='Administrators', allow_cats='all', allow_adds='1', cat_add='all', allow_admin='1', allow_addc='1', allow_editc='1', allow_delc='1', edit_allc='1', del_allc='1', moderation='1', allow_all_edit='1', allow_edit='1', allow_pm='1', max_pm='1000', max_foto='400x400', allow_files='1', allow_hide='1', allow_short='1', time_limit='0',.........

How to fix all usergroups?

Thanks
 
Status
Not open for further replies.
Back
Top