| Author |
 Topic Search  Topic Options
|
dr_who 
Newbie
Joined: 26 July 2006
Location: Denmark
Status: Offline
Points: 26
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: register.asp
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
|
 |
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 August 2006 at 9:20am |
|
Could be a corrupted file, first try reuploading the file again.
|
|
|
|
dr_who
Newbie
Joined: 26 July 2006
Location: Denmark
Status: Offline
Points: 26
|
Post Options
Thanks(0)
Quote Reply
Posted: 12 August 2006 at 9:21am |
|
hav try... no go... sry
|
|
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 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.
Edited by -boRg- - 12 August 2006 at 9:43am
|
|
|
|
dr_who
Newbie
Joined: 26 July 2006
Location: Denmark
Status: Offline
Points: 26
|
Post Options
Thanks(0)
Quote Reply
Posted: 12 August 2006 at 10:14am |
thx....i had some one look a my base... no errors...
myODBC it is 3.51...
|
|
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 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.
|
|
|
|
dr_who
Newbie
Joined: 26 July 2006
Location: Denmark
Status: Offline
Points: 26
|
Post Options
Thanks(0)
Quote Reply
Posted: 12 August 2006 at 6:25pm |
no go with myODBC 3.51m try reinstalling it...
|
|
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 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.
|
|
|
|
