History: Upgrade 1.7 to 1.8

            ^This page is only useful if you have a {MOUSEOVER(label="really old Tiki instance (pre 1.8.x)")}Tiki 1.8.0 was released on 2004-02-08 so it's highly unlikely that you still are running one.{MOUSEOVER}. Otherwise, see ((Upgrade))^

However, if you have a Tiki 1.7 installation, and would like to upgrade it to Tiki 3.x (or later), you still need to convert your database to Tiki 1.8.x format before converting to Tiki 3.x (or later) format.

Your database:
__Tiki 1.7.x  -> Tiki 1.8.x -> Tiki 1.9.x__ -> Tiki 3.x (or later)



! How to convert a Tiki database from 1.7.x to 1.8.x
!! 1-Get these three files
[http://tikiwiki.cvs.sourceforge.net/*checkout*/tikiwiki/tiki/db/tiki_1.7to1.8.sql?revision=1.110|tiki_1.7to1.8.sql]
[http://tikiwiki.cvs.sourceforge.net/*checkout*/tikiwiki/tiki/db/structure_fix_1.7to1.8.sql?revision=1.2|structure_fix_1.7to1.8.sql]
[http://tikiwiki.cvs.sourceforge.net/*checkout*/tikiwiki/tiki/db/comments_fix_1.7to1.8.sql?revision=1.2|comments_fix_1.7to1.8.sql]


!! 2- Backup your existing 1.7.x database (use the command [http://www.mysql.com/doc/en/mysqldump.html|mysqldump] or use [http://www.phpmyadmin.net/home_page/|phpMyAdmin])


!! 3- Run the upgrade scripts on your backup database
!!! 3a via phpmyadmin

__Scripts needed to upgrade from 1.7.x to 1.8__
#tiki_1.7to1.8.sql - this is the main upgrade script, it can be re-run as often as needed.
** Note: errors relating to "duplicate entry" are normal and can be safely ignored
#comments_fix_1.7to1.8.sql - only run this once on a 1.7 database, __then never again__
#structure_fix_1.7to1.8.sql - only run this once on a 1.7 database, __then never again__
#tiki_1.7to1.8.sql - rerun to fix forums (can be run multiple times)

!!!3b via shell (SSH) 
__Step by step:__
#mysql -f -u dbuser -p tikidb < tiki_1.7to1.8.sql
#mysql -f -u dbuser -p tikidb < comments_fix_1.7to1.8.sql
#mysql -f -u dbuser -p tikidb < structure_fix_1.7to1.8.sql
#mysql -f -u dbuser -p tikidb < tiki_1.7to1.8.sql (re-run again to fix Forums)


Congratulations!. You now have a Tiki 1.8.x format database.

You can now use the regular ((Upgrade)) instructions to take you to the latest version.