Hello again, finally i can start amarok now, starting with amarok --wizard and deselecting the folders of my mp3, once started i can create the database again from the program options, but i still have a little problem, amarok doesn\'t shows preferences, and \"your favourite tracks\" and \"least listened songs\" are always empty, when i play a song the program doesn\'t shows the rate.

The output from console is now as this:

luis@debian:~$ amarok
[amaroK] Connecting to /home/luis/.kde/socket-debian/amarok.loader_socket
[amaroK] Starting amarokapp..
[amaroK] If you want a backtrace, run gdb against amarokapp, not amarok!
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::Plugin::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: available db connections: 1
amarok: [CollectionDB::CollectionDB()]
amarok: ERROR: [QStringList CollectionDB::query(const QString&, DbConnection*)][CollectionDB] sqlite3_compile error:
amarok: ERROR: no such table: statistics
amarok: ERROR: on query: SELECT COUNT( url ) FROM statistics LIMIT 0, 1;
amarok: available db connections: 5
amarok: ERROR: [QStringList CollectionDB::query(const QString&, DbConnection*)][CollectionDB] sqlite3_compile error:
amarok: ERROR: no such table: statistics
amarok: ERROR: on query: SELECT COUNT( url ) FROM statistics LIMIT 0, 1;
amarok: ERROR: [QStringList CollectionDB::query(const QString&, DbConnection*)][CollectionDB] sqlite3_compile error:
amarok: ERROR: no such table: statistics
amarok: ERROR: on query: SELECT COUNT( url ) FROM statistics LIMIT 0, 1;
amarok: [void CollectionDB::scanModifiedDirs(bool, bool)]
QLayout: Adding KToolBar/playlist_toolbar (child of QVBox/unnamed) to layout for PlaylistWindow/PlaylistWindow
amarok: [browserBar] Initialisation statistics:
amarok: Init: ContextBrowser
amarok: [void ContextBrowser::setStyleSheet()]
amarok: Initial Color Properties: s:0 v:0
amarok: Unapplied Contrast: 160
amarok: Final Colour Properties: s:30 v:160
amarok: Time: 0.03s
amarok: Init: CollectionBrowser
amarok: [CollectionView::CollectionView(CollectionBrowser*)]
amarok: [void CollectionView::renderView()]
amarok: SELECT DISTINCT artist.name FROM tags,album,artist WHERE 1 AND tags.sampler = 0 AND album.id=tags.album AND artist.id=tags.artist ORDER BY LOWER( artist.name )
amarok: SELECT DISTINCT artist.name FROM tags,album,artist WHERE 1 AND tags.sampler = 1 AND album.id=tags.album AND artist.id=tags.artist LIMIT 0, 1
amarok: Time: 0.06s
amarok: Init: PlaylistBrowser
amarok: [ThreadWeaver] Job::Job: PlaylistLoader
amarok: [ThreadWeaver] Queuing: PlaylistLoader
amarok: [ThreadWeaver] Thread::Thread: PlaylistLoader
amarok: SELECT DISTINCT artist.name FROM artist WHERE 1 ORDER BY LOWER( artist.name )
amarok: [ThreadWeaver] Running Job: PlaylistLoader
amarok: [ThreadWeaver] Job Done: PlaylistLoader. Aborted? false
amarok: Time: 0.05s
amarok: Init: SearchBrowser
amarok: Time: 0.03s
amarok: Init: FileBrowser
amarok: Time: 0.02s
amarok: Session Playlist: /home/luis/.kde/share/apps/amarok/current.xml
amarok: [ThreadWeaver] Job::Job: PlaylistLoader
amarok: [ThreadWeaver] Queuing: PlaylistLoader
amarok: BEGIN [void App::applySettings(bool)]
amarok: [void ContextBrowser::setStyleSheet()]
amarok: Initial Color Properties: s:0 v:255
amarok: Unapplied Contrast: 160
amarok: Over-compensation: 160
amarok: Final Colour Properties: s:30 v:95
amarok: [ThreadWeaver] Running Job: PlaylistLoader
amarok: [ThreadWeaver] Job Done: PlaylistLoader. Aborted? false
amarok: BEGIN [PlayerWidget::PlayerWidget(QWidget*, const char*, bool)]
amarok: END [PlayerWidget::PlayerWidget(QWidget*, const char*, bool)]
amarok: [AudioScrobbler] Handshake url: http://post.audioscrobbler.com/?hs=true ... u=iamarock
amarok: [void ContextBrowser::setStyleSheet()]
amarok: Initial Color Properties: s:0 v:255
amarok: Unapplied Contrast: 160
amarok: Over-compensation: 160
amarok: Final Colour Properties: s:30 v:95
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: [ThreadWeaver] [virtual void ThreadWeaver::customEvent(QCustomEvent*)]
amarok: [ThreadWeaver] Thread::~Thread: PlaylistLoader
amarok: [ThreadWeaver] Job::~Job: PlaylistLoader
amarok: [ThreadWeaver] [virtual void ThreadWeaver::customEvent(QCustomEvent*)]
amarok: [ThreadWeaver] Thread was deleted while processing this job: PlaylistLoader
amarok: [ThreadWeaver] Job::~Job: PlaylistLoader
amarok: BEGIN [static EngineBase* EngineController::loadEngine()]
amarok: [PluginManager] Plugin trader constraint: [X-KDE-amaroK-framework-version] == 3 and [X-KDE-amaroK-plugintype] == \'engine\' and [X-KDE-amaroK-name] == \'xine-engine\' and [X-KDE-amaroK-rank] > 0
amarok: [PluginManager] Trying to load: libamarok_xine-engine
amarok: [amaroK::Plugin::Plugin()]
amarok:
amarok: PluginManager Service Info:
amarok: ---------------------------
amarok: name : Motor xine
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: [xine-engine] Build stamp: Dec 13 2004 16:42:57
amarok: Please report bugs to http://bugs.kde.org
Please test bugs against the newest available xine-lib
amarok: [static void PluginManager::unload(amaroK::Plugin*)]
amarok: [virtual amaroK::Plugin::~Plugin()]
amarok: [PluginManager] Unloading library: libamarok_void-engine_plugin
amarok: ERROR: [QStringList CollectionDB::query(const QString&, DbConnection*)][CollectionDB] sqlite3_compile error:
amarok: ERROR: no such table: statistics
amarok: ERROR: on query: SELECT tags.title, tags.url, round( statistics.percentage + 0.4 ), artist.name, album.name FROM tags, artist, album, statistics WHERE artist.id = tags.artist AND album.id = tags.album AND statistics.url = tags.url ORDER BY statistics.percentage DESC LIMIT 0,10;
amarok: ERROR: [QStringList CollectionDB::query(const QString&, DbConnection*)][CollectionDB] sqlite3_compile error:
amarok: ERROR: no such table: statistics
amarok: ERROR: on query: SELECT tags.title, tags.url, artist.name, album.name, statistics.accessdate FROM tags, artist, album, statistics WHERE artist.id = tags.artist AND album.id = tags.album AND tags.url = statistics.url ORDER BY statistics.accessdate LIMIT 0,5;
amarok: ERROR: [QStringList CollectionDB::query(const QString&, DbConnection*)][CollectionDB] sqlite3_compile error:
amarok: ERROR: no such table: statistics
amarok: ERROR: on query: SELECT tags.title, tags.url, round( statistics.percentage + 0.4 ), artist.name, album.name FROM tags, artist, album, statistics WHERE artist.id = tags.artist AND album.id = tags.album AND statistics.url = tags.url ORDER BY statistics.percentage DESC LIMIT 0,10;
amarok: ERROR: [QStringList CollectionDB::query(const QString&, DbConnection*)][CollectionDB] sqlite3_compile error:
amarok: ERROR: no such table: statistics
amarok: ERROR: on query: SELECT tags.title, tags.url, artist.name, album.name, statistics.accessdate FROM tags, artist, album, statistics WHERE artist.id = tags.artist AND album.id = tags.album AND tags.url = statistics.url ORDER BY statistics.accessdate LIMIT 0,5;
amarok: END [static EngineBase* EngineController::loadEngine()]
amarok: [void CollectionView::renderView()]
amarok: SELECT DISTINCT artist.name FROM tags,album,artist WHERE 1 AND tags.sampler = 0 AND album.id=tags.album AND artist.id=tags.artist ORDER BY LOWER( artist.name )
amarok: SELECT DISTINCT artist.name FROM tags,album,artist WHERE 1 AND tags.sampler = 1 AND album.id=tags.album AND artist.id=tags.artist LIMIT 0, 1
amarok: END [void App::applySettings(bool)]
amarok: [App] Pruned 0 of 199 amazon cover images.
[amaroK] Startup successful
[amaroK] Exiting
luis@debian:~$ amarok: [virtual void LoaderServer::newConnection(int)]
amarok: Received: STARTUP (8 bytes)
QImage::smoothScale: Image is a null image
amarok: WARNING: [AudioScrobbler] KIO error! errno: 14



It seems a database related problem, please, how can i fix it?

Thank you.

delete your amarokrc (in .kde/share/config) and your collection.db (in .kde/share/apps/amarok), then start amarok.

regards,
muesli

Hello, I\'ve upgraded Amarok from 1.1.1 to the new 1.2.beta.2, I\'m using Debian Unstable and I\'ve used .deb package from the Kalyxo (http://www.kalyxo.org/) repositories.

When I try to start Amarok from console the output is as follows:

amarok: ERROR: [QStringList CollectionDB::query(const QString&, DbConnection*)][CollectionDB] sqlite3_compile error:
amarok: ERROR: unable to open database file
amarok: ERROR: on query: CREATE TABLE artist (id INTEGER PRIMARY KEY ,name VARCHAR(255) );
amarok: ERROR: [QStringList CollectionDB::query(const QString&, DbConnection*)][CollectionDB] sqlite3_compile error:
amarok: ERROR: unable to open database file
amarok: ERROR: on query: CREATE TABLE genre (id INTEGER PRIMARY KEY ,name VARCHAR(255) );
amarok: ERROR: [QStringList CollectionDB::query(const QString&, DbConnection*)][CollectionDB] sqlite3_compile error:
amarok: ERROR: unable to open database file
amarok: ERROR: on query: CREATE TABLE year (id INTEGER PRIMARY KEY ,name VARCHAR(4) );
amarok: ERROR: [QStringList CollectionDB::query(const QString&, DbConnection*)][CollectionDB] sqlite3_compile error:
amarok: ERROR: unable to open database file
amarok: ERROR: on query: CREATE TABLE images (path VARCHAR(255),artist VARCHAR(255),album VARCHAR(255) );
amarok: ERROR: [QStringList CollectionDB::query(const QString&, DbConnection*)][CollectionDB] sqlite3_compile error:
amarok: ERROR: unable to open database file
amarok: ERROR: on query: CREATE TABLE directories (dir VARCHAR(255) UNIQUE,changedate INTEGER );
amarok: ERROR: [QStringList CollectionDB::query(const QString&, DbConnection*)][CollectionDB] sqlite3_compile error:
amarok: ERROR: unable to open database file
amarok: ERROR: on query: CREATE INDEX album_idx ON album( name );
amarok: ERROR: [QStringList CollectionDB::query(const QString&, DbConnection*)][CollectionDB] sqlite3_compile error:
amarok: ERROR: unable to open database file
amarok: ERROR: on query: CREATE INDEX artist_idx ON artist( name );
amarok: ERROR: [QStringList CollectionDB::query(const QString&, DbConnection*)][CollectionDB] sqlite3_compile error:
amarok: ERROR: unable to open database file
amarok: ERROR: on query: CREATE INDEX genre_idx ON genre( name );
amarok: ERROR: [QStringList CollectionDB::query(const QString&, DbConnection*)][CollectionDB] sqlite3_compile error:
amarok: ERROR: unable to open database file
amarok: ERROR: on query: CREATE INDEX year_idx ON year( name );
amarok: ERROR: [QStringList CollectionDB::query(const QString&, DbConnection*)][CollectionDB] sqlite3_compile error:
amarok: ERROR: unable to open database file
amarok: ERROR: on query: CREATE TABLE related_artists (artist VARCHAR(255),suggestion VARCHAR(255),changedate INTEGER );
amarok: ERROR: [QStringList CollectionDB::query(const QString&, DbConnection*)][CollectionDB] sqlite3_compile error:
amarok: ERROR: unable to open database file
amarok: ERROR: on query: CREATE INDEX url_tag ON tags( url );
amarok: ERROR: [QStringList CollectionDB::query(const QString&, DbConnection*)][CollectionDB] sqlite3_compile error:
amarok: ERROR: unable to open database file
amarok: ERROR: on query: CREATE INDEX album_tag ON tags( album );
amarok: ERROR: [QStringList CollectionDB::query(const QString&, DbConnection*)][CollectionDB] sqlite3_compile error:
amarok: ERROR: unable to open database file
amarok: ERROR: on query: CREATE INDEX artist_tag ON tags( artist );
amarok: ERROR: [QStringList CollectionDB::query(const QString&, DbConnection*)][CollectionDB] sqlite3_compile error:
amarok: ERROR: unable to open database file
amarok: ERROR: on query: CREATE INDEX genre_tag ON tags( genre );
amarok: ERROR: [QStringList CollectionDB::query(const QString&, DbConnection*)][CollectionDB] sqlite3_compile error:
amarok: ERROR: unable to open database file
amarok: ERROR: on query: CREATE INDEX year_tag ON tags( year );
amarok: ERROR: [QStringList CollectionDB::query(const QString&, DbConnection*)][CollectionDB] sqlite3_compile error:
amarok: ERROR: unable to open database file
amarok: ERROR: on query: CREATE INDEX sampler_tag ON tags( sampler );
amarok: ERROR: [QStringList CollectionDB::query(const QString&, DbConnection*)][CollectionDB] sqlite3_compile error:
amarok: ERROR: unable to open database file
amarok: ERROR: on query: CREATE INDEX images_album ON images( album );
amarok: ERROR: [QStringList CollectionDB::query(const QString&, DbConnection*)][CollectionDB] sqlite3_compile error:
amarok: ERROR: unable to open database file
amarok: ERROR: on query: CREATE INDEX images_artist ON images( artist );
amarok: ERROR: [QStringList CollectionDB::query(const QString&, DbConnection*)][CollectionDB] sqlite3_compile error:
amarok: ERROR: unable to open database file
amarok: ERROR: on query: CREATE INDEX directories_dir ON directories( dir );
amarok: ERROR: [QStringListTerminado (killed)


And so on, those errors keep showing on an endless loop, and i have to close the process from another terminal.

version 1.1.1 was completely fine.

Thanks in advance.

Sorry for my english