Correction: One mythtv setting does get initialized: GameDBSchemaVer. Regards.
-- You received this bug notification because you are a member of Mythbuntu Bug Team, which is subscribed to Mythbuntu. https://bugs.launchpad.net/bugs/1354893 Title: Mythgame doesn't show Favorites Status in Mythbuntu, Ubuntu derivative focused upon MythTV: New Bug description: Hi! I run mythtv version 2:0.27.3+fixes.20140809.6788ea9-0ubuntu0mythbuntu2. After marking a few games as favorite, Favorites menu option doesn't display any. I've traced this issue to the file mythgame/gameui.cpp. I've added a couple of LOGs to the code. Here's a piece of the output of mythfrontend: 2014-08-10 12:57:27.302221 I gameui.cpp: Favorite levels: 2014-08-10 12:57:27.334470 I gameui.cpp: SQL Query: select distinct ,system,year,genre,gamename from gamemetadata where system in ('MAME') and favorite=1 and display = 1 order by ; 2014-08-10 12:57:27.334971 E Error preparing query: select distinct ,system,year,genre,gamename from gamemetadata where system in ('MAME') and favorite=1 and display = 1 order by ; 2014-08-10 12:57:27.335011 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 'system,year,genre,gamename from gamemetadata where system in ('MAME') and favori' at line 1 "Favorite levels" is the content of the variable "levels" in this piece of code, from gameui.cpp, and it gets no value at all: QString levels = gCoreContext->GetSetting("GameFavTreeLevels"); If really "GameFavTreeLevels" refers to the setting "Favorite display order" in "MythGame Settings -- General" as it seems, which is set to the value "gamename" (I don't remember whether I changed it or not); then the connection between this setting and the piece of code above is lost somehow. To manage notifications about this bug go to: https://bugs.launchpad.net/mythbuntu/+bug/1354893/+subscriptions _______________________________________________ Mailing list: https://launchpad.net/~mythbuntu-bugs Post to : mythbuntu-bugs@lists.launchpad.net Unsubscribe : https://launchpad.net/~mythbuntu-bugs More help : https://help.launchpad.net/ListHelp
