Dual Pricing 1.7 error

[Mediaslave]

Hey guys

When I try to install the Dual Pricing 1.7 mod, I get this error:

1054 Unknown column 'discount_price_w' in 'products_discount_quantity'
in:
[ALTER TABLE products_discount_quantity ADD discount_price_w VARCHAR( 150 ) DEFAULT '0' AFTER discount_price_w;]
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 idea? Unfortunately I have no idea what its talking about, nor do I know how to fix it.

This is the last thing I need for this project to work!

Thanks much!



This is the SQL file info:

ALTER TABLE `customers` ADD `customers_whole` VARCHAR( 4 ) DEFAULT '0' NOT NULL;
ALTER TABLE `products` ADD `products_price_w` VARCHAR( 150 ) DEFAULT '0' AFTER `products_price`;
ALTER TABLE `products_attributes` ADD `options_values_price_w` VARCHAR( 150 ) DEFAULT '0' AFTER `options_values_price`;
ALTER TABLE `products_discount_quantity` ADD `discount_price_w` VARCHAR( 150 ) DEFAULT '0' AFTER `discount_price_w`;
ALTER TABLE `customers` ADD `customers_wholesale` VARCHAR( 4 ) DEFAULT '0' NOT NULL AFTER `customers_whole`;


Version 1.3.9h

[carilivia]

Here's the correct code =)

For everyone that is having problems with this mod and the sql problem here is the correct code without the zen_ prefix and also the code WITH the zen prefix. Use the code WITHOUT the prefix if you are running this through the Tools>>Install SQL patches in the admin of your website:

WITHOUT THE ZEN PREFIX:

ALTER TABLE `customers` ADD `customers_whole` VARCHAR( 4 ) DEFAULT '0' NOT NULL;
ALTER TABLE `products` ADD `products_price_w` VARCHAR( 150 ) DEFAULT '0' AFTER `products_price`;
ALTER TABLE `products_attributes` ADD `options_values_price_w` VARCHAR( 150 ) DEFAULT '0' AFTER `options_values_price`;
ALTER TABLE `products_discount_quantity` ADD `discount_price_w` VARCHAR( 150 ) DEFAULT '0' AFTER `discount_price`;
ALTER TABLE `customers` ADD `customers_wholesale` VARCHAR( 4 ) DEFAULT '0' NOT NULL AFTER `customers_whole`;


WITH ZEN PREFIX:

ALTER TABLE `zen_customers` ADD `customers_whole` VARCHAR( 4 ) DEFAULT '0' NOT NULL;
ALTER TABLE `zen_products` ADD `products_price_w` VARCHAR( 150 ) DEFAULT '0' AFTER `products_price`;
ALTER TABLE `zen_products_attributes` ADD `options_values_price_w` VARCHAR( 150 ) DEFAULT '0' AFTER `options_values_price`;
ALTER TABLE `zen_products_discount_quantity` ADD `discount_price_w` VARCHAR( 150 ) DEFAULT '0' AFTER `discount_price`;
ALTER TABLE `zen_customers` ADD `customers_wholesale` VARCHAR( 4 ) DEFAULT '0' NOT NULL AFTER `customers_whole`;

[Mediaslave]

Hey there

First, thanks much for the help! That was perfect, and the SQL stuff worked perfectly.

However...

the mod doesn't seem to work. It hasn't changed anything. I've uploaded the files, and from what I understand I've done what it says to add in WHOLESALE (editing a customer, for example) and theres nowhere to add in the wholesale option.

Any ideas? Does this thing work?

[carilivia]

Are you not seeing where to add in the wholesale pricing?
Let us know! Also....did you make sure and double check that all the files got uploaded. Always best to go through and re-load them all, just in case one got missed =)

=0)

[Mediaslave]

I'm not actually seeing anything anywhere. As I understand it, there should be a new box under a customers email address when I edit them in the admin panel. There isn't. Theres also no change to the product info layout page in the admin panel.

Not sure if I am missing something....

I've just reuploaded everything, and still no change. Used the latest files too, with the fix to the SQL above.


Thanks very much for your help so far, its very appreciated!

[ariadsgn]

how to install Dual Pricing ? thx