[mythtv-users] MythGame mame rom scanning problem

[Phil N. Bailey]

 Ryan,

I have the same issue, and no hair left from trying to find the issue.

What changes did you make and to what files?

Regards
Phil

-----Original Message-----
From: mythtv-users-bounces at mythtv.org
[mailto:mythtv-users-bounces at mythtv.org] On Behalf Of Ryan Nowakowski
Sent: Sunday, 20 June 2004 11:32 PM
To: mythtv-users at mythtv.org; mythtv-dev at mythtv.org
Subject: Re: [mythtv-users] MythGame mame rom scanning problem

Hrmmm.  It seams that mythgame was generating bad sql statements during
the mame rom scan.  This is from the mysql log:

103 Query       INSERT INTO gamemetadata
(system,romname,gamename,genre,year) VALUES ("Mame","nitd",""Nightmare
in the Dark","Platform^M",2000)

103 Query       INSERT INTO mamemetadata
(romname,manu,cloneof,romof,driver,cpu1,cpu2,cpu3,cpu4,sound1,sound2,sou
nd3,sound4,players,buttons,rom_path) VALUES ("nitd",""Eleven /
Gavaking","-","neogeo","neogeo","68000","-","-","-","YM2610","-","-","-"
,2,4, "/space/roms/mame")

Notice the inappropriate double quotes in front of the 'romname' and
'manu' values.  I've hacked the source to remove one of the double
quotes but it's a bad hack, just good enough to get it working in my
situation.
Here's my setup:

mythtv 0.15.1 (debian packages)
xmame 0.83

I hope this helps the developers.  I'd be glad to offer debugging
assistance.

- Ryan

On Sat, Jun 19, 2004 at 11:05:58PM -0500, Ryan Nowakowski wrote:
> I'm having problems with the mame rom scan.  After upgrading from 0.14

> to 0.15.1 (using the debian packages), no mame roms show up in the 
> game menu, even after a rescan.  I've tried different things such as 
> making sure my hiscores setting is correct, etc.  Any suggestions?