[clug] MySQL error

David Tulloh david at tulloh.id.au
Fri Sep 15 14:49:35 GMT 2006

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.

You have a field,  customer SMALLINT(4),
You then link it,  CONSTRAINT fk_customer_id FOREIGN KEY (customer)

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.


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!

More information about the linux mailing list