| Author |
 Topic  |
|
taropatch
Average Member
USA
741 Posts |
 Posted - 01 April 2004 : 11:31:49
|
I just updated to 3.4.04 along with some of the mods I'm running. Everything seemed to be working fine EXCEPT when I post, I get this: quote:
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:
Open the home page, and then look for links to the information you want.
Click the Refresh button, or try again later.
Click Search to look for information on the Internet.
You can also see a list of related sites.
HTTP 500 - Internal server error
Internet Explorer
Think there is a problem with my post_info.asp? Or is it a permissions problem on my db? Appreciate any quick help. |
Edited by - taropatch on 02 April 2004 11:46:49 |
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
|
|
taropatch
Average Member
USA
741 Posts |
Posted - 01 April 2004 : 11:51:34
|
Thanks Nikkol (and for reponding so quickly).quote:
Microsoft VBScript compilation error '800a03f6'
Expected 'End'
/forum/post_info.asp, line 2103
I may have messed up the file when applying the poll mod. Was not sure about a couple of things when I compared the 3.4.04 file.
I'm not sure what the error is telling me? |
Edited by - taropatch on 01 April 2004 11:59:09 |
 |
|
|
taropatch
Average Member
USA
741 Posts |
Posted - 01 April 2004 : 13:16:03
|
Well, given the problems I'm having, I reverted back to my 3.4.03 with older mods.
Not sure if the admins/moderators want to keep this post here or move it to the mod implementation forum.
I'm trying to troubleshoot but not having much luck. If anyone could take a look at my post_info.asp file, I'd really appreciate some expert help. Thanks. |
Edited by - taropatch on 02 April 2004 10:21:51 |
|
|
|
Jezmeister
Senior Member
United Kingdom
1141 Posts |
Posted - 01 April 2004 : 13:39:23
|
well your problem was telling you that the problem is in post_info.asp line 2103 - id have a look but you seem to have removed the .txt file... it could be that you had to remove & _ when installing a mod and didnt or that you had to add Response.Write to the line after a mod - theyre not the only possibilities obviously but a few of the mods require that |
|
|
|
taropatch
Average Member
USA
741 Posts |
Posted - 01 April 2004 : 13:56:25
|
Oops, sorry. When I reverted back - I forgot to move the .txt file. It's back up now.
When working on the poll 2.0.7 mod, I was not sure at around line 1005. |
Edited by - taropatch on 02 April 2004 10:22:15 |
|
|
|
Jezmeister
Senior Member
United Kingdom
1141 Posts |
Posted - 01 April 2004 : 14:14:23
|
not sure why you got the error - but try removing
'## Subscribe checkbox end ##
from the end of your post_info.asp - im not entirely sure why it should be a problem but that seems to be where the problem is falling...
O and 1005 is where the poll mod should be - you have put it in the right place so that shouldnt be a problem |
|
|
|
taropatch
Average Member
USA
741 Posts |
Posted - 01 April 2004 : 15:37:31
|
I deleted '## Subscribe checkbox end ## and the got this:quote:
Microsoft VBScript compilation error '800a03f6'
Expected 'End'
/forum34/post_info.asp, line 2101
I've looked at the post_info.asp and cannot figure out what is going wrong. On another note, my active topics is resulting in: quote:
Microsoft VBScript compilation error '800a0400'
Expected statement
/forum34/active.asp, line 595
end if
^
So it would seem I have more than one problem going on? I'll take a closer look at home tonight. Double check the premod files vs the mod files.
I do appreciate any help though because I do not know much ASP. Thanks Jezmeister. |
|
|
|
Jezmeister
Senior Member
United Kingdom
1141 Posts |
Posted - 01 April 2004 : 17:42:59
|
hmm i feel i should do something to earn that thanks lol well the problem isnt that you've removed the '##Subscribe checkbox end##
hmm i get expected statements all the time when i play about with the scripts... its usually a missing & _ on the line above or that the part in question simply isnt needed - check that you actually have an if statement that needs ending above it (am not actually checking the file here so i could be completely wrong)...
considering you have two problems simultaneosly i would check that you have followed the installation instructions for all your mods correctly. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 01 April 2004 : 20:25:59
|
It's plain hard to find out the cause for an error, if you test the forum after adding several mods.
I would suggest one of two alternatives:
1. Review the changes suggested by each mod in each of the files where you're having errors, because you forgot some changes for sure.
2. This is a last resort one: get a fresh base version and add the mods one by one. Test the full functionality after adding each mod. Like that you will know what mod causes any given problem, if problems do arise. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
taropatch
Average Member
USA
741 Posts |
Posted - 02 April 2004 : 00:24:03
|
Okay, I was able to isolate it to the polls 2.0.7 mod. I kept a backup of files pre-poll mod, and with them, the forum works fine.
I was also able to find an extra "end if" in active.asp. So that's fixed. 
So it comes down to post_info.asp from version 3.4.04 with the poll mod code. I'm still not sure where I've gone wrong. There must be an "end if" or "end sub" missing? I'm assuming that's what is meant by Expected 'End'. I keep going through the file using WinMerge.
So I'm closer, almost, but not quite... |
|
|
|
taropatch
Average Member
USA
741 Posts |
Posted - 02 April 2004 : 00:55:34
|
I think I'm having trouble merging the following...
Poll mod post_info.asp around lines 957-993
strSql = strSql & ", 1 "
strSQL = strSQL & ", 0 "
strSQL = strSQL & ", 0 "
strSql = strSql & ")"
my_Conn.Execute (strSql),,adCmdText + adExecuteNoRecords
'############################ Poll Mod ##############################
if Request.Form("poll") = "1" then
strSql = "SELECT " & strTablePrefix & "TOPICS.TOPIC_ID "
strSql = strSql & "FROM " & strTablePrefix & "TOPICS "
strSql = strSql & "WHERE " & strTablePrefix & "TOPICS.T_ISPOLL = " & 1 & " "
strSql = strSql & "ORDER BY " & strTablePrefix & "TOPICS.T_DATE DESC"
set rsPollID = my_Conn.Execute (strSql)
PollID = rsPollID("TOPIC_ID")
rsPollID.close
set rsPollID = nothing
'## Forum_SQL - Add new poll to Polls Table
strSql = "INSERT INTO " & strTablePrefix & "POLLS (CAT_ID"
strSql = strSql & ", FORUM_ID"
strSql = strSql & ", TOPIC_ID"
strSql = strSql & ", P_WHOVOTES"
for i = 1 to ubound(txtAns)
strSql = strSql & ", ANSWER" & CStr(i)
strSql = strSql & ", COUNT" & CStr(i)
next
strSql = strSql & ") VALUES ("
strSql = strSql & Cat_ID
strSql = strSql & ", " & Forum_ID
strSql = strSql & ", " & PollID
strSql = strSql & ", '" & chkString(Request.Form("WhoVotes"),"SQLString") & "'"
for i = 1 to ubound(txtAns)
strSql = strSql & ", '" & chkString(txtAns(i),"") & "'"
strSql = strSql & ", " & 0
next
3.4.04 post_info.asp around lines 881-887
end if
else
strSql = strSql & ", 1 "
end if
strSql = strSql & ", 0 "
strSql = strSql & ", 0 "
Can someone please tell me what this code should look like after copying the poll code into the base 3.4.04 post_info.asp?  |
Edited by - taropatch on 02 April 2004 15:21:05 |
|
|
|
Jezmeister
Senior Member
United Kingdom
1141 Posts |
Posted - 02 April 2004 : 14:28:02
|
looks fine to me...
you can use the one at: <<link removed>> to check if you like - its the one i use on my forums - has polls installed, no other mods (that use post_info.asp anyway) |
Edited by - Jezmeister on 02 April 2004 15:31:27 |
|
|
|
taropatch
Average Member
USA
741 Posts |
Posted - 02 April 2004 : 15:19:54
|
Thanks Jezmeister!!!
That's exactly what I needed. When I used WinMerge, I was losing a few lines of important code. Just for the record (for me next time or maybe others), here are the changes I needed to make.
Your correct code... post_info.asp lines 999-1004
else
strSql = strSql & ", 1 "
end if
else
strSql = strSql & ", 1 "
end if
strSql = strSql & ", 0 "
strSql = strSql & ", 0 "
strSql = strSql & ")"
[bad code]My incorrect code... post_info.asp lines 999-1000
strSQL = strSQL & ", 0 "
strSQL = strSQL & ", 0 " [/bad code]
|
|
|
|
Jezmeister
Senior Member
United Kingdom
1141 Posts |
Posted - 02 April 2004 : 15:29:31
|
| hmm i must be going blind - i looked thru all that comparing it before I posted that link! lol nyway glad its sorted ;) |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
|
|
Topic |
|
Topic Locked
