<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=Windows-1252">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Hi all,<br>
I'm replying here to document where the problem lies and how I solved it.<br>
<br>
The problem: it seems that the '<i>upgrade-articles</i>' script somehow doesn't update all records in the
<i>ObjectCustomFieldValues</i> table. Specifically, it only updates articles that have the '<i>Disabled</i>' flag set to 0. Those that have '<i>Disabled</i>' set to 1 (i.e. the old revisions of an article) retain the old (now wrong) ObjectType.<br>
<br>
If you have mysql, you can check for this type of problem by running this query against your
<b>rt4</b> database:<br>
<blockquote><big><b><tt>select Disabled, ObjectType, count(*)</tt></b></big><br>
<big><b><tt>from ObjectCustomFieldValues</tt></b></big><br>
<big><b><tt>where ObjectType like '%article%'</tt></b></big><br>
<big><b><tt>group by Disabled, ObjectType; </tt></b></big><br>
</blockquote>
<br>
If you see a row where ObjectType = 'RT::FM::Article', than you have the problem.<br>
<br>
I fixed the problem with this simple update:<br>
<blockquote><big><b><tt>update ObjectCustomFieldValues</tt></b></big><br>
<big><b><tt>set ObjectType = 'RT::Article'</tt></b></big><br>
<big><b><tt>where ObjectType = 'RT::FM::Article'</tt></b></big><br>
</blockquote>
<br>
I hope this can help others having this problem.<br>
<br>
Bye<br>
Cris<br>
<br>
<br>
<div class="moz-cite-prefix">
<hr>
<b>Da:</b> Guadagnino Cristiano <a class="moz-txt-link-rfc2396E" href="mailto:guadagnino.cristiano@creval.it">
<guadagnino.cristiano@creval.it></a><br>
<b>Inviato:</b> Fri Oct 18 2013 10:45:30 GMT+0200 (CEST)<br>
<b>A:</b> <a class="moz-txt-link-abbreviated" href="mailto:rt-users@lists.bestpractical.com">
rt-users@lists.bestpractical.com</a> <a class="moz-txt-link-rfc2396E" href="mailto:rt-users@lists.bestpractical.com">
<rt-users@lists.bestpractical.com></a><br>
<b>Oggetto:</b> Re: [rt-users] Error in article history<br>
</div>
<blockquote cite="mid:5260F51A.80202@creval.it" type="cite">Hi Kevin,<br>
it's been quite some time since we migrted to RT 4.<br>
Fortunately, I have a migration procedure I wrote down while migrating our test environment, so that I could re-apply the same steps in production.<br>
<br>
We migrated to RT 4 while also migrating to new CentOS servers, so this is what I did after installing the servers and downbloading all the required components (packages):<br>
<br>
- I followed RT's README till step 6a<br>
- in step 6a I only did the first part (i.e. I did not do "make initialize database")<br>
- I restored the backup from our RT 3.x production system (in rt4 db)<br>
- I did "make upgrade database" from step 6b<br>
- I ran ./etc/upgrade/upgrade-articles from the directory where I uncompressed the tarball<br>
<br>
I think this is the relevant part.<br>
Then I followed by porting my old Apache/sendmail/Sphinx configurations to the new servers, etc.<br>
<br>
Is that enough? Or, is there something more I should have done?<br>
<br>
Thank you<br>
Cris<br>
<br>
<br>
<div class="moz-cite-prefix">
<p><font style="FONT-SIZE: 9pt" color="#004999" face="Arial"><strong>Cristiano Guadagnino<br>
</strong><br>
Servizio Data Administration<br>
_______________________________<br>
<strong>Bankadati Servizi Informatici Soc.Cons.P.A.</strong><br>
Gruppo bancario Credito Valtellinese<br>
Via Trento, 22 - 23100 SONDRIO<br>
tel +39 0342522172 - fax +39 0342522992<br>
<a class="moz-txt-link-abbreviated" href="mailto:guadagnino.cristiano@creval.it">guadagnino.cristiano@creval.it</a><br>
<a moz-do-not-send="true" href="http://www.creval.it">www.creval.it</a></font></p>
<font style="FONT-SIZE: 9pt" color="#004999" face="Arial"></font>
<p><a moz-do-not-send="true" href="https://www.facebook.com/creval/"><img alt="Seguici su
Facebook" src="cid:part2.07040801.05030707@creval.it"></a>
<a moz-do-not-send="true" href="http://www.youtube.com/user/GruppoCreval/"><img alt="Creval Tube" src="cid:part4.01050001.07070909@creval.it"></a>
<a moz-do-not-send="true" href="https://www.creval.it/comunicazione/appICreval/appICreval.html">
<img alt="CrevalApp" src="cid:part6.07080403.07060709@creval.it"></a> <br>
<br>
<font style="FONT-SIZE: 8pt" face="Arial"><font style="FONT-SIZE: 9pt"><font style="FONT-SIZE: 8pt"><font color="#000000"><font style="FONT-SIZE: 8pt">Il presente messaggio non è di natura personale ma inviato per esigenze lavorative; l’eventuale messaggio
di risposta potrà essere conosciuto anche da altri soggetti diversi dall’originatore di questo messaggio per dette esigenze o per controllo aziendale. Questo messaggio, corredato dei relativi allegati, contiene informazioni da considerarsi strettamente riservate,
ed è destinato esclusivamente al destinatario sopra indicato, il quale è l'unico autorizzato ad usarlo, copiarlo e, sotto la propria responsabilità, diffonderlo. Chiunque ricevesse questo messaggio per errore o comunque lo leggesse senza esserne legittimato
è avvertito che trattenerlo, copiarlo, divulgarlo, distribuirlo a persone diverse dal destinatario è severamente proibito, ed è pregato di rinviarlo immediatamente al mittente distruggendone l'originale.</font><br>
</font></font></font></font></p>
<br>
<hr>
<b>Da:</b> Kevin Falcone <a moz-do-not-send="true" class="moz-txt-link-rfc2396E" href="mailto:falcone@bestpractical.com">
<falcone@bestpractical.com></a><br>
<b>Inviato:</b> Thu Oct 17 2013 16:40:50 GMT+0200 (CEST)<br>
<b>A:</b> <a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:rt-users@lists.bestpractical.com">
rt-users@lists.bestpractical.com</a><br>
<b>Oggetto:</b> Re: [rt-users] Error in article history<br>
</div>
<blockquote cite="mid:20131017144050.GO37001@jibsheet.com" type="cite">
<pre wrap="">On Thu, Oct 17, 2013 at 08:33:27AM +0000, Guadagnino Cristiano wrote:
</pre>
<blockquote type="cite">
<pre wrap=""> How can I verify the ObjectTypes? Would you be so kind to send me a query to run against mysql
to verify that everything is ok with my articles?
</pre>
</blockquote>
<pre wrap="">You'll need to write your own SQL query - as noted previously, you're
looking for RT::FM::Article in the ObjectType field on Transactions
and ObjectCustomFieldValues.
Also - please confirm which upgrade steps you ran. There is a
standalone documented and warned about script you must run to upgrade
articles.
-kevin
</pre>
<blockquote type="cite">
<pre wrap=""> You likely still have a Transaction record or ObjectCustomFieldValue
record with the wrong ObjectType that those scripts should have fixed
for you.
</pre>
</blockquote>
</blockquote>
<br>
<div class="moz-signature">-- <br>
</div>
</blockquote>
<br>
<div class="moz-signature">-- <br>
</div>
</body>
</html>