Farofylakas wrote: ↑
Sat Feb 09, 2019 8:50 pm
When I edit the post and try to change the http to https I get a
"It was not possible to determine the dimensions of the image. Please verify that the URL you entered is correct."
WWW is considered subdomain and you need a SSL certificate that will support each subdomain if you are using any. Yours does not support WWW.
You are redirecting http://www.yourdomain.com to https://www.yourdomain.com and you can't do that without a valid certificate for WWW. That is why the images do not appear to begin with and the error from phpBB. Also note a redirection from https://www.yourdomain.com to https://yourdomain.com will also fail so you will proabaly want to get support for the WWW because anyone typing WWW manually will get certificate error page. As it is now you can only redirect http://www.yourdomain.com and http://yourdomain.com to https://yourdomain.com.
Of course removing the WWW in the post will also fix it because there is no redirection occurring
Or else, should I run an SQL query and replace all http://mydomain with https://mydomain ?
Backup first. If you open phpmyadmin from your hosting control panel open the table phpbb_posts. Once the table is open on the top click the search tab, on that tab find the button search and replace below the tabs. Type in http://www.yourdomain.com in the find text box and then type in https://yourdomain.com in the replace text box. In the drop down box select the column "post_text". Click the go button and it should give you preview of the changes. Click go again and the operation will be carried out.
Be aware there may be unforeseen issues with this but they should me minor if any. For example a post like this one becomes nonsensical.