The Sonic Center

Welcome Center => Beef => Topic started by: Shadowfan on November 29, 2011, 05:39:10 pm

Title: TSC error
Post by: Shadowfan on November 29, 2011, 05:39:10 pm
TSC Fatal Error

Each time I try to submit something, I can select the charts and then update the stats, however, upon hitting the confirm button, it takes me to the tsc death page.

Query Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND e.category IN () AND e.creation='SUBMIT' GROUP BY e.class ORDER BY l.level_o' at line 1: SELECT e.*, l.*, d.*, cn.*, MAX(s.stat_date), s.value, t.comment FROM classes AS e LEFT JOIN levels AS l ON l.level = e.level LEFT JOIN divisions AS d ON d.division = e.division LEFT JOIN catnames AS cn ON cn.category = e.category AND cn.site = 1 LEFT JOIN stats_current AS s ON s.class = e.class AND s.player = 2181 AND s.stat_status = 'CURRENT' LEFT JOIN stats_comments AS t ON s.stat = t.stat WHERE e.game = AND e.category IN () AND e.creation='SUBMIT' GROUP BY e.class ORDER BY l.level_order, d.division_order

Please report the above error to The Sonic Center staff. Include the URL where the error occured as well as what you did to get the error.