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

SQL "null" argument still needs to be set in a few spots #73

Open michael-zock opened 10 years ago

michael-zock commented 10 years ago

Seems there are still a few cases similar to issue #72

In this case it happened while I was viewing a bug entry and wanted to delete the entry along with all its siblings. Database in question is an MS SQL Server, though setting the "null" argument in the cfqueryparam tags should probably be a more versatile remedy.

Exception Summary
Application:    bugLogHQ
Host:   intra1
URL:    http://intra1/buglog/hq/index.cfm
Server Date/Time:   03.12.2013 10:02
Message:    Invalid data '' for CFSQLTYPE CF_SQL_NUMERIC.
Type:   Database
Detail:     
Tag Context:    
Y:\intranet\bugLog\components\lib\dao\dbDataProvider.cfc [64]
Y:\intranet\bugLog\components\lib\dao\DAO.cfc [47]
Y:\intranet\bugLog\components\hq\appService.cfc [318]
Y:\intranet\bugLog\hq\handlers\general.cfc [524]
Y:\intranet\bugLog\core\coreApp.cfc [210]
Y:\intranet\bugLog\core\coreApp.cfc [95]
Y:\intranet\bugLog\hq\index.cfm [27]
Script Name (CGI):  /buglog/hq/index.cfm
User Agent:     Mozilla/5.0 (Windows NT 6.1; WOW64; rv:26.0) Gecko/20100101 Firefox/26.0 ColdFire/1.11.208.251
Remote Address:     192.168.110.79
Referrer:   http://intra1/buglog/hq/index.cfm?event=entry&entryID=313771
Query String:   
Request Method:     POST
ColdFusion ID:  [SESSION]      CFID = - ; CFTOKEN = — ; SESSIONID = 84309817417cbff85cdd6869344e4bf17497
[CLIENT]      CFID = — ; CFTOKEN = —
[COOKIES]      CFID = 9464695 ; CFTOKEN = 68838170 ; JSessionID = 84309817417cbff85cdd6869344e4bf17497

Exception Info
Suppressed:     Empty array
SQLState:   n/a
sql_type:   CF_SQL_NUMERIC