TickTac

Department

Appstore

Owner

Steve Lloyd

UNASSIGNED

Status

New

In Progress

Fixed

Tested

Closed

Priority

1-High

2-Medium

3-Low

Ticket#	Title	Status	Priority	Filename	Created	Modified
34 View	-sumfields needs to strip out html	Closed	1 - High	database.php	2 yrs 11 months 2 days	2 yrs 10 months 15 days
22 View	fix encodeLatin function	Closed	2 - Medium	common.php	3 yrs 4 days	2 yrs 11 months 29 days
19 View	Fix convertSpecialChars - special chars are messed up	Closed	2 - Medium	common.php	3 yrs 4 days	2 yrs 11 months 29 days

Array object: { "file": "dev-appstore.wasql.com_php_1ed1e472f2f5a65da007497c36c50866.php", "line": 98, "function": "getDBRecords", "error": "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 coalesce(data-'$.status','') in ('new','in_progress','fixed','tested') G' at line 7", "query": " SELECT count(*) cnt, data-'$.url' as url FROM ticktac_tickets WHERE _cuser= AND coalesce(data-'$.status','') in ('new','in_progress','fixed','tested') GROUP BY data-'$.url'" } --------------------

Array object: { "file": "dev-appstore.wasql.com_php_1ed1e472f2f5a65da007497c36c50866.php", "line": 98, "function": "getDBRecords", "error": "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 coalesce(data-'$.status','') in ('new','in_progress','fixed','tested') AN' at line 7", "query": " SELECT count(*) cnt, data-'$.owner' as owner FROM ticktac_tickets WHERE _cuser= AND coalesce(data-'$.status','') in ('new','in_progress','fixed','tested') AND url='wasql' GROUP BY data-'$.owner'" } --------------------

Array object: { "file": "dev-appstore.wasql.com_php_1ed1e472f2f5a65da007497c36c50866.php", "line": 98, "function": "getDBRecords", "error": "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 coalesce(data-'$.status','') in ('new','in_progress','fixed','tested') AN' at line 7", "query": " SELECT count(*) cnt, data-'$.status' as status FROM ticktac_tickets WHERE _cuser= AND coalesce(data-'$.status','') in ('new','in_progress','fixed','tested') AND url='wasql' GROUP BY data-'$.status'" } --------------------

Array object: { "file": "dev-appstore.wasql.com_php_1ed1e472f2f5a65da007497c36c50866.php", "line": 98, "function": "getDBRecords", "error": "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 coalesce(data-'$.status','') in ('new','in_progress','fixed','tested') AN' at line 7", "query": " SELECT count(*) cnt, data-'$.priority' as priority FROM ticktac_tickets WHERE _cuser= AND coalesce(data-'$.status','') in ('new','in_progress','fixed','tested') AND url='wasql' GROUP BY data-'$.priority'" } --------------------