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 (Closed)
 (v3.4) BUG+FIX: subscriptions_list.asp
 Forum Locked  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 18 August 2002 :  19:25:46  Show Profile  Send ruirib a Yahoo! Message
In subscriptions_lisp.asp, line 102, there is:


"FROM (((FORUM_SUBSCRIPTIONS S INNER JOIN FORUM_MEMBERS M ON S.MEMBER_ID = M.MEMBER_ID) " & _
"LEFT JOIN FORUM_TOPICS T ON S.TOPIC_ID = T.TOPIC_ID) " & _
"LEFT JOIN FORUM_FORUM F ON S.FORUM_ID = F.FORUM_ID) " & _
"LEFT JOIN FORUM_CATEGORY C ON S.CAT_ID = C.CAT_ID "



Replace it by:


"FROM (((" & strTablePrefix & "SUBSCRIPTIONS S INNER JOIN " & strMemberTablePrefix & "MEMBERS M ON S.MEMBER_ID = M.MEMBER_ID) " & _
"LEFT JOIN " & strTablePrefix & "TOPICS T ON S.TOPIC_ID = T.TOPIC_ID) " & _
"LEFT JOIN " & strTablePrefix & "FORUM F ON S.FORUM_ID = F.FORUM_ID) " & _
"LEFT JOIN " & strTablePrefix & "CATEGORY C ON S.CAT_ID = C.CAT_ID "


Snitz 3.4 Readme | Like the support? Support Snitz too

Edited by - ruirib on 19 August 2002 08:35:44

Aaron S.
Average Member

USA
985 Posts

Posted - 18 August 2002 :  19:54:33  Show Profile  Visit Aaron S.'s Homepage
Should the "FORUM_MEMBERS" part be changed also?

--Aaron

DOWNLOAD GREAT NEW MODS HERE
Go to Top of Page

RichardKinser
Snitz Forums Admin

USA
16655 Posts

Posted - 18 August 2002 :  19:56:16  Show Profile
yes, fixed above
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 18 August 2002 :  19:58:40  Show Profile  Send ruirib a Yahoo! Message
Sorry, I missed it.


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

masterao
Senior Member

Sweden
1678 Posts

Posted - 18 August 2002 :  20:44:42  Show Profile  Visit masterao's Homepage
Shouldn't the three lines after line 102 also be changed to " & strTablePrefix & "?

They are now (lines 103-105):


"LEFT JOIN FORUM_TOPICS T ON S.TOPIC_ID = T.TOPIC_ID) " & _
"LEFT JOIN FORUM_FORUM F ON S.FORUM_ID = F.FORUM_ID) " & _
"LEFT JOIN FORUM_CATEGORY C ON S.CAT_ID = C.CAT_ID "



Jan
===========
FR Portal Forums | Active Users 4.0.20 Mod
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 18 August 2002 :  22:21:48  Show Profile  Send ruirib a Yahoo! Message
Changed.


Snitz 3.4 Readme | Like the support? Support Snitz too

Edited by - ruirib on 19 August 2002 08:30:51
Go to Top of Page

RichardKinser
Snitz Forums Admin

USA
16655 Posts

Posted - 21 August 2002 :  01:08:10  Show Profile
fixed in v3.4.01
Go to Top of Page
  Previous Topic Topic Next Topic  
 Forum Locked  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.16 seconds. Powered By: Snitz Forums 2000 Version 3.4.07