Errors after upgrade

[Vonaan]

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

[Benno]

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

[Vonaan]

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,

[Jan]

Hi, no there is no downgrade for the database

Jan

[Vonaan]

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,

[Vonaan]

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,

[Vonaan]

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,

[Jan]

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

Jan

[Vonaan]

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