coldfusionJedi

I got my forums back up and in the process of doing so - found two interesting issues.

First - Image.cfc (which is from the open source ImageCFC project) made use of a CFC method called Throw. This allowed code in the CFC to do:

<cfset throw("Paris Hilton recommend some awesome new shoes. Shaweet!")>

Unfortunately this conflicts with ColdFusion 9's built in support for throwing via script. My "fix" was to simply rename all the throw calls to xc989082903480983894840894328093289042389. Now the code does:

<cfset xc989082903480983894840894328093289042389("code readability ftw!")>

Ok... I lie. I just renamed it mythrow, and updated the method definition as well.

Now for the UI issue. The ColdFusion/General forum has a ginormous number of threads. This created the following "interesting" UI:

That's awesome, isn't it? All it needs is a unicorn or two to spruce it up.

So I thought that wouldn't fly. What I ended up doing is simply adding some logic to say - if there are so many pages, switch to a drop down:

<p>Page:
	<cfif attributes.pages gt 10>
		<select onChange="document.location.href=this.options[this.selectedIndex].value">
			<cfloop index="x" from=1 to="#attributes.pages#">
				<option value="#cgi.script_name#?#qs#&page=#x#" <cfif url.page is x>selected</cfif>>Page #x#</option>
			</cfloop>
		</select>
	<cfelse>
	<cfloop index="x" from=1 to="#attributes.pages#">
		<cfif url.page is not x><a href="#cgi.script_name#?#qs#&page=#x#">#x#</a><cfelse>#x#</cfif>
	</cfloop>
	</cfif>
</p>

Which results in:

Somewhat better I think. Full City Media, who did the original skin for Galleon 2, is sending me over a small CSS tweak for it that I'll include in the new version shipping tomorrow morning.

I like the word Uber. Anyway, a bunch of updates today.

• Seeker was updated to include the Admin console. This now lets you list Lucene indexes as well as perform searches. You can also optimize and delete. ToDo: Form to add/index a new index. (Also ToDo are the things I mentioned before.)
• BlogCFC was updated with the latest ColdFish which should fix the CF6/7 issues.
• Galleon had a small update to the emails sent out to users.
• RIAForge. What to say? As you guys know, it has been suffering lately. A lot of folks have given advice, and I thank you. I removed the web SVN browser and it seems to have helped a lot. This does not impact the SVN server at all. Project owners can still use SVN. I just removed the web interface to browse SVN. The next issue I had was with MySQL. I was getting a max connection error. Again, multiple gurus stepped in to offer advice. I set a max connection limit in each of the DSNs on the box. So far, both of these changes seem to have helped quite a bit. Of course, it will probably go ape-youknowwhat while I'm at CFUNITED, but I'm hoping for the best.

Any questions, let me know.

I had decided to not work anymore on BlogCFC 5, but with 6 being delayed so long, I gave some love to the 5.X code base tonight. BlogCFC 5.9.003 was released tonight. Nothing major was changed, but I did switch to ColdFish, the code syntax highlighter written by Jason Delmore. This replaces the ancient code I had in there before.

Also released was an update to Galleon. This release fixes an issue related to the past security changes as well as a case sensitivity issue. (Sorry, but you will never convince me case sensitive file systems make sense. Who in the heck wants a file named foo.txt and Foo.txt??)

I also want to point out an interesting article by Ike: Porting Galleon Forums. He is porting Galleon to various frameworks and will be posting about the process.

I just released Galleon 2.2, which has a feature that folks have been asking for since 1.0. Users can now edit their own posts. This is thanks to Todd Rafferty. He did all the work for it and I just had to mod a line or two. My main objection to the ability for folks to edit messages was because I was worried folks would use it for abuse, but Todd added an automatic 'message edited' type when a user edits a message.

Anyway, enjoy.

I just released Galleon 2.1. The major change in this release is Oracle support from James Holmes. I did not document this in the Install instructions as I'm hoping a few Oracle folks out there (poor souls I'm sure) can give it a quick try. I also fixed a deletion bug. Oracle folks - please do not use the unsupported folder. Oracle support is completely baked in.

I just released Galleon version 2.013. This release has the following updates:

• I fixed an important bug involving user profiles. If encryption was turned on and a user saved their profile w/o changing their password, their old password was lost. It is critical you get this version if you encrypt your passwords.
• Two minor cross-site scripting issues fixed.
• Here is a nice one suggested by a user: The emails that get sent out for messages will now include #last in the URL. This means when you click, you see the latest messages.
• Few other small changes as well.

I just released version 2.012 of Galleon. This update adds markitup support. This is a very cool editor that makes it easy to build support for different languages, including BBML which Galleon supports.

Now - I know I'm anti rich-text editor, but this one was so nice and slim, so elegant, that I couldn't say no to it. Plus, Todd Rafferty actually did all the coding, so all I had to do was look it over. He also nicely turned it into a config setting so folks could turn the feature off if they wanted.

Unfortunately, I don't have my personal forums updated to 2.x yet, but I'll see if I can get GTT's forums updated.

I was testing Galleon under BlueDragon 7.0.1 and ran into an odd issue. My queries were being returned with the aliases ignored. Ie, I'd do

select foo as goo
from zoo

And the result query would have a foo column, not goo.

Turns out this is a known issue with the MySQL connector, and Lori from NA posted a fix here.

Last night I released a minor update to Galleon, my forums product, and this morning I discovered a small bug with it so I have updated it again. This release(s) is a minor update, changing a few small items and fixing a bug with message deletion.

Yesterday I released a minor, but important update to Galleon. This update fixes IE support in the Admin, which was pretty badly broken. I had forgot about the IE "feature" where an image button will return form.name.x, not form.name. (Thanks IE!) A few other formatting issues were fixed as well. Thanks again to Full City Media for quickly responding and fixing the bugs. Please note that I haven't yet had a chance to fix the MS Access bug. I hope to get to that this week.

Oh and if the Saints lose this one I'm officially pretending I'm from Texas.