Lighthouse Pro Bug Fixes

This post is more than 2 years old.

So, there are a few minor bugs with LHP. Unfortunately, I'm preparing for a business trip so I may not have time to package a nice little zip. Until then - I'm going to post the fixes here. I will have the Forums up soon. Just click on Galleon Forums in the right hand Tools pod and you will (eventually) see the LHP conference.


  • The mySQL install script doesn't have the relatedURL property. Simply add it to issues, varchar, 255, not null, default "".
  • Ditto for MS Access.
  • So, now for a fun bug. On a MySQL install, a user kept getting an error when they would create an issue. The error was:

    The argument IBEAN passed to function create() is not of type IssueBean.

    Now, I knew for a fact I was passing a IssueBean to IssueDAO.create. I even dumped to make sure. I scratched my head for a while on it. Then Craig Taylor sent me a note. Turns out - the bug was simply with the cfqueryparam for the isBug value. You need to change:

    <cfqueryparam cfsqltype="cf_sql_bit" value="#arguments.iBean.getIsBug()#">


    <cfqueryparam cfsqltype="cf_sql_integer" value="#arguments.iBean.getIsBug()#">

    Now - this may break in Access or SQL Server. When I have time, I'll test, and if so, I'll simply do an IF there to check the db type. Big thanks to Craig.

Raymond Camden's Picture

About Raymond Camden

Raymond is a developer advocate for HERE Technologies. He focuses on JavaScript, serverless and enterprise cat demos. If you like this article, please consider visiting my Amazon Wishlist or donating via PayPal to show your support. You can even buy me a coffee!

Lafayette, LA