Surely someone can help...?
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=12974
Printed Date: 11 April 2026 at 7:27pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Surely someone can help...?
Posted By: nickslat
Subject: Surely someone can help...?
Date Posted: 13 December 2004 at 5:31pm
Come on you clever people, especially you moderators who are the font of ALL knowledge  !!
My newly installed SQL forum will not let me into the admin to get the thing set up and going. Everything went fine, SQL database setup, SQL query string correct etc. etc. etc. but... when i log in as Administrator I can change my own personal profile, but when I click the "ADMIN" button, I get this:
error '80020009'
/forum/admin/common.asp, line 323 PLEASE can someone help. I can't beleive no one has a solution. |
Replies:
Posted By: dj air
Date Posted: 13 December 2004 at 5:57pm
|
have you got more details about the error message or is that it. also can you post whats on that line, it might be a connection error or something. also try re uploading the forum files as they may have become corrupt. |
Posted By: nickslat
Date Posted: 13 December 2004 at 6:13pm
|
First thing I did was to re-upload the files / pages just in case. the lines from admin/common.asp read as follows (Line 323 down to line 336)
If Cbool(rsCommon("L_Code")) = true and Session("blnLicense") = false Then
'Clean up rsCommon.Close Set rsCommon = Nothing adoCon.Close Set adoCon = Nothing 'Redirect Response.Redirect "webwizforums_license.asp" End If 'Clean up
rsCommon.Close I haven't made modifications or anything to the script, just unzipped it, uploaded it and away I went. If I go direct to the page "webwizforums_license.asp" and click accept, it gives me the exact same error message.
Can't figure it out.
|
Posted By: dj air
Date Posted: 13 December 2004 at 6:27pm
|
looking on MS it seems to be talking about connection settings, make sure your settings are correct in the sql_server_connection.asp and the admin/common.asp file. making sure you are trying to coinnect to the sql server. is weird. |
Posted By: nickslat
Date Posted: 13 December 2004 at 6:34pm
|
By all means, try it for yourself...
Like I said, the connection string is corect otherwise it would
not let me change the profile settings for the one user i have ie me as
admin.
http://www.longreachevents.co.uk/new/forum/default.asp - http://www.longreachevents.co.uk/new/forum/default.asp
----edit ----
username and password deleted  ---- /edit--- i have a "test" user in there too and i have literally JUST changed the Administrator pwd back to letmein for your use so I know the connection string to the SQL server is perfect. |
Posted By: dj air
Date Posted: 13 December 2004 at 6:42pm
|
have you tried downloading the files again from WWG. also try creating a complete new version , starting from scratch. if that doesn't help im out of ideas. i think there was the same problem posted on the forums somewhere... within the past few days. |
Posted By: nickslat
Date Posted: 13 December 2004 at 6:45pm
|
It was probably me who posted the problem before. I tried yesterday but go absolutely no replies so tried again in the hope someone would know what to do.
I think Bruce must be able to help surely?!
|
Posted By: dj air
Date Posted: 13 December 2004 at 6:47pm
|
its weird as it should be working.. if you haven't done anything. i just did a search yes it was you yesturday i had seen, ive deleted that topic as all comments in the other are in this one. |