Topic on Project:Support desk/Flow

Hello

I am trying to perform a installation of MediaWiki 1.42.3 on my server, and I am encountering the following error:

Error 1064: 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 ' DEFAULT CHARSET=binary' at line 8

Function: Wikimedia\Rdbms\Database::sourceFile( /home/mediawiki/htdocs/maintenance/tables-generated.sql )

Query: CREATE TABLE `site_identifiers` (

si_type VARBINARY(32) NOT NULL,

si_key VARBINARY(32) NOT NULL,

si_site INT UNSIGNED NOT NULL,

INDEX si_site (si_site),

INDEX si_key (si_key),

PRIMARY KEY(si_type, si_key)

) ENGINE=, DEFAULT CHARSET=binary

MariaDB Version: 10.6.20

Check your $wgDBTableOptions in LocalSettings.php. Visit the link to see the allowed valid values.

I am currently in the process of installing MediaWiki from scratch, and I do not yet have the LocalSettings.php file.

How are you doing the installation? Please give exact steps leading to the error. Also state from where you downloaded MediaWiki.

Reminds me a bit of phab:T212236

What is the output of SHOW ENGINES; from your database server.