MyBB Community Forums

Full Version: 1054 - Unknown column 'edittimelimit' in 'field list' Query:
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Upgrade to 1.8.2 and getting "1054 - Unknown column 'edittimelimit' in 'field list' " when trying to edit a group.

I'm trying to hide Admin from member list, and forum team page.

Any ideas ?

Thank you.
Upgraded from which version?
(11-20-2014, 10:07 PM)Destroy666 Wrote: [ -> ]Upgraded from which version?

Sorry forgot to mention that bit 1.6.10

I'm unable to make any changes in any groups.
Well, the column was added during the upgrade: https://github.com/mybb/mybb/blob/featur...0.php#L467 You mmay have deleted it by deactivating/uninstalling an old plugin. Now you have to readd it.
(11-21-2014, 01:15 AM)Destroy666 Wrote: [ -> ]Well, the column was added during the upgrade: https://github.com/mybb/mybb/blob/featur...0.php#L467 You mmay have deleted it by deactivating/uninstalling an old plugin. Now you have to readd it.

I did have an old plugin http://mods.mybb.com/view/edit-time-limi...ermissions that may have caused a conflict.

I removed it after the upgrade, so will I have to now go through the whole upgrade again or is there just one part I can change?

Thank you for your help.
You can just manually add the field edittimelimit to the mybb_usergroups table.

Run this in PHPMyAdmin:
ALTER TABLE mybb_usergroups ADD edittimelimit INT(4) NOT NULL DEFAULT 0;
(11-21-2014, 01:52 PM)dragonexpert Wrote: [ -> ]You can just manually add the field edittimelimit to the mybb_usergroups table.

Run this in PHPMyAdmin:

ALTER TABLE mybb_usergroups ADD edittimelimit INT(4) NOT NULL DEFAULT 0;

Thank you very much Dragonexpert that solved it.

EDIT: I've marked best answer, but cant seem to mark it as solved.

I appreciate you both helping.

Smile