1064 Error - dual pricing mod

[pidotcr]

I was getting a 1036 column error that I think was caused by Dual Pricing when I was trying to copy attributes to a category. I followed the instructions in this posting to fix that Now I'm getting the error below.

Anyone have any ideas on what's causing this? Thanks!


1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '', '+', '50', '1', '0', '+', ' at line 5
in:
[insert into products_attributes values (0, '52', '1', '5', '156.0000', 0', '+', '50', '1', '0', '+', '0', '0', '1', '', '0', '0.0000', '0.0000', '0.0000', '0.0000', '0.0000', '', '', '0.0000', '0', '0.0000', '0', '0')]
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.

[superprg]

Can you give the link from where you downloaded this mod?

Also, seems like the modifiction to the table products_attributes did not happen successfully!

[pidotcr]

Thanks for your speedy reply!

This is where I downloaded it from.

http://www.zen-cart.com/index.php?ma...roducts_id=166

[superprg]

Seems like you forgot to perform this step
Go to Admin
Tools->Install SQL Patches
and run these

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`;

[pidotcr]

I just tried to install that and it says couldn't install because they already exist.. hmm.

[superprg]

Hmm, See this if this helps....
http://www.zen-cart.com/forum/showthread.php?t=55439

[pidotcr]

I looked through that thread and it didn't really help. Thanks though :)

It looks to me like maybe there's a problem because there isn't a place to put Wholesale pricing when setting a price for the attribute. Would that be the cause or am I totally off?

[pidotcr]

I went through and made the adjustments to the 3 files

/admin/attributes_controller.php
/admin/includes/functions/general.php
/admin/options_values_manager.php

And now I'm getting the same but slightly different error.


1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '', '+', '10', '1', '0', '+', ' at line 5
in:
[insert into products_attributes (products_attributes_id, products_id, options_id, options_values_id, options_values_price, options_values_prices_w, price_prefix, products_options_sort_order, product_attribute_is_free, products_attributes_weight, products_attributes_weight_prefix, attributes_display_only, attributes_default, attributes_discounted, attributes_image, attributes_price_base_included, attributes_price_onetime, attributes_price_factor, attributes_price_factor_offset, attributes_price_factor_onetime, attributes_price_factor_onetime_offset, attributes_qty_prices, attributes_qty_prices_onetime, attributes_price_words, attributes_price_words_free, attributes_price_letters, attributes_price_letters_free, attributes_required) values (0, '48', '1', '1', '27.0000', 0', '+', '10', '1', '0', '+', '0', '0', '1', '', '0', '0.0000', '0.0000', '0.0000', '0.0000', '0.0000', '', '', '0.0000', '0', '0.0000', '0', '0')]
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.



Should I just get rid of the Dual Pricing mod? Has anyone else run into this problem?

[pidotcr]

I took out the Dual Pricing mod and am still getting this error when trying to copy attributes to a category or a product. If anyone has any other ideas on what the problem is please help.

Thanks