How do i add signature to old posts?

[borbole]

Originally Posted by aaronrand

Is there a way in 4.1 to add signatures to old posts made before a signature was added?
I found a 3.8 mod but nothing for 4.x yet.
I tried editing the old posts but that did not add a signature

There is no need for a mod. It can be simply done with a query in the phpmyadmin.

PHP Code:

UPDATE post SET showsignature = 1; 


If your tables have a prefix, don''t forget to include it in the query. I just tested it at my test site and it worked like a charm. Hope it helps. Let me know how it will go.