| Author |
 Topic  |
|
thelodger
Junior Member
United Kingdom
296 Posts |
 Posted - 25 March 2009 : 15:23:52
|
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
|
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) |
 |
|
|
MaD2ko0l
Senior Member
United Kingdom
1053 Posts |
Posted - 25 March 2009 : 17:53:32
|
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 |
|
|
|
thelodger
Junior Member
United Kingdom
296 Posts |
Posted - 25 March 2009 : 17:57:52
|
| 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. |
|
|
|
MaD2ko0l
Senior Member
United Kingdom
1053 Posts |
Posted - 25 March 2009 : 18:11:56
|
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 |
|
|
|
thelodger
Junior Member
United Kingdom
296 Posts |
Posted - 26 March 2009 : 13:35:38
|
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? |
|
|
|
thelodger
Junior Member
United Kingdom
296 Posts |
Posted - 26 March 2009 : 13:36:50
|
| Thats the Active Users 4.0 for Snitz 3.4 compatable DBS file, which is the mod I have installed. |
|
|
|
thelodger
Junior Member
United Kingdom
296 Posts |
Posted - 28 March 2009 : 09:07:21
|
| Anyone got any ideas? |
|
|
|
Carefree
Advanced Member
Philippines
4207 Posts |
Posted - 28 March 2009 : 12:17:45
|
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]
|
|
|
|
thelodger
Junior Member
United Kingdom
296 Posts |
Posted - 28 March 2009 : 15:06:23
|
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 |
|
|
|
Carefree
Advanced Member
Philippines
4207 Posts |
Posted - 28 March 2009 : 17:18:44
|
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]
|
|
|
|
thelodger
Junior Member
United Kingdom
296 Posts |
Posted - 28 March 2009 : 17:50:48
|
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 |
|
|
|
Carefree
Advanced Member
Philippines
4207 Posts |
Posted - 28 March 2009 : 18:14:14
|
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 |
|
|
|
thelodger
Junior Member
United Kingdom
296 Posts |
Posted - 28 March 2009 : 18:22:21
|
| Hmmm, we have over 50 members on the forum now, so what will be causing this problem? |
|
|
|
Carefree
Advanced Member
Philippines
4207 Posts |
Posted - 28 March 2009 : 21:15:25
|
| Educated guess would be that you missed something in "inc_header.asp" (which handles the active user tracking). |
|
|
|
thelodger
Junior Member
United Kingdom
296 Posts |
Posted - 29 March 2009 : 03:47:27
|
| OK will re code that, I really appreciate all your help. |
|
|
|
Topic |
|
Topic Locked
