SQL Error : 1226

Sit Back, Relax and Chat about Anything
Post Reply
User avatar
Lawndart
Virtual Thunderbird
Posts: 9292
Joined: Tue Mar 29, 2005 8:36 am
Location: Mooresville, NC

SQL Error : 1226

Post by Lawndart » Sun Aug 13, 2006 4:17 pm

As I'm sure may of you are aware of the following has popped up when trying to access these forums recently:

Code: Select all

Could not query forums information

DEBUG MODE

SQL Error : 1226 User 'virtualt_forum' has exceeded the 'max_questions' resource (current value: 50000)

SELECT f.*, p.post_time, p.post_username, u.username, u.user_id FROM (( phpbb_forums f LEFT JOIN phpbb_posts p ON p.post_id = f.forum_last_post_id ) LEFT JOIN phpbb_users u ON u.user_id = p.poster_id ) ORDER BY f.cat_id, f.forum_order

Line : 167
File : index.php
This is a database error caused by the shared host these forums reside on and not due to anything directly in our control. A manual reset of the forum_user database is required when it happens and while we cannot change the providers max limit for 'questions' (queries to the database while browsing the forums, i.e. each page the loads may cause 5-10 'questions') and the max limit of 50000 is per hour) we can reset this count should it happen. Unfortunately, this is out of our control as far as the limit goes and if you search other internet forums for "SQL Error: 1226" you'll see that it's quite common. Why the webhosts insists on having a low limit to not overload the database, I don't know, but there's nothing we can do to change that except acquire a professional dedicated webhost box. At the present that won't happen.

If you see any more errors (once this one is fixed), please email me through the contact page. Thank you for your understanding and patience.
Post Reply