Related Entries 1.1.2 released

I'm happy to announce that my Related Entries plugin for Mango Blog has finally gotten the attention it so desperately needed. I've been swamped at work (in a good way — up to my eyeballs in learning Flex and writing applications for classroom use), and just haven't had the energy or brain power to work on these projects when I get home. I owe a debt of gratitude to my wife, who graciously allows me an evening every now and then away from some family and household obligations to work on projects like this; and to Mark Aplet, who is always willing to be my crash test dummy. In addition to today's update for Related Entries, I have some updates for Scribe in the pipeline as well.

The short version of the story is that I've fixed some significant bugs:

• Railo incompatibility due to core function name collision (part of JSONUtil, but I've adjusted for it. I've also filed a bug report and am working with Nathan to find the best solution for it.)
• Case-sensitive Operating System incompatibility — I was mixing references to "jsonutil" with a file named "JSONUtil".
• Reverse-links (when you relate post A to post B, I automatically relate post B back to post A — this is called a reverse link) were being improperly stored, and in most cases would be displayed on your blog, but you could not remove them in admin.

The case-sensitivity thing is a common gotcha, but I am a human and I work on Windows/OSX most of the time, where this isn't a problem. Please forgive the error. To make up for it, I'm offering Related Entries at half price all this week!

Fixing the reverse-links has proven to be a tricky task. I've tested this now on ColdFusion 8, ColdFusion 9, and Railo; and I am fairly confident that I've got a decent solution. You have two options.

1. For users who use SQL Server as your database, and have fairly high permissions, I have an SQL script that should fix the data for you. The only caveat with the script is that it assumes your Mango install's tables do not use a table prefix. If they do, you'll need to edit the script accordingly. (Update references to both entry_custom_field and entry to [prefix]entry_custom_field and [prefix]entry, respectively.)
   
   Of course, you should back up your database before running this script. I will apologize profusely if it messes something up, but that's about all you'll get from me.
   
   
2. For MySQL users, or SQL Server users who don't have adequate permission to run a custom script, the plugin should be (somewhat) self-correcting. If you know you have an entry with some strange behavior around Related Entries: edit that entry, double-click each related entry in the 3rd listbox to remove it — until the box is empty, and then add related entries back. This should fix most otherwise-unexplainable issues. Unfortunately, I don't think it will fix reverse-links that you can't remove. I hope to provide another release soon that will automatically fix these, but I wanted to get this part of the fix out there, so that at least no more bad data is created.

No matter which of the above two options you choose, you should update to prevent further bad data from being created.

And don't forget to grab the SQL script, if you have the ability to run it.

Plugin:

Related Entries

Version:

1.1.2

Requires:

Mango Blog 1.3+

Auto-install URL:

http://fusiongrokker.com/get/RelatedEntries

Posted in Mango | My projects | 1 Response  

1 response:

• Mike Henke Jul 30, 2009 at 9:58 AM This is great news. Thanks,