esser
Starting Member
United Kingdom
14 Posts |
Posted - 10 January 2006 : 18:19:21
|
Sorry about this loooong post. But I can't seem to work out why I get these errors (in red):
quote: Creating table(s)... CREATE TABLE FORUM_RULES( RULES_ID INT (11) DEFAULT '' NOT NULL auto_increment , RULES_TITLE varchar (100) NULL , RULES_DESCRIPTION text NULL , RULES_ORDER int NULL DEFAULT 1, RULES_CAT int NULL ,KEY FORUM_RULES_RULES_ID(RULES_ID)) CREATE TABLE FORUM_RULES( RULES_ID INT (11) DEFAULT '' NOT NULL auto_increment , RULES_TITLE varchar (100) NULL , RULES_DESCRIPTION text NULL , RULES_ORDER int NULL DEFAULT 1, RULES_CAT int NULL ,KEY FORUM_RULES_RULES_ID(RULES_ID)) -2147217871 | [MySQL][ODBC 3.51 Driver][mysqld-4.1.11-log]Invalid default value for 'RULES_ID'
--------------------------------------------------------------------------------
Creating table(s)... CREATE TABLE FORUM_RULES_CATEGORY( RCAT_ID INT (11) DEFAULT '' NOT NULL auto_increment , RCAT_TITLE varchar (100) NULL , RCAT_ORDER int NULL DEFAULT 1,KEY FORUM_RULES_CATEGORY_RCAT_ID(RCAT_ID)) CREATE TABLE FORUM_RULES_CATEGORY( RCAT_ID INT (11) DEFAULT '' NOT NULL auto_increment , RCAT_TITLE varchar (100) NULL , RCAT_ORDER int NULL DEFAULT 1,KEY FORUM_RULES_CATEGORY_RCAT_ID(RCAT_ID)) -2147217871 | [MySQL][ODBC 3.51 Driver][mysqld-4.1.11-log]Invalid default value for 'RCAT_ID'
--------------------------------------------------------------------------------
Adding new records.. INSERT INTO FORUM_RULES_CATEGORY (RCAT_TITLE) VALUES ('General') INSERT INTO FORUM_RULES_CATEGORY (RCAT_TITLE) VALUES ('General') -2147217865 | [MySQL][ODBC 3.51 Driver][mysqld-4.1.11-log]Table 'web97308.FORUM_RULES_CATEGORY' doesn't exist
I know that it's me being stupid... Can anybody help ??
|
|