[rt-users] Issues on RT 3.8.1
Jesse Vincent
jesse at bestpractical.com
Thu Aug 28 21:45:28 EDT 2008
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 <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
>
>
>
> _______________________________________________
> 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
>
More information about the rt-users
mailing list