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
 User Fields mod problem.
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

ABravNewWorld
Starting Member

USA
9 Posts

Posted - 08 June 2001 :  15:57:20  Show Profile  Visit ABravNewWorld's Homepage  Send ABravNewWorld an AOL message
Everything installe dfine except for one thing:

Creating table(s)...
CREATE TABLE FORUM_MODS( M_NAME varchar(50) NOT NULL , M_CODE varchar(50) NOT NULL , M_VALUE memo NULL )
Table created succesfully

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

Creating table(s)...
CREATE TABLE FORUM_USERFIELDS( USR_FIELD_ID COUNTER CONSTRAINT PrimaryKey PRIMARY KEY , USR_LABEL text (40) NULL , USR_FIELDTYPE text (1) NULL , USR_SHORTNAME text (10) NOT NULL )
Table created succesfully

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

Creating table(s)...
CREATE TABLE FORUM_MEMBERFIELDS( MEMBER_ID int NOT NULL , USR_FIELD_ID int NOT NULL , USR_VALUE text (50) NULL )
Table created succesfully

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

Updating Forum Values..
DELETE FROM FORUM_MODS WHERE (M_NAME = 'HModEnable' AND M_CODE = 'UserFields')
13 | Type mismatch

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

Adding new records..
INSERT INTO FORUM_MODS (M_NAME,M_CODE,M_VALUE) VALUES ('HModEnable','UserFields','1')

Value(s) updated succesfully
--------------------------------------------------------------------------------
There were errors please post a question in the MOD Implementation Forum at
Snitz Forums



Can you give me a hand as to the problem?

Thomas G.
"The best view of one's soul is from beyond the edge of looking back."

Rawly
Starting Member

United Kingdom
41 Posts

Posted - 08 June 2001 :  16:13:24  Show Profile  Visit Rawly's Homepage  Send Rawly an AOL message  Send Rawly an ICQ Message  Send Rawly a Yahoo! Message
I had a similar problem
Did you use
admin_mod_dbsetup.asp
or
mod_dbsetup.asp
to setup the database?

I didnt use the file that came with the zip after I got errors and it workd fine



Rawly
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20584 Posts

Posted - 12 June 2001 :  20:45:52  Show Profile  Visit HuwR's Homepage
The only statement which failed, is a deleteion, which just means you did not have the data being deleted. are you experiencing other problems ?

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.29 seconds. Powered By: Snitz Forums 2000 Version 3.4.07