Bealers wrote: > Attempting to solve my issue I've been trying to change my model, so > have dumped out all data and then edited my schema so the FK's are > named correctrly (like the 'not broken' ones in my previous post) > > I kept running into problems doing build-sql but assuming the problem > was still with me I figured I'd try thigs out on a completely fresh > project to see what's broken, I come up with the same issues. Here are > the steps I'm taking: > >> mkdir foo && cd foo > >> symfony init-project foo >> symfony init-app frontend > > Now create schema, make sure propel.ini has right settings and schema > first line is <dbname>: (in this case foo) > >> symfony propel-build-model >> symfony propel-build-db >
>> symfony propel-convert-yml-schema >> symfony propel-build-db You've just created two schemas now with those commands, you have schema.yml and schema.xml? > OK, now create db works (and I can check this on the mysql command > line) > > Here's the money shot: > >> symfony propel-build-sql > > ----8<---- > > <snip> > > propel > sql-template: > [propel-sql] Processing: schema.xml > [propel-sql] Processing: generated-schema.xml > Execution of target "sql-template" failed for the following reason: / > usr/share/php/symfony/vendor/propel-generator/build-propel.xml:187:1: > Duplicate table found: foo. > [phingcall] /usr/share/php/symfony/vendor/propel-generator/build- > propel.xml:187:1: Duplicate table found: foo. > > ----8<---- When you have both a .yml and .xml schema you will receive this error. I don't use propel much anymore but I'm betting the issue is a slight lake of understanding what all the propel-X-X commands do. Some of them create a schema from the db, some go the other way etc... the language is all so similar that it can be confusing. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
