Web Wiz Forums - register.asp error

Print Page | Close Window

register.asp error

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=20124
Printed Date: 28 March 2026 at 3:40am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: register.asp error

Posted By: cagataybalta
Subject: register.asp error
Date Posted: 31 May 2006 at 8:12am

version 8.0 RC1.1
register.asp

error occured while adding new member

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

adds the member but error occures

Replies:

Posted By: WebWiz-Bruce
Date Posted: 31 May 2006 at 3:40pm

First try re-uploading the files again, in case you have a corrupted file.

If the problem persists Turn off friendly HTTP errors in IE and give the full error so that we can findout what the course of this problem is.

-------------
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: leiti
Date Posted: 02 June 2006 at 6:35am

The problem is the command

.Requery

for Access. Comment this line out and it will work!

Posted By: WebWiz-Bruce
Date Posted: 02 June 2006 at 9:07am

The requery line is required for the register.asp page to work.

The database nees to be requeried to get the database generated ID number for the newly created member.

-------------
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: SPman
Date Posted: 12 June 2006 at 10:49am

I use v8.02 the release from 26th May for Access, and I am also getting the exact same error message.

When registering it gives this error although the user gets an email to confirm registration.

Once refreshing the page however, everything seems to be fine.

Still highly annoying, anyone have a fix for this?

Posted By: WebWiz-Bruce
Date Posted: 12 June 2006 at 11:57am

No one yet has given the 'error message', let alone the 'exact same error message'

Could you please supply the exact error message so it can be investigated?

An error has occurred on a line doesn't really say why the error has occurred without a detailed server error message.

You may need to disable Friendly HTTP error messages in IE so you get the detailed server error message.

-------------
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: SPman
Date Posted: 12 June 2006 at 1:39pm

Hi there

On two servers my locahost, and a companies hosted server, I get the same error.

________________________________

error '80020009'

Exception occurred.

/register.asp, line 978

____________________________

978 of course giving the line: -

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

Hope this helps.

Posted By: WebWiz-Bruce
Date Posted: 12 June 2006 at 2:53pm

This is very odd as it is only using a Requery command to requery the database to get the new users ID number, without it activation emails, etc. will not work. This has been done in this way for around 4 years now.

All the test servers seem to run this code fine as well as most Access users, so this seems to be a very isolated small number of users have this issue.

This then looks like it could be server related, and more than likely some strange bug in the MDAC database drivers.

Try downloading and re-installing the latest MDAC drivers from www.microsoft.com/data and see if that clears up the problem.

Better still if you have access to the server install the free SQL Server 2005 Express and use the SQL server version, you will get much better performance and won't get all the issues that are inherent with Access databases.

-------------
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: SPman
Date Posted: 13 June 2006 at 9:24am

Hmm... This is very strange though.

I am running IIS 5.0 on an XP machine (localhost) for testing. Also my external hosting company runs IIS 4 Windows 2000 and both give the same error.

If it was just the one server I may be inclined to agree that it is limited to a small number of people.

Also I installed MDAC 2.8 on my localhost, rebooted, retested a registration and the same error still occurs.

However, I just tried installing the original database from this site, and now the error isnt occuring.

Either the database is corrupted or perhaps the referigal integrity isnt what it should be. As far as getting a clean database for v8.02. how do I go about doing this?

Cheers

Posted By: WebWiz-Bruce
Date Posted: 13 June 2006 at 11:56am

Now were getting somewhere, I couldn't understand why this error should suddenly come about after using the same method on that file for 4 or 5 years.

It sounds like the database may have become corrupted, and this is why you are getting this error.

Access is a desktop file and not really up to being the backend for a forum, unless you only expect a handful of users. Because of this database corruption with Access databases is common, and although I do try a persuade people to use mySQL or SQL Server, people for some reason still like to use Access because of it's simplicity.

What you will need to do is download your Access database, open it in Access, and then select 'Compact and repair database' from the tools menu. This should fix the issue with your database.

-------------
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: SPman
Date Posted: 13 June 2006 at 12:53pm

I tried compact and repair didnt seem to fix the problem.

Although I am starting from fresh with only one message posted so far so its no big problem for me to start again from scratch with the database from the download section of the site.

It may be that for some unknown reason the latest database issued for v 8.02 corrupts a little easier, hence why there is a couple of people with the same problem. I admittedly messed around with the members to delete them from the database using the access user interface, and may have corrupted it in doing so.

Posted By: WebWiz-Bruce
Date Posted: 13 June 2006 at 1:23pm

It could be that you downloaded the first Access version of 8.02.

Till the start of the month files had to be transferred from place to place and PC to PC, this coursed all sorts of problems including incorrect files getting into download zip files.

This meant that the original Access 8.02 version somehow got a test Access database in the zip file which was full or crap that shouldn't be there. Although I hadn't realised this would course any problems apart from having to delete some data from the database.

I have since updated the zip file with a clean fresh Access database in the form it should be.

I have also now setup a Small Business Server 2003 so that all files are centrally located which will prevent having to move files around from PC to PC, which should prevent problems like this happening again, and will also hopefully speed up work flow, due to amount of times disks etc. have been lost, over written, etc. and work being lost.

With a clean database you should have 2 members in the tblAuthor table, the 'Administrator' and the 'Guest' accounts, if either of these 2 built in accounts are deleted it can course errors. It maybe you accidentally deleted or altered one of these built in accounts coursing the problems you experienced.

-------------
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: SPman
Date Posted: 13 June 2006 at 2:00pm

Thanks for this, I may well have.

Hopefully this thread will have cleared things up for a few people though.

No probs now.