Database error

[GoHorns123]

This is the entire message - it's happening again, right now - and there is no one logged into the board.


Database error in vBulletin :

Invalid SQL:

SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield',' userstats','birthdaycache','maxloggedin','iconcach e','eventcache','mailqueue');

MySQL Error : User 'indiscri' has exceeded the 'max_questions' resource (current value: 50000)
Error Number : 1226

Date : Tuesday, August 21st 2007 @ 07:27:00 PM


While I was typing, a second error came in.

Database error in vBulletin :

Invalid SQL:

SELECT *
FROM datastore

WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield');


MySQL Error : User 'indiscri' has exceeded the 'max_questions' resource (current value: 50000)
Error Number : 1226

Date : Tuesday, August 21st 2007 @ 07:29:41 PM
Script : http://www.XXX.com/forums/arcade.php?do=stats&gameid=8 (edited out board name & url for security)
Referrer :
IP Address : xxx.xx.xxxx
Username :
Classname : vb_database

[Eikinskjaldi]

Like I said, run it in debug mode, see how any queries are being generated.

[GoHorns123]

Sorry to be annoying, but how do I do that?

For example, I can't even access my databases. I try to log into phpmyadmin and it says "no databases" and the same error message.

[Eikinskjaldi]

turn your board off so that others cannot access it

add the following to config.php

$config['Misc']['debug'] = true;

When you load a page, at the bottom you will see a full workup of all the files called and number of database queries made.

You might have to wait an hour for the timeout you are experiencing to reset itself.

[GoHorns123]

Thank you. So I should just wait out this database error, and then attempt these steps?

On a side note, the exadmin that I mentioned previously has made her own board, using vb, and the same host we have - when we go down, we notice she has gone down too - odd? It's happened about 3 times... could our forums be connected somehow?

[Eikinskjaldi]

Originally Posted by GoHorns123

Thank you. So I should just wait out this database error, and then attempt these steps?

On a side note, the exadmin that I mentioned previously has made her own board, using vb, and the same host we have - when we go down, we notice she has gone down too - odd? It's happened about 3 times... could our forums be connected somehow?

Yep, wait it out.

She had full access to your system. For all I know she is using your forums. If she has ssh access and/or database access then she could write a script that calls your db 50000 times a minute.

Anything is possible.

[GoHorns123]

So what can I do to see if she's using our forums? Or what can I do to change it to make sure she can't use our forums?

[Eikinskjaldi]

Originally Posted by GoHorns123

So what can I do to see if she's using our forums? Or what can I do to change it to make sure she can't use our forums?

Assuming she didn't have root ssh access to the server:

Change all passwords, clear all php files, relaod a new version of the code from vb


Assuming she did have root access to the server:
ask your techs for a hard drive wipe and compete system re-install

[GoHorns123]

I think honestly, this is the case

If she has ssh access and/or database access then she could write a script that calls your db 50000 times a minute.

So how do I remover her ssh access?

By the way, it's now the next morning and the board is still down. Same DB error.

Ok, weird.

I just got our vb board up again... and the way I did that was to install a temporary phpbb board. Once I installed that - our normal forums were up and running, like it recognized our databases again.

This happened the same way the other night.

Any thoughts on this?

Update : We are now up, and their forums are down.

[Eikinskjaldi]

Originally Posted by GoHorns123

I think honestly, this is the case

So how do I remover her ssh access?

This is not something I can explain to you via post. If she has any skill she could have hidden an account anywhere on the system. You need to know how to search for it.

Ok, weird.

I just got our vb board up again... and the way I did that was to install a temporary phpbb board. Once I installed that - our normal forums were up and running, like it recognized our databases again.

This happened the same way the other night.

Any thoughts on this?

Update : We are now up, and their forums are down.

I have no idea on this. There is just so much it could be, and trying to fix the problem a post at a time is difficult.