Sigs not working :(

[ErnieTheMilk]

I seem to be having lots of problems with sigs not working, they are showing up in peoples User CP's but not on the site...

Permissions to show them are on, but still no good.

Can anyone tell me what I'm doing wrong!

Thanks

[Nick]

If a user originally didn't have a signature, and then they add one, the signature is not appended to previous posts that didn't already have a signature -- only posts from that point forward.

If you want the signature to appear on the old posts, they have to be edited and the "Show Signature" box must be checked.

[ErnieTheMilk]

Thanks Nick

Everything related as I can see is switched on to show the sigs including the show sig.

They just physically don't show up!

[Steve Machol]

They will not show up in previous posts.

[Nick]

Are you implying that you have made a post since you added your signature and it's still not appearing?

To make sure you actually have checked the show signature box, run this query:


UPDATE post
SET showsignature = 1

If you have a table prefix, append that to the beginning of "post". I.e. prefix_post

To run SQL Queries:
AdminCP -> Maintenance -> Execute SQL Query

Ensure you have permissions to execute/run SQL Queries by editing the */includes/config.php file and change X to your user ID.

// ****** 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';

[ErnieTheMilk]

Thanks, I'll give it a go and report back.

This installation is my second and is a nightmare!

Nothing (ie mods and add ons), seem to work like the first installation and its the same platform, same hosting platform etc...

Very, very frustrating...

Thanks, off to try now :)

[ErnieTheMilk]

Ensure you have permissions to execute/run SQL Queries by editing the */includes/config.php file and change X to your user ID.

OK, I did all that as superbly suggested and guess what.....


You are not authorized to execute SQL queries


Aaarrrrrgggggghhhhhh!

[Steve Machol]

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:

$config['SpecialUsers']['canrunqueries'] = 'x';

...with x being your userid number.

[Nick]

OK, I did all that as superbly suggested and guess what.....


You are not authorized to execute SQL queries


Aaarrrrrgggggghhhhhh!
Read my entire post ( #5).

[ErnieTheMilk]

Sorry, my sig does explain my understandthis somewhat :o

OK, I've run the SQL and got a message which says

Affected Rows: 215 (0.0044s)

what happens now :confused:

Thanks for your help!

[Zachery]

you're done/

[ErnieTheMilk]

you're done/

Oh sorry!

Thanks for the help Guys :D