This IS a cake issue. The scaffolding code should not pass an empty string to the ID field. It should be fixed so that the id is not used in the generated SQL statement.
On Feb 16, 8:42 am, skantner <[EMAIL PROTECTED]> wrote: > I want to say thanks also, Ben. This was really annoying me. I > started using Cake to save time, not lose time on frustrations like > this! I know it wasn't a really a Cake issue, but still... > //spk > > On Feb 10, 2:22 pm, asturges <[EMAIL PROTECTED]> wrote: > > > Thanks Ben, I was having the same problem. I knew it had to be > > something with MySQL, and not with Cake's scaffolding. For anyone else > > having this problem, edit the MySQL configuration file, which is > > probably called my.ini, and is located in the MySQL installation > > directory (if you're running windows). In the line that says > > > # Set the SQL mode to strict > > sql-mode="STRICT_TRANS_TABLES, > > NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" > > > take out the "STRICT_TRANS_TABLES" part (and delete the comma). This > > was included in the default installation of MySQL 5.0 on my Windows XP > > machine. No one else on the IRC seemed to be having the same problem, > > so perhaps my installation was not typical. Be aware that this allows > > some data to slip into MySQL that would have otherwise been forbidden. > > For more information > > see,http://dev.mysql.com/doc/refman/5.0/en/constraint-invalid-data.html. > > > -Andrew > > > On Jan 6, 6:43 pm, Ben Coleman <[EMAIL PROTECTED]> wrote: > > > > OK I've found the problem and the fix... > > > > It's caused by the version of MySQL - in v5.1the default SQL mode is > > > STRICT_TRANS_TABLES which causes thiserror. If you remove this > > > setting from the MySQL config it will let you use '' instead of NULL > > > and the Cake code works OK. > > > > Ben > > > > On Jan 6, 7:26 pm, Ben Coleman <[EMAIL PROTECTED]> wrote: > > > > > 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: > > > > > SQLError:1366: Incorrect integer value: '' forcolumn'id' atrow1 > > > > > I've defined my table as follows: > > > > > CREATE TABLE genres ( > > > > idINT UNSIGNED AUTO_INCREMENT PRIMARY KEY, > > > > name VARCHAR(50) > > > > ); > > > > > But it seems like the default scaffolding is not using the correct SQL > > > > for theidfield, 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 -~----------~----~----~----~------~----~------~--~---
