Fixing Mixed content automatically for many posts
By Laybet Colmenares Zamora on Saturday, 05 May 2018
Posted in General Issues
Replies 6
Likes 0
Views 433
Votes 0
Hi,
Recently I installed a SSL certificate in my web, I've already have forced HTTPS in all web in Joomla but I get mixed content in my blog section in which I use easyBlog. The problem is that I already have a lot of posts that have references in http. Is it possible to substitute all "http" text to "https" automatically with an script or something like that? I could do it manually but they are too many posts.
Hi,

Yes, It is because of the post content. There are some images that are being load from external domains.

This Joomla web page was not built by me, I am maintaining it and I have little experience with Joomla so my apologies if I'm being difficult.

There are more than 100 posts already published, basically all content before I installed the SSL certificate has some http reference.

I tried to look for /components/com_easyblog/blogs/entry/default.posts.php.Unfortunately, It seems my file structure is different. Maybe is it because this blog was created with a previous version of easy blog?
I have attached a screenshot of the file struccture in my Joomla installation.

On my own, I have found a MySQL table called easyblog_post which has a column called media and another one called intro. Here, I found http references.

Following the guidelines of this page, I did it with a query.



UPDATE easyblog_post SET media = REPLACE( media, "http:\\/\\/", "https:\\/\\/" );

UPDATE easyblog_post SET intro = REPLACE( intro, "http://", "https://" );


As backslash '\' is used to escape characters, I had to write one aditional backslash.
Laybet Colmenares Zamora
·
Tuesday, 08 May 2018 01:28
·
0 Likes
·
0 Votes
·
0 Comments
·
Hey there,

I am really sorry for the delay of this reply as it is a weekend for us here.

Unfortunately that was not easier way to convert your existing blog content for those http link to https link, unless run a PHP script to replace it all the existing blog post.

If i am not wrong, Admin tool extension did have this feature convert all the http link to https, perhaps you can consult with their support and see whether they got this feature or not.

https://extensions.joomla.org/extension/admin-tools/
Arlex Wong
·
Saturday, 05 May 2018 08:32
·
0 Likes
·
0 Votes
·
0 Comments
·
Thanks for your response,

Unfortunatley, I tried to replace all http references to https with different extentions... with no success. Maybe I could try with an script, backing up my database first... but I would need to know in which tables are EasyBlog posts stored.

I just need to replace some links and images. This is being more difficult than I initially thought.

Thanks in advance.
Laybet Colmenares Zamora
·
Monday, 07 May 2018 19:23
·
0 Likes
·
0 Votes
·
0 Comments
·
Hey Laybet,

Are you able to identify which posts or url having such issues? If it is due to the post content, what you could do is to edit the following files:

/components/com_easyblog/blogs/entry/default.posts.php and at line 229 replace the codes below,

[gist]
<?php echo $content; ?>
[/gist]

With,

[gist]
<?php echo JString::str_ireplace('http://', 'https://', $content); ?>
[/gist]
Mark
·
Monday, 07 May 2018 22:27
·
0 Likes
·
0 Votes
·
0 Comments
·
Thanks for getting back to us you found the solution to replace these content through SQL query way.

By the way, that file path should be located at JoomlaFolder/components/com_easyblog/themes/wireframe/blogs/entry/default.posts.php
Arlex Wong
·
Tuesday, 08 May 2018 09:19
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post