[turba] Upgrading from Turba 1.2 to 2.0

[Brett Charbeneau]

On Mon, 3 Jul 2006, Oliver Schulze L. wrote:

	Thanks for the response, Oliver!

OSL> You can insert the old .sql export first,

	Okay, through phpadmin I dropped the turba-objects table so I can start 
from scratch.
	I then tried to insert the old turba dump into the Horde database:


mysql --user=root --password=PASSWORD horde < oldIMP_turba.txt

	but I get 

ERROR 1146 at line 12: Table 'horde.turba_objects' doesn't exist


	Am I missing something?



OSL> and the run 1.2_to_2.0.mysql.sql.
OSL> The script 1.2_to_2.0.mysql.sql will add columns to your turba table,
OSL> so I thinks thats why your are having that error:
OSL> ERROR 1136 at line 12: Column count doesn't match value count at row 1
OSL> 
OSL> HTH
OSL> Oliver
OSL> 
OSL> Brett Charbeneau wrote:
OSL> > Greetings!
OSL> > 
OSL> >     Any help or pointers would greatly appreciated!
OSL> >     I've been running Horde for 3 years now, but I'm afraid my ignorance
OSL> > of MySql is causing me some problems in an upgrade.
OSL> >     I've scoured this list's archives and gone through the UPGRADING
OSL> > file, but I'm still scratching my head. If there are instructions
OSL> > somewhere on this that I've missed I apologize - I really looked!
OSL> > 
OSL> >     I am trying to upgrade from
OSL> > 
OSL> > Horde: 2.2.3    (runing on RedHat 9.0)
OSL> > IMP: 3.2.2
OSL> > Turba: 1.2
OSL> > PHP Version: 4.2.2
OSL> > 
OSL> > to
OSL> > 
OSL> > Horde: 3.0.4    (running on Debian 3.1)
OSL> > IMP: 4.0.2
OSL> > Turba: 2.0.2
OSL> > 
OSL> >     and am having some trouble with the 1.2_to_2.0.mysql.sql script that
OSL> > came with Turba.
OSL> >     I went ahead and got Horde, IMP, and Turba running on a fresh Debian
OSL> > install (from Debian .deb packages) on my new machine having created the
OSL> > initial databases with the included scripts:
OSL> > 
OSL> > /usr/share/doc/horde3/examples/scripts/sql/create.mysql.sql
OSL> > 
OSL> > By issuing:
OSL> >     mysql --user=root --password=PASSWORD < \
OSL> >     /usr/share/doc/horde3/examples/scripts/sql/create.mysql.sql
OSL> > 
OSL> >     and
OSL> > 
OSL> > /usr/share/doc/turba2/examples/scripts/sql/turba_objects.mysql.sql
OSL> > 
OSL> > By issuing:
OSL> >     mysql --user=root --password=PASSWORD horde \ <
OSL> > /usr/share/doc/turba2/examples/scripts/sql/turba_objects.mysql.sql
OSL> > 
OSL> >     On the old machine, I dumped the present Turba database with this
OSL> > command:
OSL> > 
OSL> > mysqldump -t horde turba_objects --password=PASSWORD > oldTURB.txt
OSL> > 
OSL> >     Then, I FTP'd oldTURB.txt to the new machine and restored the Turba
OSL> > dump like this:
OSL> > 
OSL> > mysql --user=root --password=PASSWORD horde < oldIMP_turba.txt
OSL> > 
OSL> >     HOWEVER, I get this error:
OSL> > 
OSL> > ERROR 1136 at line 12: Column count doesn't match value count at row 1
OSL> > 
OSL> >     Am I supposed to use the 1.2_to_2.0.mysql.sql script on the *old*
OSL> > install first? Is there a way to so this without ruining the present
OSL> > Turba 1.2 database? (I need to keep the old one up until the new one is
OSL> > online)
OSL> >     I'd be grateful for any hints, tips, or help!
OSL> > 
OSL> > 
OSL> > -- 
OSL> > ********************************************************************
OSL> > Brett Charbeneau
OSL> > Network Administrator
OSL> > Williamsburg Regional Library
OSL> > 7770 Croaker Road
OSL> > Williamsburg, VA 23188-7064
OSL> > (757)259-4044          www.wrl.org
OSL> > (757)259-4079 (fax)    brett at wrl.org
OSL> > ********************************************************************
OSL> > 
OSL> > 
OSL> > 
OSL> > 
OSL> > 
OSL> > 
OSL> > 
OSL> 
OSL> 

-- 
********************************************************************
Brett Charbeneau
Network Administrator
Williamsburg Regional Library
7770 Croaker Road
Williamsburg, VA 23188-7064
(757)259-4044          www.wrl.org
(757)259-4079 (fax)    brett at wrl.org
********************************************************************