Re: SQL error when adding item using the scaffolding

2008-05-06 Thread benjam
Because it is still an issue, and has not been fixed yet. On May 5, 2:59 pm, AD7six [EMAIL PROTECTED] wrote: benjam wrote: My thinking is that it's a cake problem. Why are you resurrecting this old thread. --~--~-~--~~~---~--~~ You received this message

Re: SQL error when adding item using the scaffolding

2008-05-05 Thread benjam
My thinking is that it's a cake problem. If there is a way of doing things (INSERT NULL) that works everywhere, regardless of server settings, and a way of doing things (INSERT '') that works _almost_ everywhere, then you should use the way of doing things that works everywhere. If you don't,

Re: SQL error when adding item using the scaffolding

2008-05-05 Thread AD7six
benjam wrote: My thinking is that it's a cake problem. Why are you resurrecting this old thread. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups CakePHP group. To post to this group, send email to

Re: SQL error when adding item using the scaffolding

2008-04-09 Thread Priya
Thankyou Ben, I was totally stuck up with this problem till I read your solution. Thankyou Andrews for your exact specification of where to modify. Priya On Feb 11, 12:22 am, asturges [EMAIL PROTECTED] wrote: Thanks Ben, I was having the same problem. I knew it had to be something with MySQL,

Re: SQL error when adding item using the scaffolding

2008-02-24 Thread jim starboard
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

Re: SQL error when adding item using the scaffolding

2008-02-24 Thread jim starboard
I have say, I love how I'm put in my place in this group. I think I finally found a home. On Feb 24, 6:39 pm, nate [EMAIL PROTECTED] wrote: On Feb 24, 6:19 pm, jim starboard [EMAIL PROTECTED] wrote: Already there. 3 weeks old. Hard to believe it's not fixed. Maybe it's because we've got

Re: SQL error when adding item using the scaffolding

2008-02-24 Thread nate
On Feb 24, 6:19 pm, jim starboard [EMAIL PROTECTED] wrote: Already there. 3 weeks old. Hard to believe it's not fixed. Maybe it's because we've got about two week's worth of fixes and various other enhancements to do. Maybe it's because, in the grand scheme of things, scaffolding isn't really

Re: SQL error when adding item using the scaffolding

2008-02-24 Thread nate
All I'm really saying is, try and show a little respect. I don't think that's too much to ask. On Feb 24, 6:44 pm, jim starboard [EMAIL PROTECTED] wrote: I have say, I love how I'm put in my place in this group. I think I finally found a home. On Feb 24, 6:39 pm, nate [EMAIL PROTECTED]

Re: SQL error when adding item using the scaffolding

2008-02-24 Thread jim starboard
That wasn't sarcasm. You were right. On Feb 24, 8:17 pm, nate [EMAIL PROTECTED] wrote: All I'm really saying is, try and show a little respect. I don't think that's too much to ask. On Feb 24, 6:44 pm, jim starboard [EMAIL PROTECTED] wrote: I have say, I love how I'm put in my place in

Re: SQL error when adding item using the scaffolding

2008-02-18 Thread jim starboard
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

Re: SQL error when adding item using the scaffolding

2008-02-18 Thread Pablo Viojo
This IS what you should do: 1. Fill a ticket 2. submit a patch [1] Regards, -- Pablo Viojo [EMAIL PROTECTED] http://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

Re: SQL error when adding item using the scaffolding

2008-02-10 Thread asturges
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

SQL error when adding item using the scaffolding

2008-01-06 Thread Ben Coleman
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: