Topic: Installing clean 2.4.20 version gets stuck
Hi
I was installing the new 2.4.20 version and it could't finish installation
I'm using
MariaDB 10.4.32
PHP Version 8.1.25
The problem I notice is when the system tries to execute the script
CREATE TABLE `0_bank_accounts` (
`account_code` varchar(15) NOT NULL DEFAULT '',
`account_type` smallint(6) NOT NULL DEFAULT '0',
`bank_account_name` varchar(60) NOT NULL DEFAULT '',
`bank_account_number` varchar(100) NOT NULL DEFAULT '',
`bank_name` varchar(60) NOT NULL DEFAULT '',
`bank_address` tinytext,
`bank_curr_code` char(3) NOT NULL DEFAULT '',
`dflt_curr_act` tinyint(1) NOT NULL DEFAULT '0',
`id` smallint(6) NOT NULL AUTO_INCREMENT,
`bank_charge_act` varchar(15) NOT NULL DEFAULT '',
`last_reconciled_date` timestamp NOT NULL DEFAULT '1900-01-01 00:00:00',
`ending_reconcile_balance` double NOT NULL DEFAULT '0',
`inactive` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `bank_account_name` (`bank_account_name`),
KEY `bank_account_number` (`bank_account_number`),
KEY `account_code` (`account_code`)
) ENGINE=InnoDB AUTO_INCREMENT=3 ;
the failure is because in the newer MariaDB does not allow this line
`last_reconciled_date` timestamp NOT NULL DEFAULT '1900-01-01 00:00:00',
so in order to make it work change it to
`last_reconciled_date` DATETIME NOT NULL DEFAULT '1900-01-01 00:00:00',
After I did it it works, hope I can help someone.
