Entries for month: December 2008

An update for Mango-Lightbox2

As was recently pointed out to me, a bug surfaced where my Lightbox2 plugin wasn't making the necessary configuration change for the advanced tab of the TinyMCE hyperlink dialogue to display in recent versions of Mango.

The bug was basically that some of Mango's code had been moved to a new file. My plugin slightly modifies this code to add the advanced tab, but couldn't find it. I've asked Laura to consider making this some sort of configuration that can be accessed programatically, but for now editing the file will have to do.

The new version of the plugin addresses this bug and is available on the RIAForge project page (or my project page), and in the SVN Repository.

in My projects | Mango | 4 Responses Posted 2008-12-09 01:34

A fix for my Mango Popular Posts Pod

Some people reported problems with my Mango Popular Posts Pod Plugin, and although I haven't verified this yet, I am almost certain I know what the problem is. In my test and production environments, I use SQL Server. In the query that looks up most-commented posts to display, I am using a SELECT TOP statement, which is not valid in all SQL DBMS'. Specifically, it's not valid in MySQL, which is a pretty common DBMS in use on the web. (If you aren't sure if you're using MySQL, and your hosting is pretty cheap, chances are good you are using it...)

I plan on chaning the plugin to work universally, but for now, here's a quick fix you can apply to the code yourself to get it working.

Open up Handler.cfc and change lines 147-152 from this:

to this:

That should get it running for you, in MySQL, for now. I will also look into Oracle and PostgreSQL when I implement a universal fix.

Sorry for the delay, I've been working on a pretty neat side-project that's been taking up almost every waking moment (and then some).

in Mango | My projects | 2 Responses Posted 2008-12-02 08:06