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



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net