| Author |
 Topic  |
|
|
simonduz
Junior Member
161 Posts |
 Posted - 29 April 2001 : 01:37:36
|
The install went fine then used an include on my main page within a cell and get this error:
quote:
Microsoft JET Database Engine error '80040e14'
The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect.
/mods/slash.asp, line 73
I have seen others post the same error but no one has mentioned what was done to fix it.
thanks
simonduz |
|
|
e3stone
Average Member
USA
885 Posts |
Posted - 29 April 2001 : 01:59:14
|
Could you give us a link to a text version of your slash.asp file? and the page which has the slash include on it.
<-- Eric -->
http://insidewaco.com/forum
Edited by - e3stone on 29 April 2001 02:03:55 |
 |
|
|
simonduz
Junior Member
161 Posts |
|
|
e3stone
Average Member
USA
885 Posts |
Posted - 29 April 2001 : 10:07:36
|
Is your slash include currently in the code running on your site? I can't see it
<-- Eric -->
http://insidewaco.com/forum |
|
|
|
e3stone
Average Member
USA
885 Posts |
Posted - 29 April 2001 : 10:25:30
|
Make a .asp file with only these lines in it:
<!--#INCLUDE FILE="config.asp" -->
<!--#INCLUDE FILE="inc_functions.asp" -->
<!--#INCLUDE FILE="inc_top.asp" -->
<!--#include file="mods/slash.asp"-->
<!--#INCLUDE FILE="inc_footer.asp" -->
That will determine if your slash mod is setup right and functions correctly by itself. We'll narrow it down that way, first. If it shows up correctly, then there's a conflict with some other include file that you have on your resources page.
You could go through all the includes (just the ones that you have added - mods) and make sure all the recordsets are closed at the bottom of them. i.e. <% rsObj.close %> <% set rsObj = nothing %>
One note, Include files are the first thing processes on a page. So, even if you have the in an "If..Then" statement, every include on your page is processed by the server. I didn't know that until a few months ago when I was trying to do a conditional statement with includes.
Try that .asp file I wrote above and we'll work from there 
<-- Eric -->
http://insidewaco.com/forum
Edited by - e3stone on 29 April 2001 10:35:24 |
|
|
|
simonduz
Junior Member
161 Posts |
Posted - 29 April 2001 : 11:29:41
|
quote:
Is your slash include currently in the code running on your site? I can't see it
No, I have 2 local test areas for different layouts both on Win2k with IIS. I try not to throw it out on an external server until it has been tested.
I did as you said and created a test1.asp file with the includes. Same error. Login works, links work from inc_top.asp. So what does this rule out?
Thanks,
simonduz |
|
|
|
e3stone
Average Member
USA
885 Posts |
Posted - 29 April 2001 : 11:50:34
|
Well, since you got an error on that test1.asp page that means that there is probably something wrong with the way you set up the slash mod. You ran the mod_dbsetup.asp to create all the tables in your database? then went to slash_admin.asp and configured the mod?
Edit: I put those 5 lines on a page on my server and it worked.
<-- Eric -->
http://insidewaco.com/forum
Edited by - e3stone on 29 April 2001 11:52:03 |
|
|
|
e3stone
Average Member
USA
885 Posts |
Posted - 29 April 2001 : 12:01:03
|
I duplicated the error
quote:
Microsoft JET Database Engine error '80040e14'
The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect.
/forum/mods/slash.asp, line 73
You don't have anything in your Forum_Mods table. Meaning that you probably haven't run the slash_admin.asp file....I'm guessing....
<-- Eric -->
http://insidewaco.com/forum |
|
|
|
simonduz
Junior Member
161 Posts |
Posted - 29 April 2001 : 14:36:43
|
Well I did run slash_admin.asp but what I thought curious was that it did not prompt me to add any database tables, only the configuration was available which always says 'SLASH MOD WAS UPDATED.' mod_dbsetup.asp has no listing for the slash mod. So this sounds pretty easy, just manually add the content to the database (like slash_admin.asp states), but then again from looking it already has FORUM_Mods with M_NAME, M_CODE, M_VALUE. What is it missing (so confused)?
How did you duplicate the error?
thanks
simonduz
FYI: just uploaded the files to the external server and get the same results.
Edited by - simonduz on 29 April 2001 14:48:06 |
|
|
|
e3stone
Average Member
USA
885 Posts |
Posted - 29 April 2001 : 15:26:59
|
This is what my FORUM_MODS table has in it:
quote:
M_NAME M_CODE M_VALUE
slash slPosts 3
slash slLength 150
slash slSort 1
slash slImages 0
slash slEncode 1
To duplicate the error, I erased those values from the database.
<-- Eric -->
http://insidewaco.com/forum |
|
|
|
simonduz
Junior Member
161 Posts |
Posted - 29 April 2001 : 20:51:07
|
Back in now from a nice sunny afternoon out.
Just wanted to report that I manually added the entries in the DB and it worked.
Well I just learned something else to check now.
Thanks for taking the time e3stone.
simonduz
http://easyromantic.121host.net -[test site]-
yada, yada. |
|
|
|
DarlingBri
Junior Member
United Kingdom
378 Posts |
Posted - 09 May 2001 : 17:57:16
|
Like simonduz, I have no Slash files in mod_dbsetup. I'm going to be utterly terrified if I have to open the database and do this by hand.
Does anyone know why there's nothing about Slash in there?
--Bri :o(
*****
"Bother," said Pooh, as Piglet was assimilated by the Borg. |
|
|
|
animedj
Junior Member
USA
190 Posts |
|
|
DarlingBri
Junior Member
United Kingdom
378 Posts |
Posted - 09 May 2001 : 20:20:06
|
Thank you, that worked brilliantly!
I was just confused by the mod commader mention when there was no dbs file.
*****
"Bother," said Pooh, as Piglet was assimilated by the Borg. |
|
|
| |
Topic |
|
Topic Locked
