During setup of the Snitz Forums using MySQL Server 4.0 and greater as your database, you will get several "Invalid default value" errors for several auto_increment fields. This is due to the changes in version 4.0 and greater, because a DEFAULT value is no longer required to be specified.
In inc_create_forum_mysql.asp, search for AUTO_INCREMENT in the file and remove the DEFAULT value from the left side of it.
For example:strSql = "CREATE TABLE " & strTablePrefix & "CATEGORY ( "
strSql = strSql & "CAT_ID INT (11) DEFAULT '' NOT NULL auto_increment, "
strSql = strSql & "CAT_STATUS SMALLINT (6) DEFAULT '1' NOT NULL , "
You would remove the code in red.
Another example:strSql = "CREATE TABLE " & strTablePrefix & "FORUM ( "
strSql = strSql & "CAT_ID int (11) DEFAULT '1' NOT NULL , "
strSql = strSql & "FORUM_ID smallint (6) DEFAULT '0' NOT NULL auto_increment, "
strSql = strSql & "F_STATUS smallint (6) DEFAULT '1', "
You would remove the code in red.
Note that not all the AUTO_INCREMENT fields you find will have a DEFAULT value set. Those can be ignored.<
Forum Locked
Topic Locked
Posted - 06 August 2006 : 23:18:38
