Signatures in Old Posts didn't "fill in"

[SemperFideles]

Well before I had a chance to check it, I put the migrated forum live at http://www.puritanboard.com/

All new posts are showing the signature of the posters. Old posts are not displaying the signature.

Is there a way to fix this?

[Steve Machol]

Any post that was made prior to the member having a signature will not show a signature. This is normal.

To turn on all signatures in all posts, you can run this query:

UPDATE user SET options=options + 1 WHERE NOT(options & 1)

[SemperFideles]

Any post that was made prior to the member having a signature will not show a signature. This is normal.

To turn on all signatures in all posts, you can run this query:

UPDATE user SET options=options + 1 WHERE NOT(options & 1)

You are misunderstanding the problem:

1. 200,000 posts were imported this AM from XMB.
2. All 200,000 posts had signatures in them.
3. All user profiles had the signature field properly imported by the import.
4. When the posts where imported, the signatures for each post didn't show up in the threads.

Now:
Is there a way to "tack" the missing signatures back into the posts based on existing signature information?

[Lats]

Try this...

UPDATE
    post
SET
    showsignature = 1
WHERE
    showsignature = 0

[SemperFideles]

It didn't work. It said it updated 15,000 rows but I still don't see sigs for old posts.

[SemperFideles]

I take it back. It DID work.

Thanks!