Mysql Error: Needs To Be Fixed Asap

after uploading a file with passcodes every page within the admin area and any active gallery page is getting the following error

MYSQL ERROR: User 'sytist111621' has exceeded the 'max_questions' resource (current value: 150000)

Query: SELECT * FROM ms_settings

How can this be resolved? and why is this happening

Edited by

It is a database query limit. I have only seen a couple of hosts with a database query limit which is really low because there can be a lot of queries happening.

Ask your host to remove or increase the MySQL max_questions.

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

Download and edit the sy-config.php file in a text editor like notepad from your Sytist installation folder or open it in the file manager in your hosting control panel.

In your hosting control panel go into the MySQL section and create 3 new MySQL users (or more) 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']).

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

Tim, thanks for the quick reply. I did contact my host and we have it resolved. I will be sure to ask them to remove or increase the MySQL max_questions.

thanks again

Edited by