metadata in mythgame

[anonymous]

I have added the romdb to the sqldatabase but when I scan for games I still get unknown year and genre. Have asked at the irc channel but nobody seems to be able and solve it, so it may be a bug. I use Axels rpm. Don't know what more to write or add so if you need any more data just say it!!

[greg]

I'm just in the process of rebuilding my development environment, so I'll take a look at this one soon.

[anonymous]

Yes, I noticed this too and tracked it down to gamehandler.cpp. The fix is to delete the trailing space in the SELECT statement in InitMetaData?() (just after the semicolon and before the closing double quote). Change this:

QString thequery = QString("SELECT crc, category, year, country, name, " "description, publisher, platform, version, " "binfile FROM romdb WHERE platform = \"%1\"; ") .arg(GameType);

To this:

QString thequery = QString("SELECT crc, category, year, country, name, " "description, publisher, platform, version, " "binfile FROM romdb WHERE platform = \"%1\";") .arg(GameType);

[greg]

(In [9931])

Closes #1359

I couldn't reproduce this problem, but it could very well be QT/MySQL

version specific. I've made this tiny change since it wont adversely anyone not seeing this and might fix it for others.