| Author |
 Topic  |
|
Da_Stimulator
DEV Team Forum Moderator
USA
3373 Posts |
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
 Posted - 19 November 2001 : 15:01:04
|
I'm stumped, can't find anything wrong, and it worked great on the site I just tested.
|
 |
|
|
Da_Stimulator
DEV Team Forum Moderator
USA
3373 Posts |
Posted - 19 November 2001 : 15:04:52
|
ut oh - ya know its a bad sign when Huw is stumped 
When I wake up a bit more I'll dive into it... although if you couldnt find anything wrong I doubt I will be able to.
----
-Eric | Mod Resource | Test Area
"A program is a device used to convert data into error messages."
http://phpscriptcenter.com -Quality PHP Scripts |
|
|
|
retro
Junior Member
123 Posts |
Posted - 22 November 2001 : 15:18:01
|
Just wanted to let you know that I tried this mod as well and got the same error.
I'm looking forward to the mod! Users have been requesting it for a while andd I just haven't gotten around to looking at how to do it.
Happy holidays!
Sean
|
|
|
|
Anks
Starting Member
2 Posts |
Posted - 05 December 2001 : 07:29:47
|
I can't find any more posts about the progress of this Mod, It is working fine for me. The only issue I had really was when I created a new topic, the SQL code needed to be moved around a little.
Edited by - anks on 05 December 2001 07:30:56 |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 05 December 2001 : 08:11:04
|
Well, not on the error, I am unable to duplicate it, and can not see any reason why it should throw the error.
Anks, what SQL code did you move around ? the mod should not affect this apart from a minor addition to a SELECT statement, it certainly shouldn't affect any inserts
|
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 05 December 2001 : 08:11:15
|
Well, not on the error, I am unable to duplicate it, and can not see any reason why it should throw the error.
Anks, what SQL code did you move around ? the mod should not affect this apart from a minor addition to a SELECT statement, it certainly shouldn't affect any inserts
|
|
|
|
Anks
Starting Member
2 Posts |
Posted - 05 December 2001 : 10:42:47
|
Huw,
My code is modified so it might not be the same for your code/generic code but if for instance if you go to create a new topic I received select statement error as there is no topic id? Make sense?
Code in Inc_Subscription.asp is
strSql = "Select Count(*) as MemberCheck " &_
" FROM " & strTablePrefix & "SUBSCRIPTIONS S" &_
" WHERE S.MEMBER_ID = " & MemberID &_
" AND S.TOPIC_ID = "
if SubType = "TOPIC" then
strSql = strSql & TopicID
However, I have just checked your forum code and it reads
if SubType = "TOPIC" and TopicID <> "" then
I must of missed the post which details this problem. Sorry.
|
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 05 December 2001 : 11:37:55
|
No problem, just making sure I hadn't missed something
|
|
|
|
Webbo
Average Member
United Kingdom
982 Posts |
Posted - 09 January 2002 : 06:38:42
|
Hi,
Are the files modified to include the above and is the 'mod' working now?
Dave
|
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 09 January 2002 : 06:47:16
|
quote:
Hi,
Are the files modified to include the above and is the 'mod' working now?
Dave
No, they did not require changing, they work perfectly ok.
|
|
|
|
Webbo
Average Member
United Kingdom
982 Posts |
Posted - 09 January 2002 : 07:44:25
|
Thanks HuwR,
Something else to play with now 
Regards, Dave
|
|
|
|
Webbo
Average Member
United Kingdom
982 Posts |
Posted - 09 January 2002 : 08:08:27
|
Sorry to bother you HuwR,
I now get the following error:
Microsoft VBScript compilation error '800a03ea'
Syntax error
/forum/post.asp, line 105
'-- Subscribe checkbox end -
^
I'm running version 3.3.03 on a MySql server.
Dave
|
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 09 January 2002 : 08:13:39
|
????No idea, what ASP are you using, that line is a comment.
|
|
|
|
Webbo
Average Member
United Kingdom
982 Posts |
Posted - 09 January 2002 : 08:21:46
|
HuwR
Sorry I don't know the version off hand.
Dave
|
|
|
|
Topic |
|
Topic Locked
