PDA

View Full Version : Trash the database every upgrade - is this normal?



James Dunn
2005-03-19, 13:45
Hi,

Every time I upgrade the Slimserver (and possibly every time I restart it -
although I'm not normally doing that so I've no clear recollection), I end
up having to trash the database because of the following error:

DBD::mysql::db do failed: Table 'metainformation' already exists at
/usr/local/SlimServer_v6.0b2/Slim/DataStores/DBI/DataModel.pm line 68, <$fh>
line 201.

This is created as the dbcreate.sql script is executed but surely this
should only be run if there isn't an existing database (or a database with
the correct schema number). At this point, the database should pass through
an upgrade process or terminate with incompatible database message.

I can easily clear the problem by logging onto the SQL server and running
the dbdrop.sql script included in the Slimserver distribution but this seems
a little severe. I could go and replace the bdcreate.sql script with an
empty file I suppose.

Obviously, from the error, I'm using MySQL which I know isn't properly
supported as yet.

Cheers,

James