Details
-
Bug
-
Status: Resolved
-
Critical
-
Resolution: Fixed
-
ManifoldCF 1.4
-
None
-
Postgresql 9.2.5
Description
Receive the following message on the ' Status and Job Management' screen:
Error: Database exception: SQLException doing query (42601): ERROR: syntax error at or near "status" Position: 60
Digging through the debug logs found:
DEBUG 2013-10-31 12:29:11,911 (http-apr-8081-exec-5) - Requested query: [SELECT COUNT(dochash) AS doccount FROM jobqueue WHERE id=?status IN (?,?,?,?,?,?) LIMIT 500001]
DEBUG 2013-10-31 12:29:11,911 (Thread-16) - Actual query: [SELECT COUNT(dochash) AS doccount FROM jobqueue WHERE id=?status IN (?,?,?,?,?,?) LIMIT 500001]
DEBUG 2013-10-31 12:29:11,912 (Thread-16) - Parameter 0: '1380815567276'
DEBUG 2013-10-31 12:29:11,912 (Thread-16) - Parameter 1: 'A'
DEBUG 2013-10-31 12:29:11,912 (Thread-16) - Parameter 2: 'a'
DEBUG 2013-10-31 12:29:11,912 (Thread-16) - Parameter 3: 'P'
DEBUG 2013-10-31 12:29:11,912 (Thread-16) - Parameter 4: 'F'
DEBUG 2013-10-31 12:29:11,912 (Thread-16) - Parameter 5: 'f'
DEBUG 2013-10-31 12:29:11,912 (Thread-16) - Parameter 6: 'G'
DEBUG 2013-10-31 12:29:11,918 (http-apr-8081-exec-5) - Reinterpreting exception 'Database exception: SQLException doing query (42601): ERROR: syntax error at or near "status"
Position: 60'. The exception type is 4
DEBUG 2013-10-31 12:29:11,918 (http-apr-8081-exec-5) - Exception Database exception: SQLException doing query (42601): ERROR: syntax error at or near "status"
Position: 60 is possibly a transaction abort signal
DEBUG 2013-10-31 12:29:11,918 (http-apr-8081-exec-5) - Exception Database exception: SQLException doing query (42601): ERROR: syntax error at or near "status"
Position: 60 is NOT a transaction abort signal
Appears that the SQL request is missing a space at 'WHERE id=?status IN (....'