[kde-freebsd] New Port for Testing: Amarok2

[Dorian Büttner]

Kemian Dang schrieb:
> 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
>>>
>>>     
Amarok2 for now only suppurts the sqlite database backend - and sqlite 
does not work with nfs-mounted home-dirs. Is it propably this what 
happens here? This is what I experienced as well, but amarok will come 
up after some time. Sure, it doesn't store collection data in that 'mode'.