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
BREAKS
----8<----
propel > create-db:
[propel-data-model] Target database type: mysql
[propel-data-model] Target package:
[propel-data-model] Using template path: /usr/share/php/symfony/vendor/
propel-generator/templates
[propel-data-model] Output directory: /home/bealers/www/U/foo/data/sql
Execution of target "create-db" failed for the following reason: /usr/
share/php/symfony/vendor/propel-generator/build-propel.xml:263:1: No
schema files were found (matching your schema fileset definition).
[phing] /usr/share/php/symfony/vendor/propel-generator/build-
propel.xml:263:1: No schema files were found (matching your schema
fileset definition).
----8<----
So I try:
> symfony propel-convert-yml-schema
> symfony propel-build-db
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<----
right back to the original problem, unable to propel-build-sql
I see a bug: http://trac.symfony-project.com/trac/ticket/1447 but this
pertains to having plugins, I have no plugins, the folders are empty
What's going on here? I can't post to the bug becuase I've forgotton
my trac login. But it seems odd that no-one has had a similar problem.
I feel I've exhasuted all avenues and have wasted a lot of time, what
next to try please?
Schema here:
http://bealers.com/schema.yml
I'm using php 5.2.3, MySQL 5.0.19 and symfony 1.0.5
Anyone?
--
Darren Beale
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
