| Author |
 Topic  |
|
DrisSelt_
Starting Member
15 Posts |
 Posted - 04 May 2002 : 01:57:59
|
I NEED HELP 
I installed Active Users 4 and get this error:
-----
Error Type:
Microsoft JET Database Engine (0x80040E37)
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_functions.asp, line 1451
--------
Line 1451 is:
set rs = my_conn.execute (strSql)
What's wrong???
(using IIS & snitz 3.3.03)
|
 |
|
|
Nathan
Help Moderator
USA
7664 Posts |
Posted - 04 May 2002 : 02:06:11
|
You didn't update the database as instructed in the readme file.
Now you need to open up inc_top.asp and remove the line "call activeuserstracker()" then go back and do that "Update Database" section from the readme, then put the "call activeuserstracker()" back in.
 Nathan Bales
Snitz Exchange | Do's and Dont's |
|
|
|
DrisSelt_
Starting Member
15 Posts |
Posted - 04 May 2002 : 02:42:26
|
You are right... Thanks for your help.
|
|
|
|
Nathan
Help Moderator
USA
7664 Posts |
|
|
funinbc
Junior Member
245 Posts |
Posted - 04 May 2002 : 13:00:02
|
HHHHHHHHhhhhhhhhhhhhheeeeeeeeeeeeeeellllllllllllppp :-o
Just when I was all proud of myself for following the instructions and getting ready to admire the new update I get this
Microsoft VBScript compilation error '800a0401'
Expected end of statement
/forum/config.asp, line 89
dim strAURecord, strAURecordDate, strAUAnon, strAUAnonOverride, strAUPAllow, strAUPCollapse dim
What have I done wrong?
|
|
|
|
Nathan
Help Moderator
USA
7664 Posts |
Posted - 04 May 2002 : 16:30:23
|
Looks like on line 89 of config.asp you need a line return (enter) where I have put in the red mark.
dim strAURecord, strAURecordDate, strAUAnon, strAUAnonOverride, strAUPAllow, strAUPCollapse heredim
Nathan Bales
Snitz Exchange | Do's and Dont's |
|
|
|
Um
Junior Member
222 Posts |
Posted - 04 May 2002 : 16:52:27
|
Hope that somebody is here to help me...
I just upload files to my forum, so I try to enter the admin_home-asp from the browser(like is in the readme.txt file)
and it wrote this error:
Microsoft VBScript runtime error '800a000d'
Type mismatch: 'chkAUPermissions'
/pf_rad/inc_activeusers.asp, line 39
I can't enter enywhere now...
|
|
|
|
Nathan
Help Moderator
USA
7664 Posts |
Posted - 04 May 2002 : 16:56:13
|
Sounds like you forgot to make the changes to inc_functions.asp, or at liest didn't select the whole block.
Nathan Bales
Snitz Exchange | Do's and Dont's |
|
|
|
Um
Junior Member
222 Posts |
Posted - 04 May 2002 : 17:29:07
|
What an idiot I am!!! I didn't upload it...
Sorry to disturb you... works... for now... 
|
|
|
|
Nathan
Help Moderator
USA
7664 Posts |
Posted - 04 May 2002 : 17:39:25
|
No Problem
Could further issues with this mod please be addressed in a new topic?
If a local mod sees this, could this topic be locked. . . its getting too long.
Nathan Bales
Snitz Exchange | Do's and Dont's |
|
|
|
Um
Junior Member
222 Posts |
Posted - 04 May 2002 : 18:06:29
|
quote:
Donload this version of active_users.asp and upload it over your current file, let me know if you have any problems with it.
http://66.189.200.59/au4.zip
Nathan Bales
Snitz Exchange | Do's and Dont's
I did that, but error is stil there:
Microsoft VBScript runtime error '800a000d'
Type mismatch: 'arrAM(...)'
/pf/inc_activeusers.asp, line 65
what do I have to do?
|
|
|
|
Ra1ney
Junior Member
United Kingdom
113 Posts |
Posted - 04 May 2002 : 20:54:57
|
I know you said to stop posting to this thread Nathan (and ur right), but I just wanted to say a couple-o-things .
Note for newbies...
I had the 'inc_activeusers.asp, line 65 ' error (plus others) and am all okay now  . Nathan & Crash were right way back in this topic (and most others), that my errors were mostly down to mistakes on my part. I literally spent hours checking all the bits of code I'd edited, as per instructions and everything was perfect. It was only when I decided to check back over every mod I'd installed to make sure there weren't any other errors, that I discovered some - which obviously weren't helping the current problem. I have since started the whole thing again and am getting much better results with my mods - less errors! If any of you who are still having problems are newbies like me, I suggest starting over if you can. It doesn't sound practical, but it worked for me and has saved me a lot of time in the long run. Now I'm less freaked by the code, re-doing the mods was a lot easier. I have been even more careful and tried to make sense of what's going on in and around the code I'm changing. Some of it even makes sense The more mods you add, the more difficult it gets to follow the instructions, so it's important to stay calm, be careful and remember what else you have edited on the page - also keeping code variations in the same order helps (don't know if it's neccessary?), ie if it appears in one order on one page, so should it on the others - it makes it easier to adapt the instructions.
Give it a try, you might be surprised  That's all, I hope this helps 
Last but not least - To Nathan/Crash, all the Snitz guys and all you other 'helpers', thanks heaps for all your effort, you're doing a great job!! Thank you!
p.s Sorry Nathan/Crash - couldn't sort out hosting
|
|
|
|
funinbc
Junior Member
245 Posts |
Posted - 04 May 2002 : 22:20:07
|
Microsoft VBScript compilation error '800a0401'
Help I have realy messed this up. This is the error I get . Can you help?
Expected end of statement
/forum/config.asp, line 303
intAURecord = cint(Application(strCookieURL & "INTAURECORD")) strAURecordDate =
end of error
this is the leine that it is talkin about
strModeration = Application(strCookieURL & "STRMODERATION")
strSubscription = Application(strCookieURL & "STRSUBSCRIPTION")
intAURecord = cint(Application(strCookieURL & "INTAURECORD")) line 303 starts here .... strAURecordDate =
Application(strCookieURL & "STRAURECORDDATE") strAUAnon = Application(strCookieURL &
"STRAUANON") strAUAnonOverride = Application(strCookieURL & "STRAUANONOVERRIDE") strAUPAllow =
Application(strCookieURL & "STRAUPALLOW") strAUPCollapse = Application(strCookieURL &
"STRAUPCOLLAPSE") strAUAllow = Application(strCookieURL & "STRAUALLOW") strAURefresh =
Application(strCookieURL & "STRAUREFRESH") strAUIP = Application(strCookieURL & "STRAUIP") strAUUA =
Application(strCookieURL & "STRAUUA") strAULocal = Application(strCookieURL & "STRAULOCAL")
strAUTimeout = Application(strCookieURL & "STRAUTIMEOUT") strAUPIsland = Application(strCookieURL &
"STRAUPISLAND") strAUAdminColor = Application(strCookieURL & "STRAUADMINCOLOR") strAUModColor
= Application(strCookieURL & "STRAUMODCOLOR")
|
|
|
|
Nathan
Help Moderator
USA
7664 Posts |
Posted - 04 May 2002 : 23:26:53
|
That block of code needs to look like this in your file:
strModeration = Application(strCookieURL & "STRMODERATION")
strSubscription = Application(strCookieURL & "STRSUBSCRIPTION")
intAURecord = cint(Application(strCookieURL & "INTAURECORD"))
strAURecordDate = Application(strCookieURL & "STRAURECORDDATE")
strAUAnon = Application(strCookieURL & "STRAUANON")
strAUAnonOverride = Application(strCookieURL & "STRAUANONOVERRIDE")
strAUPAllow = Application(strCookieURL & "STRAUPALLOW")
strAUPCollapse = Application(strCookieURL & "STRAUPCOLLAPSE")
strAUAllow = Application(strCookieURL & "STRAUALLOW")
strAURefresh = Application(strCookieURL & "STRAUREFRESH")
strAUIP = Application(strCookieURL & "STRAUIP")
strAUUA = Application(strCookieURL & "STRAUUA")
strAULocal = Application(strCookieURL & "STRAULOCAL")
strAUTimeout = Application(strCookieURL & "STRAUTIMEOUT")
strAUPIsland = Application(strCookieURL & "STRAUPISLAND")
strAUAdminColor = Application(strCookieURL & "STRAUADMINCOLOR")
strAUModColor = Application(strCookieURL & "STRAUMODCOLOR")
Which which browser did you view the readme file?
Nathan Bales
Snitz Exchange | Do's and Dont's |
|
|
|
funinbc
Junior Member
245 Posts |
Posted - 04 May 2002 : 23:35:24
|
I used Home Site to do the mod. I will go make it look like that and let you know what happens. thanks for your very fast reply!!!!!!
|
|
|
|
Topic |
|
Topic Locked
