Errors during updating from 1.8.x to 1.8.8

[nutmeg]

Good Day All

I would first like to thank you for your work on this gallery.

Joomla! Version: 1.5.4
PHP Version: 5.2.2
Database Version: 4.1.22-standard

When doing an upgrade from Phoca Gallery 1.8.x beta to 1.8.8 beta I received the following errors and the only way to correct was to uninstall and reinstall as new, of course this deleted all my gallery's, not good. Is there a fix.

Joomla admin area:

Phoca Gallery not successfully upgraded:
Table 'nutmegw2_xxxxxxx.jos_phocagallery' doesn't exist SQL=SELECT * FROM `jos_phocagallery` LIMIT 1;
Table 'nutmegw2_xxxxxxxx.jos_phocagallery_categories' doesn't exist SQL=SELECT * FROM `jos_phocagallery_categories` LIMIT 1;

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/xxxxxxxxx/public_html/j15/libraries/joomla/database/database/mysql.php on line 338

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/xxxxxxxxx/public_html/j15/libraries/joomla/database/database/mysql.php on line 338

Warning: Invalid argument supplied for foreach() in /home/xxxxxxxxx/public_html/j15/administrator/components/com_phocagallery/helpers/phocagallery.php on line 1216

In Gallery front end:

Warning: Invalid argument supplied for foreach() in /home/xxxxxxxxx/public_html/j15/components/com_phocagallery/helpers/phocagallery.php on line 612

Thank You for any help on this
Dave G

[Jan]

Hi,
did you removed the database tables? While upgrading Phoca Gallery looks at the tables in the database, it seems like it didn't found them ...

Jan

[nutmeg]

Hi Jan

I believe I followed the upgrade information for 1.8.x correctly.

I went to the joomla 1.5 admin Extension Manager and removed the Phoca Gallery component, I then installed the new component, the install went fine, I then clicked the Update Button that's when I received the errors.

It was a stock install as I was test and did not change any settings.

As far as I know I did not remove any db tables.

Thank You
Dave G

[Jan]

If you have removed the component, the data in database will be lost... the Upgrading must be done without uninstallation of previous version

The data of Phoca gallery are missed now...

[nutmeg]

Jan

Thanks I thought I read some where on the forum to uninstall and reinstall luckily it was just my test site and did not have a lot of pictures in it. After looking at your documentation on "Upgrading Phoca Gallery" it does clearly state not to uninstall.

Thank You for your time maybe I shouldn't do this kind of thing late at night.

Dave G

[Jan]

After looking at your documentation on "Upgrading Phoca Gallery" it does clearly state not to uninstall

... I have added it after reading your post

[nutmeg]

Thanks that should help us old people who don't see to well

I have on other item I found in my testing I hope I can explain it correctly.

I turned off thumbnail creating, don't ask me why, in the Joomla 1.5.4/phoca 1.8.8 config area. I then tried to delete a group of images in a gallery. When I clicked the Delete button, phoca gallery went into a create thumbnail mode and created, not deleted, as many blank thumbnails as I was trying to delete I then turned on the create thumbnails in the config and was able to delete them. Not sure if this is a bug or not but it had me stumped for a while?

Thanks
Dave G

[Jan]

If you delete the images (from the database), it is possible that e.g. 3 images use the same thumbnail, so while deleting the thumbnail will be deleted, but created for other images which use the same thumbnail... so this can happen, if one thumbnail is used by more images (filenames in the database)... If I trying it now, I can delete the images with automatically thumbnail creating off without problems ???

Jan