TPFC migrated to HTTPS

Changes, updates etc. related to this website will be posted here.
Message
Author
User avatar
webfork
Posts: 10836
Joined: Wed Apr 11, 2007 8:06 pm
Location: US, Texas
Contact:

Re: TPFC migrated to HTTPS

#16 Post 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.

User avatar
smaragdus
Posts: 2120
Joined: Sat Jun 22, 2013 3:24 am
Location: Aeaea

Re: TPFC migrated to HTTPS - No posts

#17 Post 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 36896 times
It shows "No posts" again. As far as I can remember I have never seen this before the migration to HTTPS.

User avatar
Andrew Lee
Posts: 3116
Joined: Sat Feb 04, 2006 9:19 am
Contact:

Re: TPFC migrated to HTTPS

#18 Post 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.

User avatar
webfork
Posts: 10836
Joined: Wed Apr 11, 2007 8:06 pm
Location: US, Texas
Contact:

Re: TPFC migrated to HTTPS

#19 Post 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.

User avatar
Andrew Lee
Posts: 3116
Joined: Sat Feb 04, 2006 9:19 am
Contact:

Re: TPFC migrated to HTTPS

#20 Post by Andrew Lee »

Thanks! Looks like the wrinkles have been ironed out.

User avatar
webfork
Posts: 10836
Joined: Wed Apr 11, 2007 8:06 pm
Location: US, Texas
Contact:

Re: TPFC migrated to HTTPS

#21 Post 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/

Post Reply