mythbuntu-bugs team mailing list archive

[Jose Juan Iglesias Rebollo <jjiglesias@xxxxxxxxxxxxxxx>]

Public bug reported:

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.

** Affects: mythbuntu
     Importance: Undecided
         Status: New

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