Dynamic Price Updater

[marcopolo]

Nice mod question has anyone got it to work on the product_listing.php page? It works fine on the info page but I use a module that shows attributes on the product listing page and need this to work on it as well.

[marcopolo]

This is the other module I'm trying to get it to work with:
https://www.zen-cart.com/downloads.php?do=file&id=1637

[Design75]

This is the other module I'm trying to get it to work with:
https://www.zen-cart.com/downloads.php?do=file&id=1637

For DPU to work on the product listing you would have to rewrite the whole DPU mod

[HeathenMagic]

Hello there,

Does anybody have success making this work on 1.5.5? Thanks in advance

[orochi_kyo]

Hello there,

Does anybody have success making this work on 1.5.5? Thanks in advance

This, Im receiving errors anytime I try to get to the admin after installing. This is one of the best modules, please update it.

[02-May-2016 21:02:51] Request URI: /sitio2/Claim-ppo-Whack/login.php?camefrom=index.php, IP address: 186.32.18.63
#1  trigger_error(1136:Column count doesn't match value count at row 1 :: INSERT INTO configuration VALUES (NULL, 'Dynamic Price Updater Status', 'DPU_STATUS', 'false', 'Enable Dynamic Price Updater?', '38', 10, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),') ==> (as called by) /home/etechnol/public_html/sitio2/Claim-ppo-Whack/includes/init_includes/init_dpu_config.php on line 50 <==, 256) called at [/home/etechnol/public_html/sitio2/includes/classes/db/mysql/query_factory.php:167]
#2  queryFactory->show_error() called at [/home/etechnol/public_html/sitio2/includes/classes/db/mysql/query_factory.php:139]
#3  queryFactory->set_error(1136, Column count doesn't match value count at row 1, 1) called at [/home/etechnol/public_html/sitio2/includes/classes/db/mysql/query_factory.php:266]
#4  queryFactory->Execute(INSERT INTO configuration VALUES (NULL, 'Dynamic Price Updater Status', 'DPU_STATUS', 'false', 'Enable Dynamic Price Updater?', '38', 10, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),')) called at [/home/etechnol/public_html/sitio2/Claim-ppo-Whack/includes/init_includes/init_dpu_config.php:50]
#5  require(/home/etechnol/public_html/sitio2/Claim-ppo-Whack/includes/init_includes/init_dpu_config.php) called at [/home/etechnol/public_html/sitio2/includes/autoload_func.php:48]
#6  require(/home/etechnol/public_html/sitio2/includes/autoload_func.php) called at [/home/etechnol/public_html/sitio2/Claim-ppo-Whack/includes/application_top.php:171]
#7  require(/home/etechnol/public_html/sitio2/Claim-ppo-Whack/includes/application_top.php) called at [/home/etechnol/public_html/sitio2/Claim-ppo-Whack/login.php:9]

[02-May-2016 21:02:51] PHP Fatal error:  1136:Column count doesn't match value count at row 1 :: INSERT INTO configuration VALUES (NULL, 'Dynamic Price Updater Status', 'DPU_STATUS', 'false', 'Enable Dynamic Price Updater?', '38', 10, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),') ==> (as called by) /home/etechnol/public_html/sitio2/Claim-ppo-Whack/includes/init_includes/init_dpu_config.php on line 50 <== in /home/etechnol/public_html/sitio2/includes/classes/db/mysql/query_factory.php on line 167

[orochi_kyo]

I got around those install errors, adding a ", null" in some lines then adding "sometext" in others in the code between 50 and 60 at init_dpu_config, it seems one column to add to the database was missing in those lines.
But now I cant see how to make the plugin to work, I can see the options on the admin side, "Where to display the price", when I use "productsGeneral" which is the <h2> that contains the price text tag, I choose between the attributes I see the loading GIF but the main price doesnt change, if I leave it blank or try to set another ID(of course I create a input field or a simple text spam field with an ID first), nothing happens, even the loading GIF is not there.

Im using Zencart 1.5.5 with responsive Sheffield blue, I had tried the default template too, it doesnt work.

I have been using zen cart for ten years, this kind of stuff should be there by default by now, like when people select another quantity of the same product, price should be updating without the need of pressing "add to cart" button.

[Design75]

I got around those install errors, adding a ", null" in some lines then adding "sometext" in others in the code between 50 and 60 at init_dpu_config, it seems one column to add to the database was missing in those lines.
But now I cant see how to make the plugin to work, I can see the options on the admin side, "Where to display the price", when I use "productsGeneral" which is the <h2> that contains the price text tag, I choose between the attributes I see the loading GIF but the main price doesnt change, if I leave it blank or try to set another ID(of course I create a input field or a simple text spam field with an ID first), nothing happens, even the loading GIF is not there.

Im using Zencart 1.5.5 with responsive Sheffield blue, I had tried the default template too, it doesnt work.

I have been using zen cart for ten years, this kind of stuff should be there by default by now, like when people select another quantity of the same product, price should be updating without the need of pressing "add to cart" button.

I will be away for the major part of the day, but I will take a look at your bug tonight. Below you find the default settings

Title	Value
Dynamic Price Updater Status	true
Dynamic Price Updater Version	3.1
Where to display the price	productPrices
Define used to set a variable for this script	cart_quantity
Where to display the weight	productWeight
show a small loading graphic	true
Show currency symbols	true
Show product quantity	false
Where to display the second price	cartAdd

[orochi_kyo]

This is how my config Admin looks like.

This is an url with a product with attributes, DPU is on.
http://etechnologycr.com/sitio2/inde...oducts_id=1581

Thanks in advance.

[mc12345678]

See: https://www.zen-cart.com/showthread....33#post1269333

This isn't a ZC 1.5.5 specific issue. It is a result of installing a modification that changed the configuration table and the fact that this mod hasn't incorporated the code change referenced in the above link or similar.

[orochi_kyo]

See: https://www.zen-cart.com/showthread....33#post1269333

This isn't a ZC 1.5.5 specific issue. It is a result of installing a modification that changed the configuration table and the fact that this mod hasn't incorporated the code change referenced in the above link or similar.

If I do as suggested in your post I receive this error. If I add the word Value before (null,...) I receive the same error I was receiving, about columns not matching as requested...

#1  trigger_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 'NULL, 'Dynamic Price Updater Status', 'DPU_STATUS', 'false', 'Enable Dynamic Pri' at line 1 :: INSERT INTO configuration (NULL, 'Dynamic Price Updater Status', 'DPU_STATUS', 'false', 'Enable Dynamic Price Updater?', '38', 10, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),') ==> (as called by) /home/etechnol/public_html/sitio2/Claim-ppo-Whack/includes/init_includes/init_dpu_config.php on line 50 <==, 256) called at [/home/etechnol/public_html/sitio2/includes/classes/db/mysql/query_factory.php:167]