| Author |
 Topic  |
|
|
Beano_ie
Junior Member
Ireland
328 Posts |
 Posted - 08 December 2002 : 17:08:14
|
Poll Mod Version: 2.0.1
Current Author: Davio
Original Author: Slemieux (giving him credit for the original poll script)
Last Modified: October 16, 2002
For Snitz Version: 3.4.03
Ok basically I am getting the following error when I go onto a topic;
ADODB.Recordset error '800a0cc1'
Item cannot be found in the collection corresponding to the requested name or ordinal.
/forumdf2_2/topic.asp, line 136
line 136 reads: Member_PM = rsTopic("M_PMRECEIVE")
There was another topic about his originally by Goju, it was OpenIntro who had the same probelm, back in November, but it was never concluded, nothing was said about what happened or what changed. He/She had the exact same problem.
My topic.asp can be viewed at the following link;
http://www.droghedatowncentre.com/forumdf2_2/topic.txt
And my post.asp can be viewed here;
http://www.droghedatowncentre.com/forumdf2_2/post.txt
I hope someone has had the same error or can help, I've been trying to implement Polls for a long time.
Thanks. |
Steve
Drogheda, Ireland @ www.droghedatown.com |
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 08 December 2002 : 20:16:22
|
| But you haven't added any poll mod code to your topic.asp file. |
Support Snitz Forums
|
 |
|
|
Beano_ie
Junior Member
Ireland
328 Posts |
Posted - 09 December 2002 : 03:17:31
|
My apologies, I had uploaded the wrong topic.txt, the new one is now up.
Ty. |
Steve
Drogheda, Ireland @ www.droghedatown.com |
|
|
|
Beano_ie
Junior Member
Ireland
328 Posts |
Posted - 10 December 2002 : 11:33:58
|
I think I was mis-understood, my own fault  , I meant the new topic.txt is up, I am still having the same problem. |
Steve
Drogheda, Ireland @ www.droghedatown.com |
Edited by - Beano_ie on 11 December 2002 05:43:26 |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 11 December 2002 : 18:02:02
|
| I will help you soon. Don't think I am ignoring you. Just haven't had time to access the forum from home (I'm at work) and home is where my tools are to help you. |
Support Snitz Forums
|
|
|
|
Beano_ie
Junior Member
Ireland
328 Posts |
Posted - 12 December 2002 : 06:26:42
|
Thanks Davio, no rush  |
Steve
Drogheda, Ireland @ www.droghedatown.com |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 13 December 2002 : 00:09:21
|
Firstly, the error you are getting means you are calling the field M_PMRECEIVE but you didn't SELECT it from the database. You must have copied over the sql statement from the poll mod and removed that field from the sql statement. You can add it to line 106 in your topic.asp file (new code in red):strSql = "SELECT M.M_NAME, M.M_RECEIVE_EMAIL, M.M_AIM, M.M_ICQ, M.M_MSN, M.M_YAHOO, M_PMRECEIVE" & _ And on line 143 you are calling the Avatar URL:Member_Avatar = rsTopic("M_AVATAR_URL")but you don't have it selected in your sql statement. (Most likely the same reason for the first one) You can try adding it to the same line as above (line 106) (new code in green):strSql = "SELECT M.M_NAME, M.M_RECEIVE_EMAIL, M.M_AIM, M.M_ICQ, M.M_MSN, M.M_YAHOO, M_PMRECEIVE, M_AVATAR_URL" & _ Looking through the rest of the file, I see you didn't add any more poll mod after that. You just seemed to have added some then stopped.
Continue adding the rest of the poll mod code. If you run into more problems let me know. |
Support Snitz Forums
|
|
|
|
Beano_ie
Junior Member
Ireland
328 Posts |
Posted - 13 December 2002 : 06:54:32
|
Hiya Davio, thanks for your time. For some stupid reason I appear to have been using an old topic file. I only realised this when you pointed out Avatars above.
Must have happened while using my file comparison tool
Now that I've checked it out, I am still getting the original error;
ADODB.Recordset error '800a0cc1'
Item cannot be found in the collection corresponding to the requested name or ordinal.
/forumdf2_2/topic.asp, line 136
http://www.droghedatowncentre.com/forumdf2_2/topic.asp?TOPIC_ID=3695
I have also updated the topic.txt file.
Thx. |
Steve
Drogheda, Ireland @ www.droghedatown.com |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 13 December 2002 : 08:07:14
|
Come on Steve, that's the second time you got me looking at an old file. Please double check that this is the correct file.
And if it is still the same error on line 136, add the code I told you to add in red in my last post and forget about the green code. I presume you have the Private Messages mod right? |
Support Snitz Forums
|
|
|
|
Beano_ie
Junior Member
Ireland
328 Posts |
Posted - 13 December 2002 : 09:40:14
|
My apologies Davio, have been very busy lately and my tiredness has been playing tricks on me. I'm going to leave it for a while until I'm ready to sort it out fully.
I added the , M_PMRECEIVE as you said and the topic is appearing fine.
Thank you and again sorry, I understand it is frustrating. |
Steve
Drogheda, Ireland @ www.droghedatown.com |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 14 December 2002 : 07:37:23
|
Glad you're not getting anymore errors. If you still have trouble installing the poll mod, I'm here for you. Just make sure you don't make your post when your tired ok?  |
Support Snitz Forums
|
|
|
|
Beano_ie
Junior Member
Ireland
328 Posts |
Posted - 16 December 2002 : 10:47:14
|
Thanks for your time Davio, the poll mod is working great. I was using a 'file comparison tool' for the first time and because of this i was missing certain code that needed to be added.
A lesson has been learnt here lol and I did leave a vote at snitz bitz
Thx. |
Steve
Drogheda, Ireland @ www.droghedatown.com |
|
|
| |
Topic |
|
Topic Locked
