Hi folks,
I downloaded Coldbox-Relax last last night and am receiving the following error when trying to view the logbox logs. My Db is MSSQL, and I have registered the dsn “relax” in CF Admin.
Here are my logbox settings in colbox.cfc config:
//LogBox DSL
logBox = {
// Define Appenders
appenders = {
coldboxTracer = { class=“coldbox.system.logging.appenders.ColdboxTracerAppender” },
dbAppender = {
class=“coldbox.system.logging.appenders.DBAppender”,
properties = {
dsn = “relax”, table=“api_logs”, autocreate=true, textDBType=“longtext”
}
}
},
// Root Logger
root = { levelmax=“DEBUG”, appenders="*" },
// Implicit Level Categories
info = [ “coldbox.system” ]
};
When I navigate within CB-Relax to view the logfiles I receive the following error:
Application Execution ExceptionError Type: Database : HY000
Error Messages: Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ‘LIMIT’.
Tag Context:
ID: CFQUERY
LINE: 36
Template: /Library/WebServer/Documents/coldbox-relax/modules/relax/model/relax/logbox/MYSQL_DAO.cfc
Based on the stacktrace it looks like CB is tripping up on a call to the MYSQL_DAO.cfc, however I’m using MSSQL as a database. I checked CB’s config settings for the DBAppender and there doesn’t seem to be any setting to indicate the DBType.
I know CB-Relax is really new, so not sure if others have come across this yet.
Thanks in advance.
Nolan