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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED]


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.
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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

Reply via email to