| Author |
 Topic  |
|
|
Eraxxer
Starting Member
18 Posts |
 Posted - 14 October 2006 : 19:05:25
|
Hello,
Have my own server running windows 2003 server, IIS, have on database folder full permissions. I'm using latest version of MySQL and using ODBC 3.51 MYSQL driver. On the page "Installation of Forum tables in the database I get these error messages,
Error: -2147217871 [MySQL][ODBC 3.51 Driver][mysqld-5.0.24a-community-nt]Invalid default value for 'CAT_ID'
strSql: CREATE TABLE FORUM_CATEGORY ( CAT_ID INT (11) DEFAULT '' NOT NULL auto_increment, CAT_STATUS SMALLINT (6) DEFAULT '1' NOT NULL , CAT_NAME VARCHAR (100) DEFAULT '', CAT_MODERATION int (11) DEFAULT '0', CAT_SUBSCRIPTION int (11) DEFAULT '0', CAT_ORDER int (11) DEFAULT '1', PRIMARY KEY (CAT_ID), KEY FORUM_CATEGORY_CAT_ID(CAT_ID), KEY FORUM_CATEGORY_CAT_STATUS (CAT_STATUS) )
Error: -2147217871 [MySQL][ODBC 3.51 Driver][mysqld-5.0.24a-community-nt]Invalid default value for 'FORUM_ID'
strSql: CREATE TABLE FORUM_FORUM ( CAT_ID int (11) DEFAULT '1' NOT NULL , FORUM_ID smallint (6) DEFAULT '0' NOT NULL auto_increment, F_STATUS smallint (6) DEFAULT '1', F_MAIL smallint (6) DEFAULT '1' , F_SUBJECT VARCHAR (100) DEFAULT '' , F_URL VARCHAR (255) DEFAULT '' , F_DESCRIPTION TEXT DEFAULT '' , F_TOPICS int (11) DEFAULT '0' , F_COUNT int (11) DEFAULT '0' , F_LAST_POST VARCHAR (14) DEFAULT '' , F_PASSWORD_NEW VARCHAR (255) DEFAULT '' , F_PRIVATEFORUMS int (11) DEFAULT '0' , F_TYPE smallint (6) DEFAULT '0' , F_IP VARCHAR (15) DEFAULT '000.000.000.000' , F_LAST_POST_AUTHOR int (11) DEFAULT '1' , F_LAST_POST_TOPIC_ID int (11) DEFAULT '0' , F_LAST_POST_REPLY_ID int (11) DEFAULT '0' , F_MODERATION int (11) DEFAULT '0', F_SUBSCRIPTION int (11) DEFAULT '0' , F_ORDER int (11) DEFAULT '1' , F_DEFAULTDAYS int (11) DEFAULT '30' , F_COUNT_M_POSTS smallint (6) DEFAULT '1' , F_L_ARCHIVE VARCHAR (14) DEFAULT '' , F_ARCHIVE_SCHED int (11) DEFAULT '30' , F_L_DELETE VARCHAR (14) DEFAULT '' , F_DELETE_SCHED int (11) DEFAULT '365' , F_A_TOPICS int (11) DEFAULT '0' , F_A_COUNT int (11) DEFAULT '0' , PRIMARY KEY (CAT_ID, FORUM_ID), KEY FORUM_FORUM_FORUM_ID(FORUM_ID), KEY FORUM_FORUM_CAT_ID(CAT_ID))
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 14 October 2006 : 20:33:58
|
Nope. All those are fixed the 3.4.06. Must be an older version.
Try using the latest version of the Snitz Forums. |
Support Snitz Forums
|
 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 14 October 2006 : 20:42:36
|
quote:
Originally posted by Davio
Nope. All those are fixed the 3.4.06. Must be an older version.
Try using the latest version of the Snitz Forums.
That's what I thought, thus my question... |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 15 October 2006 : 00:48:59
|
MySQL 5 seems to be distributed differently on linux vs. windows. At least for me, MySQL 5.0.22 on Fedora doesn't have the new STRICT setting enabled but the same version on W32 does, which causes MySQL to handle default values and not null differently.
For example, F_A_COUNT int (11) DEFAULT '0' will fail on my W32 mysql with strict enabled, due to the ' around a numeric value, but will work as expected on my Fedora mysql server.
There is a setting in my.ini that you can tweak also to get around these differences.
|
======
Doug G
======
Computer history and help at www.dougscode.com |
|
|
|
Eraxxer
Starting Member
18 Posts |
Posted - 15 October 2006 : 16:28:44
|
Hey Guys,
That was it. I downloaded the new version and installed it and took care of all but one problem:
Microsoft VBScript runtime error '800a000d'
Type mismatch
/default.asp, line 923
I going through search results and should bump into this resolution.
Thanks again, appreciate your help.
|
|
|
|
modifichicci
Average Member
Italy
787 Posts |
|
|
Eraxxer
Starting Member
18 Posts |
Posted - 15 October 2006 : 16:54:32
|
Actually on my last problem. I went into my config.asp file and put the ' back in front of my dns line.
'strConnString = "forumdb" '## DSN
That took of my mismatch problem.
Thanks again.
|
|
|
| |
Topic |
|
|
|
Topic Locked
