Our site www.viart.com site is operated by latest Viart Shop 5 with default Clear design
Topic Information
Dewey
Dewey
User 'a8657832_online' has exceeded the 'max_questions' resource (current value: 22000)
 
i am now getting this error on a new install on a different server with the lastest version of viart. any idea on this? i entered my info into the database area and hit next and got lots of these going down the page. can someone please inform me what and why please. Thank you
 
dmOZ
dmOZ
Dont know if you found your answer but its a MySQL DB security config.
 
Do a google search for "mysql max_questions"
 
Here is a reference from the MySQL
http://dev.mysql.com/doc/refman/5.0/en/user-resources.html
 
from the 'User' part of your original question, looks like you are on a hosted environment. So you might want to talk to your hosting provider.
 
It may be that they have a long 'session/connection' timeout for the db connection and so they are not being released when you make the next call to the DB or slow query execution causing queries to be take a long time to execute.
 
Either way its a hosting issue.
 
The install script executes individual SQL queries for each line in the db/mysql_db.sql fie
 
You could try the setup and with "persistant connection" both selected and cleared and see if that helps.
 
Dewey
Dewey
my provider only allows 40000 connections per hour (so they say). but yet when i try and run it again on a different database, it fails, i can go im and still make a few oddball things work if i put the info for the database into the file and that. but it is missing so much stuff that its not funny. i asked them about changing it and they wont. im not happy about it.
i did not do the persistant to see if that will change or not. i dont have the test site setup yet, so i will try it. but support here made it sound like that wont work either. i took a backup of a db from another person i am doing a site for (their hosting allows all this) and put it all in by hand in phpmyadmin. so i have it working atleast. just can not do any dumps. kinda disappointed with my hosting. i will be moving for sure.
Last modified: 28 Oct 2014 5:12 AM
 
Dewey
Dewey
dmOZ, it did the same thing. this tells me my host just stops it no matter what. thats fine. i will do what i did to get the database setup and working and finish what i got to do to it and then get changed to a different host.
 
dmOZ
dmOZ
Its is also possible that the PHP process and web session is timing out or being disconnected.
 
Check what server version you are running on - Apache and MySQL
Also check if they are running some proxy service (eg NGINX) as well.
 
In viart you could also turn on DB query logging - maybe ask Viart for help on that
 
Dewey
Dewey
It was my host. They are limiting how many connections to the db. Sucks but thats what happens with free testing areas. Thats all i am using this host for.