[rt-users] rt3-on-pg-to-mysql problem

Ruslan Zakirov ruslan.zakirov at gmail.com
Thu May 4 10:53:06 EDT 2006


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 at 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 at 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.


More information about the rt-users mailing list