Hello, I have made an oopsie and enabled forced HTTPS before I installed my cert. I have found a previous solution but the syntax is not working for my mysql version. (mysql Ver 8.0.28-0ubuntu0.20.04.3).
The solution I found for this issue is to change the value in Mysql. UPDATE ost_config SET value = '' WHERE key = 'force_https';
The problem arises near the end at key = 'force_https';
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'key = 'force_https'' at line 1
If you could point me in the right direction of the syntax required to fix this issue, I would be grateful.