Parameter validation error for the _INSERT function. Fresh install, first run of BugLogHQ(v1.8)

23 views
Skip to first unread message

Jeff Davis

unread,
Feb 11, 2016, 12:24:54 PM2/11/16
to BugLogHQ
Summary

After installing BugLogHQ v 1.8 under CF11, standalone developer edition, running locally on a Windows 7 box I get an error message when trying to access the dashboard/home page. The error indicates that the _insert function requires 3 parameters.

There are two _insert functions, one for databases and one for XML. It seems to me BuglogHQ is getting confused as to which to call?

How I got here

* Unzipped distro downloaded from Github page, unzipped in webroot as "bugLog"
* Set up schema in MySQL, ran scripts, confirmed tables in place
     * MySQL objected to cased name, so it created schema as "buglog", all lower case
* Made entry for datasource in CF Administrator, DSN named "bugLog" pointing to MySQL schema "buglog" and confirmed ColdFusion could connect.
* Edited buglog-config.xml.cfm to update following keys:

<setting name="general.externalURL">/bugLog/</setting>

<setting name="db.dsn">bugLog</setting>

<setting name="db.dbtype">mysql</setting>

<setting name="db.username"></setting>

<setting name="db.password"></setting>


Note I left username and password blank since that should be handled by the DSN entry in CF Admin.


Browsed to http://localhost:8500/bugLog/test/ and got the expected display.

BugLogHQ: Tests

This page links to test pages for both client and server components of bugLog


But when I go to http://localhost:8500/bugLog/hq/ I get

Parameter validation error for the _INSERT function.

The function takes 3 parameters.


Exceptions

11:46:50.050 - Template Exception - in C:/ColdFusion11/cfusion/wwwroot/bugLog/components/DAOFactory.cfc : line 20
	    Parameter validation error for the _INSERT function.


I find a function named "_insert" in two places within components\lib\dao; the dbDataProvider.cfc and the xmlDataProvider.cfc.


The code in dbDataProvider takes two arguments and the one in xmlDataProvider takes three.


Have I done something that caused a call for dbData (two parameters) to be routed to the xmlDataProvider (three parameters)?


Tried so far:


* providing the MySQL Username and password,

* running the client test in rest (error), soap, and cfc modes, NOTE Rest errors out even though I provided the arguments on the url:

* clicking the server test link gives a 500 internal error

* doing a git fetch of the master branch from GitHub, in case the several days old zip I had had been updated.



Help, please

Jeff Davis

unread,
Feb 11, 2016, 6:46:14 PM2/11/16
to bugl...@googlegroups.com
Nevermind!
Went back to github, pulled a fresh zip, redid steps and it worked!


--

---
You received this message because you are subscribed to the Google Groups "BugLogHQ" group.
To unsubscribe from this group and stop receiving emails from it, send an email to bugloghq+u...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Oscar Arevalo

unread,
Feb 29, 2016, 2:45:30 PM2/29/16
to bugl...@googlegroups.com
I'm glad that is solved. I added a new release tag to Github noting the update and explicitly calling out the fix for this particular issue.

--
Oscar Arevalo
Reply all
Reply to author
Forward
0 new messages