Author |
Topic |
DarlingBri
Junior Member
United Kingdom
378 Posts |
Posted - 09 May 2001 : 17:35:26
|
Arrgh! I'm having a bad day, filled with stupid problems, but nice people.
Right, I installed the Required Files, and my Link Manager Mod is showing up there, as is Mod Commander DB Setup, so that's good.
I've installed Slash MOS 2.10 and I'm finding ht readme really confusing.
quote:
* The setup link in MOD COMMANDER or slash_patch.asp are for people alreading using slash mod. If this is your first time setting up this mod, you don't need to use the setup link/slash_patch.asp file. * You need to unzip these files to a MODS directory inside your forums directory. * This MOD uses MOD COMMANDER for easy set-up. * If you are not using an access databse type, you are going to need to create a new table in your database. More instructions in the set-up. * If you are not using MOD COMMANDER, you need to load slash_admin.asp to start setting up this mod.
I do have MOD Commander. But there's nothing in it about Slash.
The only wonky thing is that my Slash files are all in my forum root because I have that annoying "../whatever cannot reference parent directory" thing going on.
So I think I've done this right. Except I'm getting this error:
quote: Microsoft JET Database Engine error '80040e37'
The Microsoft Jet database engine cannot find the input table or query 'mods'. Make sure it exists and that its name is spelled correctly.
So somehow, I think the tables that are supposed to be added in MOD Commander aren't added.
I'm a bit confused here, to be honest. Can anyone lend (another) hand?
--Bri
***** "Bother," said Pooh, as Piglet was assimilated by the Borg. |
|
animedj
Junior Member
USA
190 Posts |
Posted - 09 May 2001 : 19:22:00
|
can you write down here specifically the error that you get when you run slash_admin.asp in the mods directory here..
--- Johann Reyes http://animedj.com |
|
|
DarlingBri
Junior Member
United Kingdom
378 Posts |
Posted - 09 May 2001 : 19:57:59
|
Never mind. It works now!
Edited by - DarlingBri on 09 May 2001 21:54:11 |
|
|
DarlingBri
Junior Member
United Kingdom
378 Posts |
Posted - 09 May 2001 : 20:20:41
|
Hmm, it works now!!!
:o))
But I can't include it in a non-Snitz page, can I?
Edited by - DarlingBri on 09 May 2001 20:22:30 |
|
|
animedj
Junior Member
USA
190 Posts |
Posted - 09 May 2001 : 21:49:57
|
the purpose of slash mod is to include in non-snitz pages .. but you have to include in every non-snitz page other than slash.asp also config.asp and in_functions.asp from your forums directory...
--- Johann Reyes http://animedj.com |
|
|
DarlingBri
Junior Member
United Kingdom
378 Posts |
Posted - 09 May 2001 : 22:18:50
|
Thank you for clearing that up for me.
I am getting an error on my non-Snitz page:
quote: Microsoft JET Database Engine error '80040e37'
The Microsoft Jet database engine cannot find the input table or query 'mods'. Make sure it exists and that its name is spelled correctly.
/connexions/forum/slash.asp, line 27
which refers to this bit:
strSQL = "SELECT m_code, m_value FROM " & strTablePrefix & "mods WHERE m_name = 'slash';" set objRec = my_conn.Execute(strSQL)
I don't know what the heck I'm looking at, but the & "mods bit makes me think it's looking in the /Mods directory. Because I can't reference the parent directory for includes, my Slash files all reside in my /forum root.
Do I need to alter the code, then?
Thank you for you time, --Bri
***** "Bother," said Pooh, as Piglet was assimilated by the Borg.
Edited by - DarlingBri on 09 May 2001 22:19:28 |
|
|
DarlingBri
Junior Member
United Kingdom
378 Posts |
Posted - 09 May 2001 : 22:30:51
|
No, it doesn't make a difference where I put it, I still get the same error.
Slash_admin, however, shows it working and gives no errors.
mod_dbsetup show the following:
quote: Creating table(s)... CREATE TABLE FORUM_MODS( M_NAME varchar(50) NOT NULL , M_CODE varchar(50) NOT NULL , M_VALUE MEMO NULL ) -2147217900 | Table 'FORUM_MODS' already exists.
--------------------------------------------------------------------------------
Adding new records.. INSERT INTO FORUM_MODS (M_NAME,M_CODE,M_VALUE) VALUES ('slash','slPosts','5') INSERT INTO FORUM_MODS (M_NAME,M_CODE,M_VALUE) VALUES ('slash', 'slLength', '150') INSERT INTO FORUM_MODS (M_NAME,M_CODE,M_VALUE) VALUES ('slash', 'slSort', '1')
Value(s) updated succesfully
I don't know if any of this helps
***** "Bother," said Pooh, as Piglet was assimilated by the Borg. |
|
|
animedj
Junior Member
USA
190 Posts |
Posted - 09 May 2001 : 22:50:10
|
hhmm.. are you sure you included the config.asp page in that page?? .. because it seems is not loading the strTablePrefix variable that is "FORUMS_"
--- Johann Reyes http://animedj.com |
|
|
DarlingBri
Junior Member
United Kingdom
378 Posts |
Posted - 09 May 2001 : 23:57:21
|
I'd taken that bit out because I thought it was already called in AznKnight's Links Manager Frontpage AddOn. Putting it back at the top of slash.asp, ow I'm getting this:
quote: Microsoft VBScript compilation error '800a0411'
Name redefined
/connexions/forum/config.asp, line 44
dim strDBType, strConnString, strTablePrefix, strMemberTablePrefix '## Do Not Edit ----^
I've tried it with including config.asp alone *and* with inc_functions.asp and config.asp
I really want these to work together :o(((
***** "Bother," said Pooh, as Piglet was assimilated by the Borg. |
|
|
Aznknight
Senior Member
USA
1373 Posts |
Posted - 10 May 2001 : 01:03:20
|
when i wrote the links manager add-on, i thought you were using a page totally outside of the forum. but if you want to use this injunction with the slash.mod which asks to include the config.asp file just delete this part from the links_inc.asp file
dim strDBType, strConnString
'################################################################################# '## SELECT YOUR DATABASE TYPE AND CONNECTION TYPE (access, sqlserver or mysql) '################################################################################# 'strDBType = "sqlserver" strDBType = "access" 'strDBType = "mysql"
'## Make sure to uncomment one of the strConnString lines! 'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=c:\inetpub\dbroot\snitz_forums_2000.mdb" '## MS Access 97 strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("snitz/tools/snitzresource.mdb") '## MS Access 2000 using virtual path 'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\inetpub\dbroot\forum.snitz.com\snitz_forum.mdb;" '## MS Access 2000 'strConnString = "driver={SQL Server};server=SERVER_NAME;uid=SQL_USER;pwd=PASSWORD;database=DATABASE_NAME" '## MS SQL Server 7 'strConnString = "driver=MySQL;server=SERVER_NAME;uid=MYSQL_USER;pwd=PARRWORD;database=DATABASE_NAME" '## MySQL
also make you include the config.asp file b4 you include the links_inc.asp file. Hopefully that should sort you out.
- Alan www.iamviet.com www.calvsa.net Snitz Resource |
|
|
DarlingBri
Junior Member
United Kingdom
378 Posts |
Posted - 10 May 2001 : 10:55:10
|
Bloody hell, this has gotten really confused.
I'll try to explain what I'm trying to do, and if someone wants to help me, that would be great :o)
I'm building a demo site at http://www.knx.net.uk/connexions/ which is the homepage.
My Snitz stuff is in http://www.knx.net.uk/connexions/forum/
As you can see, I've got the links bit working great (thank you Alan!) with <!-- #include file=forum/links_inc.asp -->
I'd like to *also* include slash.asp on this page, which is indeed outside my forum. But when I do <!-- #include file=forum/slash.asp --> it chokes. I get the redefined error.
Is there no way I can make these two work together, both on a page outside /forums? That's what I was trying to achieve.
I'm really sorry if I've been unclear about this!
Thanks, Bri
***** "Bother," said Pooh, as Piglet was assimilated by the Borg. |
|
|
DarlingBri
Junior Member
United Kingdom
378 Posts |
Posted - 10 May 2001 : 21:22:05
|
quote:
Is there no way I can make these two work together, both on a page outside /forums? That's what I was trying to achieve.
I take it the answer is no?
**** and blast... please don't make me choose! That would jsut be evil!
Ahh, well... thanks everyone, anyhow
***** "Bother," said Pooh, as Piglet was assimilated by the Borg. |
|
|
animedj
Junior Member
USA
190 Posts |
Posted - 10 May 2001 : 23:04:40
|
like Aznknight said in his post... you need to delete those line from the links asp include to make it work....
--- Johann Reyes http://animedj.com |
|
|
DarlingBri
Junior Member
United Kingdom
378 Posts |
Posted - 11 May 2001 : 00:38:07
|
OK, I've tried that, but I'm getting an error message:
quote: Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
/connexions/forum/links_inc.asp, line 5
which refers to this line:
links_conn.open strConnString
Now, please don't get annoyed here, but am I supposed to be including config.asp myself? Because I thought the config stuff was taken care of somewhere in links_inc.asp.
For that reason, I'm calling forums/links_inc.asp before forums/slash.asp.
I'm sorry I'm not doing this very well; thanks for all your time. I know you don't have to do this, and it must get frustrating for you guys.
***** "Bother," said Pooh, as Piglet was assimilated by the Borg. |
|
|
Aznknight
Senior Member
USA
1373 Posts |
Posted - 11 May 2001 : 01:02:11
|
okay remove the lines in red from links_inc.asp i pointed to above. then include the config.asp somewhere above where you include links_inc and slash.asp
- Alan www.iamviet.com www.calvsa.net Snitz Resource |
|
|
DarlingBri
Junior Member
United Kingdom
378 Posts |
Posted - 11 May 2001 : 01:32:47
|
OK, I removed those lines, added config.asp way at the top, and now I get *this* error:
Microsoft VBScript compilation error '800a0411'
Name redefined
/connexions/forum/mod_config.asp, line 5
Dim intAllowUploads ----^
What on Earth does that mean?
***** "Bother," said Pooh, as Piglet was assimilated by the Borg. |
|
|
Topic |
|