[clug] MySQL error

[David Tulloh]

I couldn't reproduce the error either, but I was using mysql 4.
I would suggest looking at your foreign keys, I think mysql does some
foreign key enforcement, which would explain why I couldn't reproduce.

Specifically:
You have a field,  customer SMALLINT(4),
You then link it,  CONSTRAINT fk_customer_id FOREIGN KEY (customer)
REFERENCES customer(name) ON DELETE CASCADE,

I am guessing that the name field in the customer table is not an
integer.  The incompatible types may explain your problem.


If that doesn't work, try cutting out bits until you get the smallest
reproducable case.  That should give you a far better idea of where to look.


Daivd


Kristy Bennett wrote:
> Hi all!
> 
> Just a simple one I expect - mostly related to my need for sleep I have
> concluded.  Can anyone see what I cannot?
> 
> I have the details up here:
> http://www.kristy.id.au/blog/2006/09/what-did-i-do-wrong-mysql.html
> 
> Cheers!
>