Coldbox Relax - error with logbox

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 = {
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:
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.



hushhhhh!! Relax is brand new!! Nobody knows yet.

I pushed my latest committs today. Try it again and let me know.

Luis F. Majano
Ortus Solutions, Corp

ColdBox Platform:
Linked In:
IECFUG Manager: