• Registered: 06/05/2010
  • Posts: 17

Topic: Customer Credit note entry: SQL syntax error

DATABASE ERROR : The debtor transaction detail could not be written
error code : 1064
error message : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''0')' at line 6
sql that failed was : INSERT INTO 0_debtor_trans_details (debtor_trans_no, debtor_trans_type, stock_id, description, quantity, unit_price, unit_tax, discount_percent, standard_cost, src_id) VALUES ('4', '11', '102', '17inch VGA Monitor', 1, 26.42, 2.4571, 0, ,'0')

I am using ver. 2.3 beta.
How do i fix this?
Many Thanks.

  • Registered: 12/25/2007
  • Posts: 2,448

Re: Customer Credit note entry: SQL syntax error

Has been fixed in CVS unstable. Fixed file is attached to mantis report.
And yes, mantis is the best place for bug reports, however we cannot guarantee all problems are fixed in 24 hours.
Janusz