Phoca Forum

Hi,

I ungraded to the latest stable version 2.7.3 and updated the database accordingly. No error messages where displayed during the upgrade. I now get this message:

Warning: Invalid argument supplied for foreach() in /var/www/01/17/41/ravenskeep.nl/www/Joomlakeep/administrator/components/com_phocagallery/models/phocagallerycs.php on line 126

when I open the Categories and no categories are displayed in the list. I get these messages:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/01/17/41/ravenskeep.nl/www/Joomlakeep/libraries/joomla/database/database/mysql.php on line 344

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/01/17/41/ravenskeep.nl/www/Joomlakeep/libraries/joomla/database/database/mysql.php on line 344

when I open the Users and no users are displayed in the list. Anyone any idea what goes wrong and how to fix it?

Regards,
Vonaan

Hi,
see: https://www.phoca.cz/documents/2-phoca-g ... Categories
Kind regards,
Benno

The only thing I see there is that I need to use Joomla 1.5 stable. I do use Joomla 1.5.10 stable. I guess I need to delete the current PhocaGallery installation, install the old version and reload all the pictures again and change all the settings again

I suppose there is no downgrade tool that also undoes all the MySQL changes?

Regards,

Hi, no there is no downgrade for the database

Jan

Ive done some more investigation. It seems to me I have a MySQL related problem. Perhaps the changes to the database done by the update script have not been executed correctly due to version levels. I host the Joomla installetion at an ISP they provide me with Debian, PHP 4.4.2-1.1 and MySQL 4.0.24. Is that sufficient for the new Phoca Gallery version?

Regards,

By the way, can somebody please provide me with the new database table structures in order for me to check the current database and manually execute the changes if needed.

Regards,

Hi,

Where can I get the 2.6 version for downloading? I need to downgrade from 2.7. This latest version apparently doesn't work with my ISP installation.

Regards,

Hi, see:
http://joomlacode.org/gf/project/phocag ... ge_id=3942

Jan

Hi Jan,

Thx for the link. I have tried to install older version, all the down to 2.0.0. Most of them generate MySQL errors during installation. They are having compatibility problems with SQL table creation scripts. I need to contact my ISP. It must be the old MySQL engine they are hosting.

I found an old 1.5.5.beta version. That works fine.....

Regards,
Peter