[rt-devel] rt2->rt3 migration woes.

[J. Sloan]

Jesse,

  Further to our conversation the other day, I tracked down my 'Data
error's to the transaction table in my RT2 instance:

mysql> select * from Transactions where id like '1000';
+------+-----------------+--------+-----------+------------+-------+----------+------------+------+---------+---------------------+
| id   | EffectiveTicket | Ticket | TimeTaken | Type       | Field |
OldValue |
NewValue   | Data | Creator | Created             |
+------+-----------------+--------+-----------+------------+-------+----------+------------+------+---------+---------------------+
| 1000 |            NULL |    215 |         0 | AddWatcher | NULL  | NULL
|
Data error | NULL |       1 | 2003-01-10 19:32:42 |
+------+-----------------+--------+-----------+------------+-------+----------+------------+------+---------+---------------------+
1 row in set (0.03 sec)

So it appears it's nothing the dump script is doing, but actually that
text recorded in my database!

That string only appears in Watcher.pm in the code, and I recall that I
was changing user email address (via the web interface) around the time
that I first saw one appear in the ticket on the web.

I'll reset them all to be a value user email address....

[does so]

Bleh.... now I'm getting a different error.   :-(

v 1.12 of the conversion tool (with a little debugging added in):

Processing right SuperUser PrincipalId 3 Type User
[Mon May 19 18:00:01 2003] [crit]: 1 (/opt/rt3/lib/RT/ACE_Overlay.pm:884)
[Mon May 19 18:00:01 2003] [crit]: Can't load a principal for id
(/opt/rt3/lib/RT/ACE_Overlay.pm:885)
Processing right SuperUser PrincipalId 4 Type User
[Mon May 19 18:00:02 2003] [crit]: 1 (/opt/rt3/lib/RT/ACE_Overlay.pm:884)
[Mon May 19 18:00:02 2003] [crit]: Can't load a principal for id
(/opt/rt3/lib/RT/ACE_Overlay.pm:885)
Processing right SuperUser PrincipalId 29 Type User
[Mon May 19 18:00:02 2003] [crit]: 1 (/opt/rt3/lib/RT/ACE_Overlay.pm:884)
[Mon May 19 18:00:02 2003] [crit]: Can't load a principal for id
(/opt/rt3/lib/RT/ACE_Overlay.pm:885)

I'm starting to get brickmarks permenantly embedded in my forehead...

John