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 [email protected]
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
-~----------~----~----~----~------~----~------~--~---