Phoca Forum

Hello,

I just upgraded to the last version op phoca gallery 2.7.4 .I also updated modules and plugins to the newest versions.

After the update, all photos seemed gone. I went to the joomla backend and see the actegories and images were not autorized. So i autorized them all. They started to appear again.

Then i went to my menu configuration (Phoca Gallery Category List Layout) and changed some details. The images disapeared again on the website (frontend). In fact i do only see the images that are for registered users, the public ones don't show anymore.

I tryed a lot of parameter changes but it don't seem to change. What could i possibly done wrong?

In debug mode, the following SQL do seem to work, it gives the right results :

SELECT cc.*, a.catid, COUNT(a.id) AS numlinks, u.username AS username, r.count AS ratingcount, r.average AS ratingaverage, uc.avatar AS avatar, uc.approved AS avatarapproved, uc.published AS avatarpublished, a.filename, a.exts, a.extm, a.extw, a.exth, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END AS slug
FROM jos_phocagallery_categories AS cc
LEFT JOIN jos_phocagallery AS a
ON a.catid = cc.id
AND a.published = 1
LEFT JOIN jos_phocagallery_user AS uc
ON uc.userid = cc.owner_id
LEFT JOIN jos_users AS u
ON u.id = cc.owner_id
LEFT JOIN jos_phocagallery_votes_statistics AS r
ON r.catid = cc.id
WHERE cc.published = 1
AND cc.approved = 1
AND cc.parent_id = 0
GROUP BY cc.id
ORDER BY cc.ordering ASC

Here is a link to the website that don't work anymore : http://www.ryuko-dojo.com/index.php?Ite ... categories
A other link on the same site, where i didn't change the menu link after the update (still works in some kind of way) : http://www.ryuko-dojo.com/index.php?Ite ... egory&id=4

Here is a screenshot of my global phoca configuration : http://www.ryuko-dojo.com/fichiers/phoc ... rences.png
Here is a screenshot of my link configuration : http://www.ryuko-dojo.com/fichiers/phoc ... meters.png


Thanks for your help.

Joannes De Koster

I didn't find any answer to my problem. I finally updated the parameters from the menu link in the jos_menu table with the old ones.
At least i got my images back as before but have to be carefull not to change any meny link options anymore...

There seems to be a lot of new options now. Maybe there is a conflict with old and new ones?

Bye.

Joannes

Hi, while upgrading or installing, the options will be completely overwritten (but in the file - in xml) not in the database. In database old values are saved and if you resave the parameter - new parameters values will be added to the old.

Jan