Not sure how to fix this error I am getting.

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
micknc
Forum Contributor
Posts: 115
Joined: Thu Jan 24, 2008 11:13 pm

Not sure how to fix this error I am getting.

Post by micknc »

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:

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.
User avatar
Inkyskin
Forum Contributor
Posts: 282
Joined: Mon Nov 19, 2007 10:15 am
Location: UK

Re: Not sure how to fix this error I am getting.

Post by Inkyskin »

Try echoing your SQL statement, it may be that it's getting screwed up somewhere along the line
User avatar
micknc
Forum Contributor
Posts: 115
Joined: Thu Jan 24, 2008 11:13 pm

Re: Not sure how to fix this error I am getting.

Post by micknc »

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.

Anybody had anything similar?
bdlang
Forum Contributor
Posts: 395
Joined: Tue May 16, 2006 8:46 pm
Location: Ventura, CA US

Re: Not sure how to fix this error I am getting.

Post by bdlang »

Please clarify - is this SQL statement run on your server or on a FedEx server?
Unknown Column '2274888ABC' in 'field list'
It's obvious you don't have a properly formed query, as the server is receiving what is likely meant to be data as a column name.

Showing us the SQL statement would be a start, the table schema would be helpful as well.
Post Reply