Hi.
I've installed Phoca Download for Joomla!3.0
It's all ok, but when I open Upload page on back-end interface there is an error (500)
This is the message:
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 aorpm_users AS a LEFT JOIN aorpm_phocadownload AS f ON f.owner_id = a.id LEFT JOIN aorpm_phocadownload_categories AS cc ON cc.id = f.catid LEFT JOIN aorpm_users AS ua ON ua.id=f.owner_id LEFT JOIN aorpm_users AS uc ON uc.id=f.checked_out LEFT JOIN (SELECT fa.owner_id, fa.id, count(*) AS countfaid FROM aorpm_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 aorpm_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 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 aorpm_users AS a LEFT JOIN aorpm_phocadownload AS f ON f.owner_id = a.id LEFT JOIN aorpm_phocadownload_categories AS cc ON cc.id = f.catid LEFT JOIN aorpm_users AS ua ON ua.id=f.owner_id LEFT JOIN aorpm_users AS uc ON uc.id=f.checked_out LEFT JOIN (SELECT fa.owner_id, fa.id, count(*) AS countfaid FROM aorpm_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 aorpm_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 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 aorpm_users AS a LEFT JOIN aorpm_phocadownload AS f ON f.owner_id = a.id LEFT JOIN aorpm_phocadownload_categories AS cc ON cc.id = f.catid LEFT JOIN aorpm_users AS ua ON ua.id=f.owner_id LEFT JOIN aorpm_users AS uc ON uc.id=f.checked_out LEFT JOIN (SELECT fa.owner_id, fa.id, count(*) AS countfaid FROM aorpm_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 aorpm_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
What happen?
Upload Back End Error in Joomla! 3.0
- Jan
- Phoca Hero
- Posts: 48587
- Joined: 10 Nov 2007, 18:23
- Location: Czech Republic
- Contact:
Re: Upload Back End Error in Joomla! 3.0
Hi, which Phoca Download version you are running? And where you get the error exactly?
If you find Phoca extensions useful, please support the project