Forums / All Other Contributions/Addons / [Dual Pricing Error] 1054 Unknown column 'COWOA_account' in 'where clause'

[Dual Pricing Error] 1054 Unknown column 'COWOA_account' in 'where clause'

Started by solarguy on 8 May 2011, 1:13 AM · Views: 1,181

Results 1 to 6 of 6
8 May 2011, 1:13 AM
#1
solarguy avatar

solarguy

New Zenner

Join Date:
May 2010
Posts:
79
Plugin Contributions:
0

[Dual Pricing Error] 1054 Unknown column 'COWOA_account' in 'where clause'

When trying to Log into zen cart account as a customer the following error happens:

1054 Unknown column 'COWOA_account' in 'where clause'
in:
[SELECT customers_id, customers_firstname, customers_lastname, customers_password, customers_email_address, customers_default_address_id, customers_authorization, customers_referral, customers_whole FROM customers WHERE customers_email_address = '[email protected]' AND COWOA_account != 1]

I'm running 1.3.9c

dual pricing module
customer tax exempt module
quick order module

Thanks.

8 May 2011, 3:14 AM
#2
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: [Dual Pricing Error] 1054 Unknown column 'COWOA_account' in 'where clause'

Add your server details

Zen-Venom Get Bitten

8 May 2011, 3:33 AM
#3
solarguy avatar

solarguy

New Zenner

Join Date:
May 2010
Posts:
79
Plugin Contributions:
0

Re: [Dual Pricing Error] 1054 Unknown column 'COWOA_account' in 'where clause'

Linux 2.6
Apache version 2.2.17
MySQL version 5.1.56

8 May 2011, 3:34 AM
#4
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: [Dual Pricing Error] 1054 Unknown column 'COWOA_account' in 'where clause'

How's about php??

And COWOA version

Also, revisit what files your other addons have altered as I recall some touch thwe same files and this would be a case where one would have to merge the code alterations into "one" combined file

Zen-Venom Get Bitten

8 May 2011, 4:03 AM
#5
solarguy avatar

solarguy

New Zenner

Join Date:
May 2010
Posts:
79
Plugin Contributions:
0

Re: [Dual Pricing Error] 1054 Unknown column 'COWOA_account' in 'where clause'

i dont have COWOA

9 May 2011, 2:28 AM
#6
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: [Dual Pricing Error] 1054 Unknown column 'COWOA_account' in 'where clause'

i dont have COWOA
It is somewhere owing to the error

Zen-Venom Get Bitten