[clug] MySQL error

[Steve Walsh]

My understanding of the error is that it's a known bug in 4.1.10, and an upgrade 
fixes it. If you're not running 4.1.10, what David said is a good idea...

David Tulloh wrote:
> 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!
>>
>