Bug 101208

Summary:	Bug in Left Panel when using MySQL Frontend
Product:	[Applications] amarok	Reporter:	Alexandre Maciel <digitalman>
Component:	general	Assignee:	Amarok Developers <amarok-bugs-dist>
Status:	RESOLVED FIXED
Severity:	normal
Priority:	NOR
Version:	1.2.1
Target Milestone:	---
Platform:	Debian testing
OS:	Linux
Latest Commit:		Version Fixed In:
Attachments:	Screenshot Showing the 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,";