Thanks, got it working.. got a new error now that im posting in a seperate post.
On Jun 5, 1:02 pm, leo <[EMAIL PROTECTED]> wrote: > Delete the two occurrences of the word DEFAULT and try again. > > On 5 Juny, 18:26, Jason Ourscene <[EMAIL PROTECTED]> wrote: > > > Set up cake without a hitch. Moving onto the first part where we > > create the blog database i am getting this error: > > > Here is the command: > > CREATE TABLE posts ( > > id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY, > > title VARCHAR(50), > > body TEXT, > > created DATETIME DEFAULT NOT NULL, > > modified DATETIME DEFAULT NOT NULL > > ); > > > And here is the error: > > ERROR 1064 (42000): You have an error in your SQL syntax; check the > > manual that corresponds to your MySQL server version for the right > > syntax to use near 'NOT NULL, > > modified DATETIME DEFAULT NOT NULL)' at line 5 > > > I cant figure this one out. Thanks! > > > Jason --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" 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 -~----------~----~----~----~------~----~------~--~---
