FrontAccounting forum — Error Code 1292

Re: Error Code 1292

2019-12-09T08:14:50Z

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

Re: Error Code 1292

2019-12-06T04:44:28Z

yes

Re: Error Code 1292

2019-12-01T17:39:16Z

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

2019-12-01T11:58:26Z

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

2019-12-01T10:03:47Z

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?