[Doctrine] Erreur : "Unknown relation alias"
Bonjour,
J'ai deux tables qui sont relation.
La table Labelrubrique et Rubrique
lorsque je tape mon code
Code:
1 2 3 4 5 6
|
$this->label01 = Doctrine::getTable('labelrubrique')
->createQuery('lr')
->innerJoin('lr.rubrique r')
->where('lr.idrubrique = ?',1)
->execute(); |
j'ai l'erreur
throw new Doctrine_Table_Exception('Unknown relation alias ' . $alias);
et voici mon schema
Code:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53
|
Labelrubrique:
connection: doctrine
tableName: labelrubrique
columns:
idlabelrubrique:
type: integer(4)
fixed: false
unsigned: false
primary: true
autoincrement: true
idrubrique:
type: integer(4)
fixed: false
unsigned: false
primary: false
notnull: true
autoincrement: false
labelrubrique:
type: string(45)
fixed: false
unsigned: false
primary: false
notnull: false
autoincrement: false
lang:
type: string(45)
fixed: false
unsigned: false
primary: false
notnull: false
autoincrement: false
relations:
Rubrique:
local: idrubrique
foreign: idrubrique
type: one
Rubrique:
connection: doctrine
tableName: rubrique
columns:
idrubrique:
type: integer(4)
fixed: false
unsigned: false
primary: true
autoincrement: true
relations:
Labelrubrique:
local: idrubrique
foreign: idrubrique
type: many |
Merci d'avance