Upgrading 4.12.3 to 4.14.1 UpgradeDatabase.php error messages
Hi,
I am upgrading a system from 4.12.3 to 4.14.1 and the following errors appear when UpgradeDatabase.php runs.
How can I solve this ?
Thanks in advance
========================
The webERP code is version 4.14.1 and the database version is 4.12.3
Applying ./sql/mysql/upgrade4.12.3-4.13.sql
ALTER table grns ADD supplierref varchar(30) NOT NULL DEFAULT '' Failure - Error number - 1067 Invalid default value for 'deliverydate'
ALTER table stockrequest DROP FOREIGN KEY `stockrequest_ibfk_3` Failure Error number 1067 Invalid default value for 'despatchdate'
ALTER table stockrequest DROP FOREIGN KEY `stockrequest_ibfk_4` Failure Error number 1067 Invalid default value for 'despatchdate'
ALTER table bom ADD remark varchar(500) NOT NULL DEFAULT '' Failure Error number 1067 Invalid default value for 'effectiveafter'
ALTER table bom ADD digitals int(11) NOT NULL DEFAULT 0 Failure - Error number - 1067 Invalid default value for 'effectiveafter'
Applying ./sql/mysql/upgrade4.13-4.13.1.sql
ALTER TABLE `debtortrans` CHANGE `trandate` `trandate` DATE NOT NULL DEFAULT '0000-00-00' Failure - Error number - 1067 Invalid default value for 'trandate'
ALTER TABLE `stockrequest` ADD `initiator` VARCHAR(20) NOT NULL DEFAULT '' Failure - Error number - 1067 Invalid default value for 'despatchdate'
ALTER TABLE `workorders` ADD `reference` VARCHAR(40) NOT NULL DEFAULT '' Failure Error number 1067 Invalid default value for 'requiredby'
ALTER TABLE `workorders` ADD `remark` TEXT DEFAULT NULL Failure Error number 1067 Invalid default value for 'requiredby'
Applying ./sql/mysql/upgrade4.13.1-4.14.sql
UPDATE prices SET enddate='9999-12-31' WHERE enddate='0000-00-00' Failure - Error number - 1292 Incorrect date value: '0000-00-00' for column 'enddate' at row 1
|