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