Dan Sully wrote:
* Mr Nõu shaped the electrons to say...
yeah, really weird. I thought maybe the schema was corrupted somehow,
and am rebuilding a virgin empty mysql database as we are writing
this. sorry, no go on downgrading mysql here - three other apps are
dependent on the installation being 5.x
The schema for 6.2.x is broken for MySQL.
In SQL/mysql/dbcreate.sql - change the definition of 'secs' to be:
secs float unsigned,
Thanks!
I created a new db. I updated dbcreate.sql with above. I "imported" the
schema. I started slimserver. This time I let it run, and the process
picked up about half of my tracks (9000 from 20000). Significant
improvement. But still. (And I also know that this is unsupported, so
don't bend over backwards to understand...)
One of the errors is "data truncated for column 'bitrate'". Should this
variable be re-defined as well? Should I move to 6.5-branch instead?
I did NOT alter the table (below), since I started with a fresh db, ok?
/peter
And alter the table:
ALTER TABLE tracks CHANGE secs float unsigned;
-D
_______________________________________________
Discuss mailing list
[email protected]
http://lists.slimdevices.com/lists/listinfo/discuss
