Reply to thread

Message

So, here's how you can detect this issue (posts with attachments but with an attach_count of 0):
[CODE]
SELECT DISTINCT xf_post.post_id FROM xf_post
INNER JOIN xf_attachment
ON xf_post.post_id = xf_attachment.content_id
WHERE xf_post.attach_count = 0 AND xf_post.message LIKE '%[ATTACH=FULL]%' AND xf_attachment.content_type = 'post'[/CODE]

Can you run this on the Xenforo Community database just to make sure you aren't seeing the same issue occasionally?

[QUOTE="rfc0001, post: 1208631, member: 162096"] So, here's how you can detect this issue (posts with attachments but with an attach_count of 0): [CODE] SELECT DISTINCT xf_post.post_id FROM xf_post INNER JOIN xf_attachment ON xf_post.post_id = xf_attachment.content_id WHERE xf_post.attach_count = 0 AND xf_post.message LIKE '%[ATTACH=FULL]%' AND xf_attachment.content_type = 'post'[/CODE] Can you run this on the Xenforo Community database just to make sure you aren't seeing the same issue occasionally? [/QUOTE]

Verification

Reply to thread

We value your privacy