Sos!!!

[Shoonra]

I got locked out of my forums completely!

There I was quietly minding my owm business and setting up a new moderator when bang - I get this strange error message and the system doesn't know who I am any more.

Not only am I locked out of the control panel - I also can't access my forums main page!! It keeps asking me for username and password but doesn't recognize them! This is very scary because you don't have to have a username and password to see the forums!

I also just received this email:

Database error in vBulletin Control Panel: Invalid SQL: SELECT COUNT(userid) AS users FROM user WHERE usergroupid=
mysql error: You have an error in your SQL syntax near '' at line 1
mysql error number: 1064
Date: Friday 09th of February 2001 03:59:21 AM
Script:
Referer: http://www.thecatsite.com/forums/admin/forum.php3?action=moderators

What does that mean? What should I do? Can other people access my forums?

www.thecatsite.com/forums

Please help!!!

[Munro]

I can see them use the getadmin.php feature that might work...

[PeF]

Or you may use phpMyAdmin and take a look at the db. Open user table, select browse, find your username and change usergroup to 6 (admins).

[Shoonra]

Thanks for the quick reply guys - but what exactly should I do?

I don't know any PHP and I don't know how to run those things you were talking about. From my browswe (how?), my ftp program (how?), telnet (how?).

I'm glad to know that others can see them, but I would like to be back as admin ASAP!

Thank you so much!

[PeF]

phpMyAdmin can be downloaded from here:
http://phpwizard.net/projects/phpMyAdmin/

It's very powerful tool for administering MySQL databases with very easy setup. Intructions are included.

[Shoonra]

well I downloaded phpMyAdmin and tried to install. I get a 500 error message (I'm using a UNIX server).

I have never installed a php script before. Do I need to change the file permissions to something other than 664 (like I usually need to do for perl script)?

I've edited the config file to the best I could - I don't know what else to do :(

[JamesUS]

Try this:

Open Notepad, and paste this in:


require("global.php");
$DB_site->query("UPDATE user SET usergroupid='6' WHERE username='YOURUSERNAME'");
echo("All done!");


Replace YOURUSERNAME with your username, save as getadmin.php and upload to the same folder as your forums. Then type the URL to getadmin.php in your browser and it should fix the permissions for you :)

Hope that helps!

[Shoonra]

Thanks everyone!

It's solved. Turns out the getadmin is what I needed, but... in the script it kept calling global.php and it needed to call global.php3!!

I don't know any php but I managed to figure that one out! After I changed that, all was well and I reinstalled myself as administrator.

By the way, someone at another forum told me that this thing happened because I tried setting myself as moderator as well and thus I turned from administrator into moderator.

Well, all's well than ends well.

Thanks again!