Help with admin
 

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

Try running the query.

[sql]UPDATE user SET usergroupid=6 WHERE userid=x[/sql]

x being your userid.

Cheers,
g-force2k2

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]

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

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.