Dumpfile-to-rt-3.0 1.23

Hi. We’re long time rt 2.0.13 users. I’ve built an instance of 3.3.9 on
Fedora Core 3. I dumped the contents of our 2.X database using the 1.23
version of the rt-2.0-to-dumpfile tool. When I try to import this into the
new system I get through all the users, groups, etc, but on the first ticket
I get:

gggggggggrrrrrrrrrrrrrrrrrrrrrrrrrrrrfffqqqqqqqqqqqqqqqqqqqqqqqqqqqqImportin
g tickets…t-1 Couldn’t create trans 1
$VAR1 = {
‘Type’ => ‘Create’,
‘Ticket’ => ‘1’,
‘Created’ => ‘2002-04-11 12:32:06’,
‘id’ => 1,
‘Creator’ => ‘554’,
‘ActivateScrips’ => ‘0’
};

We’re on mysql 4.0.22 using InnoDB, perl 5.8.5, all dependencies OK.

Any ideas? I couldn’t find anything on the wiki.

Thanks,
Gary

Get the latest news on SurfControl and our products,
subscribe to our monthly e-newsletter, SurfAdvisory at:
http://www.surfcontrol.com/resources/surfadvisory/surfadvisory_signup.aspx

The information in this email is confidential and may be legally
privileged. It is intended solely for the addressee. Access to this
email by anyone else is unauthorized. If you are not the intended
recipient, any disclosure, copying, distribution or any action taken
or omitted to be taken in reliance on it, is prohibited and may be
unlawful. If you believe that you have received this email in error,
please contact the sender.

Transaction have no field ‘ActivateScrips’. I think you’ve added it in
2.0.x. IMHO you should delete it in 2.0 DB and export data again.

Gary Holmes wrote:

Hi,

Nope that’s not it.

A) I can’t find any mention of ‘ActivateScrips’ in our 2.x db

B) the dump imports into 3.0.12 just fine…

Gary

-----Original Message-----
From: Ruslan U. Zakirov [mailto:Ruslan.Zakirov@acronis.com]
Sent: 27 November 2004 08:58
To: Gary Holmes
Cc: rt-users@lists.fsck.com
Subject: Re: [rt-users] dumpfile-to-rt-3.0 1.23

Transaction have no field ‘ActivateScrips’. I think you’ve
added it in 2.0.x. IMHO you should delete it in 2.0 DB and
export data again.

Gary Holmes wrote:

Hi. We’re long time rt 2.0.13 users. I’ve built an instance
of 3.3.9
on Fedora Core 3. I dumped the contents of our 2.X database
using the
1.23 version of the rt-2.0-to-dumpfile tool. When I try to
import this
into the new system I get through all the users, groups,
etc, but on
the first ticket I get:

gggggggggrrrrrrrrrrrrrrrrrrrrrrrrrrrrfffqqqqqqqqqqqqqqqqqqqqqqqqqqqqIm

portin g tickets…t-1 Couldn’t create trans 1
$VAR1 = {
‘Type’ => ‘Create’,
‘Ticket’ => ‘1’,
‘Created’ => ‘2002-04-11 12:32:06’,
‘id’ => 1,
‘Creator’ => ‘554’,
‘ActivateScrips’ => ‘0’
};

We’re on mysql 4.0.22 using InnoDB, perl 5.8.5, all dependencies OK.

Any ideas? I couldn’t find anything on the wiki.

Thanks,
Gary

Get the latest news on SurfControl and our products,
subscribe to our
monthly e-newsletter, SurfAdvisory at:

http://www.surfcontrol.com/resources/surfadvisory/surfadvisory_signup.

aspx


The information in this email is confidential and may be legally
privileged. It is intended solely for the addressee. Access to this
email by anyone else is unauthorized. If you are not the intended
recipient, any disclosure, copying, distribution or any
action taken
or omitted to be taken in reliance on it, is prohibited and may be
unlawful. If you believe that you have received this email
in error,
please contact the sender.



http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

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

Get the latest news on SurfControl and our products,
subscribe to our monthly e-newsletter, SurfAdvisory at:
http://www.surfcontrol.com/resources/surfadvisory/surfadvisory_signup.aspx

The information in this email is confidential and may be legally
privileged. It is intended solely for the addressee. Access to this
email by anyone else is unauthorized. If you are not the intended
recipient, any disclosure, copying, distribution or any action taken
or omitted to be taken in reliance on it, is prohibited and may be
unlawful. If you believe that you have received this email in error,
please contact the sender.

All,

Work around seems to be as follows:

  • Install all dependancies for 3.3.x (I used 3.3.11)

  • Install and configure 3.0.9

  • make initialize-database in 3.0.9

  • run the dumpfile-to-rt3 with 3.0.9 installed

  • Replace 3.0.9 with 3.3.x and configure as needed.

  • run the upgrades that come with 3.3.x as per “make upgrade”

All works.

Gary

-----Original Message-----
From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf
Of Gary Holmes
Sent: 01 December 2004 16:33
To: Ruslan U. Zakirov
Cc: rt-users@lists.fsck.com
Subject: RE: [rt-users] dumpfile-to-rt-3.0 1.23

Hi,

Nope that’s not it.

A) I can’t find any mention of ‘ActivateScrips’ in our 2.x db

B) the dump imports into 3.0.12 just fine…

Gary

-----Original Message-----
From: Ruslan U. Zakirov [mailto:Ruslan.Zakirov@acronis.com]
Sent: 27 November 2004 08:58
To: Gary Holmes
Cc: rt-users@lists.fsck.com
Subject: Re: [rt-users] dumpfile-to-rt-3.0 1.23

Transaction have no field ‘ActivateScrips’. I think you’ve
added it in
2.0.x. IMHO you should delete it in 2.0 DB and export data again.

Gary Holmes wrote:

Hi. We’re long time rt 2.0.13 users. I’ve built an instance
of 3.3.9
on Fedora Core 3. I dumped the contents of our 2.X database
using the
1.23 version of the rt-2.0-to-dumpfile tool. When I try to
import this
into the new system I get through all the users, groups,
etc, but on
the first ticket I get:

gggggggggrrrrrrrrrrrrrrrrrrrrrrrrrrrrfffqqqqqqqqqqqqqqqqqqqqqqqqqqqqIm

portin g tickets…t-1 Couldn’t create trans 1
$VAR1 = {
‘Type’ => ‘Create’,
‘Ticket’ => ‘1’,
‘Created’ => ‘2002-04-11 12:32:06’,
‘id’ => 1,
‘Creator’ => ‘554’,
‘ActivateScrips’ => ‘0’
};

We’re on mysql 4.0.22 using InnoDB, perl 5.8.5, all
dependencies OK.

Any ideas? I couldn’t find anything on the wiki.

Thanks,
Gary

Get the latest news on SurfControl and our products,
subscribe to our
monthly e-newsletter, SurfAdvisory at:

http://www.surfcontrol.com/resources/surfadvisory/surfadvisory_signup.

aspx


The information in this email is confidential and may be legally
privileged. It is intended solely for the addressee.
Access to this

email by anyone else is unauthorized. If you are not the intended
recipient, any disclosure, copying, distribution or any
action taken
or omitted to be taken in reliance on it, is prohibited
and may be

unlawful. If you believe that you have received this email
in error,
please contact the sender.



http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

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

Get the latest news on SurfControl and our products,
subscribe to our monthly e-newsletter, SurfAdvisory at:
http://www.surfcontrol.com/resources/surfadvisory/surfadvisory
_signup.aspx


The information in this email is confidential and may be
legally privileged. It is intended solely for the addressee.
Access to this email by anyone else is unauthorized. If you
are not the intended recipient, any disclosure, copying,
distribution or any action taken or omitted to be taken in
reliance on it, is prohibited and may be unlawful. If you
believe that you have received this email in error, please
contact the sender.



http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

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

Get the latest news on SurfControl and our products,
subscribe to our monthly e-newsletter, SurfAdvisory at:
http://www.surfcontrol.com/resources/surfadvisory/surfadvisory_signup.aspx

The information in this email is confidential and may be legally
privileged. It is intended solely for the addressee. Access to this
email by anyone else is unauthorized. If you are not the intended
recipient, any disclosure, copying, distribution or any action taken
or omitted to be taken in reliance on it, is prohibited and may be
unlawful. If you believe that you have received this email in error,
please contact the sender.