| Author |
 Topic  |
|
|
Michaelos
Starting Member
Ireland
45 Posts |
 Posted - 24 November 2005 : 08:50:17
|
Hello,
I am having a problem installing the active user mod from www.ls3k.com on my forum. I am using version 3.4.05 of snitz forum 200.
I started following the enclosed instructions with the mod. It said I needed to upload the active user files which I did. Then it said I needed to update my database, and I should go to the Mod setup option on my admin home panel. So I did, and it said on the instructions;
"there should be a select form object in the center of the file. Select "Active Users 4.0.1 for Snitz 3.4 compatable"
Make sure the checkbox is checked.
Click Update!"
There is no select form object anyway on the page, there is no checkbox, and no update button, instead, there is a blank box where it says I should write in lines of code to be updated, and a submit button.
I didnt really know what to do, so I opened the audbsetup.asp file, copied all the code from it, and entered it into the box, and clicked submit. Then it said 30 lines of code updated. Then the instructions said I should go to myserver.com/forumdirectory/audbsetup.asp in my browser. So I did that, and it said Microsoft JET database engine error, for the file, and said there was a problem with a line in the file, I cant rememeber the number, but I went to that line and the line said "set rs = my_conn.execute (strSql)"
I just ignored it and proceeded to updating files like the instructions said. So I updated them all as asked exactly the way it said to, with no problems. I uploaded the language mods, and the updated files. So then it said to go to your admin panel to configue active users. So I tried to go to it, by logging in and by going directly to the panel, but in ecah case the same error came up;
"Microsoft JET Database Engine error '80040e37'
The Microsoft Jet database engine cannot find the input table or query 'FORUM_ACTIVE_USERS'. Make sure it exists and that its name is spelled correctly.
myforumdirectory/inc_func_common.asp, line 58"
So I decided to take a look at line 58, and guess what line made a return for trouble? Line 58 was our old friend " set rs = my_conn.execute (strSql)"
So since it is the same line here that I had a problem with trying to update the database, I assume its a problem with updating the database I had in the first place. So now im stumped. I have backups of all the files so I can use them if necessary. Any help on this problem would be greatly appreciated.
Thank you!
|
Michael |
Edited by - Michaelos on 24 November 2005 08:54:39 |
|
|
Classicmotorcycling
Development Team Leader
Australia
2085 Posts |
Posted - 24 November 2005 : 12:57:41
|
| Did you go to the admin options and run the dbs update file from the MOD Setup? It looks like it can not find the 'FORUM_ACTIVE_USERS' table in your DB. If you think that you ran it, please try it again. |
Cheers,
David Greening |
 |
|
|
Michaelos
Starting Member
Ireland
45 Posts |
Posted - 24 November 2005 : 14:00:15
|
Hello David,
I did as you asked, I went into Mod Setup, and I once again put the code from the audbsetup.asp file into the code box and clicked submit. Then it said 30 lines of code processed. This is the code I put in the box from audbsetup.asp:
<!--#include file="config.asp"-->
<!--#include file="inc_func_common.asp"-->
<!--#include file="inc_header.asp"-->
<%
strSql2 = "UPDATE " & strMemberTablePrefix & "MEMBERS SET M_AUHIDE='1'"
strSql = "SELECT MEMBER_ID FROM " & strMemberTablePrefix & "MEMBERS WHERE M_AUHIDE='0'"
'response.write strSql & "<br><br>"
set rs = my_conn.execute(strSql)
if rs.EOF or rs.BOF then
'response.write "No Records Need Updateing"
my_conn.execute strSql2
Response.write "<br><br><p align=""center"">Update Complete</p><p align=""center""><a href=""default.asp"">Return To Forum</a><br><br>"
call WriteFooter
response.end
end if
'response.write strSql & "<br><br>"
strSql = "UPDATE " & strMemberTablePrefix & "MEMBERS SET M_AUHIDE='0' WHERE "
do until rs.EOF
strSql = strSql & "MEMBER_ID = " & rs("MEMBER_ID") & " OR "
response.write ". "
rs.movenext
loop
strSql = strSql & "MEMBER_ID = 0"
'response.write strSql & "<br><br>"
my_conn.execute strSql2
my_conn.execute strSql
Response.write "<br><br><p align=""center"">Update Complete</p><p align=""center""><a href=""default.asp"">Return To Forum</a><br><br>"
rs.close
set rs = nothing
call WriteFooter
%>
Then I followed the next lot of instuctions, and went to audbsetup.asp in my browser, and this is what came up:
Microsoft JET Database Engine error '80040e10'
No value given for one or more required parameters.
myforumdirectory/audbsetup.asp, line 8
Line 8 of the file is "set rs = my_conn.execute(strSql)"
So same error again. I downloaded my database and had a look at it, the tables for for FORUM_ACTIVE_USERS is not written in the file.
Thanks for your help!
|
Michael |
Edited by - Michaelos on 24 November 2005 14:01:09 |
|
|
|
masterao
Senior Member
Sweden
1678 Posts |
Posted - 24 November 2005 : 16:37:04
|
You have two links for Mod Setup in the Admin area. One will show a droplist and state Snitz Forum Modifications in large letters and below that it will say Database Setup..... Below the droplist is a button that should say Update!. The direct url to this page is http://<url to your forum>/admin_mod_dbsetup.asp.
You seem to have clicked on Alternative MOD Setup which will only show a textarea and two buttons with Submit and Clear. |
Jan
===========
FR Portal Forums | Active Users 4.0.20 Mod |
|
|
|
Michaelos
Starting Member
Ireland
45 Posts |
Posted - 24 November 2005 : 16:47:42
|
No Jan, im afraid I went to that link, and all I get is the same code box!
Maybe there is a wrong file in place for the Mod setup? I get the same thing on both of the mod setup pages, the main mod setup and alternative. Maybe if there is a wrong file someone could emai,l the correct one in its place to me? mjjos1@yahoo.ie
Thanks for your help!
|
Michael |
|
|
|
Michaelos
Starting Member
Ireland
45 Posts |
Posted - 24 November 2005 : 16:49:00
|
Wait I have just noticed something, if I put in your address you gave me Jan, it redirects me to admin_mod_dbsetup2.asp ! What could be the reason for that!?
Thanks again!
|
Michael |
Edited by - Michaelos on 24 November 2005 16:50:09 |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 24 November 2005 : 18:35:45
|
quote:
Originally posted by Michaelos
Wait I have just noticed something, if I put in your address you gave me Jan, it redirects me to admin_mod_dbsetup2.asp ! What could be the reason for that!?
Thanks again!
It is possible that your host does not support the Scripting.FileSystemObject, so you're redirected to the alternate mod setup.
What you need to paste in there, once you're redirected, is this:
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]
Copy and paste it into the alternate mod setup window, click submit and all should go well. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
Classicmotorcycling
Development Team Leader
Australia
2085 Posts |
Posted - 25 November 2005 : 03:51:41
|
Thanks ruirib... Was going to advise Michaelos to copy and paste the right file contents in to the MOD setup...  |
Cheers,
David Greening |
|
|
|
Michaelos
Starting Member
Ireland
45 Posts |
Posted - 25 November 2005 : 04:25:44
|
You guys are brilliant! I will paste in that code and let you know how it goes! My host is 1asphost, I thought they would support everything asp related!
Anyway, thanks for your help again!
|
Michael |
|
|
|
Michaelos
Starting Member
Ireland
45 Posts |
Posted - 25 November 2005 : 05:53:20
|
Hey,
Just to let you know the code worked, and I have the active users working now, thanks for all your help, once again your brilliant!
Best Regards.
|
Michael |
Edited by - Michaelos on 25 November 2005 05:53:46 |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
| |
Topic |
|
|
|
Topic Locked
