SiT! Bugs

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0001959SiT!incidentspublic2015-02-26 07:242015-04-25 12:37
Reporterselvakumar 
Assigned Topaulh 
PrioritynormalSeverityblockReproducibilityalways
StatusassignedResolutionopen 
PlatformDellOSFedoraOS Version10
Product Version3.67 LTS 
Target VersionFixed in Version 
Summary0001959: in beta version v3.90 - not able to close incident immediately
Descriptiongetting error when closing the incident immediately - Billing: Addition Failed
Steps To Reproduceselect incident - select close - Close Immediately - enter data and close

getting Billing: Addition Failed error.
TagsNo tags attached.
Attached Filesgif file icon Screenshot_05 Feb. 26 12.49.gif [^] (19,162 bytes) 2015-02-26 07:24

- Relationships

-  Notes
User avatar (0004967)
paulh (administrator)
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]

- Issue History
Date Modified Username Field Change
2015-02-26 07:24 selvakumar New Issue
2015-02-26 07:24 selvakumar File Added: Screenshot_05 Feb. 26 12.49.gif
2015-04-25 12:37 paulh Assigned To => paulh
2015-04-25 12:37 paulh Status new => assigned
2015-04-25 12:37 paulh Note Added: 0004967


Copyright © 2000 - 2019 MantisBT Team
Powered by Mantis Bugtracker