| Author |
 Topic  |
|
freddydoes
Junior Member
108 Posts |
 Posted - 27 December 2001 : 17:20:08
|
Microsoft JET Database Engine error '80040e10'
No value given for one or more required parameters.
/inc_active_users.asp, line 113
113: my_Conn.Execute SQL
where can I get that file that is helping everyone? the link is broken!
|
 |
|
|
Nathan
Help Moderator
USA
7664 Posts |
|
|
freddydoes
Junior Member
108 Posts |
Posted - 27 December 2001 : 17:34:27
|
yeah... you have to edit too many pages, i have tons of mods already so I can't overwrite anything, i need a quick fix for this
Edited by - freddydoes on 27 December 2001 17:35:44 |
|
|
|
freddydoes
Junior Member
108 Posts |
Posted - 27 December 2001 : 17:59:54
|
ok, well i uploaded all the files clean and untouched and I still get that error, what the heck, it's clean. If it becuase of the new db fields? I used richard's set file suggestion.
|
|
|
|
Nathan
Help Moderator
USA
7664 Posts |
Posted - 27 December 2001 : 18:01:03
|
Yeah, that error sounds like its a database error.
Nathan Bales - Romans 15:13
---------------------------------
Snitz Exchange | Mod Resource |
|
|
|
freddydoes
Junior Member
108 Posts |
Posted - 27 December 2001 : 18:05:15
|
oh ****, i don't remember what is orginally looked like
|
|
|
|
Nathan
Help Moderator
USA
7664 Posts |
|
|
freddydoes
Junior Member
108 Posts |
Posted - 27 December 2001 : 18:11:15
|
hmm... I get the same errors with those new files, i think maybe richard goofed and I messed up my tables?
when i finished my setup, this is what it looked like:
CREATE TABLE FORUM_ONLINE ( UserID varchar (100) , UserIP varchar (40) , DateCreated varchar (100) , LastDateChecked varchar (100) , CheckedIn varchar (100) , LastChecked varchar (100) , M_BROWSE memo , SystemOS varchar (100) , Visits varchar (100) , BrowserTYPE varchar (100) )
Database set-up finish!!
Edited by - freddydoes on 27 December 2001 18:21:36 |
|
|
|
Nathan
Help Moderator
USA
7664 Posts |
Posted - 27 December 2001 : 18:26:06
|
Visits??? Why is that in there?
The dbs file should look like this
Active Users 3.5
[CREATE]
ONLINE
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#
SYSTEMOS#varchar(100)#NULL#
BROWSERTYPE#varchar(100)#NULL#
[END]
If you need to get rid of that old table first use this
Drop Active Users Table
[DROP]
ONLINE
[END]
Nathan Bales - Romans 15:13
---------------------------------
Snitz Exchange | Mod Resource
Edited by - Nathan on 27 December 2001 18:26:28 |
|
|
|
freddydoes
Junior Member
108 Posts |
Posted - 27 December 2001 : 18:28:31
|
well, i should have the necessary db info right? by the looks of my last post? i am downloading my db to see what it really looks like.
Edited by - freddydoes on 27 December 2001 18:34:40 |
|
|
|
Nathan
Help Moderator
USA
7664 Posts |
Posted - 27 December 2001 : 18:31:30
|
The files in the zip I gave you above dont use visits, they will cause a problem.
Nathan Bales - Romans 15:13
---------------------------------
Snitz Exchange | Mod Resource |
|
|
|
freddydoes
Junior Member
108 Posts |
Posted - 27 December 2001 : 18:36:28
|
do you know how I can delete my visits field using sql? where I can just run an asp file to delete it?
|
|
|
|
Nathan
Help Moderator
USA
7664 Posts |
Posted - 27 December 2001 : 18:45:24
|
Do you know how to run a dbs file?
This is the dbs file you need to run to get rid of that visits field:
Remove Visits Field
[ALTER]
ONLINE
DROP#VISITS###
[END]
Nathan Bales - Romans 15:13
---------------------------------
Snitz Exchange | Mod Resource |
|
|
|
freddydoes
Junior Member
108 Posts |
Posted - 27 December 2001 : 18:53:07
|
do i name the file .dbs then upload it and then run my mod_step and it should recognize it and then run it?
|
|
|
|
freddydoes
Junior Member
108 Posts |
Posted - 27 December 2001 : 19:04:02
|
ok, visits is now gone, i have the correct fields in my database, i uploaded your pages you sent me... and i still get the error, so
i droped the forum and remade it with your .dbs file, here is what I got
Creating table(s)...
CREATE TABLE FORUM_ONLINEUserID#varchar(100)#NULL#( UserIP#varchar(40)#NULL# int IDENTITY (1, 1) NOT NULL , DateCreated varchar(100) NULL , LastDateChecked varchar(100) NULL , CheckedIn varchar(100) NULL , LastChecked varchar(100) NULL , M_BROWSE memo NULL , SYSTEMOS varchar(100) NULL , BROWSERTYPE varchar(100) NULL )
-2147217900 | Syntax error in field definition.
Edited by - freddydoes on 27 December 2001 19:09:30 |
|
|
|
Topic |
|
Topic Locked
