Topic on Project:Support desk

Hi I am having a problem with installing mediawiki a day or two ago I went to my website and noticed that it was corrupt because it crashed I made a backup but as it is corrupt I carnt use it so I try installing it fresh but it just doesent wont to install it comes up with these errors.

MediaWiki 1.24wmf19 installation

Setting up database... done Creating tables... Sorry! This site is experiencing technical difficulties.

Try waiting a few minutes and reloading.

(Cannot contact the database server: Can't connect to MySQL server on '216.218.192.170' (111) (216.218.192.170:3306))

Backtrace:

1. 0 /home/pal2015/public_html/includes/db/DatabaseMysqlBase.php(103): DatabaseBase->reportConnectionError(':real_connect()...')
2. 1 /home/pal2015/public_html/includes/db/DatabaseMysqlBase.php(574): DatabaseMysqlBase->open('216.218.192.170...', 'paladox_admin', 'REDACTED', 'paladox_wiki')
3. 2 /home/pal2015/public_html/includes/db/Database.php(1159): DatabaseMysqlBase->ping()
4. 3 /home/pal2015/public_html/includes/db/Database.php(3948): DatabaseBase->query('CREATE TABLE `u...', 'DatabaseBase::s...')
5. 4 /home/pal2015/public_html/includes/db/Database.php(3862): DatabaseBase->sourceStream(Resource id #97, false, false, 'DatabaseBase::s...', false)
6. 5 /home/pal2015/public_html/includes/installer/DatabaseInstaller.php(196): DatabaseBase->sourceFile('/home/pal2015/p...')
7. 6 /home/pal2015/public_html/includes/installer/DatabaseInstaller.php(218): DatabaseInstaller->stepApplySourceFile('getSchemaPath', 'install', true)
8. 7 [internal function]: DatabaseInstaller->createTables(Object(MysqlInstaller))
9. 8 /home/pal2015/public_html/includes/installer/Installer.php(1584): call_user_func(Array, Object(MysqlInstaller))
10. 9 /home/pal2015/public_html/includes/installer/WebInstallerPage.php(1418): Installer->performInstallation(Array, Array)
11. 10 /home/pal2015/public_html/includes/installer/WebInstaller.php(280): WebInstallerInstall->execute()
12. 11 /home/pal2015/public_html/mw-config/index.php(79): WebInstaller->execute(Array)
13. 12 /home/pal2015/public_html/mw-config/index.php(38): wfInstallerMain()
14. 13 {main}

I am running mediawiki 1.24 wmf 19 I think there is a problem in tables.sql or one of the .sql scripts in the maintenance folder. I have tried installing it on two different MySQL servers and same error so I think it is to do with the mediawiki software.

website is http://wikisaur.tk

It seems to be the user table having the problem.

This isn't a problem of MediaWiki or the table structure, see the error message:

> Can't connect to MySQL server on '216.218.192.170'

This means, that there isn't a mysql server behind this ip, or requests are blocked by a firewall, or something else ;)

P.S.: Please notice, that the wmf versions are not meant for third party wikis, so please use them only, if you know what you do :) You drive better with the stable releases :)

Hi well when I use the table.sql manualy it works when I use web updater it doesent.

if I try to redo the install it says this

Install

A database query error has occurred. This may indicate a bug in the software.•Query:
CREATE TABLE `user` ( 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=InnoDB, DEFAULT CHARSET=binary

•Function: DatabaseBase::sourceFile( /home/pal2015/public_html/maintenance/tables.sql )

•Error: 1146 Table 'pal2015_wiki6.user' doesn't exist (localhost) Backtrace:

#0 /home/pal2015/public_html/includes/db/Database.php(1184): DatabaseBase-&--#62;reportQueryError('Table 'pal2015_...', 1146, 'CREATE TABLE `u...', 'DatabaseBase::s...', false)
#1 /home/pal2015/public_html/includes/db/Database.php(3948): DatabaseBase-&--#62;query('CREATE TABLE `u...', 'DatabaseBase::s...')
#2 /home/pal2015/public_html/includes/db/Database.php(3862): DatabaseBase-&--#62;sourceStream(Resource id #97, false, false, 'DatabaseBase::s...', false)
#3 /home/pal2015/public_html/includes/installer/DatabaseInstaller.php(196): DatabaseBase-&--#62;sourceFile('/home/pal2015/p...')
#4 /home/pal2015/public_html/includes/installer/DatabaseInstaller.php(218): DatabaseInstaller-&--#62;stepApplySourceFile('getSchemaPath', 'install', true)
#5 [internal function]: DatabaseInstaller-&--#62;createTables(Object(MysqlInstaller))
#6 /home/pal2015/public_html/includes/installer/Installer.php(1584): call_user_func(Array, Object(MysqlInstaller))
#7 /home/pal2015/public_html/includes/installer/WebInstallerPage.php(1418): Installer-&--#62;performInstallation(Array, Array)
#8 /home/pal2015/public_html/includes/installer/WebInstaller.php(280): WebInstallerInstall-&--#62;execute()
#9 /home/pal2015/public_html/mw-config/index.php(79): WebInstaller-&--#62;execute(Array)
#10 /home/pal2015/public_html/mw-config/index.php(38): wfInstallerMain()
#11 {main}

Notice: Uncommitted DB writes (transaction from DatabaseInstaller::stepApplySourceFile). in /home/pal2015/public_html/includes/db/Database.php on line 4238

I have tested wmf19 now locally and all is ok. The installer created all tables successfully without any errors. So it has to be an error in your installation :)

Is the database you want to use new? Is your database user permitted to create tables?

yes I created a new database and tried to redo the install but it keeps failing.

and my database is permitted to create tables.

probably it is a problem with one of the extensions like centralauth because my other extension create there tables fine where as centralauth doesent create it and I have to do it manually.

You accidentally posted your password in your original post. I've redacted and revision-deleted it, but you should still change it in case anyone saw it between then and now.

Oh ok thanks.