This is my second time posting, so if it shows up again i apologize, I refreshed during the last post.
So the command im sending is. # 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 # ); without the comments and the error im getting is. 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 im new to all this and have been trying to figure it out, but no avail --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
