Page 1 of 3
Upgrade - everything gone?
Posted: 26 Jan 2010, 11:40
by coendeurloo
I have upgraded my Phoca gallery from 2.5.x (not sure which one exactly) to the latest 2.6.2, and after uploading the package using the joomla installer, I got a blank page. After a refresh, the update went well according to the version number it now displays... but all my gallery data is GONE. What happened?
Also, the dutch language file (installed latest and greatest) doesn't seem to work properly:

Re: Upgrade - everything gone?
Posted: 26 Jan 2010, 11:52
by coendeurloo
It still seems to have the database info...I can see the images in the database. but how do I link it again so it also shows up in the phoca control panel?

Re: Upgrade - everything gone?
Posted: 26 Jan 2010, 12:19
by coendeurloo
When I set error reporting to maximum, on the frontend display I get this:
Code: Select all
Warning: Invalid argument supplied for foreach() in /customers/salamanders.nl/salamanders.nl/httpd.www/components/com_phocagallery/models/categories.php on line 138
And in the backend when I select for instance categories I get:
Code: Select all
Warning: Invalid argument supplied for foreach() in /customers/salamanders.nl/salamanders.nl/httpd.www/administrator/components/com_phocagallery/models/phocagallerycs.php on line 126
And in images:
Code: Select all
Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /customers/salamanders.nl/salamanders.nl/httpd.www/libraries/joomla/database/database/mysql.php on line 344
Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /customers/salamanders.nl/salamanders.nl/httpd.www/libraries/joomla/database/database/mysql.php on line 344
Re: Upgrade - everything gone?
Posted: 26 Jan 2010, 13:16
by Ronny
Hi,
it's stated at the News page of the Phoca website:
After upgrade of Phoca Gallery version 2.5.x (and older) to 2.6.0 go to Administration - Components - Phoca Gallery - Users and click on Authorize All button. Because in 2.6.0 there is a new feature (authorize images), you need to make all images, which were added before this version, authorized to display them in the frontend.
So probably your gallery isn't gone but it isn't authorized after the upgrade and therefore not shown.
Regarding the language file - maybe it isn't translated completely with the newly added features yet.
Regards,
Ronny
Re: Upgrade - everything gone?
Posted: 26 Jan 2010, 13:22
by coendeurloo
Ronny wrote:Hi,
it's stated at the News page of the Phoca website:
After upgrade of Phoca Gallery version 2.5.x (and older) to 2.6.0 go to Administration - Components - Phoca Gallery - Users and click on Authorize All button. Because in 2.6.0 there is a new feature (authorize images), you need to make all images, which were added before this version, authorized to display them in the frontend.
So probably your gallery isn't gone but it isn't authorized after the upgrade and therefore not shown.
Regarding the language file - maybe it isn't translated completely with the newly added features yet.
Regards,
Ronny
I already tried that the first time, since it was stated at the download link

But I got an error, see the image below. Also, the icons for Authorization are missing.

Re: Upgrade - everything gone?
Posted: 26 Jan 2010, 14:28
by coendeurloo
And I don't have any images showing up in the backend, so I wonder what it would 'authorize'. Since it doesn't display anything in the front- nor the backend, the system obviously doesn't recognize the old 2.5.x entries?
Re: Upgrade - everything gone?
Posted: 01 Feb 2010, 13:57
by Jan
Hi, check your tables in your database if all tables of Phoca Gallery are there, if all columns are there. Compare the tables and columns to install.bak file which you can find in ZIP installation file.
Jan
Re: Upgrade - everything gone?
Posted: 03 Feb 2010, 00:10
by coendeurloo
Code: Select all
#__phocagallery_user
#__phocagallery_img_comments
are not there... what should I do?
Re: Upgrade - everything gone?
Posted: 03 Feb 2010, 15:03
by Jan
Hi, you should install them manually on your server (e.g. with phpMyAdmin), see:
https://www.phoca.cz/documents/2-phoca-g ... em-solving
Jan
Re: Upgrade - everything gone?
Posted: 03 Feb 2010, 15:35
by coendeurloo
Thanks Jan,
I have created the missing tables and executed the updates from the bottom part of install.bak since my last version. I now have images in my control panel, so I guess something worked out allright.
However, I still have no images or categories in my control panel. The weird thing is though, when I go to images and to the categories drop down menu, it DOES show the categories:
