SQL error on Roster page

Requests, feedback, and general discussion about WoWRoster
DO NOT post topics about WoWRoster AddOns here!

SQL error on Roster page

Postby Dracoking007 » Thu Mar 08, 2007 1:50 pm

Found an error this morning on my roster page.

Database Error
1226: User 'ahordeda_roster' has exceeded the 'max_questions' resource (current value: 50000)
SQL:
SELECT IF(`note` LIKE '%ALT%',1,0) AS 'isalt', FLOOR(`level`/10) AS levelgroup, COUNT(`level`) AS amount, SUM(`level`) AS sum FROM `roster_members` GROUP BY isalt, levelgroup ORDER BY isalt ASC, levelgroup DESC
File: menu.php
Line: 55

Had a problem over the last couple of days were the whole guilds data got wiped. We were just in the process of rebuilding it when this occured.

Any ideas?

Website found here

Thanks in advance....
Dracoking007
WR.net Apprentice
WR.net Apprentice
 
Posts: 9
Joined: Thu Jul 06, 2006 11:04 pm

SQL error on Roster page

Postby ScratchMonkey » Fri Mar 09, 2007 3:27 am

http://drupal.org/node/38996

Found with this google:

http://www.google.com/search?num=100&hl ... tnG=Search

Looks like you're hammering your DB server with too many queries per hour. Your limit is set to 50000 per DB user ('ahordeda_roster') per hour.
User avatar
ScratchMonkey
WR.net Expert
WR.net Expert
 
Posts: 212
Joined: Wed Jul 05, 2006 4:32 pm
Location: San Pablo, CA


Return to General Support & Feedback

Who is online

Users browsing this forum: No registered users and 1 guest

cron