Matt wrote: > On Tue, Sep 16, 2008 at 9:30 AM, Kemian Dang <[EMAIL PROTECTED]> wrote: > >> Thanks Kris and Martin, I applied the diff and amarok builds. >> But there are problems on running it, the main window exits after >> showing for no more than 1 second and I get errors from command line >> like below. >> Any ideas what I should do to fix it? >> > > According to the beta-2 announcement on http://amarok.kde.org/ - the > database scheme changed and you need to delete the older format files > of they exist. > > <quote> > Please be aware that the database scheme changed since alpha 2 and you > will need to delete collection.db in Amarok's settings folder (often > in ~/.kde4/share/apps/amarok or ~/.kde/share/apps/amarok) if you have > used any previous version of Amarok 2. > </quote> > > Hope that helps, > Matt >
Hello Matt, thanks for reply. I have not installed amarok before. I also have tested delete the db file, which get the same error. Any other ideas? Best wishes, Kemian >> Thanks, >> Kemian >> >> amarok: [ERROR!] sqlite3_compile >> error: >> >> amarok: [ERROR!] no such table: >> artists_temp >> >> amarok: [ERROR!] on insert: "INSERT INTO artists SELECT * FROM >> artists_temp WHERE artists_temp.id NOT IN ( -1 );" >> amarok: [ERROR!] sqlite3_compile >> error: >> >> amarok: [ERROR!] no such table: >> images_temp >> >> amarok: [ERROR!] on insert: "INSERT INTO images SELECT * FROM >> images_temp;" >> amarok: [ERROR!] sqlite3_compile >> error: >> >> amarok: [ERROR!] no such table: >> albums_temp >> >> amarok: [ERROR!] on insert: "INSERT INTO albums SELECT * FROM >> albums_temp WHERE albums_temp.id NOT IN ( -1 );" >> amarok: [ERROR!] sqlite3_compile >> error: >> >> amarok: [ERROR!] no such table: >> composers_temp >> >> amarok: [ERROR!] on insert: "INSERT INTO composers SELECT * FROM >> composers_temp WHERE composers_temp.id NOT IN ( -1 >> );" >> >> amarok: [ERROR!] sqlite3_compile >> error: >> >> amarok: [ERROR!] no such table: >> genres_temp >> >> amarok: [ERROR!] on insert: "INSERT INTO genres SELECT * FROM >> genres_temp WHERE genres_temp.id NOT IN ( -1 );" >> amarok: [ERROR!] sqlite3_compile >> error: >> >> amarok: [ERROR!] no such table: >> years_temp >> >> amarok: [ERROR!] on insert: "INSERT INTO years SELECT * FROM >> years_temp WHERE years_temp.id NOT IN ( -1 );" >> amarok: [ERROR!] sqlite3_compile >> error: >> >> amarok: [ERROR!] no such table: >> urls_temp >> >> amarok: [ERROR!] on insert: "REPLACE INTO urls SELECT * FROM >> urls_temp;" >> amarok: [ERROR!] sqlite3_compile >> error: >> >> amarok: [ERROR!] no such table: >> directories_temp >> >> amarok: [ERROR!] on query: "INSERT INTO directories SELECT * >> FROM directories_temp;" >> amarok: [ERROR!] sqlite3_compile >> error: >> >> amarok: [ERROR!] no such table: >> tracks_temp >> >> amarok: [ERROR!] on insert: "REPLACE INTO tracks SELECT * FROM >> tracks_temp;" >> amarok: END__: void DatabaseUpdater::copyToPermanentTables() - Took >> 0.02s >> amarok: BEGIN: void >> DatabaseUpdater::removeTemporaryTables() >> >> amarok: [ERROR!] sqlite3_compile >> error: >> >> amarok: [ERROR!] no such table: >> tracks_temp >> >> amarok: [ERROR!] on query: "DROP TABLE >> tracks_temp;" >> >> amarok: [ERROR!] sqlite3_compile >> error: >> >> amarok: [ERROR!] no such table: >> images_temp >> >> amarok: [ERROR!] on query: "DROP TABLE >> images_temp;" >> >> amarok: [ERROR!] sqlite3_compile >> error: >> >> amarok: [ERROR!] no such table: >> albums_temp >> >> amarok: [ERROR!] on query: "DROP TABLE >> albums_temp;" >> >> amarok: [ERROR!] sqlite3_compile >> error: >> >> amarok: [ERROR!] no such table: >> genres_temp >> >> amarok: [ERROR!] on query: "DROP TABLE >> genres_temp;" >> >> amarok: [ERROR!] sqlite3_compile >> error: >> >> amarok: [ERROR!] no such table: >> years_temp >> >> amarok: [ERROR!] on query: "DROP TABLE >> years_temp;" >> >> amarok: [ERROR!] sqlite3_compile >> error: >> >> amarok: [ERROR!] no such table: >> composers_temp >> >> amarok: [ERROR!] on query: "DROP TABLE >> composers_temp;" >> >> amarok: [ERROR!] sqlite3_compile >> error: >> >> amarok: [ERROR!] no such table: >> artists_temp >> >> amarok: [ERROR!] on query: "DROP TABLE >> artists_temp;" >> >> amarok: [ERROR!] sqlite3_compile >> error: >> >> amarok: [ERROR!] no such table: >> urls_temp >> >> amarok: [ERROR!] on query: "DROP TABLE >> urls_temp;" >> >> amarok: [ERROR!] sqlite3_compile >> error: >> >> amarok: [ERROR!] no such table: directories_temp >> amarok: [ERROR!] on query: "DROP TABLE directories_temp" >> amarok: END__: void DatabaseUpdater::removeTemporaryTables() - Took 0.0053s >> amarok: Sending changed signal >> amarok: BEGIN: ScanResultProcessor::~ScanResultProcessor() >> amarok: END__: ScanResultProcessor::~ScanResultProcessor() - Took 0.00026s >> amarok: END__: virtual void XmlParseJob::run() - Took 0.69s >> amarok: [ERROR!] sqlite3_compile error: >> amarok: [ERROR!] no such table: tags >> amarok: [ERROR!] on query: "SELECT s.deviceid,s.url FROM statistics >> AS s LEFT JOIN tags AS t ON s.deviceid = t.deviceid AND s.url = t.url >> WHERE t.url IS NULL AND s.deviceid != -2;" >> amarok: [MountPointManager] Trying to update 0 statistics rows >> amarok: [ERROR!] sqlite3_compile error: >> amarok: [ERROR!] no such table: tags_labels >> amarok: [ERROR!] on query: "SELECT l.deviceid,l.url FROM tags_labels >> AS l LEFT JOIN tags as t ON l.deviceid = t.deviceidAND l.url = t.url >> WHERE t.url IS NULL;" >> amarok: [MountPointManager] Trying to update 0 tags_labels rows >> amarok: END__: virtual void UrlUpdateJob::run() - Took 0.085s >> amarok: BEGIN: void ScanManager::slotFinished() >> amarok: END__: void ScanManager::slotFinished() - Took 0.00011s >> KCrash: crashing... crashRecursionCounter = 2 >> KCrash: Application Name = amarok path = <unknown> pid = 16687 >> sock_file=/home/kemian/.kde4/socket-kemian.inf.ed.ac.uk/kdeinit4__0 >> >> _______________________________________________ kde-freebsd mailing list kde-freebsd@kde.org https://mail.kde.org/mailman/listinfo/kde-freebsd See also http://freebsd.kde.org/ for latest information
