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

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: MOD Implementation
 Problem with installing Portal MOD
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

alatar
Starting Member

4 Posts

Posted - 13 October 2005 :  13:26:52  Show Profile
I have followed the instructions in the readme, but when trying to run dbs_portal.asp I get the following output:


David's Portal Mod

Dropping Table..

Table does not exist
Dropping Table..

Table does not exist
Creating table(s)...
CREATE TABLE FORUM_CMS_CATEGORY( CAT_ID INT (11) DEFAULT '' NOT NULL auto_increment , CAT_TITLE varchar(20) NULL , CAT_ISLEFT smallint NULL DEFAULT 0, CAT_ORDER int NULL ,KEY FORUM_CMS_CATEGORY_CAT_ID(CAT_ID))
CREATE TABLE FORUM_CMS_CATEGORY( CAT_ID INT (11) DEFAULT '' NOT NULL auto_increment , CAT_TITLE varchar(20) NULL , CAT_ISLEFT smallint NULL DEFAULT 0, CAT_ORDER int NULL ,KEY FORUM_CMS_CATEGORY_CAT_ID(CAT_ID))
-2147217871 | Invalid default value for 'CAT_ID'

Creating table(s)...
CREATE TABLE FORUM_CMS_CONTENT( CONT_ID INT (11) DEFAULT '' NOT NULL auto_increment , CAT_ID int NULL , CONT_TITLE varchar(100) NULL , CONT_SUMMARY text 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,KEY FORUM_CMS_CONTENT_CONT_ID(CONT_ID))
CREATE TABLE FORUM_CMS_CONTENT( CONT_ID INT (11) DEFAULT '' NOT NULL auto_increment , CAT_ID int NULL , CONT_TITLE varchar(100) NULL , CONT_SUMMARY text 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,KEY FORUM_CMS_CONTENT_CONT_ID(CONT_ID))
-2147217871 | Invalid default value for 'CONT_ID'

Adding new records..
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('strCMSLeftNavWidth','150')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('strCMSLeftNavDisplay','5')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('strCMSLeftNavItems','1')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('strCMSRightNavWidth','150')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('strCMSRightNavDisplay','5')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('strCMSRightNavItems','1')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('strCMSEnableSearch','1')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('strCMSDefaultCID','0')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('strCMSPageTitle','Portal')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('strCMSTitleDisplay','1')

Value(s) updated successfully


I have not changed the dbs_portal.asp file at all, and this is a working install of Snitz. I've been racking my brain trying to find a solution. Tried both the search function of the forum here, as well as Google to no avail. Any help would be appreciated. Thanks.

Ranko
Junior Member

400 Posts

Posted - 14 October 2005 :  03:46:49  Show Profile
That is a OK.

First the dbs tryed to drop the existing tables, found they didn't exist and created them. If it is not working, run setup.asp and see if it works then.
Go to Top of Page

alatar
Starting Member

4 Posts

Posted - 14 October 2005 :  13:39:18  Show Profile
quote:
Originally posted by Ranko

That is a OK.

First the dbs tryed to drop the existing tables, found they didn't exist and created them. If it is not working, run setup.asp and see if it works then.



After running setup.asp, all changes were made to config.asp and admin_home.asp. Trying to access portal.asp gives the following error:

Microsoft OLE DB Provider for ODBC Drivers error '80040e37'

Table 'mysql.forum_cms_content' doesn't exist

/forum/portal.asp, line 201

When I check the database using MySQL Administrator, I do not see the new entries listed.
Go to Top of Page

Ranko
Junior Member

400 Posts

Posted - 15 October 2005 :  07:02:43  Show Profile
Did you try using alternative mod setup page?
Go to Top of Page

modifichicci
Average Member

Italy
787 Posts

Posted - 15 October 2005 :  08:38:03  Show Profile  Visit modifichicci's Homepage
MySql doesn't like a default value for fields auto increment
Delete the default value from the dbs for the fields:
FORUM_CMS_CATEGORY CAT_ID
FORUM_CMS_CONTENT CONT_ID

Ernia e Laparocele
Forum di Ernia e Laparocele
Acces - MySql Migration Tutorial
Adamantine forum
Go to Top of Page

alatar
Starting Member

4 Posts

Posted - 15 October 2005 :  11:54:26  Show Profile
quote:
Originally posted by modifichicci

MySql doesn't like a default value for fields auto increment
Delete the default value from the dbs for the fields:
FORUM_CMS_CATEGORY CAT_ID
FORUM_CMS_CONTENT CONT_ID



I don't see any default values, where would I delete them?

Edited by - alatar on 15 October 2005 11:55:11
Go to Top of Page

modifichicci
Average Member

Italy
787 Posts

Posted - 15 October 2005 :  13:53:58  Show Profile  Visit modifichicci's Homepage
What is your dbs_portal.asp ? This file set the values for the fields, and in some code it has the create command with values..I don't know that file, post a text link to it...

Ernia e Laparocele
Forum di Ernia e Laparocele
Acces - MySql Migration Tutorial
Adamantine forum
Go to Top of Page

Ranko
Junior Member

400 Posts

Posted - 16 October 2005 :  06:11:39  Show Profile
You delete them from the dbs file. Open it with notepad and you will see the values.
Go to Top of Page

alatar
Starting Member

4 Posts

Posted - 16 October 2005 :  14:58:03  Show Profile
This is the text of the dbs_portal.asp that I DL'd:

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#text#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]

I tried just deleting the line CAT_ID from the CMS_CATEGORY section and CONT_ID from the CMS_CONTENT section. This is the output I get:


David's Portal Mod

Dropping Table..

Table does not exist
Dropping Table..

Table does not exist
Creating table(s)...
CREATE TABLE FORUM_CMS_CATEGORY( CAT_TITLE#VARCHAR(20)#NULL# INT (11) DEFAULT '' NOT NULL auto_increment , CAT_ISLEFT smallint NULL DEFAULT 0, CAT_ORDER int NULL ,KEY FORUM_CMS_CATEGORY_CAT_TITLE#VARCHAR(20)#NULL#(CAT_TITLE#VARCHAR(20)#NULL#))
Table already exists

Creating table(s)...
CREATE TABLE FORUM_CMS_CONTENT( CAT_ID#INT#NULL# INT (11) DEFAULT '' NOT NULL auto_increment , CONT_TITLE varchar(100) NULL , CONT_SUMMARY text 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,KEY FORUM_CMS_CONTENT_CAT_ID#INT#NULL#(CAT_ID#INT#NULL#))
Table already exists

Adding new records..
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('strCMSLeftNavWidth','150')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('strCMSLeftNavDisplay','5')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('strCMSLeftNavItems','1')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('strCMSRightNavWidth','150')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('strCMSRightNavDisplay','5')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('strCMSRightNavItems','1')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('strCMSEnableSearch','1')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('strCMSDefaultCID','0')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('strCMSPageTitle','Portal')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('strCMSTitleDisplay','1')

Value(s) updated successfully

Database setup finished

Yes, I have tried the alternative mod setup page and I get the same results. When I examine the DB, the Tables do not exist, so I can;t understand why it says that the Table already exists. This is beginning to get frustrating.

Edited by - alatar on 16 October 2005 15:01:35
Go to Top of Page

modifichicci
Average Member

Italy
787 Posts

Posted - 16 October 2005 :  16:03:56  Show Profile  Visit modifichicci's Homepage
What MySql version is running?
What is your MySql driver on the server?
Is the string connection right?

Ernia e Laparocele
Forum di Ernia e Laparocele
Acces - MySql Migration Tutorial
Adamantine forum
Go to Top of Page
  Previous Topic Topic Next Topic  
 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.28 seconds. Powered By: Snitz Forums 2000 Version 3.4.07