[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]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic