Type	Database
Function(s)	getMessageQueue (C:/inetpub/sites/MarketplaceFunctions/SocialFunctions.cfm, Line=109, Column=1)
Query 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 'P'' order by post_date, post_time' at line 1
Datasource	MARKETPLACE
Native Error Code	1064
SQL State	42000
SQL	SELECT * from tbl_ext_service_queue where ((post_time <= '13:24:03' and post_date='2018-07-05') or post_date < '2018-07-05') and status=''P'' order by post_date, post_time
Tag Context	CFSET (C:/inetpub/sites/altusinternet.com/utils/marketplace/messages.cfm, Line=10, Column=1) | +-- CFFUNCTION (C:/inetpub/sites/MarketplaceFunctions/SocialFunctions.cfm, Line=109, Column=1)     |     +-- CFIF (C:/inetpub/sites/MarketplaceFunctions/SocialFunctions.cfm, Line=116, Column=2)         |         +-- CFELSE (C:/inetpub/sites/MarketplaceFunctions/SocialFunctions.cfm, Line=129, Column=2)             |             +-- CFQUERY (C:/inetpub/sites/MarketplaceFunctions/SocialFunctions.cfm, Line=130, Column=3)
Source	127: SELECT * from tbl_ext_service_queue where store_ID='#arguments.storeID#' and ID='#arguments.ID#' 128: </cfquery> 129: <cfelse> 130: <cfquery name="returnResults" datasource="marketplace"> 131: SELECT * from tbl_ext_service_queue where ((post_time <= '#timeformat(arguments.time, 'HH:mm:ss')#' and post_date='#dateformat(arguments.time, 'yyyy-mm-dd')#') or post_date < '#dateformat(arguments.time, 'yyyy-mm-dd')#') #statusClause# order by post_date, post_time ^ Snippet from underlying CFML source