Print Page - 1525 INCORRECT DATETIME VALUE: ''

Title: 1525 INCORRECT DATETIME VALUE: ''
Post by: stensbo on September 14, 2023, 16:08:03 PM

Hello,

Using Joomla! 3.10.11 - VirtueMart 3.8.9 10473 php 7.4.33

I think our Host has upgraded our MySQL version to 8.0.33-25 since yesterday because today we have the error:
1525 INCORRECT DATETIME VALUE: ''
when we login to administration and to our Virtuemart shop.

Any hint what to do..

Title: Re: 1525 INCORRECT DATETIME VALUE: ''
Post by: mdtechteam on April 24, 2024, 18:34:55 PM

Hello, did you ever get this resolved? My hosting updated to mysql 8 and getting the same error on some products. Some products open however products that have a child product are throwing the Incorrect DATETIME value: '' messge.

Title: Re: 1525 INCORRECT DATETIME VALUE: ''
Post by: AH on April 26, 2024, 13:39:10 PM

Look in your VM tables for Default DATETIME fields with a value of 0000-00-00 00:00:00

MYSQL does not like these

VirtueMart Forum

VirtueMart 2 + 3 + 4 => Installation, Migration & Upgrade => Topic started by: stensbo on September 14, 2023, 16:08:03 PM