Re: Error with foreign key constraint when updating

2003-07-28 Thread Heikki Tuuri
ED]> Sent: Tuesday, July 29, 2003 12:08 AM Subject: RE: Error with foreign key constraint when updating Oh sorry... I was trying to disguise my db name with "mydb", heh. Oh well... There is only one db.. It is tamiyausa. -Original Message- From: Heikki Tuuri [mailto:[EMAI

Re: Error with foreign key constraint when updating

2003-07-28 Thread Heikki Tuuri
er MySQL technical support from https://order.mysql.com/ - Original Message - From: ""Jeremiah Jacks"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Monday, July 28, 2003 9:11 PM Subject: Error with foreign key constraint when updating > &g

Error with foreign key constraint when updating

2003-07-28 Thread Jeremiah Jacks
I just upgraded to MySQL 4.0.14-standard for RedHat Linux and am using the pre-compiled binaries. I have a database with INNODB tables. When I insert a row into one of the child tables, I get the following MySQL error: INSERT INTO product_access_level (product_id,access_level_id) VALUES ('10201'