<![CDATA[FrontAccounting forum — Customer Credit note entry: SQL syntax error]]> https://frontaccounting.com/punbb/viewtopic.php?id=1491 Thu, 12 Aug 2010 09:04:09 +0000 PunBB <![CDATA[Re: Customer Credit note entry: SQL syntax error]]> https://frontaccounting.com/punbb/viewtopic.php?pid=6711#p6711 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

]]> Thu, 12 Aug 2010 09:04:09 +0000 https://frontaccounting.com/punbb/viewtopic.php?pid=6711#p6711 <![CDATA[Customer Credit note entry: SQL syntax error]]> https://frontaccounting.com/punbb/viewtopic.php?pid=6709#p6709 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.

]]> Thu, 12 Aug 2010 04:55:30 +0000 https://frontaccounting.com/punbb/viewtopic.php?pid=6709#p6709