1 Topic by Tode (edited by Tode 12/01/2019 05:32:29 pm)

  • Tode
  • Member
  • Offline
  • From: Denmark
  • Registered: 03/04/2018
  • Posts: 19

Topic: Error Code 1292

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?

  • From: USA
  • Registered: 07/16/2017
  • Posts: 276

Re: Error Code 1292

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.

  • Tode
  • Member
  • Offline
  • From: Denmark
  • Registered: 03/04/2018
  • Posts: 19

Re: Error Code 1292

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?

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,160

Re: Error Code 1292

yes

apmuthu's Website

  • Tode
  • Member
  • Offline
  • From: Denmark
  • Registered: 03/04/2018
  • Posts: 19

Re: Error Code 1292

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