[prev in list] [next in list] [prev in thread] [next in thread] 

List:       kde-bugs-dist
Subject:    [Bug 89247] New: Filesongs with containing ' make amaroK crash
From:       Jean-Michel Fayard <jmfayard () gmail ! com>
Date:       2004-09-10 14:44:31
Message-ID: 20040910164428.89247.jmfayard () gmail ! com
[Download RAW message or body]

------- 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()]


[prev in list] [next in list] [prev in thread] [next in thread]