search

oarevalo / BugLogHQ

BugLogHQ is a tool to centralize the handling of automated bug reports from multiple applications. BugLogHQ provides a unified view of error messages sent from any number of applications, allowing the developer to search, graph, forward, and explore the bug reports submitted by the applications.
http://www.bugloghq.com
154 stars 67 forks source link

Timezone setting causes failure in application #54

Closed sipacate closed 11 years ago

sipacate commented 11 years ago

Changing the Timezone in the buglog-config.xml.cfm to UTC-5 (or some such value) causes the application to report an error with the format.

Expression Exception - in C:_web\bugLog\hq\includes\udf.cfm : line 76 {ts '2013-06-17 07:59:56'} is an invalid time format.

To fix this, remove the {ts } portions of the date time return strings in /hq/includes/udf.cfm inside of the dateConvertZ(). (This is on CF9)

return "{ts '" & DateFormat(targetDate, "yyyy-mm-dd ") & TimeFormat(targetDate, "HH:mm:ss") & "'}"; should be return DateFormat(targetDate, "yyyy-mm-dd ") & TimeFormat(targetDate, "HH:mm:ss");

return "{ts '" & DateFormat(targetDate, "yyyy-mm-dd ") & TimeFormat(targetDate, "HH:mm:ss") & "'}"; should be return DateFormat(targetDate, "yyyy-mm-dd ") & TimeFormat(targetDate, "HH:mm:ss");

return "{ts 'yyyy-mm-dd HH:mm:ss'}"; should be
return 'yyyy-mm-dd HH:mm:ss';

oarevalo commented 11 years ago

Fixed in 1.8.1. Funny thing, this bug does not manifest itself in Railo engines, only on ACF ones (I was able to reproduce this on ACF10)

sipacate commented 11 years ago

Thanks. I'm loving the product. On Jun 19, 2013 7:12 PM, "Oscar Arevalo" notifications@github.com wrote:

Fixed in 1.8.1. Funny thing, this bug does not manifest itself in Railo engines, only on ACF ones (I was able to reproduce this on ACF10)

— Reply to this email directly or view it on GitHubhttps://github.com/oarevalo/BugLogHQ/issues/54#issuecomment-19721448 .