Rt2.0.15 PostgreSQL to rt3.4.0 MySQL

Trying to go from rt2.0.15 PostgreSQL to rt3.4.0 MySQL and I’m getting some errors when I try and load the dump created by rt2-to-dumpfile with dumpfile-to-rt3. Any ideas as to what’s going on?

Original Server: rt2.0.15, Red Hat Linux 7.3, Perl 5.6.1, Postgresql 7.2.4 (Dual PII-266MHz, 190MB memory, 8000 tickets)
New Server: rt3.4.0, Red Hat Enterprise Linux, Perl 5.8.6, MySQL 4.1.9 (Dual Xeon 3.4GHz, 4GB memory)

[root@ul174 rt2-to-rt3-1.23]# ./dumpfile-to-rt-3.0 /rt
Use of uninitialized value in concatenation (.) or string at /rt/rt3.4/etc/RT_SiteConfig.pm line 56.
Use of uninitialized value in concatenation (.) or string at /rt/rt3.4/etc/RT_SiteConfig.pm line 60.
Importing users
uCreating user joe.blow@principal.com
.uCreating user joe.blow@prinicpal.com
.
.
.
Importing groups
grrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrfffffqqqqqqqqqqImporting ticketsImporting links
l[Wed Feb 2 21:11:57 2005] [crit]: RT::Ticket=HASH(0x9ef3bfc) tried to load a bogus ticket: 34
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb 2 21:11:57 2005] [crit]: RT::Ticket=HASH(0x9ef5dd8) tried to load a bogus ticket: 254
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb 2 21:11:57 2005] [crit]: RT::Ticket=HASH(0x9ee0954) tried to load a bogus ticket: 385
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb 2 21:11:57 2005] [crit]: RT::Ticket=HASH(0x9eeb324) tried to load a bogus ticket: 385
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb 2 21:11:57 2005] [crit]: RT::Ticket=HASH(0x9ef5e38) tried to load a bogus ticket: 386
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb 2 21:11:57 2005] [crit]: RT::Ticket=HASH(0x9eed4a8) tried to load a bogus ticket: 386
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb 2 21:11:58 2005] [crit]: RT::Ticket=HASH(0x9eeb39c) tried to load a bogus ticket: 390
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb 2 21:11:58 2005] [crit]: RT::Ticket=HASH(0x9ee7378) tried to load a bogus ticket: 157
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb 2 21:11:58 2005] [crit]: RT::Ticket=HASH(0x9ede988) tried to load a bogus ticket: 391
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb 2 21:11:58 2005] [crit]: RT::Ticket=HASH(0x9ef5dd8) tried to load a bogus ticket: 392
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb 2 21:11:58 2005] [crit]: RT::Ticket=HASH(0x9ede7f0) tried to load a bogus ticket: 491
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb 2 21:11:58 2005] [crit]: RT::Ticket=HASH(0x9eed538) tried to load a bogus ticket: 684
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb 2 21:11:58 2005] [crit]: RT::Ticket=HASH(0x9ef3bfc) tried to load a bogus ticket: 746
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb 2 21:11:58 2005] [crit]: RT::Ticket=HASH(0x9eef6d0) tried to load a bogus ticket: 777
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb 2 21:11:58 2005] [crit]: RT::Ticket=HASH(0x9ee72b8) tried to load a bogus ticket: 849
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb 2 21:11:58 2005] [crit]: RT::Ticket=HASH(0x9ee9444) tried to load a bogus ticket: 850
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb 2 21:11:58 2005] [crit]: RT::Ticket=HASH(0x9ede988) tried to load a bogus ticket: 899
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb 2 21:11:58 2005] [crit]: RT::Ticket=HASH(0x9eed490) tried to load a bogus ticket: 926
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb 2 21:11:59 2005] [crit]: RT::Ticket=HASH(0x9ede9dc) tried to load a bogus ticket: 1017
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb 2 21:11:59 2005] [crit]: RT::Ticket=HASH(0x9f424c0) tried to load a bogus ticket: 1149
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb 2 21:11:59 2005] [crit]: RT::Ticket=HASH(0x9eeb150) tried to load a bogus ticket: 1184
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb 2 21:11:59 2005] [crit]: RT::Ticket=HASH(0x9ede8ec) tried to load a bogus ticket: 1320
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb 2 21:11:59 2005] [crit]: RT::Ticket=HASH(0x9edea84) tried to load a bogus ticket: 1655
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb 2 21:11:59 2005] [crit]: RT::Ticket=HASH(0x9eef634) tried to load a bogus ticket: 2092
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb 2 21:11:59 2005] [crit]: RT::Ticket=HASH(0x9ee0954) tried to load a bogus ticket: 2245
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb 2 21:11:59 2005] [crit]: RT::Ticket=HASH(0x9eed4c0) tried to load a bogus ticket: 2343
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb 2 21:11:59 2005] [crit]: RT::Ticket=HASH(0x9ede970) tried to load a bogus ticket: 2353
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb 2 21:11:59 2005] [crit]: RT::Ticket=HASH(0x9ee72b8) tried to load a bogus ticket: 1684
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb 2 21:11:59 2005] [crit]: RT::Ticket=HASH(0x9ee9444) tried to load a bogus ticket: 2485
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb 2 21:11:59 2005] [crit]: RT::Ticket=HASH(0x9ee099c) tried to load a bogus ticket: 2485
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb 2 21:11:59 2005] [crit]: RT::Ticket=HASH(0x9ee9378) tried to load a bogus ticket: 2732
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb 2 21:11:59 2005] [crit]: RT::Ticket=HASH(0x9f412c0) tried to load a bogus ticket: 2731
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb 2 21:12:00 2005] [crit]: RT::Ticket=HASH(0x9ede874) tried to load a bogus ticket: 2728
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb 2 21:12:00 2005] [crit]: RT::Ticket=HASH(0x9ede97c) tried to load a bogus ticket: 2752
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)

Could not create scrip: On Correspond Notify Owner With Attach with template Correspondence in queue0 – $VAR1 = {
‘ScripCondition’ => ‘On Correspond’,
‘ScripAction’ => ‘Notify Owner With Attach’,
‘Queue’ => ‘0’,
‘Template’ => ‘Correspondence’,
‘Description’ => ‘Imported from RT 2.0’
};

  • may be due to a non-standard template, condition or action

Could not create scrip: On Correspond Notify Requestors, Ccs and AdminCcs With Attach with template Correspondence in queue #0

  • may be due to a non-standard template, condition or action

Could not create scrip: On Create Autoreply To Requestors with template Matt Autoreply in queue #6

  • may be due to a non-standard template, condition or action

Could not create scrip: On Create Autoreply To Requestors with template Midrange Auto Response in queue #7

  • may be due to a non-standard template, condition or action

Could not create scrip: On Owner Change Notify Owner with template Assigned in queue #7

  • may be due to a non-standard template, condition or action

Could not create scrip: On Ticket Pickup Open Ticket with template blank in queue #7

  • may be due to a non-standard template, condition or action

Could not create scrip: On Owner Change Open Ticket with template blank in queue #7

  • may be due to a non-standard template, condition or action

Could not create scrip: On Create Autoreply To Requestors with template Quote Autoreply in queue #9

  • may be due to a non-standard template, condition or action

Could not create scrip: On Create Autoreply To Requestors with template To Do Reply in queue #10

  • may be due to a non-standard template, condition or action
    Couldn’t create link from fsck.com-rt:/ticket/254 to fsck.com-rt:/ticket/270
    Couldn’t create link from fsck.com-rt:/ticket/385 to fsck.com-rt:/ticket/57
    Couldn’t create link from fsck.com-rt:/ticket/386 to fsck.com-rt:/ticket/57
    Couldn’t create link from fsck.com-rt:/ticket/390 to fsck.com-rt:/ticket/57
    Couldn’t create link from fsck.com-rt:/ticket/157 to fsck.com-rt:/ticket/390
    Couldn’t create link from fsck.com-rt:/ticket/391 to fsck.com-rt:/ticket/57
    Couldn’t create link from fsck.com-rt:/ticket/392 to fsck.com-rt:/ticket/57
    Couldn’t create link from fsck.com-rt:/ticket/777 to fsck.com-rt:/ticket/391
    Couldn’t create link from fsck.com-rt:/ticket/849 to fsck.com-rt:/ticket/392
    Couldn’t create link from fsck.com-rt:/ticket/850 to fsck.com-rt:/ticket/385
    Couldn’t create link from fsck.com-rt:/ticket/2485 to fsck.com-rt:/ticket/158

-----Message Disclaimer-----

This e-mail message is intended only for the use of the individual or
entity to which it is addressed, and may contain information that is
privileged, confidential and exempt from disclosure under applicable law.
If you are not the intended recipient, any dissemination, distribution or
copying of this communication is strictly prohibited. If you have
received this communication in error, please notify us immediately by
reply email to Connect@principal.com and delete or destroy all copies of
the original message and attachments thereto. Email sent to or from the
Principal Financial Group or any of its member companies may be retained
as required by law or regulation.

Nothing in this message is intended to constitute an Electronic signature
for purposes of the Uniform Electronic Transactions Act (UETA) or the
Electronic Signatures in Global and National Commerce Act (“E-Sign”)
unless a specific statement to the contrary is included in this message.

To reply to myself with an update on what I’ve tried…

I’ve also tried installing 3.2.2 and running the dumpfile-to-rt3 again with the same results.
I did notice that the original dump that I’m trying to load was done using rt2-to-rt3-1.21 and not 1.23 that I’m trying to use to load it. I’m redumping with 1.23 to see if that makes a difference.

Matt-----Original Message-----
From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com]On Behalf Of Millard,
Matt
Sent: Wednesday, February 02, 2005 3:27 PM
To: rt-users@lists.bestpractical.com
Subject: [rt-users] rt2.0.15 PostgreSQL to rt3.4.0 MySQL

Trying to go from rt2.0.15 PostgreSQL to rt3.4.0 MySQL and I’m getting some errors when I try and load the dump created by rt2-to-dumpfile with dumpfile-to-rt3. Any ideas as to what’s going on?

Original Server: rt2.0.15, Red Hat Linux 7.3, Perl 5.6.1, Postgresql 7.2.4 (Dual PII-266MHz, 190MB memory, 8000 tickets)
New Server: rt3.4.0, Red Hat Enterprise Linux, Perl 5.8.6, MySQL 4.1.9 (Dual Xeon 3.4GHz, 4GB memory)

[root@ul174 rt2-to-rt3-1.23]# ./dumpfile-to-rt-3.0 /rt
Use of uninitialized value in concatenation (.) or string at /rt/rt3.4/etc/RT_SiteConfig.pm line 56.
Use of uninitialized value in concatenation (.) or string at /rt/rt3.4/etc/RT_SiteConfig.pm line 60.
Importing users
uCreating user joe.blow@principal.com
.uCreating user joe.blow@prinicpal.com
.
.
.
Importing groups
grrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrfffffqqqqqqqqqqImporting ticketsImporting links
l[Wed Feb 2 21:11:57 2005] [crit]: RT::Ticket=HASH(0x9ef3bfc) tried to load a bogus ticket: 34
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb 2 21:11:57 2005] [crit]: RT::Ticket=HASH(0x9ef5dd8) tried to load a bogus ticket: 254
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb 2 21:11:57 2005] [crit]: RT::Ticket=HASH(0x9ee0954) tried to load a bogus ticket: 385
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb 2 21:11:57 2005] [crit]: RT::Ticket=HASH(0x9eeb324) tried to load a bogus ticket: 385
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb 2 21:11:57 2005] [crit]: RT::Ticket=HASH(0x9ef5e38) tried to load a bogus ticket: 386
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb 2 21:11:57 2005] [crit]: RT::Ticket=HASH(0x9eed4a8) tried to load a bogus ticket: 386
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb 2 21:11:58 2005] [crit]: RT::Ticket=HASH(0x9eeb39c) tried to load a bogus ticket: 390
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb 2 21:11:58 2005] [crit]: RT::Ticket=HASH(0x9ee7378) tried to load a bogus ticket: 157
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb 2 21:11:58 2005] [crit]: RT::Ticket=HASH(0x9ede988) tried to load a bogus ticket: 391
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb 2 21:11:58 2005] [crit]: RT::Ticket=HASH(0x9ef5dd8) tried to load a bogus ticket: 392
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb 2 21:11:58 2005] [crit]: RT::Ticket=HASH(0x9ede7f0) tried to load a bogus ticket: 491
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb 2 21:11:58 2005] [crit]: RT::Ticket=HASH(0x9eed538) tried to load a bogus ticket: 684
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb 2 21:11:58 2005] [crit]: RT::Ticket=HASH(0x9ef3bfc) tried to load a bogus ticket: 746
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb 2 21:11:58 2005] [crit]: RT::Ticket=HASH(0x9eef6d0) tried to load a bogus ticket: 777
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb 2 21:11:58 2005] [crit]: RT::Ticket=HASH(0x9ee72b8) tried to load a bogus ticket: 849
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb 2 21:11:58 2005] [crit]: RT::Ticket=HASH(0x9ee9444) tried to load a bogus ticket: 850
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb 2 21:11:58 2005] [crit]: RT::Ticket=HASH(0x9ede988) tried to load a bogus ticket: 899
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb 2 21:11:58 2005] [crit]: RT::Ticket=HASH(0x9eed490) tried to load a bogus ticket: 926
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb 2 21:11:59 2005] [crit]: RT::Ticket=HASH(0x9ede9dc) tried to load a bogus ticket: 1017
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb 2 21:11:59 2005] [crit]: RT::Ticket=HASH(0x9f424c0) tried to load a bogus ticket: 1149
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb 2 21:11:59 2005] [crit]: RT::Ticket=HASH(0x9eeb150) tried to load a bogus ticket: 1184
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb 2 21:11:59 2005] [crit]: RT::Ticket=HASH(0x9ede8ec) tried to load a bogus ticket: 1320
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb 2 21:11:59 2005] [crit]: RT::Ticket=HASH(0x9edea84) tried to load a bogus ticket: 1655
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb 2 21:11:59 2005] [crit]: RT::Ticket=HASH(0x9eef634) tried to load a bogus ticket: 2092
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb 2 21:11:59 2005] [crit]: RT::Ticket=HASH(0x9ee0954) tried to load a bogus ticket: 2245
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb 2 21:11:59 2005] [crit]: RT::Ticket=HASH(0x9eed4c0) tried to load a bogus ticket: 2343
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb 2 21:11:59 2005] [crit]: RT::Ticket=HASH(0x9ede970) tried to load a bogus ticket: 2353
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb 2 21:11:59 2005] [crit]: RT::Ticket=HASH(0x9ee72b8) tried to load a bogus ticket: 1684
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb 2 21:11:59 2005] [crit]: RT::Ticket=HASH(0x9ee9444) tried to load a bogus ticket: 2485
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb 2 21:11:59 2005] [crit]: RT::Ticket=HASH(0x9ee099c) tried to load a bogus ticket: 2485
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb 2 21:11:59 2005] [crit]: RT::Ticket=HASH(0x9ee9378) tried to load a bogus ticket: 2732
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb 2 21:11:59 2005] [crit]: RT::Ticket=HASH(0x9f412c0) tried to load a bogus ticket: 2731
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb 2 21:12:00 2005] [crit]: RT::Ticket=HASH(0x9ede874) tried to load a bogus ticket: 2728
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb 2 21:12:00 2005] [crit]: RT::Ticket=HASH(0x9ede97c) tried to load a bogus ticket: 2752
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)

Could not create scrip: On Correspond Notify Owner With Attach with template Correspondence in queue0 – $VAR1 = {
‘ScripCondition’ => ‘On Correspond’,
‘ScripAction’ => ‘Notify Owner With Attach’,
‘Queue’ => ‘0’,
‘Template’ => ‘Correspondence’,
‘Description’ => ‘Imported from RT 2.0’
};

  • may be due to a non-standard template, condition or action

Could not create scrip: On Correspond Notify Requestors, Ccs and AdminCcs With Attach with template Correspondence in queue #0

  • may be due to a non-standard template, condition or action

Could not create scrip: On Create Autoreply To Requestors with template Matt Autoreply in queue #6

  • may be due to a non-standard template, condition or action

Could not create scrip: On Create Autoreply To Requestors with template Midrange Auto Response in queue #7

  • may be due to a non-standard template, condition or action

Could not create scrip: On Owner Change Notify Owner with template Assigned in queue #7

  • may be due to a non-standard template, condition or action

Could not create scrip: On Ticket Pickup Open Ticket with template blank in queue #7

  • may be due to a non-standard template, condition or action

Could not create scrip: On Owner Change Open Ticket with template blank in queue #7

  • may be due to a non-standard template, condition or action

Could not create scrip: On Create Autoreply To Requestors with template Quote Autoreply in queue #9

  • may be due to a non-standard template, condition or action

Could not create scrip: On Create Autoreply To Requestors with template To Do Reply in queue #10

  • may be due to a non-standard template, condition or action
    Couldn’t create link from fsck.com-rt:/ticket/254 to fsck.com-rt:/ticket/270
    Couldn’t create link from fsck.com-rt:/ticket/385 to fsck.com-rt:/ticket/57
    Couldn’t create link from fsck.com-rt:/ticket/386 to fsck.com-rt:/ticket/57
    Couldn’t create link from fsck.com-rt:/ticket/390 to fsck.com-rt:/ticket/57
    Couldn’t create link from fsck.com-rt:/ticket/157 to fsck.com-rt:/ticket/390
    Couldn’t create link from fsck.com-rt:/ticket/391 to fsck.com-rt:/ticket/57
    Couldn’t create link from fsck.com-rt:/ticket/392 to fsck.com-rt:/ticket/57
    Couldn’t create link from fsck.com-rt:/ticket/777 to fsck.com-rt:/ticket/391
    Couldn’t create link from fsck.com-rt:/ticket/849 to fsck.com-rt:/ticket/392
    Couldn’t create link from fsck.com-rt:/ticket/850 to fsck.com-rt:/ticket/385
    Couldn’t create link from fsck.com-rt:/ticket/2485 to fsck.com-rt:/ticket/158

-----Message Disclaimer-----

This e-mail message is intended only for the use of the individual or
entity to which it is addressed, and may contain information that is
privileged, confidential and exempt from disclosure under applicable law.
If you are not the intended recipient, any dissemination, distribution or
copying of this communication is strictly prohibited. If you have
received this communication in error, please notify us immediately by
reply email to Connect@principal.com and delete or destroy all copies of
the original message and attachments thereto. Email sent to or from the
Principal Financial Group or any of its member companies may be retained
as required by law or regulation.

Nothing in this message is intended to constitute an Electronic signature
for purposes of the Uniform Electronic Transactions Act (UETA) or the
Electronic Signatures in Global and National Commerce Act (“E-Sign”)
unless a specific statement to the contrary is included in this message.
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

RT Administrator and Developer training is coming to your town soon! (Boston, San Francisco, Austin, Sydney) Contact training@bestpractical.com for details.

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

-----Message Disclaimer-----

This e-mail message is intended only for the use of the individual or
entity to which it is addressed, and may contain information that is
privileged, confidential and exempt from disclosure under applicable law.
If you are not the intended recipient, any dissemination, distribution or
copying of this communication is strictly prohibited. If you have
received this communication in error, please notify us immediately by
reply email to Connect@principal.com and delete or destroy all copies of
the original message and attachments thereto. Email sent to or from the
Principal Financial Group or any of its member companies may be retained
as required by law or regulation.

Nothing in this message is intended to constitute an Electronic signature
for purposes of the Uniform Electronic Transactions Act (UETA) or the
Electronic Signatures in Global and National Commerce Act (“E-Sign”)
unless a specific statement to the contrary is included in this message.

One last reply, hopefully. Import is working with tickets dumped using 1.23 not 1.21. Ran into another problem with max_allowed_packet error on MySQL, but I think I’ve got that worked out by editting my.cnf.

Matt-----Original Message-----
From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com]On Behalf Of Millard,
Matt
Sent: Thursday, February 03, 2005 10:55 AM
To: rt-users@lists.bestpractical.com
Subject: RE: [rt-users] rt2.0.15 PostgreSQL to rt3.4.0 MySQL

To reply to myself with an update on what I’ve tried…

I’ve also tried installing 3.2.2 and running the dumpfile-to-rt3 again with the same results.
I did notice that the original dump that I’m trying to load was done using rt2-to-rt3-1.21 and not 1.23 that I’m trying to use to load it. I’m redumping with 1.23 to see if that makes a difference.

Matt

-----Original Message-----
From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com]On Behalf Of Millard,
Matt
Sent: Wednesday, February 02, 2005 3:27 PM
To: rt-users@lists.bestpractical.com
Subject: [rt-users] rt2.0.15 PostgreSQL to rt3.4.0 MySQL

Trying to go from rt2.0.15 PostgreSQL to rt3.4.0 MySQL and I’m getting some errors when I try and load the dump created by rt2-to-dumpfile with dumpfile-to-rt3. Any ideas as to what’s going on?

Original Server: rt2.0.15, Red Hat Linux 7.3, Perl 5.6.1, Postgresql 7.2.4 (Dual PII-266MHz, 190MB memory, 8000 tickets)
New Server: rt3.4.0, Red Hat Enterprise Linux, Perl 5.8.6, MySQL 4.1.9 (Dual Xeon 3.4GHz, 4GB memory)

[root@ul174 rt2-to-rt3-1.23]# ./dumpfile-to-rt-3.0 /rt
Use of uninitialized value in concatenation (.) or string at /rt/rt3.4/etc/RT_SiteConfig.pm line 56.
Use of uninitialized value in concatenation (.) or string at /rt/rt3.4/etc/RT_SiteConfig.pm line 60.
Importing users
uCreating user joe.blow@principal.com
.uCreating user joe.blow@prinicpal.com
.
.
.
Importing groups
grrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrfffffqqqqqqqqqqImporting ticketsImporting links
l[Wed Feb 2 21:11:57 2005] [crit]: RT::Ticket=HASH(0x9ef3bfc) tried to load a bogus ticket: 34
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb 2 21:11:57 2005] [crit]: RT::Ticket=HASH(0x9ef5dd8) tried to load a bogus ticket: 254
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb 2 21:11:57 2005] [crit]: RT::Ticket=HASH(0x9ee0954) tried to load a bogus ticket: 385
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb 2 21:11:57 2005] [crit]: RT::Ticket=HASH(0x9eeb324) tried to load a bogus ticket: 385
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb 2 21:11:57 2005] [crit]: RT::Ticket=HASH(0x9ef5e38) tried to load a bogus ticket: 386
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb 2 21:11:57 2005] [crit]: RT::Ticket=HASH(0x9eed4a8) tried to load a bogus ticket: 386
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb 2 21:11:58 2005] [crit]: RT::Ticket=HASH(0x9eeb39c) tried to load a bogus ticket: 390
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb 2 21:11:58 2005] [crit]: RT::Ticket=HASH(0x9ee7378) tried to load a bogus ticket: 157
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb 2 21:11:58 2005] [crit]: RT::Ticket=HASH(0x9ede988) tried to load a bogus ticket: 391
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb 2 21:11:58 2005] [crit]: RT::Ticket=HASH(0x9ef5dd8) tried to load a bogus ticket: 392
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb 2 21:11:58 2005] [crit]: RT::Ticket=HASH(0x9ede7f0) tried to load a bogus ticket: 491
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb 2 21:11:58 2005] [crit]: RT::Ticket=HASH(0x9eed538) tried to load a bogus ticket: 684
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb 2 21:11:58 2005] [crit]: RT::Ticket=HASH(0x9ef3bfc) tried to load a bogus ticket: 746
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb 2 21:11:58 2005] [crit]: RT::Ticket=HASH(0x9eef6d0) tried to load a bogus ticket: 777
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb 2 21:11:58 2005] [crit]: RT::Ticket=HASH(0x9ee72b8) tried to load a bogus ticket: 849
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb 2 21:11:58 2005] [crit]: RT::Ticket=HASH(0x9ee9444) tried to load a bogus ticket: 850
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb 2 21:11:58 2005] [crit]: RT::Ticket=HASH(0x9ede988) tried to load a bogus ticket: 899
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb 2 21:11:58 2005] [crit]: RT::Ticket=HASH(0x9eed490) tried to load a bogus ticket: 926
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb 2 21:11:59 2005] [crit]: RT::Ticket=HASH(0x9ede9dc) tried to load a bogus ticket: 1017
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb 2 21:11:59 2005] [crit]: RT::Ticket=HASH(0x9f424c0) tried to load a bogus ticket: 1149
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb 2 21:11:59 2005] [crit]: RT::Ticket=HASH(0x9eeb150) tried to load a bogus ticket: 1184
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb 2 21:11:59 2005] [crit]: RT::Ticket=HASH(0x9ede8ec) tried to load a bogus ticket: 1320
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb 2 21:11:59 2005] [crit]: RT::Ticket=HASH(0x9edea84) tried to load a bogus ticket: 1655
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb 2 21:11:59 2005] [crit]: RT::Ticket=HASH(0x9eef634) tried to load a bogus ticket: 2092
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb 2 21:11:59 2005] [crit]: RT::Ticket=HASH(0x9ee0954) tried to load a bogus ticket: 2245
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb 2 21:11:59 2005] [crit]: RT::Ticket=HASH(0x9eed4c0) tried to load a bogus ticket: 2343
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb 2 21:11:59 2005] [crit]: RT::Ticket=HASH(0x9ede970) tried to load a bogus ticket: 2353
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb 2 21:11:59 2005] [crit]: RT::Ticket=HASH(0x9ee72b8) tried to load a bogus ticket: 1684
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb 2 21:11:59 2005] [crit]: RT::Ticket=HASH(0x9ee9444) tried to load a bogus ticket: 2485
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb 2 21:11:59 2005] [crit]: RT::Ticket=HASH(0x9ee099c) tried to load a bogus ticket: 2485
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb 2 21:11:59 2005] [crit]: RT::Ticket=HASH(0x9ee9378) tried to load a bogus ticket: 2732
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb 2 21:11:59 2005] [crit]: RT::Ticket=HASH(0x9f412c0) tried to load a bogus ticket: 2731
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb 2 21:12:00 2005] [crit]: RT::Ticket=HASH(0x9ede874) tried to load a bogus ticket: 2728
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb 2 21:12:00 2005] [crit]: RT::Ticket=HASH(0x9ede97c) tried to load a bogus ticket: 2752
(/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)

Could not create scrip: On Correspond Notify Owner With Attach with template Correspondence in queue0 – $VAR1 = {
‘ScripCondition’ => ‘On Correspond’,
‘ScripAction’ => ‘Notify Owner With Attach’,
‘Queue’ => ‘0’,
‘Template’ => ‘Correspondence’,
‘Description’ => ‘Imported from RT 2.0’
};

  • may be due to a non-standard template, condition or action

Could not create scrip: On Correspond Notify Requestors, Ccs and AdminCcs With Attach with template Correspondence in queue #0

  • may be due to a non-standard template, condition or action

Could not create scrip: On Create Autoreply To Requestors with template Matt Autoreply in queue #6

  • may be due to a non-standard template, condition or action

Could not create scrip: On Create Autoreply To Requestors with template Midrange Auto Response in queue #7

  • may be due to a non-standard template, condition or action

Could not create scrip: On Owner Change Notify Owner with template Assigned in queue #7

  • may be due to a non-standard template, condition or action

Could not create scrip: On Ticket Pickup Open Ticket with template blank in queue #7

  • may be due to a non-standard template, condition or action

Could not create scrip: On Owner Change Open Ticket with template blank in queue #7

  • may be due to a non-standard template, condition or action

Could not create scrip: On Create Autoreply To Requestors with template Quote Autoreply in queue #9

  • may be due to a non-standard template, condition or action

Could not create scrip: On Create Autoreply To Requestors with template To Do Reply in queue #10

  • may be due to a non-standard template, condition or action
    Couldn’t create link from fsck.com-rt:/ticket/254 to fsck.com-rt:/ticket/270
    Couldn’t create link from fsck.com-rt:/ticket/385 to fsck.com-rt:/ticket/57
    Couldn’t create link from fsck.com-rt:/ticket/386 to fsck.com-rt:/ticket/57
    Couldn’t create link from fsck.com-rt:/ticket/390 to fsck.com-rt:/ticket/57
    Couldn’t create link from fsck.com-rt:/ticket/157 to fsck.com-rt:/ticket/390
    Couldn’t create link from fsck.com-rt:/ticket/391 to fsck.com-rt:/ticket/57
    Couldn’t create link from fsck.com-rt:/ticket/392 to fsck.com-rt:/ticket/57
    Couldn’t create link from fsck.com-rt:/ticket/777 to fsck.com-rt:/ticket/391
    Couldn’t create link from fsck.com-rt:/ticket/849 to fsck.com-rt:/ticket/392
    Couldn’t create link from fsck.com-rt:/ticket/850 to fsck.com-rt:/ticket/385
    Couldn’t create link from fsck.com-rt:/ticket/2485 to fsck.com-rt:/ticket/158

-----Message Disclaimer-----

This e-mail message is intended only for the use of the individual or
entity to which it is addressed, and may contain information that is
privileged, confidential and exempt from disclosure under applicable law.
If you are not the intended recipient, any dissemination, distribution or
copying of this communication is strictly prohibited. If you have
received this communication in error, please notify us immediately by
reply email to Connect@principal.com and delete or destroy all copies of
the original message and attachments thereto. Email sent to or from the
Principal Financial Group or any of its member companies may be retained
as required by law or regulation.

Nothing in this message is intended to constitute an Electronic signature
for purposes of the Uniform Electronic Transactions Act (UETA) or the
Electronic Signatures in Global and National Commerce Act (“E-Sign”)
unless a specific statement to the contrary is included in this message.
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

RT Administrator and Developer training is coming to your town soon! (Boston, San Francisco, Austin, Sydney) Contact training@bestpractical.com for details.

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

-----Message Disclaimer-----

This e-mail message is intended only for the use of the individual or
entity to which it is addressed, and may contain information that is
privileged, confidential and exempt from disclosure under applicable law.
If you are not the intended recipient, any dissemination, distribution or
copying of this communication is strictly prohibited. If you have
received this communication in error, please notify us immediately by
reply email to Connect@principal.com and delete or destroy all copies of
the original message and attachments thereto. Email sent to or from the
Principal Financial Group or any of its member companies may be retained
as required by law or regulation.

Nothing in this message is intended to constitute an Electronic signature
for purposes of the Uniform Electronic Transactions Act (UETA) or the
Electronic Signatures in Global and National Commerce Act (“E-Sign”)
unless a specific statement to the contrary is included in this message.
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

RT Administrator and Developer training is coming to your town soon! (Boston, San Francisco, Austin, Sydney) Contact training@bestpractical.com for details.

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

-----Message Disclaimer-----

This e-mail message is intended only for the use of the individual or
entity to which it is addressed, and may contain information that is
privileged, confidential and exempt from disclosure under applicable law.
If you are not the intended recipient, any dissemination, distribution or
copying of this communication is strictly prohibited. If you have
received this communication in error, please notify us immediately by
reply email to Connect@principal.com and delete or destroy all copies of
the original message and attachments thereto. Email sent to or from the
Principal Financial Group or any of its member companies may be retained
as required by law or regulation.

Nothing in this message is intended to constitute an Electronic signature
for purposes of the Uniform Electronic Transactions Act (UETA) or the
Electronic Signatures in Global and National Commerce Act (“E-Sign”)
unless a specific statement to the contrary is included in this message.

Hi, I don’t mean to start a Windows/Unix war; all that I would like to know
is RT recommended to install on Windows? I know that it is
platform-independent, but are there any hassles/problems with installing
this on Windows?

Any comments will be appreciated

Best Regards,
Ravin Mathoora

Running RT v3.0.12 on Windows. Runs fine. Have a single outstanding
item that I would like to resolve but haven’t found the time to sit down
and take a look. Content search doesn’t work as advertised. Logs
suggest that a bad SQL statement to blame. Someday …

Company has both Windows and Unix (Red Hat & Solaris) admins. We share
ticketing system. When offered the chance to migrate to *nix, the Unix
guys shrug their shoulders and take a pass. Endorsement? Probably not.
I think they’re just avoiding work but if the unix admins are happy
with functionality and performance that counts for something.