|
mrjamin
Starting Member
United Kingdom
11 Posts |
 Posted - 25 July 2009 : 20:31:18
|
Hi,
I've just tried to run the IPGate setup .dbs for v2.4 RC3 but the SQL generates the following errors:
Creating table(s)...
CREATE TABLE FORUM_IPLIST( IPLIST_ID INT (11) DEFAULT '' NOT NULL auto_increment , IPLIST_MEMBERID varchar(32) NULL DEFAULT 0, IPLIST_STARTIP varchar(32) NULL , IPLIST_STARTDATE varchar(32) NULL , IPLIST_ENDDATE varchar(32) NULL , IPLIST_COMMENT varchar(255) NULL , IPLIST_STATUS varchar(8) NULL , IPLIST_DBPAGEKEY varchar(32) NULL ,KEY FORUM_IPLIST_IPLIST_ID(IPLIST_ID))
CREATE TABLE FORUM_IPLIST( IPLIST_ID INT (11) DEFAULT '' NOT NULL auto_increment , IPLIST_MEMBERID varchar(32) NULL DEFAULT 0, IPLIST_STARTIP varchar(32) NULL , IPLIST_STARTDATE varchar(32) NULL , IPLIST_ENDDATE varchar(32) NULL , IPLIST_COMMENT varchar(255) NULL , IPLIST_STATUS varchar(8) NULL , IPLIST_DBPAGEKEY varchar(32) NULL ,KEY FORUM_IPLIST_IPLIST_ID(IPLIST_ID))
-2147467259 | [MySQL][ODBC 3.51 Driver][mysqld-5.0.45]Invalid default value for 'IPLIST_ID'
Dropping Table..
Table does not exist
Creating table(s)...
CREATE TABLE FORUM_PAGEKEYS( PAGEKEYS_ID INT (11) DEFAULT '' NOT NULL auto_increment , PAGEKEYS_PAGEKEY varchar(32) NULL ,KEY FORUM_PAGEKEYS_PAGEKEYS_ID(PAGEKEYS_ID))
CREATE TABLE FORUM_PAGEKEYS( PAGEKEYS_ID INT (11) DEFAULT '' NOT NULL auto_increment , PAGEKEYS_PAGEKEY varchar(32) NULL ,KEY FORUM_PAGEKEYS_PAGEKEYS_ID(PAGEKEYS_ID))
-2147467259 | [MySQL][ODBC 3.51 Driver][mysqld-5.0.45]Invalid default value for 'PAGEKEYS_ID'
Adding new records..
INSERT INTO FORUM_PAGEKEYS (PAGEKEYS_PAGEKEY) VALUES ('post.asp')
INSERT INTO FORUM_PAGEKEYS (PAGEKEYS_PAGEKEY) VALUES ('post.asp')
-2147217865 | [MySQL][ODBC 3.51 Driver][mysqld-5.0.45]Table 'fnetForum.FORUM_PAGEKEYS' doesn't exist
Dropping Table..
Table does not exist
Creating table(s)...
CREATE TABLE FORUM_IPLOG( IPLOG_ID INT (11) DEFAULT '' NOT NULL auto_increment , IPLOG_MEMBERID varchar(32) NULL DEFAULT 0, IPLOG_IP varchar(32) NULL , IPLOG_PATHINFO varchar(255) NULL , IPLOG_DATE varchar(32) NULL ,KEY FORUM_IPLOG_IPLOG_ID(IPLOG_ID))
CREATE TABLE FORUM_IPLOG( IPLOG_ID INT (11) DEFAULT '' NOT NULL auto_increment , IPLOG_MEMBERID varchar(32) NULL DEFAULT 0, IPLOG_IP varchar(32) NULL , IPLOG_PATHINFO varchar(255) NULL , IPLOG_DATE varchar(32) NULL ,KEY FORUM_IPLOG_IPLOG_ID(IPLOG_ID))
-2147467259 | [MySQL][ODBC 3.51 Driver][mysqld-5.0.45]Invalid default value for 'IPLOG_ID'
Adding new records..
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRIPGATEBAN','0')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRIPGATELCK','0')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRIPGATECOK','0')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRIPGATEMET','0')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRIPGATEMSG','You are banned from these forums')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRIPGATELKMSG','Forums are currently locked')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRIPGATENOACMSG','You do not have access to the requested page')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRIPGATEWARNMSG','Your or another persons activity is being logged')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRIPGATEVER','Ver 2.4.4')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRIPGATELOG','0')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRIPGATETYP','0')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRIPGATEEXP','15')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRIPGATECSS','0')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRIPGATESHOWRECS','25')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRIPGATEAUTOCLEAN','0')
Value(s) updated successfully
Any suggestions would be greatly appreciated.
Ben C
|
|
Topic Locked
