Error Executing Database Query.
|
(conn:7047) Unknown column 'id' in 'where clause'
Query is : select object_rev
from site_object_schedule
where object_type = 1
and object_id = id
and object_start_date <= '2019-12-08 10:21:58'
and object_end_date >= '2019-12-08 10:21:58'
|
|
The error occurred in C:/knivis/knivis5.1bata/content.cfc: line 99
Called from C:/Websites/fireflyatlanta/firefly-cms.com/www/index.cfm: line 104
Called from conn: line 7047
Called from conn: line 7047
Called from C:/knivis/knivis5.1bata/content.cfc: line 99
Called from C:/Websites/fireflyatlanta/firefly-cms.com/www/index.cfm: line 104
|
97 : and object_id = #id#
98 : and object_start_date <= #CreateODBCDateTime(now())#
99 : and object_end_date >= #CreateODBCDateTime(now())#
100 : </cfquery>
101 : <cfset rev = getschedulerev.object_rev>
|
|
SQLSTATE |
42S22 |
DATASOURCE |
firefly |
VENDORERRORCODE |
1054 |
SQL |
select object_rev
from site_object_schedule
where object_type = 1
and object_id = id
and object_start_date <= {ts '2019-12-08 10:21:58'}
and object_end_date >= {ts '2019-12-08 10:21:58'} |
|
Resources:
|
Browser |
CCBot/2.0 (https://commoncrawl.org/faq/) |
Remote Address |
35.172.217.40 |
Referrer |
|
Date/Time |
08-Dec-19 10:21 AM |
|