BlogCFC 5.1.003 Released

This is another minor update.

A method was added to remove all unverified subscribers. This will help clean up spammers from your subscribe list.

Charlie suggested a nice fix for the "too long" url issue in the recent comments pod.

I added editing instructions to the admin. I get multiple emails from folks asking how they do certain things in blog entries, so I thought this would help.

Comments
Critter's Gravatar Thanks mate!
# Posted By Critter | 7/21/06 8:10 AM
MrBuzzy's Gravatar Say I wanted to see the code changes from 5.1.001 to 5.1.003... should I use SVN for that?
I have Tortoise, it seems I can only choose revisions by whole numbers, ie '5'.

Cheers.
# Posted By MrBuzzy | 7/22/06 1:19 AM
Raymond Camden's Gravatar Tortoise lets me see such changes if I do it file by file. Not sure about over all files.
# Posted By Raymond Camden | 7/22/06 8:12 AM
Critter's Gravatar What about an option to verify a subscriber?

what I mean.. Let's say granny subscribes to the blog, but for one reason or another misses the blog email.. it's junked.. or something... she never sees the verification email.. I can go into the db and do it..

just a thought...
# Posted By Critter | 7/23/06 8:51 AM
Raymond Camden's Gravatar As you noticed, I didn't let you edit subscribers. I could add that so you could verify. Adding a simple Verify Selected will be a pain as I use one custom tag for all the tables in the admin.
# Posted By Raymond Camden | 7/24/06 8:08 AM
Raymond Camden's Gravatar Hey guys. Forgive me. I'm doing some mail server testing. If you get this, please post a comment.
# Posted By Raymond Camden | 7/31/06 11:13 AM
Carl's Gravatar I get errors when trying to import thenew mysql.sql file. the file contained in ver. 5.007 works fine.

What changed?

I'm running mySQL 4.1.

Thanks,

-Carl
# Posted By Carl | 7/31/06 11:52 AM
Raymond Camden's Gravatar What errors?
# Posted By Raymond Camden | 7/31/06 11:56 AM
Carl's Gravatar Ray,

It almost seems like the top of the mysql.sql file was cut off. Below is the error:

Line no.:120
Error Code: 1231 - Variable 'character_set_client' can't be set to the value of 'NULL'

Query:
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */

Thanks,

-Carl
# Posted By Carl | 8/1/06 8:53 AM
Carl's Gravatar Oh, and the server is running mySQL 5, not 4.1.

-Carl
# Posted By Carl | 8/1/06 8:58 AM
Raymond Camden's Gravatar Odd. So looking at the diffs, I don't see anything dropped. Oh wait. Now I do.

Try adding this to the top.

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

If this works let me know and I'll update.
# Posted By Raymond Camden | 8/1/06 9:19 AM
Carl's Gravatar Now I get:

Error occured at:2006-08-01 10:18:01
Line no.:123
Error Code: 1231 - Variable 'collation_connection' can't be set to the value of 'NULL'

-Carl
# Posted By Carl | 8/1/06 10:19 AM
Carl's Gravatar I took these from the old version and added them to the new one and the import ran sucessfully.

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;

I'll let you know if I see any issues setting up or using the blog.

Thanks for your help and for the great app!

-Carl
# Posted By Carl | 8/1/06 10:23 AM
Raymond Camden's Gravatar I'll get those guys into the newxt build.
# Posted By Raymond Camden | 8/1/06 10:25 AM
Henry Fatino's Gravatar Hey ray I have the problem with the "Pods" not displaying until after the middle section display. I only have 1 hair left on my head trying to fix this. Any help would be appriciated.
# Posted By Henry Fatino | 8/17/06 9:46 AM
Raymond Camden's Gravatar Are you running the very latest?
# Posted By Raymond Camden | 8/17/06 9:55 AM
BlogCFC was created by Raymond Camden. This blog is running version 5.9.2. Contact Blog Owner