LighthousePro 2.2 Released

Posted in ColdFusion | Posted on 01-21-2007 | 4,798 views

Today I put the finishing touches on Lighthouse 2.2, my ColdFusion based bug tracker. It was more fun that watching my Saints lose. (Although they did try very hard!) Changes in this version include:

First off - many changes were done by Qasim Rasheed. Thanks Qasim!
Support for Oracle. This was done by renaming the tables to not conflict with Oracle. There isn't a install script yet, but you should be able to copy the structure from SQL Server and run it just fine on Oracle. (Thanks Qasim.)
You can supply a username/password for your dsn. (Thanks Qasim.)
Improvements to how CFCs are passed around. (Thanks Qasim.)
Issue Types are now editable. In the past your issues were one of two types: Bug or Enhancement. Now you can make as many issue types as you want.
Slight changes to the PDF creation. You now get a properly named file and the display is a tiny bit different.
LighthousePro is now cooking with AJAX, baby! Spry specifically. This will be especially useful for projects with large numbers of issues.

You can download the latest version from RIAForge (which is also going to have a nice update later this week).

The next version of LighthousePro will have integrated email checking. You will be able to point a project to a mail server account and then have it automatically create bug reports based on mails sent to the account. This lets you "open up" LHP to the world by simply creating an email address for your bug reports.

As always, LHP is free. If you find it useful, please visit my wish list.

Comments

[Add Comment] [Subscribe to Comments]

dickbob said on 01-22-2007 at 4:13 AM #

A little bug I think using MS Access?

IssueManager.cfc line 343

[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'i.locusidfk = pl.id LEFT JOIN lh_severities sev on i.severityidfk = sev.id LEFT JOIN lh_statuses st on i.statusidfk = st.id LEFT JOIN lh_projects p on i.projectidfk = p.id LEFT JOIN lh_users u on i.useridfk = u.id LEFT JOIN lh_issuetypes it on i.issuetypeidf'.

Raymond Camden said on 01-22-2007 at 5:33 PM #
	Confirmed. Not quite sure how to fix it though. It works fine in MySQL/SQL Server. Do you know?

Antony said on 01-22-2007 at 8:54 PM #
	If you have a spare 5 mins you could drop in Reactor or Transform... Sorry, no real suggestion on how to fix it.

dickbob said on 01-23-2007 at 3:31 AM #

Okay, I've taken a look at the query and got the following to work in MS Access...

SELECT i.id, i.projectidfk, i.created, i.updated, i.publicid, i.duedate,
i.name, i.useridfk, i.description, i.history, i.creatoridfk,
i.locusidfk, i.severityidfk, i.statusidfk, i.relatedurl, i.attachment,
pl.name AS locusname,
sev.name AS severityname,
st.name AS statusname,
p.name AS projectname,
sev.rank AS severityrank,
u.name AS username,
it.name as issuetype
FROM (((((lh_issues i
LEFT JOIN lh_projectloci pl on i.locusidfk = pl.id)
LEFT JOIN lh_severities sev on i.severityidfk = sev.id)
LEFT JOIN lh_statuses st on i.statusidfk = st.id)
LEFT JOIN lh_projects p on i.projectidfk = p.id)
LEFT JOIN lh_users u on i.useridfk = u.id)
LEFT JOIN lh_issuetypes it on i.issuetypeidfk = it.id
WHERE 1=1

Looks like MS Access likes it brackets!

You want to check that it is supported in the other db's.

Raymond Camden said on 01-23-2007 at 6:29 AM #
	That did it, thanks! There will be a 2.2.002 release later today. Other bugs are fixed as well.

David said on 01-23-2007 at 6:26 PM #
	when did all the tables get renamed with the lh_ prefix? we only started using in lighthouse in late december(and now have hundreds of bugs in it), but don't see a straight forward upgrade path here as the tables are all named different!

Raymond Camden said on 01-23-2007 at 9:13 PM #
	David, please see the readme as it describes what to do. Outside of the changes for issuetypes, all you need to do is rename the tables, which is simple.

David said on 01-23-2007 at 9:24 PM #
	ah... RTFM!! my apologies jedi master ;p

Scott Fitchet said on 01-24-2007 at 4:47 PM #
	Not sure where the bugtracker is for the bugtracker. ;) The mySQL install script did not run in Navicat until I deleted the comments at the top and bottom of the file. Not sure which of those two programs choked on it.

Raymond Camden said on 01-24-2007 at 4:53 PM #
	THose comments came from mysql-front. I need to stop using that. ;) Oh - and LHP has a bug tracker on riaforge.

[Add Comment] [Subscribe to Comments]