Max_questions Resource Error

I installed Sytist to a new host server recently and received an error message today regarding too many queries to the SQL database.

My host tells me this is an hourly limit which auto-resets; but I wanted to know if this is common for Sytist to run this many queries? I was working on the price list and a few uploads but I don't think I did 75,000 actions within an hour.

They of course want $20/month to upgrade (double) my query limit. Would you say that's worth my while? How many database queries are "normal"?

---
MYSQL ERROR: User 'sytist' has exceeded the 'max_questions' resource (current value: 75000)

Query: SELECT * FROM ms_settings
5:37:13 PM

Edited by

I have only seen a couple of hosts that have the limit this low with the MySQL queries. Yes there are a lot of queries taking place depending on many factors.

If the limit can not be removed, here is something to try.

In your hosting control panel go into the MySQL section and create 3 or 4 new MySQL users and give them the same password as the existing user. You can see that password in the sy-config.php file ($setup['pc_db_user']) which is located in the folder where Sytist is installed.

Assign those users to your Sytist database.

At the bottom of the sy-config.php file before the closing PHP tag ?> ... add these lines and enter in the existing database user and the 2 new ones.

$db_user_array[] = "user_name1"; //enter 1st user name
$db_user_array[] = "user_name2"; //enter 2nd user name
$db_user_array[] = "user_name3"; //enter 3rd user name

Save and re-upload. Doing this will select a random database user each connection and may help with how many questions per database user.

Edited by

I'll definitely give that a try; thanks for the idea, I will follow up with results.

For anyone doing research on the best hosting for Sytist, iPage is the host I'm using. They offer "unlimited" plans with "unlimited" SQL databases, but this query limit is not really in their promotional material so that's a relevant bit of info.

Edited by

Hi Tim, after several days we are still having this issue and I have maxed the accesses for 13 different user profiles (meaning we have nearly 900,000 hits in the space of an hour happening).

The message from my host is that the script needs to close the connection:

This error will be caused if a script is not closing the MySQL connection after accessing the database. I could see that you are using custom script. Therefore, I request you to please contact your webmaster and close all the Mysql connection using mysql_close() command or you have to purchase the Myslq query limit.

Can you help with this ... I am not skilled enough to know where that close command would need to go.

Edited by

I replied to your email about this. And the MySQL connections are being closed. Really have only seen this issue with iPage hosting.

Edited by

Thought I would post a follow-up since I was just messaged by another Sytist / iPage user with this issue. Tim's solution worked, although it is cumbersome and I found that 3 or 4 database users weren't enough - I needed about 10x that amount. To set it up, you have to modify a few things both in Sytist and on iPage.

iPage setup:

• Go to your Control Panel and click the "MySQL Database" link.


• Choose your database and click the little "Add new user" button


• Make up a set of usernames. They all should be different of course, I did "nl_user1" "nl_user2" "nl_user3" etc. up to about 35 users in total.

Sytist setup:

• In the Sytist admin, click "settings" in the menu bar (not the drop-down, just click it)


• At the bottom of the left sidebar, click the "Edit config file" link


• Follow Tim's instructions from above to enter the usernames in the config file.
  (Note that the text after // are just comments and not functioning code.)
  $db_user_array[] = "nl_user1";
  $db_user_array[] = "nl_user2";
  $db_user_array[] = "nl_user3"; etc.


• Hit 'save'

This seems to be working for me; my site isn't super busy so if you have a high number of users you might need to do more. (Or, get a better host that allows unlimited questions.)

Edited Wed May 30, 18 9:04 AM by Michael Leenheer