<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body bgcolor="#FFFFFF" text="#000000">
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>
guadagnino.cristiano@creval.it<br>
<a href="http://www.creval.it">www.creval.it</a></p>
</font>
<p><a href="https://www.facebook.com/creval/"><img alt="Seguici su Facebook" src="cid:logofacebookfc0712"></a>
<a href="http://www.youtube.com/user/GruppoCreval/"><img alt="Creval Tube" src="cid:logoyoutube0016af"></a>
<a href="https://www.creval.it/comunicazione/appICreval/appICreval.html"><img alt="CrevalApp" src="cid:logocreval9143dd"></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 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 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>
</body>
</html>