Bug 101208 - Bug in Left Panel when using MySQL Frontend
Summary: Bug in Left Panel when using MySQL Frontend
Status: RESOLVED FIXED
Alias: None
Product: amarok
Classification: Applications
Component: general (show other bugs)
Version: 1.2.1
Platform: Debian testing Linux
: NOR normal
Target Milestone: ---
Assignee: Amarok Developers
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2005-03-10 00:42 UTC by Alexandre Maciel
Modified: 2006-06-11 12:32 UTC (History)
0 users

See Also:
Latest Commit:
Version Fixed In:


Attachments
Screenshot Showing the Bug (34.48 KB, image/jpeg)
2005-03-10 01:05 UTC, Alexandre Maciel
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Alexandre Maciel 2005-03-10 00:42:50 UTC
Version:           1.2.1 (using KDE KDE 3.3.2)
Installed from:    Debian testing/unstable Packages
OS:                Linux

Well, when I exchange frontend from SQLite to MySQL, I noticied a little bug in left panel, Current Track option. When I open album in Artists's Album, if my file don't have a track number information, Amarok shows the track as '00', insted of hide this information like SQLite behavior. 

I will try to attach a screenshot showing the bug.
Comment 1 Alexandre Maciel 2005-03-10 01:05:15 UTC
Created attachment 10051 [details]
Screenshot Showing the Bug
Comment 2 Alexandre Oliveira 2005-03-10 04:30:32 UTC
CVS commit by aoliveira: 
 
Track is set as a number in the database, so shouldn't be added 
rounded by quotes. Fixes 101208 (after you rescan your collection).
BUG: 101208
CCMAIL: amarok-devel@lists.sf.net
 
 
  M +2 -2      collectiondb.cpp   1.314
 
 
--- kdeextragear-1/amarok/src/collectiondb.cpp  #1.313:1.314
@@ -1032,6 +1032,6 @@ CollectionDB::addSong( MetaBundle* bundl
 
     command += escapeString( bundle->title() ) + "','";
-    command += escapeString( bundle->comment() ) + "','";
-    command += escapeString( bundle->track() ) + "', ";
+    command += escapeString( bundle->comment() ) + "', ";
+    command += ( bundle->track().isEmpty() ? "NULL" : 
escapeString( bundle->track() ) ) + " , ";
     command += artist == i18n( "Various Artists" ) ? "1," : "0,";