------- You are receiving this mail because: -------
You are on the CC list for the bug, or are watching someone who is.
        
http://bugs.kde.org/show_bug.cgi?id=89247        
           Summary: Filesongs with containing ' make amaroK crash
           Product: amarok
           Version: unspecified
          Platform: Mandrake RPMs
        OS/Version: Linux
            Status: UNCONFIRMED
          Severity: crash
          Priority: NOR
         Component: general
        AssignedTo: amarok-bugs-dist lists sourceforge net
        ReportedBy: jmfayard gmail com


Version:           CVS snapshot (using KDE KDE 3.2.3)
Installed from:    Mandrake RPMs
OS:                Linux

I have an file named '/mppp/Renaud/Boucan D'Enfer'
This fools the SQL statements and make amaroK crash.

Debug :
amarok: [Gst-Engine] Loading url: file:/mppp/Renaud/Boucan%20D%27Enfer/Docteur%20Renaud,%20Mister%20Renaud.mp3
amarok: [InputPipeline::InputPipeline()]
amarok: [virtual bool GstEngine::play(uint)]
amarok: [static void GstEngine::error_cb(GstElement*, GstElement*, GError*, gchar*, void*)]
amarok: [CollectionDB] SQL-query (0.1s): SELECT album.name, artist.name, datetime( datetime( statistics.createdate, 'unixepoch' ), 'localtime' ), datetime( datetime( statistics.accessdate, 'unixepoch' ), 'localtime' ), statistics.playcounter, round( statistics.percentage + 0.5 ) FROM album, tags, artist, statistics WHERE album.id = tags.album AND artist.id = tags.artist AND statistics.url = tags.url AND tags.url = '/mppp/Renaud/Boucan D''Enfer/Docteur Renaud, Mister Renaud.mp3';
amarok: [CollectionDB] SQL-query (0.1s): SELECT album.name, artist.name FROM album, tags, artist WHERE album.id = tags.album AND artist.id = tags.artist AND tags.url = '/mppp/Renaud/Boucan D''Enfer/Docteur Renaud, Mister Renaud.mp3';
amarok: ERROR: [bool CollectionDB::execSql(const QString&, QStringList*, QStringList*, bool)] [CollectionDB] sqlite3_compile error:
amarok: ERROR: near "Enfer": syntax error
amarok: ERROR: on query: SELECT DISTINCT artist, album FROM tags WHERE dir = '/mppp/Renaud/Boucan D'Enfer'
ASSERT: "i <= nodes" in /usr/lib/qt3//include/qvaluelist.h (372)
QImage::smoothScale: Image is a null image
amarok: [CollectionDB] SQL-query (0.05s): SELECT tags.title, tags.url, round( statistics.percentage + 0.5 ) FROM tags, artist, statistics WHERE tags.artist = artist.id AND artist.name LIKE 'Renaud' AND statistics.url = tags.url ORDER BY statistics.percentage DESC LIMIT 0,5;
amarok: [CollectionDB] SQL-query (0.07s): SELECT tags.title, tags.url, tags.track FROM tags, artist, album WHERE tags.album = album.id AND album.name LIKE 'Boucan D''Enfer' AND tags.artist = artist.id AND ( tags.sampler = 1 OR artist.name LIKE 'Renaud' ) ORDER BY tags.track;
amarok: [CollectionDB] SQL-query (0.13s): SELECT DISTINCT album.name, artist.name, album.id, artist.id FROM album, tags, artist WHERE album.id = tags.album AND tags.artist = artist.id AND album.name <> '' AND artist.name LIKE 'Renaud' ORDER BY album.name;
amarok: ERROR: [bool CollectionDB::execSql(const QString&, QStringList*, QStringList*, bool)] [CollectionDB] sqlite3_compile error:
amarok: ERROR: near "Enfer": syntax error
amarok: ERROR: on query: SELECT DISTINCT artist, album FROM tags WHERE dir = '/mppp/Renaud/Boucan D'Enfer'
ASSERT: "i <= nodes" in /usr/lib/qt3//include/qvaluelist.h (372)
QImage::smoothScale: Image is a null image
amarok: ERROR: [bool CollectionDB::execSql(const QString&, QStringList*, QStringList*, bool)] [CollectionDB] sqlite3_compile error:
amarok: ERROR: near "Enfer": syntax error
amarok: ERROR: on query: SELECT DISTINCT artist, album FROM tags WHERE dir = '/mppp/Renaud/Boucan D'Enfer'
ASSERT: "i <= nodes" in /usr/lib/qt3//include/qvaluelist.h (372)
QImage::smoothScale: Image is a null image
amarok: [void GstEngine::destroyPipeline()]
amarok: BEGIN [InputPipeline::~InputPipeline()]
amarok: Unreffing input bin.
amarok: END [InputPipeline::~InputPipeline()]