PDA

View Full Version : 6.2 w/ MySQL & foreign-key / crash



BKDotCom
2005-10-25, 05:54
crashes when scaning with this error left in system event log (windows XP):

Can't delete file:///G:/Audio/mp3/Chillout_Lounge_Downbeat/Cafe_del_Mar/Cafe%20Del%20Mar%20-%20Vol%2006.mp3#0-318.066666666667: DBD::mysql::st execute failed: Cannot delete or update a parent row: a foreign key constraint fails at C:\Program Files\SlimServer\server\CPAN/DBIx/ContextualFetch.pm line 51.
at /PerlApp/Slim/DataStores/DBI/DBIStore.pm line 581
.

BKDotCom
2005-10-25, 19:24
Appears solved by making all foreign-key links cascade..
I think this was the case with previous releases - I simply forgot.

Dan Sully
2005-10-25, 19:27
* BKDotCom shaped the electrons to say...

>Appears solved by making all foreign-key links cascade..
>I think this was the case with previous releases - I simply forgot.

Should we change this in our schema?

-D
--
<ZangTT> berkeley db - it's mostly about the hash()

BKDotCom
2005-10-26, 08:41
* BKDotCom shaped the electrons to say...

>Appears solved by making all foreign-key links cascade..
>I think this was the case with previous releases - I simply forgot.

Should we change this in our schema?

My vote: yes