greentrees Posted October 11, 2022 Share Posted October 11, 2022 Was hoping to install OS4 and take a look at it, can't get through install, see screenshot below. Local test server http://abc.com - set by hosts to server's ip 192.168.1.88 Error. Can't update database: Invalid default value for 'ad_date_add'ℹ Operating system CentOS Linux 7.9.2009 Running PHP 7.4 Both log folders are empty Any ideas please Quote Link to comment Share on other sites More sharing options...
osCommerce-Official Posted October 11, 2022 Share Posted October 11, 2022 @pandreicould you please comment here? Thanks! Quote Link to comment Share on other sites More sharing options...
pandrei Posted October 11, 2022 Share Posted October 11, 2022 1 hour ago, greentrees said: Any ideas please This is a version dependent error. What version of your mysql/mariadb? To check the version your MySQL is running, type and execute mysql -V (note the uppercase V) in the command line. Quote Link to comment Share on other sites More sharing options...
managingdirector Posted April 5 Share Posted April 5 Problem: Cannot install osCommerce 4 on the "Database Access" panel. Error. Can't update database: Invalid default value for 'ad_date_add'ℹ Linux Server Operating on: CentOS Linux 7.9.2009 (Core) Plesk Obsidian v18.0.51_build1800230310.09 os_CentOS 7 mysql Ver 15.1 Distrib 5.5.68-MariaDB, for Linux (x86_64) using readline 5.1 Allow local connections only to Database host:*: localhost:3306 SELinux config settings: "SELINUX=disabled" and "SELINUXTYPE=minimum" Quote Link to comment Share on other sites More sharing options...
pandrei Posted April 6 Share Posted April 6 21 hours ago, managingdirector said: Error. Can't update database: Invalid default value for 'ad_date_add'ℹ Could you move mouse on ℹ icon and make a screenshot with the pop up hint? Quote Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.