Upgrading Phoca Gallery 1.8.x to 1.8.8/2.0.2

[ep98]

the bug comes on:
PHP 5.2.5
MySQL 5.0.51-community-log

[code]
Phoca Gallery not successfully upgraded:
Error while updating HITS columnTable 'ep98_htroot.jos_phocagallery' doesn't exist SQL=SELECT * FROM `jos_phocagallery` LIMIT 1;
Table 'ep98_htroot.jos_phocagallery_categories' doesn't exist SQL=SELECT * FROM `jos_phocagallery_categories` LIMIT 1;
[/code]

Phoca Gallery upgrade procedure did not separate the database from the tables
columnTable 'ep98_htroot.jos_phocagallery' doesn't exist, in fact the database is ep98_htroot and the table is jos_phocagallery, I tought this bug is bcz 1.8.x was BETA for very long time, with the releasing of 2.0.1 Alpha I've tried the same upgrade ... no way.

Except this bug and the missing feature (importing from anything else as galleries), this is the best pickup for gallery solution with the best ever made framework of Joomla 1.5.

Keep up good work on Phoca Gallery

[Jan]

Hi, does this table "jos_phocagallery_categories" exists while uprading ?

[ep98]

For sure, Phoca Gallery not remove anything, but the upgrade procedure get the database name as prefix name, this will go to domain too (u probably keep old versions of your gallery) and will leave it to u

[Jan]

the upgrade procedure takes the joomla prefix this way:

Code: Select all

$db		= &JFactory::getDBO();
$dbPref 	= $db->getPrefix();

Code: Select all

$query = "ALTER TABLE `".$table."` ADD `".$column."` ".$attributes." AFTER `".$after."`";

table:

Code: Select all

$dbPref."phocagallery_categories"

Jan

[ep98]

You will see tomorrow on your own, I'm too tired right now to set a domain for Downloads and Gallery, but tomorrow morning this will be the first thing with the coffee