DUAL Pricing v2

[HeathenMagic]

Wow craftzombie you are a star! That fixed it for me and I am very thankful to you.

Cheers

Heathenmagic

[jaskarn]

Hi,
Can somebody please help me.
When i click on the Customers Page in admin is get this error.


Customers Search:

ID# Last Name
Asc Desc First Name
Asc Desc Company
Asc Desc Account Created
Asc Desc Last Login
Asc Desc Pricing Group
Asc Desc TABLE_HEADING_GV_AMOUNT
Asc Desc Authorized
Asc Desc Action TABLE_HEADING_COWOA
Asc Desc Action
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.


This happened after i installed this addon.

[HeathenMagic]

did you process your sql patch from the dual pricing folder?

[craftzombie]

Hi,
Can somebody please help me.
When i click on the Customers Page in admin is get this error.


Customers Search:

ID# Last Name
Asc Desc First Name
Asc Desc Company
Asc Desc Account Created
Asc Desc Last Login
Asc Desc Pricing Group
Asc Desc TABLE_HEADING_GV_AMOUNT
Asc Desc Authorized
Asc Desc Action TABLE_HEADING_COWOA
Asc Desc Action
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.


This happened after i installed this addon.

Someone who updated this mod also uses the Checkout Without Account (COWOA) mod and left the code in there, probably thinking it wouldn't hurt the functionality of the Dual Pricing mod (???). I probably would've left it in there too. I went through the customers.php file and hopefully removed all of the cowoa code. You can download that version of the file here:

customers.zip

Install it into your admin folder and then click on your customers and see what happens. Let me know....

[jaskarn]

Hi everyone,
thank you for your efforts and help.
1. I did proccess the patch by going to Zencart Admin and pasting the complete file provided.
2. I tried the file without the COWOA supplied but now it gives me this error:

Fatal error: Call to undefined function: zen_get_customers_address_book() in /home/pjdhatt/public_html/dgtech/admin/customers.php on line 1137

Looks like we are hopefully getting closer. Please advise

[craftzombie]

Hi everyone,
thank you for your efforts and help.
1. I did proccess the patch by going to Zencart Admin and pasting the complete file provided.
2. I tried the file without the COWOA supplied but now it gives me this error:

Fatal error: Call to undefined function: zen_get_customers_address_book() in /home/pjdhatt/public_html/dgtech/admin/customers.php on line 1137

Looks like we are hopefully getting closer. Please advise

Sorry about that. I couldn't test it properly at the time because my test site was 1.3.7. I just upgraded it and tested the file and of course, I made a mistake. I fixed it and tested it and it seems to be working now. Download the customer zip file again and upload it to your admin folder. Let me know what happens.

[jaskarn]

Hi craftzombie,
I downloaded the file from the link in your last post and tried it but still i get the same error:


Fatal error: Call to undefined function: zen_get_customers_address_book() in /home/pjdhatt/public_html/dgtech/admin/customers.php on line 1146

When i deleted line 1146, it worked but the formatting was all wrong, i guess there is something wrong with bringing up the address book.

Please HELP!

Thanks.
Jaskarn

[craftzombie]

Hi craftzombie,
I downloaded the file from the link in your last post and tried it but still i get the same error:


Fatal error: Call to undefined function: zen_get_customers_address_book() in /home/pjdhatt/public_html/dgtech/admin/customers.php on line 1146

When i deleted line 1146, it worked but the formatting was all wrong, i guess there is something wrong with bringing up the address book.

Please HELP!

Thanks.
Jaskarn

I have a test cart installed with no other mods on it but Dual Pricing and I am not getting any errors with this new customers.php file. What mods do you have installed?

[jaskarn]

Hi again,
i have easy populate installed, sales_report_rev104, and aquick_price_search. From what i think the zen_address get thing function could have been renamed, could this be another file inlcuded in dual pricing mod download that would have changed it.

[craftzombie]

Hi again,
i have easy populate installed, sales_report_rev104, and aquick_price_search. From what i think the zen_address get thing function could have been renamed, could this be another file inlcuded in dual pricing mod download that would have changed it.

Just to clarify, the newest version of Dual Pricing is for 1.3.8. I noticed the download for the 1.3.7 version does not contain an easypopulate.php file, but the 1.3.6 and 1.3.8 versions do. I'm not sure what happened there. I do not use Easy Populate. If anyone is running into problems and you use Easy Populate with this mod, make sure your versions match.