Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: MOD Implementation
 Active users
 New Topic  Topic Locked
 Printer Friendly
Next Page
Author Previous Topic Topic Next Topic
Page: of 2

thelodger
Junior Member

United Kingdom
296 Posts

Posted - 25 March 2009 :  15:23:52  Show Profile
OK I have had this working but added the online video mod and now I only get this

Active Users
Active Members: 0 | Guests: 0 || Total: 0
Active Users Record: 0 | Record Set On: 11 Nov 1111 at 11:11:11 AM
Members Online: None

I have checked all the code with both mods but with my limited knowledge I cont see anything wrong, the videos are working fine but the active users isnt working, I know we have about 50-70 members on the forum but it says 0 and the time is very strange, any ideas anyone?

thelodger
Junior Member

United Kingdom
296 Posts

Posted - 25 March 2009 :  16:11:03  Show Profile
OK as soon as I put on the video mod, I get this error at the top of the forum


quote:
Microsoft VBScript runtime error '800a000d'
Type mismatch: 'chkAUPermissions'

/inc_activeusers.asp, line 39


Line 39 of inc_activeusers.asp is

bolOverride = chkAUPermissions(strAUAnonOverride)
Go to Top of Page

MaD2ko0l
Senior Member

United Kingdom
1053 Posts

Posted - 25 March 2009 :  17:53:32  Show Profile  Visit MaD2ko0l's Homepage
have you tryed removing the online video mod to see if it is that thats causing the problem?

it may have been a case of you didnt notice it wasnt working until you added this mod.

© 1999-2010 MaD2ko0l
Go to Top of Page

thelodger
Junior Member

United Kingdom
296 Posts

Posted - 25 March 2009 :  17:57:52  Show Profile
Yeah, with the vid mod working I get the 1st error, and using the backup files before the vid mod I get the 2nd error, it was working fine before.
Go to Top of Page

MaD2ko0l
Senior Member

United Kingdom
1053 Posts

Posted - 25 March 2009 :  18:11:56  Show Profile  Visit MaD2ko0l's Homepage
hhhuuuummm....well im not sure about the first error with the dodgy dates.

as for the 2nd error that woudl see as tho theres a problem with the active users code added to inc_func_common.

i would suggest reinstlling both these mods as somethign has been messed up somewhere alogn the line

© 1999-2010 MaD2ko0l
Go to Top of Page

thelodger
Junior Member

United Kingdom
296 Posts

Posted - 26 March 2009 :  13:35:38  Show Profile
OK, I reinstalled the mods, the videos are working fine but I am still getting

quote:
Active Users
Active Members: 0 | Guests: 0 || Total: 0
Active Users Record: 0 | Record Set On: 11 Nov 1111 at 11:11:11 AM
Members Online: None


Now when I run the dbs file, I get this error

-2147217900 | [MySQL][ODBC 3.51 Driver][mysqld-5.0.45-log]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'varchar(1) NULL' at line 1


Anyone got any idea's?
Go to Top of Page

thelodger
Junior Member

United Kingdom
296 Posts

Posted - 26 March 2009 :  13:36:50  Show Profile
Thats the Active Users 4.0 for Snitz 3.4 compatable DBS file, which is the mod I have installed.
Go to Top of Page

thelodger
Junior Member

United Kingdom
296 Posts

Posted - 28 March 2009 :  09:07:21  Show Profile
Anyone got any ideas?
Go to Top of Page

Carefree
Advanced Member

Philippines
4207 Posts

Posted - 28 March 2009 :  12:17:45  Show Profile
Either (a) re-download the zip file (it may be corrupted) and replace the dbs file, or (b) try the following saved as "dbs_activeusers.asp"

Active Users 4

[DROP]
ONLINE
[END]

[DROP]
ACTIVE_USERS
[END]

[CREATE]
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#
[END]

[ALTER]
MEMBERS
ADD#M_AUHIDE#varchar(1)#NULL#
ALTER#M_AUHIDE#varchar(1)#NULL#
[END]

[ALTER]
MEMBERS_PENDING
ADD#M_AUHIDE#varchar(1)#NULL#
[END]

[INSERT]
CONFIG_NEW
(C_VARIABLE,C_VALUE)#('STRAUANON','1')
(C_VARIABLE,C_VALUE)#('STRAUANONOVERRIDE','2')
(C_VARIABLE,C_VALUE)#('STRAUPALLOW','4')
(C_VARIABLE,C_VALUE)#('STRAUPCOLLAPSE','1')
(C_VARIABLE,C_VALUE)#('STRAUALLOW','3')
(C_VARIABLE,C_VALUE)#('STRAUREFRESH','0')
(C_VARIABLE,C_VALUE)#('STRAUIP','1')
(C_VARIABLE,C_VALUE)#('STRAUUA','2')
(C_VARIABLE,C_VALUE)#('STRAULOCAL','3')
(C_VARIABLE,C_VALUE)#('STRAUTIMEOUT','7')
(C_VARIABLE,C_VALUE)#('STRAUADMINCOLOR','orangered')
(C_VARIABLE,C_VALUE)#('STRAUMODCOLOR','forestgreen')
(C_VARIABLE,C_VALUE)#('STRAUADMINCOLOR','orangered')
(C_VARIABLE,C_VALUE)#('STRAUMODCOLOR','forestgreen')
(C_VARIABLE,C_VALUE)#('intAURecord','0')
(C_VARIABLE,C_VALUE)#('strAURecordDate','11111111111111')
[END]
Go to Top of Page

thelodger
Junior Member

United Kingdom
296 Posts

Posted - 28 March 2009 :  15:06:23  Show Profile
Cheers, but I get the same errors

quote:
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 successfully

--------------------------------------------------------------------------------

Adding Column M_AUHIDE...
ALTER TABLE FORUM_MEMBERS ADD M_AUHIDE varchar(1) NULL
ALTER TABLE FORUM_MEMBERS ADD M_AUHIDE varchar(1) NULL
-2147217900 | [MySQL][ODBC 3.51 Driver][mysqld-5.0.45-log]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
-2147217900 | [MySQL][ODBC 3.51 Driver][mysqld-5.0.45-log]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use 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
-2147217900 | [MySQL][ODBC 3.51 Driver][mysqld-5.0.45-log]Duplicate column name 'M_AUHIDE'


And obviously the same error on the forum

Edited by - thelodger on 28 March 2009 15:07:09
Go to Top of Page

Carefree
Advanced Member

Philippines
4207 Posts

Posted - 28 March 2009 :  17:18:44  Show Profile
OK - to preclude the duplicate tables/fields/records issue, we'll have to add DELETE/DROP statements before trying to insert/add.


Active Users 4

[DROP]
ONLINE
[END]

[DROP]
ACTIVE_USERS
[END]

[CREATE]
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#
[END]

[ALTER]
MEMBERS
DROP#M_AUHIDE###
ADD#M_AUHIDE#varchar(1)#NULL#
[END]

[ALTER]
MEMBERS_PENDING
DROP#M_AUHIDE###
ADD#M_AUHIDE#varchar(1)#NULL#
[END]

[DELETE]
CONFIG_NEW
(C_VARIABLE = 'STRAUANON')
(C_VARIABLE = 'STRAUANON')
(C_VARIABLE = 'STRAUANONOVERRIDE')
(C_VARIABLE = 'STRAUPALLOW')
(C_VARIABLE = 'STRAUPCOLLAPSE')
(C_VARIABLE = 'STRAUALLOW')
(C_VARIABLE = 'STRAUREFRESH')
(C_VARIABLE = 'STRAUIP')
(C_VARIABLE = 'STRAUUA')
(C_VARIABLE = 'STRAULOCAL')
(C_VARIABLE = 'STRAUTIMEOUT')
(C_VARIABLE = 'STRAUADMINCOLOR')
(C_VARIABLE = 'STRAUMODCOLOR')
(C_VARIABLE = 'STRAUADMINCOLOR')
(C_VARIABLE = 'STRAUMODCOLOR')
(C_VARIABLE = 'intAURecord')
[END]

[INSERT]
CONFIG_NEW
(C_VARIABLE,C_VALUE)#('STRAUANON','1')
(C_VARIABLE,C_VALUE)#('STRAUANONOVERRIDE','2')
(C_VARIABLE,C_VALUE)#('STRAUPALLOW','4')
(C_VARIABLE,C_VALUE)#('STRAUPCOLLAPSE','1')
(C_VARIABLE,C_VALUE)#('STRAUALLOW','3')
(C_VARIABLE,C_VALUE)#('STRAUREFRESH','0')
(C_VARIABLE,C_VALUE)#('STRAUIP','1')
(C_VARIABLE,C_VALUE)#('STRAUUA','2')
(C_VARIABLE,C_VALUE)#('STRAULOCAL','3')
(C_VARIABLE,C_VALUE)#('STRAUTIMEOUT','7')
(C_VARIABLE,C_VALUE)#('STRAUADMINCOLOR','orangered')
(C_VARIABLE,C_VALUE)#('STRAUMODCOLOR','forestgreen')
(C_VARIABLE,C_VALUE)#('STRAUADMINCOLOR','orangered')
(C_VARIABLE,C_VALUE)#('STRAUMODCOLOR','forestgreen')
(C_VARIABLE,C_VALUE)#('intAURecord','0')
(C_VARIABLE,C_VALUE)#('strAURecordDate','11111111111111')
[END]
Go to Top of Page

thelodger
Junior Member

United Kingdom
296 Posts

Posted - 28 March 2009 :  17:50:48  Show Profile
Great cheers, thats the error gone when creating the database
Now we still get this in active users.

quote:
Active Users
Active Members: 0 | Guests: 0 || Total: 0
Active Users Record: 0 | Record Set On: 11 Nov 1111 at 11:11:11 AM
Members Online: None

Edited by - thelodger on 28 March 2009 17:51:07
Go to Top of Page

Carefree
Advanced Member

Philippines
4207 Posts

Posted - 28 March 2009 :  18:14:14  Show Profile
That's not an error. See this line in the db configuration:
quote:
(C_VARIABLE,C_VALUE)#('strAURecordDate','11111111111111')


That string of 1s is what is creating that date/time group that you see. Until you have an active user sign in, that will remain. Once your first active user(s) connect, it should be replaced with legitimate date/time information.

Edited by - Carefree on 28 March 2009 18:14:26
Go to Top of Page

thelodger
Junior Member

United Kingdom
296 Posts

Posted - 28 March 2009 :  18:22:21  Show Profile
Hmmm, we have over 50 members on the forum now, so what will be causing this problem?
Go to Top of Page

Carefree
Advanced Member

Philippines
4207 Posts

Posted - 28 March 2009 :  21:15:25  Show Profile
Educated guess would be that you missed something in "inc_header.asp" (which handles the active user tracking).
Go to Top of Page

thelodger
Junior Member

United Kingdom
296 Posts

Posted - 29 March 2009 :  03:47:27  Show Profile
OK will re code that, I really appreciate all your help.
Go to Top of Page
Page: of 2 Previous Topic Topic Next Topic  
Next Page
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.33 seconds. Powered By: Snitz Forums 2000 Version 3.4.07