Error Executing Database Query.
|
|
(conn:6870) 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 <= '2020-02-24 05:54:45'
and object_end_date >= '2020-02-24 05:54:45'
|
| |
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 6870
Called from conn: line 6870
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 '2020-02-24 05:54:45'}
and object_end_date >= {ts '2020-02-24 05:54:45'} |
|
|
Resources:
|
| Browser |
CCBot/2.0 (https://commoncrawl.org/faq/) |
| Remote Address |
3.234.208.66 |
| Referrer |
|
| Date/Time |
24-Feb-20 05:54 AM |
|