<![CDATA[FrontAccounting forum — Customer Credit note entry: SQL syntax error]]> 2010-08-12T09:04:09Z PunBB https://frontaccounting.com/punbb/viewtopic.php?id=1491 <![CDATA[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

]]> https://frontaccounting.com/punbb/profile.php?id=89 2010-08-12T09:04:09Z https://frontaccounting.com/punbb/viewtopic.php?pid=6711#p6711 <![CDATA[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.

]]> https://frontaccounting.com/punbb/profile.php?id=1126 2010-08-12T04:55:30Z https://frontaccounting.com/punbb/viewtopic.php?pid=6709#p6709