Please Help
Posted: 01 Aug 2013, 12:25
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
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