开发者

Column not found error in Criteria

I'm working on a symfony project and i need to query a many to many relationship, so i made this criteria based function to query the database:

开发者_C百科
    //Create Criteria Object
    $c1 = new Criteria();
    //Selecting the rows in the link table that matches the Table1 id (parameter)
    $c1->add(LinktablePeer::TBL1_CODIGO,$parameter,Criteria::EQUAL);
    //Selecting the rows in Table2 that matched with the last query
    $c1->addJoin(LinktablePeer::TBL2_CODIGO,Table2Peer::TBL2_CODIGO);
    $list = LinktablePeer::doSelect($c1);

but it throws me this strange error

[wrapped: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'link_table.ID' in 'field list']

Is strange because i have no column named ID in that table. Why is this happening? How can i fix it?

The question in other words:

Is there an option for the php symfony propel:build-model command that prevents generating the "ID" column for those tables that don't have a primary key? Thank you for your time ;)


I've found that the problem was the dump command task was trying to export a view in my mysql database. When I specifically defined the tables I wanted to export using -classes="...", the error went away.

For example:

symfony propel:data-dump --classes="{table},{tablew},..."  fixtures.yml
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜