| Author |
 Topic  |
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
 Posted - 09 January 2002 : 08:33:07
|
are you using windows and IIS ? or another OS/webserver combination.
|
 |
|
|
Webbo
Average Member
United Kingdom
982 Posts |
Posted - 09 January 2002 : 08:39:05
|
Yes to the first Huw its a Windows Nt server
I've got to go to work now so can I leave it with you and I'll get back later,
Cheers, Dave
|
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 09 January 2002 : 08:55:19
|
ok, give me a shout later
|
|
|
|
retro
Junior Member
123 Posts |
Posted - 09 January 2002 : 10:02:59
|
Hey Webbo,
I had EXACTLY the same problem. Take out the comment lines that says "Subscribe checkbox begin" and "Subscribe checkbox end". It worked fine form me when I removed those lines.
If it still doesn't work, let me know and I'll post my code exactly when i get back home this evening.
Sean
Edited by - Retro on 10 May 2002 16:50:17 |
|
|
|
Webbo
Average Member
United Kingdom
982 Posts |
Posted - 09 January 2002 : 21:40:07
|
Hi Sean and HuwR,
I did that in post.asp and it now works fine for 'Reply to Topic' however in 'New Topic' I'm getting the following error within the page:
Microsoft OLE DB Provider for ODBC Drivers error '80040e09'
[TCX][MyODBC]You have an error in your SQL syntax near 'AND S.FORUM_ID = 1 AND S.CAT_ID = 1' at line 1
/clubforums/inc_subscription.asp, line 133
Line 133 reads: rsWatch.open strSql, my_Conn
if that helps.
I have left everything as is if you want to take a look www.maggotdrowning.com/clubforums
Thanks, Dave
|
|
|
|
Webbo
Average Member
United Kingdom
982 Posts |
Posted - 10 January 2002 : 04:44:02
|
Hi again,
Here's a quick update:
The error only shows when a poster is logged in. It doesn't show otherwise. This may be down to the fact that I am running 2 boards on the same db with the same members table being used for both.
Dave
-->Update2: It isn't that. I have just altered the code for the forum so that it picks up on it's own members table and the error still shows in the 'post new topic' page where the checkbox would have been.
This only happens though when you are logged in otherwise the 'post' is okay and the checkbox doesn't show which is what I would have expected. Back to the drawing board (sorry for the pun  )
Dave
Edited by - Webbo on 10 January 2002 04:58:55 |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 10 January 2002 : 05:12:54
|
can you put
response.write strSQL
on line 132, above the rsWatch.open strSql, my_Conn line.
Now when you o to post.asp, it should print out the SQL, could you copy it and post here so I can take a quick look.
|
|
|
|
Webbo
Average Member
United Kingdom
982 Posts |
Posted - 10 January 2002 : 05:27:54
|
Goodmorning? HuwR
I get the following:
Select Count(*) as MemberCheck FROM FORUM2_SUBSCRIPTIONS S WHERE S.MEMBER_ID = 3 AND S.TOPIC_ID = AND S.FORUM_ID = 1 AND S.CAT_ID = 1
Microsoft OLE DB Provider for ODBC Drivers error '80040e09'
[TCX][MyODBC]You have an error in your SQL syntax near 'AND S.FORUM_ID = 1 AND S.CAT_ID = 1' at line 1
/clubforums/inc_subscription.asp, line 134
Dave
|
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 10 January 2002 : 05:44:32
|
Ok, can you email me the file, i will fix it, it is because you are uing MySQL.
to huw@forum.snitz.com
|
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 10 January 2002 : 07:02:14
|
in inc_subscriptions, a few lines up from 134, you will find this code
if SubType = "TOPIC" then
strSql = strSql & TopicID
else
strSql = strSql & "0 "
end if
change it to
if SubType = "TOPIC" and TopicID <> "" then
strSql = strSql & TopicID
else
strSql = strSql & "0 "
end if
|
|
|
|
Webbo
Average Member
United Kingdom
982 Posts |
Posted - 10 January 2002 : 07:54:22
|
Excellent Huw,
It works a treat, thanks very much 
Dave
|
|
|
|
KerryG
Starting Member
USA
41 Posts |
Posted - 22 January 2002 : 18:42:15
|
I don't see where it includes the checkbox during the post as was originally asked and happens to be what I am looking for right now.
-Kerry
Kerry
http://www.WildHobbies.com |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 22 January 2002 : 19:12:54
|
it includes the checkbox where it used to be. make a post on my test forum http://www.magicmushroom.org.uk (make sure the forum allows subscription) :)
|
|
|
|
KerryG
Starting Member
USA
41 Posts |
Posted - 22 January 2002 : 19:34:00
|
I see it in yours perfectly. However, I have searched through the three pages included in the zip file and none of them have any code that resembles creating a text box like that. I have two checkboxes on the page, the profile signature and the lock topic after post.
Kerry
WildHobbies.com
Kerry
http://www.WildHobbies.com |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 23 January 2002 : 03:15:47
|
the code which creates the checkbox is in inc_subscription.asp
|
|
|
|
Topic |
|
Topic Locked
