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:
[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.
I just created a php file with the insert command and when I put in the same type of PO number. It goes in without problem.
That would limit the problem to the FedEx computer (which executes the same command to an access table with no problem) or the MySQL driver.