<div dir="ltr"><div>Thanks for the help David. Apologies for my simple questions as I do not have any knowledge on CPAN. </div>
<div> </div>
<div>I run below but upgrade is not an available command on CPAN shell. </div>
<div> </div>
<div>Error:</div>
<div>Unknown command 'upgrade'. Type ? for help.<br><br>What do I need to run to upgrade?</div>
<div> </div>
<div> </div>
<div>Thanks!</div>
<div>Roehl<br></div>
<div class="gmail_quote">On Wed, Aug 27, 2008 at 2:27 PM, David Svejda <span dir="ltr"><<a href="mailto:david.svejda@netfriends.cz">david.svejda@netfriends.cz</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">Upgrade your DBD::mysql module. The easiest way is using CPAN shell, so<br>type this command:<br><br>/usr/bin/perl -MCPAN -e shell<br>
<br>and when in shell, type:<br><br>upgrade DBD::mysql<br><br><br>Regards<br><br>Davdi<br>
<div class="Ih2E3d"><br>rmp dmd wrote:<br>> Thank you very for the help Ruslan.<br>><br>> I'm running<br>> perl etc/upgrade/<a href="http://schema.mysql-4.0-4.1.pl/" target="_blank">schema.mysql-4.0-4.1.pl</a><br>
</div>> <<a href="http://schema.mysql-4.0-4.1.pl/" target="_blank">http://schema.mysql-4.0-4.1.pl</a>> rt3 user password > sql.queries<br>
<div class="Ih2E3d">><br>> I'm getting<br>><br>> DBD::mysql version 4.002 required--this is only version 3.0002 at<br></div>> etc/upgrade/<a href="http://schema.mysql-4.0-4.1.pl/" target="_blank">schema.mysql-4.0-4.1.pl</a> <<a href="http://schema.mysql-4.0-4.1.pl/" target="_blank">http://schema.mysql-4.0-4.1.pl</a>> line 7.<br>
<div class="Ih2E3d">> BEGIN failed--compilation aborted at etc/upgrade/<a href="http://schema.mysql-4.0-4.1.pl/" target="_blank">schema.mysql-4.0-4.1.pl</a><br></div>> <<a href="http://schema.mysql-4.0-4.1.pl/" target="_blank">http://schema.mysql-4.0-4.1.pl</a>> line 7.<br>
<div class="Ih2E3d">><br>> I googled the error but there's no information available on this.<br>><br>><br>> Thanks again!<br>> Roehl<br>><br>> On Wed, Aug 27, 2008 at 11:48 AM, Ruslan Zakirov <<a href="mailto:ruz@bestpractical.com">ruz@bestpractical.com</a><br>
</div>
<div class="Ih2E3d">> <mailto:<a href="mailto:ruz@bestpractical.com">ruz@bestpractical.com</a>>> wrote:<br>><br>> `a_session` column is longtext what is WRONG and means that you HAVN'T<br>> upgraded correctly.<br>
><br>> Read UPGRADING.mysql, this column must be LONGBLOB.<br>><br>><br>><br>> On Wed, Aug 27, 2008 at 7:16 PM, rmp dmd <<a href="mailto:rmp.dmd1229@gmail.com">rmp.dmd1229@gmail.com</a><br></div>
<div class="Ih2E3d">> <mailto:<a href="mailto:rmp.dmd1229@gmail.com">rmp.dmd1229@gmail.com</a>>> wrote:<br>> > Thanks for the reply Ruslan.<br>> ><br>> > I'm not that familiar with mysql but when I run<br>
> ><br>> > SHOW CREATE TABLE sessions;<br>> ><br>> > I have this output which I believe does not indicate any<br>> corruption. How do<br>> > I know if there is corruption<br>
> ><br>> > RT3.8.1 is working fine only this weird occurence of asking to<br>> log-again<br>> > after clicking items as indicated on the previous message.<br>> ><br>> > Has anyone encounter this?<br>
> ><br>> > -Roehl<br>> ><br>> ><br>> --------------------------------------------------------------------------------------------------------------------------------------+<br>
> > | Table | Create<br>> > Table<br>> > |<br>> ><br>> +----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+<br>
> > | sessions | CREATE TABLE `sessions` (<br>> > `id` varchar(32) NOT NULL default '',<br>> > `a_session` longtext,<br>> > `LastUpdated` timestamp NOT NULL default CURRENT_TIMESTAMP on update<br>
> > CURRENT_TIMESTAMP,<br>> > PRIMARY KEY (`id`)<br>> > ) ENGINE=MyISAM DEFAULT CHARSET=latin1 |<br>> ><br>> +----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+<br>
> > 1 row in set (0.00 sec)<br>> ><br>> > On Tue, Aug 26, 2008 at 5:07 PM, Ruslan Zakirov<br></div>> <<a href="mailto:ruz@bestpractical.com">ruz@bestpractical.com</a> <mailto:<a href="mailto:ruz@bestpractical.com">ruz@bestpractical.com</a>>><br>
<div class="Ih2E3d">> > wrote:<br>> >><br>> >> On Tue, Aug 26, 2008 at 7:15 PM, rmp dmd <<a href="mailto:rmp.dmd1229@gmail.com">rmp.dmd1229@gmail.com</a><br></div>
<div class="Ih2E3d">> <mailto:<a href="mailto:rmp.dmd1229@gmail.com">rmp.dmd1229@gmail.com</a>>> wrote:<br>> >> > Hi,<br>> >> ><br>> >> > First, I'd like to say great job on putting up an excellent<br>
> >> > documentation<br></div>> >> > that is easy to follow for upgrading <a href="http://3.8.1./" target="_blank">3.8.1.</a> <<a href="http://3.8.1./" target="_blank">http://3.8.1./</a>><br>
<div class="Ih2E3d">> I'm newbie RT user/admin but<br>> >> > was<br>> >> > able to do the updagrade easily.<br>> >> ><br></div>> >> > I just have few minor issues on <a href="http://3.8.1./" target="_blank">3.8.1.</a> <<a href="http://3.8.1./" target="_blank">http://3.8.1./</a>><br>
<div>
<div></div>
<div class="Wj3C7c">> >> ><br>> >> > - On "RT at Glance" the link for "Bookmarked Tickets", "10 highest<br>> >> > priority<br>> >> > tickets I own", "10 newest unowned tickets" are pointing for<br>
> >> > <a href="http://localhost/rt/Search/Results.html?format....." target="_blank">http://localhost/rt/Search/Results.html?format.....</a>.. How can<br>> change<br>> >> > this<br>
> >> > link to <a href="http://mydomain.com/rt/Search/Results.html?format....." target="_blank">http://mydomain.com/rt/Search/Results.html?format.....</a>.. ?<br>> >> WebDomain option?<br>> >><br>
> >> ><br>> >> > - While I'm exploring the new interface 3.8.1, I stumble in<br>> this weird<br>> >> > scenario which I'm not sure if it's normal or bug. when I click<br>
> >> > Home->Tickets->configuration, it will be on site<br>> >> > <a href="http://mydomain.com/rt/Admin/index.html" target="_blank">http://mydomain.com/rt/Admin/index.html</a> but it will ask me to log<br>
> >> > again.<br>> >> > same thing when I click Home->simpleSearch->tickets->Tools, it<br>> will on<br>> >> > site<br>> >> > <a href="http://mydomain.com/rt/Tools/index.html" target="_blank">http://mydomain.com/rt/Tools/index.html</a> but it will ask me to<br>
> log again.<br>> >> > I'm<br>> >> > not sure what else is in ther but this may be nuisance.<br>> >> ><br>> >> > Any ideas?<br>> >> WebDomain or session corruption because of incorrect upgrade.<br>
> >><br>> >> SHOW CREATE TABLE sessions;<br>> >><br>> >> ><br>> >> > Thanks!<br>> >> > Roehl<br>> >> ><br>> >> > _______________________________________________<br>
> >> > <a href="http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users" target="_blank">http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users</a><br>> >> ><br>> >> > Community help: <a href="http://wiki.bestpractical.com/" target="_blank">http://wiki.bestpractical.com</a><br>
> <<a href="http://wiki.bestpractical.com/" target="_blank">http://wiki.bestpractical.com/</a>><br>> >> > Commercial support: <a href="mailto:sales@bestpractical.com">sales@bestpractical.com</a><br>
</div></div>> <mailto:<a href="mailto:sales@bestpractical.com">sales@bestpractical.com</a>><br>
<div class="Ih2E3d">> >> ><br>> >> ><br>> >> > Discover RT's hidden secrets with RT Essentials from O'Reilly<br>> Media.<br>> >> > Buy a copy at <a href="http://rtbook.bestpractical.com/" target="_blank">http://rtbook.bestpractical.com</a><br>
> <<a href="http://rtbook.bestpractical.com/" target="_blank">http://rtbook.bestpractical.com/</a>><br>> >> ><br>> >><br>> >><br>> >><br>> >> --<br>
> >> Best regards, Ruslan.<br>> ><br>> ><br>> > _______________________________________________<br>> > <a href="http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users" target="_blank">http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users</a><br>
> ><br>> > Community help: <a href="http://wiki.bestpractical.com/" target="_blank">http://wiki.bestpractical.com</a><br>> <<a href="http://wiki.bestpractical.com/" target="_blank">http://wiki.bestpractical.com/</a>><br>
> > Commercial support: <a href="mailto:sales@bestpractical.com">sales@bestpractical.com</a><br></div>> <mailto:<a href="mailto:sales@bestpractical.com">sales@bestpractical.com</a>><br>
<div>
<div></div>
<div class="Wj3C7c">> ><br>> ><br>> > Discover RT's hidden secrets with RT Essentials from O'Reilly Media.<br>> > Buy a copy at <a href="http://rtbook.bestpractical.com/" target="_blank">http://rtbook.bestpractical.com</a><br>
> <<a href="http://rtbook.bestpractical.com/" target="_blank">http://rtbook.bestpractical.com/</a>><br>> ><br>><br>><br>><br>> --<br>> Best regards, Ruslan.<br>><br>><br>
><br>> ------------------------------------------------------------------------<br>><br>> _______________________________________________<br>> <a href="http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users" target="_blank">http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users</a><br>
><br>> Community help: <a href="http://wiki.bestpractical.com/" target="_blank">http://wiki.bestpractical.com</a><br>> Commercial support: <a href="mailto:sales@bestpractical.com">sales@bestpractical.com</a><br>><br>
><br>> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.<br>> Buy a copy at <a href="http://rtbook.bestpractical.com/" target="_blank">http://rtbook.bestpractical.com</a><br><br></div></div>
</blockquote></div><br></div>