TickTac

Department

Appstore

Blogsmart

Owner

Steve Lloyd

UNASSIGNED

Status

New

In Progress

Fixed

Tested

Closed

Priority

1-High

2-Medium

3-Low

Ticket#	Title	Status	Priority	Owner	Created	Modified
18 View	Add ability to check to see if a license has been used	Closed	2 - Medium	Steve Lloyd	3 yrs 4 days	3 yrs 2 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='appstore' 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='appstore' 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='appstore' GROUP BY data-'$.priority'" } --------------------