mythbuntu-bugs team mailing list archive

[Jose Juan Iglesias Rebollo <jjiglesias@xxxxxxxxxxxxxxx>]

Hi again!

I've been debugging this issue myself and I think I've found the cause.

The real problem of this bug is that MythGame settings do not exist in
the database, in 'settings' table. Then those settings cannot be read
nor written.

The package of mythtv in Mythbuntu has an SQL file in the debian folder:
mythtv_0.27.0.sql. The execution of this file seems to create and fill
the settings table, but its code doesn't seem to initialize any MythGame
setting.

Then, in short, debian/mythtv_0.27.0.sql LACKS MythGame settings
initialization.

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