Topic on Project:Support desk

I'm currently receiving the following error on a fresh install of media wiki. I've not seen this before so any help would be greatly appreciated.

[XlUxDInaLdpKzzb5@CIEigAAACI] /mw-config/index.php?page=Install Wikimedia\Rdbms\DBQueryError from line 1603 of /home/vol1000_5/epizy.com/epiz_25226591/htdocs/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?

Query: CREATE TABLE `wikiuser` (

user_id int unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT,

user_name varchar(255) binary NOT NULL default '',

user_real_name varchar(255) binary NOT NULL default '',

user_password tinyblob NOT NULL,

user_newpassword tinyblob NOT NULL,

user_newpass_time binary(14),

user_email tinytext NOT NULL,

user_touched binary(14) NOT NULL default '',

user_token binary(32) NOT NULL default '',

user_email_authenticated binary(14),

user_email_token binary(32),

user_email_token_expires binary(14),

user_registration binary(14),

user_editcount int,

user_password_expires varbinary(14) DEFAULT NULL

) ENGINE=, DEFAULT CHARSET=binary

Function: Wikimedia\Rdbms\Database::sourceFile( /home/vol1000_5/epizy.com/epiz_25226591/htdocs/maintenance/tables.sql )

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 17 (sql308.epizy.com)

Backtrace:

#0 /home/vol1000_5/epizy.com/epiz_25226591/htdocs/includes/libs/rdbms/database/Database.php(1574): Wikimedia\Rdbms\Database->getQueryExceptionAndLog(string, integer, string, string)

#1 /home/vol1000_5/epizy.com/epiz_25226591/htdocs/includes/libs/rdbms/database/Database.php(1152): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean)

#2 /home/vol1000_5/epizy.com/epiz_25226591/htdocs/includes/libs/rdbms/database/Database.php(4539): Wikimedia\Rdbms\Database->query(string, string)

#3 /home/vol1000_5/epizy.com/epiz_25226591/htdocs/includes/libs/rdbms/database/Database.php(4474): Wikimedia\Rdbms\Database->sourceStream(resource (closed), NULL, NULL, string, NULL)

#4 /home/vol1000_5/epizy.com/epiz_25226591/htdocs/includes/installer/DatabaseInstaller.php(228): Wikimedia\Rdbms\Database->sourceFile(string)

#5 /home/vol1000_5/epizy.com/epiz_25226591/htdocs/includes/installer/DatabaseInstaller.php(251): DatabaseInstaller->stepApplySourceFile(string, string, boolean)

#6 /home/vol1000_5/epizy.com/epiz_25226591/htdocs/includes/installer/Installer.php(1624): DatabaseInstaller->createTables(MysqlInstaller)

#7 /home/vol1000_5/epizy.com/epiz_25226591/htdocs/includes/installer/WebInstallerInstall.php(44): Installer->performInstallation(array, array)

#8 /home/vol1000_5/epizy.com/epiz_25226591/htdocs/includes/installer/WebInstaller.php(270): WebInstallerInstall->execute()

#9 /home/vol1000_5/epizy.com/epiz_25226591/htdocs/mw-config/index.php(80): WebInstaller->execute(array)

#10 /home/vol1000_5/epizy.com/epiz_25226591/htdocs/mw-config/index.php(38): wfInstallerMain()

#11 {main}

Hi! Did you run Update.php? Also, which version of MediaWiki you are trying to install?

What is $wgDBTableOptions set to? I think it's set to something wrong. It should be something like $wgDBTableOptions = "ENGINE=InnoDB, DEFAULT CHARSET=binary";

Wait, this is in the installer. This would probably indicate _MysqlEngine is set to the empty string. I'm not sure how that could happen. Are you using the normal installer? Did you get MediaWiki from the official site?

Can you do the SQL query SHOW ENGINES; and tell us the results?

During the installer, on the MySQL settings step, what did you select for Storage engine: option?

I am also having this issue while attempting to install MediaWiki 1.35 from GitHub.

Any solution? I have the excact problem

people who are having the same issue should also answer my comment above asking for more details.

The following is what I get when I query SHOW ENGINES;

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

well you have both InnoDB and MyISAM which are the two mw looks for, so idk.