Has anyone seen this before? I converted by blog over to ContentBox locally using ContentBox express and then moved the DB and files to my server. Upon hitting the app I’m getting this error:
could not execute query |
- |
The error occurred in**/var/wwwroot/codersrevolution_com/coldbox/system/orm/hibernate/BaseORMService.cfc: line 313**
Called from /var/wwwroot/codersrevolution_com/coldbox/system/orm/hibernate/VirtualEntityService.cfc: line 105
Called from /var/wwwroot/codersrevolution_com/modules/contentbox/model/ui/LayoutService.cfc: line 145
Called from /var/wwwroot/codersrevolution_com/modules/contentbox-ui/ModuleConfig.cfc: line 142
Called from /var/wwwroot/codersrevolution_com/coldbox/system/web/services/ModuleService.cfc: line 324
Called from /var/wwwroot/codersrevolution_com/coldbox/system/web/services/ModuleService.cfc: line 256
Called from /var/wwwroot/codersrevolution_com/coldbox/system/web/services/LoaderService.cfc: line 86
Called from /var/wwwroot/codersrevolution_com/coldbox/system/Coldbox.cfc: line 71
Called from /var/wwwroot/codersrevolution_com/Application.cfc: line 82 |
Enabling ORM logging shows that the error is a syntax error on this SQL:
select
this_.settingID as settingID17_0_,
this_.name as name17_0_,
this_.[value] as value3_17_0_
from cb_setting this_
where this_.name=?
The problem bit is where it wrapped the column name “value” in square brackets. If I remove the brackets or replace them with ticks it works in a SQL client. My dialect is set to “MySQLwithInnoDB”. Has anyone else run into this?
What’s also really weird, is I have another ContentBox site running on this same server and it has no issues at all. Obviously something is different between the two of them.
Thanks!
~Brad
ColdBox Platform Evangelist
Ortus Solutions, Corp
E-mail: brad@coldbox.org
ColdBox Platform: http://www.coldbox.org
Blog: http://www.codersrevolution.com