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:

Image

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?

Image

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.

Image

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:

Image