Page 2 of 2

Re: TPFC migrated to HTTPS

Posted: Fri Nov 04, 2016 5:18 pm
by webfork
I don't know but I suspect based on what I'm seeing in this article that google is classing sites with HTTPS with higher ratings:

http://venturebeat.com/2016/11/04/googl ... picks=true

Maybe that will benefit us.

Re: TPFC migrated to HTTPS - No posts

Posted: Thu Nov 10, 2016 7:28 pm
by smaragdus
Anyway, looks like problem fixed.
It seems that the problem persists:
Portable Freeware Update - 2016-11-11 - 002.png
Portable Freeware Update - 2016-11-11 - 002.png (2.08 KiB) Viewed 30607 times
It shows "No posts" again. As far as I can remember I have never seen this before the migration to HTTPS.

Re: TPFC migrated to HTTPS

Posted: Fri Nov 11, 2016 1:41 am
by Andrew Lee
I will look into this as soon as I can.

[EDIT]
Very strange. I tried all the various stats/forum resync functions in the admin control panel, nothing works to getting the last post stats updated.

So I posted a test reply to one of the threads, last post stats was updated correctly. Deleted my test reply, last post stats was updated correctly as well.

I also tried posting a new test topic. Same thing. Deleted test topic. Last post stats was updated correctly.

The database fields are very simple. Each forum has fields for last topic id, subject, date/time, poster id. The only code that touches these fields are in the posting module, which also takes care of post deletion.

So in summary, something is setting these fields to null, and I don't think it's due to the migration to https. Because if it is due to https, all the forums will be affected and not limited to one particular forum. Perhaps database corruption and/or some phpBB bug make a certain sequence of actions cause this result. We need to be find out how to reproduce this issue reliably before this problem can be resolved.

The workaround currently is for a test post to be posted, then deleted, which will reset those fields.

Re: TPFC migrated to HTTPS

Posted: Wed Dec 07, 2016 7:48 pm
by webfork
Hopefully things on this have cleared up over the last month. Thank you again for going this route, despite the trouble. I suspect it will prevent issues before they happen.

Re: TPFC migrated to HTTPS

Posted: Thu Dec 08, 2016 8:46 pm
by Andrew Lee
Thanks! Looks like the wrinkles have been ironed out.

Re: TPFC migrated to HTTPS

Posted: Thu Aug 17, 2017 3:21 pm
by webfork
For anyone else that might be thinking getting SSL/TLS for their site is a waste of time, an entertaining breakdown by someone arguing with non-experts:

https://www.troyhunt.com/dont-take-secu ... eil-patel/