How to put sigs in previous posts of a user

[MJM]

Some members have recently started using a signature, but their previous posts don't show the signature.

Is there any way to get their signature into all their previous posts?

Thanks,
Mark

[Jake Bunce]

The Show your signature checkbox is not enabled for the old posts. They would need to edit their old posts and enable that checkbox.

You can update old posts with this query:

UPDATE post
SET showsignature = 1

Or for a specific user:

UPDATE post
SET showsignature = 1
WHERE userid = X

Where X is the userid of the user.

[mindbuster]

Or maybe the old posts not showing the signature is cached posts ?

[MJM]

Thanks a bunch Jake!
This will be a big time saver.
Mark

[MJM]

Okay I finally got around to trying this out on my old posts without sigs
copied and pasted per user instruction, with my user ID #
into > On - Display signature > clicked continue
said xxx rows changed ... but nothing happened
..cleared cache/cookies, restarted my computer
..still not showing in posts

Any suggestion where to go from here?

Mark

[Jake Bunce]

I would need to take a look for myself. I can do this if you send me a PM with a URL and admin login to your forum, as well as links to some of the posts that are having the problem. I might also need permission to run queries.

[MJM]

Thanks! PM sent.
Mark

[MJM]

Thanks Jake! That magic wand of yours did the trick!
Much appreciated
Mark

[Jake Bunce]

Is it working now? It doesn't look like it's working to me.

[MJM]

Yep! all my past posts now have a sig.
Ah the mysteries of life in the electron age!

The only mod I have is...
Advanced Editing Options For Mods & Admins

http://www.vbulletin.org/forum/showthread.php?t=61412

and I've never had any problems with it affecting anything.

Many thanks!
Mark

[Faast]

Or maybe the old posts not showing the signature is cached posts ?

How do you disable caching?

[hescominsoon]

Ok hwere is what happens when i try that query:
UPDATE post
SET showsignature = 1
WHERE userid = 1331
vBulletin Message An error occurred while attempting to execute your query. The following information was returned.
error number: 1146
error desc: Table 'cgavb3.post' doesn't exist

[Jake Bunce]

You need to change "post" in the query to include your table prefix. The table prefix is set in the includes/config.php file.