Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

macparts

1525 - Incorrect DATETIME value: '' error

Recommended Posts

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 ?

Share this post


Link to post
Share on other sites

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 by Demitry

osCommerce: made for programmers, ...because store owners do not want to be programmers.

https://trends.google.com/trends/explore?date=all&geo=US&q=oscommerce

Share this post


Link to post
Share on other sites

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. 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×