Results 1 to 10 of 10
  1. #1
    Join Date
    Oct 2009
    Location
    New York, USA
    Posts
    70
    Plugin Contributions
    0

    Default 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.

  2. #2
    Join Date
    Jun 2003
    Posts
    33,715
    Plugin Contributions
    0

    Default 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.

  3. #3
    Join Date
    Oct 2009
    Location
    New York, USA
    Posts
    70
    Plugin Contributions
    0

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

    Quote Originally Posted by Kim View Post
    Did you ever have the module installed?
    Hi Kim, no, never had that module installed.

  4. #4
    Join Date
    Jan 2004
    Posts
    66,364
    Blog Entries
    7
    Plugin Contributions
    274

    Default 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.p...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.

  5. #5
    Join Date
    Oct 2009
    Location
    New York, USA
    Posts
    70
    Plugin Contributions
    0

    Default 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?

  6. #6
    Join Date
    Oct 2009
    Location
    New York, USA
    Posts
    70
    Plugin Contributions
    0

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

  7. #7
    Join Date
    Jan 2004
    Posts
    66,364
    Blog Entries
    7
    Plugin Contributions
    274

    Default 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.

  8. #8
    Join Date
    Oct 2009
    Location
    New York, USA
    Posts
    70
    Plugin Contributions
    0

    Default 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?

  9. #9
    Join Date
    Jan 2004
    Posts
    66,364
    Blog Entries
    7
    Plugin Contributions
    274

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

    Quote Originally Posted by willieWontGo View Post
    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.

  10. #10
    Join Date
    Oct 2009
    Location
    New York, USA
    Posts
    70
    Plugin Contributions
    0

    Default Re: SOLVED: 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.
    Last edited by willieWontGo; 1 Jul 2011 at 08:21 PM.

 

 

Similar Threads

  1. 1054 Unknown column 'p.products_carrot' in 'field list'
    By vivianso in forum All Other Contributions/Addons
    Replies: 1
    Last Post: 23 Jun 2011, 05:25 PM
  2. 1054 Unknown column 'p.product_price_w' in 'field list'
    By stevefriedman71 in forum All Other Contributions/Addons
    Replies: 25
    Last Post: 4 Mar 2011, 02:18 AM
  3. 1054 Unknown column 'zen_order_id' in 'field list'
    By bunnyzoe in forum PayPal Website Payments Pro support
    Replies: 0
    Last Post: 6 Jun 2009, 08:18 PM
  4. 1054 Unknown column 'account_name' in 'field list'
    By jford in forum Built-in Shipping and Payment Modules
    Replies: 4
    Last Post: 22 Aug 2006, 11:24 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR