Client Tools to Export AC 5.X Store

[sweeperq]

Okay, I have the DataPort 7.6.248 set up and connected to my AC 7.0.6 instance, and I've installed Client Tools V4 and established a connection to my existing AC 5.X store.

Everything starts working okay, but when the Client Tools V4 gets to my "Orders" table, it throws an error and quits. The error is:

System.Data.Odbc.OdbcException: ERROR [42S22] [MySQL][ODBC 3.51 Driver][mysqld-5.1.45-community-log]Unknown column 'PaymentStatus' in 'field list'
at System.Data.Odbc.OdbcConnection.HandleError(HandleRef hrHandle, SQL_HANDLE hType, RETCODE retcode)
at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method)
at System.Data.Odbc.OdbcCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Odbc.OdbcCommand.ExecuteReader()
at ad.a(String A_0, Int32 A_1, Int32 A_2)
at o.aa(Int32 A_0)
at o.u(Int32 A_0)
at o.c(Object A_0, EventArgs A_1)
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

We are currently running AC 5.5 SR1, Build 1236 which I'm guessing has something to do with it since most service releases will include changes/database updates. Is there a version of the export that runs with this version, or are we S.O.L. unless we upgrade everything to SR3?

[jmestep]

We have run into that error on older builds of ColdFusion Able. We just added fields to the payment table for the missing pieces and then the export worked. We had to add only two fields and the message will tell you what they are.

[sweeperq]

Thanks Judy, maybe I'll try that instead of monkeying around with the internal store export to get it to export to a file.