MyBB Community Forums

Hmm, I'm never sure what to do with quotes in SQL queries. Try this:

UPDATE `mybb_usergroups` SET `cancp` = 'yes' WHERE `gid` = '4'

(2008-06-29, 12:03 PM)MrDoom Wrote: [ -> ]Hmm, I'm never sure what to do with quotes in SQL queries. Try this:

UPDATE `mybb_usergroups` SET `cancp` = 'yes' WHERE `gid` = '4'

Entered! Now what?

If it ran without an error, and the problem was what I thought the problem was. You should now have access to the AdminCP again. If you haven't; either the problem lies somewhere else, or my query was wrong.

To check if you have access to the AdminCP, you can run this query the same as before:

SELECT title, cancp FROM `mybb_usergroups` WHERE gid =4

It should return:

title 			 cancp
Administrators 	yes

(2008-06-29, 12:38 PM)MrDoom Wrote: [ -> ]If it ran without an error, and the problem was what I thought the problem was. You should now have access to the AdminCP again. If you haven't; either the problem lies somewhere else, or my query was wrong.

To check if you have access to the AdminCP, you can run this query the same as before:

SELECT title, cancp FROM `mybb_usergroups` WHERE gid =4

It should return:

title 			 cancp
Administrators 	yes

Old website deleted. New website created.