• From: UK
  • Registered: 10/02/2012
  • Posts: 146

Topic: Bank deposit bug

Hi
I am getting this error when posting bank deposit.

DATABASE ERROR :
At file C:\www\favarsoni\gl\includes\db\gl_db_trans.inc:66:
The GL transaction could not be inserted
error code : 1366
error message : Incorrect string value: '\xA31 Eac...' for column 'memo_' at row 1
sql that failed was : INSERT INTO 0_gl_trans ( type, type_no, tran_date, account, dimension_id, dimension2_id, memo_, amount, person_type_id, person_id) VALUES ('2', '5', '2014-02-05', '18001', '0', '0', 'admin - D Varsani 500 Shares @ £1 Each.', '-500', '0', '')

Thanks

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,107

Re: Bank deposit bug

I will have a Word with Janusz regarding this.

/Joe

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,107

Re: Bank deposit bug

You have probably set your database to utf8 while FA is running with another character encoding.

Joe