| Author |
 Topic  |
|
|
stonenajem
Starting Member
10 Posts |
 Posted - 10 June 2007 : 20:54:49
|
I've exhausted all possible solutions I found on the forums, so I'm posting to see if someone can help me with these five errors. This happens when I try to run the installation of forum-tables in the database. I apologize in advance, I'm not experienced with either mysql or snitz.
Error: -2147467259 [MySQL][ODBC 3.51 Driver][mysqld-5.0.41-community-nt]BLOB/TEXT column 'F_DESCRIPTION' can't have a default value
strSql: CREATE TABLE FORUM_FORUM ( CAT_ID int (11) DEFAULT '1' NOT NULL , FORUM_ID smallint (6) 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))
Error: -2147467259 [MySQL][ODBC 3.51 Driver][mysqld-5.0.41-community-nt]BLOB/TEXT column 'M_SIG' can't have a default value
strSql: CREATE TABLE FORUM_MEMBERS ( MEMBER_ID int (11) NOT NULL AUTO_INCREMENT, M_STATUS smallint (6) DEFAULT '0' , M_NAME VARCHAR (75) DEFAULT '' , M_USERNAME VARCHAR (150) DEFAULT '' , M_PASSWORD VARCHAR (65) DEFAULT '' , M_EMAIL VARCHAR (50) DEFAULT '' , M_COUNTRY VARCHAR (50) DEFAULT '' , M_HOMEPAGE VARCHAR (255) DEFAULT '' , M_SIG TEXT DEFAULT '' , M_VIEW_SIG smallint (6) NULL DEFAULT '1' , M_SIG_DEFAULT smallint (6) NULL DEFAULT '1' , M_DEFAULT_VIEW int (11) DEFAULT '1' , M_LEVEL smallint (6) DEFAULT '1' , M_AIM VARCHAR (150) DEFAULT '' , M_ICQ VARCHAR (150) DEFAULT '' , M_MSN VARCHAR (150) DEFAULT '' , M_YAHOO VARCHAR (150) DEFAULT '' , M_POSTS int (11) DEFAULT '0' , M_DATE VARCHAR (14) DEFAULT '' , M_LASTHEREDATE VARCHAR (14) DEFAULT '' , M_LASTPOSTDATE VARCHAR (14) DEFAULT '' , M_TITLE VARCHAR (50) DEFAULT '' , M_SUBSCRIPTION smallint (6) DEFAULT '0' , M_HIDE_EMAIL smallint (6) DEFAULT '0' , M_RECEIVE_EMAIL smallint (6) DEFAULT '1' , M_LAST_IP VARCHAR (15) DEFAULT '000.000.000.000' , M_IP VARCHAR (15) DEFAULT '000.000.000.000' , M_FIRSTNAME VARCHAR (100) DEFAULT '' , M_LASTNAME VARCHAR (100) DEFAULT '' , M_OCCUPATION VARCHAR (255) DEFAULT '' , M_SEX VARCHAR (50) DEFAULT '' , M_AGE VARCHAR (10) DEFAULT '' , M_DOB VARCHAR (8) DEFAULT '' , M_HOBBIES TEXT DEFAULT '' , M_LNEWS TEXT DEFAULT '' , M_QUOTE TEXT DEFAULT '' , M_BIO TEXT DEFAULT '' , M_MARSTATUS VARCHAR (100) DEFAULT '' , M_LINK1 VARCHAR (255) DEFAULT '' , M_LINK2 VARCHAR (255) DEFAULT '' , M_CITY VARCHAR (100) DEFAULT '' , M_STATE VARCHAR (100) DEFAULT '' , M_PHOTO_URL VARCHAR (255) DEFAULT '' , M_KEY VARCHAR (32) DEFAULT '' , M_NEWEMAIL VARCHAR (50) DEFAULT '', M_PWKEY VARCHAR (32) DEFAULT '' , M_SHA256 smallint (6) DEFAULT '1' ,PRIMARY KEY (MEMBER_ID), KEY FORUM_MEMBERS_MEMBER_ID (MEMBER_ID) )
Error: -2147467259 [MySQL][ODBC 3.51 Driver][mysqld-5.0.41-community-nt]BLOB/TEXT column 'M_SIG' can't have a default value
strSql: CREATE TABLE FORUM_MEMBERS_PENDING ( MEMBER_ID int (11) NOT NULL AUTO_INCREMENT, M_STATUS smallint (6) DEFAULT '0' , M_NAME VARCHAR (75) DEFAULT '' , M_USERNAME VARCHAR (150) DEFAULT '' , M_PASSWORD VARCHAR (65) DEFAULT '' , M_EMAIL VARCHAR (50) DEFAULT '' , M_COUNTRY VARCHAR (50) DEFAULT '' , M_HOMEPAGE VARCHAR (255) DEFAULT '' , M_SIG TEXT DEFAULT '' , M_VIEW_SIG smallint (6) NULL DEFAULT '1' , M_SIG_DEFAULT smallint (6) NULL DEFAULT '1' , M_DEFAULT_VIEW int (11) DEFAULT '1' , M_LEVEL smallint (6) DEFAULT '1' , M_AIM VARCHAR (150) DEFAULT '' , M_ICQ VARCHAR (150) DEFAULT '' , M_MSN VARCHAR (150) DEFAULT '' , M_YAHOO VARCHAR (150) DEFAULT '' , M_POSTS int (11) DEFAULT '0' , M_DATE VARCHAR (14) DEFAULT '' , M_LASTHEREDATE VARCHAR (14) DEFAULT '' , M_LASTPOSTDATE VARCHAR (14) DEFAULT '' , M_TITLE VARCHAR (50) DEFAULT '' , M_SUBSCRIPTION smallint (6) DEFAULT '0' , M_HIDE_EMAIL smallint (6) DEFAULT '0' , M_RECEIVE_EMAIL smallint (6) DEFAULT '1' , M_LAST_IP VARCHAR (15) DEFAULT '000.000.000.000' , M_IP VARCHAR (15) DEFAULT '000.000.000.000' , M_FIRSTNAME VARCHAR (100) DEFAULT '' , M_LASTNAME VARCHAR (100) DEFAULT '' , M_OCCUPATION VARCHAR (255) DEFAULT '' , M_SEX VARCHAR (50) DEFAULT '' , M_AGE VARCHAR (10) DEFAULT '' , M_DOB VARCHAR (8) DEFAULT '' , M_HOBBIES TEXT DEFAULT '' , M_LNEWS TEXT DEFAULT '' , M_QUOTE TEXT DEFAULT '' , M_BIO TEXT DEFAULT '' , M_MARSTATUS VARCHAR (100) DEFAULT '' , M_LINK1 VARCHAR (255) DEFAULT '' , M_LINK2 VARCHAR (255) DEFAULT '' , M_CITY VARCHAR (100) DEFAULT '' , M_STATE VARCHAR (100) DEFAULT '' , M_PHOTO_URL VARCHAR (255) DEFAULT '' , M_KEY VARCHAR (32) DEFAULT '' , M_NEWEMAIL VARCHAR (50) DEFAULT '', M_PWKEY VARCHAR (32) DEFAULT '' , M_APPROVE smallint (6) , M_SHA256 smallint (6) DEFAULT '1' , PRIMARY KEY (MEMBER_ID) )
Error: -2147217865 [MySQL][ODBC 3.51 Driver][mysqld-5.0.41-community-nt]Table 'web-db.forum_members' doesn't exist
strSql: INSERT INTO FORUM_MEMBERS (M_STATUS, M_NAME, M_USERNAME, M_PASSWORD, M_EMAIL, M_COUNTRY, M_HOMEPAGE, M_LINK1, M_LINK2, M_PHOTO_URL, M_SIG, M_VIEW_SIG, M_DEFAULT_VIEW, M_LEVEL, M_AIM, M_ICQ, M_MSN, M_YAHOO, M_POSTS, M_DATE, M_LASTHEREDATE, M_LASTPOSTDATE, M_TITLE, M_SUBSCRIPTION, M_HIDE_EMAIL, M_RECEIVE_EMAIL, M_LAST_IP, M_IP) VALUES(1, 'web-db-admin', 'web-db-admin', '2de998e986ecef55d5a5c225811877cac2f88839156693adda37516b333b2be9', 'yourmail@server.com', ' ', ' ', ' ', ' ', ' ', ' ', 1, 1, 3, ' ', ' ', ' ', ' ', 1, '20070610195554', '20070610195054', '20070610195554', 'Forum Admin', '0', '0', 1, '000.000.000.000', '000.000.000.000')
Error: -2147217865 [MySQL][ODBC 3.51 Driver][mysqld-5.0.41-community-nt]Table 'web-db.forum_forum' doesn't exist
strSql: INSERT INTO FORUM_FORUM(CAT_ID, F_STATUS, F_MAIL, F_SUBJECT, F_URL, F_DESCRIPTION, F_TOPICS, F_COUNT, F_LAST_POST, F_PASSWORD_NEW, F_PRIVATEFORUMS, F_TYPE, F_IP, F_LAST_POST_AUTHOR, F_LAST_POST_TOPIC_ID, F_LAST_POST_REPLY_ID) VALUES(1, 1, '0', 'Testing Forums', '', 'This forum gives you a chance to become more familiar with how this product responds to different features and keeps testing in one place instead of posting tests all over. Happy Posting!  ', 1, 1, '20070610195554', '', '0', '0', '000.000.000.000', 1, 1, 0)
The Installation has NOT been completed !
There were 5 Critical Errors...
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 11 June 2007 : 03:57:39
|
Find inc_create_forum_mysql.asp.
At line# 93, replace
strSql = strSql & "F_DESCRIPTION TEXT DEFAULT '' , "
by
strSql = strSql & "F_DESCRIPTION TEXT, "
At line# 136, do a similar thing. Replace:
strSql = strSql & "M_SIG TEXT DEFAULT '', "
by
strSql = strSql & "M_SIG TEXT, "
At line# 195, do a similar thing. Replace:
strSql = strSql & "M_SIG TEXT DEFAULT '', "
by
strSql = strSql & "M_SIG TEXT, "
To get the setup done all over again, once you've done these changes, run setup.asp like this: setup.asp?RC=5 |
Snitz 3.4 Readme | Like the support? Support Snitz too |
 |
|
|
stonenajem
Starting Member
10 Posts |
Posted - 11 June 2007 : 17:36:18
|
| It also complained of M_QUOTE, M_LNEWS, M_HOBBIES, M_BIO, but I did the same thing on those, and it worked! Thanks again for your help. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
| |
Topic |
|
|
|
Topic Locked
