Thank you very for the help Ruslan. I'm running perl etc/upgrade/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 line 7. BEGIN failed--compilation aborted at etc/upgrade/schema.mysql-4.0-4.1.plline 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 <[EMAIL PROTECTED]>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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> > > wrote: > >> > >> On Tue, Aug 26, 2008 at 7:15 PM, rmp dmd <[EMAIL PROTECTED]> 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. I'm newbie RT user/admin > but > >> > was > >> > able to do the updagrade easily. > >> > > >> > I just have few minor issues on 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 > >> > Commercial support: [EMAIL PROTECTED] > >> > > >> > > >> > 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: [EMAIL PROTECTED] > > > > > > 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: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com