[rt-users] Issues on RT 3.8.1

[Shannon Adams]

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?



----- Original Message ----
From: Drew Barnes <barnesaw at ucrwcu.rwc.uc.edu>
To: Shannon Adams <shannon_adams68 at yahoo.com>
Cc: rt-users at lists.bestpractical.com
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: sales at bestpractical.com
>
>
> 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