SiT! Bugs - SiT!
View Issue Details
0000401SiT!billingpublic2009-01-14 10:102009-02-27 16:27
paulh 
paulh 
normalminorsometimes
closedfixed 
3.41 
3.453.45 
0000401: After approving a billable incident you get a SQL error
2009-01-14T11:17:16+00:00 /webtrack/billable_incidents.php Application Warning [512] MySQL Query Error You have an error in your SQL synta
x; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND m.expirydate > 1231931836 AND m.ter
m != 'yes'' at line 1 (in line 10402 of file /var/webtrack/includes/functions.inc.php)
2009-01-14T11:17:16+00:00 /webtrack/billable_incidents.php Warning [2] mysql_num_rows(): supplied argument is not a valid MySQL result res
ource (in line 10404 of file /var/webtrack/includes/functions.inc.php)


running 3.41
No tags attached.
child of 0000429closed paulh Move billing functions to lib/ 
Issue History
2009-01-14 10:10paulhNew Issue
2009-01-14 10:10paulhStatusnew => assigned
2009-01-14 10:10paulhAssigned To => paulh
2009-01-14 10:43paulhNote Added: 0000491
2009-01-25 14:10paulhTarget Version => 3.45
2009-01-25 14:10paulhRelationship addedchild of 0000429
2009-01-25 17:22paulhNote Added: 0000526
2009-01-25 17:22paulhStatusassigned => resolved
2009-01-25 17:22paulhResolutionopen => fixed
2009-01-25 17:22paulhFixed in Version => 3.45
2009-02-27 16:27ivanStatusresolved => closed

Notes
(0000491)
paulh   
2009-01-14 10:43   
Tracked this down to get_service_percentage which passes a siteid to does_contact_have_billable_contract rather than a contact
(0000526)
paulh   
2009-01-25 17:22   
trunk r4722 uses maintid all the way through