Thank you Alexander! I found that I could use your solution to combine
both schema files for sfGuard and sfSimpleForum into one file and it
worked. Then I ran into the problem where if when I wanted to test out
the sfSimpleBlog plugin, I no longer had the option of duplicating the
sfGuard schema into that schema as well. The main problem I realized
was this issue of having foreign keys across different schemas... once
I

So, for anyone having a similar problem with the error:

"Attempt to set foreign key to nonexistent table"

I found that I had to set propel.packageObjectModel to true in my
propel.ini:

propel.targetPackage                 = lib.model
propel.packageObjectModel        = true

That, along with verifying that each schema file was part of the
xxx.lib.model package, did the trick.

Thank you!

Helpful resources found along the way:
http://www.symfony-project.com/forum/index.php/m/31261/
http://www.symfony-project.com/snippets/snippet/170 (not needed if the
solution found in the forum works)




On Aug 2, 6:09 am, Alexander Deruwe <[EMAIL PROTECTED]> wrote:
> On 02 Aug 2007, at 00:40, Stereo wrote:
>
> > [propel-sql] Processing: generated-schema.xml
> > [propel-sql] Processing: generated-sfGuardPlugin-schema.xml
> > [propel-sql] Processing: generated-sfSimpleForumPlugin-schema.xml
> > Execution of target "sql-template" failed for the following reason: /
> > usr/local/php5/lib/php/symfony/vendor/propel-generator/build-
> > propel.xml:187:1: ERROR!! Attempt to set foreign key to nonexistent
> > table, sf_guard_user!
> > [phingcall] /usr/local/php5/lib/php/symfony/vendor/propel-generator/
> > build-propel.xml:187:1: ERROR!! Attempt to set foreign key to
> > nonexistent table, sf_guard_user!
>
> Add the following to your schema.yml:
>
> propel:
>    _attributes: { package: "plugins.sfGuardPlugin.lib.model" }
>    sf_guard_user:
>      _attributes: { phpName: sfGuardUser }
>      id:
>
> propel:
>    << your own schema goes here >>
>
> Now you can link to sf_guard_user and 'propel-build-all' should work
> just fine.
>
> Cheers,
>
> Alexander


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"symfony users" 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/symfony-users?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to