stdin

stdin.txt

2013-04-08 17:56:38.415814 I  Beginning Game Scan.
2013-04-08 17:57:03.367739 I  MythCoreContext: Connecting to backend server: 192.168.0.104:6543 (try 1 of 1)
2013-04-08 17:57:03.368616 I  Using protocol version 75
2013-04-08 17:57:03.370786 I  Received remote 'Clear Cache' request
2013-04-08 17:57:18.116469 I  Received remote 'Clear Cache' request
2013-04-08 17:57:31.347190 I  Received remote 'Clear Cache' request
2013-04-08 17:58:05.418343 I  MythGame:GAMEHANDLER: Found ROM : (Mupen64plus) - Mario Kart 64.v64
2013-04-08 17:58:05.420095 E  MythGame:GAMEHANDLER: No romDB data read from database for gametype N64 . Not imported?
2013-04-08 17:58:06.344640 E  MythGame:GAMEHANDLER: NO ROMDB FOUND for /mnt/data/mythtv/games/emulators/n64/roms/Mario Kart 64.v64 (98bd4147)
2013-04-08 17:58:06.345986 E  Original query failed, but resend with empty strings in place of NULL strings worked. 
DB Error (MSqlQuery):
Query was:
INSERT INTO gamemetadata (system, romname, gamename, genre, year, gametype, rompath, country, crc_value, diskcount, display, plot, publisher, version, fanart, boxart, screenshot) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, '1', '1', ?, ?, ?, ?, ?, ?)
Bindings were:
:BOXART=NULL, :COUNTRY="Unbekannt", :CRC32="98bd4147", :FANART=NULL,
:GAMENAME="Mario Kart 64", :GAMETYPE="N64", :GENRE="Unbekannt N64",
:PLOT="Unbekannt", :PUBLISHER="Unbekannt", :ROMNAME="Mario Kart 64.v64",
:ROMPATH="/mnt/data/mythtv/games/emulators/n64/roms", :SCREENSHOT=NULL,
:SYSTEM="Mupen64plus", :VERSION="0", :YEAR="19xx"
Driver error was [2/1048]:
QMYSQL3: Unable to execute statement
Database error was:
Column 'fanart' cannot be null
2013-04-08 17:58:06.611280 N  MythGame:GAMEHANDLER: Update gametype N64



2013-04-08 18:22:13.309406 E  Error preparing query: select distinct  from gamemetadata where system in ('Mupen64plus') and trim(system)=:SYSTEM and  display = 1  order by ;
2013-04-08 18:22:13.309423 E  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 'from gamemetadata where system in ('Mupen64plus') and trim(system)=? and  displa' at line 1

2013-04-08 18:22:16.141371 E  Error preparing query: select distinct  from gamemetadata where system in ('Mupen64plus') and trim(system)=:SYSTEM and  display = 1  order by ;
2013-04-08 18:22:16.141389 E  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 'from gamemetadata where system in ('Mupen64plus') and trim(system)=? and  displa' at line 1