Correct syntax for sql query?

[guvner]

Hi everyone,

I just ported a SMF board acrosss to VB and seem to have lost a lot of pre-existing signatures. I've also had a few members ask why, when they activate a sig, it doesn't flow through all their previous posts like it does with other forums, even if they didn't have a sig before.

Since I have a fast growing forum, it's an important issue for many of them because they're looking for link backs to improve their page rank.

I've discovered that with VB, because the sig was "turned off" in the postbit in earlier posts, it can't update historically. Fair enough, so I went looking for a hack that would help me add them to previous posts and all I could find was an old reference here from May 2003 which requires this sql query to be run.

UPDATE post SET post.showsignature = 1 WHERE user.signature != "" AND post.userid = user.userid;

Well, I'm a long way from being even slightly competent with mySQL and no matter what I try (and I've tried so many variations), I can't run the query (on my test board)

The last failure was using:

UPDATE post SET vb3_post.showsignature = 1 WHERE vb3_user.signature != "" AND vb3_post.userid = vb3_user.userid

The error I get every time is "MySQL said: #1146 - Table 'xxxxxxx_testvbulletin.post' doesn't exist

Assume my DB is called xxxxxxx_testvbulletin and my table prefix is vb3_ could someone who "gets it" please help me with the correct syntax?

Thanks in advance.

Mike

[Zachery]

Why not just use clear.php ?

[tehste]

I'm assuming vb3_ is the table prefix.
try:

UPDATE vb3_post SET showsignature = 1 WHERE showsignature = 0

in php my admin or the query runner from the vbulletin admin cp.
(This will make signature appear on all posts.

[guvner]

Zachery - sorry but I don't know what clear.php is.

No matter - zsdave, thank you so much - it worked really well! :laugh: