Jump to content
Sign in to follow this  
businesspromotion

Install OsCommerce 2.3.4.1 new installation

Recommended Posts

Moorning,  after installation i say this error....1525 - Incorrect DATETIME value: ''

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

pls help me

Share this post


Link to post
Share on other sites

@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

Share this post


Link to post
Share on other sites

1525 is a SQL error, not PHP. And the official last version of osCommerce does not throw such an error.

Share this post


Link to post
Share on other sites
Posted (edited)

@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

Edited by ArtcoInc

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
Sign in to follow this  

×