Public bug reported:
Binary package hint: amarok-kde4
On a upgraded/updated Ubuntu Intrepid using Gnome running Amarok from
terminal, i get a crash, i can't report crash dump, i have already
installed amarok (not kde4 release):
On the terminal window i see error on sql:
amarok: [ERROR!] on query: "REPLACE INTO
tracks_temp(url,artist,album,genre,composer,year,title,comment,tracknumber,discnumber,bitrate,length,samplerate,filesize,filetype,bpm,createdate,modifydate)
VALUES ( 230,230,230,2,1,11,'Thunderball','Encoded by
GuitarMan',0,0,128,180,44100,2883712,0,0,0,0);"
KCrash: Application 'amarok' crashing...
After first crash i restart amarok from terminal so i can see errors and other
it run and start... i see:
Couldn't resolve property: radialGradient3986
amarok: keys ()
amarok: [ERROR!] sqlite3_compile error:
amarok: [ERROR!] no such column: component
amarok: [ERROR!] on query: "SELECT version FROM admin WHERE component =
'AMAROK_PODCAST';"
amarok: creating Podcast Tables
amarok: BEGIN: void SqlPodcastProvider::createTables() const
amarok: [ERROR!] sqlite3_compile error:
amarok: [ERROR!] table podcastchannels already exists
amarok: [ERROR!] on query: "CREATE TABLE podcastchannels (id INTEGER
PRIMARY KEY AUTOINCREMENT,url VARCHAR(1024) UNIQUE,title VARCHAR(255),weblink
VARCHAR(1024),image VARCHAR(1024),description TEXT,copyright
VARCHAR(255),directory VARCHAR(255),labels VARCHAR(255),autoscan BOOL,
fetchtype INTEGER,autotransfer BOOL, haspurge BOOL, purgecount INTEGER );"
amarok: [ERROR!] sqlite3_compile error:
amarok: [ERROR!] table podcastepisodes already exists
amarok: [ERROR!] on query: "CREATE TABLE podcastepisodes (id INTEGER
PRIMARY KEY AUTOINCREMENT,url VARCHAR(1024) UNIQUE,channel INTEGER,localurl
VARCHAR(1024),guid VARCHAR(1024),title VARCHAR(255),subtitle
VARCHAR(255),sequencenumber INTEGER,description TEXT,mimetype
VARCHAR(255),pubdate VARCHAR(255),duration INTEGER,filesize INTEGER,isnew BOOL
);"
On a restart, running from terminal, i can view sql errors:
amarok: [ERROR!] sqlite3_compile error:
amarok: [ERROR!] index url_podchannel already exists
amarok: [ERROR!] on query: "CREATE INDEX url_podchannel ON
podcastchannels( url );"
amarok: [ERROR!] sqlite3_compile error:
amarok: [ERROR!] index url_podepisode already exists
amarok: [ERROR!] on query: "CREATE INDEX url_podepisode ON
podcastepisodes( url );"
amarok: [ERROR!] sqlite3_compile error:
amarok: [ERROR!] index localurl_podepisode already exists
amarok: [ERROR!] on query: "CREATE INDEX localurl_podepisode ON
podcastepisodes( localurl );"
amarok: [ERROR!] sqlite3_compile error:
amarok: [ERROR!] table admin has no column named component
amarok: [ERROR!] on query: "INSERT INTO admin(component,version)
VALUES('AMAROK_PODCAST',1);"
Then if i try to add a song to play list:
amarok: [ERROR!] sqlite3_compile error:
amarok: [ERROR!] no such column: urls.uniqueid
amarok: [ERROR!] on query: "SELECT urls.deviceid, urls.rpath,
urls.uniqueid, tracks.id, tracks.title, tracks.comment, tracks.tracknumber,
tracks.discnumber, statistics.score, statistics.rating, tracks.bitrate,
tracks.length, tracks.filesize, tracks.samplerate, statistics.createdate,
statistics.accessdate, statistics.playcount, tracks.filetype, tracks.bpm,
artists.name, artists.id, albums.name, albums.id, albums.artist, genres.name,
genres.id, composers.name, composers.id, years.name, years.id FROM urls LEFT
JOIN tracks ON urls.id = tracks.url LEFT JOIN artists ON tracks.artist =
artists.id LEFT JOIN albums ON tracks.album = albums.id LEFT JOIN genres ON
tracks.genre = genres.id LEFT JOIN composers ON tracks.composer = composers.id
LEFT JOIN years ON tracks.year = years.id LEFT JOIN statistics ON urls.id =
statistics.url WHERE 1 AND artists.name = 'AC/DC';"
amarok: END__: void AmarokMimeData::startQueries() - Took 0.016s
amarok: BEGIN: virtual void Playlist::GraphicsView::dropEvent(QDropEvent*)
amarok: Found track mime type
amarok: END__: virtual void Playlist::GraphicsView::dropEvent(QDropEvent*) -
Took 0.00057s
amarok: After the drag!
amarok: clearing PUD
amarok: END__: virtual void CollectionTreeView::startDrag(Qt::DropActions) -
Took 0.88s
--------------------------------------------------------------------------------------------------------
Now i delete all amarok setting and i retry. Any error will be reported
Thank you
** Affects: amarok-kde4 (Ubuntu)
Importance: Undecided
Status: New
** Description changed:
Binary package hint: amarok-kde4
On a upgraded/updated Ubuntu Intrepid using Gnome running Amarok from
- terminal, i get a crash, i can't report crash dump, i have just
+ terminal, i get a crash, i can't report crash dump, i have already
installed amarok (not kde4 release):
On the terminal window i see error on sql:
amarok: [ERROR!] on query: "REPLACE INTO
tracks_temp(url,artist,album,genre,composer,year,title,comment,tracknumber,discnumber,bitrate,length,samplerate,filesize,filetype,bpm,createdate,modifydate)
VALUES ( 230,230,230,2,1,11,'Thunderball','Encoded by
GuitarMan',0,0,128,180,44100,2883712,0,0,0,0);"
KCrash: Application 'amarok' crashing...
After first crash i restart amarok from terminal so i can see errors and
other it run and start... i see:
Couldn't resolve property: radialGradient3986
amarok: keys ()
amarok: [ERROR!] sqlite3_compile error:
amarok: [ERROR!] no such column: component
amarok: [ERROR!] on query: "SELECT version FROM admin WHERE component
= 'AMAROK_PODCAST';"
amarok: creating Podcast Tables
amarok: BEGIN: void SqlPodcastProvider::createTables() const
amarok: [ERROR!] sqlite3_compile error:
amarok: [ERROR!] table podcastchannels already exists
amarok: [ERROR!] on query: "CREATE TABLE podcastchannels (id
INTEGER PRIMARY KEY AUTOINCREMENT,url VARCHAR(1024) UNIQUE,title
VARCHAR(255),weblink VARCHAR(1024),image VARCHAR(1024),description
TEXT,copyright VARCHAR(255),directory VARCHAR(255),labels VARCHAR(255),autoscan
BOOL, fetchtype INTEGER,autotransfer BOOL, haspurge BOOL, purgecount INTEGER
);"
amarok: [ERROR!] sqlite3_compile error:
amarok: [ERROR!] table podcastepisodes already exists
amarok: [ERROR!] on query: "CREATE TABLE podcastepisodes (id
INTEGER PRIMARY KEY AUTOINCREMENT,url VARCHAR(1024) UNIQUE,channel
INTEGER,localurl VARCHAR(1024),guid VARCHAR(1024),title VARCHAR(255),subtitle
VARCHAR(255),sequencenumber INTEGER,description TEXT,mimetype
VARCHAR(255),pubdate VARCHAR(255),duration INTEGER,filesize INTEGER,isnew BOOL
);"
On a restart, running from terminal, i can view sql errors:
amarok: [ERROR!] sqlite3_compile error:
amarok: [ERROR!] index url_podchannel already exists
amarok: [ERROR!] on query: "CREATE INDEX url_podchannel ON
podcastchannels( url );"
amarok: [ERROR!] sqlite3_compile error:
amarok: [ERROR!] index url_podepisode already exists
amarok: [ERROR!] on query: "CREATE INDEX url_podepisode ON
podcastepisodes( url );"
amarok: [ERROR!] sqlite3_compile error:
amarok: [ERROR!] index localurl_podepisode already exists
amarok: [ERROR!] on query: "CREATE INDEX localurl_podepisode ON
podcastepisodes( localurl );"
amarok: [ERROR!] sqlite3_compile error:
amarok: [ERROR!] table admin has no column named component
amarok: [ERROR!] on query: "INSERT INTO admin(component,version)
VALUES('AMAROK_PODCAST',1);"
Then if i try to add a song to play list:
amarok: [ERROR!] sqlite3_compile error:
amarok: [ERROR!] no such column: urls.uniqueid
amarok: [ERROR!] on query: "SELECT urls.deviceid, urls.rpath,
urls.uniqueid, tracks.id, tracks.title, tracks.comment, tracks.tracknumber,
tracks.discnumber, statistics.score, statistics.rating, tracks.bitrate,
tracks.length, tracks.filesize, tracks.samplerate, statistics.createdate,
statistics.accessdate, statistics.playcount, tracks.filetype, tracks.bpm,
artists.name, artists.id, albums.name, albums.id, albums.artist, genres.name,
genres.id, composers.name, composers.id, years.name, years.id FROM urls LEFT
JOIN tracks ON urls.id = tracks.url LEFT JOIN artists ON tracks.artist =
artists.id LEFT JOIN albums ON tracks.album = albums.id LEFT JOIN genres ON
tracks.genre = genres.id LEFT JOIN composers ON tracks.composer = composers.id
LEFT JOIN years ON tracks.year = years.id LEFT JOIN statistics ON urls.id =
statistics.url WHERE 1 AND artists.name = 'AC/DC';"
amarok: END__: void AmarokMimeData::startQueries() - Took 0.016s
amarok: BEGIN: virtual void Playlist::GraphicsView::dropEvent(QDropEvent*)
amarok: Found track mime type
amarok: END__: virtual void Playlist::GraphicsView::dropEvent(QDropEvent*) -
Took 0.00057s
amarok: After the drag!
amarok: clearing PUD
amarok: END__: virtual void CollectionTreeView::startDrag(Qt::DropActions) -
Took 0.88s
--------------------------------------------------------------------------------------------------------
Now i delete all amarok setting and i retry. Any error will be reported
Thank you
--
[ intrepid ] amarok-kde4 crash on upgrading collection at startup
https://bugs.launchpad.net/bugs/264187
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
--
ubuntu-bugs mailing list
[email protected]
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
