BP Blog

Here's an updated SQL script for use with SQL Server 2000.  The main changes were:

- varchar(max) to varchar (7000)
- removing some erroneous statements

I verified this works on a test database using SQL Server 2000.  I will include this in a new download of the entire software tonight.

It's in the latest release download in the Connections folder.

If you try and add a new entry and for some reason it doesn't show up in your entries list on the admin page - but it DOES show up on your recent entries sidebar (e.g., http://66.206.28.1/tommy/blog%5F5.0b/), then you may have to manually delete these erroneous entries.

First find out what the ID of your bad entry is.  You can do this by mousing over the link and seeing what's after "id=".  Then you go to your admin page and act like you're going to delete a regular entry that does show up.  On the delete confirmation page type in your erroneous id.

For example, if your erroneous title has an id of 3, go to the admin page and click "delete entry" for your latest post.  On the next page your URL should be something like http://blogurl.com/delete_blog.asp?passID=123 - delete the "123" in the address bar and type in your erroneous post id, in this case "3" so that the URL is now http://blogurl.com/delete_blog.asp?passID=3, then press enter (or Go).  You can now delete this entry and fix your sidebar.

I haven't figured out exactly why this happens but it has something to do with taking a particularly long posting time in the editor window when you're creating an entry.  Maybe it times out and the session variable is lost so the post doesn't have all of the information.  It still writes to the database, but erroneously without all of the required information.

I hope this helps.