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 ??
 |
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
 and I dont have : strDBTrue = 1
I have: strDBTrue = "true" ------------- Signature? |