Author |
Topic  |
c1sissy
New Member

85 Posts |
Posted - 04 May 2003 : 14:03:43
|
Somehow I have ended up with two statistic tables at the bottom of my page http://home.1asphost.com/fibrom/default.asp I'm not really sure how this happened. I'm not done installing the mod yet, but have discovered this.
Unfortunatly my host is slower then molases in alaska anymore and it is taking forever to do this. If anyone could help me as to how to solve this one little problem I would appreciate it!
Thanks in advance. |
c1sissy
Can I hypnotise myself to learn faster??!!! http://rienfam.tripod.com |
|
c1sissy
New Member

85 Posts |
Posted - 04 May 2003 : 18:29:56
|
I'm having an additional problem, Microsoft VBScript compilation error '800a03ea'
Syntax error
/fibrom/inc_header.asp, line 260
' Get Private Message count for display I have copied the code exactly as it is in the read file, though If there is soemthing that I am not doign correctly, please let me know! thanks in advance
|
c1sissy
Can I hypnotise myself to learn faster??!!! http://rienfam.tripod.com |
 |
|
Nikkol
Forum Moderator
    
USA
6907 Posts |
|
c1sissy
New Member

85 Posts |
Posted - 04 May 2003 : 19:06:13
|
Hi Nikkol, How do I do this, or should I just give access to the file manager? |
c1sissy
Can I hypnotise myself to learn faster??!!! http://rienfam.tripod.com |
 |
|
Nikkol
Forum Moderator
    
USA
6907 Posts |
|
c1sissy
New Member

85 Posts |
Posted - 04 May 2003 : 19:28:22
|
ok, it will be a different site from what I am working on right now, this host is terribly slowwwwwww. extremly annoying!
I'll get to work on it now, thanks appreciate it! |
c1sissy
Can I hypnotise myself to learn faster??!!! http://rienfam.tripod.com |
 |
|
Nikkol
Forum Moderator
    
USA
6907 Posts |
|
c1sissy
New Member

85 Posts |
Posted - 04 May 2003 : 19:39:04
|
http://c1sissy.tripod.com/include/inc_header.txt here it is , thanks appreciate it big time!
I thought that this was going to go easy, lol I did the poll mod through the week, and fixed the problems that arose. This one though, I can't figure out at all! |
c1sissy
Can I hypnotise myself to learn faster??!!! http://rienfam.tripod.com |
Edited by - c1sissy on 04 May 2003 19:40:08 |
 |
|
Hamlin
Advanced Member
    
United Kingdom
2386 Posts |
Posted - 04 May 2003 : 19:54:32
|
" popupWin = window.open(url,'new_page','width=450,height=525,scrollbars=yes,toolbars=yes,menubar=yes,resizable=yes')" & vbNewLine & _
"}" & vbNewLine & _
' Get Private Message count for display
Try removing the code in red shown above, line 259
EDIT - And add the code shown in green below (line 276)...
response.write "function openWindow6(url) {" & vbNewLine & _
" popupWin = window.open(url,'new_page','width=500,height=450,scrollbars=yes')" & vbNewLine & _
"}" & vbNewLine & _
|
Edited by - Hamlin on 04 May 2003 19:56:45 |
 |
|
ruirib
Snitz Forums Admin
    
Portugal
26364 Posts |
Posted - 04 May 2003 : 19:58:51
|
You are sure that this code that is currently at line# 260 should go in line# 260:
' Get Private Message count for display
if strDBType = "access" then
strSqL = "SELECT count(M_TO) as [pmcount] "
else
strSqL = "SELECT count(M_TO) as pmcount "
end if
strSql = strSql & " FROM " & strMemberTablePrefix & "MEMBERS , " & strTablePrefix & "PM "
strSql = strSql & " WHERE " & strMemberTablePrefix & "MEMBERS.M_NAME = '" & strDBNTUserName & "'"
strSql = strSql & " AND " & strMemberTablePrefix & "MEMBERS.MEMBER_ID = " & strTablePrefix & "PM.M_TO "
strSql = strSql & " AND " & strTablePrefix & "PM.M_READ = 0 "
Set rsPM = my_Conn.Execute(strSql)
pmcount = rsPM("pmcount")
rsPM.close
set rsPM = nothing
I find it very strange that it needs to go at this line. You're "breaking" existing code when you do this and that's why you're getting the error. Check the readme for the mod. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
 |
|
ruirib
Snitz Forums Admin
    
Portugal
26364 Posts |
|
c1sissy
New Member

85 Posts |
Posted - 04 May 2003 : 20:05:32
|
Hi ruirib, how are you?! yes, that is how it is in the help file. I checked it and double checked it a zillion times.
I played with it a bit, and changed it back, moved it about to where it seemed as though it would make more sense.
here is the copy from the help file
INC_HEADER.ASP Add the following: (about line 260)
This code needs to be after the connection is opened near the top of the page and after strDBNTUserName is defined. It needs to be placed before sForumNavigation() is called.
Select All ' Get Private Message count for display if strDBType = "access" then strSqL = "SELECT count(M_TO) as [pmcount] " else strSqL = "SELECT count(M_TO) as pmcount " end if strSql = strSql & " FROM " & strMemberTablePrefix & "MEMBERS , " & strTablePrefix & "PM " strSql = strSql & " WHERE " & strMemberTablePrefix & "MEMBERS.M_NAME = '" & strDBNTUserName & "'" strSql = strSql & " AND " & strMemberTablePrefix & "MEMBERS.MEMBER_ID = " & strTablePrefix & "PM.M_TO " strSql = strSql & " AND " & strTablePrefix & "PM.M_READ = 0 "
Set rsPM = my_Conn.Execute(strSql) pmcount = rsPM("pmcount")
rsPM.close set rsPM = nothing
I knew that I had placed it correctly, lol, at least I had hoped that I had. And chekced it and double checked it over and over to see if I was missing something or leaving something out, but it checked each time.
Nikkol thanks for the help, I'll get to this asap. dinner calls for the hungry young ones about now! lol
|
c1sissy
Can I hypnotise myself to learn faster??!!! http://rienfam.tripod.com |
 |
|
ruirib
Snitz Forums Admin
    
Portugal
26364 Posts |
Posted - 04 May 2003 : 20:10:50
|
I would place it at line# 292, immediately before this line:
call sForumNavigation()
Like that you do not need to change existing code, inserting the new code will be enough. Otherwise you will need to add the changes posted by Hamlin. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
 |
|
c1sissy
New Member

85 Posts |
Posted - 04 May 2003 : 20:31:38
|
grin, I tried that per the directions, still didn't work.
What I do to get the correct lines, assuming that the mod creator is going by the orignal file lines before additional mods are installed, Is that I open it in homesite and see where the line # is. So I looked for the sForumNavigation, placed the code in there and it didn't work out at all. I'll try it again and see what I get, but I dont think that it is going to work.
Thanks again, all help is greatly appreciated on this end! big time! |
c1sissy
Can I hypnotise myself to learn faster??!!! http://rienfam.tripod.com |
 |
|
ruirib
Snitz Forums Admin
    
Portugal
26364 Posts |
Posted - 04 May 2003 : 20:35:16
|
If you insert it where I told you I'm absolutely sure that it will work. There is no reason not to.
Don't look just for sForumNavigation, but for call sForumNavigation.
Also, don't forget to remove the code from the location where you had previously inserted it. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
 |
|
c1sissy
New Member

85 Posts |
Posted - 04 May 2003 : 21:41:05
|
ahhh, maybe that's what I had done. I'll look for the code and do it and let you know along with the changes from nikkol. Thanks again. I'll get back to you soemtime tomorrow afternoon. |
c1sissy
Can I hypnotise myself to learn faster??!!! http://rienfam.tripod.com |
 |
|
Topic  |
|