Learn how easy it is to sync an existing GitHub or Google Code repo to a SourceForge project! See Demo

Close

#565 Illegal order clauses

open
nobody
None
5
2009-11-13
2009-11-13
conw
No

V2.7/MySQL. See also: http://www.bitweaver.org/forums/index.php?t=12040
The following statement from the GMap package envokes an error message:
[code]
SELECT bm.*, lc.`content_id`, lc.`title`, lc.`data`, lcds.`data` AS `summary`, lc.`format_guid`, lc.`last_modified`, lc.`created`, lc.`version` ,gks.`security_id`, gks.`security_description`, gks.`is_private`, gks.`is_hidden`, gks.`access_question`, gks.`access_answer` , geo.`lat`, geo.`lng`, geo.`amsl`, geo.`amsl_unit` FROM `bwgmaps` bm INNER JOIN `bwliberty_content` lc ON( lc.`content_id` = bm.`content_id` ) LEFT OUTER JOIN `bwliberty_content_data` lcds ON (lc.`content_id` = lcds.`content_id` AND lcds.`data_type`='summary') LEFT OUTER JOIN `bwgatekeeper_security_map` cg ON (lc.`content_id`=cg.`content_id`) LEFT OUTER JOIN `bwgatekeeper_security` gks ON (gks.`security_id`=cg.`security_id` ) LEFT JOIN `bwgeo` geo ON ( lc.`content_id`=geo.`content_id` ) WHERE lc.`content_type_guid` = 'bitgmap' ORDER BY lc.`gmap_id` DESC LIMIT 0,50
#### ERROR CODE: Errno: 1054 Message: Unknown column 'lc.gmap_id' in 'order clause'
[/code]
Indeed, there isn't any column 'gmap_id' in table liberty_content. Moreover, it looks like more order clauses than this one use illegal columns.

Discussion