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.
Comment 1 written by dickbob on 22 January 2007, at 4:13 AM
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'.
Comment 2 written by Raymond Camden on 22 January 2007, at 5:33 PM
Comment 3 written by Antony on 22 January 2007, at 8:54 PM
Sorry, no real suggestion on how to fix it.
Comment 4 written by dickbob on 23 January 2007, at 3:31 AM
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.
Comment 5 written by Raymond Camden on 23 January 2007, at 6:29 AM
Comment 6 written by David on 23 January 2007, at 6:26 PM
Comment 7 written by Raymond Camden on 23 January 2007, at 9:13 PM
Comment 8 written by David on 23 January 2007, at 9:24 PM
Comment 9 written by Scott Fitchet on 24 January 2007, at 4:47 PM
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.
Comment 10 written by Raymond Camden on 24 January 2007, at 4:53 PM
Oh - and LHP has a bug tracker on riaforge.
[Add Comment] [Subscribe to Comments]