[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