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

[anduril3019]

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!

[phark]

I am getting the same exact error. Anyone?

[madfastride]

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.

[gone_fission]

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

[phark]

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

[Prattski]

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.

[madfastride]

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

[phark]

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

[cookiesa]

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

THANKS!

[oavs]

Couple of GOLD stars for Emiliano !

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

Many thanks !!!