[rt-users] Error in RT after a rebuild

[Mike Coakley]

Several months ago we had an issue in which the host running our RT
instance got corrupt. I was able to restore the majority of our data
with two exceptions: the ObjectCustomFieldValues table and the
CustomFieldValues table. Bringing the CustomFieldValues table back to
normal was easy. The ObjectCustomFieldValues table has not been so
easy.

A little more information... During the recovery I also took the
opportunity to upgrade from 3.6.7 to 4.0.5. I still have the 3.6.7
database that was fully restored and repaired prior to the upgrade.

Once I upgraded to 4.0.5 I ran rt-validator. It fixed a ton of stuff
(as expected).

My plan to fix the missing ObjectCustomFieldValues was to run some SQL
to first find the missing records, then lookup the transactions for
the custom field and pull the last edit value and insert a new value
into the table. But I can now see I'm missing about 28K transactions
with links to the table.

I'm also getting the following error on the ticket display page with
any ticket that has transactions in which the ObjectCustomFieldValues
table is missing data:


Can't call method "new" on an undefined value at
/opt/rt4/sbin/../lib/RT/ObjectCustomFieldValue.pm line 304

Any ideas on how I can proceed?

Mike
Sent from my iPhone