<?xml version="1.0" encoding="utf-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom">
	<channel>
		<title><![CDATA[FrontAccounting forum — Installing clean 2.4.20 version gets stuck]]></title>
		<link>https://frontaccounting.com/punbb/viewtopic.php?id=10726</link>
		<atom:link href="https://frontaccounting.com/punbb/extern.php?action=feed&amp;tid=10726&amp;type=rss" rel="self" type="application/rss+xml" />
		<description><![CDATA[The most recent posts in Installing clean 2.4.20 version gets stuck.]]></description>
		<lastBuildDate>Tue, 12 May 2026 18:30:49 +0000</lastBuildDate>
		<generator>PunBB</generator>
		<item>
			<title><![CDATA[Installing clean 2.4.20 version gets stuck]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=43866#p43866</link>
			<description><![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>]]></description>
			<author><![CDATA[null@example.com (fburbano)]]></author>
			<pubDate>Tue, 12 May 2026 18:30:49 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=43866#p43866</guid>
		</item>
	</channel>
</rss>
