Client Tools to Export AC 5.X Store
Posted: Wed Mar 02, 2011 9:18 am
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:
Everything starts working okay, but when the Client Tools V4 gets to my "Orders" table, it throws an error and quits. The error is:
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?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)