All pastes #86779 Raw Edit

Something

public text v1 · immutable
·published 2006-07-13 06:32 UTC
rendered paste body
amarok:     BEGIN: void CollectionDB::copyTempTables()
amarok:       [CollectionDB] MYSQL INSERT FAILED: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT id FROM album )' at line 1
amarok: FAILED INSERT: INSERT INTO album SELECT * FROM album_temp WHERE album_temp.id NOT IN ( SELECT id FROM album );
amarok:       [CollectionDB] MYSQL INSERT FAILED: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT id FROM artist )' at line 1
amarok: FAILED INSERT: INSERT INTO artist SELECT * FROM artist_temp WHERE artist_temp.id NOT IN ( SELECT id FROM artist );
amarok:       [CollectionDB] MYSQL INSERT FAILED: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT id FROM genre )' at line 1
amarok: FAILED INSERT: INSERT INTO genre SELECT * FROM genre_temp WHERE genre_temp.id NOT IN ( SELECT id FROM genre );
amarok:       [CollectionDB] MYSQL INSERT FAILED: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT id FROM year )' at line 1
amarok: FAILED INSERT: INSERT INTO year SELECT * FROM year_temp WHERE year_temp.id NOT IN ( SELECT id FROM year );
amarok:       [CollectionDB] MYSQL INSERT FAILED: Duplicate entry './Music/World/Americas/El Disco Reggaeton/Front.jpg-3' for key 1
amarok: FAILED INSERT: INSERT INTO images SELECT * FROM images_temp;
amarok:     END__: void CollectionDB::copyTempTables() - Took 0.57s
amarok:   END__: virtual bool ScanController::doJob() - Took 1.7e+02s