| Author |
 Topic  |
|
|
adslonline
Starting Member
Netherlands
38 Posts |
 Posted - 15 February 2004 : 17:04:37
|
I have encountered a few small problems during the steps to install Active users mod version 4.0.17. I am running Snitz 3.4.04 on MySQL database under IIS 5.1
During the setup mod process in admin options, I got one small error message while the rest worked fine:
quote:
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-4.0.17-nt]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
My first question, is Active Users meant to work with MySQL?
Secondly, could the error message above have caused any ASP error messages I am getting right now when testing active users on default.asp?
We have this mod working already for months on our live server running Access.
thanks in advance |
www.adslforum.nl |
Edited by - adslonline on 15 February 2004 17:08:40 |
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 15 February 2004 : 17:44:00
|
| could you paste the contents of the dbs file, looks like there may be something wrong with it. |
 |
|
|
adslonline
Starting Member
Netherlands
38 Posts |
Posted - 15 February 2004 : 17:48:53
|
Here is the dbs file that was in the zip-file
quote:
Active Users 4.0 for Snitz 3.4 compatable
[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]
|
www.adslforum.nl |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 15 February 2004 : 18:31:51
|
Ok,
try removing the line I have highlighted in red, I don't see any reason for it being there, although the error should not be affecting the mod, as it should have added the column anyway.
[ALTER]
MEMBERS
ADD#M_AUHIDE#varchar(1)#NULL#
ALTER#M_AUHIDE#varchar(1)#NULL#
[END]
what asp errors are you getting ?
|
|
|
|
adslonline
Starting Member
Netherlands
38 Posts |
Posted - 15 February 2004 : 18:42:18
|
Hello HuwR, thanks for the help so far.
Your suggested edit of the dbs file worked, no more errors in the SQL query.
I still get an ASP error in default.asp, allthough the page loads I get this error message in the statistics table at the bottom:
quote:
Microsoft VBScript runtime error '800a000d'
Type mismatch: 'fLang'
/snitz/inc_activeusers.asp, line 141
Line 141 is: Response.Write"<a href=""" & ScriptName & "?HideActiveUsers=Y"">" &
getCurrentIcon(strIconMinus,fLang(strLangMOD_Ls3kAU_00003),"") & "</a>"
It is good to know the SQL query is not causing it, it is probably an error I made in the numerous file changes that are necessary for Active Users. Any idea to which part this error relates? I have not found it yet. |
www.adslforum.nl |
Edited by - adslonline on 15 February 2004 18:53:50 |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 15 February 2004 : 19:24:10
|
Did you add the following code at the end of your config.asp according to the readme file?'#################################################################################
'######################## ADDED FOR INTERNATIONAL MODS! #########################
strLangLCID = "1033"
function fLang(s)
' fLang=eval(s) ' commented out for IIS 4 compatibility, all related function calls changed
fLang=s
end function
%>
<!--#include file="langMODS_Ls3kAU4.asp"--> |
Support Snitz Forums
|
|
|
|
adslonline
Starting Member
Netherlands
38 Posts |
Posted - 15 February 2004 : 19:45:08
|
I had followed the changes to config.asp according to the readme by adding the appropriate line for my version 4.0.17
quote:
VERSION 4.0b4+ (and version 3.4s already configured for international mods)
Add this to the very bottom of your existing config.asp file.
This should be after the last %> in the file.
<!--#include file="langMODS_Ls3kAU4.asp"-->
I overlooked the words already configured, meaning for config.asp I had to use the code meant for the older version (3.4) instead.
It works like a charm now, thanks Davio and HuwR for taking the time to help. I'm pretty happy I didn't make any other errors considering the large number of changes this mod needs  |
www.adslforum.nl |
Edited by - adslonline on 15 February 2004 19:50:30 |
|
|
| |
Topic |
|
|
|
Topic Locked
