SiT! Bugs - SiT!
View Issue Details
0001959SiT!incidentspublic2015-02-26 07:242015-04-25 12:37
selvakumar 
paulh 
normalblockalways
assignedopen 
DellFedora10
3.67 LTS 
 
0001959: in beta version v3.90 - not able to close incident immediately
getting error when closing the incident immediately - Billing: Addition Failed
select incident - select close - Close Immediately - enter data and close

getting Billing: Addition Failed error.
No tags attached.
gif Screenshot_05 Feb. 26 12.49.gif (19,162) 2015-02-26 07:24
http://bugs.sitracker.org/file_download.php?file_id=262&type=bug
gif
Issue History
2015-02-26 07:24selvakumarNew Issue
2015-02-26 07:24selvakumarFile Added: Screenshot_05 Feb. 26 12.49.gif
2015-04-25 12:37paulhAssigned To => paulh
2015-04-25 12:37paulhStatusnew => assigned
2015-04-25 12:37paulhNote Added: 0004967

Notes
(0004967)
paulh   
2015-04-25 12:37   
reproduced using points based billing, error

)
2015-04-25T12:35:56+01:00 /sit4/incident_close.php Application Error [256] 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 'AND transactionstatus = 10' at line 1 (in line 1517 of file /home/paulh/dev/paulheaneys-sit/lib/billing.inc.php)

[CONTEXT-BEGIN]
Array
(
    [transactionid] =>
    [amount] => -1
    [description] =>
    [rtnvalue] => 1
    [sql] => UPDATE `transactions` SET amount = -1, transactionstatus = 5 WHERE transactionid = AND transactionstatus = 10
)

[CONTEXT-END]
----------

2015-04-25T12:35:56+01:00 /sit4/incident_close.php Application Error [256] Transition reserved monies failed UPDATE `transactions` SET amount = -1, transactionstatus = 5 WHERE transactionid = AND transactionstatus = 10 (in line 1522 of file /home/paulh/dev/paulheaneys-sit/lib/billing.inc.php)

[CONTEXT-BEGIN]
Array
(
    [transactionid] =>
    [amount] => -1
    [description] =>
    [rtnvalue] =>
    [sql] => UPDATE `transactions` SET amount = -1, transactionstatus = 5 WHERE transactionid = AND transactionstatus = 10
)

[CONTEXT-END]