CreateMyBB Support Forums
SQL Error from Editing User Groups (2) - Printable Version

+- CreateMyBB Support Forums (https://support.createmybb.com)
+-- Forum: CreateMyBB Support (https://support.createmybb.com/forumdisplay.php?fid=5)
+--- Forum: General Support (https://support.createmybb.com/forumdisplay.php?fid=6)
+--- Thread: SQL Error from Editing User Groups (2) (/showthread.php?tid=3362)



SQL Error from Editing User Groups (2) - tartist - 11-15-2021

When I edit and try to save a user group I get an SQL error referring to field canbeinvisible:
Code:
MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1054 - Unknown column 'canbeinvisible' in 'field list'

A solution to this is reported in another forum https://community.mybb.com/thread-233700.html
Code:
ALTER TABLE mybb_usergroups ADD COLUMN canbeinvisible tinyint(1) NOT NULL default '1' AFTER canbereported;

How do I implement this, please?


RE: SQL Error from Editing User Groups (2) - Jon - 11-15-2021

What is your forum url?


RE: SQL Error from Editing User Groups (2) - Jon - 11-15-2021

I ran the query on all hosted forums let me know if it helps.


RE: SQL Error from Editing User Groups (2) - tartist - 11-16-2021

(11-15-2021, 09:53 PM)Jon Wrote: I ran the query on all hosted forums let me know if it helps.

That's done the trick Jon.
Thanks for your support!