Hi,
Not sure if this or the doctrine newsgroup is the right place to post
this question/bug.
It's about the doctrine admin generator for the symfony backend.
As described at page 157 of the Jobeet tutorial Symfony 1.3, Doctrine
1.2 I wanted to modify the list (of auctions).
/apps/backend/auctions/config/generator.yml:
[...]
config:
[...]
list:
title: List of all auctions
display: [is_active, =product, ends, starts, min_price, user]
sort: [ends, desc]
object_actions:
_edit: ~
table_method: retrieveBackendAuctionList
/lib/model/AuctionsTable.class.php:
[...]
public function retrieveBackendAuctionList(Doctrine_Query $q)
{
$rootAlias = $q->getRootAlias();
$q ->andWhere('(isnull('.$rootAlias.'.starts) OR ' . $rootAlias .
'.starts<NOW())')
->andWhere($rootAlias.'.ends>NOW()')
;
return $q;
}
The Error:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'r.starts' in
'where clause'. Failing Query: "SELECT COUNT(*) AS `num_results` FROM
`auctions` `a` WHERE (isnull(r.starts) OR `a`.`starts` < NOW()) AND
`a`.`ends` > NOW()"
As you can see, it's the same variable $rootAlias ... so it's replaced
once by "r" and the other two times by "a" as table alias.
Any ideas? Thanks :)
Florian
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
