Aliance call error. - Githubissues

What steps will reproduce the problem?
1. Open the Eve Component Account manager

What is the expected output? What do you see instead?

Expected to see alliance information or the corporation info.

Error returned for alliance:

Unknown table 'c' in order clause SQL=SELECT al.*, editor.name AS editor FROM 
(`jos_eve_alliances` AS `al`) LEFT JOIN `jos_users` AS `editor` ON 
al.checked_out=editor.id 
ORDER BY c.name ASC LIMIT 0, 20 Unknown table 'c' in order clause SQL=SELECT 
al.*, 
editor.name AS editor FROM (`jos_eve_alliances` AS `al`) LEFT JOIN `jos_users` 
AS `editor` ON 
al.checked_out=editor.id ORDER BY c.name ASC

Error returned for corporations:

Unknown table 'c' in order clause SQL=SELECT co.*, al.name AS allianceName, 
al.shortName, 
editor.name AS editor FROM (`jos_eve_corporations` AS `co`) LEFT JOIN 
`jos_eve_alliances` AS 
`al` ON al.allianceID=co.allianceID LEFT JOIN `jos_users` AS `editor` ON 
co.checked_out=editor.id ORDER BY c.name ASC LIMIT 0, 20 Unknown table 'c' in 
order clause 
SQL=SELECT co.*, al.name AS allianceName, al.shortName, editor.name AS editor 
FROM 
(`jos_eve_corporations` AS `co`) LEFT JOIN `jos_eve_alliances` AS `al` ON 
al.allianceID=co.allianceID LEFT JOIN `jos_users` AS `editor` ON 
co.checked_out=editor.id 
ORDER BY c.name ASC

What version of the product are you using? On what operating system?
Joomla 1.5, joomla in eve, R86

Please provide any additional information below.

Original issue reported on code.google.com by omgfy...@gmail.com on 14 Feb 2010 at 6:23

EVE-SECURE / joomla-in-eve

Aliance call error. #6