Author |
Topic  |
barky81
Junior Member
 
USA
166 Posts |
Posted - 13 January 2001 : 14:51:39
|
This error is from your test site as well: ---- ADODB.Connection.1 error '80004005'
SQLBindParameter not used for all parameters
/~gor/Snitz_3_1_SR4/post_info.asp, line 577 ----
See:


These are the same errors my site gives off.
Edited by - barky81 on 15 February 2001 12:19:29 |
 |
|
gor
Retired Admin
    
Netherlands
5511 Posts |
Posted - 13 January 2001 : 16:59:54
|
quote:
Well, not surprisingly the ASP engine has died at my site again (as described above). And it appears that I cannot reach your site either gor (so you might want to check yours).
When you say you can't reproduce the error, do you mean "on your site" or "my site"?
Did you site die too?
At first I couldn't reproduce them at "my site" but then it looked like it died. Didn't contact the site-admin yet to see if it really died.
It was back up a few minutes ago, and when I started testing everything worked ok. Now I got a
HTTP Error 507 507 Unexpected
The Web server encountered an unexpected error while communicating with the ASP service.
Please contact the server's administrator if this problem persists.
when I pressed reload I got
error '800a0cc1'
ADO Could not find the object in the collection corresponding to the name or ordinal reference requested by the collection.
inc_functions.asp, line 658
It saved the changes however.
Preview didn't work the first time I posted, but works now again.
So, the good news is, it isn't your server that is causing this. The bad news: I haven't got a clue yet as to were to start looking for a fix for this.
I've posted a link to this topic in the BUGS forum.
Pierre |
 |
|
barky81
Junior Member
 
USA
166 Posts |
Posted - 13 January 2001 : 21:01:22
|
quote:
At first I couldn't reproduce them at "my site" but then it looked like it died. Didn't contact the site-admin yet to see if it really died.
It was back up a few minutes ago, and when I started testing everything worked ok.
Well, it's possible that your host pings the server to test for response (and auto-reboots). Because, yes, it looks to me that you site dies, but comes back.
I have discussed something similar with my host, but for now I must manually request a restart...
quote:
Preview didn't work the first time I posted, but works now again.
So, the good news is, it isn't your server that is causing this. The bad news: I haven't got a clue yet as to were to start looking for a fix for this.
I've posted a link to this topic in the BUGS forum.
Pierre
Well, that is what brings me kinda back to where I started: Is there/has there been a "true" working version of Snitz for linux/chiliasp/mysql? 'Cause that's the place to start looking for the differences. There definitely seems to be a problem in preview.asp; and the post.asp/post_info.asp as well?
Anyway, thanks, I hope we can figure it out. (And I guess I'm s'posed to be using the topic in BUGS now, huh.
|
 |
|
gor
Retired Admin
    
Netherlands
5511 Posts |
Posted - 13 January 2001 : 21:06:52
|
quote:
Anyway, thanks, I hope we can figure it out. (And I guess I'm s'posed to be using the topic in BUGS now, huh.
I posted the link there so this would be remembered during bugsweeping. For now, replying to this topic is best thing to do.
Pierre |
 |
|
gor
Retired Admin
    
Netherlands
5511 Posts |
|
barky81
Junior Member
 
USA
166 Posts |
Posted - 18 January 2001 : 10:11:30
|
Hey, gor!
It seems that you also changed the title of this thread? (Didn't you?)
And now I don't get notifications of posts to this thread.... (I happened to be searching for it so that I could make a new post...just stumbled on it by chance.)
For instance, I did not get notified of this post of yours...but anyway...
quote:
I changed the post_info.asp at the softcastle site. (see: http://forum.snitz.com/forum/link.asp?TOPIC_ID=3764 for fixes).
Does this make the errors go away for you there ?
Never mind, I just got an error.... 
Pierre
I understand from your earlier posts (as well as this one) that you are looking at problems that may be related to the e-mail functions. (I even followed your earlier advice to set "ChiliMail" in mailserverconfig, even though mail is not enabled on my site.)
My own suspicions lie in another area, however: On my site, I am using the website cookie method (strUniqueID), but the forum code still relies on strcookieURL for a lot of action.
For example, I have a pop_preview.asp problem in which I can only preview once, after which I get the "< there is no text to preview >" default response... See this code from post.asp:
function OpenPreview() { var curCookie = "strMessagePreview=" + escape(document.PostTopic.Message.value); document.cookie = curCookie; popupWin = window.open('pop_preview.asp', 'preview_page', 'scrollbars=yes,width=750,height=450') }
It apparently stuffs the message text into a variable to pass to pop_preview.asp for display.... Then pop_preview.asp does this:
<% strMessagePreview = Request.Cookies("strMessagePreview") Response.Cookies("strMessagePreview") = "" if strMessagePreview = "" or IsNull(strMessagePreview) then strMessagePreview = "< There is no text to preview ! >" end if %>
Now, I don't claim to understand all this, but... I don't see anything that "deals with" the empty cookie this creates... Once I close the pop_preview.asp spawned document window, is the cookie supposed to be discarded? (Because I don't think it is. Instead, I think it "hangs around with its value set to "") So I have been wondering if this is a problem that only affects "website" cookie sites?
|
 |
|
barky81
Junior Member
 
USA
166 Posts |
Posted - 18 January 2001 : 10:55:02
|
quote:
I took a look at your site, I could post without a problem with the test-account, but when I tried to edit it, I got this error:
error '800a0cc1'
ADO Could not find the object in the collection corresponding to the name or ordinal reference requested by the collection.
inc_functions.asp, line 656
Pierre
Regarding this error specifically, I have been looking around. You will note that on each of our sites, the error comes back off a line or two (because I added that extra stuff at the top of mine). In both cases, it's referring back to this code in inc_functions.asp:
function getMemberID(fUser_Name)
'## Forum_SQL strSql = "SELECT " & strMemberTablePrefix & "MEMBERS.MEMBER_ID " strSql = strSql & " FROM " & strMemberTablePrefix & "MEMBERS " strSql = strSql & " WHERE M_NAME = '" & fUser_Name & "'"
rsGetMemberID = my_Conn.Execute(strSql) getMemberID = rsGetMemberID("MEMBER_ID")
end function
So looking through post_info.asp (which is the actual operative page at the time of the error), I find this code:
'## Forum_SQL - Update Last Post strSql = " UPDATE " & strTablePrefix & "TOPICS" strSql = strSql & " SET T_LAST_POST = '" & DateToStr(strForumTimeAdjust) & "'" strSql = strSql & ", T_LAST_POST_AUTHOR = " & getMemberID(STRdbntUserName) strSql = strSql & " WHERE TOPIC_ID = " & Request.Form("TOPIC_ID")
my_Conn.Execute (strSql)
Note where it "calls" the getMemberID function within the sql statement.... does this constitute a "subselect" sql query (as discussed here)?
Could that be part of the problem?
|
 |
|
barky81
Junior Member
 
USA
166 Posts |
Posted - 23 January 2001 : 10:05:54
|
bomp . . .
(I don't know how to help, because I don't know where to look. I have asked questions that have not been answered, so I don't know what to test for...)
|
 |
|
gor
Retired Admin
    
Netherlands
5511 Posts |
Posted - 23 January 2001 : 10:50:19
|
barky,
I took a look at the function you mentioned but couldn't see anything wrong with it. I changed one thing, just in case, but that didn't help as you noticed when you tested yesterday (thank you for that ).
I did a search for the error message at http://www.chilisoft.com/ at http://www.mysql.com and at the RAQ website (don't know the url anymore). I couldn't find any reference to the errormessage!
The Softcastle site is down at the moment, I didn't have time to look at the preview problem yet.
My feeling is the same as yours: why doesn't it work anymore and why did older versions work without a problem 
(but I wasn't ignoring you or forgetting that this problem is there, I really appreciate your help!)
Pierre |
 |
|
barky81
Junior Member
 
USA
166 Posts |
Posted - 23 January 2001 : 11:37:58
|
quote:
barky,
I took a look at the function you mentioned but couldn't see anything wrong with it. I changed one thing, just in case, but that didn't help as you noticed when you tested yesterday (thank you for that ).
Okay, well I have continued to stumble around, and now I have a question: An inconsistency "seems" to have crept into the code (or, then again, it may just be me). In searching around, I can find 7 files referencing "strdbntsqlname" versus 15 files using "strdbntusername'. (Of course, there is also some typographic inconsistency in the rendering of STRdbnt...versus strDBNT... etc.)
In particular, I note the function I mentioned calls it this way:
getMemberID(STRdbntUserName)
Are you sure this is not a problem?
quote:
I did a search for the error message at http://www.chilisoft.com/ at http://www.mysql.com and at the RAQ website (don't know the url anymore). I couldn't find any reference to the errormessage!
http://www.cobalt.com/index.html
quote:
The Softcastle site is down at the moment, I didn't have time to look at the preview problem yet.
Yes, I have noticed this....
quote:
My feeling is the same as yours: why doesn't it work anymore and why did older versions work without a problem 
Well, two things (big changes?) in particular jump out at me: The above-mentioned strdbnt... issue, and the new "allowed user list" combo box code that has been added.... (haven't done anything with that).
quote:
(but I wasn't ignoring you or forgetting that this problem is there, I really appreciate your help!)
Pierre
Of that I am quite sure! 
I was really just trying to keep the topic toward the top (cause it is important to me...) and hoping someone else might chime in. (I don't think I have the skills to deal with the problem; and I am sure you have more important "matters" in your hands.)
Again, thank you!
|
 |
|
gor
Retired Admin
    
Netherlands
5511 Posts |
Posted - 23 January 2001 : 13:43:32
|
Ok, I checked the case-matching for the variable, could you try to break it for me again. I don't seem to be able to, but you usually are . Still strange results with the preview, sometimes it works a few times in a row, sometimes it won't work.
Maybe writing it in a cookie wasn't the best choice (it was the easiest).
Pierre |
 |
|
barky81
Junior Member
 
USA
166 Posts |
Posted - 23 January 2001 : 15:26:50
|
quote:
Ok, I checked the case-matching for the variable, could you try to break it for me again. I don't seem to be able to, but you usually are .
It breaks on demand.... I have been still searching the SQLbindparameter error links, and here's an M$ reference or two:
http://msdn.microsoft.com/library/psdk/dasdk/odch6jhu.htm
http://msdn.microsoft.com/library/psdk/dasdk/odap1v77.htm
And then there is this:
http://www.phpbuilder.com/mail/php-developer-list/199912/0376.php (which suggests that the order or datatype of multiple parameters may influence the error.)
quote:
Still strange results with the preview, sometimes it works a few times in a row, sometimes it won't work.
Maybe writing it in a cookie wasn't the best choice (it was the easiest).
I still don't know whether it is the combination of website (struniqueID) cookie and forum (strcookieurl) cookie code that triggers the issue; are we sure it is a linux/chiliasp/mysql issue? What cookie(s) are you running on your test site? Is there anyway to "temporarily" take it out of the cookie (or re-write that cookie to use the struniqueid)? The issue still "seems" to be that sometimes(?!?!) once the strmessagepreview gets set to "" (or to "there is no text...") it appears to "stick" that way. Is there a better way to write these functions in post.asp: "function autoReload(objform)" and "function OpenPreview()"
And just to clarify the "case-matching for the variable", are there "2" variables (strdbntusername AND strdbntsqlname) or should this all be corrected and standardized in the code base (to just 1 variable)? (Will you post a Bug for sweeping purposes?)
|
 |
|
barky81
Junior Member
 
USA
166 Posts |
Posted - 30 January 2001 : 01:06:18
|
burpee, er, bump....
Edited by - barky81 on 15 February 2001 12:08:06 |
 |
|
Enigma
Starting Member
Germany
16 Posts |
Posted - 16 March 2001 : 02:23:14
|
WEll after reading the whole topic and reviewing my problems the last three days We got the same on my server. However can I please know of any solution for this could I please have the new version with this particular bug fixes Is it actual possible to run snitz on the server specs above?
Thanks
|
 |
|
mario van Ginneken
Starting Member
Netherlands
5 Posts |
Posted - 02 June 2001 : 04:36:15
|
Hi,
I think Snitz is doomed to run badly on any Chillisoft server, mine does not run either and I am also on a providers' system running Chillisoft...
my wannabe-forum is on http://www.koningsschutters.nl/schietsport
|
 |
|
Topic  |
|