| Author |
 Topic  |
|
|
bluu
Starting Member
10 Posts |
 Posted - 19 July 2002 : 15:06:36
|
http://usm.virtualed.org *MISSION CRITICAL*
SQLserver 7
new problem
Snitz forum version 3.3.05
have not installed any MODS prior to this one
using t1 connexion
When installing Active Users Mod, received these errors after updating Active Users 4.0 for Snitz 3.3.03 compatable dbs.
Active Users 4.0 for Snitz 3.3.03 compatable
Dropping Table..
Table does not exist
--------------------------------------------------------------------------------
Dropping Table..
Table dropped succesfully
--------------------------------------------------------------------------------
Creating table(s)...
CREATE TABLE FORUM_ACTIVE_USERS( MEMBER_ID int NULL , AU_IP nvarchar(40) NULL , AU_LOGINTIME nvarchar(100) NULL , AU_LASTACTIVETIME nvarchar(100) NULL , AU_LASTPAGE nvarchar(250) NULL , AU_QUERYSTRING text NULL , AU_USER_AGENT text NULL )
Table created succesfully
--------------------------------------------------------------------------------
Adding Column M_AUHIDE...
ALTER TABLE FORUM_MEMBERS ADD M_AUHIDE nvarchar(1) NULL
ALTER TABLE FORUM_MEMBERS ADD M_AUHIDE nvarchar(1) NULL
-2147217900 | Column names in each table must be unique. Column name 'M_AUHIDE' in table 'FORUM_MEMBERS' is specified more than once.
Adding Column M_AUHIDE...
ALTER TABLE FORUM_MEMBERS ALTER COLUMN M_AUHIDE nvarchar(1) NULL
Column altered successfully
--------------------------------------------------------------------------------
Adding new records..
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRAUANON','1')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRAUANONOVERRIDE','2')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRAUPALLOW','4')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRAUPCOLLAPSE','1')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRAUALLOW','3')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRAUREFRESH','0')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRAUIP','1')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRAUUA','2')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRAULOCAL','3')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRAUTIMEOUT','7')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRAUADMINCOLOR','orangered')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRAUMODCOLOR','forestgreen')
Value(s) updated succesfully
--------------------------------------------------------------------------------
The dbs file was succesfully deleted.
I then edited these files as instructed
admin_home.asp
config.asp
default.asp
inc_functions.asp
inc_profile.asp
inc_top.asp
pop_config_help.asp
pop_profile.asp
register.asp
after backing them up. I edited them in the exact order and fashion as I was instructed in the readme provided. I then uploaded the new/edited files to my server.
And my forum does not load. I get the "Page cannot be displayed" error.
What did I do wrong? I am a newbie...but I learn fast...
|
|
|
Darthsteven
Starting Member
United Kingdom
38 Posts |
Posted - 19 July 2002 : 15:25:50
|
if your using ie, you should disable simple http error messages, Tools->Internet Options->Advanced(Tab)->Untick "show friendly HTTP error messages"
Regards
Darthsteven |
 |
|
|
bluu
Starting Member
10 Posts |
Posted - 19 July 2002 : 15:35:11
|
ok...so now this is the error i get
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
/inc_top.asp, line 75
but since i am a newbie, i dont know how to fix this :Þ
|
|
|
|
bluu
Starting Member
10 Posts |
Posted - 19 July 2002 : 15:43:06
|
this is what line 74,75 are...they are the same as the lines in my working inc_top.asp
set my_Conn = Server.CreateObject("ADODB.Connection")
my_Conn.Open strConnString
|
|
|
|
bluu
Starting Member
10 Posts |
|
|
Dan Martin
Average Member
USA
528 Posts |
Posted - 19 July 2002 : 15:53:08
|
I hope that's not your real SQL Server username and password. If it is, I'd suggest putting a few ***** in that file.
|
|
|
|
bluu
Starting Member
10 Posts |
Posted - 19 July 2002 : 15:58:45
|
thanx...dan
|
|
|
|
bluu
Starting Member
10 Posts |
Posted - 19 July 2002 : 16:09:32
|
i went back to my config file and uncommented the driver for sql server 7 [i'm not sure if I was supposed to do this] but it still doesn't work!
??!
|
|
|
|
bluu
Starting Member
10 Posts |
Posted - 19 July 2002 : 16:22:10
|
ok...I fixed the config file...I dont have the error anymore
|
|
|
|
Nathan
Help Moderator
USA
7664 Posts |
Posted - 19 July 2002 : 19:00:08
|
from the error list, it looks like the dbs file ran absolutely flawlessly. 
 Nathan Bales
Snitz Exchange | Do's and Dont's |
|
|
| |
Topic |
|
Topic Locked
