Error Executing Database Query.
|
Unknown column 'd.zoneid' in 'field list'
|
|
The error occurred in D:/home/dr-oogle.com/wwwroot/recent_reviews.cfm: line 215
Called from D:/home/dr-oogle.com/wwwroot/recent_reviews.cfm: line 194
Called from D:/home/dr-oogle.com/wwwroot/recent_reviews.cfm: line 58
Called from D:/home/dr-oogle.com/wwwroot/recent_reviews.cfm: line 1
Called from D:/home/dr-oogle.com/wwwroot/dentist.cfm: line 616
Called from D:/home/dr-oogle.com/wwwroot/recent_reviews.cfm: line 215
Called from D:/home/dr-oogle.com/wwwroot/recent_reviews.cfm: line 194
Called from D:/home/dr-oogle.com/wwwroot/recent_reviews.cfm: line 58
Called from D:/home/dr-oogle.com/wwwroot/recent_reviews.cfm: line 1
Called from D:/home/dr-oogle.com/wwwroot/dentist.cfm: line 616
|
213 : WHERE <cfif session.dbzone lt 100 or session.dbzone gt 100 and isdefined('url.city') and url.city neq ''>u.domain = '#session.metroname#'<cfelse>D.State = '#session.state#'</cfif>
214 :
215 : and u.city='#cleancity#' AND U.Showreview = 1 AND D.noListing = 0 AND D.noReviews = 0 and D.nonparticipating = 0
216 :
217 : ORDER BY U.reviewID DESC
|
|
SQLSTATE |
42S22 |
DATASOURCE |
oogle_cc_aws |
VENDORERRORCODE |
1054 |
SQL |
SELECT D.dentistID, D.FirstName, d.zoneid, D.City, D.specialty, D.lastname,U.Question5, U.reviewID, U.review, D.numreviews, D.Address, D.zipcode
FROM userreviews U
LEFT OUTER JOIN dentists D ON u.dentistid = d.dentistid
WHERE u.domain = 'San Francisco'
and u.city='eby' AND U.Showreview = 1 AND D.noListing = 0 AND D.noReviews = 0 and D.nonparticipating = 0
ORDER BY U.reviewID DESC
limit 6
|
|
Resources:
|
Browser |
claudebot |
Remote Address |
172.70.39.81 |
Referrer |
|
Date/Time |
29-Mar-24 08:11 AM |
|