| Author |
 Topic  |
|
|
revenger
Junior Member
United Kingdom
132 Posts |
 Posted - 08 August 2004 : 17:17:31
|
I've got this problem with Active users - I installed the mod exactly as the instructions said. When I visit my forum - I get this:
Microsoft JET Database Engine error '80040e37'
The Microsoft Jet database engine cannot find the input table or query 'FORUM_ACTIVE_USERS'. Make sure it exists and that its name is spelled correctly.
/forum/inc_func_common.asp, line 199
Could someone please tell me how to fix this? |
|
|
Jezmeister
Senior Member
United Kingdom
1141 Posts |
Posted - 08 August 2004 : 17:29:10
|
| are you sure you made the changes to the database? |
 |
|
|
revenger
Junior Member
United Kingdom
132 Posts |
Posted - 08 August 2004 : 17:40:21
|
Well when I view it I get this:
Active Users 4.0 for Snitz 3.4 compatable [DROP] ONLINE [END] [DROP] ACTIVE_USERS [END] [CREATE] ACTIVE_USERS MEMBER_ID#int#NULL# AU_IP#varchar(40)#NULL# AU_LOGINTIME#varchar(100)#NULL# AU_LASTACTIVETIME#varchar(100)#NULL# AU_LASTPAGE#varchar(250)#NULL# AU_QUERYSTRING#text#NULL# AU_USER_AGENT#text#NULL# [END] [ALTER] MEMBERS ADD#M_AUHIDE#varchar(1)#NULL# ALTER#M_AUHIDE#varchar(1)#NULL# [END] [ALTER] MEMBERS_PENDING ADD#M_AUHIDE#varchar(1)#NULL# [END] [INSERT] CONFIG_NEW (C_VARIABLE,C_VALUE)#('STRAUANON','1') (C_VARIABLE,C_VALUE)#('STRAUANONOVERRIDE','2') (C_VARIABLE,C_VALUE)#('STRAUPALLOW','4') (C_VARIABLE,C_VALUE)#('STRAUPCOLLAPSE','1') (C_VARIABLE,C_VALUE)#('STRAUALLOW','3') (C_VARIABLE,C_VALUE)#('STRAUREFRESH','0') (C_VARIABLE,C_VALUE)#('STRAUIP','1') (C_VARIABLE,C_VALUE)#('STRAUUA','2') (C_VARIABLE,C_VALUE)#('STRAULOCAL','3') (C_VARIABLE,C_VALUE)#('STRAUTIMEOUT','7') (C_VARIABLE,C_VALUE)#('STRAUADMINCOLOR','orangered') (C_VARIABLE,C_VALUE)#('STRAUMODCOLOR','forestgreen') (C_VARIABLE,C_VALUE)#('STRAUADMINCOLOR','orangered') (C_VARIABLE,C_VALUE)#('STRAUMODCOLOR','forestgreen') (C_VARIABLE,C_VALUE)#('intAURecord','0') (C_VARIABLE,C_VALUE)#('strAURecordDate','11111111111111') [END]
Is that right? |
|
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 09 August 2004 : 08:40:11
|
Did you type the address of the dbs file into your browser manually or did you try running through Mod Setup in your admin options?
|
 Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.” |
|
|
|
revenger
Junior Member
United Kingdom
132 Posts |
Posted - 09 August 2004 : 10:54:52
|
| Manually. I can't get to Admin Options because I the above error when visiting any part of my forum.. |
|
|
|
masterao
Senior Member
Sweden
1678 Posts |
Posted - 09 August 2004 : 17:54:59
|
| Did you keep a backup of your files before adding the AU-mod? If so, upload the unmodified files again. That will let you access your website and the forum admin section again. Then run the DBS-file in Mod Setup. |
Jan
===========
FR Portal Forums | Active Users 4.0.20 Mod |
|
|
|
revenger
Junior Member
United Kingdom
132 Posts |
Posted - 10 August 2004 : 07:48:36
|
| OK I uploaded the un-modified files - and the dbs_activeusers.asp file - but when I go to admin options I just get a white box with nothing in it... |
|
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 10 August 2004 : 08:16:30
|
You mean an empty textrea or select box?
If it's an empty select box then use the alternative mod setup. Open up the dbs file in a text editor and copy everything in it and paste it into the textarea.
|
Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.” |
|
|
|
masterao
Senior Member
Sweden
1678 Posts |
Posted - 10 August 2004 : 14:33:13
|
| Shaggy's suggestion is one way you can do it. The other way is to upload dbs_activeusers.asp into your forum-folder (it doesn't seem to be at the moment). |
Jan
===========
FR Portal Forums | Active Users 4.0.20 Mod |
|
|
|
revenger
Junior Member
United Kingdom
132 Posts |
Posted - 12 August 2004 : 06:20:47
|
OK I have done that - now I get this when I submit it:
Active Users 4.0 for Snitz 3.3.03 compatable
Dropping Table..
DROP TABLE FORUM_ONLINE
Table does not exist
--------------------------------------------------------------------------------
Dropping Table..
DROP TABLE FORUM_ACTIVE_USERS
Table dropped succesfully
--------------------------------------------------------------------------------
Creating table(s)...
CREATE TABLE FORUM_ACTIVE_USERS( MEMBER_ID int NULL , AU_IP varchar(40) NULL , AU_LOGINTIME varchar(100) NULL , AU_LASTACTIVETIME varchar(100) NULL , AU_LASTPAGE varchar(250) NULL , AU_QUERYSTRING text NULL , AU_USER_AGENT text NULL )
Table created succesfully
--------------------------------------------------------------------------------
adding Column M_AUHIDE...
ALTER TABLE FORUM_MEMBERS ADD COLUMN M_AUHIDE varchar(1) NULL
Column already exists
altering Column M_AUHIDE...
ALTER TABLE FORUM_MEMBERS ALTER COLUMN M_AUHIDE varchar(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')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('intAURecord','0')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('strAURecordDate','11111111111111')
Value(s) updated succesfully
--------------------------------------------------------------------------------
Database setup finished
I go to the forum but it still doesent show... |
|
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 12 August 2004 : 06:58:50
|
Have you reuploaded the edited files?
|
Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.” |
|
|
|
revenger
Junior Member
United Kingdom
132 Posts |
Posted - 13 August 2004 : 04:53:00
|
Yes - but when I upload them I just get that error again:
Microsoft JET Database Engine error '80040e37'
The Microsoft Jet database engine cannot find the input table or query 'FORUM_ACTIVE_USERS'. Make sure it exists and that its name is spelled correctly.
/forum/inc_func_common.asp, line 199 |
|
|
| |
Topic |
|
Topic Locked
