signature problem in phpbb forum

At my forum signature is only viewed in post made after i change it. in older ones there is nothing.
What should i do?
i run phpBB 2.0.21 , no mods.
Thanks

 

Yes, all the other post will not have the sig because you did not enable sig in post as you do not have any sig available.

There is a SQL query to run to enable sig throughout your post but I need to find out first as I am outside now

 

please do when you can!
thanks

 

Hi,

You need to execute SQL query to enable your sig in the post

You need to run this to find out your userid because you need this ID for your next query.

SELECT `user_id` FROM `phpbb_users` WHERE `username` = "[COLOR="Red"]tanfwc[/COLOR]";

Code (markup):

You need to execute this query as it will update your posts that does not have sig enabled. You need to replace the poster id which you have retrieve on your first query. If you have a large forums, this SQL query will only select those post that does not have sig enabled therefore saving memory

UPDATE `phpbb_posts` SET `enable_sig` = '1' WHERE `enable_sig` = 0 AND `poster_id` = [COLOR="Red"]2[/COLOR];

Code (markup):

Reps appreciated