failed SQL queries in the dynamic branch

[Ian Monroe]

I use mysql 4.0.25

amarok:   BEGIN: CollectionDB::CollectionDB()
amarok:     BEGIN: void CollectionDB::initialize()
amarok:       [ThreadWeaver] Creating pthread key, exit value is 0
amarok:       BEGIN: MySqlConnection::MySqlConnection(const MySqlConfig*)
amarok:         [CollectionDB] [MySqlConnection::MySqlConnection(const
MySqlConfig*)]
amarok:       END__: MySqlConnection::MySqlConnection(const
MySqlConfig*) - Took 0.048s
amarok:       [CollectionDB] MYSQL QUERY FAILED: Table
'amarok.devices' doesn't exist
amarok: FAILED QUERY: SELECT COUNT( id ) FROM devices LIMIT 1 OFFSET 0;
amarok:       [CollectionDB] Creating DEVICES table
amarok:       [CollectionDB] MYSQL QUERY FAILED: Specified key was too
long. Max key length is 500
amarok: FAILED QUERY: CREATE INDEX devices_remoteshare ON devices(
servername, sharename );
amarok:     END__: void CollectionDB::initialize() - Took 0.25s
amarok:     [CollectionDB] INotify not available, using QTimer!
amarok:   END__: CollectionDB::CollectionDB() - Took 0.33s
amarok:   [CollectionDB] Different database stats version detected!
Stats table will be updated or rebuilt.
amarok:   [CollectionDB] MYSQL QUERY FAILED: Table 'amarok.playlists'
doesn't exist
amarok: FAILED QUERY: INSERT INTO playlists_fix SELECT
playlist,url,tracknum FROM playlists;
amarok:   [CollectionDB] MYSQL QUERY FAILED: Unknown table 'playlists'
amarok: FAILED QUERY: DROP TABLE playlists;
amarok:   [CollectionDB] Rebuilding database!
amarok:   [CollectionDB] Dropping media table
amarok:   BEGIN: void CollectionDB::createTables(bool)
amarok:     [CollectionDB] MYSQL QUERY FAILED: Table 'admin' already exists
amarok: FAILED QUERY: CREATE TABLE admin (noption VARCHAR(255), value
VARCHAR(255));
amarok:   END__: void CollectionDB::createTables(bool) - Took 0.39s
amarok:   [CollectionDB] INotify not available, using QTimer!