Web Wiz Forums - unexpected problem

Print Page | Close Window

unexpected problem

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=20458
Printed Date: 09 April 2026 at 2:40pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: unexpected problem

Posted By: giangi
Subject: unexpected problem
Date Posted: 27 June 2006 at 7:52pm

hi all

from 3 days, i had a registration problem!

when i try to register to http://80.68.192.86/registration_rules.asp?FID=0 - http://80.68.192.86/registration_rules.asp?FID=0 and i fill up the fields, and click to submit, appear this:

---

error '80020009'

/register.asp, line 976

----

However i check into database, and when the error occurred, user is insert in the database, but not enable, and email don't sent.

can you help me?

thnaks

Replies:

Posted By: WebWiz-Bruce
Date Posted: 28 June 2006 at 7:19am

This problem usually happens if the Access database has become corrupted.

To fix the issue you need to download the Access database, open it in MS Access, then choose 'Compact and repair database' from the tools menu.

This should fix the issue.

However, looking at your forum, you should use either the mySQL or SQL Server versions.

Access is a simple flat office file, NOT a database management system, and OK for small web sites, but on forums with more than a handful of users and posts it struggles to cope and often becomes corrupted, sometimes you can not fix the corruption and will loose all the data in the Access database.

You should look at using mySQL or SQL Server as soon as you can.

-------------
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: WebWiz-Bruce
Date Posted: 28 June 2006 at 7:20am

I also see you are using the free 'Adware' version of Web Wiz Forums, and you have removed the ads.

This breaks the terms of the license for running Web Wiz Forums, under which you can have your license revoked and you will have to remove Web Wiz Forums from your servers.

You need to either place the ads back into the software, or purchase an ad/link removal license key from the purchase section on this site.

-------------
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: giangi
Date Posted: 28 June 2006 at 11:29am

hi borg,

we wish buy a ad/link removal license version, it's not a problem!

but we have follow your workaround, and we had migrate to sql server, but the problem also accured.

unfortunately we don't have a good backup. how cna we solve the problem?

thanks

Posted By: WebWiz-Bruce
Date Posted: 29 June 2006 at 5:17pm

I few people have now reported this and it is a database error.

As it seems to effect so few users and as it is a database error I need to findout if you are using any strange setup on the server for your database or database connection.

Are you using the standard DSN-less database connection?
What version of the database driver are you using?
What operating system is the server running?

-------------
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: WebWiz-Bruce
Date Posted: 29 June 2006 at 5:46pm

Right been doing some research into this.

As I can not replicate the error I can not test this but try changing line 976 or the file register.asp from:-

lngUserProfileID = CLng(.Fields("Author_ID"))

To:-

If NOT isNull(.Fields("Author_ID")) Then lngUserProfileID = CLng(.Fields("Author_ID"))

-------------
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: miladanimator
Date Posted: 30 June 2006 at 7:54pm

I change
lngUserProfileID = CLng(.Fields("Author_ID"))

To:-

If NOT isNull(.Fields("Author_ID")) Then lngUserProfileID = CLng(.Fields("Author_ID"))

but the error was shown yet ...

-borg- ! first I install ms access version - then I migrate to mssql version 7.96 and all users can register with out any problem ...

and now I upgrade 2 version 8.03 and this error was occured ... but old users can update their profile ... post new PM and create new topic & ...

now! when any new user register , all user's data was added to tblAuthor and user can login to forum ... but after register.asp page , the error was shown ...

Posted By: miladanimator
Date Posted: 30 June 2006 at 8:46pm

can any one find a way to solve this problem ???

http://search.microsoft.com/results.aspx?mkt=en-US&setlang=en-US&q=80020009

Posted By: WebWiz-Bruce
Date Posted: 02 July 2006 at 2:10pm

The code mentioned only runs when a new users registers so will have nothing to do with sending PM's or editing profiles.

Could you please give more details as mentioned in my previous post so that this problem can be replicated and a solution found?

-------------
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: miladanimator
Date Posted: 03 July 2006 at 10:47am

Operating System	Windows 2003	Windows 2000
Windows Edition	Standard	Server
Service Pack	SP1	SP4
Antivirus	Symantec CE	Symantec CE
Firewall	WinRoute/IP Sec	WinRoute/IP Sec
Default charset for non-Unicode	English / Farsi	r
Services	Windows 2003	Windows 2000
Web Server	IIS 6.0	IIS 5.0
FTP Server	Serv-U 4	Serv-U 4
Mail Server	Imail 7.07	Imail 7.07
Web Mail	Imail / NS WebMail*	Imail / NS WebMail*
Management	Windows 2003	Windows 2000
Control Panel	Helm 3.2.9 ( http://helmdemo.webhostautomation.com/default.asp?selInterface=standard_XP&txtUsername=DEMOUSER&txtPassword=password - Demo )	Helm 3.2.9 ( http://helmdemo.webhostautomation.com/default.asp?selInterface=standard_XP&txtUsername=DEMOUSER&txtPassword=password - Demo )
Web Data Admin	b	r
phpMyAdmin	2.6	r
Web Based FTP	b	r
Databases

Posted By: miladanimator
Date Posted: 03 July 2006 at 1:20pm

this is our server datails ...

-borg- , is there a way to delete database , reinstall the database and import datas too the database ???

Posted By: WebWiz-Bruce
Date Posted: 03 July 2006 at 3:02pm

Those details don't explain a thing I'm afraid.

I was looking for more technical details such as MDAC installed etc. on the server.

As you are using a web host then you may need to take this error up with them as I don't know what strange settings they have done on their servers that is coursing this.

-------------
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