While we are on lighthouse, I've a similar open source system http://cfdefect.riaforge.com.
Thanks Qasim On Mon, Mar 31, 2008 at 11:44 AM, Seth Bienek <[EMAIL PROTECTED]> wrote: > I agree. For the uninitiated, Lighthouse keeps a change log for open > issues by appending a carriage return followed by a datestamp and comments > reflecting the changes to an issue to a carchar field. It keeps things > simple (architecturally) but has limits on the amount of history that can be > stored, and makes the data less usable for searching and reporting. > > If someone (like Aaron, wink wink, nudge nudge) were to break the historty > out into a seperate table and check in the changes, it would be a big > improvent for what is probably the biggest drawback to the product. > > Seth > > ------------------------------ > *From:* [email protected] [mailto:[EMAIL PROTECTED] *On > Behalf Of *Aaron Rouse > *Sent:* Monday, March 31, 2008 9:58 AM > *To:* [email protected] > *Subject:* [houcfug] Re: free issue tracking systems? > > That reminds me, we used it on Oracle on the project I mentioned earlier. > At the time the scripts for Oracle created the comments/issues fields as > varchar2. We routinely were getting to the point of running out of room due > to the datatype. First tried to increase it to 4000k and ultimately went to > a clob. Ray, the maker of LH, seemed to think that the scripts for Oracle > did a clob out of the box but the ones we got did not, do not know if he > since updated this. I personally always wanted to modify it so that > comments were their own record in the database to make it easier to search > on comments based upon user and time/date. > > On Mon, Mar 31, 2008 at 9:48 AM, Seth Bienek <[EMAIL PROTECTED]> wrote: > > > I've had good luck using Lighthouse Pro for a 4-person team on my > > current project. > > > > http://lighthousepro.riaforge.org/ > > > > It's not a full-featured system, but it is CF-based, and well > > architected, so you can add the functionality you need fairly easily.. > > > > On a side note, the SQL is pretty plain vanilla, which makes it good for > > deploying on most DB platforms. It was designed for MySQL, but we deployed > > it on Oracle with only minor modifications (mostly to account for Oracle's > > case-sensitivity). > > > > Trac is a more complete free "project management" system, but is a > > little more (functionally) than we have needed, and I was put off by the > > poor usability and learning curve aspects. It may suit your needs, though: > > > > http://trac.edgewall.org/ > > > > Take Care, > > > > Seth > > > > ------------------------------ > > *From:* [email protected] [mailto:[EMAIL PROTECTED] *On > > Behalf Of *Mark Davis > > *Sent:* Monday, March 31, 2008 9:11 AM > > *To:* [email protected] > > *Subject:* [houcfug] free issue tracking systems? > > > > Anyone recommend a free or inexpensive issue tracking system? > > > > > > > > *Mark Davis* > > > > __________________________________________________ > > *ProjecTools.com* > > P.O. Box 786 > > Bellville, TX 77418 > > (713) 371 9840 x 1308 > > cell (303) 261-7851 > > [EMAIL PROTECTED] > > > > > > > > > > > -- > Aaron Rouse > http://www.happyhacker.com/> > -- Qasim Rasheed Certified Advanced ColdFusion MX Developer (IM qasimrasheed AT yahoo, msn or GTalk) --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the "Houston ColdFusion Users' Group" discussion list. To unsubscribe, send email to [EMAIL PROTECTED] For more options, visit http://groups.google.com/group/houcfug?hl=en -~----------~----~----~----~------~----~------~--~---
