Signature missing from all imported UBB.Threads Posts

[sblair]

vb 3.5.4
Impex 1.30

Have imported and merged two UBB.Threads systems into vB and have done most all the configuration now, but I notice that the signature is missing from all the posts.

When I look at a users profile, the sig is in their profile...but it isn't displaying it for imported posts only new ones.

Any nice easy PHP script or setting I can run to fix that?

I can't afford the downtime of another merge cycle as there is massive amounts of configuration and merging of dupe users each time.

Hoping there is an easy fix.

Thanks.
Scott

[Jerry]

Try this SQL :


UPDATE post SET showsignature = 1;


That will turn it on for all of them.

[sblair]

I'm using the Admin account that vB was installed with so I have full permissions to everything, but every time I go into Execute SQL Command I get the following:

"You are not authorized to execute SQL queries"

Any ideas?

Thanks.
Scott

[Colin F]

To run queries you first need to give yourself permission to run queries in the Admin CP. To do this, edit this section of config.php:

// ****** USERS WITH QUERY RUNNING PERMISSIONS ******
// The users specified here will be allowed to run queries from the control panel.
// See the above entries for more information on the format.
// Please note that the ability to run queries is quite powerful. You may wish
// to remove all user IDs from this list for security reasons.
$canrunqueries = 'x';

...with x being your userid number (not username).