Help! whos_online Crashed my Database

[minuteman1970]

My live shop has been working fine for 2+ years. Suddenly today, it crashed and shows the following error:

 

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

 

delete from whos_online where time_last_click < '1207350209'

 

[TEP STOP]

 

 

I am running OSc 2.2, and do have the Who's Online v1.9 contribution installed. Another member suggested I remove all the rows in the 'whos_online' table, which I did. I also ran the 'repair' option for the table in PHPMyadmin. However, this did not help. Could this be some sort of issue on my hosting company's side?

Thanks in advance.

[Jan Zonjee]

My live shop has been working fine for 2+ years. Suddenly today, it crashed and shows the following error:

 

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

 

delete from whos_online where time_last_click < '1207350209'

 

[TEP STOP]

I am running OSc 2.2, and do have the Who's Online v1.9 contribution installed. Another member suggested I remove all the rows in the 'whos_online' table, which I did. I also ran the 'repair' option for the table in PHPMyadmin. However, this did not help. Could this be some sort of issue on my hosting company's side?

Thanks in advance.

It means they set a maximum to the number of sql queries per hour your site can make. After that maximum number you get the 1226 error. Within the hour things should be working again.

 

Either you ask your hosting company for a higher number (they will likely want some monetary compensation for that) or you add contributions to reduce the number of queries. A Store Speed Optimization in Progress, Step by step from a vanilla install! is a good starting point.