| Author |
 Topic  |
|
|
Yamaboy
Starting Member
46 Posts |
 Posted - 12 July 2005 : 12:04:31
|
Here is the mod I am using and what I am doing step by step. Also, I'm not sure if it matters, but the e-mail feature is disabled right now.
Some Info
---------------------------------
Mod I'm trying to install - http://www.snitzbitz.com/mods/details.asp?Version=All&mid=207
My Host
Operating system Linux
Kernel version 2.4.21-27.0.4.ELsmp
Machine Type i686
Apache version 1.3.33 (Unix)
PERL version 5.8.4
Path to PERL /usr/bin/perl
Path to sendmail /usr/sbin/sendmail
MySQL version 4.0.24-standard
cPanel Build 10.2.0-RELEASE 82
*.asp handler chiliasp
---------------------------------
Here is exactly what I am doing.
1. I upload the dbs_Active_(Logged_In)_Users.asp
2. Run the MOD setup through the admin panel.
3. Shut down the forum then change the code per the instructions listed for the MOD.
4. Upload the changed default and inc_header.asp pages
5. Start the forum.
This is what I get when I restart the board.
The page cannot be displayed
There is a problem with the page you are trying to reach and it cannot be displayed.
Please try the following:
* Click the Refresh button, or try again later.
* Open the xxxxxxx.com home page, and then look for links to the information you want.
HTTP 500.100 - Internal Server Error - ASP error
Apache/1.3.33 (Unix) Sun-ONE-ASP/4.0.2 PHP/4.3.11 mod_auth_passthrough/1.8 mod_log_bytes/1.2 mod_bwlimited/1.4 FrontPage/5.0.2.2635 mod_ssl/2.8.22 OpenSSL/0.9.7a
Technical Information (for support personnel)
* Error Type:
Sun ONE ASP VBScript compilation (0x800A03F6)
Expected 'End'
/forum/default.asp, line 1141, column 14
* Browser Type:
Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.8) Gecko/20050511 Firefox/1.0.4
* Page:
GET /forum/default.asp
* Time:
Tuesday, July 12, 2005, 9:05:00 AM
* More information:
Sun ONE Active Server Pages Support
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Yamaboy
Starting Member
46 Posts |
Posted - 12 July 2005 : 16:33:20
|
It seems that I am editing the script incorrectly.
For instance, the instructions say replace this
------------------------
end if
if mLev = 4 and strEmailVal = "1" and strRestrictReg = "1" and strEmail = "1" then
'## Forum_SQL - Get membercount from DB
with this
------------------------
'## Update LastActive column
strActiveSql = "UPDATE " & strMemberTablePrefix & "MEMBERS "
strActiveSql = strActiveSql & " SET M_LASTACTIVE = '" & strForumTimeAdjust & "'"
strActiveSql = strActiveSql & ", M_LAST_IP = '" & Request.ServerVariables("REMOTE_ADDR") & "'"
strActiveSql = strActiveSql & " WHERE MEMBER_ID = " & MemberID
my_Conn.Execute (strActiveSql),,adCmdText + adExecuteNoRecords
if mLev = 4 and strEmailVal = "1" and strRestrictReg = "1" and strEmail = "1" then
'## Forum_SQL - Get membercount from DB
I do this exactly. The first set is replaced by the new set. Am I screwing something up here? By the error report I am guessing that I am over writing the end of some instruction set since an 'end' was expected.
|
 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 12 July 2005 : 21:28:51
|
Where is that written? I can't find it in the mod's readme file.
Anyway, I'd say that end if just before if mlev.., should not be deleted. Instead you should move the new between the end if and the start of the inserted code, like this
end if
## Update LastActive column
strActiveSql = "UPDATE " & strMemberTablePrefix & "MEMBERS "
strActiveSql = strActiveSql & " SET M_LASTACTIVE = '" & strForumTimeAdjust & "'"
strActiveSql = strActiveSql & ", M_LAST_IP = '" & Request.ServerVariables("REMOTE_ADDR") & "'"
strActiveSql = strActiveSql & " WHERE MEMBER_ID = " & MemberID
my_Conn.Execute (strActiveSql),,adCmdText + adExecuteNoRecords
if mLev = 4 and strEmailVal = "1" and strRestrictReg = "1" and strEmail = "1" then
'## Forum_SQL - Get membercount from DB
Not being able to find that in the readme, this is what seems logical to me. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
Edited by - ruirib on 14 July 2005 11:14:50 |
|
|
|
Yamaboy
Starting Member
46 Posts |
Posted - 13 July 2005 : 14:38:47
|
Ok, now I got this after "correcting" things.
Here is a copy of the default.asp file. I don't know it the problem is there or in the database from this error.
http://www.yamaboy.com/snitz/default.zip
---------------------------------------------
Error Type:
ADODB.Recordset.1 (0x80004005)
SQLState: 4 Native Error Code: 1054 [TCX][MyODBC]Unknown column 'HIGHEST_ACTIVE_USERS_COUNT' in 'field list'
/forum/default.asp, line 853 |
|
|
|
Yamaboy
Starting Member
46 Posts |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Yamaboy
Starting Member
46 Posts |
Posted - 13 July 2005 : 16:05:05
|
Yes. Do I need to do anything after running the update asp file included with the mod?
I am running this from /admin_mod_dbsetup.asp. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Ouija
Starting Member
USA
15 Posts |
Posted - 14 July 2005 : 10:22:23
|
Yeah, I had an error in the instructions that removed the end if from the first code segment. once the end if was added back in it should be fixed.
Thank you Yammaboy for bringing this to my attention.
If your version is still misbehaving then all you should have to do to fix it is find:
## Update LastActive column
and just above that line add:
end if
Which it looks like ruirib already got you to do  |
Edited by - Ouija on 14 July 2005 10:27:27 |
|
|
|
Ouija
Starting Member
USA
15 Posts |
Posted - 14 July 2005 : 10:24:29
|
quote:
Originally posted by Yamaboy
Ok, now I got this after "correcting" things.
Here is a copy of the default.asp file. I don't know it the problem is there or in the database from this error.
http://www.yamaboy.com/snitz/default.zip
---------------------------------------------
Error Type:
ADODB.Recordset.1 (0x80004005)
SQLState: 4 Native Error Code: 1054 [TCX][MyODBC]Unknown column 'HIGHEST_ACTIVE_USERS_COUNT' in 'field list'
/forum/default.asp, line 853
That error should mean that the DBS file wasn't run from the MOD menu correctly.
If you look at your Database there should be a field called 'HIGHEST_ACTIVE_USERS_COUNT' after you runt he DBS file.
I'm looking at yoru zip file right now to see what's up if anything and putting it on my prototype site to make sure that you got everything correct.
I think i see a glitch, working on it now. |
Edited by - Ouija on 14 July 2005 10:32:30 |
|
|
|
Ouija
Starting Member
USA
15 Posts |
Posted - 14 July 2005 : 10:43:39
|
Version 3.1 is now on SnitzBits
There was an error in the DBS File that I have fixed. If you download the 3.1 version and run the DBS file it should correct the problems you are having.
http://www.snitzbitz.com/mods/details.asp?Version=All&mid=207
Let me know how it goes, and if you have any further trouble. Thank you very much for coming to my site and asking me about the MOD! |
Edited by - Ouija on 14 July 2005 10:44:19 |
|
|
|
Yamaboy
Starting Member
46 Posts |
Posted - 14 July 2005 : 11:03:35
|
| Thanks! BTW I assume I just delete the old dbs_Active_(Logged_In)_Users.asp and then upload and run the new one to update the database? |
|
|
|
Ouija
Starting Member
USA
15 Posts |
Posted - 14 July 2005 : 14:50:49
|
quote:
Originally posted by Yamaboy
Thanks! BTW I assume I just delete the old dbs_Active_(Logged_In)_Users.asp and then upload and run the new one to update the database?
Yes. you can either overwrite the old version or delete it first. just run the new version once it's uploaded to yoru server. |
|
|
| |
Topic |
|
Topic Locked
