[Tickets #6814] Re: problem of upgrade turba from 2.1.7 to 2.2

[bugs at horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/6814
-----------------------------------------------------------------------
 Ticket             | 6814
 Updated By         | david at tmv.gov.tw
 Summary            | problem of upgrade turba from 2.1.7 to 2.2
 Queue              | Turba
 Version            | 2.2
 Type               | Bug
 State              | Feedback
 Priority           | 1. Low
 Milestone          |
 Patch              |
 Owners             | Michael Rubinsky
-----------------------------------------------------------------------


david at tmv.gov.tw (2008-06-04 17:48) wrote:

Here are the complete upgrade shell sripts:

#!/bin/bash
Wait () {
  echo -n "$STEP  Done!!"
  echo
}

HORDE="/usr/local/apache/horde-rc"
HD="/root/bin/upgrade-horde3.2"
S_DB="horde317"
D_DB="horde32
# Share not stable for SQL in Horde-3.2
USE_SHARE="N"

cd $HD

STEP="Duplicate Database"
echo "Duplicate Database from $S_DB to $D_DB"
echo "DROP DATABASE $D_DB;" >/tmp/Recreate_db.sql
echo "CREATE DATABASE $D_DB;" >>/tmp/Recreate_db.sql
mysql </tmp/Recreate_db.sql
/usr/local/bin/mysqldump --opt $S_DB >/tmp/$S_DB.sql
mysql $D_DB </tmp/$S_DB.sql
Wait

# HORDE
STEP="Horde upgrade scripts"
cd $HORDE/scripts/upgrades
mysql $D_DB<./3.1_to_3.2.mysql.sql
case $USE_SHARE in
y|Y)
   echo -n " processing ..."
   php -f ./convert_datatree_groups_to_sql.php
   php -f ./convert_datatree_perms_to_sql.php
   ;;
esac
Wait

# NAG
STEP="Nag upgrade scripts"
cd $HORDE/nag/scripts/upgrades
mysql $D_DB<./2.1_to_2.2.sql
php -f ./2006-04-18_add_creator_and_assignee_fields.php
mysql $D_DB<$HD/upg_nag.sql
case $USE_SHARE in
y|Y)
   echo -n " processing ..."
   php -f ./convert_datatree_shares_to_sql.php
   ;;
esac

Wait

# MNEMO
STEP="Mmemo upgrade scripts"
cd $HORDE/mnemo/scripts/upgrades
mysql $D_DB<./2.1_to_2.2.sql
case $USE_SHARE in
y|Y)
   echo -n " processing ..."
   php -f ./convert_datatree_shares_to_sql.php
   ;;
esac

Wait

# TREAN
STEP="Trean upgrade scripts"
cd $HORDE/trean/scripts/sql
mysql $D_DB<trean.sql
cd $HORDE/trean/scripts/upgrades
php -f ./2006-12-29_sql_bookmarks.php
php -f ./2006-12-29_cleanup.php
Wait

# WHUPS
STEP="Whups upgrade scripts"
cd $HORDE/whups/scripts/upgrades
mysql $D_DB <./2006-07-12_add_due_date.sql
mysql $D_DB <./2006-08-04_drop_subjectlist.sql
mysql $D_DB <./2007-01-16_add_queries.sql
mysql $D_DB <./2007-01-16_add_ticket_dates.sql
mysql $D_DB <./2007-01-16_drop_searches.sql
php -f ./2007-01-16_query_share_updates.php
php -f ./2007-01-16_cache_calculated_dates.php
mysql $D_DB <./2007-01-20_add_indexes.sql
mysql $D_DB <./2007-09-07_rename_listeners_table.sql
mysql $D_DB <./2007-12-09_add_slugs.sql
mysql $D_DB <./2007-12-12_additional_indexes.sql
mysql $D_DB <./2008-02-27_add_defaults.sql
case $USE_SHARE in
y|Y)
   echo -n " processing ..."
   mysql $D_DB <./2008-04-29_add_sql_share_tables.sql
   php -f ./convert_datatree_shares_to_sql.php
   ;;
esac
Wait

# KRONOLITH
STEP="Kronolith upgrade scripts"
cd $HORDE/kronolith/scripts/upgrades
mysql $D_DB<./2.1_to_2.2.sql
php -f ./2006-08-20_fix_recur_int_fields.mysql.sql
case $USE_SHARE in
y|Y)
   echo -n " processing ..."
   php -f ./convert_datatree_shares_to_sql.php
   ;;
esac
Wait

# TURBA
STEP="Turba upgrade scripts"
cd $HORDE/turba/scripts/upgrades
php -f ./2007-06-17_flatten_shares.php
php -f ./2.1_to_2.2_sql_schema.php
case $USE_SHARE in
y|Y)
   echo -n " processing ..."
   php -f ./2.1_to_2.2_add_sql_share_tables.sql
   php -f ./convert_datatree_shares_to_sql.php
   ;;
esac
Wait

# ANSEL
STEP="Ansel upgrade scripts"
cd $HORDE/ansel/scripts/upgrades
php -f ./2006-11-27_sql_images.php
php -f ./2006-11-27_datatree_to_sql_renames.php
php -f ./2006-11-27_fix_default_images.php
php -f ./2006-11-27_cleanup.php
mysql $D_DB <./2008_01_07_add_galleries.sql
php -f ./2008_01_07_sql_galleries.php
php -f ./2008_01_28_clean_datatree.php
mysql $D_DB <./2008_02_04_add_images_and_slugs.sql
php -f ./2008_02_04_add_initial_image_counts.php
mysql $D_DB <./2008_02_29_fix_category_defaults.sql
mysql $D_DB <./2008_03_18_add_gallery_age.sql
mysql $D_DB <./2008_03_19_add_gallery_download.sql
case $USE_SHARE in
y|Y)
   echo -n " processing ..."
   mysql $D_DB <./2008-04-28_add_sql_share_tables.sql
   php -f ./2008-04-28_sql_share_migration.php
   ;;
esac
Wait

# INGO
STEP="Ingo"
cd  $HORDE/ingo/scripts/sql
mysql $D_DB<./ingo.sql
cd $HORDE/ingo/scripts/upgrades
php -f ./convert_prefs_to_sql.php </etc/mail/login
cd $HD
mysql $D_DB <./convert_spam.sql
cd $HORDE/ingo/scripts/upgrades
case $USE_SHARE in
y|Y)
   echo -n " processing ..."
   php -f ./convert_datatree_shares_to_sql.php
   ;;
esac

# For ingo 2.x
#php -f ./convert_imp_filters.php </etc/mail/login
Wait

echo "Upgrade completed !"