Getting error while setting up MediaWiki

Username (e.g. epiz_XXX) or Website URL

epiz_28427855

Error Message

[YH@Pbmmt6irpTiWuJWkUDwAAAD0] /w/mw-config/index.php?page=Install Wikimedia\Rdbms\DBQueryError from line 1699 of /home/vol10_2/epizy.com/epiz_28427855/htdocs/w/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 (sql202.epizy.com:3306)
Function: Wikimedia\Rdbms\Database::sourceFile( /home/vol10_2/epizy.com/epiz_28427855/htdocs/w/maintenance/tables-generated.sql )
Query: CREATE TABLE wlhmnsite_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/vol10_2/epizy.com/epiz_28427855/htdocs/w/includes/libs/rdbms/database/Database.php(1683): Wikimedia\Rdbms\Database->getQueryException(string, integer, string, string)
#1 /home/vol10_2/epizy.com/epiz_28427855/htdocs/w/includes/libs/rdbms/database/Database.php(1658): Wikimedia\Rdbms\Database->getQueryExceptionAndLog(string, integer, string, string)
#2 /home/vol10_2/epizy.com/epiz_28427855/htdocs/w/includes/libs/rdbms/database/Database.php(1227): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean)
#3 /home/vol10_2/epizy.com/epiz_28427855/htdocs/w/includes/libs/rdbms/database/Database.php(5073): Wikimedia\Rdbms\Database->query(string, string)
#4 /home/vol10_2/epizy.com/epiz_28427855/htdocs/w/includes/libs/rdbms/database/Database.php(5008): Wikimedia\Rdbms\Database->sourceStream(resource (closed), NULL, NULL, string, NULL)
#5 /home/vol10_2/epizy.com/epiz_28427855/htdocs/w/includes/installer/DatabaseInstaller.php(232): Wikimedia\Rdbms\Database->sourceFile(string)
#6 /home/vol10_2/epizy.com/epiz_28427855/htdocs/w/includes/installer/DatabaseInstaller.php(256): DatabaseInstaller->stepApplySourceFile(string, string, boolean)
#7 /home/vol10_2/epizy.com/epiz_28427855/htdocs/w/includes/installer/Installer.php(1732): DatabaseInstaller->createTables(MysqlInstaller)
#8 /home/vol10_2/epizy.com/epiz_28427855/htdocs/w/includes/installer/WebInstallerInstall.php(44): Installer->performInstallation(array, array)
#9 /home/vol10_2/epizy.com/epiz_28427855/htdocs/w/includes/installer/WebInstaller.php(269): WebInstallerInstall->execute()
#10 /home/vol10_2/epizy.com/epiz_28427855/htdocs/w/mw-config/index.php(82): WebInstaller->execute(array)
#11 /home/vol10_2/epizy.com/epiz_28427855/htdocs/w/mw-config/index.php(40): wfInstallerMain()
#12 {main}

Other Information

I did want to create a wiki using MediaWiki, but i can’t setting things up. Pls help ;-;

https://forum.infinityfree.com/search?q=MediaWiki

A quick Google search shows me this item from the MediaWiki talk pages:

https://www.mediawiki.org/wiki/Topic:Sc4g0shq1xjyqtan

Maybe you can change the charset from binary to utf-8 by changing the Manual:$wgDBTableOptions configuration option and fix it that way?

1 Like

This topic was automatically closed 15 days after the last reply. New replies are no longer allowed.