| Author |
 Topic  |
|
|
wrc1
Starting Member
47 Posts |
 Posted - 14 July 2002 : 07:50:41
|
i downloaded this mod at http://www.ls3k.com/snitz/mods.asp
When i start the mod setup i get this error : (who can help or is this normal)
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 ,KEY FORUM_ACTIVE_USERS_())
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 ,KEY FORUM_ACTIVE_USERS_())
-2147467259 | SQLState: 42000
Native Error Code: 1064
[TCX][MyODBC]You have an error in your SQL syntax near '))' at line 1
Adding Column M_AUHIDE...
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
-2147467259 | SQLState: 42000
Native Error Code: 1064
[TCX][MyODBC]You have an error in your SQL syntax near 'varchar(1) NULL ' at line 1
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 14 July 2002 : 09:53:19
|
Some of those errors don't seem problematic. Others definitely do, namely the syntax errors.
However I guess it's better to wait for Nathan to have a say on that since he was the one who coded that dbs file.
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs |
 |
|
|
Akali
Starting Member
United Kingdom
24 Posts |
Posted - 18 July 2002 : 09:12:13
|
Hi
I have just tried this three times  and I am getting the same errors. Any further advice Nathan ??
Running version 3.3.05 on PWS with mySQL.
Akali
Edited by - Akali on 18 July 2002 09:16:15 |
|
|
|
Akali
Starting Member
United Kingdom
24 Posts |
Posted - 18 July 2002 : 11:27:52
|
OK
Sorted the problem out
wrc1 I had a trawl through the site and got the answer from here
http://forum.snitz.com/forum/topic.asp?TOPIC_ID=26081
Richard Kinser states:
"If you are using MySQL and are getting errors, there is a modified version of the MOD Setup file for download here (this is the same version that will be included in v3.4):
http://kinser.121hosts.net/link-it/redirect.asp?linkid=5"
I guess if you are using mySQL this may well resolve your problem as well. Although fixes for Access are also posted.
Hope that helps
I love this forum
Akali
Edited by - Akali on 18 July 2002 11:28:26 |
|
|
|
gamer885
Starting Member
6 Posts |
Posted - 19 July 2002 : 03:02:02
|
Will active users 4.0 work with version 3.3.05. The folder inside of the download says 3303 so can those files just work with v. 3.3.03? And will i get those errors if i am using access 2000?
|
|
|
|
Akali
Starting Member
United Kingdom
24 Posts |
Posted - 19 July 2002 : 05:07:08
|
Hmm.....
Pass on that one  Not sure about the Access 2000 bit.
I installed it on a test machine yesterday and therefore have not had the chance to run any extensive tests but it seems to run fine for the limited bit of work that I have done with it.
I was just pleased I got it working. Will this be included in the next version or will we still need to add this MOD?
Akali
quote:
Will active users 4.0 work with version 3.3.05. The folder inside of the download says 3303 so can those files just work with v. 3.3.03? And will i get those errors if i am using access 2000?
Edited by - Akali on 19 July 2002 06:04:24 |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 19 July 2002 : 06:38:02
|
quote:
Will active users 4.0 work with version 3.3.05. The folder inside of the download says 3303 so can those files just work with v. 3.3.03? And will i get those errors if i am using access 2000?
Of course it will work with 3.3.05. Just be carefull with the line numbers, better make sure you change the right lines, since there may be some slight differences in line numbers.
Usually you shouldn't get problems with the Access version, but that does not depend on the database only. You need your host to support FSO to be able to install the mod from the MOD setup in the Admin panel.
Anyway, don't worry much about it. Try to setup the mod form the MOD setup. If it all goes well, done. If hou have problems, with messages related to object not support or so, then you can try the alternative mod setup. But you probably want to post here for help before doing it.
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs |
|
|
|
gamer885
Starting Member
6 Posts |
Posted - 19 July 2002 : 12:38:45
|
quote:
Will this be included in the next version or will we still need to add this MOD?
Akali
That would be nice to know so i could just wait so i won't have to go though all the troble installing active users 4.0.
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Nathan
Help Moderator
USA
7664 Posts |
Posted - 19 July 2002 : 18:16:19
|
And it probably won't be untill some database guru sorts out the whole indexing shebaggle.
 Nathan Bales
Snitz Exchange | Do's and Dont's |
|
|
|
Akali
Starting Member
United Kingdom
24 Posts |
Posted - 20 July 2002 : 13:11:49
|
Will this mod still be compatible in the new version??
i.e. Will the same instructions apply??
Actually that question applies to all the other (well most popular) mods out there.
Complicated stuff this website building
Akali
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Akali
Starting Member
United Kingdom
24 Posts |
Posted - 20 July 2002 : 13:39:58
|
Err..
Don't bother replying to that one, I got the answer at
http://forum.snitz.com/forum/topic.asp?whichpage=2&TOPIC_ID=31170
Exciting stuff this waiting for version 3.4. Really appreciate all the work that has gone into creating this. Just recently discovered the mods and am having fun installing them. The buzz when it works is amazing. (Does this mean that I have a sad life??)
Don't bother answering that one
Akali
|
|
|
| |
Topic |
|
Topic Locked
