Skip to:
Content
Pages
Categories
Search
Top
Bottom

Re: Topic paging issue

@_ck_

Participant

Okay we need to see if the query is failing somehow.

try this (assuming the table is bb_posts)

SELECT topic_id, COUNT(post_status) as topic_posts FROM bb_posts WHERE post_status=0 AND topic_id=12

See if that gives 80 or 81

Then try this if that gives 81

SELECT topic_id, COUNT(*) as topic_posts FROM bb_posts WHERE post_status=0 AND topic_id=12

(sorry I forgot to add AND topic_id=12)

Skip to toolbar