> 1) i don't know what's wrong in the SQL statement, what it is?

From: http://dev.mysql.com/doc/refman/5.0/en/create-table.html

column_definition:
    data_type [NOT NULL | NULL] [DEFAULT default_value]
      [AUTO_INCREMENT] [UNIQUE [KEY] | [PRIMARY] KEY]
      [COMMENT 'string'] [reference_definition]

Note that "[DEFAULT default_value]" means that DEFAULT is optional,
but if you specify it, it's mandatory that it be followed by the
default value.

> 2) this is the code in my .php, it's exactly the tutorial:
> http://bin.cakephp.org/saved/34489

I can't see nothing wrong with that code...

> On Sat, Jul 5, 2008 at 4:49 PM, Dardo Sordi Bogado <[EMAIL PROTECTED]>
> wrote:
>>
>> Hello, and welcome to CakePHP!
>>
>>
>> > i'm trying to learn CakePHP by the bog tutorial, i'm using APache2Triad
>> > 1.5.4 and CakePHP 1.1.19.6305 and i had two problems:
>>
>> Let me suggest you start right with CakePHP 1.2 RC2, since it's the
>> second release candidate seems like soon we will have a stable
>> release.
>>
>>
>> > 1) MySQL did'nt accept the DEFAULT parameter in:
>> >
>> > 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
>> > );
>>
>> Indeed that has a typo, perhaps you should file a documentation
>> ticket: http://trac.cakephp.org .
>>
>>
>> > 2) After i created the view "index.thtml" i tried to see what i did in
>> > the
>> > browser and i got this error: " Parse error: syntax error, unexpected
>> > T_CLASS in
>> > C:\apache2triad\htdocs\cake\app\controllers\posts_controller.php
>> > on line 2", this doens't make any sense to me, because all the code i
>> > copied
>> > ctrl+c ctrl+v from the tutorial and all syntax is correct.
>>
>> Seems like you have a syntax error in your PostsController, if you
>> show us the code maybe we can spot the error. Please use the bin:
>> http://bin.cakephp.org
>>
>> > so if anyone can help me with this, tks!
>>
>> Regards,
>> - Dardo Sordi.
>>
>> > >
>> >
>>
>>
>
>
> >
>

--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---

Reply via email to