MyBB Community Forums

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?

(2014-11-20, 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.

(2014-11-21, 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;

(2014-11-21, 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.