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
 Forum Rules v1.3 MOD errors
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

esser
Starting Member

United Kingdom
14 Posts

Posted - 10 January 2006 :  18:19:21  Show Profile
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 ??

esser
Starting Member

United Kingdom
14 Posts

Posted - 13 January 2006 :  17:25:09  Show Profile
If anybody encounter this problem see topic "'SITESTAT_ID' problem" for the solution.

I had the problem on several MOD installations "Invalid default value for.."

//esser
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