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 "