<HTML><BODY style="word-wrap: break-word; -khtml-nbsp-mode: space; -khtml-line-break: after-white-space; ">Alex Krohn at Gossamer Threads fixed it up locally with the following snippet. I'm on-site with a client today, but if somebody could clean it up a little bit (I suspect it needs to load the RT::System saved searches attribute by something other than id and it needs a wrapper so that it can run as a standalone script.<DIV><BR class="khtml-block-placeholder"></DIV><DIV>-j<DIV><BR class="khtml-block-placeholder"></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><SPAN class="Apple-tab-span" style="white-space:pre"> </SPAN><B>From: </B><SPAN class="Apple-tab-span" style="white-space:pre"> </SPAN> <A href="mailto:alex@gossamer-threads.com">alex@gossamer-threads.com</A></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><SPAN class="Apple-tab-span" style="white-space:pre"> </SPAN><B>Subject: </B><SPAN class="Apple-tab-span" style="white-space:pre"> </SPAN><B>fixing webpath in database</B></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><SPAN class="Apple-tab-span" style="white-space:pre"> </SPAN><B>To: </B><SPAN class="Apple-tab-span" style="white-space:pre"> </SPAN> <A href="mailto:jesse@bestpractical.com">jesse@bestpractical.com</A></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; min-height: 14px; "><BR></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">Hi Jesse,</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; min-height: 14px; "><BR></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">Quick question for you if you have a moment. I ran into the problem with</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">__WebPath__ not getting stored in the database for "Highest priority</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">tickets I own" search on a few new 3.6.1 installs. After reading:</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; min-height: 14px; "><BR></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><A href="http://www.gossamer-threads.com/lists/rt/devel/58955#58955">http://www.gossamer-threads.com/lists/rt/devel/58955#58955</A></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; min-height: 14px; "><BR></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">I put something together to fix up the value in Content in the</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">Attributes table on this installation:</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; min-height: 14px; "><BR></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><SPAN class="Apple-tab-span" style="white-space:pre"> </SPAN>my $attr = RT::Attribute->new($RT::SystemUser);</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><SPAN class="Apple-tab-span" style="white-space:pre"> </SPAN>$attr->Load(18);</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><SPAN class="Apple-tab-span" style="white-space:pre"> </SPAN>my $hash = $attr->Content;</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><SPAN class="Apple-tab-span" style="white-space:pre"> </SPAN>$hash->{Format} =~ s,<a href="/,<a href="__WebPath__/,;</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><SPAN class="Apple-tab-span" style="white-space:pre"> </SPAN>$attr->SetContent($hash);</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; min-height: 14px; "><BR></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">and it worked fine. However, for one user account, I still get links to</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">'/Ticket/Display', rather then '/rt3/Ticket/Display'. i.e. __WebPath__ is</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">missing. All other users on this install show up fine.</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; min-height: 14px; "><BR></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">Is there somewhere else I would need to update for this?</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; min-height: 14px; "><BR></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">Thanks!</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; min-height: 14px; "><BR></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">Alex</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; min-height: 14px; "><BR></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">--</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">Alex Krohn <<A href="mailto:alex@gossamer-threads.com">alex@gossamer-threads.com</A>></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">Gossamer Threads Inc. <A href="http://www.gossamer-threads.com">http://www.gossamer-threads.com</A>/</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">Tel: (604) 687-5804 Fax: (604) 687-5806</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; min-height: 14px; "><BR></DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV><BR><DIV><DIV>On Nov 17, 2006, at 2:18 AM, James Mitchell wrote:</DIV><BR class="Apple-interchange-newline"><BLOCKQUOTE type="cite"><P><FONT size="2" face="Arial">I have searched quite a bit, not found a fix but I did find a workaround.</FONT> </P><P><FONT size="2" face="Arial"><A href="http://lists.bestpractical.com/pipermail/rt-users/2006-October/042231.html">http://lists.bestpractical.com/pipermail/rt-users/2006-October/042231.html</A></FONT> </P><P><FONT size="2" face="Arial">On Tue, 2006-10-03 at 18:21 +0200, Wolfgang.Fuertbauer at ebewe.com wrote:</FONT> <BR><FONT size="2" face="Arial">> Great! it works! </FONT> <BR><FONT size="2" face="Arial">> one has to remove and add the Subject column in "Customize ..."</FONT> </P> <BR><P><FONT size="2" face="Arial">So, as you see, if you edit the table, remove the subject column and re-add it</FONT> <BR><FONT size="2" face="Arial">with the link, it should work (and did on mine but that doesn't solve the</FONT> <BR><FONT size="2" face="Arial">problem for any other users...)</FONT> </P><P><FONT size="2" face="Arial">If anybody finds a genuine fix, please re-post it here for the benefit of anybody</FONT> <BR><FONT size="2" face="Arial">finding this thread via a search.</FONT> </P><P><FONT size="2" face="Arial">Thanks,</FONT> </P><P><FONT size="2" face="Arial">James</FONT> </P> <FONT face="Tahoma" size="2"><FONT color="#0000ff"><P class="MsoNormal"><SPAN style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">+++++</SPAN></P><P class="MsoNormal"><SPAN style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">Unless expressly stated otherwise, the contents of and attachments to this email represents only the views of the sender as expressed to the intended recipient. It does not necessarily represent the view of the company and is not intended to place any legal obligation upon the company, nor does it commit the company to any course of action or contractual undertaking. If you are not the intended recipient of this message/information, please inform the sender by return of mail and destroy the message and any attachments. Use or disclosure of any of the contents of the message by unauthorised persons may result in legal action being taken.</SPAN></P> </FONT></FONT><P class="MsoNormal"><FONT face="Tahoma" size="2"><FONT color="#0000ff"><SPAN style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">+++++</SPAN></FONT></FONT></P><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">_______________________________________________</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><A href="http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users">http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users</A></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; min-height: 14px; "><BR></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">Community help: <A href="http://wiki.bestpractical.com">http://wiki.bestpractical.com</A></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">Commercial support: <A href="mailto:sales@bestpractical.com">sales@bestpractical.com</A></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; min-height: 14px; "><BR></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; min-height: 14px; "><BR></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">Discover RT's hidden secrets with RT Essentials from O'Reilly Media.<SPAN class="Apple-converted-space"> </SPAN></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">Buy a copy at <A href="http://rtbook.bestpractical.com">http://rtbook.bestpractical.com</A></DIV> </BLOCKQUOTE></DIV><BR></DIV></DIV></BODY></HTML>