businesspromotion Posted April 13, 2021 Share Posted April 13, 2021 Moorning, after installation i say this error....1525 - Incorrect DATETIME value: '' select banners_id, date_scheduled from banners where date_scheduled != '' pls help me Link to comment Share on other sites More sharing options...
ArtcoInc Posted April 13, 2021 Share Posted April 13, 2021 @businesspromotion What version of PHP are you running? Link to comment Share on other sites More sharing options...
businesspromotion Posted April 14, 2021 Author Share Posted April 14, 2021 7.3 Link to comment Share on other sites More sharing options...
ArtcoInc Posted April 14, 2021 Share Posted April 14, 2021 @businesspromotion v2.3.4.1 was written to run under PHP v5.x, and will give you problems when running under PHP v7.x. Can your host roll back to PHP v5.x? While you can modify v2.3.4.1 to run under v7.x, you will continually chase issues as PHP evolves, resulting in your own fork of oSC. M Link to comment Share on other sites More sharing options...
Hotclutch Posted April 14, 2021 Share Posted April 14, 2021 1525 is a SQL error, not PHP. And the official last version of osCommerce does not throw such an error. Link to comment Share on other sites More sharing options...
ArtcoInc Posted April 15, 2021 Share Posted April 15, 2021 @Hotclutch You are absolutely correct. I stand corrected. I ran into this exact problem when I was moving an old osC site from a server running PHP 5.x to a different server with PHP v7.x. However, as I now look back into my notes, it was NOT a PHP issue. Instead, the SQL setup on the new server was much more strict. The resolution was ... On my local WAMP server, after locating the file my.ini file, I had to edit the line that said "sql-mode= ... <blah, blah, blah> ....", and comment out the expression NO_ZERO_DATE. (I replicated the entire "sql-mode= " line below itself, commented out the first line (with a comment explaining what I did), and edited the copied line, removing the NO_ZERO_DATE expression.) @businesspromotion Is this on your local server, or a hosted server? Do you have access to edit the appropriate .ini file? If not, you may need to contact your host to resolve this for you. I apologize for the initial wild goose chase ... M Link to comment Share on other sites More sharing options...
ruden Posted April 17, 2021 Share Posted April 17, 2021 @businesspromotion Install v2.3.5 https://github.com/ruden/vanilla-oscommerce Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.