Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Snitz Forums 2000 MOD-Group
 MOD Add-On Forum (W/Code)
 Portal Mod 1.0 (with Links Manager 3 integration)
 New Topic  Topic Locked
 Printer Friendly
Next Page
Author Previous Topic Topic Next Topic
Page: of 11

DavidRhodes
Senior Member

United Kingdom
1222 Posts

Posted - 15 April 2003 :  10:31:13  Show Profile
Following on from http://forum.snitz.com/forum/topic.asp?TOPIC_ID=43155 here's my first release, tested ok on Sql Server, should work on others too

David's Portal Mod

Please follow the instruction carefully, especially step 4

Edit: took off the beta from the title as it seems to be bug free now (touch wood)

The UK MkIVs Forum

Edited by - DavidRhodes on 28 December 2003 12:20:53

Faizan
Average Member

United Kingdom
592 Posts

Posted - 15 April 2003 :  10:58:50  Show Profile  Visit Faizan's Homepage  Send Faizan an AOL message  Send Faizan an ICQ Message  Send Faizan a Yahoo! Message
Hey, I can't download this, it says:
quote:
HTTP1.1 STATUS 403 Remote Access to this object forbidden This file cannot be directly accessed from a remote site, but must be linked through the Brinkster Member's site.


»Snitz Graphics
Go to Top of Page

weeweeslap
Senior Member

USA
1077 Posts

Posted - 15 April 2003 :  11:07:53  Show Profile  Visit weeweeslap's Homepage  Send weeweeslap an AOL message  Send weeweeslap a Yahoo! Message
Copy and paste the link into this window and the download will work too
Thanks David!

coaster crazy
Go to Top of Page

Faizan
Average Member

United Kingdom
592 Posts

Posted - 15 April 2003 :  13:54:12  Show Profile  Visit Faizan's Homepage  Send Faizan an AOL message  Send Faizan an ICQ Message  Send Faizan a Yahoo! Message
Yeah, It works, Thanks!


»Snitz Graphics
Go to Top of Page

kwhipp
Junior Member

USA
407 Posts

Posted - 15 April 2003 :  14:44:44  Show Profile  Visit kwhipp's Homepage  Send kwhipp an AOL message  Send kwhipp an ICQ Message  Send kwhipp a Yahoo! Message
Or, just right-click and "Save Target As ..."

- Kevin
Go to Top of Page

pollocka
Starting Member

8 Posts

Posted - 16 April 2003 :  05:17:07  Show Profile
I add the files and make the changes, run dbs_portal.asp and setup.asp, then go to the admin page, click 'portal' and then 'Add Content' and it comes back with...


Error Type:
Microsoft JET Database Engine (0x80040E37)
The Microsoft Jet database engine cannot find the input table or query 'FORUM_CMS_CATEGORY'. Make sure it exists and that its name is spelled correctly.
/dev/Forum/admin_cms_content.asp, line 271

Where am I going wrong?
Go to Top of Page

DavidRhodes
Senior Member

United Kingdom
1222 Posts

Posted - 16 April 2003 :  08:04:34  Show Profile
did the dbs file report any errors?

The UK MkIVs Forum
Go to Top of Page

pollocka
Starting Member

8 Posts

Posted - 16 April 2003 :  09:16:06  Show Profile
When I run it the browser just shows

David's Portal Mod [DROP] CMS_CATEGORY [END] [DROP] CMS_CONTENT [END] [CREATE] CMS_CATEGORY CAT_ID CAT_TITLE#varchar(20)#NULL# CAT_ISLEFT#smallint#NULL#0 CAT_ORDER#int#NULL# [END] [CREATE] CMS_CONTENT CONT_ID CAT_ID#int#NULL# CONT_TITLE#varchar(100)#NULL# CONT_SUMMARY#varchar(500)#NULL# CONT_BODY#text#NULL# CONT_POSTEDBY#int#NULL# CONT_AUTHOR#int#NULL# CONT_DATE#varchar(14)#NULL# CONT_LAST_EDIT#varchar(14)#NULL# CONT_STATUS#smallint#NULL#0 [END] [INSERT] CONFIG_NEW (C_VARIABLE,C_VALUE)#('strCMSLeftNavWidth','150') (C_VARIABLE,C_VALUE)#('strCMSLeftNavDisplay','5') (C_VARIABLE,C_VALUE)#('strCMSLeftNavItems','1') (C_VARIABLE,C_VALUE)#('strCMSRightNavWidth','150') (C_VARIABLE,C_VALUE)#('strCMSRightNavDisplay','5') (C_VARIABLE,C_VALUE)#('strCMSRightNavItems','1') (C_VARIABLE,C_VALUE)#('strCMSEnableSearch','1') (C_VARIABLE,C_VALUE)#('strCMSDefaultCID','0') (C_VARIABLE,C_VALUE)#('strCMSPageTitle','Portal') (C_VARIABLE,C_VALUE)#('strCMSTitleDisplay','1') [END]
Go to Top of Page

DavidRhodes
Senior Member

United Kingdom
1222 Posts

Posted - 16 April 2003 :  09:44:13  Show Profile
I gather this is your first mod

By running the dbs file I mean, login to admin section, click Mod Setup and select 'David's Portal Mod' from the drop down and click submit.
then actually run setup.asp in the browser

The UK MkIVs Forum
Go to Top of Page

pollocka
Starting Member

8 Posts

Posted - 16 April 2003 :  10:11:47  Show Profile
Ooooh, cunning
Go to Top of Page

pollocka
Starting Member

8 Posts

Posted - 16 April 2003 :  10:19:15  Show Profile
Okay, now it is saying it can't create the CMS_CONTENT table because the field name is too long. I'm using Access 2000.
Go to Top of Page

Faizan
Average Member

United Kingdom
592 Posts

Posted - 16 April 2003 :  11:21:38  Show Profile  Visit Faizan's Homepage  Send Faizan an AOL message  Send Faizan an ICQ Message  Send Faizan a Yahoo! Message
http://fsqforums.www3.dotnetplayground.com/forum2/portal.asp

When I ran alternative MOD setup, everything was created successfully, apart from this:
quote:
Creating table(s)...
CREATE TABLE FORUM_CMS_CONTENT( CONT_ID int IDENTITY (1, 1) PRIMARY KEY NOT NULL , CAT_ID int NULL , CONT_TITLE varchar(100) NULL , CONT_SUMMARY varchar(500) NULL , CONT_BODY text NULL , CONT_POSTEDBY int NULL , CONT_AUTHOR int NULL , CONT_DATE varchar(14) NULL , CONT_LAST_EDIT varchar(14) NULL , CONT_STATUS smallint NULL DEFAULT 0)
CREATE TABLE FORUM_CMS_CONTENT( CONT_ID int IDENTITY (1, 1) PRIMARY KEY NOT NULL , CAT_ID int NULL , CONT_TITLE varchar(100) NULL , CONT_SUMMARY varchar(500) NULL , CONT_BODY text NULL , CONT_POSTEDBY int NULL , CONT_AUTHOR int NULL , CONT_DATE varchar(14) NULL , CONT_LAST_EDIT varchar(14) NULL , CONT_STATUS smallint NULL DEFAULT 0)
-2147217887 | Size of field 'CONT_SUMMARY' is too long.


And the portal page doesn't work because of this.
You can have a look at my portal page as well:
http://fsqforums.www3.dotnetplayground.com/forum2/portal.asp


»Snitz Graphics
Go to Top of Page

OneWayMule
Dev. Team Member & Support Moderator

Austria
4969 Posts

Posted - 16 April 2003 :  13:53:22  Show Profile  Visit OneWayMule's Homepage  Send OneWayMule an ICQ Message
The CONT_SUMMARY field should be memo:

CONT_SUMMARY#memo#NULL#

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
Go to Top of Page

stylishvn
Junior Member

Vietnam
185 Posts

Posted - 17 April 2003 :  00:54:05  Show Profile  Visit stylishvn's Homepage  Send stylishvn an ICQ Message  Send stylishvn a Yahoo! Message
thanks David
it's not hard to install when my forum's been added some MOD but I have a problem like some guys here
Size of field 'CONT_SUMMARY' is too long

so how can I fix it ?

..:: Welcome #Snitz in Dalnet ::..
Go to Top of Page

OneWayMule
Dev. Team Member & Support Moderator

Austria
4969 Posts

Posted - 17 April 2003 :  00:58:41  Show Profile  Visit OneWayMule's Homepage  Send OneWayMule an ICQ Message
stylishvn, as I posted above, simply change the varchar(500) to memo.
You can download a dbs file with the fix here.

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
Go to Top of Page

stylishvn
Junior Member

Vietnam
185 Posts

Posted - 17 April 2003 :  03:29:15  Show Profile  Visit stylishvn's Homepage  Send stylishvn an ICQ Message  Send stylishvn a Yahoo! Message
thanks OneWayMule
it's fixed with a simple line
now I need some help
how can I skipt 2 links in red rectangel (I mean that it'll not display in the portal) and if I want add some include with MOD,
how can I do (example with inc_login in the left hand, some last Posts below Homepage Content...)

thanks ur help

..:: Welcome #Snitz in Dalnet ::..
Go to Top of Page
Page: of 11 Previous Topic Topic Next Topic  
Next Page
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.22 seconds. Powered By: Snitz Forums 2000 Version 3.4.07