The forum is here for legacy reasons. No new posts will be created. User registration is disabled! If you have any questions, please email us or check https://www.adultscriptpro.com for more details!
You are not logged in.
Pages: 1
Hi,
This bug is related to the forum page. Latest post might not be fetched correctly from mysql (if deleted or not updated) and also the URL is not correct.
To fix edit modules/forum/components/forum.php and replace:
$sql = "SELECT c.cat_id, c.name, c.description AS cdescription, c.slug AS cslug, c.access AS caccess,
f.forum_id, f.slug, f.title, f.description, f.total_topics, f.total_posts, f.access, f.last_post_id,
p.post_id, p.last_post_date, p.title AS subject, u.username
FROM #__forum_categories AS c
INNER JOIN #__forum AS f ON (c.cat_id = f.cat_id AND f.status = '1')
LEFT JOIN #__forum_posts AS p ON (f.last_post_id = p.post_id AND p.status = '1')
LEFT JOIN #__user AS u ON (p.user_id = u.user_id)
WHERE c.status = '1'
ORDER BY c.pos, c.cat_id, f.pos";with:
$sql = "SELECT c.cat_id, c.name, c.description AS cdescription, c.slug AS cslug, c.access AS caccess,
f.forum_id, f.slug, f.title, f.description, f.total_topics, f.total_posts, f.access, f.last_post_id,
p.post_id, p.add_date AS last_post_date, p.title AS subject, u.username
FROM #__forum_categories AS c
INNER JOIN #__forum AS f ON (c.cat_id = f.cat_id AND f.status = '1')
LEFT JOIN #__forum_posts AS p ON (
p.post_id =
(SELECT post_id
FROM #__forum_posts
WHERE forum_id = f.forum_id
AND status = '1'
ORDER BY post_id DESC
LIMIT 1)
AND p.status = '1'
)
LEFT JOIN #__user AS u ON (p.user_id = u.user_id)
WHERE c.status = '1'
ORDER BY c.pos, c.cat_id, f.pos";Also edit templates/your-template/
TO BE CONTINUED :-) (discovered another forum related bug)
Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds
Offline
Pages: 1