Actions

Difference between revisions of "Upgrading 1.6.5 to 1.7"

From Joomla! Documentation

(Manual Upload/Installation)
(Fixed reference to dead page for migration 1.5 > 1.6+, now 1.5 > 2.5)
(47 intermediate revisions by 9 users not shown)
Line 1: Line 1:
 
{{JVer|1.6}}{{JVer|1.7}}
 
{{JVer|1.6}}{{JVer|1.7}}
  
Joomla! 1.7 is the first major Joomla! release that aims to provide users with a seamless method for easily updating their sites, without any difficult, or time consuming upgrade processes.  With the new 6 Month Release Cycle from the Joomla! Project, sequential Joomla! versions will be easily updated in your site.  There are several methods you can use to upgrade your site, three to be exact.  We’ll take a look at each one of them starting with the easiest one, and ending with the most involved method.  These methods are only for current 1.6 users. If your Joomla! site is on 1.5.x, take a look at this tutorial that will walk you through migrating your site from 1.5 to 1.7
+
Joomla! 1.7 introduces a [[#Quick_Update | Quick Update]] for sites already up-to-date with Joomla 1.6.5 or 1.6.6.
  
==Update Manager==
+
If your site is not already at 1.6.5 or 1.6.6, or you prefer not to use the [[#Quick_Update | Quick Update]], there are several other options:
  
The new update manager in Joomla! 1.6 has been utilized to provide “one click updates” for Joomla! users. In order to perform this operation, Joomla! users will have to already be on the latest Joomla! 1.6 version (1.6.5). For those users already using Joomla! 1.6.5, the following steps will easily update your site to 1.7.0
+
* [[#Installation_Manager | Traditional Update using the Installation Manager]]
 +
* [[Upgrading from 1.6.4 or earlier|Sites on 1.6.0 - 1.6.4]]
 +
* [[#Manual_Upload.2FInstallation | Manual Update for 1.6.5/1.6.6]]
 +
* [[Migrating from Joomla 1.5 to Joomla 2.5]]
  
{{ambox|image=notice|style=notice|text=If you are not using this latest version, use [[Upgrading 1.6 from an existing 1.6x version|this tutorial]] to get from your current 1.6 version, to 1.7.}}
+
== Quick Update ==
  
Log in to your Joomla! administrator control panel (www.example.com/administrator), and access the '''Extensions''' > '''Extensions Manager''' option in your administration menu.  From here, go to the ‘Update’ tab.  You should see a list of available updates for Joomla!, and any additional components that use the new udpate method. If there are no updates listed there, simply click the ‘Purge Cache’ button in the top right toolbar, then click the ‘Find Updates’ button to refresh the list of available updates.  You should now see an item in the list to update your site to Joomla! 1.7
+
For sites already up-to-date running Joomla 1.6.5, upgrading to Joomla 1.7 is now very easy.
  
{{ambox|image=notice|style=notice|text=If you still don’t see an upgrade option there, use the process described in the next section.}}
+
Before you begin:
  
To update your site, simply check the box next to the 1.7 update option, and click ‘Update’!
+
* Check that all installed extensions are compatible with Joomla 1.7 by checking the JED Listing or developer site.
 +
 
 +
* [[Backup | Backup]] the website files and database.
 +
 
 +
1. In the Administrator, select the '''Extensions-Extensions Manager''' Menu item.
 +
 
 +
[[Image:1-Extensions-ExtensionManager.png]]
 +
 
 +
2. Click the '''Update''' Sub menu.
 +
 
 +
[[Image:2-Extension-Update.png]]
 +
 
 +
3. Click the '''Purge Cache''', then '''Find Updates''' Buttons in the Button Bar located in the upper right of the page.
 +
 
 +
[[Image:3-Extension-Manager-Update.png]]
 +
 
 +
4. Click the checkbox to the left of the Joomla line containing the latest Version Number and, next, press the Update Button in the Button Bar.  
 +
 
 +
'''Be patient while the system downloads and replaces the necessary files.''' This can take several minutes or could update very quickly, depending on your system.
 +
 
 +
[[Image:4-Update-Joomla.png]]
 +
 
 +
5. When the update has finished, you will be presented with this page.
 +
 
 +
[[Image:6-Final.png]]
 +
 
 +
'''That's it!''' Follow these simple instructions next time you upgrade. Now, it's to keep your Joomla website up-to-date and safe!
  
 
==Installation Manager ==
 
==Installation Manager ==
  
If you aren’t comfortable with using the Update Manager yet to update your site, you’re still ok!  There are more easy options to update your site.  The second method to update your Joomla! 1.6.5 site to 1.7.0 is to use the extension installer, just as if you were installing a component, module, plugin, or template in your site.
+
If you aren’t yet comfortable with using the Update Manager to update your site, you’re still ok!  There are more easy options to update your site.  The second method to update your Joomla! 1.6.5/1.6.6 site to 1.7.0 is to use the extension installer, just as if you were installing a component, module, plugin, or template in your site. '''This method is specially handy for users updating localized distributions made available by Language Communities.'''
  
To update your site using this method, first, download the update package from JoomlaCode.  The 1.6.5 > 1.7.0 package can be found here.
+
To update your site using this method, first, download the update package from JoomlaCode (or your language Community Site).  The 1.6.5/1.6.6 > 1.7.0 package can be found [http://joomlacode.org/gf/project/joomla/frs/?action=FrsReleaseBrowse&frs_package_id=5986 here].
  
{{ambox|image=notice|style=notice|text=If you are not currently on Joomla! 1.6.5, use this tutorial to update your site to 1.6.5, then resume the process of updating to 1.7}}
+
{{ambox|image=notice|style=notice|text=If you are not currently on Joomla! 1.6.5/1.6.6, use [[Upgrading 1.6 from an existing 1.6x version|this tutorial]] to update your site to 1.6.5/1.6.6, then resume the process of updating to 1.7}}
  
After you download the update package, access your Joomla! installer by logging in to your adminstrator control panel, and navigating to the '''Extensions''' > '''Extension Manager''' option in your administrator menu.  From here you can select the file you just downloaded, and install it.  The Joomla! installer will upload the package, and install it, making any changes to files or the database as needed.
+
After you download the update package, access your Joomla! installer by logging in to your administrator control panel, and navigating to the '''Extensions''' > '''Extension Manager''' option in your administrator menu.  From here you can select the file you just downloaded, and install it.  The Joomla! installer will upload the package, and install it, making any changes to files AND the database as needed.
  
 
== Manual Upload/Installation ==
 
== Manual Upload/Installation ==
  
The last method available to update your site, involves a little more technical expertise, and should probably only be used if the previous methods won’t work due to a highly complex site. For most Joomla! sites, the first two methods will successfully update your site.  However, updating is still fairly easily, and should not be a problem.
+
The last method available to update your site, involves a little more technical expertise, and should probably only be used if the previous methods won’t work due to a highly complex site or hosting issues (shared hosting for example). ''' As usual back-up your site and your database.''' For most Joomla! sites, the first two methods will successfully update your site.  However, updating is still fairly easily, and should not be a problem.
 +
 
 +
Before you begin, go to global configuration and on the server tab and in the Database Settings area find the database table prefix used by your site.
 +
 
 +
To update your site manually, you will need to download the 1.6.5 > 1.7.0 update package from JoomlaCode.  You can download it [http://joomlacode.org/gf/project/joomla/frs/?action=FrsReleaseBrowse&frs_package_id=5986 here].  Unpack the package and you will find two zip files in it. You will only need the large zip file called <tt>Joomla_1.7.0-Stable-Update_Package.zip</tt> for your update. Using an ftp client, upload the zip file to your server into the root directory of your website, and unpack the files.  This will over-write any modified files with new, updated files for 1.7.0.  Alternatively, you can unpack the <tt>Joomla_1.7.0-Stable-Update_Package.zip</tt> on your local computer, then copy the un-packed files into your websites root, overwriting the modified files.
 +
 
 +
After unpacking the files to your website you need to manually delete the files and folders listed in administrator/components/com_admin/script.php.
 +
 
 +
This is the list of files:
 +
 
 +
*<tt>/templates/atomic/css/blueprint/src/blueprintcss-0-9-1-cheatsheet-3-5-3-gjms.pdf</tt>
 +
*<tt>/administrator/manifests/packages/joomla.xml</tt>
 +
*<tt>/administrator/templates/bluestork/css/rounded.css</tt>
 +
*<tt>/administrator/templates/bluestork/css/norounded.css</tt>
 +
*<tt>/administrator/templates/bluestork/images/j_corner_bl.png</tt>
 +
*<tt>/administrator/templates/bluestork/images/j_header_right_rtl.png</tt>
 +
*<tt>/administrator/templates/bluestork/images/j_crn_br_dark.png</tt>
 +
*<tt>/administrator/templates/bluestork/images/j_crn_br_black.png</tt>
 +
*<tt>/administrator/templates/bluestork/images/j_crn_tr_black.png</tt>
 +
*<tt>/administrator/templates/bluestork/images/j_crn_bl_dark.png</tt>
 +
*<tt>/administrator/templates/bluestork/images/j_crn_tr_med.png</tt>
 +
*<tt>/administrator/templates/bluestork/images/j_crn_bl_light.png</tt>
 +
*<tt>/administrator/templates/bluestork/images/j_header_right.png</tt>
 +
*<tt>/administrator/templates/bluestork/images/j_crn_br_light.png</tt>
 +
*<tt>/administrator/templates/bluestork/images/j_crn_tl_black.png</tt>
 +
*<tt>/administrator/templates/bluestork/images/j_crn_bl_black.png</tt>
 +
*<tt>/administrator/templates/bluestork/images/j_crn_tr_dark.png</tt>
 +
*<tt>/administrator/templates/bluestork/images/j_crn_bl_med.png</tt>
 +
*<tt>/administrator/templates/bluestork/images/j_header_left.png</tt>
 +
*<tt>/administrator/templates/bluestork/images/j_crn_tl_med.png</tt>
 +
*<tt>/administrator/templates/bluestork/images/j_crn_tl_dark.png</tt>
 +
*<tt>/administrator/templates/bluestork/images/j_crn_br_med.png</tt>
 +
*<tt>/administrator/templates/bluestork/images/j_crn_tl_light.png</tt>
 +
*<tt>/administrator/templates/bluestork/images/j_crn_tr_light.png</tt>
 +
*<tt>/administrator/templates/bluestork/images/j_corner_br.png</tt>
 +
*<tt>/administrator/templates/bluestork/images/j_header_left_rtl.png</tt>
 +
*<tt>/administrator/templates/hathor/html/com_modules/module/modal.php</tt>
 +
*<tt>/administrator/templates/hathor/html/com_modules/module/edit_assignment.php</tt>
 +
*<tt>/administrator/templates/hathor/html/com_menus/item/edit_modules.php</tt>
 +
*<tt>/administrator/templates/hathor/html/com_menus/items/default_batch.php</tt>
 +
*<tt>/administrator/templates/hathor/html/com_languages/language/edit.php</tt>
 +
*<tt>/administrator/templates/hathor/html/com_content/article/edit_metadata.php</tt>
 +
*<tt>/administrator/templates/hathor/html/com_categories/category/edit_metadata.php</tt>
 +
*<tt>/administrator/templates/hathor/html/com_categories/categories/default_batch.php</tt>
 +
*<tt>/administrator/components/com_menus/models/forms/item_options.xml</tt>
 +
*<tt>/administrator/language/overrides/xx-XX.override.ini</tt>
 +
*<tt>/administrator/help/helpsites-16.xml</tt>
 +
*<tt>/administrator/help/en-GB/Components_Content_Categories_Edit.html</tt>
 +
*<tt>/administrator/help/en-GB/Components_Weblinks_Categories_Edit.html</tt>
 +
*<tt>/administrator/help/en-GB/Components_Newsfeeds_Categories_Edit.html</tt>
 +
*<tt>/administrator/help/en-GB/Components_Banners_Categories_Edit.html</tt>
 +
*<tt>/administrator/help/en-GB/Components_Contact_Categories_Edit.html</tt>
 +
*<tt>/media/editors/codemirror/css/docs.css</tt>
 +
*<tt>/media/editors/tinymce/jscripts/tiny_mce/tiny_mce_gzip.js</tt>
 +
*<tt>/media/editors/tinymce/jscripts/tiny_mce/tiny_mce_gzip.php</tt>
 +
*<tt>/media/editors/tinymce/jscripts/tiny_mce/plugins/media/css/content.css</tt>
 +
*<tt>/media/mod_languages/images/ta.gif</tt>
 +
*<tt>/libraries/joomla/config.php</tt>
 +
*<tt>/libraries/joomla/import.php</tt>
 +
*<tt>/libraries/joomla/version.php</tt>
 +
 
 +
And these folders:
 +
 
 +
*<tt>/plugins/authentication/example</tt>
 +
*<tt>/plugins/user/example</tt>
 +
*<tt>/plugins/content/example</tt>
 +
*<tt>/plugins/extension/example</tt>
 +
*<tt>/administrator/templates/hathor/html/com_modules/select</tt>
 +
*<tt>/administrator/templates/hathor/html/com_media</tt>
 +
*<tt>/administrator/templates/hathor/html/mod_popular</tt>
 +
*<tt>/administrator/templates/hathor/html/mod_status</tt>
 +
*<tt>/administrator/templates/hathor/html/mod_latest</tt>
 +
*<tt>/administrator/components/com_weblinks/helpers/html</tt>
 +
*<tt>/media/editors/tinymce/jscripts/tiny_mce/plugins/pagebreak/css</tt>
 +
*<tt>/media/editors/tinymce/jscripts/tiny_mce/plugins/pagebreak/img</tt>
 +
*<tt>/media/editors/tinymce/jscripts/tiny_mce/plugins/example</tt>
 +
 
 +
 
 +
After you have done this you need to manually update your site's database. To do so locate the file <tt>installation/sql/mysql/joomla_update_17ga.sql</tt>, or the files <tt>/administrator/components/com_admin/sql/updates/mysql/1.7.0-2011-06-06.sql and administrator/components/com_admin/sql/updates/mysql/1.7.0-2011-06-06-2.sql</tt>.
  
To update your site manually, you will need to download the 1.6.5 > 1.7.0 update package from JoomlaCode.  You can download it here.  Using an ftp client, upload the zip files to your server into the root directory of your website, and unpack the files.  This will over-write any modified files with new, updated files for 1.7.0.  Alternatively, you can unpack the download on your local computer, then copy the un-packed files into your websites root, overwriting the modified files.
+
As of July 16th 2011 the file(s) contains:
  
After unpacking the files to your website you need to manually delete the files and folders listed in dministrator/components/com_admin/script.php
+
<source lang="sql">ALTER TABLE `#__languages` ADD COLUMN `ordering` int(11) NOT NULL default 0 AFTER `published`;
 +
ALTER TABLE `#__languages` ADD INDEX `idx_ordering` (`ordering`);
 +
</source>
 +
<source lang="sql">CREATE TABLE IF NOT EXISTS `#__associations` (
 +
  `id` VARCHAR(50) NOT NULL COMMENT 'A reference to the associated item.',
 +
  `context` VARCHAR(50) NOT NULL COMMENT 'The context of the associated item.',
 +
  `key` CHAR(32) NOT NULL COMMENT 'The key for the association computed from an md5 on associated ids.',
 +
  PRIMARY KEY `idx_context_id` (`context`, `id`),
 +
  INDEX `idx_key` (`key`)
 +
) DEFAULT CHARSET=utf8;
  
After ou have done this you need to manually update your sites database. To do so locate the file installation/sql/mysql/joomla_update_17ga.sql.
+
</source>
  
Inside you will fine parts like "#__languages". Replace the pound sign and the first underscore with your databases prefix. By default this is jos_. To find what your site uses, open your sites configuration.php and search for $dbprefix the string inside the single quotes behind is what you're looking for. So out of "#__languages" you need to make "jos_langauges" and so on.
+
Inside you will find parts like <code>#__languages</code> and <code>#__associations</code>. Replace the pound sign and the first underscore (<code>#_</code>) with your [[Database Table Prefix|database tables prefix]]. By default this is <code>jos</code>. If you didn't get the prefix before starting, open your site's <tt>configuration.php</tt> and search for <code>$dbprefix</code>. The string inside the single quotes behind it is what you're looking for. So you need to change <code>#__languages</code> to <code>jos_languages</code> and so on.
  
Once you've done this go to your sites phpmyadmin and open the database your site uses. There will be a tab called SQL, open this. Paste the content of your modified joomla_update_17ga.sql inside the text area and press go.
+
Once you've done this go to your site's phpmyadmin (or any way you usually manage your database) and open the database your site uses. There will be a tab called SQL, open this. Paste the content of your modified <tt>joomla_update_17ga.sql</tt> inside the text area and press go.
  
 
Your site is now updated to Joomla 1.7.
 
Your site is now updated to Joomla 1.7.

Revision as of 21:46, 26 January 2012

Joomla 1.6Joomla 1.7

Joomla! 1.7 introduces a Quick Update for sites already up-to-date with Joomla 1.6.5 or 1.6.6.

If your site is not already at 1.6.5 or 1.6.6, or you prefer not to use the Quick Update, there are several other options:

Quick Update

For sites already up-to-date running Joomla 1.6.5, upgrading to Joomla 1.7 is now very easy.

Before you begin:

  • Check that all installed extensions are compatible with Joomla 1.7 by checking the JED Listing or developer site.
  • Backup the website files and database.

1. In the Administrator, select the Extensions-Extensions Manager Menu item.

1-Extensions-ExtensionManager.png

2. Click the Update Sub menu.

2-Extension-Update.png

3. Click the Purge Cache, then Find Updates Buttons in the Button Bar located in the upper right of the page.

3-Extension-Manager-Update.png

4. Click the checkbox to the left of the Joomla line containing the latest Version Number and, next, press the Update Button in the Button Bar.

Be patient while the system downloads and replaces the necessary files. This can take several minutes or could update very quickly, depending on your system.

4-Update-Joomla.png

5. When the update has finished, you will be presented with this page.

6-Final.png

That's it! Follow these simple instructions next time you upgrade. Now, it's to keep your Joomla website up-to-date and safe!

Installation Manager

If you aren’t yet comfortable with using the Update Manager to update your site, you’re still ok! There are more easy options to update your site. The second method to update your Joomla! 1.6.5/1.6.6 site to 1.7.0 is to use the extension installer, just as if you were installing a component, module, plugin, or template in your site. This method is specially handy for users updating localized distributions made available by Language Communities.

To update your site using this method, first, download the update package from JoomlaCode (or your language Community Site). The 1.6.5/1.6.6 > 1.7.0 package can be found here.

After you download the update package, access your Joomla! installer by logging in to your administrator control panel, and navigating to the Extensions > Extension Manager option in your administrator menu. From here you can select the file you just downloaded, and install it. The Joomla! installer will upload the package, and install it, making any changes to files AND the database as needed.

Manual Upload/Installation

The last method available to update your site, involves a little more technical expertise, and should probably only be used if the previous methods won’t work due to a highly complex site or hosting issues (shared hosting for example). As usual back-up your site and your database. For most Joomla! sites, the first two methods will successfully update your site. However, updating is still fairly easily, and should not be a problem.

Before you begin, go to global configuration and on the server tab and in the Database Settings area find the database table prefix used by your site.

To update your site manually, you will need to download the 1.6.5 > 1.7.0 update package from JoomlaCode. You can download it here. Unpack the package and you will find two zip files in it. You will only need the large zip file called Joomla_1.7.0-Stable-Update_Package.zip for your update. Using an ftp client, upload the zip file to your server into the root directory of your website, and unpack the files. This will over-write any modified files with new, updated files for 1.7.0. Alternatively, you can unpack the Joomla_1.7.0-Stable-Update_Package.zip on your local computer, then copy the un-packed files into your websites root, overwriting the modified files.

After unpacking the files to your website you need to manually delete the files and folders listed in administrator/components/com_admin/script.php.

This is the list of files:

  • /templates/atomic/css/blueprint/src/blueprintcss-0-9-1-cheatsheet-3-5-3-gjms.pdf
  • /administrator/manifests/packages/joomla.xml
  • /administrator/templates/bluestork/css/rounded.css
  • /administrator/templates/bluestork/css/norounded.css
  • /administrator/templates/bluestork/images/j_corner_bl.png
  • /administrator/templates/bluestork/images/j_header_right_rtl.png
  • /administrator/templates/bluestork/images/j_crn_br_dark.png
  • /administrator/templates/bluestork/images/j_crn_br_black.png
  • /administrator/templates/bluestork/images/j_crn_tr_black.png
  • /administrator/templates/bluestork/images/j_crn_bl_dark.png
  • /administrator/templates/bluestork/images/j_crn_tr_med.png
  • /administrator/templates/bluestork/images/j_crn_bl_light.png
  • /administrator/templates/bluestork/images/j_header_right.png
  • /administrator/templates/bluestork/images/j_crn_br_light.png
  • /administrator/templates/bluestork/images/j_crn_tl_black.png
  • /administrator/templates/bluestork/images/j_crn_bl_black.png
  • /administrator/templates/bluestork/images/j_crn_tr_dark.png
  • /administrator/templates/bluestork/images/j_crn_bl_med.png
  • /administrator/templates/bluestork/images/j_header_left.png
  • /administrator/templates/bluestork/images/j_crn_tl_med.png
  • /administrator/templates/bluestork/images/j_crn_tl_dark.png
  • /administrator/templates/bluestork/images/j_crn_br_med.png
  • /administrator/templates/bluestork/images/j_crn_tl_light.png
  • /administrator/templates/bluestork/images/j_crn_tr_light.png
  • /administrator/templates/bluestork/images/j_corner_br.png
  • /administrator/templates/bluestork/images/j_header_left_rtl.png
  • /administrator/templates/hathor/html/com_modules/module/modal.php
  • /administrator/templates/hathor/html/com_modules/module/edit_assignment.php
  • /administrator/templates/hathor/html/com_menus/item/edit_modules.php
  • /administrator/templates/hathor/html/com_menus/items/default_batch.php
  • /administrator/templates/hathor/html/com_languages/language/edit.php
  • /administrator/templates/hathor/html/com_content/article/edit_metadata.php
  • /administrator/templates/hathor/html/com_categories/category/edit_metadata.php
  • /administrator/templates/hathor/html/com_categories/categories/default_batch.php
  • /administrator/components/com_menus/models/forms/item_options.xml
  • /administrator/language/overrides/xx-XX.override.ini
  • /administrator/help/helpsites-16.xml
  • /administrator/help/en-GB/Components_Content_Categories_Edit.html
  • /administrator/help/en-GB/Components_Weblinks_Categories_Edit.html
  • /administrator/help/en-GB/Components_Newsfeeds_Categories_Edit.html
  • /administrator/help/en-GB/Components_Banners_Categories_Edit.html
  • /administrator/help/en-GB/Components_Contact_Categories_Edit.html
  • /media/editors/codemirror/css/docs.css
  • /media/editors/tinymce/jscripts/tiny_mce/tiny_mce_gzip.js
  • /media/editors/tinymce/jscripts/tiny_mce/tiny_mce_gzip.php
  • /media/editors/tinymce/jscripts/tiny_mce/plugins/media/css/content.css
  • /media/mod_languages/images/ta.gif
  • /libraries/joomla/config.php
  • /libraries/joomla/import.php
  • /libraries/joomla/version.php

And these folders:

  • /plugins/authentication/example
  • /plugins/user/example
  • /plugins/content/example
  • /plugins/extension/example
  • /administrator/templates/hathor/html/com_modules/select
  • /administrator/templates/hathor/html/com_media
  • /administrator/templates/hathor/html/mod_popular
  • /administrator/templates/hathor/html/mod_status
  • /administrator/templates/hathor/html/mod_latest
  • /administrator/components/com_weblinks/helpers/html
  • /media/editors/tinymce/jscripts/tiny_mce/plugins/pagebreak/css
  • /media/editors/tinymce/jscripts/tiny_mce/plugins/pagebreak/img
  • /media/editors/tinymce/jscripts/tiny_mce/plugins/example


After you have done this you need to manually update your site's database. To do so locate the file installation/sql/mysql/joomla_update_17ga.sql, or the files /administrator/components/com_admin/sql/updates/mysql/1.7.0-2011-06-06.sql and administrator/components/com_admin/sql/updates/mysql/1.7.0-2011-06-06-2.sql.

As of July 16th 2011 the file(s) contains:

ALTER TABLE `#__languages` ADD COLUMN `ordering` int(11) NOT NULL DEFAULT 0 AFTER `published`;
ALTER TABLE `#__languages` ADD INDEX `idx_ordering` (`ordering`);
CREATE TABLE IF NOT EXISTS `#__associations` (
  `id` VARCHAR(50) NOT NULL COMMENT 'A reference to the associated item.',
  `context` VARCHAR(50) NOT NULL COMMENT 'The context of the associated item.',
  `key` CHAR(32) NOT NULL COMMENT 'The key for the association computed from an md5 on associated ids.',
  PRIMARY KEY `idx_context_id` (`context`, `id`),
  INDEX `idx_key` (`key`)
) DEFAULT CHARSET=utf8;

Inside you will find parts like #__languages and #__associations. Replace the pound sign and the first underscore (#_) with your database tables prefix. By default this is jos. If you didn't get the prefix before starting, open your site's configuration.php and search for $dbprefix. The string inside the single quotes behind it is what you're looking for. So you need to change #__languages to jos_languages and so on.

Once you've done this go to your site's phpmyadmin (or any way you usually manage your database) and open the database your site uses. There will be a tab called SQL, open this. Paste the content of your modified joomla_update_17ga.sql inside the text area and press go.

Your site is now updated to Joomla 1.7.