Print Page | Close Window

register.asp

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=21002
Printed Date: 07 April 2026 at 11:22pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: register.asp
Posted By: dr_who
Subject: register.asp
Date Posted: 12 August 2006 at 8:59am
i am geting this error on register.asp :
 
error '80020009'

Exception occurred.

/register.asp, line 600

the line looks like this :

intForumStartingGroup = CInt(rsCommon("Group_ID"))

i am useing mysql 4.1.20



Replies:
Posted By: WebWiz-Bruce
Date Posted: 12 August 2006 at 9:20am
Could be a corrupted file, first try reuploading the file again.

-------------
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: dr_who
Date Posted: 12 August 2006 at 9:21am
hav  try... no go... sry


Posted By: WebWiz-Bruce
Date Posted: 12 August 2006 at 9:39am
There is no reason in the code why this error should occur at this point as it is a database error and the SQL query being run at this part of the code is only a simple, basic SQL query to get the starting group ID from the database on the tblGroup table.

As this is a database error, the problem is either in your database drivers on the server or some type of issue with mySQL or the actual database itself.

If you have access to the server I would first try updating the myODBC database driver and see if that resolves the issue.

If you still have the problem check that the database is OK, the mySQL site may also give you more help on why you get this error.


-------------
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: dr_who
Date Posted: 12 August 2006 at 10:14am
thx....i had some one look a my base... no errors...
 
myODBC it is 3.51...


Posted By: WebWiz-Bruce
Date Posted: 12 August 2006 at 12:15pm
There are different versions of the myODBC 3.51 driver, try installing, or reinstalling the latest 3.51 driver.

If that fails, then as I recall the database is a conversion from an MS Access database you had, so it could be some issue that happened when you did the conversion.

The problem is there is nothing wrong within the code in web wiz forums as it is a simple database query, which should not course this error, so it looks like the issue is a bug within mySQL or the myODBC Driver which means that trying to resolve the issue is beyond any support that I can give and you maybe better off trying the mySQL web site for help on this.

A clean install using the mySQL setup tool within web wiz forums to create the database should not course issues like 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


Posted By: dr_who
Date Posted: 12 August 2006 at 6:25pm

no go with myODBC 3.51m try reinstalling it...



Posted By: WebWiz-Bruce
Date Posted: 12 August 2006 at 8:05pm
I would try searching Google and see what you can find as there is no reason why you would get this error, so it must be some bug in mySQL or myODBC. Maybe upgrading your version of mySQL will correct the issue.

-------------
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: dr_who
Date Posted: 13 August 2006 at 12:12pm
hi...
 
what group are register.asp useing... Guest or Newbie ???


Posted By: WebWiz-Bruce
Date Posted: 13 August 2006 at 3:22pm
If you want to remove the SQL query altogether than you need to look in the database for the Group_ID that you have set to be the group new regsitered users are in.

Then remove the SQL query at line 600 of register.asp and chnage thhe line below to:-

intForumStartingGroup = Group ID Number

Change the part in red to the ID number of the group you want new members to be part in.


-------------
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: 13 August 2006 at 3:23pm
Sorry forgot to mention, new members are usually in the Newbie group, Group ID 4 so you would have:-

intForumStartingGroup = 4


-------------
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: tropenland
Date Posted: 07 October 2006 at 5:38pm
Had the same problem, think the problem is found here:

Opened database_connection.asp, line 216 and changed

strDBTrue = -1

to

strDBTrue = 1

This fixes a lot of other problems as well e.g. http://forums.webwiz.net/forum_posts.asp?TID=20536&KW= - http://forums.webwiz.net/forum_posts.asp?TID=20536&KW=;
, or that there are no active_topics displayed

BUT new entries by the MySQl Database are -1 and not 1 (access). So new problems come up.

Maybe the best solution is to set all values (1) in the database to (-1)

Tropenland


Posted By: greytricky
Date Posted: 17 January 2007 at 1:22pm
Thanks tropenland
 
Ive just got my sql8 running finally and my active topics were not displaying until I made that small edit
 
Is this now safe?, other parts of the forum should'nt suffer no ??
Smile


Posted By: tropenland
Date Posted: 04 February 2007 at 3:41pm
hi!

I'm running WWF for 4 months on MySQL and it works great. I made a few adaptions so that it fits better to my needs.


Posted By: Hydrogen
Date Posted: 22 March 2007 at 1:53pm
I had this problem after upgrading from 7.5 to 8.0 then converting to MySQL...
 
I solved it by changing the new user group via the admin section, then changing it back to "Newbie"! - I can only imagine there was a strange entry in the DB...
 
I still have the active topics problem though... it doesnt work Cry
 
and I dont have : strDBTrue = 1
 
I have: strDBTrue = "true"


-------------
Signature?



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