Error Executing Database Query.
|
|
(conn:7958) 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 <= '2018-10-20 23:27:23'
and object_end_date >= '2018-10-20 23:27:23'
|
| |
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 7958
Called from conn: line 7958
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 '2018-10-20 23:27:23'}
and object_end_date >= {ts '2018-10-20 23:27:23'} |
|
|
Resources:
|
| Browser |
CCBot/2.0 (https://commoncrawl.org/faq/) |
| Remote Address |
54.224.56.126 |
| Referrer |
|
| Date/Time |
20-Oct-18 11:27 PM |
|