| Author |
 Topic  |
|
|
funinbc
Junior Member
245 Posts |
 Posted - 05 May 2002 : 03:59:46
|
can anyone help me on this? I am tring to set up the Slash mod and when I go to the mod set up this is what I get.
Slash Mod ver3.00 SR1
Adding Column M_NAME...
ALTER TABLE FORUM_MODS ALTER COLUMN M_NAME text(50) NOT
NULL
-2147217865 | Cannot find table or constraint.
Adding Column M_CODE...
ALTER TABLE FORUM_MODS ALTER COLUMN M_CODE text(50) NOT
NULL
-2147217865 | Cannot find table or constraint.
Adding Column M_VALUE...
ALTER TABLE FORUM_MODS ALTER COLUMN M_VALUE memo NOT
NULL
-2147217865 | Cannot find table or constraint.
Updating Forum Values..
DELETE FROM FORUM_MODS WHERE M_NAME = 'slash'
-2147217865 | The Microsoft Jet database engine cannot find the
input table or query 'FORUM_MODS'. Make sure it exists and that
its name is spelled correctly.
Adding new records..
INSERT INTO FORUM_MODS (M_NAME,M_CODE,M_VALUE) VALUES
('slash','config','enx01050002000')
-2147217865 | Could not find output table 'FORUM_MODS'.
The dbs file was succesfully deleted.
|
|
|
crash
Advanced Member
Netherlands
2064 Posts |
Posted - 05 May 2002 : 06:59:59
|
the table FORUM_MODS did not get created
Crash's Site | Crash is from 
|
 |
|
|
funinbc
Junior Member
245 Posts |
Posted - 05 May 2002 : 11:16:46
|
sorry here comes the next stupid question. How do you get FORUM_MODS to get created ?
|
|
|
|
crash
Advanced Member
Netherlands
2064 Posts |
Posted - 05 May 2002 : 11:34:34
|
well... i am not familiar with the slash mod as a separate mod, but it should be in the DBS file. see if you find any instances of
[CREATE]
MODS
in the DBS file
Crash's Site | Crash is from
|
|
|
|
funinbc
Junior Member
245 Posts |
Posted - 05 May 2002 : 12:01:57
|
I have read the set up file about 20 times and I still dont get it. It says to:
As always you need to unzip the files in the forum directory, with paths enabled
But how do you get the paths enabled?
I guess I am still at square one still. I have uploaded all the files
but as in my first post I cant run the admin mod setup. Does anybody know of a detailed setup file? Am I the only one with this problem?
|
|
|
|
crash
Advanced Member
Netherlands
2064 Posts |
Posted - 05 May 2002 : 12:12:24
|
did you even read my post?
Crash's Site | Crash is from
|
|
|
|
funinbc
Junior Member
245 Posts |
Posted - 05 May 2002 : 12:28:27
|
I did but I'm sorry the best I can hope for is to follow instuctions. I dont know the code. I would like to learn when I get more time.
I'm not sure where to look for
[CREATE]
MODS
in the DBS file
This DBS file I have are :
dbs_language.dbs
dbs_mods_new.dbs
dbs_slash_mod.dbs
But I cant edit them to see if there is "Create Mods" in them
Sorry for being such a newbie
|
|
|
|
crash
Advanced Member
Netherlands
2064 Posts |
Posted - 05 May 2002 : 12:32:32
|
i don't blame noone here. i just asked a question.
when you right click the dbs file named dbs_mods_new.dbs and open it with notepad you should be able to look inside it.
tell me if there are these lines:
[CREATE]
MODS
Crash's Site | Crash is from
|
|
|
|
funinbc
Junior Member
245 Posts |
Posted - 05 May 2002 : 12:48:09
|
Yes it reads:
MOD Table - New Installation
[CREATE]
MODS
M_NAME#varchar(50)##
M_CODE#varchar(50)##
M_VALUE#MEMO##
[END]
Do I have to change these?
|
|
|
|
Classicmotorcycling
Development Team Leader
Australia
2085 Posts |
Posted - 05 May 2002 : 16:14:37
|
Funinbc,
I have found an old copy of the Slash Mod (both 3.0 alpha and 3.10) and see you need to run the file mods_new.dbs or dbs_mods_new.dbs (depending on the version) first. You then need to run the update, slash_mod.dbs or dbs_slash_mod.dbs (again depending on the version). I have listed the contents of both files here for you.
First file: mods_new.dbs
MOD Table - New Installation
[CREATE]
MODS
M_NAME#varchar(50)##
M_CODE#varchar(50)##
M_VALUE#MEMO##
[END]
Second file: slash_mod.dbs
Slash Mod ver3.00 SR1
[ALTER]
MODS
ALTER#M_NAME#varchar(50)###
ALTER#M_CODE#varchar(50)###
ALTER#M_VALUE#MEMO###
[END]
[DELETE]
MODS
M_NAME = 'slash'
[END]
[INSERT]
MODS
(M_NAME,M_CODE,M_VALUE)#('slash','config','enx01050002000')
[END]
I just tried them and they worked on an old system, so give em a go and they should be right.
quote:
Yes it reads:
MOD Table - New Installation
[CREATE]
MODS
M_NAME#varchar(50)##
M_CODE#varchar(50)##
M_VALUE#MEMO##
[END]
Do I have to change these?
Regards,
Webmaster @ Classic Motorycling Australia
Classic Motorcycling Australia |
|
|
|
funinbc
Junior Member
245 Posts |
Posted - 06 May 2002 : 02:04:06
|
I have the file but like in my first post I get errors when I run it. I would realy like this mod but there is not really good instructions. I can't figure out what I am doing wrong. I have up loaded the files and ran them. I think it has something to do with the FORUM_MODS but I cant figure it out. Can anyone offer some more suggestions? Thanks in advance
|
|
|
|
Classicmotorcycling
Development Team Leader
Australia
2085 Posts |
Posted - 06 May 2002 : 03:45:18
|
Funinbc,
Do you have the following fields in your FORUM_MODS table in your database?
It is just these fields are required for the Slash Mod to work. If not, I suggest you add them to your DB. Also when you uploaded your files to your site, did you include the admin_mod_dbsetup.asp file and use that? It is I remember a while ago someone saying that you need to use the one that came with it.
All else fails, you may need to remove all the DB entries for the Slash mod and re-run the dbs files.
quote:
I have the file but like in my first post I get errors when I run it. I would realy like this mod but there is not really good instructions. I can't figure out what I am doing wrong. I have up loaded the files and ran them. I think it has something to do with the FORUM_MODS but I cant figure it out. Can anyone offer some more suggestions? Thanks in advance
Regards,
Webmaster @ Classic Motorycling Australia
Classic Motorcycling Australia |
|
|
|
funinbc
Junior Member
245 Posts |
Posted - 09 May 2002 : 00:58:22
|
Ok I have found the two files and have ran them. I then put the
<!-- #INCLUDE VIRTUAL="/forums/config.asp" -->
<!-- #INCLUDE VIRTUAL="/forums/inc_functions.asp" -->
<!-- #INCLUDE VIRTUAL="/forums/slash.asp" -->
at the top of the page and <%= slash() %> where I what the post to apear.
It still does not work. It says that it can not find my config.asp. I checked and I do have a config.asp in this directory
What am I missing??
|
|
|
|
Classicmotorcycling
Development Team Leader
Australia
2085 Posts |
Posted - 09 May 2002 : 03:50:21
|
Funinbc,
You actually need to add them like this;
<!-- #INCLUDE VIRTUAL="/forum/config.asp" -->
<!-- #INCLUDE VIRTUAL="/forum/inc_functions.asp" -->
<!-- #INCLUDE VIRTUAL="/forum/slash.asp" -->
You will notice that there is no s in the forums part...
quote:
Ok I have found the two files and have ran them. I then put the
<!-- #INCLUDE VIRTUAL="/forums/config.asp" -->
<!-- #INCLUDE VIRTUAL="/forums/inc_functions.asp" -->
<!-- #INCLUDE VIRTUAL="/forums/slash.asp" -->
at the top of the page and <%= slash() %> where I what the post to apear.
It still does not work. It says that it can not find my config.asp. I checked and I do have a config.asp in this directory
What am I missing??
Regards,
Webmaster @ Classic Motorycling Australia
Classic Motorcycling Australia |
|
|
|
funinbc
Junior Member
245 Posts |
Posted - 09 May 2002 : 14:34:18
|
actually figured that out and added them without the S I then tried to move it to the top of the page then to the header and it did not make a differences.
I did run the test java html page and the forum msg were created.
|
|
|
|
stwilson
Junior Member
USA
385 Posts |
Posted - 07 September 2002 : 12:11:35
|
This is the error I get when I run the MOD setup:
Updating Forum Values..
DELETE FROM FORUM_MODS WHERE M_NAME = 'slash'
13 | Type mismatch
When I go to: slash_admin.asp, I get the form buy I noticed the Language element has no selectible options. Also, when I submit the form I get this error "Couldn't load the config for SlashMod"
I then look at my DB and I do not see the list of items ClassicMotorcycling listed. What do I do?
STW |
Shannon
RidingArizona.com |
Edited by - stwilson on 07 September 2002 12:12:43 |
|
|
| |
Topic |
|
Topic Locked
