Blog Entry Disappears from BlogCFC
This is a strange one. I'm hoping that someone else has come across it and figured out what the problems is. Basically, after I create a new entry to my blog, if I edit something directly in the database, that entry doesn't display anymore.
This happened with a post earlier today. After I published my blog entry, I noticed that the time being displayed was about 5 hours off. Not knowing if it was a data or a display issue, I looked in the database to see what the time stamp was on the blog entry. Sure enough, the database (MySQL 5) had the wrong time stored in it. So I changed the time in the database, and I didn't touch anything else.
When I pulled the blog back up, that blog entry had completely disappeared. It wouldn't show up on my blog, and it wasn't listed in the blog administrator under entries any more. I don't know what happened to it, it's still in the database, but BlogCFC can't see it any more. I even changed the time back, and it still won't show.
I guess I could go into the guts of BlogCFC and step through its queries to determine why it's not pulling that entry, but frankly it's not that big of a deal and I really don't have the time. I just thought it was strange that it happened and wondered if anyone else has ever seen this. I found this post in the BlogCFC forums that mentions it, but there doesn't seem to be a resolution posted.
BlogCFC won't display entries that have a future timestamp, so your blog entry will probably show up in a couple hours when that time difference has passed.
You will probably have to set the offset value to -5 to indicate that you are 5 hours behind the server time to avoid this problem in the future.
The real issue was that when I changed the "6" to an "11", the blog entry disappeared. Even when I changed it back to a "6", the entry won't show up. It's now been over 24 hours (according to the time stamp in the database) and the entry still doesn't show up.