Hi,
After reading lots of forums, websites and symfony tutorial of course,
I remain having the same error again when I try to kink a profile to
my sfGuard User (with Doctrine).
Here is my code in schema.yml :
sfGuardUserProfile:
actAs: { Timestampable: ~ }
tableName: sf_guard_user_profile
columns:
id: { type: integer, notnull: true, autoincrement: true, primary:
true }
user_id: { type: integer(4) }
last_name: { type: string(100), notnull: true }
first_name: { type: string(100), notnull: true }
email: { type: string(100), notnull: true }
relations:
User:
class: sfGuardUser
foreignType: one
local: user_id
onDelete: CASCADE
foreignAlias: Profile
ForeignTable:
refClass: ForeignLinkTable
foreignAlias: sfGuardUsers
local: sf_guard_user_profile_id
foreign: event_id
And when i do a ./symfony doctrine:build-all-reload Here is what I
get:
SQLSTATE[42000]: Syntax error or access violation: 1072 Key column
'user_id' doesn't exist in table. Failing Query: CREATE TABLE
foreign_link_table (id BIGINT AUTO_INCREMENT, sf_guard_user_id BIGINT,
foreign_table_id BIGINT, gift_id BIGINT, created_at DATETIME,
updated_at DATETIME, INDEX sf_guard_user_id_idx (sf_guard_user_id),
INDEX foreign_table_id_idx (event_id), INDEX user_id_idx (user_id),
PRIMARY KEY(id)) ENGINE = INNODB
Any help on what's going on ? Can you also tell me how I can reference
my profile Id in its foreign tables ?
Thanks in advance,
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
