HAve you seen this error before?

[austy25]

Hi everyone!
I have been running the store just fine without any major issues lately but then last night this error came up

1226 User '*****' has exceeded the 'max_questions' resource (current value: 50000)
in:
[select value from sessions where sesskey = '81ca57d93d251474730b983fbf19dfbb' and expiry > '1174925865']

This resulted in me not being able to log in to admin or store - the rest of the site works just fine.
I do have admin set for more users to be able to upload and insert their own products could that be the problem I have searched the database quite a bit this morning but can't seem to pinpoint exactly this problem
Please excuse this thread if its in the wrong section. I was looking for an error section but didn't find one.

Thank you!!!!

[austy25]

Grr double post sorry

[austy25]

Sorry to have posted this question - never mind on the issue - I did a 'max_questions' resource check and found my answer. I already contacted my hosting ;)
Sorry I took up yes even more space asking a question that has been asked before ;)

[Ajeh]

Let us know what you discover ... it is always helpful to have both question and solution on issues posted ...

[austy25]

well so far I have done a search on the web on it and people recommend setting up new databases this is one article I found HTH:
--------------------------------------------------------------------------------------
This topic has been fixed. Her problem was that her service provider puts a quota on a SQL database user of 50,000 querries per hour max. Well everybody knows that Nuke with many active users can double that number so the site was shutting everything down when they hit their quota for an hour. Her service provider refused to bump the quota and actually told her to purchace a dedicated server which is BS!

I fixed this problem by creating 3 DB users and gave them all permissions to the nuke database. All 3 had the same password. Then went to config.php and made these modifications:
Code:

//$dbuname = "********1"; //Old DB UserName Access
$db_user_array[] = "********1"; //1st user name
$db_user_array[] = "********2"; //2nd user name
$db_user_array[] = "********3"; //3rd user name
$dbuname = $db_user_array[ rand( 0, ( sizeof($db_user_array) -1 ) ) ];

This allowed nuke to swap between 3 different users so that the 50,000 limit quota would be evenly distributed throught 3 users making her quota 150,000.
--------------------------------------------------------------------------------
Like I said hope that helps someone else as well :)

[austy25]

Here I found an even better one that was posted by Dr.Byte: Thanks Doc.:)

http://www.zen-cart.com/forum/showthread.php?t=24089

GL to all with this problem :)