| Author |
 Topic  |
|
blackinwhite
Average Member
Turkey
657 Posts |
 Posted - 27 March 2001 : 17:06:49
|
and I also got that error when I try to reach to the lasty post message from the main forum page.
-----
Microsoft JET Database Engine error '80040e10'
No value given for one or more required parameters.
/forum/topic.asp, line 97
|
 |
|
|
Luca
Starting Member
Italy
3 Posts |
Posted - 27 March 2001 : 17:11:39
|
I installed this mod in my forum: it's ok.
|
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 27 March 2001 : 17:31:59
|
quote:
but I got the error in a different place.
Edited by - blackinwhite on 27 March 2001 16:54:33
I have emailed your post.asp back to you.
|
|
|
|
blackinwhite
Average Member
Turkey
657 Posts |
Posted - 27 March 2001 : 17:52:57
|
quote:
quote:
but I got the error in a different place.
Edited by - blackinwhite on 27 March 2001 16:54:33
I have emailed your post.asp back to you.
I think you emailed ttnetworks' file, I didn't get any file. 
|
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 28 March 2001 : 09:38:41
|
I just checked, I definately sent it to the email address in your profile, try emailing me, I will sent it as a reply.
|
|
|
|
blackinwhite
Average Member
Turkey
657 Posts |
Posted - 28 March 2001 : 09:58:37
|
email has been sent. 
|
|
|
|
Rob Poretti
Junior Member
Canada
435 Posts |
Posted - 29 March 2001 : 22:57:55
|
Hi HuwR,
I've noticed that the sub PostNewTopic() has been re-written to some degree. I've installed the poll mod which inserts this code:
<% ' #################### Poll Mod #####################
if (strUserPolls = "1") or (mlev = 4 or mlev = 3) then %>
<a href="post.asp?poll=1&method=Topic&FORUM_ID=<% =Request.QueryString("FORUM_ID")%>&CAT_ID=<% =Request.QueryString("CAT_ID")%>&Forum_Title=<% =ChkString(Request.QueryString("FORUM_Title"),"urlpath") %>"><img src="pin.gif" alt="Add Poll" height=15 width=15 border=0></a> <a href="post.asp?poll=1&method=Topic&FORUM_ID=<% =Request.QueryString("FORUM_ID")%>&CAT_ID=<% =Request.QueryString("CAT_ID")%>&Forum_Title=<% =ChkString(Request.QueryString("FORUM_Title"),"urlpath") %>">Add Poll</a>
<% end if
' ################################################### %>
...just after this code, in your version:
if rsFStatus("F_STATUS") <> 0 then
response.write "<a href=""post.asp?method=Topic&FORUM_ID=" & Request.QueryString("FORUM_ID") & "&CAT_ID=" & Request.QueryString("CAT_ID") & "&Forum_Title=" & ChkString(Request.QueryString("FORUM_Title"),"urlpath") & """>"
response.write "<img src=""" & strImageURL & "icon_folder_new_topic.gif"" alt=""New Topic"" height=15 width=15 border=0></a> <a href=""post.asp?method=Topic&FORUM_ID=" & Request.QueryString("FORUM_ID") & "&CAT_ID=" & Request.QueryString("CAT_ID") & "&Forum_Title=" & ChkString(Request.QueryString("FORUM_Title"),"urlpath") & """>New Topic</a>"
Do you think this might cause any problems? Are you familiar with the Poll Mod? Anyone out ther install this mod with the poll mod?
Thanks for your help...
Oh... and one other thing... I'm using a sr2 version... would this mod be compatable with the sr2 base code in the post.asp and post_info.asp? For example, I noticed that the allowed user list box code uses the javascript mechanism to display the selected users. This started in sr3 or sr4, did it not? My post.asp doesn't have the javascript functions like "InsertSelection" or "MoveList". This was mainly done with asp.
I really need this mod, but both post.asp and post_info.asp files are a piece of work! -- I'm not sure about upgrading those files, but otherwise staying ins sr2. (Plus, both those files are moded with a couple of mods -- like the POLL mod.)
If this couldn't work in sr2, how isolated is the sr4 versions of post.asp and post_info.asp from the rest of the code? COuld I update those two files, deal with the cookie thing and have it all work with sr2 code?
As you can see, I really need to make this mod work...
Sorry for the trouble...
Rob
Rob Poretti 
Sascom Marketing Group ~ Toronto
vox.905.825.5373 fax.905.825.5960
Edited by - Rob Poretti on 29 March 2001 22:58:39
Edited by - Rob Poretti on 29 March 2001 23:19:02 |
|
|
|
Rob Poretti
Junior Member
Canada
435 Posts |
Posted - 31 March 2001 : 00:09:24
|
Has anyone tried implementing this mod in sr2?
Thanks,
Rob
Rob Poretti
Sascom Marketing Group ~ Toronto
vox.905.825.5373 fax.905.825.5960 |
|
|
|
Rob Poretti
Junior Member
Canada
435 Posts |
Posted - 01 April 2001 : 00:23:46
|
Hi Huwr,
I decided to take the plunge (after making some back-ups)
I'm not getting any errors but, when I change a forums properties to only allow mederators to post (All Users reply) -- it's not working... (Althought it is reporting that the post was successfull.)
When I go back to check the properties, they are back to "All Users".
The forum topic also shows: All users can post NEW topics in this forum. All users can reply to topics in this forum.
I think I can track this down... the DB gets updated in post_info.asp... correct?
Could you tell me where in this file it gets updated?
Rob Poretti
Sascom Marketing Group ~ Toronto
vox.905.825.5373 fax.905.825.5960 |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 01 April 2001 : 05:17:27
|
Rob, if you mail me your post_info.sp, i'll give it a quick look
|
|
|
|
Rob Poretti
Junior Member
Canada
435 Posts |
Posted - 01 April 2001 : 10:19:41
|
Hi HuwR,
Thanks for the offer! I tried emailing you via your profile email address and the message was returned (too many hops! - 21!) I sent it again in hopes that the routers got smarter the second time around!
In case they didn't get clever the second time around, you can download it here: post_info.zip
There are a LOT of mods in this file but they should all be documented. Good luck...
Rob Poretti
Sascom Marketing Group ~ Toronto
vox.905.825.5373 fax.905.825.5960
Edited by - Rob Poretti on 01 April 2001 10:21:04
BTW, I use Visual InterDev as an editor ... when I step through the code (after changing a forums properties so that only moderators can post to it - IE: Request.Form("Method_Type") = "EditForum" ) it does the following:
It gets to: if Request.Form("Method_Type") = "Forum" and instead of skipping over to the next Method_Type evaluation (if Request.Form("Method_Type") = "URL", it starts running:
'######## Update allowed user list##################################
set rsCount = my_Conn.execute("SELECT MAX(FORUM_ID) AS maxForumID FROM " & strTablePrefix & "FORUM ")
newForumMembers rsCount("maxForumId")
'##################################################################
(This is within the if Request.Form("Method_Type") = "Forum" section!)
I'm currently checking to see if there are some "end if" problems that is preventing the procedure from exiting that section of code...
Edited by - Rob Poretti on 01 April 2001 10:51:07 |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 01 April 2001 : 10:29:07
|
I received it OK
I have replied with the changes for you
|
|
|
|
Rob Poretti
Junior Member
Canada
435 Posts |
Posted - 01 April 2001 : 10:53:05
|
Ok... Sorry,...must have been writing my other comments while your were working on it... I'm checking it now...
Rob Poretti
Sascom Marketing Group ~ Toronto
vox.905.825.5373 fax.905.825.5960 |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 01 April 2001 : 10:59:20
|
you should not have any code dealing with the update userlist, this is sr4 code for the memberlist
|
|
|
|
Rob Poretti
Junior Member
Canada
435 Posts |
Posted - 01 April 2001 : 11:19:51
|
Right! (I wondered about that...and was going to ask you about it.)
It is now writing the correct information in the table... (checked in Enterprise Manager.)
I will keep testing for other possible issues but it looks like you nailed it...
I thank-you very much. It is really appreciated. This mod is really important to me and very grateful for your personal help...
Cheers!
Rob Poretti
Sascom Marketing Group ~ Toronto
vox.905.825.5373 fax.905.825.5960
Edited by - Rob Poretti on 01 April 2001 12:31:37 |
|
|
|
Topic |
|
Topic Locked
