View Full Version : Help with admin
dmogg
02-14-2004, 06:45 AM
Okay I had a few problems and deleted a table, well I have since rebuilt the table and my board was down for maintance, now I try and log into the admincp and it will not recognize me as the admin, how do I fix this? I looked at the table in myphpadmin and it says I am an admin yet VB wont let me in. Plz help
g-force2k2
02-14-2004, 07:07 AM
Try running the query.
UPDATE user SET usergroupid=6 WHERE userid=x
x being your userid.
Cheers,
g-force2k2
dmogg
02-14-2004, 06:40 PM
I ran that querie and this is the message I got.
Error
SQL-query :
UPDATE user SET usergroupid =6 WHERE userid = TheNotoriousMogg
MySQL said:
#1054 - Unknown column 'TheNotoriousMogg' in 'where clause'
[Documentation] ยท [Back]
dmogg
02-14-2004, 06:43 PM
Also what happens is I go to log into the admincp and it says "thanks for logging..blah blah" and it kicks me back into the login screen, I went into my phpadmin and found the 'user' table and 'usergroup' table and the 'user' table says I am an admin, usersgroup 6 and the 'usergroup' table says usergroup 6 us administrators.
Thank you
Zachery
02-14-2004, 08:09 PM
Also what happens is I go to log into the admincp and it says "thanks for logging..blah blah" and it kicks me back into the login screen, I went into my phpadmin and found the 'user' table and 'usergroup' table and the 'user' table says I am an admin, usersgroup 6 and the 'usergroup' table says usergroup 6 us administrators.
Thank you
USERID not USERNAME
Userid is your ID based apon the the order in which you registered
If you installed vBulletin your probally userid 1
dmogg
02-15-2004, 06:17 AM
I ran the query and still I cannot log in.
I tried adding another one of my mods as a admin by running this query and he could not either.
the usergroup table looks fine
Thanks for all your help.
vBulletin® v3.8.12 by vBS, Copyright ©2000-2024, vBulletin Solutions Inc.