JohnCMS 9.2.0

# chudels (19.05.2020 / 14:08)
Как вызвать bbcode на странице?

$tools = di(\Johncms\System\Legacy\Tools::class);
echo $tools->checkout($text, 1, 1);

Please help me, this problem when I'm install JohnCMS 9.2.0

SQLSTATE[23000]: Integrity constraint violation: 1217 Cannot delete or update a parent row: a foreign key constraint fails
SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'users' already exists
SQLSTATE[HY000]: General error: 1709 Index column size too large. The maximum column size is 767 bytes.
SQLSTATE[42000]: Syntax error or access violation: 1075 Incorrect table definition; there can be only one auto column and it must be defined as a key



mrCommand, What version of mysql do you have?

# Simba (30.05.2020 / 19:01)
mrCommand, What version of mysql do you have?

mrCommand, The easiest way is to update it. It will definitely work on version 10.1. https://mariadb.com/kb/en/changes-improvements-in-mariadb-101/

Simba, Is there any other way? I cannot update my mariadb at this time.

# Simba (30.05.2020 / 20:02)
mrCommand, The easiest way is to update it. It will definitely work on version 10.1. [url=https://mariadb.com/kb/en/changes-improvements-in-mariadb-101/]https://mariadb.com/kb/en/changes-improvements

You need to search for which of the queries the error appears on.
Try replacing the install/sql/install.sql file with this one

If this does not solve the problem, you can write to me in private messages FTP access to the site, I will try to solve this problem.

# Simba (01.06.2020 / 12:37)
You need to search for which of the queries the error appears on.
Try replacing the install/sql/install.sql file with this one