Disregard this message, sorry, I ran the query again without the word "default" and it worked without any errors.
----- Original Message ---- From: Janis Rough <[EMAIL PROTECTED]> To: [email protected] Sent: Thursday, October 9, 2008 8:06:16 AM Subject: Re: newbie question I just installed it. Sorry I didn't research the list further. I do have another question on the tutorial. I tried running these sql create statements and they didn't work. I got 2 errors. I wonder why? 1 SQL query: 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 ) MySQL said: #1064 - 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 2 SQL query: 1INSERT INTO posts( title, body, created ) VALUES ( 'Title strikes back', 'This is really exciting Not.', NOW( ) ); MySQL said: #1064 - 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 '1INSERT INTO posts (title,body,created) VALUES ('Title strikes back', 'This ' at line 1 here is the query i didn't run it with the numbers. The first error I got rid of was the word default on line 6. Why can't the default be not null?: 1. /* First, create our posts table: */ 2. CREATE TABLE posts ( 3. id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY, 4. title VARCHAR(50), 5. body TEXT, 6. created DATETIME DEFAULT NOT NULL, 7. modified DATETIME DEFAULT NOT NULL 8. ); 9. /* Then insert some posts for testing: */ 10. INSERT INTO posts (title,body,created) 11. VALUES ('The title', 'This is the post body.', NOW()); 12. INSERT INTO posts (title,body,created) 13. VALUES ('A title once again', 'And the post body follows.', NOW()); 14. INSERT INTO posts (title,body,created) 15. VALUES ('Title strikes back', 'This is really exciting! Not.', NOW());This might be a mysql question but I'm trying to get the cake php tutorial to work. ----- Original Message ---- From: Gabriel Kolbe <[EMAIL PROTECTED]> To: [email protected] Sent: Thursday, October 9, 2008 2:55:42 AM Subject: Re: newbie question I user Xampp, and it works like a dream !! On Thu, Oct 9, 2008 at 4:09 AM, <[EMAIL PROTECTED]> wrote: > > I think it may be best if you use a real server! > > On 10/08/2008, JRough <[EMAIL PROTECTED]> wrote: >> >> I want to try out Cakephp. Do you know if I can use it with XXAMP on >> Windows just for testing or do I have to install it on a real server? >> >> thanks, >> >> > >> > > > -- > Xavier A. Mathews > Student/Developer/Web-Master > GG Client Based Tech Support Specialist > Hazel Crest Illinois > [EMAIL PROTECTED] > "Fear of a name, only increases fear of the thing itself." > > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
