Order Delivery Date Support Thread

[weif]

It turns out that the actual conflict was caused by having not merged the 1.5.6 template files with the live template. There are several changes between 1.5.1 (when they were last merged, in this case) and 1.5.6 which are no longer completely compatible.

So, boys and girls, remember when performing an upgrade, you need to check your template files for any custom template against the changes in the template it is modeled from...

[donw]

Hi, I have recently installed this module on a site running Zencart 1.5.5e. I originally installed version 2.6.1, and everything worked correctly with 2 exceptions.

1. The calendar popup doesn't appear on checkout. A date can be entered manually, and this functions correctly.

2. If a date is not entered, then on the order details, invoice and packing slip, a date of Tuesday 30th November, 1999 is shown. Looking at the database table, a value of 0000-00-00 00:00:00 is written to the table, rather than the correct default value of NULL (0001-01-01 00:00:00).

After reading a lot of posts in this forum, I downloaded and installed version 2.6.2, but bot problems persist. I consider 2. a bug.

I would appreciate any help to resolve these issues.

[mc12345678]

Hi, I have recently installed this module on a site running Zencart 1.5.5e. I originally installed version 2.6.1, and everything worked correctly with 2 exceptions.

1. The calendar popup doesn't appear on checkout. A date can be entered manually, and this functions correctly.

2. If a date is not entered, then on the order details, invoice and packing slip, a date of Tuesday 30th November, 1999 is shown. Looking at the database table, a value of 0000-00-00 00:00:00 is written to the table, rather than the correct default value of NULL (0001-01-01 00:00:00).

After reading a lot of posts in this forum, I downloaded and installed version 2.6.2, but bot problems persist. I consider 2. a bug.

I would appreciate any help to resolve these issues.

There are two aspects to item 2, the plugin uses ZC functions that are/were expected to provide appropriate response if no data was provided. This was found to be an issue and corrected in ZC 1.5.6. The pull that corrects the function operation for the three associated functions can be found in this PR: https://github.com/zencart/zencart/pull/2067/files and https://github.com/zencart/zencart/c...4c0a668713f047 to address the display of multilingual information on windows related systems (character encoding appeared to need modification on windows servers). While the first PR was not adopted in full (sequence of the checks was reversed), ZC 1.5.6 and above carries the calculations through to more appropriately handle/correct the issue. The second aspect is the need to assign a default to the field if nothing is provided. The field in the database can be modified per the below to provide a default and ensure that it accepts a value of NULL if NULL is given (Which should also prevent the incorrect storage of '0000-00-00 00:00:00'):

ALTER TABLE orders MODIFY order_delivery_date datetime DEFAULT '0001-01-01 00:00:00' NULL;

Then the code of post #478 that includes the following SQL:

UPDATE orders SET order_delivery_date = NULL WHERE order_delivery_date < '0001-01-01' AND order_delivery_date IS NOT NULL;

in anticipation of correcting issues associated with upgrading Zen Cart such as the orders table containing date/datetime fields that have incorrect/unacceptable values.

[donw]

Thanks. The modified file has fixed the problem. Had already carried out the post #478. Any suggestions re the calendar not showing up ?

[mc12345678]

Thanks. The modified file has fixed the problem. Had already carried out the post #478. Any suggestions re the calendar not showing up ?

This could be from a number of things, between load sequence of the mootools javascript, the presence/absence of css (button may be there, but not where it is expected), template modifications and whether the date box is tied to the correct object, as part of sequence loading whether some other javascript/jquery is prohibiting connecting/executing, a javascript failure in something else, the page not passing html validation, etc...

I (or I would think almost any forum member) could take a look at some of the above by knowing where on the Internet to look at and when that/those individuals are available to do so.

[donw]

I've just had a look in the Safari javascript console and the error coming up is related to the code:

if (undefined !== typeof (jQuery)) {
jQuery.noConflict();
}

at the top of the jscript_a-mootools.js file. The error is "Can't find variable: jQuery

Appreciate any help in sorting this out.

[mc12345678]

I've just had a look in the Safari javascript console and the error coming up is related to the code:

if (undefined !== typeof (jQuery)) {
jQuery.noConflict();
}

at the top of the jscript_a-mootools.js file. The error is "Can't find variable: jQuery

Appreciate any help in sorting this out.

Basically that means that jQuery is not being loaded before the mooTools.js file. This seems to imply that the header file(s) for the page load have been modified away from standard content for the last several Zen Cart versions. Specifically includes/templates/YOUR_TEMPLATE/common/html_header.php.

Effectively, somewhere above/before the mootolls file, jQuery should be loaded. It has been verified to function with the version released with ZC 1.5.6c and with the alpha version of ZC 1.5.7. Suggest comparing your version of that file with either of the two versions available either responsive_classic or template_default...