login issues after switching to SSL

Emeric_Kolbaszer

Hello,

I've been using this service on our forum (phpbb3) since 2014, very happy with it. However since I added SSL to the website, the browser doesn't display the oneall login option. If I check it with webdeveloper tools, it's telling me that:

Mixed Content: The page at 'https://www.gojilandromania.eu/forum/search.php?search_id=active_topics' was loaded over HTTPS, but requested an insecure script 'http://gojilandromania.api.oneall.com/socialize/library.js'. This request has been blocked; the content must be served over HTTPS.

Can you please help?

Emeric_Kolbaszer

If I press 'Print View" I get the following:

SELECT * FROM `bb_config` WHERE `config_name` LIKE '%protocol%' LIMIT 0, 30 ;

Rows: 1
config_name config_value is_dynamic server_protocol http:// 0

Emeric_Kolbaszer

"server_protocol http:// 0"

It seems like this was the problem, I changed it from http to https, did a cache refresh of the templates and now it works!

Claude, I'd like to thank you very much for the fast tech support and for the great service, I will definitely recommend your services to others, you guys are awesome! Keep up the good work!

Claude_Schlesser

Hi Emeric,

have you manually changed the phpBB templates to add the plugin?

Regards,

Emeric_Kolbaszer

Thank you for your answer! Yes I manually installed the extension on to the phpbb board if that's what you mean.

Claude_Schlesser

Hello,

could you please run this query in your database and post the output?
SELECT * FROM `phpbb_config` WHERE `config_name` LIKE '%protocol%'

You might have to change the phpbb_config to a different name if you are using another prefix.

Emeric_Kolbaszer

Had to change 'phpbb_config" to 'bb_config' and I ran the query in phpmyadmin and this is what I got:


Showing rows 0 - 0 (1 total, Query took 0.0009 sec)
SELECT *
FROM `bb_config`
WHERE `config_name` LIKE '%protocol%'
LIMIT 0 , 30


Is this what you are looking for?

Emeric_Kolbaszer

Also if I press the 'Explain SQL' button in phpmyadmin this is what it gives me:

Your SQL query has been executed successfully
EXPLAIN SELECT *
FROM `bb_config`
WHERE `config_name` LIKE '%protocol%'
[ Edit ] [ Skip Explain SQL ] [ Create PHP Code ]



+ Options
id
select_type
table
type
possible_keys
key
key_len
ref
rows
Extra
1
SIMPLE
bb_config
ALL
NULL
NULL
NULL
NULL
534
Using where