Database error

[GoHorns123]

Can anyone tell me why I would get this database error for a couple of hours, and then the board went back to being fine & running. What would cause this error?

Invalid SQL:

SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcac
he','stylecache','languagecache','products','plugi nlist','cron','pr
ofilefield','userstats','birthdaycache','maxlogged in','iconcache','eventcac
he','mailqueue');

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

[Paul M]

Because you hit a limit set by your host, that limit is a timed limit so once the time has expired you are ok again.

[Kirk Y]

To my knowledge, the "max_questions" resource refers to the amount of SELECT queries that are allowed to be performed per hour, so after that hour passed - you were fine.

[GoHorns123]

Our board isn't busy at all. Maybe 9 people post there, and we've never seen that error before. That's why I was confused to why we got that error.

What exactly is select queries? Is that hits to the board?

[Kirk Y]

If I'm right in it being due to SELECT queries; they retrieve information previously stored in your database - ie: posts, users, statistics, etc.

[Eikinskjaldi]

Originally Posted by GoHorns123

Our board isn't busy at all. Maybe 9 people post there, and we've never seen that error before. That's why I was confused to why we got that error.

What exactly is select queries? Is that hits to the board?

Depends on how many people are connected as "user i"

select queries are queries which select (extract data from) the database. As opposed to insert queries (which insert data into the database)

[GoHorns123]

Hmmm, so someone was retrieving previously stored info from our database? There are only 2 of us that are supposed to be connected to user" i". Me or the other admin weren't doing that at the time we got that error. So that would mean we have someone else that can access our database, right?

[Eikinskjaldi]

Originally Posted by GoHorns123

Hmmm, so someone was retrieving previously stored info from our database? Me or the other admin weren't doing that at the time we got that error. So that would mean we have someone else that can access our database, right?

Almost all vb info lives in a db. if you view a forum, thread, post, user info, basically anything and everything, you are looking at data from the db.

[GoHorns123]

Originally Posted by Eikinskjaldi

Almost all vb info lives in a db. if you view a forum, thread, post, user info, basically anything and everything, you are looking at data from the db.

I got that part. What I'm not understanding is why we would have gotten that error. Even when our board was big we never got a database error like that. Now, only a few people post there and it isn't busy at all. I'm just wondering if our ex admin that flipped out on us was running inquiries and that's why we got that error. Only one person was on the board at the time it went down, and we shouldn't have reached "max_questions.

See what I'm saying?

And you have to excuse me if I'm asking stupid questions or not understanding , I'm just learning about this stuff.

I don't know if it matters but this was with the database error. It has a IP number with it, but I have no idea what that means. I'm guessing it means it was a person trying to get onto the board when we were down.

"Database error in vBulletin 3.6.4:

Invalid SQL:

SELECT *
FROM session
WHERE userid = 0

AND host = '74.6.25.203'
AND idhash = '67264e443604f5f10d3bd6750ed99119'
LIMIT 1;"

[Eikinskjaldi]

Originally Posted by GoHorns123

I got that part. What I'm not understanding is why we would have gotten that error. Even when our board was big we never got a database error like that. Now, only a few people post there and it isn't busy at all. I'm just wondering if our ex admin that flipped out on us was running inquiries and that's why we got that error.

It is possible. Either that or there is some really poor/inefficient code in your system that is making a lot of db calls.

Run the board in debug mode and have a look at how many queries your pages generate.

As for the error, was there more to the message? some indication of what the invalid sql was or perhaps an error message?