Page 1 of 1

Signature appearance after permission changed

Posted: Mon Apr 03, 2017 11:42 am
by pikachuturkey
sorry for my bad English :D
i am using 3.2.0 and fresh install (www.saglikforum.org/forum). i posted a few topic (i have signature and signature iz allowed site wide), than because of spams, i closed signature usage by ACP site wide.
i posted more new topics.
than i changed the settings again and i allowed signatures again by ACP.
Now there my is signature under my topics, when i posted topics and settings is allowed to signature but there isn't my signature under my topics when i posted topics and setting is not allowed to signature.
Signature seems to be on some posts, even though site-wide signature permissions are turned on, but signature doesn't seem under some posts.
Signature seems: http://www.saglikforum.org/forum/viewtopic.php?f=49&t=5
Signature doesn't seem: http://www.saglikforum.org/forum/viewto ... ?f=49&t=50
is this normal?
and how can i show signatures under all my posts :)
---
i looked at "edit post" section and there is no click on "add my signature" area. when i click this signature appears. but do i change all my posts for showing signature?

Re: Signature appearance after permission changed

Posted: Mon Apr 03, 2017 1:08 pm
by stevemaury
I believe that is normal. If you post when signatures are not allowed, then that post will not have a signature.

Re: Signature appearance after permission changed

Posted: Mon Apr 03, 2017 1:57 pm
by Brf
Yes. There is an "Attach signature" flag on each post. If you edit a post that has no signature you can checkmark to attach the signature.

Re: Signature appearance after permission changed

Posted: Mon Apr 03, 2017 2:09 pm
by pikachuturkey
Brf wrote:
Mon Apr 03, 2017 1:57 pm
Yes. There is an "Attach signature" flag on each post. If you edit a post that has no signature you can checkmark to attach the signature.
Thank you Brf and stevemaury. :) Is there an easy way for adding all my posts. I have more than 200 posts without signature. From cpanel, phpmyadmin, sql code etc? :mrgreen:

Re: Signature appearance after permission changed

Posted: Mon Apr 03, 2017 2:28 pm
by RMcGirr83

Code: Select all

UPDATE phpbb_posts SET enable_sig = 1 WHERE poster_id = your_poster_id
You need to change phpbb if that is not your table extension name and your_poster_id to whatever your user id is.

You should also, disable the forum and backup the posts table prior to doing that query. Then test to see if it worked and re-enable the forum. If it didn't work just restore the backup.

Re: Signature appearance after permission changed

Posted: Mon Apr 03, 2017 5:42 pm
by pikachuturkey
RMcGirr83 wrote:
Mon Apr 03, 2017 2:28 pm

Code: Select all

UPDATE phpbb_posts SET enable_sig = 1 WHERE poster_id = your_poster_id
You need to change phpbb if that is not your table extension name and your_poster_id to whatever your user id is.

You should also, disable the forum and backup the posts table prior to doing that query. Then test to see if it worked and re-enable the forum. If it didn't work just restore the backup.
Thanks. it works :D