Author |
Topic |
|
rick7165
Senior Member
USA
1094 Posts |
Posted - 14 June 2001 : 13:49:12
|
If you get a second can you send me the mod_dbsetup.asp files for your forum code so I can setup SQL the one I have gives me some errors.
Thanks, Rick
Test Site www.eastpasco.com HuwR's SR4 release. Colors and Graphic scheme done by Richard Kinser. |
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
|
rick7165
Senior Member
USA
1094 Posts |
Posted - 18 June 2001 : 12:16:12
|
HuwR... do you have the dbs file for this?
Test Site www.eastpasco.com HuwR's SR4 release. Colors and Graphic scheme done by Richard Kinser. |
|
|
rick7165
Senior Member
USA
1094 Posts |
Posted - 18 June 2001 : 12:32:56
|
This is strange... I have all the .dbs files in the root... I can only see 1 of them with Admin_mod_dbsetup.asp and only can see the other ones in mod_dbsetup.asp, but all the files extensions are .dbs. I can only run your HuwdbMods.dbs with mod_dbsetup.asp and I get all these errors:
Huw's Forum DB Changes
Creating table(s)... CREATE TABLE FORUM_BOOKMARKS( BOOKMARK_ID int IDENTITY (1, 1) NOT NULL , B_MEMBERID int NOT NULL , B_TOPICID int NOT NULL ) Table created succesfully
--------------------------------------------------------------------------------
Creating table(s)... CREATE TABLE FORUM_POLL( ID int IDENTITY (1, 1) NOT NULL , question nvarchar(255) NOT NULL , answer1 nvarchar(50) NOT NULL , count1 int NOT NULL , answer2 nvarchar(50) NOT NULL , count2 int NOT NULL , answer3 nvarchar(50) NOT NULL , count3 int NOT NULL , answer4 nvarchar(50) NOT NULL , count4 int NOT NULL , answer5 nvarchar(50) NOT NULL , count5 int NOT NULL , answer6 nvarchar(50) NOT NULL , count6 int NOT NULL , answer7 nvarchar(50) NOT NULL , count7 int NOT NULL , answer8 nvarchar(50) NOT NULL , count8 int NOT NULL , createdwhen smalldatetime NOT NULL , active bit NOT NULL ) Table created succesfully
--------------------------------------------------------------------------------
Creating table(s)... CREATE TABLE FORUM_VOTELOG( ID int IDENTITY (1, 1) NOT NULL , poll_id int NOT NULL , ip nvarchar(20) NOT NULL , datum date NOT NULL ) -2147217900 | [Microsoft][ODBC SQL Server Driver][SQL Server]Column or parameter #4: Cannot find data type date.
--------------------------------------------------------------------------------
Creating table(s)... CREATE TABLE FORUM_ANNOUNCE( A_ID int IDENTITY (1, 1) NOT NULL , A_AUTHOR nvarchar(50) NOT NULL , A_SUBJECT nvarchar(50) NOT NULL , A_MESSAGE text NOT NULL , A_START_DATE nvarchar(50) NOT NULL , A_END_DATE nvarchar(50) NOT NULL ) Table created succesfully
--------------------------------------------------------------------------------
Creating table(s)... CREATE TABLE FORUM_MODS( M_NAME nvarchar(50) NOT NULL , M_CODE nvarchar(50) NOT NULL , M_VALUE ntext NOT NULL ) Table created succesfully
--------------------------------------------------------------------------------
Creating table(s)... CREATE TABLE FORUM_SMILE_CAT( CAT_ID int IDENTITY (1, 1) NOT NULL , CAT_NAME nvarchar (40) NULL ) Table created succesfully
--------------------------------------------------------------------------------
Creating table(s)... CREATE TABLE FORUM_SMILES( ID int IDENTITY (1, 1) NOT NULL , SMILE_URL nvarchar (40) NOT NULL , SMILE_CODE nvarchar (10) NOT NULL , SMILE_NAME nvarchar (20) NOT NULL , CAT_ID int NOT NULL DEFAULT 1) Table created succesfully
--------------------------------------------------------------------------------
Creating table(s)... CREATE TABLE FORUM_USERFILES( F_FILEID int IDENTITY (1, 1) NOT NULL , MEMBER_ID int NOT NULL , F_FILENAME nvarchar (255) NOT NULL , F_FILESIZE int NULL , F_REPLY_ID int NULL , F_TOPIC_ID int NULL ) Table created succesfully
--------------------------------------------------------------------------------
Creating table(s)... CREATE TABLE FORUM_EMAIL_CONFIG( M_TYPE nvarchar (15) NULL , M_SUBJECT nvarchar (100) NULL , M_MESSAGE ntext NULL ) Table created succesfully
--------------------------------------------------------------------------------
Creating table(s)... CREATE TABLE FORUM_PM( M_ID int IDENTITY (1, 1) NOT NULL , M_SUBJECT nvarchar (50) NULL , M_FROM int NULL , M_TO int NULL , M_SENT nvarchar (50) NULL , M_MESSAGE ntext NULL , M_PMCOUNT nvarchar (50) NULL , M_READ int NULL DEFAULT 0, M_MAIL nvarchar (50) NULL , M_OUTBOX smallint NULL ) Table created succesfully
--------------------------------------------------------------------------------
Creating table(s)... CREATE TABLE FORUM_USERFIELDS( USR_FIELD_ID int IDENTITY (1, 1) NOT NULL , USR_LABEL nvarchar (40) NULL , USR_FIELDTYPE nvarchar (1) NULL , USR_SHORTNAME nvarchar (10) NOT NULL ) Table created succesfully
--------------------------------------------------------------------------------
Creating table(s)... CREATE TABLE FORUM_MEMBERFIELDS( MEMBER_ID int NOT NULL , USR_FIELD_ID smallint NOT NULL , USR_VALUE nvarchar (50) NULL ) 9 | Subscript out of range
--------------------------------------------------------------------------------
Creating table(s)... CREATE TABLE FORUM_ONLINE( UserID nvarchar (100) NOT NULL , UserIP nvarchar (40) NOT NULL , LastChecked nvarchar (100) NOT NULL , DateCreated nvarchar (100) NOT NULL , CheckedIn nvarchar (100) NOT NULL , M_BROWSE nvarchar (255) NOT NULL ) Table created succesfully
--------------------------------------------------------------------------------
Adding Column... ALTER TABLE FORUM_MEMBERS ADD M_PMEMAIL int NULL DEFAULT 0 Column added succesfully Updating Current Records UPDATE FORUM_MEMBERS SET M_PMEMAIL=0 Adding Column... ALTER TABLE FORUM_MEMBERS ADD M_ALLOWDOWNLOADS int NULL DEFAULT 1 Column added succesfully Updating Current Records UPDATE FORUM_MEMBERS SET M_ALLOWDOWNLOADS=1 Adding Column... ALTER TABLE FORUM_MEMBERS ADD M_ALLOWUPLOADS int NULL DEFAULT 1 Column added succesfully Updating Current Records UPDATE FORUM_MEMBERS SET M_ALLOWUPLOADS=1 Table(s) updated
--------------------------------------------------------------------------------
Adding Column... ALTER TABLE FORUM_FORUM ADD F_CREATED nvarchar (40) NULL Column added succesfully Adding Column... ALTER TABLE FORUM_FORUM ADD FORUM_ORDER int NULL DEFAULT 1 Column added succesfully Updating Current Records UPDATE FORUM_FORUM SET FORUM_ORDER=1 Adding Column... ALTER TABLE FORUM_FORUM ADD F_HIDDEN smallint NULL DEFAULT 0 Column added succesfully Updating Current Records UPDATE FORUM_FORUM SET F_HIDDEN=0 Adding Column... ALTER TABLE FORUM_FORUM ADD F_URLIMAGE nvarchar(100) NOT NULL -2147217900 | [Microsoft][ODBC SQL Server Driver][SQL Server]ALTER TABLE only allows columns to be added that can contain nulls or have a DEFAULT definition specified. Column 'F_URLIMAGE' cannot be added to table 'FORUM_FORUM' because it does not allow nulls and does not specify a DEFAULT definition. Table(s) updated
--------------------------------------------------------------------------------
Adding Column... ALTER TABLE FORUM_CONFIG ADD C_INTUSERFIELDS smallint NULL DEFAULT 1 Column added succesfully Updating Current Records UPDATE FORUM_CONFIG SET C_INTUSERFIELDS=1 Table(s) updated
--------------------------------------------------------------------------------
Adding Column... ALTER TABLE FORUM_CATEGORY ADD CAT_ORDER int NULL DEFAULT 1 Column added succesfully Updating Current Records UPDATE FORUM_CATEGORY SET CAT_ORDER=1 Table(s) updated
--------------------------------------------------------------------------------
Adding new records.. INSERT INTO FORUM_SMILE_CAT (CAT_NAME) VALUES ('Snitz') INSERT INTO FORUM_SMILE_CAT (CAT_NAME) VALUES ('Other')
Value(s) updated succesfully --------------------------------------------------------------------------------
Adding new records.. INSERT INTO FORUM_MODS (M_NAME,M_CODE,M_VALUE) VALUES ('Attachment','faMaxSize','512') INSERT INTO FORUM_MODS (M_NAME,M_CODE,M_VALUE) VALUES ('Attachment','faExtensions','.zip:.mdb:.txt:.asp') INSERT INTO FORUM_MODS (M_NAME,M_CODE,M_VALUE) VALUES ('HModEnable','Pmessages','1') INSERT INTO FORUM_MODS (M_NAME,M_CODE,M_VALUE) VALUES ('HModEnable','UserFields','1') INSERT INTO FORUM_MODS (M_NAME,M_CODE,M_VALUE) VALUES ('HModEnable','PollMentor','0') INSERT INTO FORUM_MODS (M_NAME,M_CODE,M_VALUE) VALUES ('HModEnable','SideMenu','0') INSERT INTO FORUM_MODS (M_NAME,M_CODE,M_VALUE) VALUES ('HModEnable','Attachment','0') INSERT INTO FORUM_MODS (M_NAME,M_CODE,M_VALUE) VALUES ('HModEnable','NewMemberPM','1') INSERT INTO FORUM_MODS (M_NAME,M_CODE,M_VALUE) VALUES ('HModEnable','imgURLPath','images/') INSERT INTO FORUM_MODS (M_NAME,M_CODE,M_VALUE) VALUES ('NewMemPM','Subject','Enter your subject line here') INSERT INTO FORUM_MODS (M_NAME,M_CODE,M_VALUE) VALUES ('NewMemPM','Message','Enter your message here') INSERT INTO FORUM_MODS (M_NAME,M_CODE,M_VALUE) VALUES ('NewMemPM','OnOff','0')
Value(s) updated succesfully --------------------------------------------------------------------------------
Adding new records.. INSERT INTO FORUM_SMILES (SMILE_URL,SMILE_CODE,SMILE_NAME,CAT_ID) VALUES ('icon_smile_angry.gif',':(!','Angry',1) INSERT INTO FORUM_SMILES (SMILE_URL,SMILE_CODE,SMILE_NAME,CAT_ID) VALUES ('icon_smile_blackeye.gif', 'B)', 'Black Eye',1) INSERT INTO FORUM_SMILES (SMILE_URL,SMILE_CODE,SMILE_NAME,CAT_ID) VALUES ('icon_smile_dissapprove.gif', 'V', 'Dissapprove',1) INSERT INTO FORUM_SMILES (SMILE_URL,SMILE_CODE,SMILE_NAME,CAT_ID) VALUES ('icon_smile_dead.gif', 'XX(', 'Dead',1) INSERT INTO FORUM_SMILES (SMILE_URL,SMILE_CODE,SMILE_NAME,CAT_ID) VALUES ('icon_smile_shock.gif', ':O', 'Shocked',1) INSERT INTO FORUM_SMILES (SMILE_URL,SMILE_CODE,SMILE_NAME,CAT_ID) VALUES ('icon_smile_approve.gif', '^', 'Approve',1) INSERT INTO FORUM_SMILES (SMILE_URL,SMILE_CODE,SMILE_NAME,CAT_ID) VALUES ('icon_smile_question.gif', '?', 'Question?',1) INSERT INTO FORUM_SMILES (SMILE_URL,SMILE_CODE,SMILE_NAME,CAT_ID) VALUES ('icon_smile_blush.gif', ':I', 'Blushing',1) INSERT INTO FORUM_SMILES (SMILE_URL,SMILE_CODE,SMILE_NAME,CAT_ID) VALUES ('icon_smile_sad.gif', ':(', 'Sad',1) INSERT INTO FORUM_SMILES (SMILE_URL,SMILE_CODE,SMILE_NAME,CAT_ID) VALUES ('icon_smile_shy.gif', '8)', 'Shy',1) INSERT INTO FORUM_SMILES (SMILE_URL,SMILE_CODE,SMILE_NAME,CAT_ID) VALUES ('icon_smile.gif', ':)', 'Smile:)',1) INSERT INTO FORUM_SMILES (SMILE_URL,SMILE_CODE,SMILE_NAME,CAT_ID) VALUES ('icon_smile_evil.gif', '}:)', 'Evil',1) INSERT INTO FORUM_SMILES (SMILE_URL,SMILE_CODE,SMILE_NAME,CAT_ID) VALUES ('icon_smile_big.gif', ':D', 'Big Smile',1) INSERT INTO FORUM_SMILES (SMILE_URL,SMILE_CODE,SMILE_NAME,CAT_ID) VALUES ('icon_smile_cool.gif', '8D', 'Cool Guy',1) INSERT INTO FORUM_SMILES (SMILE_URL,SMILE_CODE,SMILE_NAME,CAT_ID) VALUES ('icon_smile_sleepy.gif', '|)', 'Sleepy/Tired',1) INSERT INTO FORUM_SMILES (SMILE_URL,SMILE_CODE,SMILE_NAME,CAT_ID) VALUES ('icon_smile_clown.gif', ':o)', 'Clown',1) INSERT INTO FORUM_SMILES (SMILE_URL,SMILE_CODE,SMILE_NAME,CAT_ID) VALUES ('icon_smile_kisses.gif', ':X', 'Kisses',1) INSERT INTO FORUM_SMILES (SMILE_URL,SMILE_CODE,SMILE_NAME,CAT_ID) VALUES ('icon_smile_tongue.gif', ':p', 'Tongue :P',1) INSERT INTO FORUM_SMILES (SMILE_URL,SMILE_CODE,SMILE_NAME,CAT_ID) VALUES ('icon_smile_wink.gif', ' INSERT INTO FORUM_SMILES (SMILE_URL,SMILE_CODE,SMILE_NAME,CAT_ID) VALUES ('icon_smile_8ball.gif', '8', '8 Ball',1) -2147217900 | [Microsoft][ODBC SQL Server Driver][SQL Server]Unclosed quotation mark before the character string ''.
--------------------------------------------------------------------------------
Updating Forum Values.. UPDATE FORUM_FORUM SET F_HIDDEN = 1 WHERE F_PRIVATEFORUMS IN (5,6,8)
Value(s) updated succesfully --------------------------------------------------------------------------------
Edited by - rick7165 on 18 June 2001 12:41:00
Edited by - rick7165 on 18 June 2001 12:43:31 |
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 18 June 2001 : 13:36:04
|
the admin_mod_dbsetup.asp takes a different format file name
ie dbs_FILENAME.asp this is to prevent the files from being downloaded easily
|
|
|
rick7165
Senior Member
USA
1094 Posts |
Posted - 18 June 2001 : 13:42:50
|
How do I fix the above problem? I got those errors in red
I'm trying to install the forum into SQL... I did a fresh install and ran the setup.asp file and the Forum Admin setup. Then ran your Mod setup file and those where the errors I got.
Test Site www.eastpasco.com HuwR's SR4 release. Colors and Graphic scheme done by Richard Kinser.
Edited by - rick7165 on 18 June 2001 13:45:36 |
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 18 June 2001 : 21:41:31
|
quote:
Creating table(s)... CREATE TABLE FORUM_VOTELOG( ID int IDENTITY (1, 1) NOT NULL , poll_id int NOT NULL , ip nvarchar(20) NOT NULL , datum date NOT NULL ) -2147217900 | [Microsoft][ODBC SQL Server Driver][SQL Server]Column or parameter #4: Cannot find data type date.
In the dbs file, change date to smalldatetime
quote:
Creating table(s)... CREATE TABLE FORUM_MEMBERFIELDS( MEMBER_ID int NOT NULL , USR_FIELD_ID smallint NOT NULL , USR_VALUE nvarchar (50) NULL ) 9 | Subscript out of range
in the dbs file, find the [CREATE] section for MEMBERFIELDS, one of the lines has a missing ; at the end of one of the lines
quote:
Adding Column... ALTER TABLE FORUM_FORUM ADD F_URLIMAGE nvarchar(100) NOT NULL -2147217900 | [Microsoft][ODBC SQL Server Driver][SQL Server]ALTER TABLE only allows columns to be added that can contain nulls or have a DEFAULT definition specified. Column 'F_URLIMAGE' cannot be added to table 'FORUM_FORUM' because it does not allow nulls and does not specify a DEFAULT definition. Table(s) updated
Change the NOT NULL to NULL for F_URLIMAGE
quote:
INSERT INTO FORUM_SMILES (SMILE_URL,SMILE_CODE,SMILE_NAME,CAT_ID) VALUES ('icon_smile_wink.gif', ' INSERT INTO FORUM_SMILES (SMILE_URL,SMILE_CODE,SMILE_NAME,CAT_ID) VALUES ('icon_smile_8ball.gif', '8', '8 Ball',1) -2147217900 | [Microsoft][ODBC SQL Server Driver][SQL Server]Unclosed quotation mark before the character string ''.
Ok, this is why I changed from using the ; as a seperator, and started using the #, what has happened is, it has split one of the lines, because one of the fields contained a ; Just add the record for by hand.
|
|
|
pfilias
New Member
69 Posts |
Posted - 09 July 2001 : 14:41:18
|
I need the default DBS file for the admin_mod_dbsetup.asp. This is killing me. I wish someone could help me.
|
|
|
|
Topic |
|
|
|