Upload Back End Error in Joomla! 3.0

Phoca Download - download manager
TTR
Phoca Newbie
Phoca Newbie
Posts: 1
Joined: 03 Apr 2013, 18:12

Upload Back End Error in Joomla! 3.0

Post by TTR »

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?
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 48585
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Upload Back End Error in Joomla! 3.0

Post by Jan »

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
Post Reply