Jump to the post that solved this thread.
Solved: 6 Years, 4 Months, 3 Weeks ago 1054 - Unknown column 'edittimelimit' in 'field list' Query:
#1
Solved: 6 Years, 4 Months, 3 Weeks ago Question 
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.
Reply
#2
Solved: 6 Years, 4 Months, 3 Weeks ago
Upgraded from which version?
Reply
#3
Solved: 6 Years, 4 Months, 3 Weeks ago
(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.
Reply
#4
Solved: 6 Years, 4 Months, 3 Weeks ago
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.
Reply
#5
Solved: 6 Years, 4 Months, 3 Weeks ago
(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.
Reply
#6
Solved: 6 Years, 4 Months, 3 Weeks ago
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;
Reply
#7
Solved: 6 Years, 4 Months, 3 Weeks ago
(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.

Smile
Reply
Jump to the post that solved this thread.


Forum Jump:


Users browsing this thread: 1 Guest(s)