Parcel ETA shows 01.01.1999 as date

  • Resolved Zoker

    (@zoker)


    1 year, 8 months ago

    Hi there,

    When I look at the parcel sent confirmation mail, there is a estimate time of arrival field, which looks like this for every email:

    A ETA of 1. Januar 1999 is not really helpful for our customers. Is this a bug?

    How to show the correct date here or hide it if the date is not correctly set?

    Thanks!

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author vendidero

    (@vendidero)

    Hi there,

    seems very much like a known issue with your database – I guess there is an issue with automatically applying DB updates to your installation as this issue was already fixed quite some time ago. Please make sure that date columns in the table woocommerce_gzd_shipments have a default value of 0000-00-00 00:00:00 set. This is the current schema:

    https://github.com/vendidero/woocommerce-germanized-shipments/blob/master/src/Install.php#L222

    Cheers

    Thread Starter Zoker

    (@zoker)

    Hi there,

    I looked into the table, but seems to be ok, right?

    Version is the latest 3.4.11:

    Anything else I can debug/test? Thanks!

    Plugin Author vendidero

    (@vendidero)

    And did you check what’s actually saved to the DB as shipment_est_delivery_date (_gmt)? Does that happen to new orders/shipments created via Germanized in the newest version too?

    Another user reported that the (a similar) issue was related to a backup plugin (WPvivid Backup) which parsed the datetimes wrong.

    Cheers

    Thread Starter Zoker

    (@zoker)

    It seems that this issue is also present in the latest db entries. The bottom two are orders, were no shipping label has been created yet. I suppose as soon as the label is created, the date becomes this 1999-01-01 00:00:00

    We do not use WPvivid Backup plugin. Is there any way to debug the output of this date format or which plugin may cause this issue?

    Plugin Author vendidero

    (@vendidero)

    That’s quite strange. Which PHP/mySQL Version are you using? Could you please check whether the issue exists after every shipment update (that’s what happens under the hood when adding a label), e.g. after updating the shipment status or the shipment weight?

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Parcel ETA shows 01.01.1999 as date’ is closed to new replies.