Snitz Forums 2000 - Links manager problems!

Snitz Forums 2000

Username:	Password:
Save Password
Forgot your Password?

All Forums

Help Groups for Snitz Forums 2000 Users

Help: MOD Implementation

Links manager problems!

New Topic

Topic Locked

Printer Friendly

Author

Topic

Page: of 2

majk
Starting Member

Sweden
8 Posts

Posted - 29 April 2003 : 20:12:28

Hi, I'm really new to Snitz but managed to pull throgh some MODs but when it comes to Link Manager I fail. Tried at least 10 times to install this MOD.
Different versions on my test forum who had some MODs, tried it on a clean installation, didn't work either.

After I've done everything you should I get...

from klicking "Links" in "Administrative Functions"...

Admin Interface

Microsoft JET Database Engine error '80040e37'

The Microsoft Jet database engine cannot find the input table or query 'LINKS'. Make sure it exists and that its name is spelled correctly.

/httestforum/admin_links_main.asp, line 33

But the menu to the left shows up!

If I enter the links through the newly created "Web links" I get the following error...

Microsoft JET Database Engine error '80040e37'

The Microsoft Jet database engine cannot find the input table or query 'links_categories'. Make sure it exists and that its name is spelled correctly.

/httestforum/links.asp, line 26

And when I klick some of the links in the left menu, there are various problems, but the fault message refeers to these files:

/httestforum/admin_links_admin.asp, line 92
/httestforum/admin_links_admin.asp, line 28
/httestforum/admin_links_adminsubcat.asp, line 25
/httestforum/admin_links_admintodelsubcat.asp, line 24
/httestforum/admin_links_addnewsubcat.asp, line 22
/httestforum/admin_links_urledit.asp, line 98
/httestforum/admin_links_urledit.asp, line 32
/httestforum/admin_links_browse.asp, line 179
/httestforum/admin_links_showbadlink.asp, line 27

Strange I think because it doesn't seem to hard to set up.
I've successfully installed Avatars, Polls, SmileManagerPlus, FAQ Admin, Forum Rules Admin but Links Mangager will not work.

Please help me out here folk!!!

/Mikael

Carefree
Advanced Member

Philippines
4217 Posts

Posted - 29 April 2003 : 23:34:51

Look at the file titled "Readme.html"

There's a line in there I think you missed:

quote:

Otherwise, if this is your initial installation, run the file "links_mod_dbsetup.asp"...

It sounds like you never setup the tables.

majk
Starting Member

Sweden
8 Posts

Posted - 29 April 2003 : 23:55:33

Of course I did, or at least I think.

It don't show up in the "Mod Setup" so I put the code from the file in the niffty "Alternative MOD Setup".
Maybe that's not the right way to do but I don't know what else to do.
All other MODs has shown in the "Mod setup.

So why not this one?

/Mikael
http://majk.gbg411.net

Edited by - majk on 29 April 2003 23:59:01

majk
Starting Member

Sweden
8 Posts

Posted - 30 April 2003 : 15:20:28

Anyone!?

/Mikael
http://majk.gbg411.net

Carefree
Advanced Member

Philippines
4217 Posts

Posted - 30 April 2003 : 20:10:13

If I remember that file correctly (and I think I do), once you are signed in as administrator you simply type the file name in the address bar to run it and create the tables.

Could have been done better; however, the author chose that method.

wiltech
Starting Member

17 Posts

Posted - 30 April 2003 : 23:47:45

It also doesn't allow for images to be in another directory

Tony W

CJOffroad.com

majk
Starting Member

Sweden
8 Posts

Posted - 01 May 2003 : 00:24:58

quote:
Originally posted by Carefree

If I remember that file correctly (and I think I do), once you are signed in as administrator you simply type the file name in the address bar to run it and create the tables.

Could have been done better; however, the author chose that method.

Thanks!
I tried what you suggested but i didn't work. I'll try from a fresh installation later on.
Strange indeed, not seen anyone having the same problem.

/Mikael
http://majk.gbg411.net

majk
Starting Member

Sweden
8 Posts

Posted - 05 May 2003 : 04:28:29

Ok, I tried this on a new installed forum, but I still don't get i t to work. I know it says that you should run the links_mod_dbsetup.asp but when I do this nothing happens. I mean nothing. The database doesn't get any larger and there is no "Table created succesfully" message.
But when i run the links.dbs in the Alternative MOD setup window i get:

Creating table(s)...
CREATE TABLE FORUM_LINKS_CATEGORIES( CAT_ID int IDENTITY (1, 1) PRIMARY KEY NOT NULL , CAT_NAME text (100) NULL )
Table created succesfully

--------------------------------------------------------------------------------

Creating table(s)...
CREATE TABLE FORUM_LINKS_SUBCATEGORIES( SUBCAT_ID int IDENTITY (1, 1) PRIMARY KEY NOT NULL , SUBCAT_NAME text (100) NULL , CAT_ID int NULL )
Table created succesfully

--------------------------------------------------------------------------------

Creating table(s)...
CREATE TABLE FORUM_LINKS( LINK_ID int IDENTITY (1, 1) PRIMARY KEY NOT NULL , NAME text (100) NULL , URL text (100) NULL , KEYWORD text (255) NULL , DESCRIPTION text (255) NULL , EMAIL text (100) NULL , POST_DATE text (50) NULL , BANNER_URL text (100) NULL , HIT int NULL DEFAULT 0, CATEGORY int NULL , PARENT_ID int NULL , SHOW int NULL , BADLINK int NULL )
Table created succesfully

--------------------------------------------------------------------------------

Creating table(s)...
CREATE TABLE FORUM_LINKS_RATING( RATING_ID int IDENTITY (1, 1) PRIMARY KEY NOT NULL , COMMENTS memo NULL , RATING int NULL , RATE_BY int NULL , LINK int NULL , RATE_DATE text (50) NULL )
Table created succesfully

--------------------------------------------------------------------------------

adding Column RATING...
ALTER TABLE FORUM_LINKS ADD COLUMN RATING int NOT NULL DEFAULT 0
Column added successfully
UPDATE FORUM_LINKS SET RATING=0
Populating Current Records with new Default value
Table(s) updated

--------------------------------------------------------------------------------

adding Column VOTES...
ALTER TABLE FORUM_LINKS ADD COLUMN VOTES int NOT NULL DEFAULT 0
Column added successfully
UPDATE FORUM_LINKS SET VOTES=0
Populating Current Records with new Default value
Table(s) updated

--------------------------------------------------------------------------------

Adding new records..
INSERT INTO FORUM_LINKS_CATEGORIES (CAT_NAME) VALUES ('News and Media')

Value(s) updated succesfully
--------------------------------------------------------------------------------

Adding new records..
INSERT INTO FORUM_LINKS_CATEGORIES (CAT_NAME) VALUES ('Business and Economy')

Value(s) updated succesfully
--------------------------------------------------------------------------------

Adding new records..
INSERT INTO FORUM_LINKS_CATEGORIES (CAT_NAME) VALUES ('Recreation and Sports')

Value(s) updated succesfully
--------------------------------------------------------------------------------

Adding new records..
INSERT INTO FORUM_LINKS_CATEGORIES (CAT_NAME) VALUES ('Computers and Internet')

Value(s) updated succesfully
--------------------------------------------------------------------------------

Adding new records..
INSERT INTO FORUM_LINKS_CATEGORIES (CAT_NAME) VALUES ('Entertainment')

Value(s) updated succesfully
--------------------------------------------------------------------------------

Adding new records..
INSERT INTO FORUM_LINKS_SUBCATEGORIES (SUBCAT_NAME,CAT_id) VALUES ('Newspaper and Literature',1)

Value(s) updated succesfully
--------------------------------------------------------------------------------

Adding new records..
INSERT INTO FORUM_LINKS_SUBCATEGORIES (SUBCAT_NAME,CAT_id) VALUES ('Radio Online',1)

Value(s) updated succesfully
--------------------------------------------------------------------------------

Adding new records..
INSERT INTO FORUM_LINKS_SUBCATEGORIES (SUBCAT_NAME,CAT_id) VALUES ('Consulting',2)

Value(s) updated succesfully
--------------------------------------------------------------------------------

Adding new records..
INSERT INTO FORUM_LINKS_SUBCATEGORIES (SUBCAT_NAME,CAT_id) VALUES ('Commerce',2)

Value(s) updated succesfully
--------------------------------------------------------------------------------

Adding new records..
INSERT INTO FORUM_LINKS_SUBCATEGORIES (SUBCAT_NAME,CAT_id) VALUES ('Shopping',2)

Value(s) updated succesfully
--------------------------------------------------------------------------------

Adding new records..
INSERT INTO FORUM_LINKS_SUBCATEGORIES (SUBCAT_NAME,CAT_id) VALUES ('Auction',2)

Value(s) updated succesfully
--------------------------------------------------------------------------------

Adding new records..
INSERT INTO FORUM_LINKS_SUBCATEGORIES (SUBCAT_NAME,CAT_id) VALUES ('Services',2)

Value(s) updated succesfully
--------------------------------------------------------------------------------

Adding new records..
INSERT INTO FORUM_LINKS_SUBCATEGORIES (SUBCAT_NAME,CAT_id) VALUES ('Golf',3)

Value(s) updated succesfully
--------------------------------------------------------------------------------

Adding new records..
INSERT INTO FORUM_LINKS_SUBCATEGORIES (SUBCAT_NAME,CAT_id) VALUES ('NFL',3)

Value(s) updated succesfully
--------------------------------------------------------------------------------

Adding new records..
INSERT INTO FORUM_LINKS_SUBCATEGORIES (SUBCAT_NAME,CAT_id) VALUES ('Soccer',3)

Value(s) updated succesfully
--------------------------------------------------------------------------------

Adding new records..
INSERT INTO FORUM_LINKS_SUBCATEGORIES (SUBCAT_NAME,CAT_id) VALUES ('NBA',3)

Value(s) updated succesfully
--------------------------------------------------------------------------------

Adding new records..
INSERT INTO FORUM_LINKS_SUBCATEGORIES (SUBCAT_NAME,CAT_id) VALUES ('NHL',3)

Value(s) updated succesfully
--------------------------------------------------------------------------------

Adding new records..
INSERT INTO FORUM_LINKS_SUBCATEGORIES (SUBCAT_NAME,CAT_id) VALUES ('Programming',4)

Value(s) updated succesfully
--------------------------------------------------------------------------------

Adding new records..
INSERT INTO FORUM_LINKS_SUBCATEGORIES (SUBCAT_NAME,CAT_id) VALUES ('Internet',4)

Value(s) updated succesfully
--------------------------------------------------------------------------------

Adding new records..
INSERT INTO FORUM_LINKS_SUBCATEGORIES (SUBCAT_NAME,CAT_id) VALUES ('ASP Resources',4)

Value(s) updated succesfully
--------------------------------------------------------------------------------

Adding new records..
INSERT INTO FORUM_LINKS_SUBCATEGORIES (SUBCAT_NAME,CAT_id) VALUES ('Web Hosts',4)

Value(s) updated succesfully
--------------------------------------------------------------------------------

Adding new records..
INSERT INTO FORUM_LINKS_SUBCATEGORIES (SUBCAT_NAME,CAT_id) VALUES ('PHP Resources',4)

Value(s) updated succesfully
--------------------------------------------------------------------------------

Adding new records..
INSERT INTO FORUM_LINKS_SUBCATEGORIES (SUBCAT_NAME,CAT_id) VALUES ('Movies',5)

Value(s) updated succesfully
--------------------------------------------------------------------------------

Adding new records..
INSERT INTO FORUM_LINKS_SUBCATEGORIES (SUBCAT_NAME,CAT_id) VALUES ('Books',5)

Value(s) updated succesfully
--------------------------------------------------------------------------------

Adding new records..
INSERT INTO FORUM_LINKS_SUBCATEGORIES (SUBCAT_NAME,CAT_id) VALUES ('Games',5)

Value(s) updated succesfully
--------------------------------------------------------------------------------

Adding new records..
INSERT INTO FORUM_LINKS_SUBCATEGORIES (SUBCAT_NAME,CAT_id) VALUES ('Cool Sites',5)

Value(s) updated succesfully
--------------------------------------------------------------------------------

Database setup finished

Odd enough I don't get i to work anyway. Still get the same error messages as described in the first post!

And when I look in the database I see that the tables HAS been created.
I don't understand this. Can somebody help me please.

/Mikael
http://majk.gbg411.net

Edited by - majk on 05 May 2003 04:31:37

Chris Yew
Junior Member

134 Posts

Posted - 15 May 2003 : 10:04:37

Hi,
I've installed the Link Manager 2 "refreshed" version 2.35. When I wanted to run the Mod Setup, I couldn't find the Link Mod dbsetup.dbs which usually most of the mods I've done should show up here.

I've reinstalled again twice and still didn't show up in the Mod Setup. Why is this so? Have I missed up anything?

Pls help thank you.

Chris Yew

OneWayMule
Dev. Team Member & Support Moderator

Austria
4969 Posts

Posted - 15 May 2003 : 10:09:52

You can either
- rename the .dbs file so it's in the format dbs_something.asp (e.g. dbs_links.asp)
- open the dbs file and copy its content to Alternate MOD setup and hit update

hope that helps

My MODs:
Birthdays - Custom Policy - F.A.Q. Administration - Forum Rules - Guestbook
Links Manager - MyOwnGoogle - Profile Views - Search Log - WebSearch

Useful stuff:
Forum and MOD Installation - MOD Installation Guide - Snitz v3.4.05 Readme - Free ASP Hosts - Support Snitz

Chris Yew
Junior Member

134 Posts

Posted - 15 May 2003 : 10:37:58

Thanks Mule. I've tried rename the file but the Mod setup shows a blank space. So I tried the Alternate Mod setup and it works in and didn't show any problem in that stage.

So I go the the Admin Option -> Links;
It shows;

Admin Interface

Microsoft JET Database Engine error '80040e37'

The Microsoft Jet database engine cannot find the input table or query 'LINKS'. Make sure it exists and that its name is spelled correctly.

/forum/admin_links_main.asp, line 49

And that line is ;
Set RScount = my_Conn.Execute(strSQL)

Pls help. Thank you.

Chris Yew

OneWayMule
Dev. Team Member & Support Moderator

Austria
4969 Posts

Posted - 15 May 2003 : 10:45:12

Wait... as far as I remember LM2 includes a db update script...
if the zip you've downloaded includes a file called links_mod_dbsetup.asp then upload it to your forum folder and run it.

Chris Yew
Junior Member

134 Posts

Posted - 15 May 2003 : 10:52:41

Yes, you are right! Hit right on and it works. Thanks a million.

OneWayMule
Dev. Team Member & Support Moderator

Austria
4969 Posts

Posted - 15 May 2003 : 11:08:50

No problem, you're welcome.

AWD_ENVY
Junior Member

103 Posts

Posted - 16 May 2003 : 16:39:39

FYI... Links V2.x has issues with MYSQL

The "SHOW" field in the "Links" table is incompatible with MySQL. I just renamed everything for the "SHOW" field to "SHOWLINKS" and everything was fine.

majk
Starting Member

Sweden
8 Posts

Posted - 19 May 2003 : 06:05:51

Hmm ,strange.

I still

don't get this to work. Sigh!
But now my server has gone broken

so this is not the primary objective anymore.
But I'll be back.

/Mikael
http://majk.gbg411.net

Page: of 2

Topic

New Topic

Topic Locked

Printer Friendly

Jump To:

Snitz Forums 2000

This page was generated in 0.44 seconds.