If this is your first visit, check our documentation. To post, register or login.
Forums / PayPal Express Checkout support / 1054 Unknown column 'COWOA_order' in 'field list'

1054 Unknown column 'COWOA_order' in 'field list'

Locked

Started by williewontgo on 30 Jun 2011, 5:52 PM · Views: 1,887

Results 1 to 10 of 10
This thread is locked. New replies are disabled.
30 Jun 2011, 5:52 PM
#1
williewontgo avatar

williewontgo

New Zenner

Join Date:
Oct 2009
Location:
New York, USA
Posts:
70
Plugin Contributions:
0

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.

30 Jun 2011, 6:01 PM
#2
Kim avatar

Kim

Obaa-san

Join Date:
Jun 2003
Location:
West Coast, North America
Posts:
26,747
Plugin Contributions:
0

Re: 1054 Unknown column 'COWOA_order' in 'field list'

I DO NOT have the COWOA mod installed.

Did you ever have the module installed?

Please do not PM for support issues: a private solution doesn't benefit the community.

Be careful with unsolicited advice via email or PM - Make sure the person you are talking to is a reliable source.

30 Jun 2011, 6:08 PM
#3
williewontgo avatar

williewontgo

New Zenner

Join Date:
Oct 2009
Location:
New York, USA
Posts:
70
Plugin Contributions:
0

Re: 1054 Unknown column 'COWOA_order' in 'field list'

Kim:

Did you ever have the module installed?

Hi Kim, no, never had that module installed.

30 Jun 2011, 6:14 PM
#4
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,512
Plugin Contributions:
176

Re: 1054 Unknown column 'COWOA_order' in 'field list'

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

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

30 Jun 2011, 6:18 PM
#5
williewontgo avatar

williewontgo

New Zenner

Join Date:
Oct 2009
Location:
New York, USA
Posts:
70
Plugin Contributions:
0

Re: 1054 Unknown column 'COWOA_order' in 'field list'

OK.

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

30 Jun 2011, 6:23 PM
#6
williewontgo avatar

williewontgo

New Zenner

Join Date:
Oct 2009
Location:
New York, USA
Posts:
70
Plugin Contributions:
0

Re: 1054 Unknown column 'COWOA_order' in 'field list'

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']) {

30 Jun 2011, 10:35 PM
#7
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,512
Plugin Contributions:
176

Re: 1054 Unknown column 'COWOA_order' in 'field list'

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.

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

1 Jul 2011, 2:20 AM
#8
williewontgo avatar

williewontgo

New Zenner

Join Date:
Oct 2009
Location:
New York, USA
Posts:
70
Plugin Contributions:
0

Re: 1054 Unknown column 'COWOA_order' in 'field list'

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?

1 Jul 2011, 4:31 AM
#9
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,512
Plugin Contributions:
176

Re: 1054 Unknown column 'COWOA_order' in 'field list'

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.

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

1 Jul 2011, 7:18 PM
#10
williewontgo avatar

williewontgo

New Zenner

Join Date:
Oct 2009
Location:
New York, USA
Posts:
70
Plugin Contributions:
0

Re: 1054 Unknown column 'COWOA_order' in 'field list'

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.