Bug 3016 - MySQL FK issue.
: MySQL FK issue.
Status: RESOLVED DUPLICATE of bug 3101
Product: MySqueezebox.com
Classification: Unclassified
Component: Internet Radio
: Prod
: All All
: P2 normal (vote)
: ---
Assigned To: Andy Grundman
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2006-02-16 11:29 UTC by Dan Sully
Modified: 2008-03-14 08:54 UTC (History)
0 users

See Also:
Category: ---


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Dan Sully 2006-02-16 11:29:56 UTC
2006-02-16 02:27:21.1127 Auto-detecting IP: 192.168.254.4                                                                                                  
2006-02-16 02:27:21.1129 Disconnecting all clients from 192.168.254.4:3554                                                                                 
2006-02-16 07:38:38.3925 DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails [for Statement "INSERT INTO       
squeezenetwork_prod1.player_codes (player, updated, code)                                                                                                  
VALUES (?, ?, ?)                                                                                                                                           
"] at /home/svcprod/ss/Orbital-42/service/../base/lib/Class/DBI.pm line 721.                                                                               
2006-02-16 07:39:08.0891 DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails [for Statement "INSERT INTO       
squeezenetwork_prod1.player_prefs (value, name, idx, player)                                                                                               
VALUES (?, ?, ?, ?)                                                                                                                                        
"] at /home/svcprod/ss/Orbital-42/service/../base/lib/Class/DBI.pm line 721.                                                                               
2006-02-16 07:39:22.6406 DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails [for Statement "INSERT INTO       
squeezenetwork_prod1.player_prefs (value, name, idx, player)                                                                                               
VALUES (?, ?, ?, ?)                                                                                                                                        
"] at /home/svcprod/ss/Orbital-42/service/../base/lib/Class/DBI.pm line 721.                                                                               
2006-02-16 07:39:22.8301 DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails [for Statement "INSERT INTO       
squeezenetwork_prod1.now_tracks (stream, player, playlist)                                                                                                 
VALUES (?, ?, ?)                                                                                                                                           
"] at /home/svcprod/ss/Orbital-42/service/../base/lib/Class/DBI.pm line 721.                                                                               
Can't insert new SDI::Service::Model::NowTrack: Can't get last insert id at /home/svcprod/ss/Orbital-42/service/SDI/Service/Control.pm line 140            
 at /home/svcprod/ss/Orbital-42/service/SDI/Service/Control.pm line 140                                                                                    
2006-02-16 07:39:22.8723 Disconnecting all clients from 192.168.254.4:3554
Comment 1 Andy Grundman 2006-03-03 14:06:15 UTC

*** This bug has been marked as a duplicate of 3101 ***