0

In my TYPO3 v7.6 installation, I have an SQL script with the following line:

 recursive tinyint(3) unsigned DEFAULT '0' NOT NULL,

This tries to create a column named 'recursive'.

Unfortunately, recursive is a reserved keyword since MariaDB 10.2. I tried escaping the word like this:

`recursive`

but this still gave me the same error as before:

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 'recursive tinyint(3) unsigned NOT NULL | | | default '0'' at line XYZ.

How can I edit my statement to make this work? Downgrading MariaDB is not an option.

janisch
  • 159
  • 1
  • 1
  • 13

1 Answers1

3

TYPO3 7.6 is not compatible with MariaDB 10.2. As you've already stated that downgrading MariaDB is not an option, you're only options are:

  1. Upgrade to a newer version of TYPO3
  2. Fix the problem in TYPO3 7.6 yourself
  3. Contact TYPO3 GmbH to ask if MariaDB compatibility has been build into the ELTS (Extended Long Term Support) version or if you can sponsor this.

As TYPO3 7.6 is a very old version and if you don't already have ELTS (which ends at the end of this year anyway) there are multiple security issues with it, I'd recommend upgrading to a newer version.

Rudy Gnodde
  • 4,286
  • 2
  • 12
  • 34
  • I fully agree: do an upgrade: you can't just update the Server, Database, ... and don't touch the application + expect that everything will work – Georg Ringer Apr 18 '21 at 17:38