Rt3-on-pg-to-mysql problem

I’ve run into a problem with this script that I’m hoping someone can
help me out with.

It seems to work fine; connecting to both databases (old and new) and
transferring data. However, when it gets to CustomFields is kicks out
an error that says
DBD::mysql::st execute failed: Unknown column ‘queue’ in ‘field list’ at
./rt3-on-pg-to-mysql line 64.

0,12,Profiles,1,Company Profile,2004-05-18 18:46:35,2004-05-18
20:37:39,1,SelectMultiple,0,12 at ./rt3-on-pg-to-mysql line 64.

Company Profile being the custom field. I looked at the information
about the CustomField table but there aren’t any columns called “queue.”

Has anyone else run into this problem?

Mathew Snyder
Systems Administrator
Network+
ServerVault TechOps

As I recall this script was writen for RT-3.0.x, but in recent
realeases schema around custom fields was changed. You can check
changes in /opt/rt3/etc/upgrade files.On 4/30/06, Mathew Snyder msnyder@servervault.com wrote:

I’ve run into a problem with this script that I’m hoping someone can
help me out with.

It seems to work fine; connecting to both databases (old and new) and
transferring data. However, when it gets to CustomFields is kicks out
an error that says
DBD::mysql::st execute failed: Unknown column ‘queue’ in ‘field list’ at
./rt3-on-pg-to-mysql line 64.

0,12,Profiles,1,Company Profile,2004-05-18 18:46:35,2004-05-18
20:37:39,1,SelectMultiple,0,12 at ./rt3-on-pg-to-mysql line 64.

Company Profile being the custom field. I looked at the information
about the CustomField table but there aren’t any columns called “queue.”

Has anyone else run into this problem?


Mathew Snyder
Systems Administrator
Network+
ServerVault TechOps


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

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

We’re hiring! Come hack Perl for Best Practical: http://bestpractical.com/about/jobs.html

Best regards, Ruslan.