Phoca Download 2.0.0 RC [BUG]
Posted: 11 Feb 2011, 12:05
Tab Users returns
[code]
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 jos_users AS a
LEFT JOIN jos_phocadownload AS f ON f.owner_id = a.id
LEFT JOIN jos_phocadownload_categories AS cc ON cc.id = f.catid
LEFT JOIN jos_users AS ua ON ua.id=f.owner_id
LEFT JOIN jos_users AS uc ON uc.id=f.checked_out
LEFT JOIN (SELECT fa.owner_id, fa.id, count(*) AS countfaid FROM jos_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 jos_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 uc.name asc
[/code]
With clean install or upgrade from 2.0.0 Beta 1 to RC.
Instead of the user table, in 2.0.0 BETA1 this bug is not existing.
And question regarding the update. Is there will a be a smooth version for upgrading from 1.3.7 way of Sections/Categories to Categories/Sub-categories in 2.0.0 ?
[code]
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 jos_users AS a
LEFT JOIN jos_phocadownload AS f ON f.owner_id = a.id
LEFT JOIN jos_phocadownload_categories AS cc ON cc.id = f.catid
LEFT JOIN jos_users AS ua ON ua.id=f.owner_id
LEFT JOIN jos_users AS uc ON uc.id=f.checked_out
LEFT JOIN (SELECT fa.owner_id, fa.id, count(*) AS countfaid FROM jos_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 jos_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 uc.name asc
[/code]
With clean install or upgrade from 2.0.0 Beta 1 to RC.
Instead of the user table, in 2.0.0 BETA1 this bug is not existing.
And question regarding the update. Is there will a be a smooth version for upgrading from 1.3.7 way of Sections/Categories to Categories/Sub-categories in 2.0.0 ?
