Upgrading Phoca Gallery

Some useful articles about FTP downloading and uploading:

• How to upload (download) files to (from) server via FTP
• How to set permissions on files and folders

Download the newest Phoca Gallery version from the Phoca Gallery download site. You get a ZIP file. Unzip this file into your temporary folder on your disc. You get these files and folders:

• [assets]
• [controllers]
• [elements]
• [front]
• [help]
• [helpers]
• [language]
• [libraries]
• [models]
• [other]
• [tables]
• [views]
• admin.phocagallery.php
• config.xml
• controller.php
• index.html
• install.bak
• install.sql
• install.phocagallery.php
• phocagallery.xml
• uninstall.sql
• uninstall.phocagallery.php

Copy all files and folders except folders: front, language, other into:

• your-server/administrator/components/com_phocagallery/

Copy all files and folders from folder front into:

• your-server/components/com_phocagallery/

Copy all files and folders from folder language into:

• your-server/language/
• your-server/administrator/language/

While copying your files you need to accept the overwritting previously installed files.

Updating the MySql database after a manual upgrade

If you are upgrading Phoca Gallery with help of FTP method, you need to be aware as in new version there can be new database tables or new columns in database tables.

You need to open the install.bak file which you can find in root of the installation ZIP file and compare it with your database. E.g. with help of phpMyAdmin tool. In install.bak file you can see which new tables and columns were added in previous versions. So if some table doesn't exists in your database and you can see the SQL query for this table in install.bak file, just run this query (query for creating one table) so this table will be added into your database (Don't run all the queries as they can overwrite your current data in your site, which means deleting all your data).

You can see the upgrade sql queries too (upgrading columns in tables). If you compare the table in your database with SQL query of the install.bak file and you will recognize that some columns don't exists in your tables, you need to run the SQL upgrade queries (which are prepared at the end of the install.bak file). After copying and pasting the queries into phpMyAdmin you need to remove comments characters (-- at the begin of the line) and you need to modify the prefixes.

Upgrading the tables:

Because the names of tables are prepared for system installation, so they contain '#__' instead of your table prefix, you have to rename them:

• #__phocagallery to TablePrefix_phocagallery
• #__phocagallery_categories to TablePrefix_phocagallery_categories, etc.
  

TablePrefix is the prefix you selected while installing Joomla! CMS (it is mostly 'jos_' and it should differentiate the Joomla! tables from other tables used in your database). Make sure that you delete #_ at the start of the line; you only need one _ {underscore}.

Upgrading the columns:

If you have all tables in your database (e.g. you are upgrading from 2.1.0 to 2.2.0) check the columns of your tables. E.g. in Phoca Gallery version 2.2.0 there are new colums: extlink1, extlink2 and these should be added into table: #__phocagallery. In case you are upgrading e.g. from 2.1.0 to 2.2.0 and you got some error message while automatically upgrading of Phoca Gallery tables, check the #_phocagallery table and if extlink1 or extlink2 columns aren't included, then run the SQL query for 2.2.0 version:

ALTER TABLE `#__phocagallery` ADD `extlink1` text NOT NULL AFTER `params` ;
ALTER TABLE `#__phocagallery` ADD `extlink2` text NOT NULL AFTER `extlink1` ;

If you're upgrading to 2.2.2 then run also the SQL query for the 2.2.2 version:

ALTER TABLE `#__phocagallery_categories` ADD `date` datetime NOT NULL default '0000-00-00 00:00:00' AFTER `description` ;