On Aug 28, 2008, at 6:43 PM, Shannon Adams wrote: > Thanks, Drew. When I run: > perl etc/upgrade/schema.mysql-4.0-4.1.pl db user pw > sql.queries > I get: > DBD::mysql version 4.002 required--this is only version 2.9007 at > etc/upgrade/schema.mysql-4.0-4.1.pl line 7. > BEGIN failed--compilation aborted at etc/upgrade/ > schema.mysql-4.0-4.1.pl line 7. > > How do I upgrade DBD::mysql to version 4.002? >
sudo cpan DBD::mysql > > > ----- Original Message ---- > From: Drew Barnes <[EMAIL PROTECTED]> > To: Shannon Adams <[EMAIL PROTECTED]> > Cc: [email protected] > Sent: Thursday, August 28, 2008 10:52:21 AM > Subject: Re: [rt-users] Issues on RT 3.8.1 > > You missed a step. > > Per Ruslan yesterday: > `a_session` column is longtext what is WRONG and means that you HAVN'T > upgraded correctly. > > Read UPGRADING.mysql, this column must be LONGBLOB. > > > Shannon Adams wrote: >> RT 3.8.1 >> mysql version - 4.1.20-log >> Fedora Core 4 >> >> SHOW CREATE TABLE sessions; shows: >> +---------- >> + >> --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ >> | Table | Create >> Table >> >> >> | >> +---------- >> + >> --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ >> | sessions | CREATE TABLE `sessions` ( >> `id` varchar(32) NOT NULL default '', >> `a_session` longtext, >> `LastUpdated` timestamp NOT NULL default CURRENT_TIMESTAMP on >> update CURRENT_TIMESTAMP, >> PRIMARY KEY (`id`) >> ) ENGINE=MyISAM DEFAULT CHARSET=latin1 | >> +---------- >> + >> --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ >> 1 row in set (0.00 sec) >> >> SHOW CREATE TABLE Attachments; shows: >> >> +------------- >> +--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ >> | Table | Create >> Table >> >> >> >> >> >> >> >> >> | >> +------------- >> +--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ >> | Attachments | CREATE TABLE `Attachments` ( >> `id` int(11) NOT NULL auto_increment, >> `TransactionId` int(11) NOT NULL default '0', >> `Parent` int(11) NOT NULL default '0', >> `MessageId` varchar(160) default NULL, >> `Subject` varchar(255) default NULL, >> `Filename` varchar(255) default NULL, >> `ContentType` varchar(80) default NULL, >> `ContentEncoding` varchar(80) default NULL, >> `Content` longtext, >> `Headers` longtext, >> `Creator` int(11) NOT NULL default '0', >> `Created` datetime default NULL, >> PRIMARY KEY (`id`), >> KEY `Attachments2` (`TransactionId`), >> KEY `Attachments3` (`Parent`,`TransactionId`) >> ) ENGINE=InnoDB DEFAULT CHARSET=latin1 | >> +------------- >> +--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ >> 1 row in set (0.19 sec) >> >> Thanks, >> Shannon >> >> >> >>> once again, send us results of "SHOW CREATE TABLE sessions;" >>> and "SHOW CREATE TABLE Attachments;" >>> On Wed, Aug 27, 2008 at 6:23 AM, Ruslan Zakirov <ruz at >>> bestpractical.com> wrote: >>> send us results of "SHOW CREATE TABLE sessions;" >>> >>> On Wed, Aug 27, 2008 at 4:05 AM, Carlos A. Alvarez <calvarez at >>> commx.net> wrote: >>> >>>> I am also having the same "Logout/Login" issues as described >>>> above. The >>>> are no errors reported on the debug.log or the access/error >>>> logs. This >>>> only happened after I upgraded from 3.8.0 to 3.8.1. It seems as >>>> one >>>> changes links from Home to Simple Search or Tools, the >>>> application will >>>> log you out at random. I have tried all the fixes suggested here >>>> with >>>> no avail. This is happening with Firefox, IE and Safari. Any >>>> ideas? >>>> _______________________________________________ >>>> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users >>>> >>>> Community help: http://wiki.bestpractical.com >>>> Commercial support: sales at bestpractical.com >>>> >>>> >>>> Discover RT's hidden secrets with RT Essentials from O'Reilly >>>> Media. >>>> Buy a copy at http://rtbook.bestpractical.com >>>> >>>> >>> >>> -- >>> Best regards, Ruslan. >>> >>> >> >> >> >> _______________________________________________ >> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users >> >> Community help: http://wiki.bestpractical.com >> Commercial support: [EMAIL PROTECTED] >> >> >> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. >> Buy a copy at http://rtbook.bestpractical.com >> > > -- > Drew Barnes > Applications Analyst > Network Resources Department > Raymond Walters College > University of Cincinnati > > > > _______________________________________________ > http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users > > Community help: http://wiki.bestpractical.com > Commercial support: [EMAIL PROTECTED] > > > Discover RT's hidden secrets with RT Essentials from O'Reilly Media. > Buy a copy at http://rtbook.bestpractical.com > _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
