Can´t see and edit my categories after upgrade to 2.6.0

[cookie]

Hi,
I´ve just upgraded Phoca Gallery from 2.5.6 to 2.6.0, because I saw the picasa option is implemented now and because the editor gallery button is working now for me.

Updating went well, success was shown, but i can´t see and can´t edit my categories now.

The error is:
Warning: Invalid argument supplied for foreach() in /var/www/.../components/com_phocagallery/models/phocagallerycs.php on line 126

I´m running on the latest joomla version and everything else works well. MySQL and PHP are quite a bit old, but it´s upon my provider to update them, I can´t do that.

I have more than 1000 pictures in more then 200 categories
When I select pictures I can see all pictures and I can see the category names, where they resides in. If I click now on a category, I´ll get the same error as above.

What´s wrong? Any hint?

BTW What´s the common used language in this forum? I speak English, German and Czech, so I can post in any of these languages...

Thanks Martin

[Jan]

Hi, check the tables and columns in your database (compare it with install.bak file which you can find in installation ZIP file). Check if all tables and all columns were installed.

Jan

[cookie]

Jan,
hadn´t time to check, but just did it. All tables are ok, except one: phocagallery_user_category.
This table does not exist, instead phocagallery_user_category_tmp exists with three fields: id, catid and userid, and this table is empty.

BTW the phocagallery_user table is also empty.
phocagallery has 1118 entries and phocagallery_categories 225, both are ok, this is the exact number of photos and categories I have.

Any ideas, what I can do?
I´ve tried and copied phocagallery_user_category_tmp to phocagallery_user_category, so it does exist, but the error is still the same.

Thanks
Martin

[Jan]

Hi, this
phocagallery_user_category_tmp is obsolete table but it cannot be removed (because upgrading process need to have some information) so don't care about this table.

Seem all OK with your tables Did you check the columns? (I mean not rows) I mean checking the columns name with columns which you can see in install.bak file?

[cookie]

Jan, as I just mentioned in my other post as a reply to dee and you, it works after an downgrade to gallery 2.5.8
Your version of phoca gallery starting with 2.6.0 isn´t compatible to mysql 4 anymore.
Bad for me, cause I can´t upgrade to mysql 5. Maybe a solution, that you make it compatible again? Phoca Gallery is the best imaging tool I´ve found for joomla, I like it very much, but i can´t use your newer version.

BTW thanks for your replies, without the hints, I would never solve the problem

Ahoj
Martin

[cricrist]

Hi,
Just to say that I have exactly the same problem (error messages you've mentionned)and i've downgraded to phocagallery 2.5.8.
My mysql version is worth than yours, it's 3.23, but as far as now I've always succeeded in installing phocagallery.
Hope to find an issue...