[mythtv-users] games not scanning

[David Campbell]

Tom Weichmann wrote:
> Thanks, I tried to view games as if to choose one to play (but like I said 
> there is nothing in the list) and this is all I got fromthe console:
> 
> 2007-03-22 19:29:27.616 XMLParse::LoadTheme 
> using /usr/share/mythtv/themes/default/game-ui.xml
> 
> So then I went into setup to scan for games looks like they have been found:
> 
> Found Rom : (Zsnes)  - Beavis and Butthead.smc
> Found Rom : (Zsnes)  - California Games II.smc
> Found Rom : (Zsnes)  - Castlevania - Vampire's Kiss.smc
> Found Rom : (Zsnes)  - Der Langrisser.smc
> Found Rom : (Zsnes)  - Drift King - Shutokou Battle 2.smc
> Found Rom : (Zsnes)  - ESPN Sunday Night NFL.smc
> Found Rom : (Zsnes)  - F-1 Grand Prix Part III.smc
> Found Rom : (Zsnes)  - F-Zero.smc
> Found Rom : (Zsnes)  - GT Racing.smc
> Found Rom : (Zsnes)  - Jeopardy! Deluxe Edition.smc
> Found Rom : (Zsnes)  - La Wares.smc
> Found Rom : (Zsnes)  - Lamborghini - American Challenge (E) [!].smc
> Found Rom : (Zsnes)  - Madden NFL '98.smc
> Found Rom : (Zsnes)  - Mortal Kombat 3.smc
> Found Rom : (Zsnes)  - Super Metroid.smc
> Found Rom : (Zsnes)  - Super Punch-Out!! (U).smc
> 
> I tried again to play a game and again got an empty list and the following 
> error:
> 
> 2007-03-22 19:35:14.516 XMLParse::LoadTheme 
> using /usr/share/mythtv/themes/default/game-ui.xml
> 
> 
> 
> OK, so I went back into settings and went to clear data and then re-imported.  
> Here is what I got:
> 
> No romDB data read from database. Not imported?
> 2007-03-22 19:37:34.082 New DB connection, total: 3
> 2007-03-22 19:37:34.091 Connected to database 'mythconverg' at host: localhost
> Update gametype SNES
> 
> 
> Any idea what is going on?
> 

can you connect to mysql and use the mythconverg database

then run

mysql> select playername, rompath, commandline, gametype from 
gameplayers where playername ='SNES';

Make sure the data looks like you might expect

Then run

mysql> select system, romname from gamemetadata where system = 'SNES' 
limit 10;

to see what is actually there

Dave