<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Hi Kevin!<br>
<br>
<div class="moz-cite-prefix">On 03/13/2013 06:50 PM, Kevin Falcone wrote:<br>
</div>
<blockquote cite="mid:20130313175024.GD1554@jibsheet.com" type="cite">
<pre wrap="">On Tue, Mar 12, 2013 at 08:53:51AM +0000, Guadagnino Cristiano wrote:
</pre>
<blockquote type="cite">
<pre wrap=""> I think I have found out where the problem lies.
On our production system (RT 3.8.10) attachments that have no value assigned show as "(no
value)". On our test system (RT 4.0.8) attachments that have no value simply show a blank
space, but in the source you find a link pointing to an invalid url (e.g.
"/Download/CustomFieldValue/12194/").
</pre>
</blockquote>
<pre wrap="">
If you select * from ObjectCustomFieldValues where id = 12194 on your
old and new systems, what's different?
Keep in mind you might need to examine Content carefully to see if
it's truly empty or if it contains spaces.
-kevin
</pre>
</blockquote>
<br>
Kevin, now I am REALLY confused. By looking at mysql tables as you suggested, I discovered a few things:<br>
<br>
- I told you that new articles created in RT4 did not trigger errors. That's not true, they DO trigger the same kind of error. They do not trigger errors only if I do attach something both in the "attachments" and in the "images" CFs I defined. If they are
left empty, I have errors.<br>
<br>
- I told you that our production system generated different links. That's not true either. I was looking at very old articles, before I defined the "attachments" and "images" CFs. The newer articles generate the same kind of links.<br>
<br>
- BOTH our production system and our test system are configured to log at "warning" level.<br>
<br>
- Our production system DO NOT show errors in the log when accessing articles (both old and new), while our test system DO show errors.<br>
<br>
I decided to look at the source lines indicated in the error log.<br>
<br>
This is the source line from out production system (RT3):<br>
<blockquote>
<pre><big><a href="<%RT->Config->Get('WebPath')%>/Download/CustomFieldValue/<% $Object->Id %>/<b><% $Object->Content %>"></b><% $Object->Content %></a></big></pre>
</blockquote>
While this is the source line from our test system (RT4):<br>
<blockquote>
<pre><big><a href="<%RT->Config->Get('WebPath')%>/Download/CustomFieldValue/<% $Object->Id %>/<font color="#cc0000"><b><% $Object->Content |u %></b></font>"><% $Object->Content %></a></big></pre>
</blockquote>
As you can see they're nearly identical, but for a slight difference in the part I highlighted.<br>
<br>
Now I think we have two possibilities:<br>
- that slight difference in code is causing the errors (I'm not fluent enough in perl to understand it)<br>
- I have done something wrong defining the CFs in our test system. I am attaching two screenshots, could your be so kind to tell me if you see anything wrong?<br>
<br>
Bye<br>
Cris<br>
<br>
<div class="moz-signature">-- <br>
<b><i>Cristiano Guadagnino</i></b><br>
<small>Servizio Data Administration<br>
Bankadati S.I.<br>
Gruppo Credito Valtellinese<br>
Tel. +39-0342-522172</small><br>
</div>
</body>
</html>