[rt-users] Issues on RT 3.8.1
Shannon Adams
shannon_adams68 at yahoo.com
Fri Aug 29 08:43:15 EDT 2008
Running FC4. cpan DBD::mysql shows:
Test Summary Report
-------------------
t/40blobs (Wstat: 65280 Tests: 0 Failed: 0)
Non-zero exit status: 255
Parse errors: No plan found in TAP output
Files=34, Tests=6, 3 wallclock secs ( 0.06 usr 0.21 sys + 1.74 cusr 0.85 csys = 2.86 CPU)
Result: FAIL
Failed 1/34 test programs. 0/6 subtests failed.
make: *** [test_dynamic] Error 255
CAPTTOFU/DBD-mysql-4.008.tar.gz
/usr/bin/make test -- NOT OK
//hint// to see the cpan-testers results for installing this module, try:
reports CAPTTOFU/DBD-mysql-4.008.tar.gz
Running make install
make test had returned bad status, won't install without force
Any idea why it won't install?
Thanks,
Shannon
----- Original Message ----
From: Jesse Vincent <jesse at bestpractical.com>
To: Shannon Adams <shannon_adams68 at yahoo.com>
Cc: Drew Barnes <barnesaw at ucrwcu.rwc.uc.edu>; rt-users at lists.bestpractical.com
Sent: Thursday, August 28, 2008 9:45:28 PM
Subject: Re: [rt-users] Issues on RT 3.8.1
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