quote:

---

Originally posted by ruirib

http://forum.snitz.com/forum/topic.asp?ARCHIVE=true&TOPIC_ID=52219

---

quote:

---

Originally posted by ruirib

Anyway, your problem is with the definition of RULES_ID, and there was no such field in the posted code.

---

[CREATE]
FAQ
F_ID
F_FAQ_QUESTION#VARCHAR (100)#NULL#
F_FAQ_ANSWER#memo#NULL#
F_FAQ_ORDER#int#NULL#1#
F_FAQ_CATEGORY#int#NULL#1#
F_FAQ_TYPE#int#NULL#0#
[END]
[CREATE]
FAQ_CATEGORY
FCAT_ID
FCAT_TITLE#varchar(100)#NULL#
FCAT_ORDER#int#NULL#1#
FCAT_LEVEL#int#NULL#
[END]

Database Update


Creating table(s)...
CREATE TABLE FORUM_FAQ( F_ID INT (11) DEFAULT '' NOT NULL auto_increment , F_FAQ_QUESTION varchar (100) NULL , F_FAQ_ANSWER text NULL , F_FAQ_ORDER int NULL DEFAULT 1, F_FAQ_CATEGORY int NULL DEFAULT 1, F_FAQ_TYPE int NULL DEFAULT 0,KEY FORUM_FAQ_F_ID(F_ID))
CREATE TABLE FORUM_FAQ( F_ID INT (11) DEFAULT '' NOT NULL auto_increment , F_FAQ_QUESTION varchar (100) NULL , F_FAQ_ANSWER text NULL , F_FAQ_ORDER int NULL DEFAULT 1, F_FAQ_CATEGORY int NULL DEFAULT 1, F_FAQ_TYPE int NULL DEFAULT 0,KEY FORUM_FAQ_F_ID(F_ID))
-2147217871 | [MySQL][ODBC 3.51 Driver][mysqld-4.1.15-nt]Invalid default value for 'F_ID'

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

Creating table(s)...
CREATE TABLE FORUM_FAQ_CATEGORY( FCAT_ID INT (11) DEFAULT '' NOT NULL auto_increment , FCAT_TITLE varchar(100) NULL , FCAT_ORDER int NULL DEFAULT 1, FCAT_LEVEL int NULL ,KEY FORUM_FAQ_CATEGORY_FCAT_ID(FCAT_ID))
CREATE TABLE FORUM_FAQ_CATEGORY( FCAT_ID INT (11) DEFAULT '' NOT NULL auto_increment , FCAT_TITLE varchar(100) NULL , FCAT_ORDER int NULL DEFAULT 1, FCAT_LEVEL int NULL ,KEY FORUM_FAQ_CATEGORY_FCAT_ID(FCAT_ID))
-2147217871 | [MySQL][ODBC 3.51 Driver][mysqld-4.1.15-nt]Invalid default value for 'FCAT_ID'

quote:

---

Originally posted by ruirib

And the fix is posted on the link above, in my starting post. Just follow Davio's instructions to change the code.

---

quote:

---

Originally posted by modifichicci

You need to modify also admin_mod_dbsetup.asp and admin_mod_dbsetup2.asp.
These files have the same error as inc_create_forum_mysql.asp setting a default value for autoincrement field in mysql.

Search for autoincrement and delete the DEFAULT '' before.

There is a post (from Davio i think...) about it but i cannot find at this moment.

---