Order Delivery Date Support Thread

[mc12345678]

Quick question - if I have 1.5.4 installed should I be using the 1.5.1 or 1.5.5 version ?

Stuck your foot out there did you? :) The right answer is that should be using ZC 1.5.5 or the most recently released production version; however, I would expect that the software provided in the package download would work using the 1.5.5 fileset for as far back as ZC 1.5.3, though it has not been tested.

I will say that in use of any provided template file, the important thing is to incorporate the Order Delivery Date changes provided into your existing template file or if that template file is unchanged, to use the template_default version of that file to incorporate the changes.

[royaldave]

Stuck your foot out there did you? :) The right answer is that should be using ZC 1.5.5 or the most recently released production version; however, I would expect that the software provided in the package download would work using the 1.5.5 fileset for as far back as ZC 1.5.3, though it has not been tested.

I will say that in use of any provided template file, the important thing is to incorporate the Order Delivery Date changes provided into your existing template file or if that template file is unchanged, to use the template_default version of that file to incorporate the changes.

Seems to be working - EXCEPT - if I don't select a date it displays - ERROR_PLEASE_CHOOSE_DELIVERY_DATE - even though I have updated checkout_shipping.php in languages.

Not using OPC.

[dbltoe]

Whenever you see something in all caps with underlines in between words, your seeing a display letting you know that the variable has not been defined. You may have placed the checkout_shipping.php in the wrong directory, it may be missing, or the define may be done incorrectly.

Look for includes/languages/english/YOUR_TEMPLATE/checkout_shipping.php

[mc12345678]

Haven't seen anyone post about trying to use this with ZC 1.5.6 or issues directly related to using this with ZC 1.5.6 (where more likely to have stricter controls over operations); however, did want to provide some information if a problem occurs that identifies this plugin by reference to the table orders field order_delivery_date.

Operation on my test site shows history that at some point in use/development a date of 0000-00-00 was stored in the field; however, in operation of the current version it appears to properly store a value of null. That said, I wanted to address the problem before it was identified as an issue if it is/has been.

My suggestion first would be that while the database modifications of this plugin are present, that the following SQL be executed prior to attempting to upgrade to ZC 1.5.6 or if you ever encounter a problem modifying the orders table and the order_delivery_date field is identified as a problem.

The problem statement that may be expected to be seen in the zcInstall related logs would be something like:

[DATE_AND_TIME_OF_ISSUE SERVER_TIMEZONE] MySQL error 1292 encountered during zc_install:
Incorrect date value: '0000-00-00 00:00:00' for column 'order_delivery_date' at row XXX
ALTER TABLE orders ADD order_weight FLOAT default NULL;

The following SQL could be executed to eliminate any such issue with the order_delivery_date field.

UPDATE orders SET order_delivery_date = NULL WHERE order_delivery_date < '0001-01-01' and order_delivery_date is not null;

If operating with ZC 1.5.1 and above, the sql statement could be applied as is in the admin->Tools->Install SQL Patches. If, however, it is executed in phpMyAdmin, a similar database access utility or from within an older version of Zen Cart, then care must be taken to prepend the DB_PREFIX (defined in includes/configure.php and matching in admin/includes/configure.php) to orders. If the prefix were 'bright_', then the above would start with UPDATE bright_orders SET ...

[weif]

I am in the process of upgrading a site from 1.5.5b to 1.5.6a and the calendar button is not displaying on the checkout page as expected. I have downloaded version 1.6.1 of the module and am working with that.

Looking through this support thread, it looks like a JQuery conflict, but it appears that JQuery is now being used in ZenCart to track session and order information, so there doesn't appear to be a piece of that I can readily dispose of (or maybe I am missing something?).

ZenCart 1.5.6a
Sitemap XML 3.9.5
ImageHandler5 for ZenCart 1.5.6
ZipShip 2.0.0

php 7.2.14
mysql 5.5.60
CentOS (Linux)

[mc12345678]

I am in the process of upgrading a site from 1.5.5b to 1.5.6a and the calendar button is not displaying on the checkout page as expected. I have downloaded version 1.6.1 of the module and am working with that.

Looking through this support thread, it looks like a JQuery conflict, but it appears that JQuery is now being used in ZenCart to track session and order information, so there doesn't appear to be a piece of that I can readily dispose of (or maybe I am missing something?).

ZenCart 1.5.6a
Sitemap XML 3.9.5
ImageHandler5 for ZenCart 1.5.6
ZipShip 2.0.0

php 7.2.14
mysql 5.5.60
CentOS (Linux)

I thought I would have had a chance yesterday to install the plugin to my ZC 1.5.6a test site; however, didn't have that opportunity. Yes there has historically been a javascript/jQuery conflict; however, the noconflict flag had been added in to attempt to permit operation of the mootools software.

I will try again when back at my computer to install and see what is going on with the possibility of logging into your site to see what is happening there after I see what is happening.

[weif]

And the noconflict flag is in place...