In addition to the integers as strings not allowing nulls, I just ran into another Postgres issue...
Trying to create the ACL tables with: cake schema run create DbAcl outputs SQL in the form of "id" integer serial NOT NULL, which causes a SQL syntax error. The type should just be SERIAL. On Jan 15, 1:31 am, Charlie Chilton <[EMAIL PROTECTED]> wrote: > The update and delete issue has been fixed in the latest SVN (along > with a sequences fix too), > > I only noticed the integer-as-string thing you mentioned late in the > day yesterday, I don't know whether this has had a Ticket or fix yet > (my SVN copy is a few days old). > > I should have some time to investigate today and create a ticket for > the devs if theres not one already there. > > Charlie > > On Jan 15, 2:43 am, "pixelaté" <[EMAIL PROTECTED]> wrote: > > > > > Hey, first up; I think Cake is an awesome framework. It makes website > > development extremely easy! Thanks for the product and keep up the > > good work! > > > I was using the an earlier build of cake and everything was working > > relatively well - I did have an issue where I have to restart apache > > every 6 hours because the server stops responding but I've been > > ignoring that hoping that future releases will fix it. > > > Anyways, I decided up upgrade and had mammoth problems with postgres. > > > Long story short, I had a problem with postgres updates and deletes. I > > found cryptic bug messages on using test prefixes and other things > > which I have no idea what they mean. Instead I just went and upgraded > > my dbo_source.php and dbo_postgres.php from the svn repository. That > > seemed to fix most of my issues. > > > The other issue I ended up having was cake wasn't addressing data > > types. It was treating all of my database fields as strings. > > > Trying to enter in an empty number resulted in an error as cake was > > trying to enter in an empty string rather than a null. Very > > frustrating. > > > I gave up and reverted to the old version and it's running again. I > > hope this will be fixed soon :( > > > Just thought I'd throw my experiences in. > > > Cheers, > > > Ian- Hide quoted text - > > - Show quoted text - --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
