Be sure to specify the table name.  I think I ran into an issue where not 
specifying the table name
would result in a fatal error when trying to build the sql file:

Person:
  tableName: person
  columns:
    title:
      type: string(255)

Charley

[EMAIL PROTECTED] said on Friday, January 11, 2008:


>
>Well, I nuked everything, started from scratch again, re-init my
>symfony project (1.0.10), used sfDoctrinePlugin from here:
>http://svn.symfony-project.com/plugins/sfDoctrinePlugin/branches/1.0,
>created a very simple schema:
>
>Person:
>  columns:
>    title:
>      type: string(255)
>
>doctrine-build-model works fine.
>
>doctrine-build-sql throws exactly as above.
>
>
>
>
>On Jan 11, 9:32 am, "Sadri Sahraoui" <[EMAIL PROTECTED]> wrote:
>> hmm, I just can suggest to hard clean the cache and log directories,
>> delete the generated classes inside "lib" rewrite your schema, delete
>> and reinstall the sfDoctrinePlugin directory and finally rebuild your
>> models and re run *-sql
>>
>> On Jan 11, 2008 8:21 PM, Jonotron <[EMAIL PROTECTED]> wrote:
>>
>>
>>
>> > Just ran phpinfo()
>>
>> > PDO mysql is installed.  (I'm pretty sure debian's php5-mysql package
>> > installs PDO)
>>
>> > On Jan 11, 9:08 am, "Sadri Sahraoui" <[EMAIL PROTECTED]> wrote:
>> > > I'd the same problem last week check if pdo_mysql is installed or no !
>>
>> > > On Jan 11, 2008 8:06 PM, Jonathan Wage <[EMAIL PROTECTED]> wrote:
>>
>> > > > Hmm, I don't see any problems initially. But, currently their is a bug 
>> > > > in
>> > > > the creation of databases and the connection name must be the same as 
>> > > > the
>> > > > name of the database. But this is not related to your problem.
>>
>> > > >  What kind of server are you running this on? Does it have PDO mysql 
>> > > > and all
>> > > > that installed?
>>
>> > > > - Jon
>>
>> > > > On Jan 11, 2008 10:57 AM, Jonotron <[EMAIL PROTECTED] > wrote:
>>
>> > > > > my databases.yml file:
>>
>> > > > > dev:
>> > > > >  myproject:
>> > > > >    class:          sfDoctrineDatabase
>> > > > >    param:
>> > > > >      dsn:          mysql://dev:[EMAIL PROTECTED]/myProject_trunk
>>
>> > > > > and my doctrine/schema.yml:
>> > > > > ---
>> > > > > # Sympathy project main schema file for doctrine
>> > > > > Person:
>> > > > >  columns:
>> > > > >    person_id:
>> > > > >      notnull:        true
>> > > > >      primary:        true
>> > > > >      autoincrement:  true
>> > > > >      type:           integer(4)
>> > > > >      unsigned:       true
>> > > > >    name:
>> > > > >      notnull:        true
>> > > > >      type:           string
>> > > > >      length:         255
>> > > > >    content:
>> > > > >      type:           clob
>>
>> > > > > Thanks again
>>
>> > > > > J
>>
>> > > > > On Jan 11, 6:41 am, "Jonathan Wage" < [EMAIL PROTECTED]> wrote:
>> > > > > > Can we see your schema? Have you configured your databases.yml? 
>> > > > > > Can I
>> > > > see
>> > > > > > that too?
>>
>> > > > > > - Jon
>>
>> > > > > > On Jan 10, 2008 11:47 PM, Jonotron < [EMAIL PROTECTED]> wrote:
>>
>> > > > > > > I'm starting a new project and thought I'd give Doctrine a try 
>> > > > > > > (having
>> > > > > > > built one project on Propel, I like the looks of Doctrine 
>> > > > > > > better).
>>
>> > > > > > > I've installed the sfDoctrinePlugin 1.0 branch from svn and the
>> > > > > > > doctrine-build-model works fine, but when I try to do 
>> > > > > > > doctrine-build-
>> > > > > > > sql or doctrine-insert-sql I get an exception.  This is the only 
>> > > > > > > info
>> > > > > > > I am presented:
>>
>> > > > > > > [sfException]
>>
>> > > > > > >  #0 
>> > > > > > > /home/jonotron/workspace/myProject-trunk/plugins/sfDoctrinePlugin/
>> > > > > > > lib/doctrine/Doctrine/Cli.php(88): Doctrine_Cli->_run(Array)
>> > > > > > >  #1 
>> > > > > > > /home/jonotron/workspace/myProject-trunk/plugins/sfDoctrinePlugin/
>> > > > > > > data/tasks/sfPakeDoctrine.php(716): Doctrine_Cli->run(Array)
>> > > > > > >  #2 
>> > > > > > > /home/jonotron/workspace/myProject-trunk/plugins/sfDoctrinePlugin/
>> > > > > > > data/tasks/sfPakeDoctrine.php(220): 
>> > > > > > > _call_doctrine_cli('generate-sql')
>> > > > > > >  #3 [internal function]: run_doctrine_build_sql(Object(pakeTask),
>> > > > > > > Array, Array)
>> > > > > > >  #4 /usr/share/php/symfony/vendor/pake/pakeTask.class.php(218):
>> > > > > > > call_user_func_array('run_doctrine_bu...', Array)
>> > > > > > >  #5 /usr/share/php/symfony/vendor/pake/pakeTask.class.php(181):
>> > > > > > > pakeTask->execute(Array, Array)
>> > > > > > >  #6 /usr/share/php/symfony/vendor/pake/pakeApp.class.php(175):
>> > > > > > > pakeTask->invoke(Array, Array)
>> > > > > > >  #7 /usr/share/php/data/symfony/bin/symfony.php(174): pakeApp-
>> > > > > > > >run(NULL, NULL, false)
>> > > > > > >  #8 /usr/bin/symfony(39): include('/usr/share/
>> > > > > > > php/...')
>> > > > > > >  #9 {main}
>>
>> > > > > > > Can anyone shed some light on this so I can get a little further 
>> > > > > > > and
>> > > > > > > actually try Doctrine?
>>
>> > > > > > > Thanks
>>
>> > > > > > --
>> > > > > > Jonathan Wagehttp://www.jwage.comhttp://www.centresource.com
>>
>> > > > >http://www.centresource.com
>>

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"symfony users" group.
To post to this group, send email to symfony-users@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/symfony-users?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to