1525 - Incorrect DATETIME value: '' error

[macparts]

OK , Brand new user here and trying to get the 2.3.1 store to launch and I get 

1525 - Incorrect DATETIME value: ''

select banners_id, date_scheduled from banners where date_scheduled != ''

[TEP STOP]

Can someone give me a hint where to look for this ?

[Demitry]

Go into catalog/includes/functions/banner.php and find tep_activate_banners() function. 

Change the $banners_query line to the following:

$banners_query = tep_db_query("SELECT banners_id, date_scheduled FROM banners WHERE date_scheduled IS NOT NULL");

 

 

Edited January 29, 2022 by Demitry

[macparts]

Thanks , That worked. Store finally came up. 

Your sig line is so true. I want to use the @$#@$ thing not spent hours trying to get it installed and running.