[rt-users] Error in article history

[Guadagnino Cristiano]

Hi Kevin,
it's been quite some time since we migrted to RT 4.
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.

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):

- I followed RT's README till step 6a
- in step 6a I only did the first part (i.e. I did not do "make initialize database")
- I restored the backup from our RT 3.x production system (in rt4 db)
- I did "make upgrade database" from step 6b
- I ran ./etc/upgrade/upgrade-articles from the directory where I uncompressed the tarball

I think this is the relevant part.
Then I followed by porting my old Apache/sendmail/Sphinx configurations to the new servers, etc.

Is that enough? Or, is there something more I should have done?

Thank you
Cris



Cristiano Guadagnino

Servizio Data Administration
_______________________________
Bankadati Servizi Informatici Soc.Cons.P.A.
Gruppo bancario Credito Valtellinese
Via Trento, 22 - 23100 SONDRIO
tel +39 0342522172  - fax +39 0342522992
guadagnino.cristiano at creval.it
www.creval.it<http://www.creval.it>

[Seguici su Facebook]<https://www.facebook.com/creval/>  [Creval Tube] <http://www.youtube.com/user/GruppoCreval/>   [CrevalApp] <https://www.creval.it/comunicazione/appICreval/appICreval.html>

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.

________________________________
Da: Kevin Falcone <falcone at bestpractical.com><mailto:falcone at bestpractical.com>
Inviato: Thu Oct 17 2013 16:40:50 GMT+0200 (CEST)
A: rt-users at lists.bestpractical.com<mailto:rt-users at lists.bestpractical.com>
Oggetto: Re: [rt-users] Error in article history

On Thu, Oct 17, 2013 at 08:33:27AM +0000, Guadagnino Cristiano wrote:


   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?


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



 You likely still have a Transaction record or ObjectCustomFieldValue
 record with the wrong ObjectType that those scripts should have fixed
 for you.


--
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20131018/2ffed13f/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: logofacebookfc0712
Type: image/png
Size: 746 bytes
Desc: logofacebookfc0712
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20131018/2ffed13f/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: logoyoutube0016af
Type: image/png
Size: 1108 bytes
Desc: logoyoutube0016af
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20131018/2ffed13f/attachment-0001.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: logocreval9143dd
Type: image/png
Size: 1028 bytes
Desc: logocreval9143dd
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20131018/2ffed13f/attachment-0002.png>