[kde-freebsd] New Port for Testing: Amarok2

[Kemian Dang]

Matt wrote:
> On Tue, Sep 16, 2008 at 9:30 AM, Kemian Dang <fbsd.kdang at googlemail.com> 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
>>
>>