I am working on a task in which I need advice for. I am trying to convert the database and data to UTF-8. I am using a SMF test forum in order to minimize risk to to the actual forum. It is located here…
https://1858remington.com/test/index.php“You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'key key varbinary(255) NOT NULL default ''' at line 10
File: /home/eartjylo/1858remington.com/test/Sources/ManageMaintenance.php
Line: 664
Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 2.0.17, while your database is at version 2.0.6. The above error might possibly go away if you execute the latest version of upgrade.php. ”
I have the most current version of SMF, plus I have run the upgrade.php again, as suggested by the last line of the above message.
I contacted my host and got this back…
We have checked the settings for your application and the error logs, please check it below:
[19-May-2020 18:50:00 America/New_York] PHP Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/eartjylo/1858remington.com/test/Sources/Subs.php on line 3825
It seems that the issue is caused by the file Subs.php. Please double-check the code in this file with the website developer.
What should I do?