It complains about engines and whenever I do something I seem to get database problems. Is the database missing? How can I create it?

Any help would be highly appeciated - amarok roks (or actually, rocked on my friends computer).

Jimisola

[jimisola@turing config]$ amarok: ERROR: [bool CollectionDB::execSql(const QString&, QStringList*, QStringList*, bool)] [CollectionDB] sqlite3_compile error:
amarok: ERROR: no such table: tags
amarok: ERROR: on query: SELECT COUNT( url ) FROM tags LIMIT 0, 1;
amarok: ERROR: [bool CollectionDB::execSql(const QString&, QStringList*, QStringList*, bool)] [CollectionDB] sqlite3_compile error:
amarok: ERROR: no such table: tags
amarok: ERROR: on query: SELECT COUNT( url ) FROM tags LIMIT 0, 1;
amarok: ERROR: [bool CollectionDB::execSql(const QString&, QStringList*, QStringList*, bool)] [CollectionDB] sqlite3_compile error:
amarok: ERROR: no such table: tags
amarok: ERROR: on query: SELECT COUNT( url ) FROM tags LIMIT 0, 1;
amarok: ERROR: [bool CollectionDB::execSql(const QString&, QStringList*, QStringList*, bool)] [CollectionDB] sqlite3_compile error:
amarok: ERROR: no such table: tags
amarok: ERROR: on query: SELECT COUNT( url ) FROM tags LIMIT 0, 1;
amarok: ERROR: [bool CollectionDB::execSql(const QString&, QStringList*, QStringList*, bool)] [CollectionDB] sqlite3_compile error:
amarok: ERROR: no such table: tags
amarok: ERROR: on query: SELECT COUNT( url ) FROM tags LIMIT 0, 1;
amarok: ERROR: [bool CollectionDB::execSql(const QString&, QStringList*, QStringList*, bool)] [CollectionDB] sqlite3_compile error:
amarok: ERROR: no such table: tags
amarok: ERROR: on query: SELECT COUNT( url ) FROM tags LIMIT 0, 1;
amarok: ERROR: [bool CollectionDB::execSql(const QString&, QStringList*, QStringList*, bool)] [CollectionDB] sqlite3_compile error:
amarok: ERROR: no such table: tags
amarok: ERROR: on query: SELECT COUNT( url ) FROM tags LIMIT 0, 1;
amarok: ERROR: [bool CollectionDB::execSql(const QString&, QStringList*, QStringList*, bool)] [CollectionDB] sqlite3_compile error:
amarok: ERROR: no such table: tags
amarok: ERROR: on query: SELECT COUNT( url ) FROM tags LIMIT 0, 1;
amarok: ERROR: [bool CollectionDB::execSql(const QString&, QStringList*, QStringList*, bool)] [CollectionDB] sqlite3_compile error:
amarok: ERROR: no such table: tags
amarok: ERROR: on query: SELECT COUNT( url ) FROM tags LIMIT 0, 1;
amarok: ERROR: [bool CollectionDB::execSql(const QString&, QStringList*, QStringList*, bool)] [CollectionDB] sqlite3_compile error:
amarok: ERROR: no such table: tags
amarok: ERROR: on query: SELECT COUNT( url ) FROM tags LIMIT 0, 1;
amarok: ERROR: [bool CollectionDB::execSql(const QString&, QStringList*, QStringList*, bool)] [CollectionDB] sqlite3_compile error:
amarok: ERROR: no such table: tags
amarok: ERROR: on query: SELECT COUNT( url ) FROM tags LIMIT 0, 1;
amarok: ERROR: [bool CollectionDB::execSql(const QString&, QStringList*, QStringList*, bool)] [CollectionDB] sqlite3_compile error:
amarok: ERROR: no such table: tags
amarok: ERROR: on query: SELECT COUNT( url ) FROM tags LIMIT 0, 1;
amarok: ERROR: [bool CollectionDB::execSql(const QString&, QStringList*, QStringList*, bool)] [CollectionDB] sqlite3_compile error:
amarok: ERROR: no such table: tags
amarok: ERROR: on query: SELECT COUNT( url ) FROM tags LIMIT 0, 1;
amarok: ERROR: [bool CollectionDB::execSql(const QString&, QStringList*, QStringList*, bool)] [CollectionDB] sqlite3_compile error:
amarok: ERROR: no such table: tags
amarok: ERROR: on query: SELECT COUNT( url ) FROM tags LIMIT 0, 1;
amarok: ERROR: [bool CollectionDB::execSql(const QString&, QStringList*, QStringList*, bool)] [CollectionDB] sqlite3_compile error:
amarok: ERROR: no such table: tags
amarok: ERROR: on query: SELECT COUNT( url ) FROM tags LIMIT 0, 1;
amarok: ERROR: [bool CollectionDB::execSql(const QString&, QStringList*, QStringList*, bool)] [CollectionDB] sqlite3_compile error:
amarok: ERROR: no such table: tags
amarok: ERROR: on query: SELECT COUNT( url ) FROM tags LIMIT 0, 1;
QThread object destroyed while thread is still running.
amarok: ERROR: [bool CollectionDB::execSql(const QString&, QStringList*, QStringList*, bool)] [CollectionDB] sqlite3_compile error:
amarok: ERROR: no such table: tags
amarok: ERROR: on query: SELECT COUNT( url ) FROM tags LIMIT 0, 1;
amarok: ERROR: [bool CollectionDB::execSql(const QString&, QStringList*, QStringList*, bool)] [CollectionDB] sqlite3_compile error:
amarok: ERROR: no such table: tags
amarok: ERROR: on query: SELECT COUNT( url ) FROM tags LIMIT 0, 1;
amarok: ERROR: [bool CollectionDB::execSql(const QString&, QStringList*, QStringList*, bool)] [CollectionDB] sqlite3_compile error:
amarok: ERROR: no such table: tags
amarok: ERROR: on query: SELECT COUNT( url ) FROM tags LIMIT 0, 1;
amarok: ERROR: [bool CollectionDB::execSql(const QString&, QStringList*, QStringList*, bool)] [CollectionDB] sqlite3_compile error:
amarok: ERROR: no such table: tags
amarok: ERROR: on query: SELECT COUNT( url ) FROM tags LIMIT 0, 1;
QThread object destroyed while thread is still running.

I am using Mandrake 10.1 Official (have had the same problem since 10.0).
Installed using rpm (urpmi).

Jimisola

try deleting

~/.kde/share/apps/amarok/collection.db

Thanks for helping out.

I tried that - no success. I even removed the whole ´~/.kde/share/apps/amarok directory after that. Same problem.

[jimisola@turing amarok]$ ls
albumcovers/ collection.db current.xml playlistbrowser_save smartplaylists undo/
[jimisola@turing amarok]$ cd ..
[jimisola@turing apps]$ rm -rf amarok/
[jimisola@turing apps]$ amarok
[amaroK loader] connecting to /home/jimisola/.kde/socket-turing/amarok.loader_socket
[amaroK loader] amaroK not running. Trying to start it..
amarokapp: Symbol `_ZTI12KApplication' has different size in shared object, consider re-linking
amarok: ERROR: [bool CollectionDB::execSql(const QString&, QStringList*, QStringList*, bool)] [CollectionDB] sqlite3_compile error:
amarok: ERROR: no such table: tags
amarok: ERROR: on query: SELECT COUNT( url ) FROM tags LIMIT 0, 1;
amarok: WARNING: Database versions incompatible. Removing and rebuilding database.
amarok: ERROR: [bool CollectionDB::execSql(const QString&, QStringList*, QStringList*, bool)] [CollectionDB] sqlite3_compile error:
amarok: ERROR: no such table: tags
amarok: ERROR: on query: SELECT COUNT( url ) FROM tags LIMIT 0, 1;
amarok: ERROR: [bool CollectionDB::execSql(const QString&, QStringList*, QStringList*, bool)] [CollectionDB] sqlite3_compile error:
amarok: ERROR: no such table: tags
amarok: ERROR: on query: DROP TABLE tags;
amarok: ERROR: [bool CollectionDB::execSql(const QString&, QStringList*, QStringList*, bool)] [CollectionDB] sqlite3_compile error:
amarok: ERROR: no such table: album
amarok: ERROR: on query: DROP TABLE album;
amarok: ERROR: [bool CollectionDB::execSql(const QString&, QStringList*, QStringList*, bool)] [CollectionDB] sqlite3_compile error:
amarok: ERROR: no such table: artist
amarok: ERROR: on query: DROP TABLE artist;
amarok: ERROR: [bool CollectionDB::execSql(const QString&, QStringList*, QStringList*, bool)] [CollectionDB] sqlite3_compile error:
amarok: ERROR: no such table: genre
amarok: ERROR: on query: DROP TABLE genre;
amarok: ERROR: [bool CollectionDB::execSql(const QString&, QStringList*, QStringList*, bool)] [CollectionDB] sqlite3_compile error:
amarok: ERROR: no such table: year
amarok: ERROR: on query: DROP TABLE year;
amarok: ERROR: [bool CollectionDB::execSql(const QString&, QStringList*, QStringList*, bool)] [CollectionDB] sqlite3_compile error:
amarok: ERROR: no such table: images
amarok: ERROR: on query: DROP TABLE images;
amarok: ERROR: [bool CollectionDB::execSql(const QString&, QStringList*, QStringList*, bool)] [CollectionDB] sqlite3_compile error:
amarok: ERROR: no such table: statistics
amarok: ERROR: on query: SELECT COUNT( url ) FROM statistics LIMIT 0, 1;
amarok: ERROR: [bool CollectionDB::execSql(const QString&, QStringList*, QStringList*, bool)] [CollectionDB] sqlite3_compile error:
amarok: ERROR: no such table: statistics
amarok: ERROR: on query: DROP TABLE statistics;
[amaroK loader] startup successful.
[amaroK loader] exiting.
[jimisola@turing apps]$ cd amarok/
[jimisola@turing amarok]$ ls -l
total 28
drwxr-xr-x 3 jimisola jimisola 72 Oct 31 14:31 albumcovers/
-rw-r--r-- 1 jimisola jimisola 25600 Oct 31 14:31 collection.db
drwx------ 2 jimisola jimisola 48 Oct 31 14:31 undo/

My collection.db contains plain SQL statements (see attachment) is that really correct?

Jimisola

PS. Uploaded files had to be either image or text file, so I renamed collection.db to collection.jpg. http://amarok.kde.org/components/com_si ... ection.jpg DS. [img]http://amarok.kde.org/components/com_simpleboard/uploaded/images/collection.jpg[/img]

Post edited by: jimisola, at: 2004/10/31 20:43

Seem to be some similarities with this thread.

http://amarok.kde.org/component/option, ... 8/catid,8/

Is it aproblem with Mandrake 10.x?

Mandrake don't seem to have the right dependencies for amarok. Seems as if sqlite was not installed.

So I downloaed the rpm from http://www.hwaci.com/sw/sqlite/download.html and installed (forced since it claimed that libreadline.so.4 was installed which is was, but with a different name) from here.

That of course caused other problems, but at least I get to see my tracks when I import them. However, I can't play any songs..

[jimisola@turing apps]$ amarok
[amaroK loader] connecting to /home/jimisola/.kde/socket-turing/amarok.loader_socket
[amaroK loader] amaroK not running. Trying to start it..
amarokapp: Symbol `_ZTI12KApplication' has different size in shared object, consider re-linking
[amaroK loader] startup successful.
[amaroK loader] exiting.
[jimisola@turing apps]$ amarok: ERROR: [bool CollectionDB::execSql(const QString&, QStringList*, QStringList*, bool)] [CollectionDB] sqlite3_compile error:
amarok: ERROR: no such table: tags
amarok: ERROR: on query: SELECT COUNT( url ) FROM tags LIMIT 0, 1;
amarok: WARNING: Database versions incompatible. Removing and rebuilding database.
amarok: ERROR: [bool CollectionDB::execSql(const QString&, QStringList*, QStringList*, bool)] [CollectionDB] sqlite3_compile error:
amarok: ERROR: no such table: tags
amarok: ERROR: on query: DROP TABLE tags;
amarok: ERROR: [bool CollectionDB::execSql(const QString&, QStringList*, QStringList*, bool)] [CollectionDB] sqlite3_compile error:
amarok: ERROR: no such table: album
amarok: ERROR: on query: DROP TABLE album;
amarok: ERROR: [bool CollectionDB::execSql(const QString&, QStringList*, QStringList*, bool)] [CollectionDB] sqlite3_compile error:
amarok: ERROR: no such table: artist
amarok: ERROR: on query: DROP TABLE artist;
amarok: ERROR: [bool CollectionDB::execSql(const QString&, QStringList*, QStringList*, bool)] [CollectionDB] sqlite3_compile error:
amarok: ERROR: no such table: genre
amarok: ERROR: on query: DROP TABLE genre;
amarok: ERROR: [bool CollectionDB::execSql(const QString&, QStringList*, QStringList*, bool)] [CollectionDB] sqlite3_compile error:
amarok: ERROR: no such table: year
amarok: ERROR: on query: DROP TABLE year;
amarok: ERROR: [bool CollectionDB::execSql(const QString&, QStringList*, QStringList*, bool)] [CollectionDB] sqlite3_compile error:
amarok: ERROR: no such table: images
amarok: ERROR: on query: DROP TABLE images;
amarok: ERROR: [bool CollectionDB::execSql(const QString&, QStringList*, QStringList*, bool)] [CollectionDB] sqlite3_compile error:
amarok: ERROR: no such table: statistics
amarok: ERROR: on query: DROP TABLE statistics;
QColor::setRgb: RGB parameter(s) out of range
QColor::setRgb: RGB parameter(s) out of range
QColor::setRgb: RGB parameter(s) out of range
amarok: ERROR: [Gst-Engine] createPipeline() failed.
QObject::connect: No such signal QCheckBox::stateChanged(1)
QObject::connect: (sender name: 'kcfg_ShowTrayIcon')
QObject::connect: (receiver name: 'kcfg_AnimateTrayIcon')
QObject::connect: No such signal QCheckBox::stateChanged(0)
QObject::connect: (sender name: 'kcfg_ShowTrayIcon')
QObject::connect: (receiver name: 'kcfg_AnimateTrayIcon')
amarok: ERROR: Could not set outputThread to state PLAYING!
amarok: ERROR: [GStreamer Error] OSS device "/dev/dsp" is already in use by another program.
amarok: ERROR: Could not set outputThread to state PLAYING!
amarok: ERROR: [Gst-Engine] createPipeline() failed.
amarok: ERROR: [GStreamer Error] OSS device "/dev/dsp" is already in use by another program.
amarok: ERROR: [bool CollectionDB::execSql(const QString&, QStringList*, QStringList*, bool)] [CollectionDB] sqlite3_compile error:
amarok: ERROR: table directories already exists
amarok: ERROR: on query: CREATE TABLE directories (dir VARCHAR(100) UNIQUE,changedate INTEGER );
QThread object destroyed while thread is still running.
QThread object destroyed while thread is still running.
QThread object destroyed while thread is still running.

i had the same problem.

solved it by emerging (i use gentoo) with USE=\"-arts\".

i have disabled the arts support and i was able to use amarok 1.1.1

now, if i disable arts, howcome it works?

[]

Clansman wrote:

i had the same problem.

solved it by emerging (i use gentoo) with USE="-arts".

i have disabled the arts support and i was able to use amarok 1.1.1

now, if i disable arts, howcome it works?

[]

sorry, clicked submit too soon.
if arts is disabled, is amarok directly using alsa?

[]

amarok: ERROR: [GStreamer Error] OSS device \"/dev/dsp\" is already in use by another program.

you\'re soundcard is blocked by another program. try installing alsa\'s dmix plugin / get a better soundcard / close the program accessing the device (prolly artsd).

regards,
muesli

There is still a problem under gentoo ... you should have a look at this thread:
http://forums.gentoo.org/viewtopic.php?t=254602

And then this link:
http://bugs.gentoo.org/show_bug.cgi?id=70260

The problem come from Amarok or Glibc ?

I was a amarok addict ... and now I had to get back on a old player ... If anyone can help me ... it would be gratefull !

Have a nice Day.

I tried to compile it with and without artsd ... but I get the same result.

This is the error I get:
[code:1]
[~]$ amarok
[amaroK loader] connecting to /home/pol/.kde/socket-wolverine/amarok.loader_socket
[amaroK loader] amaroK not running. Trying to start it..
amarok: [PluginManager] Plugin trader constraint: [X-KDE-amaroK-framework-version] == 3 and [X-KDE-amaroK-plugintype] == \'engine\' and [X-KDE-amaroK-name] == \'void-engine\' and [X-KDE-amaroK-rank] > 0
amarok: [PluginManager] Trying to load: libamarok_void-engine_plugin
amarok:
amarok: PluginManager Service Info:
amarok: ---------------------------
amarok: name :
amarok: library : libamarok_void-engine_plugin
amarok: desktopEntryPath : amarok_void-engine_plugin.desktop
amarok: X-KDE-amaroK-plugintype : engine
amarok: X-KDE-amaroK-name : void-engine
amarok: X-KDE-amaroK-authors : (Max Howell,Mark Kretschmann)
amarok: X-KDE-amaroK-rank : 1
amarok: X-KDE-amaroK-version : 1
amarok: X-KDE-amaroK-framework-version: 3
amarok:
amarok: ERROR: [bool CollectionDB::execSql(const QString&, QStringList*, QStringList*, bool)] [CollectionDB] sqlite3_compile error:
amarok: ERROR: no such table: tags
amarok: ERROR: on query: SELECT COUNT( url ) FROM tags LIMIT 0, 1;
amarok: ERROR: [bool CollectionDB::execSql(const QString&, QStringList*, QStringList*, bool)] [CollectionDB] sqlite3_compile error:
amarok: ERROR: no such table: tags
amarok: ERROR: on query: DROP TABLE tags;
amarok: ERROR: [bool CollectionDB::execSql(const QString&, QStringList*, QStringList*, bool)] [CollectionDB] sqlite3_compile error:
amarok: ERROR: no such table: album
amarok: ERROR: on query: DROP TABLE album;
amarok: ERROR: [bool CollectionDB::execSql(const QString&, QStringList*, QStringList*, bool)] [CollectionDB] sqlite3_compile error:
amarok: ERROR: no such table: artist
amarok: ERROR: on query: DROP TABLE artist;
amarok: ERROR: [bool CollectionDB::execSql(const QString&, QStringList*, QStringList*, bool)] [CollectionDB] sqlite3_compile error:
amarok: ERROR: no such table: genre
amarok: ERROR: on query: DROP TABLE genre;
amarok: ERROR: [bool CollectionDB::execSql(const QString&, QStringList*, QStringList*, bool)] [CollectionDB] sqlite3_compile error:
amarok: ERROR: no such table: year
amarok: ERROR: on query: DROP TABLE year;
amarok: ERROR: [bool CollectionDB::execSql(const QString&, QStringList*, QStringList*, bool)] [CollectionDB] sqlite3_compile error:
amarok: ERROR: no such table: images
amarok: ERROR: on query: DROP TABLE images;
amarok: ERROR: [bool CollectionDB::execSql(const QString&, QStringList*, QStringList*, bool)] [CollectionDB] sqlite3_compile error:
amarok: ERROR: table directories already exists
amarok: ERROR: on query: CREATE TABLE directories (dir VARCHAR(100) UNIQUE,changedate INTEGER );
amarok: ERROR: [bool CollectionDB::execSql(const QString&, QStringList*, QStringList*, bool)] sqlite_step error.
amarok: ERROR: database schema has changed
amarok: ERROR: on query: SELECT DISTINCT artist.name, tags.sampler FROM tags, artist WHERE artist.id=tags.artist ORDER BY lower(artist.name) DESC;
amarok: ERROR: [bool CollectionDB::execSql(const QString&, QStringList*, QStringList*, bool)] [CollectionDB] sqlite3_compile error:
amarok: ERROR: no such table: tags
amarok: ERROR: on query: SELECT COUNT( url ) FROM tags LIMIT 0, 1;
QColor::setRgb: RGB parameter(s) out of range
QColor::setRgb: RGB parameter(s) out of range
QColor::setRgb: RGB parameter(s) out of range
amarok: [PluginManager] Plugin trader constraint: [X-KDE-amaroK-framework-version] == 3 and [X-KDE-amaroK-plugintype] == \'engine\' and [X-KDE-amaroK-name] == \'\' and [X-KDE-amaroK-rank] > 0
amarok: WARNING: [static amaroK::«»Plugin* PluginManager::createFromQuery(const QString&«»)] No matching plugin found.
amarok: [PluginManager] Plugin trader constraint: [X-KDE-amaroK-framework-version] == 3 and [X-KDE-amaroK-plugintype] == \'engine\' and [X-KDE-amaroK-name] != \'\' and [X-KDE-amaroK-rank] > 0
amarok: [PluginManager] Trying to load: libamarok_xine-engine
amarok:
amarok: PluginManager Service Info:
amarok: ---------------------------
amarok: name : xine Engine
amarok: library : libamarok_xine-engine
amarok: desktopEntryPath : amarok_xine-engine.desktop
amarok: X-KDE-amaroK-plugintype : engine
amarok: X-KDE-amaroK-name : xine-engine
amarok: X-KDE-amaroK-authors : (Max Howell)
amarok: X-KDE-amaroK-rank : 254
amarok: X-KDE-amaroK-version : 1
amarok: X-KDE-amaroK-framework-version: 3
amarok:
amarok: dl-close.c:365: _dl_close: l\'assertion « imap->l_type == lt_loaded || imap->l_opencount > 0 » a échoué.
KCrash: Application \'amarok\' crashing...
[/code:1]