<?xml version="1.0" encoding="utf-8"?>
<feed xmlns="http://www.w3.org/2005/Atom">
	<title type="html"><![CDATA[FrontAccounting forum — Installing clean 2.4.20 version gets stuck]]></title>
	<link rel="self" href="https://frontaccounting.com/punbb/extern.php?action=feed&amp;tid=10726&amp;type=atom" />
	<updated>2026-05-12T18:30:49Z</updated>
	<generator>PunBB</generator>
	<id>https://frontaccounting.com/punbb/viewtopic.php?id=10726</id>
		<entry>
			<title type="html"><![CDATA[Installing clean 2.4.20 version gets stuck]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=43866#p43866" />
			<content type="html"><![CDATA[<p>Hi </p><p>I was installing the new 2.4.20 version and it could&#039;t finish installation</p><p>I&#039;m using </p><p>MariaDB 10.4.32<br />PHP Version 8.1.25</p><p>The problem I notice is when the system tries to execute the script </p><p> CREATE TABLE `0_bank_accounts` (<br />&nbsp; `account_code` varchar(15) NOT NULL DEFAULT &#039;&#039;,<br />&nbsp; `account_type` smallint(6) NOT NULL DEFAULT &#039;0&#039;,<br />&nbsp; `bank_account_name` varchar(60) NOT NULL DEFAULT &#039;&#039;,<br />&nbsp; `bank_account_number` varchar(100) NOT NULL DEFAULT &#039;&#039;,<br />&nbsp; `bank_name` varchar(60) NOT NULL DEFAULT &#039;&#039;,<br />&nbsp; `bank_address` tinytext,<br />&nbsp; `bank_curr_code` char(3) NOT NULL DEFAULT &#039;&#039;,<br />&nbsp; `dflt_curr_act` tinyint(1) NOT NULL DEFAULT &#039;0&#039;,<br />&nbsp; `id` smallint(6) NOT NULL AUTO_INCREMENT,<br />&nbsp; `bank_charge_act` varchar(15) NOT NULL DEFAULT &#039;&#039;,<br />&nbsp; `last_reconciled_date` timestamp NOT NULL DEFAULT &#039;1900-01-01 00:00:00&#039;,<br />&nbsp; `ending_reconcile_balance` double NOT NULL DEFAULT &#039;0&#039;,<br />&nbsp; `inactive` tinyint(1) NOT NULL DEFAULT &#039;0&#039;,<br />&nbsp; PRIMARY KEY (`id`),<br />&nbsp; KEY `bank_account_name` (`bank_account_name`),<br />&nbsp; KEY `bank_account_number` (`bank_account_number`),<br />&nbsp; KEY `account_code` (`account_code`)<br />) ENGINE=InnoDB AUTO_INCREMENT=3 ; </p><p>the failure is because in the newer MariaDB does not allow this line&nbsp; &nbsp;<br />`last_reconciled_date` timestamp NOT NULL DEFAULT &#039;1900-01-01 00:00:00&#039;, </p><p>so in order to make it work change it to&nbsp; <br />`last_reconciled_date` DATETIME NOT NULL DEFAULT &#039;1900-01-01 00:00:00&#039;,</p><p>After I did it it works, hope I can help someone.</p>]]></content>
			<author>
				<name><![CDATA[fburbano]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=45139</uri>
			</author>
			<updated>2026-05-12T18:30:49Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=43866#p43866</id>
		</entry>
</feed>
