Anonymous | Login | Signup for a new account | 2021-01-21 04:38 GMT | ![]() |
Main | My View | View Issues | Change Log | Roadmap |
View Issue Details [ Jump to Notes ] | [ Issue History ] [ Print ] | ||||||||||||
ID | Project | Category | View Status | Date Submitted | Last Update | ||||||||
0001959 | SiT! | incidents | public | 2015-02-26 07:24 | 2015-04-25 12:37 | ||||||||
Reporter | selvakumar | ||||||||||||
Assigned To | paulh | ||||||||||||
Priority | normal | Severity | block | Reproducibility | always | ||||||||
Status | assigned | Resolution | open | ||||||||||
Platform | Dell | OS | Fedora | OS Version | 10 | ||||||||
Product Version | 3.67 LTS | ||||||||||||
Target Version | Fixed in Version | ||||||||||||
Summary | 0001959: in beta version v3.90 - not able to close incident immediately | ||||||||||||
Description | getting error when closing the incident immediately - Billing: Addition Failed | ||||||||||||
Steps To Reproduce | select incident - select close - Close Immediately - enter data and close getting Billing: Addition Failed error. | ||||||||||||
Tags | No tags attached. | ||||||||||||
Attached Files | ![]() | ||||||||||||
![]() |
|
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] |
![]() |
|||
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 - 2021 MantisBT Team |