| Author |
 Topic Search  Topic Options
|
nickslat 
Newbie
Joined: 12 December 2004
Status: Offline
Points: 9
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: Surely someone can help...?
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.
|
 |
dj air
Senior Member
Joined: 05 April 2002
Location: United Kingdom
Status: Offline
Points: 3627
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
nickslat
Newbie
Joined: 12 December 2004
Status: Offline
Points: 9
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
dj air
Senior Member
Joined: 05 April 2002
Location: United Kingdom
Status: Offline
Points: 3627
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
nickslat
Newbie
Joined: 12 December 2004
Status: Offline
Points: 9
|
Post Options
Thanks(0)
Quote Reply
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.
----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.
Edited by dj air - 13 December 2004 at 6:40pm
|
|
dj air
Senior Member
Joined: 05 April 2002
Location: United Kingdom
Status: Offline
Points: 3627
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
nickslat
Newbie
Joined: 12 December 2004
Status: Offline
Points: 9
|
Post Options
Thanks(0)
Quote Reply
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?!
|
|
dj air
Senior Member
Joined: 05 April 2002
Location: United Kingdom
Status: Offline
Points: 3627
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
