|
Webbo
Average Member
United Kingdom
982 Posts |
 Posted - 10 February 2003 : 05:23:45
|
Hi,
Is the Active Users Mod compatable with MySql database?
I just updated the database and got the following errors:
Active Users 4.0 for Snitz 3.3.03 compatable
Dropping Table..
DROP TABLE FORUM4_ONLINE
-2147467259 | [TCX][MyODBC]Unknown table 'FORUM4_ONLINE'
--------------------------------------------------------------------------------
Dropping Table..
DROP TABLE FORUM4_ACTIVE_USERS
-2147467259 | [TCX][MyODBC]Unknown table 'FORUM4_ACTIVE_USERS'
--------------------------------------------------------------------------------
Creating table(s)...
CREATE TABLE FORUM4_ACTIVE_USERS( MEMBER_ID int NULL , AU_IP varchar(40) NULL , AU_LOGINTIME varchar(100) NULL , AU_LASTACTIVETIME varchar(100) NULL , AU_LASTPAGE varchar(250) NULL , AU_QUERYSTRING text NULL , AU_USER_AGENT text NULL )
Table created succesfully
--------------------------------------------------------------------------------
Adding Column M_AUHIDE...
ALTER TABLE FORUM4_MEMBERS ADD M_AUHIDE varchar(1) NULL
Column added successfully
Adding Column M_AUHIDE...
ALTER TABLE FORUM4_MEMBERS ALTER COLUMN M_AUHIDE varchar(1) NULL
ALTER TABLE FORUM4_MEMBERS ALTER COLUMN M_AUHIDE varchar(1) NULL
-2147217911 | [TCX][MyODBC]You have an error in your SQL syntax near 'varchar(1) NULL ' at line 1
--------------------------------------------------------------------------------
Adding new records..
INSERT INTO FORUM4_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRAUANON','1')
INSERT INTO FORUM4_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRAUANONOVERRIDE','2')
INSERT INTO FORUM4_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRAUPALLOW','4')
INSERT INTO FORUM4_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRAUPCOLLAPSE','1')
INSERT INTO FORUM4_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRAUALLOW','3')
INSERT INTO FORUM4_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRAUREFRESH','0')
INSERT INTO FORUM4_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRAUIP','1')
INSERT INTO FORUM4_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRAUUA','2')
INSERT INTO FORUM4_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRAULOCAL','3')
INSERT INTO FORUM4_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRAUTIMEOUT','7')
INSERT INTO FORUM4_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRAUADMINCOLOR','orangered')
INSERT INTO FORUM4_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRAUMODCOLOR','forestgreen')
INSERT INTO FORUM4_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('intAURecord','0')
INSERT INTO FORUM4_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('strAURecordDate','0')
Value(s) updated succesfully
Thanks,
Dave |
|
Topic Locked
