[rt-users] Issues on RT 3.8.1

David Svejda david.svejda at netfriends.cz
Wed Aug 27 14:27:49 EDT 2008


Upgrade your DBD::mysql module. The easiest way is using CPAN shell, so
type this command:

/usr/bin/perl -MCPAN -e shell

and when in shell, type:

upgrade DBD::mysql


Regards

Davdi

rmp dmd wrote:
> Thank you very for the help Ruslan.
>  
> I'm running
> perl etc/upgrade/schema.mysql-4.0-4.1.pl
> <http://schema.mysql-4.0-4.1.pl> rt3 user password > sql.queries
>  
> I'm getting
> 
> DBD::mysql version 4.002 required--this is only version 3.0002 at
> etc/upgrade/schema.mysql-4.0-4.1.pl <http://schema.mysql-4.0-4.1.pl> line 7.
> BEGIN failed--compilation aborted at etc/upgrade/schema.mysql-4.0-4.1.pl
> <http://schema.mysql-4.0-4.1.pl> line 7.
> 
> I googled the error but there's no information available on this.
>  
>  
> Thanks again!
> Roehl
>  
> On Wed, Aug 27, 2008 at 11:48 AM, Ruslan Zakirov <ruz at bestpractical.com
> <mailto:ruz at bestpractical.com>> wrote:
> 
>     `a_session` column is longtext what is WRONG and means that you HAVN'T
>     upgraded correctly.
> 
>     Read UPGRADING.mysql, this column must be LONGBLOB.
> 
> 
> 
>     On Wed, Aug 27, 2008 at 7:16 PM, rmp dmd <rmp.dmd1229 at gmail.com
>     <mailto:rmp.dmd1229 at gmail.com>> wrote:
>     > Thanks for the reply Ruslan.
>     >
>     > I'm not that familiar with mysql but when I run
>     >
>     > SHOW CREATE TABLE sessions;
>     >
>     > I have this output which I believe does not indicate any
>     corruption. How do
>     > I know if there is corruption
>     >
>     > RT3.8.1 is working fine only this weird occurence of asking to
>     log-again
>     > after clicking items as indicated on the previous message.
>     >
>     > Has anyone encounter this?
>     >
>     > -Roehl
>     >
>     >
>     --------------------------------------------------------------------------------------------------------------------------------------+
>     > | 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)
>     >
>     > On Tue, Aug 26, 2008 at 5:07 PM, Ruslan Zakirov
>     <ruz at bestpractical.com <mailto:ruz at bestpractical.com>>
>     > wrote:
>     >>
>     >> On Tue, Aug 26, 2008 at 7:15 PM, rmp dmd <rmp.dmd1229 at gmail.com
>     <mailto:rmp.dmd1229 at gmail.com>> wrote:
>     >> > Hi,
>     >> >
>     >> > First, I'd like to say great job on putting up an excellent
>     >> > documentation
>     >> > that is easy to follow for upgrading 3.8.1. <http://3.8.1./>
>     I'm newbie RT user/admin but
>     >> > was
>     >> > able to do the updagrade easily.
>     >> >
>     >> > I just have few minor issues on 3.8.1. <http://3.8.1./>
>     >> >
>     >> > - On "RT at Glance" the link for "Bookmarked Tickets", "10 highest
>     >> > priority
>     >> > tickets I own", "10 newest unowned tickets" are pointing for
>     >> > http://localhost/rt/Search/Results.html?format.......  How can
>     change
>     >> > this
>     >> > link to http://mydomain.com/rt/Search/Results.html?format.......  ?
>     >> WebDomain option?
>     >>
>     >> >
>     >> > - While I'm exploring the new interface 3.8.1, I stumble in
>     this weird
>     >> > scenario which I'm not sure if it's normal or bug. when I click
>     >> > Home->Tickets->configuration, it will be on site
>     >> >  http://mydomain.com/rt/Admin/index.html but it will ask me to log
>     >> > again.
>     >> > same thing when I click Home->simpleSearch->tickets->Tools, it
>     will on
>     >> > site
>     >> > http://mydomain.com/rt/Tools/index.html but it will ask me to
>     log again.
>     >> > I'm
>     >> > not sure what else is in ther but this may be nuisance.
>     >> >
>     >> > Any ideas?
>     >> WebDomain or session corruption because of incorrect upgrade.
>     >>
>     >> SHOW CREATE TABLE sessions;
>     >>
>     >> >
>     >> > Thanks!
>     >> > Roehl
>     >> >
>     >> > _______________________________________________
>     >> > http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>     >> >
>     >> > Community help: http://wiki.bestpractical.com
>     <http://wiki.bestpractical.com/>
>     >> > Commercial support: sales at bestpractical.com
>     <mailto:sales at bestpractical.com>
>     >> >
>     >> >
>     >> > Discover RT's hidden secrets with RT Essentials from O'Reilly
>     Media.
>     >> > Buy a copy at http://rtbook.bestpractical.com
>     <http://rtbook.bestpractical.com/>
>     >> >
>     >>
>     >>
>     >>
>     >> --
>     >> Best regards, Ruslan.
>     >
>     >
>     > _______________________________________________
>     > http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>     >
>     > Community help: http://wiki.bestpractical.com
>     <http://wiki.bestpractical.com/>
>     > Commercial support: sales at bestpractical.com
>     <mailto:sales at bestpractical.com>
>     >
>     >
>     > Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
>     > Buy a copy at http://rtbook.bestpractical.com
>     <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




More information about the rt-users mailing list