Not sure how to fix this error I am getting.
Posted: Sat Feb 02, 2008 9:00 am
Hey guys,
I have been setting up a tracking system for our family buisness using php and MySQL and I am having trouble with one thing.
We have a FedEx system that uploads some data when a package ships and I am having trouble with one of the fields. Here is the error that I am getting:
I have been setting up a tracking system for our family buisness using php and MySQL and I am having trouble with one thing.
We have a FedEx system that uploads some data when a package ships and I am having trouble with one of the fields. Here is the error that I am getting:
Code: Select all
[OBDC 3.51 Driver][mysld-4.1.22-standard]Unknown Column '2274888ABC' in 'field list' (RecordExport)
Now this will error on one package and not on another. By process of elimination we have figured out that it is our PO number field. When a package has a only a numerical PO (like 1234) it will ship with no error but one of our brokers uses an alpha-numeric field (like A-1234). This is the package that gets the error.
I have changed the column type from VARCHAR to TEXT (even though I didn't think this was the problem) but I had no luck. The FedEx system also passes the same info to an access database in the office for another system to use without error.
Does anyone know where I should start?
Thanks.