Bug #4245
Order by does not work on nested table relations
| Status: | Resolved | Start date: | 2009-08-14 | |
|---|---|---|---|---|
| Priority: | Must have | Due date: | ||
| Assignee: | Balisky Christophe | % Done: | 0% |
|
| Category: | sql_generator | Spent time: | - | |
| Target version: | - | |||
| Branch: | ||||
| Votes: | 0 |
Description
Unknown column 'tx_ardcrictransportdata_vehiclejourney.routeid.name' in 'order clause'
SELECT distinct tx_ardcrictransportdata_route_routeid.publishedname as 'routeid.publishedname',tx_ardcrictransportdata_route_routeid.name as 'routeid.name',tx_ardcrictransportdata_vehiclejourney.publishedjourneyname,tx_ardcrictransportdata_vehiclejourney.uid
FROM tx_ardcrictransportdata_vehiclejourney LEFT JOIN tx_ardcrictransportdata_route as tx_ardcrictransportdata_route_routeid ON tx_ardcrictransportdata_route_routeid.uid=tx_ardcrictransportdata_vehiclejourney.routeid
WHERE
1 AND tx_ardcrictransportdata_vehiclejourney.deleted=0 ORDER BY tx_ardcrictransportdata_vehiclejourney.routeid.name DESC LIMIT 0,40
require#76 // tslib_fe->INTincScript#438 // tslib_fe->INTincScript_process#3057 // tslib_cObj->USER#3118 // tslib_cObj->callUserFunction#757 // call_user_func_array#6076 // tx_metafeedit_user_feAdmin->user_init# // tx_metafeedit_user_feAdmin->displayEditScreen#729 // tx_metafeedit_user_feAdmin->displayListScreen#2780 // t3lib_DB->exec_SELECTquery#2108 // t3lib_DB->debug#238
History
Updated by Balisky Christophe almost 4 years ago
- Category set to sql_generator
- Status changed from New to Accepted
- Assignee set to Balisky Christophe
- Priority changed from Should have to Must have
Updated by Balisky Christophe over 3 years ago
- Status changed from Accepted to Resolved