This forum is in READ-ONLY mode.
You can look around, but if you want to ask a new question, please use the new forum.
Home » plugins » User management plugins » sfForkedDoctrineApply extending schema problem
sfForkedDoctrineApply extending schema problem [message #97828] Thu, 22 April 2010 03:18 Go to next message
iceblock
Messages: 30
Registered: February 2009
Location: australia
Member
Using Symfony V1.4.

sfGuardUserProfile there's company_id field to identify which company user works for, and references to id field in Company table.

Prior to using this plugin, the Company field is a dropdown list filled with company names from Company table. After adding the plugin, the Company becomes a text input field with the Company's ID.

Here's how the schema is now defined after adding the plugin:

sfGuardUserProfile:
  inheritance:
    extends:            sfGuardUserProfileBasis
    type:               simple
  columns:
    company_id:         { type: integer, notnull: true }
    contact_phone:      { type: string(100) }
    remarks:            { type: clob }
  relations:
    User:
      class:            sfGuardUser
      foreign:          id
      local:            user_id
      onDelete:         cascade
      foreignType:      one
      foreignAlias:     Profile
    Company:            { local: company_id, foreign: id }


Is this problem due to table inheritance? Or there's some setup needs to be done but missed?
Re: sfForkedDoctrineApply extending schema problem [message #98247 is a reply to message #97828 ] Thu, 29 April 2010 08:59 Go to previous messageGo to next message
fizyk  is currently offline fizyk
Messages: 64
Registered: December 2009
Location: Western Slavic Republic
Member
Can you check that the field in database is integer? Also, can you create issue on github.com?
Re: sfForkedDoctrineApply extending schema problem [message #98296 is a reply to message #98247 ] Fri, 30 April 2010 02:06 Go to previous message
iceblock
Messages: 30
Registered: February 2009
Location: australia
Member
company_id column is bigint(20). Will create an issue.
Previous Topic:sfDoctrineGuard: update a sfGuardUser via Form results in Integrity constraint violation
Next Topic:sfForkedDoctrineApplyPlugin : Mail service required?
Goto Forum:
  

powered by FUDforum - copyright ©2001-2004 FUD Forum Bulletin Board Software