MYSQL Problem when Updating from RS 8.6.12.117 to RS 9.2.14.536

[Kristian Nurmi]

Hi,

I'm having trouble updating to the latest Resourcespace. I'm using XAMPP to test the upgrade process as usual. I'm running PHP 7.4.3.

I just copied the new installation files and replaced the filestore with my old files. Then imported the current SQL and replaced the config.php with the old one.

When I try to access the new resource space I get this error. I have no clue how to solve this.
(database) line N/A: 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 'PRIMARY on annotation (ref)' at line 1<br/><br/>create index PRIMARY on annotation (ref)

---

 

Rakennuskemia Oy, Kerkkolankatu 17, 05800 Hyvinkää, Finland

+358-19-457 4400 | in...@rakennuskemia.com | www.rakennuskemia.com

This message and any attachments may contain confidential and/or privileged information. They are intended solely for the named recipient(s). If you are not the intended recipient you may not disclose, copy, distribute or retain any part of this message or attachments. If you have received this email in error, please inform the sender by return email and delete this message and any attachments. Any views or opinions expressed are solely those of the author and do not necessarily represent those of Rakennuskemia Oy. 

[Kristian Nurmi]

There also seems to be a JSON syntax error when selecting anything from the new browser menu. I get this error.
Error 200. Sorry, there has been an error. If this error persists please contact your system administrator : SyntaxError: Unexpected token < in JSON at position 0

[charrier...@gmail.com]

Hi, got the same JSON error. Did u fix it ? Any idea of where it comme sfrom ?