Topic on Project:Support desk/Flow

This is the problem I'm running into. No clue what to do.

[YHIRZHvPbKyipD3wVS0RSQAAAAI] /mediawiki-1.35.1/mw-config/index.php?page=Install Wikimedia\Rdbms\DBQueryError from line 1699 of /home/vol9_8/epizy.com/epiz_xxxxxxxx/htdocs/mediawiki-1.35.1/includes/libs/rdbms/database/Database.php: A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' DEFAULT CHARSET=binary' at line 8 (sql104.epizy.com)

Function: Wikimedia\Rdbms\Database::sourceFile( /home/vol9_8/epizy.com/epiz_xxxxxxxx/htdocs/mediawiki-1.35.1/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 site_ids_site (si_site),

INDEX site_ids_key (si_key),

PRIMARY KEY(si_type, si_key)

) ENGINE=, DEFAULT CHARSET=binary

Backtrace:

#0 /home/vol9_8/epizy.com/epiz_xxxxxxxx/htdocs/mediawiki-1.35.1/includes/libs/rdbms/database/Database.php(1683): Wikimedia\Rdbms\Database->getQueryException(string, integer, string, string)

#1 /home/vol9_8/epizy.com/epiz_xxxxxxxx/htdocs/mediawiki-1.35.1/includes/libs/rdbms/database/Database.php(1658): Wikimedia\Rdbms\Database->getQueryExceptionAndLog(string, integer, string, string)

#2 /home/vol9_8/epizy.com/epiz_xxxxxxxx/htdocs/mediawiki-1.35.1/includes/libs/rdbms/database/Database.php(1227): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean)

#3 /home/vol9_8/epizy.com/epiz_xxxxxxxx/htdocs/mediawiki-1.35.1/includes/libs/rdbms/database/Database.php(5075): Wikimedia\Rdbms\Database->query(string, string)

#4 /home/vol9_8/epizy.com/epiz_xxxxxxxx/htdocs/mediawiki-1.35.1/includes/libs/rdbms/database/Database.php(5010): Wikimedia\Rdbms\Database->sourceStream(resource (closed), NULL, NULL, string, NULL)

#5 /home/vol9_8/epizy.com/epiz_xxxxxxxx/htdocs/mediawiki-1.35.1/includes/installer/DatabaseInstaller.php(232): Wikimedia\Rdbms\Database->sourceFile(string)

#6 /home/vol9_8/epizy.com/epiz_xxxxxxxx/htdocs/mediawiki-1.35.1/includes/installer/DatabaseInstaller.php(256): DatabaseInstaller->stepApplySourceFile(string, string, boolean)

#7 /home/vol9_8/epizy.com/epiz_xxxxxxxx/htdocs/mediawiki-1.35.1/includes/installer/Installer.php(1732): DatabaseInstaller->createTables(MysqlInstaller)

#8 /home/vol9_8/epizy.com/epiz_xxxxxxxx/htdocs/mediawiki-1.35.1/includes/installer/WebInstallerInstall.php(44): Installer->performInstallation(array, array)

#9 /home/vol9_8/epizy.com/epiz_xxxxxxxx/htdocs/mediawiki-1.35.1/includes/installer/WebInstaller.php(269): WebInstallerInstall->execute()

#10 /home/vol9_8/epizy.com/epiz_xxxxxxxx/htdocs/mediawiki-1.35.1/mw-config/index.php(82): WebInstaller->execute(array)

#11 /home/vol9_8/epizy.com/epiz_xxxxxxxx/htdocs/mediawiki-1.35.1/mw-config/index.php(40): wfInstallerMain()

#12 {main}

In SQL, what is the output of SHOW ENGINES; ?

Hi. Thanks for the reply. This is the output:

Engine	Support	Comment	Transactions	XA	Savepoints
PERFORMANCE_SCHEMA	YES	Performance Schema	NO	NO	NO
CSV	YES	CSV storage engine	NO	NO	NO
MRG_MYISAM	YES	Collection of identical MyISAM tables	NO	NO	NO
BLACKHOLE	YES	/dev/null storage engine (anything you write to it...	NO	NO	NO
MyISAM	DEFAULT	MyISAM storage engine	NO	NO	NO
FEDERATED	NO	Federated MySQL storage engine	NULL	NULL	NULL
ARCHIVE	YES	Archive storage engine	NO	NO	NO
MEMORY	YES	Hash based, stored in memory, useful for temporary...	NO	NO	NO
InnoDB	NO	Percona-XtraDB, Supports transactions, row-level l...	NULL	NULL	NULL

And in particular, make sure that InnoDB is one of them.

Also, were you prompted during install to choose between innodb/myisam, and if so what did you choose?

Also did you compile mysql/mariadb yourself with unusual compile time options, get it from an unusual source, or otherwise have something unique with your database? You're the second person i have heard of with this issue (mediawiki installer not detecting mysql engine properly), and i dont think anyone figured out what happened last time around.

Hi. Thanks for the reply. I tried SHOW ENGINES; and it says my database doesn't support innodb but I can't use myisam because the installer didn't prompt me to choose between them. Do you know if there's any way around this or will I have to find a new host where they have innodb?

Hmm, i thought it'd be automatically detected. There is definitely a bug in the installer. I guess you could try the commandline install.php

You might want to do that anyways, innodb is much more reliable than myisam

Your question title is not appropriate. It should be like this, hi i am trying to install MediaWiki.

See- Download

MediaWiki is not compatible with PHP 7.4.0 to 7.4.2 due to an upstream bug. Use PHP 7.4.3 or later instead. See [[task T246594]] for more information. Thank you

@Tanbirzx That comment is not helpful. Why do you think this has anything to do with PHP versions? The reporter did not even mention any PHP version. You could ask them for a PHP version, instead of jumping to wrong conclusions.