Remove the words DEFAULT.
On Jun 5, 6:26 pm, 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
-~----------~----~----~----~------~----~------~--~---
