| Author |
 Topic  |
|
stwilson
Junior Member
USA
385 Posts |
 Posted - 02 January 2002 : 01:33:25
|
Nathan,
I am getting the following upon install:
Microsoft JET Database Engine error '80040e10'
No value given for one or more required parameters.
/active_users.asp, line 140
Any thoughts? Thanks, in advance for your reply.
Shannon
|
 |
|
|
Nathan
Help Moderator
USA
7664 Posts |
Posted - 02 January 2002 : 01:46:34
|
Save the following code as dbs_whatever.asp
Then run it form Admin-Options > Mod Setup
Active Users 3.5 FIX
[ALTER]
MEMBERS
DROP#M_AUHIDE###
ADD#M_AUHIDE#int#NULL#1
[END]
BTW: Did you just download that tonight??? I thought I had that problem fixed in the zip file.
Nathan Bales - Romans 15:13
---------------------------------
Snitz Exchange | Mod Resource |
|
|
|
stwilson
Junior Member
USA
385 Posts |
Posted - 02 January 2002 : 01:50:38
|
quote:
BTW: Did you just download that tonight??? I thought I had that problem fixed in the zip file.
YES. I did. Thanks for the quick reply.
Shannon
|
|
|
|
stwilson
Junior Member
USA
385 Posts |
Posted - 02 January 2002 : 01:53:38
|
Nate,
That fixed it. THANKS!!!! Excellent MOD.
Shannon
|
|
|
|
Nathan
Help Moderator
USA
7664 Posts |
Posted - 02 January 2002 : 02:15:09
|
Wait a second. . . that fixed it? I just realized thats not even the code I ment to post! 
Oh well, if it fixed it then it fixed it I guess!
Nathan Bales - Romans 15:13
---------------------------------
Snitz Exchange | Mod Resource
Edited by - Nathan on 02 January 2002 02:31:52 |
|
|
|
Zeb
Starting Member
Italy
41 Posts |
Posted - 02 January 2002 : 09:18:52
|
I also got this error:
Microsoft VBScript runtime error '800a000d'
Type mismatch: 'CInt'
/sdc/forum/active_users.asp, line 402
while a user was replying to a topic named: "Idee per il sito x l'esame" (http://www.sensibile.it/sdc/forum/topic.asp?TOPIC_ID=87)
category name:"Informatica - Il corso del Prof. Costa"
___
Zeb |
|
|
|
Nathan
Help Moderator
USA
7664 Posts |
Posted - 02 January 2002 : 14:14:02
|
That problem is in the URL de-encoder. If the problem presists then comment out lines 374 - 398
For some reason, it chokes up on some topic names.
Nathan Bales - Romans 15:13
---------------------------------
Snitz Exchange | Mod Resource |
|
|
|
arthurgrajeda
Starting Member
USA
3 Posts |
Posted - 02 January 2002 : 23:06:57
|
I am getting this error can anyone help
Microsoft OLE DB Provider for ODBC Drivers error '80040e37'
[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot find the input table or query 'FORUM_ONLINE'. Make sure it exists and that its name is spelled correctly.
/forum/inc_activeusers.asp, line 140
Thanks
http://www.s10planet.com
race hard. |
|
|
|
Nathan
Help Moderator
USA
7664 Posts |
Posted - 02 January 2002 : 23:23:07
|
Did the DBS file run without errors?
Nathan Bales - Romans 15:13
---------------------------------
Snitz Exchange | Mod Resource |
|
|
|
Nathan
Help Moderator
USA
7664 Posts |
Posted - 02 January 2002 : 23:29:33
|
Dude!!! I finally found out why only some of my DBS files work!!! 
Open up dbs_activeusers.asp
Make sure it looks like this (omit red text)
Active Users 3.5
make sure there is a blank line here
[CREATE]
ONLINE
make sure there is a blank line here
UserID#varchar(100)#NULL#
UserIP#varchar(40)#NULL#
DateCreated#varchar(100)#NULL#
LastDateChecked#varchar(100)#NULL#
CheckedIn#varchar(100)#NULL#
LastChecked#varchar(100)#NULL#
M_BROWSE#memo#NULL#
[END]
[ALTER]
ONLINE
ADD#SystemOS#varchar(150)#NULL#
ADD#BrowserTYPE#varchar(150)#NULL#
[END]
[ALTER]
MEMBERS
ADD#M_AUHIDE#int#NULL#1
[END]
Then run the file and if there are any errors let me know.
Nathan Bales - Romans 15:13
---------------------------------
Snitz Exchange | Mod Resource
Edited by - Nathan on 02 January 2002 23:29:51 |
|
|
|
Nathan
Help Moderator
USA
7664 Posts |
Posted - 02 January 2002 : 23:42:09
|
I updated the Zip file with a dbs file I know will work, the disadvantage is that any members already on your boards will default to anonymous on the active users. 
Nathan Bales - Romans 15:13
---------------------------------
Snitz Exchange | Mod Resource |
|
|
|
avs
New Member
USA
83 Posts |
Posted - 03 January 2002 : 01:40:07
|
Thanks for the explanation on the error Nathan, now that I know what the problem is I think I can live with it. It makes sense, some posters post topics that are either really long or that have symbols in them like @#$^% I can definitely see how that would choke up the code!
It's fine, other then this minor issue it's solid as a rock :)
|
|
|
|
arthurgrajeda
Starting Member
USA
3 Posts |
Posted - 03 January 2002 : 11:52:05
|
ok I think I really messed up my board now, I could not get the code to work so I simply reuploaded the forum to my server and still am getting errors, can someone please help, thanks. Do I have to do a complete reinstall?
http://www.s10planet.com
race hard. |
|
|
|
Nathan
Help Moderator
USA
7664 Posts |
Posted - 03 January 2002 : 16:01:18
|
Looks like when you uploaded the old files you didn't get the strConnString and strDBType set
Nathan Bales - Romans 15:13
---------------------------------
Snitz Exchange | Mod Resource |
|
|
|
GhettoDalaiLama
Junior Member
212 Posts |
Posted - 04 January 2002 : 05:53:32
|
ADODB.Recordset error '800a0cb3'
Object or provider is not capable of performing requested operation.
/active_users.asp, line 153
__________________________________________________________________
The active users panel on default.asp displays fine, but when I click on the hyperlink to go to active_users.asp, I get that error message and nothing is displayed.
OS: Win2000 Adv Server SP2
Webserver: IIS 5.0
Snitz: 3.3.03
MySQL: 3.23.40
ODBC Driver: MySQL v.2.50.37.00 - 20.Apr.01
Any ideas?
Thanks
Edited by - GhettoDalaiLama on 04 January 2002 05:54:21 |
|
|
|
Topic |
|
Topic Locked
