Emergency Please Help!

[Guest]

I was changing things around and adding products to my oscommerce and I went to change a category name on the admin page. Once I completed renaming the category I received this error message:

 

1226 - User 'imprezat_p_os1' has exceeded the 'max_questions' resource (current value: 50000)

 

delete from whos_online where time_last_click < '1161412937'

 

[TEP STOP]

 

What does that mean? Neither I nor customers can go to my store and make purchases. What happened, more than that, what can I do to fix it? Please someone help me.

 

Thank you

 

Jared

[digbydo]

:angry: did you just rush in here or did you try searching the board first?

 

if it was the second I'm rather surprised you didn't find your answer :(

 

http://www.oscommerce.com/forums/index.php?act...ions%26%2339%3B

[SonicDepot]

I was changing things around and adding products to my oscommerce and I went to change a category name on the admin page. Once I completed renaming the category I received this error message:

 

1226 - User 'imprezat_p_os1' has exceeded the 'max_questions' resource (current value: 50000)

 

delete from whos_online where time_last_click < '1161412937'

 

[TEP STOP]

 

What does that mean? Neither I nor customers can go to my store and make purchases. What happened, more than that, what can I do to fix it? Please someone help me.

 

Thank you

 

Jared

 

Anyway, to answer your question:

 

Hey,

 

Here is what appears to be a better fix that I just came up with (ok, I kinda stole the idea from espicom at http: //www. phpbb. com/kb/article. php?article_id=371&sid=a5547fbab7cfe9082dd13b9e0a99dd69, but I had to modify it to match up to the osC coding):

 

 

In your database setup panel, add 2 more users and use the same password for them as for your first one. Make sure that when you create your new database usernames, that you give them accessibility to the proper database.

 

Now go to your file manager, and edit ..catalog/includes/configure.php. This is where all of your database login info is stored.

 

*** FYI in this example, name1 is your database username. So in the case of wrxtuner44, you would replace name1 with "imprezat_p_os1". name2, name3, etc are the respective new usernames that you have just created. ***

 

In the area of line 40 you should find the following code:

 

define('DB_SERVER_USERNAME', 'name1');

 

Replace that with:

 

$username = date("i") % 3; // split hour into 3 overlapping sessions

switch ($username)

{

case 0:

$username='name1';

break;

case 1:

$username='name2';

break;

case 2:

$username='name3';

break;

}

define('DB_SERVER_USERNAME', $username);

 

 

essentially what you have just done is made it so that your "current value" of 50000 is now 150000 (50000 per username). If you still need more, just add more usernames to your database, change the "% 3" in the first line to 4, 5, etc... how ever many you now have, and add more case statements with the new names.

 

P.S. I haven't fully tested this for bugs, but it seems to work quite well. Maybe some of you with more coding experience can double check me?

[ptouch]

Help this happene to me too! and i am a newbie and can't figure this out, i'm new to using myphpadmin too

 

how do i add two users in my database set up panel?

[ptouch]

okay i did what sonic depot said to do but now i get this error on my store

 

Warning: mysql_connect(): Access denied for user: 'breakgir1@localhost' (Using password: YES) in /home/breakgir/public_html/store/includes/functions/database.php on line 19

Unable to connect to database server!