Author |
Topic  |
|
alatar
Starting Member
4 Posts |
Posted - 13 October 2005 : 13:26:52
|
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
|
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. |
 |
|
alatar
Starting Member
4 Posts |
Posted - 14 October 2005 : 13:39:18
|
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. |
 |
|
Ranko
Junior Member
 
400 Posts |
Posted - 15 October 2005 : 07:02:43
|
Did you try using alternative mod setup page? |
 |
|
modifichicci
Average Member
  
Italy
787 Posts |
|
alatar
Starting Member
4 Posts |
Posted - 15 October 2005 : 11:54:26
|
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 |
 |
|
modifichicci
Average Member
  
Italy
787 Posts |
|
Ranko
Junior Member
 
400 Posts |
Posted - 16 October 2005 : 06:11:39
|
You delete them from the dbs file. Open it with notepad and you will see the values. |
 |
|
alatar
Starting Member
4 Posts |
Posted - 16 October 2005 : 14:58:03
|
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 |
 |
|
modifichicci
Average Member
  
Italy
787 Posts |
|
|
Topic  |
|
|
|