| Author |
 Topic Search  Topic Options
|
giangi 
Newbie
Joined: 07 April 2006
Location: Italy
Status: Offline
Points: 11
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: unexpected problem
Posted: 27 June 2006 at 7:52pm |
hi all
from 3 days, i had a registration problem!
---
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
Edited by giangi - 27 June 2006 at 7:53pm
|
 |
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
giangi
Newbie
Joined: 07 April 2006
Location: Italy
Status: Offline
Points: 11
|
Post Options
Thanks(0)
Quote Reply
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
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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?
|
|
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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"))
|
|
|
|
miladanimator
Groupie
Joined: 24 July 2005
Location: United States
Status: Offline
Points: 156
|
Post Options
Thanks(0)
Quote Reply
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 ...
|
|
miladanimator
Groupie
Joined: 24 July 2005
Location: United States
Status: Offline
Points: 156
|
Post Options
Thanks(0)
Quote Reply
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
|
|
