Hi,

Just got back into using Cake after some time away from it (and PHP
development in general) I want to knock up an app very quickly so I
want to use the scaffolding. I have a very simple table, model &
controller defined but when I come to add an item I always get this
error:

SQL Error: 1366: Incorrect integer value: '' for column 'id' at row 1

I've defined my table as follows:

CREATE TABLE genres (
    id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(50)
);

But it seems like the default scaffolding is not using the correct SQL
for the id field, how can I get round this?
I'm using MySQL 5.0 and PHP 5.2

Any advice is appreciated!

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake 
PHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to