failed SQL queries in the dynamic branch

[Andrew Turner]

Ian,

I believe that maxx_k has fixed the problem with creating the index.

As for the playlists table not existing - that is not a problem with
the branch. That table should exist in trunk as of Persistent Tables
Version 12, which is from the end of May. (revision 546372) . I would
guess that if you were still travelling, you might have got bitten by
the bug I recently found where Persistent and Stats table upgrades
would only do the upgrade from 10->11, even if you were starting from
10 and going to 12. This will probably also have affected anyone
upgrading from 1.4.0 to 1.4.1 (inc beta1), if my guess is right. More
amusing still is that an upgrade to Persistent Tables version 11 is in
fact a NOOP - it does nothing.

The upgrade code for Persistent tables is fixed only in the branch, as
with all the talk of merging, I thought it not worth the effort to
backport it to trunk. It would also be pointless, unless anyone is
immediately going to add more tables in trunk, as it would only help
for future updates; that you managed to notice a previous upgrade had
failed is purely happy coincidence.

I think, from what I can tell, this is the only failure that can
happen with the 1.4.0->1.4.1 upgrade. So, when the branch is merged
into trunk (or, the fix backported, I suppose), everything will be
sorted. Until then, I wonder what the effect is of not having a
playlists table.

Andrew


On 15/07/06, Ian Monroe <ian at monroe.nu> wrote:
> 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!
> _______________________________________________
> Amarok mailing list
> Amarok at kde.org
> https://mail.kde.org/mailman/listinfo/amarok
>