| Author |
 Topic Search  Topic Options
|
cagataybalta 
Newbie
Joined: 31 May 2006
Status: Offline
Points: 1
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: register.asp error
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
|
 |
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
leiti
Groupie
Joined: 16 February 2005
Status: Offline
Points: 65
|
Post Options
Thanks(0)
Quote Reply
Posted: 02 June 2006 at 6:35am |
The problem is the command
.Requery
for Access. Comment this line out and it will work!
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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.
Edited by -boRg- - 02 June 2006 at 9:07am
|
|
|
|
SPman
Newbie
Joined: 12 June 2006
Status: Offline
Points: 5
|
Post Options
Thanks(0)
Quote Reply
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?
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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.
Edited by -boRg- - 12 June 2006 at 11:58am
|
|
|
|
SPman
Newbie
Joined: 12 June 2006
Status: Offline
Points: 5
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
