| Author |
 Topic  |
|
|
wrc1
Starting Member
47 Posts |
 Posted - 26 August 2003 : 10:07:19
|
Hello,
I try to install the active users mod and i uploaded the mod to my forum an run the install but i get this error. What can i do about it. do i have to change something to my forum ? or to my mysql tables ????? i want to run this mod. If i change my forum files it won't work with those errors i think. Please could someone help me.
thx
Dropping Table..
DROP TABLE FORUM_ONLINE
-2147467259 | SQLState: S1000
Native Error Code: 1051
[TCX][MyODBC]Unknown table 'FORUM_ONLINE'
--------------------------------------------------------------------------------
Dropping Table..
Table dropped succesfully
--------------------------------------------------------------------------------
Creating table(s)...
CREATE TABLE FORUM_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 FORUM_MEMBERS ADD M_AUHIDE varchar(1) NULL
ALTER TABLE FORUM_MEMBERS ADD M_AUHIDE varchar(1) NULL
-2147467259 | SQLState: 42S21
Native Error Code: 1060
[TCX][MyODBC]Duplicate column name 'M_AUHIDE'
Adding Column M_AUHIDE...
ALTER TABLE FORUM_MEMBERS ALTER COLUMN M_AUHIDE varchar(1) NULL
ALTER TABLE FORUM_MEMBERS ALTER COLUMN M_AUHIDE varchar(1) NULL
-2147467259 | SQLState: 42000
Native Error Code: 1064
[TCX][MyODBC]You have an error in your SQL syntax near 'varchar(1) NULL ' at line 1
--------------------------------------------------------------------------------
Adding Column M_AUHIDE...
ALTER TABLE FORUM_MEMBERS_PENDING ADD M_AUHIDE varchar(1) NULL
ALTER TABLE FORUM_MEMBERS_PENDING ADD M_AUHIDE varchar(1) NULL
-2147467259 | SQLState: 42S21
Native Error Code: 1060
[TCX][MyODBC]Duplicate column name 'M_AUHIDE'
--------------------------------------------------------------------------------
Adding new records..
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRAUANON','1')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRAUANONOVERRIDE','2')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRAUPALLOW','4')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRAUPCOLLAPSE','1')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRAUALLOW','3')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRAUREFRESH','0')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRAUIP','1')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRAUUA','2')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRAULOCAL','3')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRAUTIMEOUT','7')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRAUADMINCOLOR','orangered')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRAUMODCOLOR','forestgreen')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRAUADMINCOLOR','orangered')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRAUMODCOLOR','forestgreen')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('intAURecord','0')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('strAURecordDate','11111111111111')
Value(s) updated succesfully
--------------------------------------------------------------------------------
If there were errors please post a question in the MOD Implementation Forum at
Snitz Forums |
Edited by - wrc1 on 26 August 2003 12:45:42 |
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 26 August 2003 : 12:49:11
|
Those errors are perfectly normal. The dbs was trying to create some fields in various table but, because you had the AU mod installed previously, those fields already exist and there's no need to create them again.
<edit>
Actually this error may need to be looked into, not familiar with mySQL, so I can't be of much help myself.quote:
-2147467259 | SQLState: 42000
Native Error Code: 1064
[TCX][MyODBC]You have an error in your SQL syntax near 'varchar(1) NULL ' at line 1
</edit>
|
 Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.” |
Edited by - Shaggy on 26 August 2003 12:51:29 |
 |
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 26 August 2003 : 14:38:36
|
| It looks ok to me. Are you having problems with the mod? |
Support Snitz Forums
|
|
|
|
wrc1
Starting Member
47 Posts |
Posted - 26 August 2003 : 15:06:52
|
| i do the changes on the pages tomorow. so i will let you know if it went ok. |
|
|
| |
Topic |
|
|
|
Topic Locked
