Dynamic Price Updater

Hello there,

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

HeathenMagic:

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

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.

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.

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

This is how my config Admin looks like.

This is an url with a product with attributes, DPU is on.
http://etechnologycr.com/sitio2/index.php?main_page=product_info&cPath=49&products_id=1581

Thanks in advance.

See: https://www.zen-cart.com/showthread.php?70577-Dynamic-Price-Updater&p=1269333#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.

mc12345678:

See: https://www.zen-cart.com/showthread.php?70577-Dynamic-Price-Updater&p=1269333#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]

orochi_kyo:

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]

OK JUST IGNORE THIS, I forgot to delete the first "NUll" of every line.

Sadly, its not still working in the frontend...

orochi_kyo:

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]

As already pointed out there was a discrepancy in the sql, but all-in-all, the above is not at all what was suggested to be performed. The below is an example of how the line(s) should be written. Further based on the presentation of the configuration menu as compared to what is expected, som "unknown" values were placed in unknown location within the sql. This could cause unknown issues:

$sql = "INSERT INTO ".TABLE_CONFIGURATION." (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Dynamic Price Updater Status', 'DPU_STATUS', 'false', 'Enable Dynamic Price Updater?', '".$dpu_configuration_id."', 10, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),')";

Ok. Checking out my database I found after the 'trim(') code present in line 54, the rest of the lines werent be added to the database, and again in line 60 this code 'zen_cfg_select_option(array(''true'', ''false''),') wasnt allowing the last line being added to de DB, I change both to null, then going PHPMYADMIN and adding this 'zen_cfg_select_option(array(''true'', ''false''),') manually.
It seems everything is fine now with the DB, all the lines are there, and now I can see all the radio buttons on the true/false options in the backend, something It wasnt ther before. BUT, frontend is still not working.
I tought this plugin needed the sidebox to be activated, so I change the template to the classic one and turn on the sidebox, the sidebox doesnt show anything but the loading gif logo.

Checking the console error in Firebug and Chrome I receive this.

TypeError: this._responseXML is null
var type = this._responseXML.getElementsByTagName('responseType')[0].childNodes[0].nodeValue;

Checking the DOM, well it confirms that the value of this._responseXML is indeed NULL.

I get lost here, but I need this to work, was basically the most important thing my client wants in his website.

Hi

I have been using DPU for about 2 years.

I have just set up a new template and although the system is working fine on my local testing environment, I keep getting a status returned window pop up on my live site

And I cannot work out why. Please help :shocking:

Actually panic over.

I located /public_html/includes/modules/pages/product_info/jscript_dynamic_price_updater.php and at around line 36

var theURL = '<?php echo DIR_WS_CATALOG; ?>dpu_ajax.php';

For some ungodly reason had a '/' before it (that might be a setting down added to get this working on my local testing environment).

Anyway its removed and is now working. Happy days :cool:

Cant someone confirm for real, that this is working for 1.55? Please dont try to guess, if you know this is really working with 1.55 or 1.55a please link to the store where the plugin is working on, so I would try to make a clean installation to make this work. Im really tired, I have wasted one month trying to make this work...

orochi_kyo:

Cant someone confirm for real, that this is working for 1.55? Please dont try to guess, if you know this is really working with 1.55 or 1.55a please link to the store where the plugin is working on, so I would try to make a clean installation to make this work. Im really tired, I have wasted one month trying to make this work...

I can confirm that results can be obtained from using much of the software offered in the plugin while using ZC 1.5.5/1.5.5.a, but I was provided a site that had already tried to install it and had some difficulty in operation. Which means I did not start with a fresh download of the plugin, but instead resolving the issues before me.

Anyways, after correcting html validation issues (apparently extreme) the plugin does what it should, though I'm finding that I have an additional onchange event to be executes, but it gets overwritten, etc... so have to javascript my way to what I want/need. :P but it does work.

Does the latest version of this plugin work with 1.39h? or should I install an older version?

Chargin:

Does the latest version of this plugin work with 1.39h? or should I install an older version?
Ultimately instead of applying this to an older version of ZC, should be considering upgrading your ZC. ZC 1.5.5 will still operate in an environment with PHP 5.2.x installed, but more PHP older than 5.4 is no longer considered supported by the PHP community and is less secure than more recent versions.

mc12345678:

I can confirm that results can be obtained from using much of the software offered in the plugin while using ZC 1.5.5/1.5.5.a, but I was provided a site that had already tried to install it and had some difficulty in operation. Which means I did not start with a fresh download of the plugin, but instead resolving the issues before me.

Anyways, after correcting html validation issues (apparently extreme) the plugin does what it should, though I'm finding that I have an additional onchange event to be executes, but it gets overwritten, etc... so have to javascript my way to what I want/need. :P but it does work.

I will try a fresh install, then I will add this plugin first, testing, then adding the rest of the plugins, to see if there is any other plugin that is breaking it. Thanks.

firstGroup optionID: 3
Uncaught NotFoundError: Failed to

execute 'removeChild' on 'Node': The node to be removed

is not a child of this node.

I have looked for a piece of code, it maybe slove this problem.

function removeElement(_element){
     var _parentElement = _element.parentNode;
     if(_parentElement){
            _parentElement.removeChild(_element); 
     }
}

Does the latest version of this work on 1.39h? Or should I install an older version?

(Im fully aware of the problems with running 1.39h and I am working towards migrating this site to Wordpress and Woocommerce but its going to be a few months...)

It probably will, but I have not tried

Chargin:

Does the latest version of this work on 1.39h? Or should I install an older version?

(Im fully aware of the problems with running 1.39h and I am working towards migrating this site to Wordpress and Woocommerce but its going to be a few months...)