close ad
Help us test the new Databridge BETA with MySQLi support
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Installed SSL - but images from DB are insecure

Thread began 6/21/2018 12:57 pm by Charles | Last modified 6/22/2018 5:34 pm by Ray Borduin | 161 views | 8 replies |

Charles

Installed SSL - but images from DB are insecure

Used Data Assist to build https://www.thestonecenter.com/
Just installed SSL - page is secure, but images called from db are not
Does anyone know what WA file controls the http/https prefix in assembling the call from the db

Sign in to reply to this post

Ray BorduinWebAssist

What code do you use to store the images in the database? Usually the image name and not the full path is stored in the database, so you just update the html to fix the issue.

I'd have to see the underlying html and php to understand what is going on and how to fix it.

Sign in to reply to this post

Charles

I'd appreciate it if you could take a look . . .

Sign in to reply to this post

Ray BorduinWebAssist

On the results page on line 377 you have:

<img class="WADAResultThumb" border="0" src="http://outofchaos.net/gsc/www/gallery/images/product-images/<?php echo($row_WADAproducts['Small_pic_Name']); ?>" alt="<?php echo($row_WADAproducts['']); ?>" width="150"/>

You can update that to use https:// instead of http:// right there on the php page.

Sign in to reply to this post

Charles

Almost there . . .

Sign in to reply to this post

Ray BorduinWebAssist

On pages with CMS where the path is actually already in the database you would have to use a replace function to adjust the code.... something like:

php:
<?php echo str_replace("http://","https://",WA_getCMSContent($database_PowerCMSConnection$PowerCMSConnection'SCNJ-Home''SCNJ Home Box 1')); ?>



You can also update your webassist/kfm/config.php file so that it uses https:// automatically in the future, but that wouldn't fix the existing data... however you could do a replace in the database as well to account for the problem that way.

Sign in to reply to this post

Charles

Still stuck . . .

Sign in to reply to this post

Charles

Disregard my previous answer

I found that I can edit the http to https in the pcms2_contents table of the DB and it clears the issue! Excellent - thank you!
Hopefully by updating the kfm config file, it will also work going forward.

Sign in to reply to this post

Ray BorduinWebAssist

Yes. That should take care of it.

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...