mythbuntu-bugs team mailing list archive

[Thomas Mashos <1354893@xxxxxxxxxxxxxxxxxx>]

We really do appreciate you opening this ticket to help improve
Mythbuntu, but it needs to be closed for a number of reasons. The
biggest one is that upstream has moved on to a new version and believes
this to be fixed. Could you please verify if this issue still exists in
the latest version?

Please do not let the closing of this ticket dissuade you from opening a
new ticket if this (or any other) problem occurs with the newer
versions.

** Changed in: mythbuntu
       Status: New => Expired

-- 
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:
  Expired

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