Web Wiz Forums - Problem with upgrade from v6.25 to v7.97

Print Page | Close Window

Problem with upgrade from v6.25 to v7.97

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=18129
Printed Date: 12 April 2026 at 10:36pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Problem with upgrade from v6.25 to v7.97

Posted By: cfrey
Subject: Problem with upgrade from v6.25 to v7.97
Date Posted: 25 January 2006 at 5:55pm

Greetings! I've been using version 6.25 of WWF for several years now. As part of a move to a new server, I've decided to take the plunge and upgrade to v7.97. I have installed the new version on the server, grabbed the old Access database and put it in place on the new server, have renamed the strDbPathAndName in the 2 common.asp files to point to my existing Access database, and now I'm getting this error when I try to visit the default.asp page:

ADODB.Recordset error '800a0cc1'
Item cannot be found in the collection corresponding to the requested name or ordinal.
/Forum2/common.asp, line 291

What am I doing wrong?

Replies:

Posted By: WebWiz-Bruce
Date Posted: 25 January 2006 at 6:18pm

Blimey, 6.25, that's about 3 years out-of-date, your almost in time for the version 8 release this spring.

7.x versions uses a different database to 6.x versions.

You will need to download the Access 6.x to 7.x migration tool from the Web Wiz Forums download page and use this to migrate over your data.

For security reasons it is also worth making sure you are always running the latest stable release.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: cfrey
Date Posted: 25 January 2006 at 7:08pm

Thanks, boRg! I successfully updated and posted the database to my forum. I've now started to change permissions, etc. - no problem there. But when I post a new test message and click submit, I get this error:

Microsoft VBScript runtime error '800a005e'

Invalid use of Null: 'Replace'
/Forum2/functions/functions_send_mail.asp, line 73

What would be causing that to occur?

Posted By: WebWiz-Bruce
Date Posted: 26 January 2006 at 5:49pm

Try settings up email tools in the email configuration page in the admin area

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: cfrey
Date Posted: 27 January 2006 at 4:59am

I have set it up. I've been told by my hosting firm that my dedicated server has CDOSYS set up, so I configured it to support that. But no matter what I try, I keep getting this error. Is there something specific you can recommend that I try?

Posted By: WebWiz-Bruce
Date Posted: 27 January 2006 at 8:58am

Looking at the line of code in error it is coursed by the emails 'From' name not being passed to the function.

Make sure you have populated all fields in the forum configuration page, particularly fields for 'Forum Name', 'Forum Email Address', and 'Forum Path'

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: cfrey
Date Posted: 27 January 2006 at 3:58pm

OK, I'm no longer getting the error. Thanks! But now I'm not getting e-mail notification. I have everything set up in the e-mail admin menu. Apparently my mail server requires authentication. So, following the instructions elsewhere in this forum, I have attempted to edit the function_send_mail.asp file with my server values. Is this the proper syntax (sorry, but I'm not a programmer...):

strMailServerUser = "my e-mail address"
strMailServerPass = "my password"

That's how I have it set up, but as I said, it's not working (at least it's not erroring out any more!!)

Thanks!

Posted By: WebWiz-Bruce
Date Posted: 27 January 2006 at 6:09pm

The syntax looks OK, but the first one should be the username for the mail server rather than a password.

Check with your web hosts as to the correct settings.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: cfrey
Date Posted: 27 January 2006 at 6:30pm

My e-mail address IS my user name for e-mail with my web hosting firm.

Posted By: dove_g
Date Posted: 17 March 2006 at 2:56pm

And what do I need to upgrade from 7.7a to 7.97?
Just copy all code? And don't touch mdb?

Thanks.

Posted By: WebWiz-Bruce
Date Posted: 17 March 2006 at 3:43pm

That's right yes.