[chuggles]

Can anyone help me fix what's going on with my site?

http://www.marksmotos.com

This is the error message:

Notice: Query failed: User 'marksmot' has exceeded the 'max_questions' resource (current value: 50000) SQL: SELECT COUNT(*) AS size FROM class_products WHERE section In (44) AND expiration > NOW() AND (display='Y' OR display='S') in /home/marksmot/public_html/includes/classes/database/mysql.php on line 135

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/marksmot/public_html/includes/classes/database/mysql.php on line 194

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/marksmot/public_html/includes/classes/database/mysql.php on line 217



It just popped up with this warning and I have never seen this before. Any ideas?

Thanks,

~Adam

[suzkaw]

Do you have access to phpmyadmin? Can you try running a repair on all the tables and see if that sorts it?

[chuggles]

I went into the hosting provider control panel and clicked repair on the database. It is still giving me tons of warnings. I did call the hosting provider and they said everything was good on their part. They did mention that there was no database username. So I put one in.

It is not allowing me to go in the classifieds admin as well. Any suggestions to point me in a direction?

[suzkaw]

I believe you need to click repair on the individual tables and not the whole database. Also while you are in there do a check, repair, and optimize.

From searching google I see a lot of people with the same issue and from what I have read doing this will fix the error.

[Lhotch]

Chuggles, max_questions is a setting that some hosts use to limit the number of queries that can be made to a database in a given time frame. If your host imposes a limit like that I highly recommend you find yourself a new host. They allready limit disk space and bandwidth its totally unreasonable for them to limit the queries to the data base as well.

This is something I recommend every ask their host before using them. Most hosts will not volunteer that the limit max_questions so you need to ask and if they do, then find a new host.