Phoca and Postgres.

[gigipuscarie]

Hi, Im using your wonderful components and plugins for some time, Im familiar with them but now I have a Joomla site that had to be installed on a server with postgresql. Unfortunately, Phoca Gallery and Phoca Download dont work anymore. It is strange, but on wikipedia says that they support Postgres also. Do you have any solutions? The error message is, offcourse, a "wrong sql statement" since that statement is probably written for mysql.

[Jan]

Hi, unfortunately I don't have any experience with Postgres, do you get some specific error? Maybe some sql part is not compatible with postgres

Jan

[gigipuscarie]

Installing Phoca Gallery says is installed ok:
"Message

Folder images\phocagallery\ created!
Folder images\phocagallery\avatars\ created!


Installing component was successful."

But when I try to go to"Categories" from the control panel of the Gallery I get this error:

An error has occurred.
0 Database query failed (error # %s): %s 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,ua.id AS userid, ua.username AS username, ua.name AS usernameno,v.average AS ratingavg,cc.countid AS countid FROM
`bgb50_phocagallery_categories` AS a LEFT JOIN `bgb50_languages` AS l ON l.lang_code = a.language LEFT JOIN bgb50_users AS uc ON uc.id=a.checked_out LEFT JOIN bgb50_viewlevels AS ag ON ag.id = a.access LEFT JOIN bgb50_phocagallery_categories AS c ON c.id = a.parent_id LEFT JOIN bgb50_users AS ua ON ua.id = a.owner_id LEFT JOIN bgb50_phocagallery_votes_statistics AS v ON v.catid = a.id LEFT JOIN (SELECT cc.parent_id, count(*) AS countid FROM bgb50_phocagallery_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


Images:

An error has occurred.
0 Database query failed (error # %s): %s SQL=SELECT COUNT(a.id) AS count FROM bgb50_phocagallery AS a WHERE approved = 0 LIMIT 1 OFFSET 0


And so on. I cannot understant it either. I worked a bit in the last years with postgres and I use regullar sql queries that work very well on mysql and postgres. I think is the implementation of Joomla 3.1 having issues with postgres because a lot of other joomla external plugins/components have problems under postgres, is not just your Phoca Gallery. Too bad I cannot use it for this project...

[Jan]

Hmmm, really no idea what can be wrong there (there is no clue error message )

Jan

[gigipuscarie]

From my point of view there are 2 solutions (none of them in your power): 1. Joomla is going to remove the "3.0" from all the extensions that dont work with Postgres (like 95% of the extensions probably) or 2. Simply drop the Postgres support and only keep MySQL.

I think you agree with me that if you see an extension in the extensions directory saying 3.0 it should naturally support Postgres. Once again an amateur movement from the Joomla team (is not the first).