Moved topics

[Migrated From Jforum.net]

When i move the topic then in forum stay the "shadow" of moved topic. What i need to do for delete this "shadow"?
[originally posted on jforum.net by Rotoz]

[Migrated From Jforum.net]

The easier way is to change the sql query. Open the file WEB-INF/config/database/generic/generic_queries.sql (if you're using MySQL), search for "TopicModel.selectAllByForumByLimit" and change it to

SELECT t.*, p.user_id AS last_user_id, p.post_time, p.attach AS attach, ? as x_ \
	FROM jforum_topics t, jforum_posts p \
	WHERE t.forum_id = ? \
	AND p.post_id = t.topic_last_post_id \
	AND p.need_moderate = 0 \
	ORDER BY t.topic_type DESC, t.topic_last_post_id DESC \
	LIMIT ?, ?

Please note that the "\" is not optional, and there should be no blank space after it.

Rafael

[originally posted on jforum.net by Rafael Steil]

[Migrated From Jforum.net]

I'm not sure to understand, what does your modification?

I don't really get the logic behind the move topic hint: The seem to be there forever? they apparently can't be deleted (checkbox is disabled). If the topic itself is deleted the link stay anyway.


[originally posted on jforum.net by pala]

[Migrated From Jforum.net]

Apparently, links are being deleted when the topic is deleted, it is just a cache bug.
[originally posted on jforum.net by pala]

[Migrated From Jforum.net]

Yes, the hint is there "forever". I'll make this optional in JForum3. What the modified query does is to not bring moved topics as well.

Rafael
[originally posted on jforum.net by Rafael Steil]