Project:Support desk/Sections/Database

__NEWSECTIONLINK__

= MediaWiki Database Support =

(Resolved) Wired Data after upgrading of Debian

 * MediaWiki version: 1.11
 * PHP version: 5.2
 * MySQL version: 5.0 / Lastest Debian 5.0
 * URL: http://wiki.seemannsreise.de

After upgrading of debian 5.0 the whole wiki is getting wired. The databases tables itselfes look alright, and instaling a backupdatabase didn't help. What can i do ... ? Richard 212.51.25.1 Update: Upgrading from 1.11 to 1.14 didn't solve the problem.... Update2: Upgrading vom 1.11 to 1.14 with Database Update solved the problem. Everything up and running again :-). See "Upgrading Medawiki" for more information

[Solved] Database error when registered user or Admin try to modify Main page contents

 * MediaWiki version: 1.13.3
 * PHP version: 5
 * MySQL version:
 * URL: http://www.4copter.com/mediawiki

Hello, I have a quite strange problem.

When a logged registered user or logged Admin try to modify the Main page contents he receive an error message: ''Sorry! This site is experiencing technical difficulties. Try waiting a few minutes and reloading. (Can't contact the database server: Unknown error (sql.4copter.com))''

Any non logged user  can modify the main page ! Registered users and Admin when logged can access to their pages.

It is a bug !

'''If I click on the edit link on the left side of the Main page, the hyperlink is something like http://www.mysite.com/mediawiki/index.php?title=main_page&action=edit&section=1

But if I click on the "modify" tab on the top menu of the same page hyperlink is something like http://www.mysite.com/mediawiki/index.php?title=main_page&action=edit

Without the final part of link "&section=1" the page can be modified also by registred user and Admin.


 * Why solved ? where ? I experienced the very same problem.

I will hide editsection until a solution will be found.
 * MediaWiki version: 1.14.0
 * PHP version: 5.2
 * MySQL version: 5.0.51-community
 * free host: http://www.000webhost.com
 * URL: http://www.brunehaud.be

ipblocks table corrupt?

 * MediaWiki version: 1.12
 * PHP version: 5.2.4
 * MySQL version: N/A
 * Postgresql version: 8.3.1
 * URL: N/A (intranet)

I receive the following message when trying to describe table ipblocks "ERROR: expected "[" to start datum, but got "4 [ 1 0 0 0 ]})}"; length = 0".

The reason I noticed this is because database dumps are now failing.

Sorry! This site is experiencing technical difficulties.
I get this error when editing any page. But saving a new page is functional.


 * (sitename) has a problem

Sorry! This site is experiencing technical difficulties.

Try waiting a few minutes and reloading.

(Can't contact the database server: Unknown error (mysql6.000webhost.com))

Can any one please help?

Answer: there is a file in the main folder called 'LocalSettings.php'. This file contains your database username and password information. Check to make sure the credentials are correct - this solved my problem. I had a bad password.

Illegal mix of collations for operation after Upgrade
Live-Wiki (1.3.9) has charset=iso-8859-1 // (German)
 * MediaWiki: 1.14.0 (upgrade from: 1.3.9)
 * PHP: 5.2.4 (apache2handler)
 * MySQL: 5.1.33-community
 * Url: test-machine @ home (Windows)

I've got the following error on some pages: ... aus der Funktion „LinkBatch::doQuery“. MySQL meldete den Fehler „1271: Illegal mix of collations for operation ' IN ' (localhost)“.

I've upgraded via Web-Setup. Shell don't work. wgDBmysql5 is true ... false = no error, but i get problem with umlauts like äöü! The complete database has collation binary (manuelly set) and innodb (manuelly). After upgrade is sometimes innodb, myisam mixed or binary, latin1 mixed. I've tested some "install"-methodes (other settings) to upgrade - nothing work :(

What can i do?
 * same problem here :( It seems an issue with moving databases, can't find an easy fix yet.

Updating to 1.14
HI,

I upgraded to 1.14 today using ../maintenance/update.php and I have now an error when I want to view a page (in french) :

Erreur de syntaxe de la requête dans la base de données est intervenue. Ceci peut indiquer un bogue dans le logiciel. La dernière requête traitée par la base de données était :

(Requête SQL cachée)

depuis la fonction « OutputPage::addCategoryLinks ». MySQL a renvoyé l’erreur « 1146 : Table 'wwmbxfdgchaton.wiki_page_props' doesn't exist (mysql5-7) »

Here my environment variables.

Please include all of the lines below when reporting installation problems.

* PHP 5.2.9 installed * Found database drivers for: MySQL PostgreSQL * PHP server API is cgi; using ugly URLs (index.php?title=Page_Title) * Have XML / Latin1-UTF-8 conversion support. * Session save path (/tmp) appears to be valid. * PHP's memory_limit is 32M. * Couldn't find Turck MMCache, eAccelerator, APC or XCache; cannot use these for object caching. * Found GNU diff3: /usr/bin/diff3. * Found ImageMagick: /usr/bin/convert; image thumbnailing will be enabled if you enable uploads. * Found GD graphics library built-in. * Installation directory: /homez.150/wwmbxfdg/www/wiki * Script URI path: /wiki * Installing MediaWiki with php file extensions * Environment checked. You can install MediaWiki. *

Generating configuration file... * Database type: MySQL * Loading class: DatabaseMysql * Attempting to connect to database server as wwmbxfdgchaton...success. * Connected to mysql 5.0.68-log; enabling MySQL 4.1/5.0 charset mode * Database wwmbxfdgchaton exists * Creating tables... done. * Initializing statistics...   * Created sysop account JP. *

Creating LocalSettings.php...

Installation successful! Move the config/LocalSettings.php file to the parent directory, then follow this link to your wiki.

You should change file permissions for LocalSettings.php as required to prevent other users on the server reading passwords and altering configuration data.

Thanks for your help.

Database error when trying to edit pages.

 * MediaWiki version: 1.14.0
 * PHP version: 5.3.1 (apache2handler)
 * MySQL version: 5.1.30-log
 * URL: intranet

When trying to update or edit any page, with any user gets the following error.

Database error A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was: (SQL query hidden) from within function "Revision::insertOn". MySQL returned error "1048: Column 'old_text' cannot be null (localhost)".

Update from 1.3.9 (latin1) to 1.15.1 (UTF8) - problem with converting latin to utf8

 * MediaWiki version: upgraded from 1.3.9 to 1.15.1
 * PHP version: 5.x
 * MySQL version: 4.x
 * URL: not public

I make an update via web. After update i have encoding-errors in some (not all!) sections: e.g. Special:ListFiles (Comments), RecentChanges etc. The Main-Content (?title=Mainpage) is ok. No Problems mit Umlauts, Special-Chars. On some pages i get a Collation-Error. (search in ListFiles a Filename with Umlaut) Look @ Database: many Table/Rows has collation latin1 (why?!). I change it manually to utf8-bin/general => collation-errors are fixed. I make a Dump from "images" with mysqldumper (webbased tool), i say his encoding is "latin1". I opened the .sql with notepad++ (windows) and change format from ansi to utf8/boms. Import with mysqldumper. Now: no Encoding-Errors in Special:ListFiles. Fine! Same withe the revision-Table. No Errors in History. Fine! Have I do this with EVERY Table?! :( (49 after update, fresh install 41 ... normal?)

But whats the problem with update-procedure? Only some Tables are converting. Only some rows are utf8 :( How i can update correctly to 1.15.1 utf8 ?. Before update -> dump (latin1) -> convert to utf8 -> import sql -> update? 1-2 Years ago this doesn't work :( Pagenames with Umlauts are broken und many encoding-Errors! :((

Sorry for my bad englisch :( Thanks in advance


 * MediaWiki version:
 * PHP version:
 * MySQL version:
 * URL:

The following error popped up during my install process. I have been unable to fix this. Please help!

* PHP 5.3.2 installed * Found database drivers for: PostgreSQL SQLite * PHP server API is apache2handler; ok, using pretty URLs (index.php/Page_Title) * Have XML / Latin1-UTF-8 conversion support. * Session save path (/var/lib/php/session) appears to be valid. * PHP's memory_limit is 128M. * Couldn't find Turck MMCache, eAccelerator, APC or XCache; cannot use these for object caching. * Found GNU diff3: /usr/bin/diff3. * Found ImageMagick: /usr/bin/convert; image thumbnailing will be enabled if you enable uploads. * Installation directory: /var/www/html/wiki * Script URI path: /wiki * Installing MediaWiki with php file extensions * Environment checked. You can install MediaWiki. *

Generating configuration file... * Database type: PostgreSQL * Loading class: DatabasePostgres * Attempting to connect to database "postgres" as superuser "andyyen"...   * Checking the version of Postgres...version 8.1.18 is OK. * User "wikiuser" already exists, skipping account creation. * Database "wikidb" already exists, skipping database creation. * Connecting to "wikidb" as superuser "andyyen" to check rights...OK   * Checking that tsearch2 is installed in the database "wikidb"...OK    * Ensuring that user "wikiuser" has select rights on the tsearch2 tables...OK    * Schema already exists, explicitly granting rights... OK   * Checking for Pl/Pgsql ...OK    * Attempting to connect to database "wikidb" as "wikiuser"...    * Checking the version of Postgres...version 8.1.18 is OK. * Checking for tsearch2 in the schema "public"...OK   * Checking tsearch2 permissions...OK    * Verifying tsearch2 locale with en_US.UTF-8...not found * Attempting to set default tsearch2 locale to "en_US.UTF-8"... Warning: pg_query: Query failed: ERROR: permission denied for relation pg_ts_cfg in /var/www/html/wiki/includes/db/DatabasePostgres.php on line 580 FAILED. Please make sure that the locale in pg_ts_cfg for "default" is set to "en_US.UTF-8"

—131.215.22.175 12:07, 9 March 2010 (UTC)

All tables are populated, but I can't get the text to show

 * MediaWiki version: 1.15.1
 * PHP version: 3.2.4
 * MySQL version: 4.1.22
 * URL: http://badger.arvixe.com/~dpmccann/wiki/ (dns hasn't propagated yet)

After moving my wiki, I can't get the text to show. Tried rebuilding the text index, refreshing links... nothing is fixing it. I'm pretty new at this and could really use some help.

Thanks.

DPM

—88.252.140.240 03:19, 17 March 2010 (UTC)

So, it seems that the database backed up, but I have to do an xml dump from the old location and import it to the new one. mwdumper seems to be just the tool...if only I could figure out how to use it.

You know, guys, a basic manual for beginners would be a good idea.

issues upgrading to 1.15.2

 * mediawiki version [old]: 1.11.0 and 1.11.2
 * mediawiki version [new]: 1.15.2
 * php version: 5.2.6
 * mysql version: 5.0.67

INDEX command denied to user
i am trying to upgrade a number of wikis [1.11.0 and 1.11.2] to 1.15.2. on virtually all the upgrades i am getting an error:

MySQL returned error "1142: INDEX command denied to user '$WIKIadm'@'localhost' for table 'pagelinks' (localhost)"

the problem being that on each of them, when i go into mysql and issue a show grants, all of those users have INDEX:

mysql> show grants for '$WIKIadm'@'localhost'; +---+ | Grants for $WIKIadm@localhost                                                                                | +---+ | GRANT USAGE ON *.* TO '$WIKIadm'@'localhost' IDENTIFIED BY PASSWORD '$PASSWORD'                              | | GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER, LOCK TABLES ON `$WIKI`.* TO '$WIKIadm'@'localhost'      | +---+ 2 rows in set (0.01 sec)

i don't quite understand the error, considering mysql seems to think i have the necessary access.

-Zeefreak 18:19, 2 April 2010 (UTC)

Accidentally deleted database
Hi, After just installing MediaWiki and setting everything up I accidentally deleted the database (good news, I didn't lose anything). Now, though, nothing works. Is there a way to easily create a new database with everything needed for my site to run?

resolution
i think if you remove or rename ./LocalSettings.php and then just go to your wiki you can rerun the config. that will recreate all the tables for you.

Zeefreak 18:13, 5 April 2010 (UTC)