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
Jeremiah, you are inserting in the database 'tamiyausa' to the table 'product_access_level'. > But the parent table mydb/product does not currently exist! It complains there is no table 'product' in database 'mydb'. Can you do mysql> use tamiyausa mysql> SHOW CREATE TABLE product_access_level