Re: URGENT !! InnoDB Constraint problem !

2004-06-07 Thread Heikki Tuuri
iling.database.myodbc Sent: Monday, June 07, 2004 12:56 PM Subject: URGENT !! InnoDB Constraint problem ! > i dont have that section in my status report (ill tried it before) > here's the report > *** 1. row *** > Status: > ==

URGENT !! InnoDB Constraint problem !

2004-06-07 Thread Dimitri Bosiers
i dont have that section in my status report (ill tried it before) here's the report *** 1. row *** Status: = 040607 10:04:41 INNODB MONITOR OUTPUT = Per second averages calculate

Re: URGENT !! InnoDB Constraint problem !

2004-06-06 Thread Josh Trutwin
On Sun, 6 Jun 2004 15:48:37 +0200 Dimitri Bosiers <[EMAIL PROTECTED]> wrote: > INSERT INTO > pages(hidden,name,page_number,data,is_section_root,layout_id,group_ > id) VALUES(1,'nieuwe pagina',100,'',2,1,@LID); > > this fails with a "ERROR 1216: Cannot add a child row: a foreign key > > con

URGENT !! InnoDB Constraint problem !

2004-06-06 Thread Dimitri Bosiers
I have a problem with my innodb database wich freaks me out , first a description of the involving tables : mysql> describe pages ; +-+--+--+-+- ++ | Field | Type | Null | Key | Default | Extra