TSC error


Author Topic: TSC error  (Read 2224 times)

0 Members and 1 Guest are viewing this topic.

Offline Shadowfan

TSC error
« 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.


Hits: 489 | Hits This Month: 8 | DB Calls: 8 | Mem Usage: 6.63 MB | Time: 0.10s | Printable

The Sonic Center v3.9
Copyright 2003-2011 by The Sonic Center Team.