Upgrade to new Version of Garys Cookbook 3.X.x.

If you're not experienced please be careful. Please post your experiences.

1. Preparations
2. Upgrade with the help of the new Installation-Package (Re-Installation)
3. Manual Upgrade from an extracted Installation-Package


1. Preparations

I know there are a lot of other ways to do this, but then you absolutly have to know what you're doing. This should be a short help to non-experienced users with a productive System. Two ways will be described, 2. Upgrade with the help of the Installation-Package (Re-Installation), 3. Manual Upgrade from an unpacked Installation-Package.

1.1 Download the latest Installation-Package from http://www.vb-dozent.net/
If there are new Language-Installation-Files or Language-Files (.ini) available for your Languages. Please download.

Set Gary´s Cookbook offline in the Configuration of the Cookbook on the Administration Pages.

1.2 Backup
It's a very good Idea to make a Backup of all your Joomla-Data before installing new Versions, or if you manually maintain your Database. Backup the Database with a Tool, for example with phpMyAdmin. Also copy your Joomla-Directories to a Backup-Directory, local or on your Server.

To upgrade Garys Cookbook 3.X.x you should at least backup the following Data:

Backup (export) the Garys Kochbuch Data from the Joomla Database with a Tool. Here the phpMyAdmin Version 2.11.5 with Standardconfiguration is used. With other Versions or Configurations there might be some differences.

1.2.1 The Tables (xxx = your Joomla Prefix)
xxx_garyscookbook
xxx_garyscookbook_comments
xxx_gkb_voting_log

These Tables may be exported together .
In phpMyAdmin choose your Joomla-Database and export from the Menu. Then choose exactly those Tables from the selectionlist. SQL is as standard marked, if not please mark.

Those settings work fine for me.
Add custom comment .... empty
Enclose export in a transaction: nor marked
Disable foreign key checks: not marked
SQL compatibility mode: NONE

If Structure marked is - remove!!

Those settings work fine for me.
Data: marked
Complete inserts: marked
Extended inserts: marked
Maximal length of created query: 5000
Use delayed inserts : not marked
Use ignore inserts: not marked
Use hexadecimal for BLOB: marked
Export type: INSERT

Then you mark the Save as file.
File name template is standard set to: "__DB__" and remember template is marked.
You are also able to choose a Data-Compression if you export larger Tables.

Click on Go and the Result is downloaded. You should change the filename to something understandable to your download.

1.2.2. Specialcase Categories, Tablename: xxx_categories. (xxx = your Joomla Prefix)

Choose the Table in your Joomla-Database and then SQL in the Menu.
Enter : SELECT * FROM `xxx_categories` WHERE `section` ='com_garyscookbook'
Click on Go. Now you should only see the Categories of the Cookbook. If ok.

Click on export in the footer. Then you'll see a screen almost the same as above (1.2.1). Enter the same settings and click on Go to download. You should change the filename to something understandable to your download.

1.2.3. Copy (download) from your Joomla-Directory :

from your "joomla-path/administrator/components/com_garyscookbook": config.garyscookbook.php (Configuration File)

If you've changed the Country/Region List : from your "joomla-path/administrator/components/com_garyscookbook/helpers": gkb.country.php

If you've made changes to the Language-Files: backup the changed files from "your joomla-path/administrator/language/" and/or "your joomla-path/language" directory; xx-XX.com_garyscookbook.ini where xx-XX is the language-code.

Your Recipe-Picture Directories (to be found in your configuration)
e.g. standard: "your joomla-path/components/com_garyscookbook/cookbookpictures/" +
img_pictures and
img_thumbnails
and depending on configuration
img_categories

(If you have changed the path-settings, "components/com_garyscookbook/cookbookpictures", to a path outside of the component you don't absolutly have to download the Picture-directories. But it's always a good idea to have a backup of your Recipe-pictures)

I hope that's it.

2. Upgrade with the help of the Installation-Package (Re-Installation)

2.1 Remove Garys Cookbook 3.X.x.
After the Backup-step uninstall the Component. In the Backend-Menu choose Extensions - Install/Uninstall - Components Mark Garys Cookbook and choose Uninstall, above to the right. And as supposed the Component will be deinstalled.

2.2 Install the new relase of Garys Cookbook 3.X.x
If Step 2.1 was OK, go on and open the downloaded new Installation-Package in the Joomla-Administration (Backend), Extensions -> Install/Uninstall and run it.

2.3. Check the Databasetables before importing data

2.3.1 Check that the Tables (xxx = your Joomla Prefix)
xxx_garyscookbook
xxx_garyscookbook_comments
xxx_gkb_voting_log
are empty.

In the Databaseview the Records must be "0" . If not, delete the entries. Mark the tables after another and click on Empty (Trash).

2.3.2 Also check the Table xxx_categories. (xxx = your Joomla Prefix)

Choose the Table in your Joomla-Database and then SQL in the Menu.
Enter : SELECT * FROM `xxx_categories` WHERE `section` ='com_garyscookbook'
Click on Go. Now you should only see the Categories of the Cookbook. If ok.
If you now see one or more Cookbook-Categories (only!), click on "Check All" beneath of the Table-entries. Then on Delete (X) to the right.

2.4. Import the saved data

2.4.1 Import the Data to the Joomla-Database.
In phpMyAdmin choose your Joomla-Database. Then click on import in the Menu.
Click on "Lookup" ("Durchsuchen" is shown by me also when working in english!) search your exported file to import. I use the following settings:
Character set of the file: utf8
Allow interrupt of import ..: marked
Number of record ... : 0,
SQL: marked
SQL compatibility mode: NONE

Click on Go.

Repeat for second File.

2.4.2 Upload the Backup Data to your Joomla-Directory:

To your " joomla-path/administrator/components/com_garyscookbook":
config.garyscookbook.php Your configurations.

If you've changed the Country/Region List
to "your joomla-path/administrator/components/com_garyscookbook/helpers":
gkb.country.php

Upload your saved Recipe-Picture Directories (see your configuration)
if they are to be found in the com_garyscookbook Path.
e.g. standard: "your joomla-path/components/com_garyscookbook/cookbookpictures/" +
img_pictures and
img_thumbnails
and depending on configuration
img_categories

2.4.3 New Language-Installation-Packages
If new Language-Installation-Packages are available, delete the old Language-Files, xx-XX.com_garyscookbook.ini where xx-XX is the language-code,from your "joomla-path/administrator/language" and/or "your joomla-path/language" Directory.
Then open the downloaded Packages in the Joomla-Administration (Backend), Extensions -> Install/Uninstall and run them.

2.4.4 Changed Language-Files
If you've made changes to the Language-Files. Check if the new Language-Files have new and/or changed Entries. Edit your own Language-Files.

Upload your own Files to "your joomla-path/administrator/language" and/or "your joomla-path/language" Directory overriding the Standard-Files, xx-XX.com_garyscookbook.ini where xx-XX is your language-code.

2.5 Configuration, activation and test

Open the Component in the Joomla-Administration (Backend), Components -> Gary's Cookbook.
Choose Settings. Go through all Parameters of the Component to Customize your own Site with possible new settings. Save the Configuration.

As always, test the new Version!

3. Manual Upgrade from an extracted Installation-Package.

3.1 Backup / Unpack
Backup the data as described above. It's not necessary to backup the Data from the Databasetables! Unpack the downloaded Installation-Package to a local directory.

3.2 Upload unpacked Files.
Upload the new Data to the Server from the directories of the unpacked Installation:

3.2.1 Choose all directories and files beneath directory admin. Upload all those files to "your Joomla-directory/administrator/components/com_garyscookbook/"

3.2.2 Choose all directories and files except admin and languages. Upload all those files to "your Joomla-directory/components/com_garyscookbook/"

3.2.3 Languages

3.2.3.1 Choose the Language-Directory. In the admin Directory you'll find the Languagefiles for the Administrator-Pages.Upload "your" languages to "your Joomla-directory/administrator/language/" and "your Joomla-directory/language" directory xx-YY.

3.2.3.2 Changed Language-Files
If you've made changes to the Language-Files. Check if the new Language-Files have new and/or changed Entries. Edit your own Language-Files.

Upload your own Files to "your Joomla-directory/administrator/language" and/or "your Joomla-directory/language" Directory overriding the Standard-Files, xx-XX.com_garyscookbook.ini where xx-XX is your language-code.

3.3 Upload the Backup Data to your Joomla-Directory:

To "your Joomla-directory/administrator/components/com_garyscookbook":
config.garyscookbook.php Your configurations.

If you've changed the Country/Region List:
to "your Joomla-directory/administrator/components/com_garyscookbook/helpers":
gkb.country.php

Upload your saved Recipe-Picture Directories (see your configuration)
if they are to be found in the com_garyscookbook Path and have been overridden with the Installation steps.
e.g. standard: "your joomla-path/components/com_garyscookbook/cookbookpictures/" +
img_pictures and
img_thumbnails
and depending on configuration
img_categories

3.4 Configuration, activation

Open the Component in the Joomla-Administration (Backend), Components -> Gary's Cookbook.
Choose Settings. Go through all Parameters of the Component to Customize your own Site with possible new settings. Save the Configuration.

3.5 Database upgrade to new Version.

Open the Component in the Joomla-Administration (Backend), Components -> Gary's Cookbook.
Choose "Upgrade table to Gary's Cookbook 3.X.x.
If the Database-Tables have been changed, they will be upgraded to the new Version with this step.

3.6 Test the new Version

As always, test the new Version!

That's it I think!