[rt-users] RT Upgrade 3.2.2 -> 3.8.1: HTML::Mason goes intoinfinite loop.

[Golemon, Buck]

t_t 

--Buck

-----Original Message-----
From: Golemon, Buck 
Sent: Tuesday, October 14, 2008 4:25 PM
To: Golemon, Buck; RT Users List
Cc: Descamps, Gilles-Eric; Lee, Mark (SV)
Subject: RE: [rt-users] RT Upgrade 3.2.2 -> 3.8.1: HTML::Mason goes
intoinfinite loop.

Did I ask the question the wrong way? 
At this point, any ideas are appreciated.

Has anyone successfully upgraded their database from <=3.2.2 to 3.8.1?

--Buck

-----Original Message-----
From: rt-users-bounces at lists.bestpractical.com
[mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of Golemon,
Buck
Sent: Monday, October 13, 2008 6:38 PM
To: RT Users List
Cc: Descamps, Gilles-Eric; Lee, Mark (SV)
Subject: [rt-users] RT Upgrade 3.2.2 -> 3.8.1: HTML::Mason goes
intoinfinite loop.

The installation works just find with a pristine database, but when I
copy over my old database and follow the instructions at
UPGRADING.mysql, I get this error: (see attached). This went on for two
million lines before I stopped the server. It finally gets into a
three-line loop like this: (again, see attached).



I got some errors from schema.mysql-4.0-4.1.pl like this:
# perl etc/upgrade/schema.mysql-4.0-4.1.pl rt3 rt_user rt_pass >
sql.queries
Use of uninitialized value in numeric gt (>) at
etc/upgrade/schema.mysql-4.0-4.1.pl line 310.
Use of uninitialized value in numeric gt (>) at
etc/upgrade/schema.mysql-4.0-4.1.pl line 310. 
Use of uninitialized value in numeric gt (>) at
etc/upgrade/schema.mysql-4.0-4.1.pl line 310.
Use of uninitialized value in numeric gt (>) at
etc/upgrade/schema.mysql-4.0-4.1.pl line 310.


I had to replace all the occurrences (three total) of 'BLOB CHARACTER
SET utf8' with just 'BLOB', since BLOB doesn't have a character set, and
this is a syntax error in mysql.


I also dropped and recreated the sessions table because it was
corrupted. I did it like this:
drop table sessions;
CREATE TABLE `sessions` (
  `id` varchar(32) NOT NULL default '',
  `a_session` longblob NOT NULL,
  `LastUpdated` timestamp NOT NULL default CURRENT_TIMESTAMP on update
CURRENT_TIMESTAMP,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1


Thanks in advance,
--Buck