1054 Unknown column 'COWOA_order' in 'field list'

Using version 1.3.9h.

Using Paypal Express as the only online payment method (no credit cards, no Google Checkout, etc).

I have it set to automatically create an account when the customer uses the Paypal Express button for their order.

I DO NOT have the COWOA mod installed.

This is what happens:

The order and payment process goes thru as expected.

It's when I go to update the status from 'Processing [2]' to 'Shipped [3]' or 'Update [4]' on the Orders page in Zen Cart, when I receive the error:

1054 Unknown column 'COWOA_order' in 'field list'
in:
[select customers_name, customers_email_address, orders_status, date_purchased, COWOA_order from zen_orders where orders_id = '1099']
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Any ideas? I'm guessing it has something to do with the Paypal Express module creating an account automatically; hence, why I posted this issue in this section of the forum. Please forgive me if this is the wrong place.

Thank you.

I DO NOT have the COWOA mod installed.

Did you ever have the module installed?

Kim:

Did you ever have the module installed?

Hi Kim, no, never had that module installed.

Well, you wouldn't get that error if one or more of your PHP files didn't have references to COWOA in them. So, someone must have installed COWOA or you've installed an addon that has COWOA mod dependencies.
The Zen Cart master files do NOT have any mention of COWOA in them.
You'll need to fully remove all the COWOA stuff from your site's files.

http://www.zen-cart.com/wiki/index.php/Troubleshoot_-_Diagnosing_Obscure_Issues

OK.

How about this - if I move forward and install the COWOA mod, do you think it will remedy the issue?

Also, when using the Developer's Tookit (great feature btw), when doing a Look-up in all files for COWOA, the following is the result:

.../my admin folder/orders.php

Line #53 : date_purchased, COWOA_order from " . TABLE_ORDERS . "

Line #90 : date_purchased, COWOA_order from " . TABLE_ORDERS . "

Line #105 : if(!$check_status->fields['COWOA_order']) {

Okay, so that confirms that at least your /admin/orders.php file has COWOA code in it that wasn't there in the original ZC version of the file.
So, that means you've changed the file somehow, either by installing the addon partially, or by installing another addon that had COWOA code in it that you didn't know about.

I do NOT recommend blindly going and installing COWOA, or any mod, without knowing what you're getting into. I think that would be the wrong direction to go.

Yes, the last mod I had installed was the Google Checkout module.

I 'turned it off', but never uninstalled it/deleted the files.

Couldn't get it to work properly with 1.3.9, so I gave up on it, and decided to stick with the Paypal Express method for the time being.

When checking the most recent backup prior to the GC install, I noticed there was no reference to the COWOA code in the admin/orders.php file.

Should I just copy that orders.php back over the existing file?

willieWontGo:

Should I just copy that orders.php back over the existing file?
It would seem logical to me to put back the original working version of the file.

SOLVED.

OK, I have copied the original working file back over and that seems to have solved the issue.

Thanks to Kim and DrByte for chiming in and assisting.