List:General Discussion« Previous MessageNext Message »
From:Victor Subervi Date:May 21 2010 5:31pm
Subject:Re: Another Foreign Key Problem
View as plain text  
I'm canceling this thread. It belongs in the Python list. Sorry!
V

On Fri, May 21, 2010 at 1:24 PM, Victor Subervi <victorsubervi@stripped>wrote:

> 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