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