Dual Pricing - 1054 Unknown column 'c.COWOA account'

I am trying to install Dual Pricing in a new install of 1.3.8 when I go to Customers in Admin I get the following at the top of the page:

1054 Unknown column 'c.COWOA_account' in 'field list'
in:
[select c.customers_id, c.customers_lastname, c.customers_firstname, c.customers_email_address, c.customers_group_pricing, a.entry_country_id, a.entry_company, ci.customers_info_date_of_last_logon, ci.customers_info_date_account_created , c.customers_telephone, a.entry_company, a.entry_street_address, a.entry_city, a.entry_postcode, c.customers_authorization, c.customers_referral, c.COWOA_account from customers c left join customers_info ci on c.customers_id= ci.customers_info_id left join address_book a on c.customers_id = a.customers_id and c.customers_default_address_id = a.address_book_id order by ci.customers_info_date_account_created DESC limit 0, 20]
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.

If I replace the customers.php file with the standard zencart file, the problem goes away.

If anyone knows what this means, Thanks ahead of time!

I am getting the same exact error. Anyone?

Sounds like they forgot a command to insert a column in zen_customers... I'm trying to figure out right now the length and default value that will be required. If anyone has figured this one out it would be great.

I ended up uploading the admin/customers.php from the 1.3.1 beta 3 release of this mod. It seems to have worked.

I ended up scraping this mod and will use group pricing. I ended up rolling back to the older customers.php

Yes - I just installed the module, and I'm getting the same issue. Sure wish there was some documentation as to what this COWOA_account column is.

I do see that the ONLY place that this is referenced in the entire site is in /admin/customers.php

Also saw that previous versions of this mod do not have this column in it.

I'll do some tests, and see if I can get in contact with the mod author. Hopefully I can post a fix to this soon for any of you who would like to use this module.

Just to let everybody here know. There is another more informative thread for this mod. And Zencart should shut this one down. Here is the link

http://www.zen-cart.com/forum/showthread.php?t=35450

Furthermore I have experienced the same problems as many of you guys. Once you clean up the COWOA problems you will more than likely run into a list of others. I have cleaned up the files and made a few modifications. Specifically the original displayed "Whole Sale" when it should have displayed "Retail" and several other issues. The following link is to my files. Please download and try these instead. I'd like to post them as a new version of this modification but would like more testing. Specifically with the attributes activated on whole sale items. If I get enough positive feed back I will post this as a new version. PLEASE DO NOT CONTACT ME WITH PROBLEMS IF YOUR USING 1.3.7 OR BELOW UNLESS YOU WANT TO PAY ME TO UPGRADE YOU FIRST... Break this rule and you will be immediately blocked from my email account.

www.pushingbuttonsaz.com/dual_pricing_PB.zip

Thanks,
Emiliano Jordan
emilianosemail "at" gmail "dot" com

Thanks Emiliano,

I have to go to my day job right now, but will download and test tonight or tomorrow morning and l leave some feed back.

Patrick

Works a treat for me, was getting the same error posted above but just installing this new customers.php fixed it

THANKS!

Couple of GOLD stars for Emiliano !

Great job. Thats how it should have been :-)

Many thanks !!!

Seems to work like a dream... thank you this was really needed. Will post any bugs. Using on 1.3.8 as per your request!

Thank you for helping me with this. I'm glad it's worked for everyone. I'm going to get the documentation and everything prepared for the upload. :clap:

I'm also just completed a modification of this module that allows the admin to hide all products without a whole sale price when a whole sale customer is looking at the cart. Making it a little more intuitive if you have a retail / whole sale store.

Now the question is... would people like this released? I have not set it up to filter products who's base price is not modified but whose attributes are. So it would take me a little bit to further this project for release. Therefor if I get some more positive feedback I will happily work the hours. Please just PM me with your thoughts as to not flood the forum.

Now I have installed it . Can someone please give me simple guide to use this mod.
How do I know its installed ? good news is I am not getting any errors.
Where do I find the settings in admin? I can not see it anywhere? Should there be some sort of drop down? there isn't any.

Thanks in advance guys

Looks like I am getting error messages. Can anyone please hep to fix this error?

Thanks in advance.

When I select Catalog>Catalog & Products

1054 Unknown column 'p.products_price_w' in 'field list'
in:
[select p.products_type, p.products_id, pd.products_name, p.products_quantity, p.products_image, p.products_price, p.products_price_w, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status, p.products_model, p.products_quantity_order_min, p.products_quantity_order_units, p.products_priced_by_attribute, p.product_is_free, p.product_is_call, p.products_quantity_mixed, p.product_is_always_free_shipping, p.products_quantity_order_max, p.products_sort_order from zen_products p, zen_products_description pd, zen_products_to_categories p2c where p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = '1' order by p.products_sort_order, pd.products_name limit 0, 10]
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.

Not to worry. There is a new version for 1.3.8 !!! and it works

oavs:

Looks like I am getting error messages. Can anyone please hep to fix this error?

Thanks in advance.

oavs,

To be picky can you please chose which forum you are going to post in (preferably not this one) as I'm getting confused as to where you are in your install. On the other forum you asked for a SQL DB patch. That patch is in your .txt file that comes with the download as is all the information on how to use this contribution. From the sound of your error you have not yet found and installed the SQL patch. Let me know if you have installed it and you are still getting the error or if you install it and you continue to receive some sort of error.

Thanks

Just an update because I have gotten a few emails about this. The form for this mod should be completely moved over to this:

http://www.zen-cart.com/forum/showthread.php?t=35450

and the URL to download this is here:

http://www.zen-cart.com/index.php?main_page=product_contrib_info&products_id=166