| Author |
 Topic  |
|
MarkJH
Senior Member
United Kingdom
1722 Posts |
 Posted - 19 December 2002 : 17:33:49
|
quote:
Its wild cause I am already logged in as Administrator.
Are you logged in as the Forum Admin (usually member no. 1) or an Admin that you have set up yourself? You need to log in as Forum Admin to setup MODs.  |
Bandlink.net - http://www.bandlink.net/
Bandlink Music Forums - http://www.bandlink.net/forum/ |
 |
|
|
sirsmiley
New Member
77 Posts |
Posted - 19 December 2002 : 17:48:56
|
| Oh ok, yeah I am logged on as an admin that I set up, not the original Admin. I did use it to set mods on my older version and it seemed to work. But now that I have upgraded to 3.4.03 I can't set up mods. I will try that and see what happens. thanks. :) |
|
|
|
MarkJH
Senior Member
United Kingdom
1722 Posts |
Posted - 19 December 2002 : 18:21:24
|
Yes, that's a difference in 3.4.03. Caught me out first time too!
You can actually change which Admin is the Forum Admin. If you search your config.asp file for:
Const intAdminMemberID = 1
(it's somewhere near the top)
and change it to:
Const intAdminMemberID = x
where x is the member ID (the number) of the Admin you wish to be Forum Admin, you can make any Admin you like Forum Admin! |
Bandlink.net - http://www.bandlink.net/
Bandlink Music Forums - http://www.bandlink.net/forum/ |
Edited by - MarkJH on 19 December 2002 18:23:54 |
|
|
|
sirsmiley
New Member
77 Posts |
Posted - 19 December 2002 : 18:24:05
|
Ok got in, I changed the #value in Config to match mine. Now , when I try to set up the MOD Active users 4.17 after clicking updat I get this error.
-2147467259 | The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again.
Not sure if this has been answered yet, but I will do a search. If not, any ideas? Thanks
|
|
|
|
masterao
Senior Member
Sweden
1678 Posts |
Posted - 19 December 2002 : 18:42:05
|
You don't need to run the dbs-file again, as you did that before you upgraded the forum.
Just do the changes in the asp-pages, and you should be set. You may encounter an error after you have uploaded the changed files, because there may be double entries for the AU-mod in the config_new table.
|
Jan
===========
FR Portal Forums | Active Users 4.0.20 Mod |
|
|
|
sirsmiley
New Member
77 Posts |
Posted - 19 December 2002 : 18:54:51
|
Oh hmmm, do I just go ahead and click finished then even though it shows that error? And after that then do I still run the audbsetup in my browser? Or just skip that step and go right on to modifying?
Thanks. |
|
|
|
masterao
Senior Member
Sweden
1678 Posts |
|
|
sirsmiley
New Member
77 Posts |
Posted - 19 December 2002 : 22:44:29
|
| Ok thanks I have it working! :) Just one thing though so far, when I am in the admin panel and I want to see more info on a selection by clicking the ? mark, then I get Page cannot be displayed. Not sure what to do. Thanks |
|
|
|
masterao
Senior Member
Sweden
1678 Posts |
Posted - 20 December 2002 : 06:53:09
|
That sounds like you don't have pop_config_help.asp in your forum directory, or possibly that you didn't upload the modified file.
|
Jan
===========
FR Portal Forums | Active Users 4.0.20 Mod |
|
|
|
cjepp
Starting Member
USA
3 Posts |
Posted - 20 December 2002 : 16:27:44
|
sorri.forthe.interuption..i haven't reviewed this topic in a couple days. been trying to implement a fully mod'd forum wit mysql..no luck.
anyway, attempting to install this mod alone [on a fresh snitz install], i ran into this:
Active Users 4.0 for Snitz 3.4 compatable
Dropping Table..
DROP TABLE FORUM_ONLINE
-2147467259 | SQLState: S1000
Native Error Code: 1051
[TCX][MyODBC]Unknown table 'FORUM_ONLINE'
--------------------------------------------------------------------------------
Dropping Table..
DROP TABLE FORUM_ACTIVE_USERS
-2147467259 | SQLState: S1000
Native Error Code: 1051
[TCX][MyODBC]Unknown table 'FORUM_ACTIVE_USERS'
--------------------------------------------------------------------------------
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
Column added successfully
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
Column added successfully
--------------------------------------------------------------------------------
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
~~~
..which is what i'm doing
|
|
|
|
masterao
Senior Member
Sweden
1678 Posts |
Posted - 20 December 2002 : 18:02:42
|
The first two errors are not important, as the tables called didn't exist in you database (forum_online and active_users). They are used to remove any previous versions of active users tables, if any existed.
Can you check your database and see if you have a table called FORUM_ACTIVE_USERS with the abovementioned columns? Also check if FORUM_CONFIG_NEW have the additional entries, as well as FORUM_MEMBERS. I don't use mysql myself, so Im not able to give much additional help with the database additions, as Im unaware of what causes the errors
If the above additions are found, you can continue on with modifying the necessary files (don't forget to do backups of the files before modifying them).
|
Jan
===========
FR Portal Forums | Active Users 4.0.20 Mod |
|
|
|
sirsmiley
New Member
77 Posts |
Posted - 20 December 2002 : 20:45:11
|
| Hmmm, maybe I added the code wrong, cause I did upload POP_ config_help back to the site. When I did that step, for some reason it said it was optional, but I did it anyways. I'm not sure why it was optional. |
|
|
|
sirsmiley
New Member
77 Posts |
Posted - 21 December 2002 : 03:57:53
|
| Ok I re-modified Pop_config_help_.asp and re iploaded it, and its working now. I must have made a mistake the first time. :) |
|
|
|
masterao
Senior Member
Sweden
1678 Posts |
|
|
sirsmiley
New Member
77 Posts |
Posted - 21 December 2002 : 07:45:59
|
| Thanks Jan! :) Ummm I have a bunch of errors now though from another mod!:( I have made a new post about it, please take a look at it when you can. Thanks :) |
|
|
|
Topic |
|
Topic Locked
