Lighthouse Pro 2.5 (Beta)
Tonight I'm happy to release the beta of Lighthouse 2.5. There are a lot of major changes here, so I thought I'd release it as a beta and let folks play with it a bit first. So what's different?
- New design by Justin Johnson, designer of the new CFLib.
- Milestones can be created for projects, along with an optional due date. You can then assign issues to milestones.
- There was a major change to the Ajax code behind the project view. In the previous versions, all the data was loaded on the first load. This made sorting/filtering super quick, but when projects got a bit large, it made that first hit really slow. I had a client with 400+ bugs, and it got to be pretty unusable. I switched to using Ajax to load a page of data at a time. So when you sort, or filter, it does a new HTTP request, but since it's just passing JSON around, it should still be pretty zippy. My feeling here was - keep the funcitonality the same - but ensure that larger clients wouldn't be 'punished' speed wise. Hopefully this works out well for folks.
- As part of the above change, I switched from Spry to jQuery. This was not done because Spry couldn't handle the functionality. It was done so I could play more with jQuery.
- The application includes some basic documentation in itself now. So for less-technical users who are new to the idea of issue trackers in general, we can provide them with a bit of direction.
- ColdSpring. More on that in a sec.
- When you edit an issue, the email was always pretty good about detailing the changes (status changed from X to Y), now the history field will do the same thing as well.
Ok, some quick screen shots:
Login Screen

Home Screen

Issue Screen

You can find the download below. Please note that this is beta, and should be handled with care. The readme tells you what to do on the database side. I'll blog a bit later today about the ColdSpring integration. I may also blog a bit more detail about the Ajax change if folks are interested.
Comments
I've often needed to add lists to bug reports. Using an asterisk as a bullet point is not ideal. How easy is it to add fckeditor with just a few basic formatting buttons?
# Posted By Gary Fenton
| 9/29/08 8:15 AM
# Posted By Raymond Camden
| 9/29/08 8:27 AM
# Posted By Raymond Camden
| 9/29/08 8:39 AM
# Posted By Ryan
| 9/29/08 8:47 AM
"The readme tells you what to do on the database side."
;)
# Posted By Raymond Camden
| 9/29/08 8:51 AM
# Posted By Edward Beckett
| 9/29/08 10:27 AM
Element VERSION is undefined in APPLICATION.
Maybe I missed something else to do in the readme file. Really not understanding this sort of scattered approach, with an installation file, then a readme file that initially looks like just a changelog & credits & licensing but then also has necessary information in it...
I respectfully want to disagree with your 'scattered' approach. All of my apps have used this system for years now: An install folder with full installation instructions, and a readme.txt file that explains changes from one version to another. Because this is the beta, I used the readme to explain what to do for the update. There will be a full 'upgrade' doc when I release the final version. Although the readme will still be there for folks who are curious.
# Posted By Raymond Camden
| 9/29/08 12:42 PM
Additional issues exist on user_edit.cfm (Element PLAINTEXTPASSWORD is undefined in APPLICATION) and milestone.cfm (Element PROJECT is undefined in URL.)
I assume milestone.cfm would probably work if I had a project, though.
# Posted By Raymond Camden
| 9/29/08 1:24 PM
# Posted By Raymond Camden
| 9/29/08 1:24 PM
# Posted By Raymond Camden
| 9/29/08 1:35 PM
I sent it to my boss to play with and just got a bunch of emails from him looking at the issues I posted and saving them to get back to the issue list screen.
# Posted By Raymond Camden
| 9/29/08 8:18 PM
Not a big deal I guess, but I know from our existing Altiris system, which we all loathe, we have a few users who always open the darned thing in edit mode to read it and then save it, with no changes, which then emails at minimum half dozen people, some of them twice depending on the settings for the incident. But I wouldn't use this for most of those users I guess, just for our web dev group, possibly even just for myself to help keep my 8 #1 top priority drop everything else projects organized. :)
# Posted By Raymond Camden
| 10/1/08 12:55 PM
if you like I could send you the file.
Also, i changed the status table with a "show" column to let me choose to show the status in my overview of issues or not. We have a status "closed" and I don't want to see those status in my overview.
If you like I could also send you this change.
One project dropped from 600+ issues to 80+ that actually mattered :-)
# Posted By Tjarko Rikkerink
| 10/2/08 4:36 AM
Oh.. and thanks for this great app!! I almost forgot to mention this :-)
# Posted By Tjarko Rikkerink
| 10/2/08 5:28 AM
Folks, I fixed a bug with pagination, but I haven't pushed the fix up here. I'll push it aftr I get these other mods from Tjarko.
# Posted By Raymond Camden
| 10/2/08 5:45 AM
# Posted By Raymond Camden
| 10/2/08 11:43 AM
1) The SQL at line 453 in components/issuemanager.cfc won't run against MS Access without modification. I've used LHP on a couple of small projects with Access for several years w/o problem but had to tweak the SQL to get the beta to work. I'll follow up off-line with updated SQL that should continue to work on other DB platforms but also works on SQL.
2) RE the new layout, please consider going back to an elastic page layout that expands and contracts based on the browser window width.
# Posted By Ron Stewart
| 10/3/08 4:29 PM
I fixed an issue from riaforge where sql server complained on the search. It didn't throw an error on mysql, but my fix should be good.
I fixed _another_ bug I can't reproduce, involving MilestoneDAO as well.
@Ron - as to your 'make it wide' rule, I'd like that as well. If someone can share the CSS fix, I'll gladly include it.
I want to wrap this up by Monday I think.
# Posted By Raymond Camden
| 10/4/08 8:14 AM
We have been using the previous version of Lighthose for the past year. Is there any way to maintain the data in the old DB after migrating to version 2.5? Thanks so much for creating such a useful progrm!
Regards,
Mike Flach
# Posted By Michael Flach
| 10/23/08 11:38 AM
# Posted By Raymond Camden
| 10/23/08 11:40 AM
After I installed the code I get the folowing message
Could not find the ColdFusion Component or Interface coldspring.beans.DefaultXmlBeanFactory.
The readme tells you what to do on the database side. I'll blog a bit later today about the ColdSpring.
# Posted By Geoffrey Barth
| 11/12/08 1:06 PM
# Posted By Raymond Camden
| 11/12/08 1:10 PM

There was a couple of things I wound up tinkering. I disabled emails because my group was in lighthouse almost everyday and the quantity of emails was too great. I flipped the ordering of notes so the most recent was on top, and made the issue text area a giant fckeditor window so we could do things like past email content with lists and links.