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
The rt-users Archives
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: Careers — Best Practical Solutions
Best regards, Ruslan.