[kde-freebsd] New Port for Testing: Amarok2

[Matt]

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
>
> 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
>