List:General Discussion« Previous MessageNext Message »
From:Victor Subervi Date:May 21 2010 5:24pm
Subject:Another Foreign Key Problem
View as plain text  
Hi;
When I try to execute this code from my Python script, I get this error:

Traceback (most recent call last):
  File "/var/www/html/creative.vi/clients/sea-flight/reservations/create_edit_bags3.py",
line 38, in ?
    create_edit_bags3()
  File "/var/www/html/creative.vi/clients/sea-flight/reservations/create_edit_bags3.py",
line 32, in create_edit_bags3
    cursor.execute('insert into Baggage values (Null, %s, %s, %s,
%s)', (flight_id, customer_id, weight, ticket_no))
  File "/usr/lib64/python2.4/site-packages/MySQLdb/cursors.py", line
163, in execute
    self.errorhandler(self, exc, value)
  File "/usr/lib64/python2.4/site-packages/MySQLdb/connections.py",
line 35, in defaulterrorhandler
    raise errorclass, errorvalue
OperationalError: (1452, 'Cannot add or update a child row: a foreign
key constraint fails (`seaflight/Baggage`, CONSTRAINT `Baggage_ibfk_2`
FOREIGN KEY (`customer_id`) REFERENCES `Customers` (`id`))')

However, when I try from the MySQL prompt after duly printing it out from
the code, it works. Why?
TIA,
Victor

Thread
Another Foreign Key ProblemVictor Subervi21 May
  • Re: Another Foreign Key ProblemVictor Subervi21 May