This forum has been archived. All content is frozen. Please use KDE Discuss instead.

Amarok SVN MYSQL collection troubles - stuck at 73% update!

Page 1 of 1 (2 posts)

Tags: None
(comma "," separated)
hish
Registered Member
Posts
23
Karma
0

Amarok SVN MYSQL collection troubles - stuck at 73% update!

Sun Jan 28, 2007 1:03 am
hey, when trying to update my mysql collection data from Amarok, it seems to get stuck at 73%.

this is a bit of the output, it gives me a lot of errors..
amarok:    [CollectionDB] MYSQL QUERY FAILED: Table './amarok/statistics' is marked as crashed and should be repaired
amarok: FAILED QUERY: SELECT url, deviceid FROM statistics WHERE uniqueid = '67ff1c0fc9e958209445405779cc0e3a';
amarok:    [CollectionDB] MYSQL QUERY FAILED: Table './amarok/statistics' is marked as crashed and should be repaired
amarok: FAILED QUERY: SELECT url, uniqueid FROM statistics WHERE deviceid = 4 AND url = './hamish/new/tunng - comments of the inner chorus (special edition 2006)/06-tunng-jenny_again.mp3';
amarok:    [CollectionDB] MYSQL QUERY FAILED: Table './amarok/statistics' is marked as crashed and should be repaired
amarok: FAILED QUERY: SELECT url, deviceid FROM statistics WHERE uniqueid = '69985313e94bb5598dea442ba0f09f56';
amarok:    [CollectionDB] MYSQL QUERY FAILED: Table './amarok/statistics' is marked as crashed and should be repaired
amarok: FAILED QUERY: SELECT url, uniqueid FROM statistics WHERE deviceid = 4 AND url = './hamish/new/tunng - comments of the inner chorus (special edition 2006)/07-tunng-man_in_the_box.mp3';
amarok:    [CollectionDB] MYSQL QUERY FAILED: Table './amarok/statistics' is marked as crashed and should be repaired
amarok: FAILED QUERY: SELECT url, deviceid FROM statistics WHERE uniqueid = '95524e358cfc774a8aa03345656e1868';
amarok:    [CollectionDB] MYSQL QUERY FAILED: Table './amarok/statistics' is marked as crashed and should be repaired
amarok: FAILED QUERY: SELECT url, uniqueid FROM statistics WHERE deviceid = 4 AND url = './hamish/new/tunng - comments of the inner chorus (special edition 2006)/08-tunng-jay_down.mp3';
amarok:    [CollectionDB] MYSQL QUERY FAILED: Table './amarok/statistics' is marked as crashed and should be repaired
amarok: FAILED QUERY: SELECT url, deviceid FROM statistics WHERE uniqueid = 'de6f1c044eae4df28e695572a270180d';
amarok:    [CollectionDB] MYSQL QUERY FAILED: Table './amarok/statistics' is marked as crashed and should be repaired
amarok: FAILED QUERY: SELECT url, uniqueid FROM statistics WHERE deviceid = 4 AND url = './hamish/new/tunng - comments of the inner chorus (special edition 2006)/04-tunng-red_and_green.mp3';
amarok:    [CollectionDB] MYSQL QUERY FAILED: Table './amarok/statistics' is marked as crashed and should be repaired
amarok: FAILED QUERY: SELECT url, deviceid FROM statistics WHERE uniqueid = '3dda5d3c0cbf08bfe38f0d09756167c2';
amarok:    [CollectionDB] MYSQL QUERY FAILED: Table './amarok/statistics' is marked as crashed and should be repaired
amarok: FAILED QUERY: SELECT url, uniqueid FROM statistics WHERE deviceid = 4 AND url = './hamish/new/tunng - comments of the inner chorus (special edition 2006)/09-tunng-its_because____weve_got_hair.mp3';
amarok:    [CollectionDB] MYSQL QUERY FAILED: Table './amarok/statistics' is marked as crashed and should be repaired
amarok: FAILED QUERY: SELECT url, deviceid FROM statistics WHERE uniqueid = 'c3ed63d743323d4e00e609573d46cae3';
amarok:    [CollectionDB] MYSQL QUERY FAILED: Table './amarok/statistics' is marked as crashed and should be repaired
amarok: FAILED QUERY: SELECT url, uniqueid FROM statistics WHERE deviceid = 4 AND url = './hamish/new/tunng - comments of the inner chorus (special edition 2006)/10-tunng-sweet_william.mp3';
amarok:    [CollectionDB] MYSQL QUERY FAILED: Table './amarok/statistics' is marked as crashed and should be repaired
amarok: FAILED QUERY: SELECT url, deviceid FROM statistics WHERE uniqueid = '70d6145ffca2aa53acaa9087224ca52a';
amarok:    [CollectionDB] MYSQL QUERY FAILED: Table './amarok/statistics' is marked as crashed and should be repaired
amarok: FAILED QUERY: SELECT url, uniqueid FROM statistics WHERE deviceid = 4 AND url = './hamish/new/tunng - comments of the inner chorus (special edition 2006)/11-tunng-engine_room.mp3';
amarok:    [CollectionDB] MYSQL QUERY FAILED: Table './amarok/statistics' is marked as crashed and should be repaired
amarok: FAILED QUERY: SELECT url, deviceid FROM statistics WHERE uniqueid = '0c0b9f4a7245f975122f882f8f348010';
amarok:    [CollectionDB] MYSQL QUERY FAILED: Table './amarok/statistics' is marked as crashed and should be repaired
amarok: FAILED QUERY: SELECT url, uniqueid FROM statistics WHERE deviceid = 4 AND url = './hamish/new/tunng - comments of the inner chorus (special edition 2006)/12-tunng-band_stand.mp3';
amarok:    [CollectionDB] MYSQL QUERY FAILED: Table './amarok/statistics' is marked as crashed and should be repaired
amarok: FAILED QUERY: SELECT url, deviceid FROM statistics WHERE uniqueid = 'e8332cf92b303d198d0ff7f2882079cb';
amarok:    [CollectionDB] MYSQL QUERY FAILED: Table './amarok/statistics' is marked as crashed and should be repaired


it gives me that for many of my albums, not sure why. I've tried just using SQLite, that works fine, but I like having the MYSQL backend.
can any offer suggestions?

thanks..
User avatar
markey
KDE Developer
Posts
2286
Karma
3
OS

Re: Amarok SVN MYSQL collection troubles - stuck at 73% update!

Sun Jan 28, 2007 11:20 am
Try to svn update; we've fixed a bug in the scanner yesterday.

--
Mark Kretschmann - Amarok Developer

Page 1 of 1 (2 posts)

Bookmarks


Who is online

Registered users: Bing [Bot], Google [Bot], kde-naveen, Sogou [Bot]