FrontAccounting forum — Error Code 1292

Re: Error Code 1292

null@example.com (Tode) — Mon, 09 Dec 2019 08:14:50 +0000

Ok this seems to work. Thank you for your help.

Re: Error Code 1292

null@example.com (apmuthu) — Fri, 06 Dec 2019 04:44:28 +0000

yes

Re: Error Code 1292

null@example.com (Tode) — Sun, 01 Dec 2019 17:39:16 +0000

Thank you Braath Waate,

If I understand this correct, I should edit the file:
includes/db/connect_db_mysqli.inc

find this line:
define('SQL_MODE', 'STRICT_ALL_TABLES');

erase 'STRICT_ALL_TABLES':

so the line looks like this:
define('SQL_MODE', '');

Is this correct?

Re: Error Code 1292

null@example.com (Braath Waate) — Sun, 01 Dec 2019 11:58:26 +0000

If you are running a current version of FA, the null date problem you are experiencing could be a bug that was unmasked by the introduction of STRICT_ALL_TABLES. You could try reverting it. See this post.

Error Code 1292

null@example.com (Tode) — Sun, 01 Dec 2019 10:03:47 +0000

When I try to register suppliers invoice, I am getting this error:

Cannot add journal entry error code : 1292

error message : Incorrect date value: '' for column 'event_date' at row 1
sql that failed was : INSERT INTO 1_journal( `type`,`trans_no`, `amount`, `currency`, `rate`, `reference`, `source_ref`, `tran_date`, `event_date`, `doc_date`) VALUES('0','2764','480','EUR','1','3661','','2019-12-01','','')

FA 2.4.7
php 7.2.25

How can I fix this?