Originally Posted by -=Sniper=-
Hey, I'm not sure if its during the new install or update, I had no options displaying in control panel, so I used the script to insert again, but got a error! so looking at the entries in phpmyadmin I found the values were in the wrong place.
the values for "disaply order" are in the "default value" field, vice versa.
the values for "group title" are in the "value" field
the values for "option code" are in the "group title" field
and the value for "values" are in the "option code" field!
use this in phpmyadmin to update, if you have this problem. (change setting to your prefix_setting).
PHP Code:
UPDATE `setting` SET `varname` = 'post_thanks_date_all', `value` = '1', `optioncode` = 'yesno', `displayorder` = 50, `grouptitle` = 'post_thanks', `defaultvalue` = '1', `advanced` = 0, `volatile` = 0 WHERE `varname` = 'post_thanks_date_all';
UPDATE `setting` SET `varname` = 'post_thanks_date_forum', `value` = '', `optioncode` = '', `displayorder` = 60, `grouptitle` = 'post_thanks', `defaultvalue` = '0', `advanced` = 0, `volatile` = 0 WHERE `varname` = 'post_thanks_date_forum';
UPDATE `setting` SET `varname` = 'post_thanks_forum_first', `value` = '', `optioncode` = '', `displayorder` = 40, `grouptitle` = 'post_thanks', `defaultvalue` = '0', `advanced` = 0, `volatile` = 0 WHERE `varname` = 'post_thanks_forum_first';
UPDATE `setting` SET `varname` = 'post_thanks_forum_first_all', `value` = '0', `optioncode` = 'yesno', `displayorder` = 30, `grouptitle` = 'post_thanks', `defaultvalue` = '0', `advanced` = 0, `volatile` = 0 WHERE `varname` = 'post_thanks_forum_first_all';
UPDATE `setting` SET `varname` = 'post_thanks_forum_off', `value` = '', `optioncode` = '', `displayorder` = 20, `grouptitle` = 'post_thanks', `defaultvalue` = '0', `advanced` = 0, `volatile` = 0 WHERE `varname` = 'post_thanks_forum_off';
UPDATE `setting` SET `varname` = 'post_thanks_on_off', `value` = '1', `optioncode` = 'yesno', `displayorder` = 10, `grouptitle` = 'post_thanks', `defaultvalue` = '1', `advanced` = 0, `volatile` = 0 WHERE `varname` = 'post_thanks_on_off';
UPDATE `setting` SET `varname` = 'post_thanks_usergroup_using', `value` = '', `optioncode` = '', `displayorder` = 70, `grouptitle` = 'post_thanks', `defaultvalue` = '0', `advanced` = 0, `volatile` = 0 WHERE `varname` = 'post_thanks_usergroup_using';
UPDATE `setting` SET `varname` = 'post_thanks_user_useing', `value` = '', `optioncode` = '', `displayorder` = 80, `grouptitle` = 'post_thanks', `defaultvalue` = '0', `advanced` = 0, `volatile` = 0 WHERE `varname` = 'post_thanks_user_useing';
|