PDA

View Full Version : MySQL error after moving some files



glen66
2006-08-25, 07:46
Hi All

I've just upgraded to MySQL, and was really pleased to find a BIG improvment in performance on SlimServer.

BUT...... I was tidying up some files and moved some to a different directory. Now Slimserver keeps crashing after a minute or so with the following error.

2006-08-25 15:41:19.1718 DBD::mysql::st execute failed: Cannot delete or update
a parent row: a foreign key constraint fails at C:\Program Files\SlimServer\serv
er\lib/Class/DBI.pm line 835.
2006-08-25 15:41:19.1862 Can't delete file:///C:/Share/Music/Music/Jamiroquai/Ph
il/Martha%20And%20The%20Muffins%20- 8.544649E-305cho%20Beach.mp3: DBD::mys
ql::st execute failed: Cannot delete or update a parent row: a foreign key const
raint fails at C:\Program Files\SlimServer\server\lib/Class/DBI.pm line 835.
at /PerlApp/Slim/DataStores/DBI/DBIStore.pm line 721


Any ideas????


Glen

glen66
2006-08-28, 09:16
The same problem is now happening when slimserver does it's nightly database update.

Can anyone help please!

Glen

JJZolx
2006-08-28, 09:40
Try doing a clear/rescan.

Which version are you running? That error sounds familiar, but I thought it was fixed a while back. IIRC, it was usually caused by renaming, deleting, or moving a directory in the music folder.

glen66
2006-08-28, 09:50
Slimserver 6.5b1 and MySQL version 4

It's a bit of a pain, as I am in the middle of sorting out all my tunes!

Glen