posted 19 years ago
I'd like to see replies in rss feed. Is it difficult to implement? Tried this (sqlserver):
===========
TopicModel.selectAllByForumByLimit1 = t.*, p.attach, u.username AS posted_by_username, u.user_id AS posted_by_id, u2.username AS last_post_by_username, u2.user_id AS last_post_by_id, p2.post_time \
FROM jforum_topics t, jforum_users u, jforum_posts p, jforum_posts p2, jforum_users u2 \
WHERE t.forum_id = ? \
AND t.user_id = u.user_id \
AND p.post_id = t.topic_first_post_id \
AND p2.post_id = t.topic_last_post_id \
AND u2.user_id = p2.user_id \
AND t.topic_id not in (
CHANGED TO:
TopicModel.selectAllByForumByLimit1 = t.*, p.attach, u.username AS posted_by_username, u.user_id AS posted_by_id, u2.username AS last_post_by_username, u2.user_id AS last_post_by_id, p2.post_time \
FROM jforum_topics t, jforum_users u, jforum_posts p, jforum_posts p2, jforum_users u2 \
WHERE t.forum_id = ? \
AND t.user_id = u.user_id \
AND p.post_id = t.topic_last_post_id \ <<<<<<<<<<<<<<<<<
AND p2.post_id = t.topic_last_post_id \
AND u2.user_id = p2.user_id \
AND t.topic_id not in (
===========
and got this:
===========
freemarker.core.InvalidReferenceException: Expression topic.postedBy is undefined on line 55, column 120 in default/recent_thread.htm.
at freemarker.core.TemplateObject.assertNonNull(TemplateObject.java:124)
at freemarker.core.TemplateObject.invalidTypeException(TemplateObject.java:134)
at freemarker.core.Dot._getAsTemplateModel(Dot.java:78)
at freemarker.core.Expression.getAsTemplateModel(Expression.java:89)
at freemarker.core.Expression.getStringValue(Expression.java:93)
at freemarker.core.DollarVariable.accept(DollarVariable.java:76)
at freemarker.core.Environment.visit(Environment.java:171)
at freemarker.core.MixedContent.accept(MixedContent.java:92)
at freemarker.core.Environment.visit(Environment.java:171)
at freemarker.core.Environment.renderElementToString(Environment.java:1342)
at freemarker.core.StringLiteral.getStringValue(StringLiteral.java:93)
at freemarker.core.StringLiteral._getAsTemplateModel(StringLiteral.java:80)
at freemarker.core.Expression.getAsTemplateModel(Expression.java:89)
...
[originally posted on jforum.net by Anonymous]