[mythtv-users] SQL errors from mythgame

Christopher X. Candreva chris at westnet.com
Fri Nov 19 04:26:52 UTC 2010


I happened to run Mythfrontend 0.24 from the command line, and noticed the 
following SQL errors when I went in to mysqlgame:


2010-11-18 23:19:42.086 Using protocol version 63
2010-11-18 23:19:44.690 Error preparing query: select distinct ,system,year,genre,gamename from gamemetadata where system in ('Arcade Games','Linux Games') and favorite=1 and  display = 1  order by ;
2010-11-18 23:19:44.691 Driver error was [2/1064]:
QMYSQL3: Unable to prepare statement
Database error was:
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 'system,year,genre,gamename from gamemetadata where system in ('Arcade Games','Li' at line 1

2010-11-18 23:19:46.111 Error preparing query: select distinct ,system,year,genre,gamename from gamemetadata where system in ('Arcade Games','Linux Games') and  display = 1  order by ;
2010-11-18 23:19:46.111 Driver error was [2/1064]:
QMYSQL3: Unable to prepare statement
Database error was:
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 'system,year,genre,gamename from gamemetadata where system in ('Arcade Games','Li' at line 1




==========================================================
Chris Candreva  -- chris at westnet.com -- (914) 948-3162
WestNet Internet Services of Westchester
http://www.westnet.com/


More information about the mythtv-users mailing list