[mythtv] New MythGame not populating rom database
harywilke at yahoo.com
Thu Jul 7 17:42:13 EDT 2005
On Jul 7, 2005, at 10:22 PM, Greg Estabrooks wrote:
> I think the problem here is because for some reason your
> gamemetadata table didn't get updated when db check created
> the gameplayers table. Two new fields are added to gamemetadata
> in the exact same piece of code and for some reason it doesn't
> look like they happened.
> Can you let me know the results of this SQL query:
> select * from settings where value = "GameDBSchemaVer";
> It should be set to 1005, which is the version set after the
> gamemetadata table gets udpated and the gameplayers table created.
> I just tried it on a fresh one here and it made the alterations
> You can make the changes manually with the following:
> ALTER TABLE gamemetadata ADD COLUMN rompath varchar(255) NOT NULL
> default '';
> ALTER TABLE gamemetadata ADD COLUMN gametype varchar(64) NOT NULL
> default '';
Ok good news it loads the rom titles into the database after adding
those two columns.
I don't know why i didn't get those two columns earlier. My
GameDBSchemaVer is 1005, I even vaguely remember seeing it get
upgraded. strange, but fixed now. thanks
>> another thing i noticed on the mac version, when scanning for games
>> the progress bar comes up with osme text above it that tells you what
>> type of roms are currently being scanned. I don't see this text on my
> This should show up on all systems. There is nothing in the
> code that would cause it to not show.
hrm. don't know why it doesn't show up for me on my linux box. not
critical by any means though.
>> FC3 system. I get the progress bar which sticks at %50,
> The 50% is currently hardcoded :)
>> a full screen redraw), then finishes. and both versions take a few
> It actually flickers? Odd since nothing is drawn to the
> screen at all during the scan. At the moment it's not even
> incrementing the progress bar.
ok i should have been more clear. Now that i've given it a more
critical eye I realize I am seeing the progress bar box area being
redrawn between scans of different rom directorys. I noticed it
because i put in two mame game types and it scanned the mame rom
directory twice. I have a lot of roms, so it was sitting at %50, then
blinked off revealing the background, then back on to %50 again.
hence the apparent flicker. I don't think there is anything wrong
with this. i was just grabbing at straws when the database thing
>> seconds to switch after you select Games Settings button on the Media
>> Settings page. Much longer than say changing from the Setup page to
>> the Media Settings Page. I'm not sure why this is.
> Happens almost instantly here. Is it slow only the first
> time? Can you go out and back in and it happen faster the
> second time?
It's consistatly at about 6 seconds on my dual P3 1Ghz. I know it's
no workhorse, but it seems weird for it to take so long to switch
into mythgame's setup. switching into the play games screen doesn't
take this long.
Now that i've got the games all loaded in, i notice that the Genre
and Year information that was being added before by catver.ini is no
longer being applied to the listings in the Play Games window. is
there a way to work this back in? It is very useful. What might also
be nice, is to be able to edit the metadata of individual roms for
systems that don't have a catver.ini type file. That way it would be
possible to assign genre's and years to all your roms. egads! that's
a daunting task. You could use the genre's in cavtver.ini as a
starting point. If you do plan on some way of editing the info of
individual roms, it would be nice if there was a little 'I' logo on
the screen. so people would know that there is a way to get info on a
title. or 'E' for edit.
thanks a ton.
More information about the mythtv-dev