Good morning DMX,
I am experiencing Mixed Content warnings when I Join to a simple MYSQL View. The Views are all tried and tested but I continue to get Mixed Content warnings.

Any help appreciated as it is driving me crazy at the moment.

Thanks in advance.
Dave.

Hello,
Please be a little more detailed. What is the exact error message and when(where) exactly do you see it?

Hi Teodor,
I see the following error message on the page that queries the View in the Developer Console of Chrome:

Booking_Details_Subscriber.php?Booking_Reference=GB90lX6aS5pE3IA2uNjQLcoyRvCt&URL_Reference=nybLjTr…:1 Mixed Content: The page at 'https://www.EXAMPLE.COM/Subscriber/Booking_Details_Subscriber.php?Booki…nybLjTrfxUHYaScvDgoi2KW45Ak1&URL_Security_Key=WqncAybGTpfgOQ2wjhYvxJPksCmi' was loaded over HTTPS, but requested an insecure XMLHttpRequest endpoint 'http://www.EXAMPLE.COM/'. This request has been blocked; the content must be served over HTTPS.

---------------------------------

The View is simply:

SELECT
  `Booking_Builder`.`Booking_Reference` AS `Booking_Reference`,
  `Booking_Builder`.`Category` AS `Category`,
  `Booking_Builder`.`Amount` AS `Amount`,
  SUM(IFNULL(`Booking_Builder`.`IVA_Amount`, 0)) AS `Total Fees IVA`,
  SUM(IFNULL(`Booking_Builder`.`Total_Amount`, 0)) AS `Total Fees`,
  `Booking_Builder`.`Payment_Status` AS `Payment_Status`
FROM `Booking_Builder`
WHERE ((`Booking_Builder`.`Category` = 'Fee') AND (`Booking_Builder`.`Payment_Status` = 'Paid'))
GROUP BY `Booking_Builder`.`Booking_Reference`

Hope that helps..

The view executed on the server has nothing to do with this actually.

The problem is you are somehow loading a content (iframe or something similar) which is served over HTTP but on an HTTPS site.
Please provide a link to your page where we can check if this is related to any of our tools.

I am not loading an iframe this only happens when I Join to the View. Will send over details to support now.

Thanks Teodor!