hi,
I want to have an i18n searchable job posting so I came up with this
model:
[CODE]OpenJob:
tableName: open_job
actAs:
Timestampable:
I18n:
fields: [title, description]
actAs:
Searchable:
fields: [title, description]
Sluggable:
unique: true
fields: [title]
columns:
id:
type: integer(8)
primary: true
unsigned: true
notnull: true
autoincrement: true
user_id:
type: integer(4)
notnull: true
category_id:
type: integer(4)
unsigned: true
notnull: true
is_active:
type: boolean
notnull: true
default: true
title:
type: string(45)
notnull: true
description:
type: clob(65535)
notnull: true
is_abuse:
type: boolean
notnull: true
default: false
relations:
Category:
local: category_id
foreign: id
foreignAlias: OpenJobs
onDelete: restrict
onUpdate: restrict
sfGuardUser:
local: user_id
foreign: id
foreignAlias: OpenJobs
onDelete: cascade
onUpdate: restrict
[/CODE]
the classes are generated, but when i try to load fixtures I get a
foreign key error [CODE] SQLSTATE[23000]: Integrity constraint
violation: 1452 Cannot add or update a child row: a foreign key
constraint fails (`myDbDEV/open_job_translation`, CONSTRAINT
`open_job_translation_ibfk_1` FOREIGN KEY (`id`) REFERENCES
`open_job_translation_index` (`id`))
[/CODE]
If I put the serchable behaviour outside i18n
[CODE]OpenJob:
tableName: open_job
actAs:
Timestampable:
Searchable:
fields: [title, description]
I18n:
fields: [title, description]
actAs:
Sluggable:
unique: true
fields: [title]
[/CODE]
then it all works with no error, but this is not what I need... It's
pretty useless to index primary and foreign keys.
Do you know how to solve this?
thanks a lot
Marco
--~--~---------~--~----~------------~-------~--~----~
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
symfony-users+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/symfony-users?hl=en
-~----------~----~----~----~------~----~------~--~---
