Please Help

[rasulli]

I recently started using Phoca Download with Joomla 3.0.

When I try to open Upload File at Phoca Control Panel, I get the following error, is one there to help? Thanks!

The error message is as follow:


An error has occurred.
500 Column 'username' in order clause is ambiguous SQL=SELECT a.*,f.id as file_id,cc.id as category_id,ua.id AS userid, ua.username AS username, ua.name AS usernameno,uc.name AS editor,fa.countfaid,fn.countfnid FROM joom_users AS a LEFT JOIN joom_phocadownload AS f ON f.owner_id = a.id LEFT JOIN joom_phocadownload_categories AS cc ON cc.id = f.catid LEFT JOIN joom_users AS ua ON ua.id=f.owner_id LEFT JOIN joom_users AS uc ON uc.id=f.checked_out LEFT JOIN (SELECT fa.owner_id, fa.id, count(*) AS countfaid FROM joom_phocadownload AS fa WHERE fa.approved = 1 GROUP BY fa.owner_id) AS fa ON a.id = fa.owner_id LEFT JOIN (SELECT fn.owner_id, fn.id, count(*) AS countfnid FROM joom_phocadownload AS fn WHERE fn.approved = 0 GROUP BY fn.owner_id) AS fn ON a.id = fn.owner_id WHERE a.id > 0 AND (fa.countfaid > 0 OR fn.countfnid > 0) GROUP BY a.id ORDER BY username asc, a.id asc Column 'username' in order clause is ambiguous SQL=SELECT a.*,f.id as file_id,cc.id as category_id,ua.id AS userid, ua.username AS username, ua.name AS usernameno,uc.name AS editor,fa.countfaid,fn.countfnid FROM joom_users AS a LEFT JOIN joom_phocadownload AS f ON f.owner_id = a.id LEFT JOIN joom_phocadownload_categories AS cc ON cc.id = f.catid LEFT JOIN joom_users AS ua ON ua.id=f.owner_id LEFT JOIN joom_users AS uc ON uc.id=f.checked_out LEFT JOIN (SELECT fa.owner_id, fa.id, count(*) AS countfaid FROM joom_phocadownload AS fa WHERE fa.approved = 1 GROUP BY fa.owner_id) AS fa ON a.id = fa.owner_id LEFT JOIN (SELECT fn.owner_id, fn.id, count(*) AS countfnid FROM joom_phocadownload AS fn WHERE fn.approved = 0 GROUP BY fn.owner_id) AS fn ON a.id = fn.owner_id WHERE a.id > 0 AND (fa.countfaid > 0 OR fn.countfnid > 0) GROUP BY a.id ORDER BY username asc, a.id asc LIMIT 0, 20 Column 'username' in order clause is ambiguous SQL=SELECT a.*,f.id as file_id,cc.id as category_id,ua.id AS userid, ua.username AS username, ua.name AS usernameno,uc.name AS editor,fa.countfaid,fn.countfnid FROM joom_users AS a LEFT JOIN joom_phocadownload AS f ON f.owner_id = a.id LEFT JOIN joom_phocadownload_categories AS cc ON cc.id = f.catid LEFT JOIN joom_users AS ua ON ua.id=f.owner_id LEFT JOIN joom_users AS uc ON uc.id=f.checked_out LEFT JOIN (SELECT fa.owner_id, fa.id, count(*) AS countfaid FROM joom_phocadownload AS fa WHERE fa.approved = 1 GROUP BY fa.owner_id) AS fa ON a.id = fa.owner_id LEFT JOIN (SELECT fn.owner_id, fn.id, count(*) AS countfnid FROM joom_phocadownload AS fn WHERE fn.approved = 0 GROUP BY fn.owner_id) AS fn ON a.id = fn.owner_id WHERE a.id > 0 AND (fa.countfaid > 0 OR fn.countfnid > 0) GROUP BY a.id ORDER BY username asc, a.id asc

[Jan]

Hi, which version of Joomla!, Phoca Download your are exactly running? If not the latest, update to latest and let me know if the problem persists. In which view you get the problem, can you copy the link before clicking it (the link to view where you get the error)

Thank you, Jan