Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Snitz Forums 2000 DEV-Group
 DEV Bug Reports (Open)
 BUG (3.1sr4): Snitz on Chili!Asp problems...
 New Topic  Topic Locked
 Printer Friendly
Previous Page | Next Page
Author Previous Topic Topic Next Topic
Page: of 3

barky81
Junior Member

USA
166 Posts

Posted - 13 January 2001 :  14:51:39  Show Profile
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
Go to Top of Page

gor
Retired Admin

Netherlands
5511 Posts

Posted - 13 January 2001 :  16:59:54  Show Profile  Visit gor's Homepage
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
Go to Top of Page

barky81
Junior Member

USA
166 Posts

Posted - 13 January 2001 :  21:01:22  Show Profile
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.


Go to Top of Page

gor
Retired Admin

Netherlands
5511 Posts

Posted - 13 January 2001 :  21:06:52  Show Profile  Visit gor's Homepage
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
Go to Top of Page

gor
Retired Admin

Netherlands
5511 Posts

Posted - 18 January 2001 :  02:42:15  Show Profile  Visit gor's Homepage
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
Go to Top of Page

barky81
Junior Member

USA
166 Posts

Posted - 18 January 2001 :  10:11:30  Show Profile
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?

Go to Top of Page

barky81
Junior Member

USA
166 Posts

Posted - 18 January 2001 :  10:55:02  Show Profile
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?

Go to Top of Page

barky81
Junior Member

USA
166 Posts

Posted - 23 January 2001 :  10:05:54  Show Profile
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...)

Go to Top of Page

gor
Retired Admin

Netherlands
5511 Posts

Posted - 23 January 2001 :  10:50:19  Show Profile  Visit gor's Homepage
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
Go to Top of Page

barky81
Junior Member

USA
166 Posts

Posted - 23 January 2001 :  11:37:58  Show Profile
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!

Go to Top of Page

gor
Retired Admin

Netherlands
5511 Posts

Posted - 23 January 2001 :  13:43:32  Show Profile  Visit gor's Homepage
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
Go to Top of Page

barky81
Junior Member

USA
166 Posts

Posted - 23 January 2001 :  15:26:50  Show Profile
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?)

Go to Top of Page

barky81
Junior Member

USA
166 Posts

Posted - 30 January 2001 :  01:06:18  Show Profile
burpee, er, bump....



Edited by - barky81 on 15 February 2001 12:08:06
Go to Top of Page

Enigma
Starting Member

Germany
16 Posts

Posted - 16 March 2001 :  02:23:14  Show Profile  Visit Enigma's Homepage
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

Go to Top of Page

mario van Ginneken
Starting Member

Netherlands
5 Posts

Posted - 02 June 2001 :  04:36:15  Show Profile  Visit mario van Ginneken's Homepage
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



Go to Top of Page
Page: of 3 Previous Topic Topic Next Topic  
Previous Page | Next Page
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.13 seconds. Powered By: Snitz Forums 2000 Version 3.4.07