wmcavoy
Starting Member
2 Posts |
Posted - 20 June 2001 : 19:54:52
|
When trying to install the User Fields mod, the following errors occur.. it does appear that something is getting cut off at the end of the first and third create table with the key setup.. If anyone can assist I would be greatly appreciative..
User Fields Mod
Creating table(s)... CREATE TABLE FORUM_MODS( M_NAME varchar(50) NOT NULL , M_CODE varchar(50) NOT NULL , M_VALUE text NULL ,KEY FORUM_MODS_()) -2147217911 | [TCX][MyODBC]You have an error in your SQL syntax near '))' at line 1
--------------------------------------------------------------------------------
Creating table(s)... CREATE TABLE FORUM_USERFIELDS( USR_FIELD_ID INT (11) DEFAULT '' NOT NULL auto_increment , USR_LABEL varchar (40) NULL , USR_FIELDTYPE varchar (1) NULL , USR_SHORTNAME varchar (10) NOT NULL ,KEY FORUM_USERFIELDS_USR_FIELD_ID(USR_FIELD_ID)) Table created succesfully
--------------------------------------------------------------------------------
Creating table(s)... CREATE TABLE FORUM_MEMBERFIELDS( MEMBER_ID int NOT NULL , USR_FIELD_ID int NOT NULL , USR_VALUE varchar (50) NULL ,KEY FORUM_MEMBERFIELDS_()) -2147217911 | [TCX][MyODBC]You have an error in your SQL syntax near '))' at line 1
--------------------------------------------------------------------------------
Updating Forum Values.. DELETE FROM FORUM_MODS WHERE (M_NAME = 'HModEnable' AND M_CODE = 'UserFields') -2147467259 | [TCX][MyODBC]Table 'forum.forum_mods' doesn't exist
--------------------------------------------------------------------------------
Adding new records.. INSERT INTO FORUM_MODS (M_NAME,M_CODE,M_VALUE) VALUES ('HModEnable','UserFields','1') -2147467259 | [TCX][MyODBC]Table 'forum.forum_mods' doesn't exist
--------------------------------------------------------------------------------
Thanks in advance for any assistance Wayne
|
|