I have a forum running on beta 3 (I know I wasn't supposed to do that, but when I realized it I already had too many topics and posts and stuff and it hadn't given me any problems). I want to change to beta 4, though. I talked to somone on their forum (who did exactly what I'm trying to do) and they said it's fairly easy, and told me to look in the history file and do all the changes in the access database. Since I am extremely familiar with Access (but not so in ASP) I decided that I would try to make my current database exactly the same as the beta 4 database by using the history file. I created the new tables and fields but it didn't work. So, I tried opening my beta 4 database (just how it was downloaded - pretty much empty) and made append queries to bring in my data into it. After some difficulties (like with primary keys) I finally got in all my data in. I opened the Forums and it looked fine until I tried to open a specific forum and it gave me a weird error (I think it had to do with a variable). Since I knew the code was right I went back to the database. This time I opened both my database that had all my data in what I thought was beta 4 structure and the original beta 4 database. I went through all the tables in design view and made the appropriate changes to make sure that the database structures were exactly the same. I put it back into testing and again it seemed fine until I tried to open a forum. This time it gave me a new error:
Microsoft VBScript runtime error '800a005e'
Invalid use of Null: 'CInt'
/TestForum/forum_topics.asp, line 377
Can anyone help me?
(Sorry the topic is so long, but I typed out everything just in case anyone needed the information to help out)