Already there. 3 weeks old. Hard to believe it's not fixed.
On Feb 18, 9:35 am, "Pablo Viojo" <[EMAIL PROTECTED]> wrote:
> This IS what you should do:
>
> 1. Fill a ticket
> 2. submit a patch [1]
>
> Regards,
>
> --
> Pablo Viojo
> [EMAIL PROTECTED]://pviojo.net
>
> [1]https://trac.cakephp.org/
>
> On Sun, Feb 17, 2008 at 5:19 PM, jim starboard <[EMAIL PROTECTED]>
> wrote:
>
>
>
> > 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
-~----------~----~----~----~------~----~------~--~---
