Signatures Not Showing Up

[glassjeg]

All of my registered members have signatures and none are showing up when you look at their post.Can someone tell me what to check? Thanks

[Jake Bunce]

The person viewing the post needs to check this:

User CP -> Edit Options -> Show Signatures

Also, when you make a post you will see there is a Show your signature checkbox. This box is automatically checked if you have a signature defined in your User CP. For old posts that were made before you had a signature, this box is probably not checked, so the signature will not show for old posts until you edit the post and check that box.

You can run this query to check that box for all old posts:

UPDATE post
SET showsignature = 1

You can run queries in your:

Admin CP -> Maintenance -> Execute SQL Query

You must have permission to execute queries in your includes/config.php file:

	//	****** 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.
$config['SpecialUsers']['canrunqueries'] = '';

[rrmccabe]

I am having the same issue and when I run it I get the error.

Table 'tbssown_forum.post' doesn't exist

[rrmccabe]

I am having the same issue and when I run it I get the error.

Table 'tbssown_forum.post' doesn't exist

Rich

[Jake Bunce]

If you use a table prefix then you need to add that to the query. For example, if your prefix is "vb3_" then the query would be:

UPDATE vb3_post
SET showsignature = 1

[rrmccabe]

Awesome !

Worked great. Had a vb_ prefix on my tables.

[RedHotChili]

Rats! I've got the same problem.

No vb prefix nor any prefix on my tables that would cause the aforementioned problem.

It's a new board and all permissions are set for all usergroups to allow sigs, but none get displayed yet. I'm sure I'm overlooking something simple.

Have looked into these threads, but nothing seems to jump out at me yet. Am wondering if I need to work the code as Lats has suggested in the thread below:

http://www.vbulletin.com/forum/showthread.php?t=298891

http://www.vbulletin.com/forum/showt...ght=signatures

http://www.vbulletin.com/forum/showthread.php?t=298891

http://www.vbulletin.com/forum/showthread.php?t=104312