Error on postgreSQL

[leandroeiro]

I have many errors with phocadownload in postgresql

when i try create categories:

Code: Select all

 JLIB_DATABASE_QUERY_FAILED SQL=SELECT a.*,l.title AS language_title,uc.name AS editor,ag.title AS access_level,c.title AS parentcat_title, c.id AS parentcat_id,cc.countid AS countid FROM `jgovce_phocadownload_categories` AS a LEFT JOIN `jgovce_languages` AS l ON l.lang_code = a.language LEFT JOIN jgovce_users AS uc ON uc.id=a.checked_out LEFT JOIN jgovce_viewlevels AS ag ON ag.id = a.access LEFT JOIN jgovce_phocadownload_categories AS c ON c.id = a.parent_id LEFT JOIN (SELECT cc.parent_id, count(*) AS countid FROM jgovce_phocadownload_categories AS cc GROUP BY cc.parent_id ) AS cc ON a.parent_id = cc.parent_id WHERE (a.published IN (0, 1)) GROUP BY a.id ORDER BY a.title asc 

when i try upload;

Code: Select all

JLIB_DATABASE_QUERY_FAILED 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 jgovce_users AS a LEFT JOIN jgovce_phocadownload AS f ON f.owner_id = a.id LEFT JOIN jgovce_phocadownload_categories AS cc ON cc.id = f.catid LEFT JOIN jgovce_users AS ua ON ua.id=f.owner_id LEFT JOIN jgovce_users AS uc ON uc.id=f.checked_out LEFT JOIN (SELECT fa.owner_id, fa.id, count(*) AS countfaid FROM jgovce_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 jgovce_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.username asc JLIB_DATABASE_QUERY_FAILED 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 jgovce_users AS a LEFT JOIN jgovce_phocadownload AS f ON f.owner_id = a.id LEFT JOIN jgovce_phocadownload_categories ..

any option on phoca download appears error

Joomla 3.1.5

[Jan]

Hi, unfortunately, I don't have any experiences with postgreSQL, Phoca Download only includes mysql data (they can be used in other database systems but as they are optimized for mysql, in case of problem, they needs to be customized)

Jan