Project:Support desk/Sections/Database

__NEWSECTIONLINK__

= MediaWiki Database Support =

External 'USER' table

 * MediaWiki version: 1.51
 * PHP version: 5.2
 * MySQL version: 5.1

I want to build a few projects of wiki, but i want that the users will register once. how did i make cooperative 'USER' table for several projects?
 * Add the user table to $wgSharedTables -- Bryan ( talk|commons ) 15:10, 20 October 2009 (UTC)

(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?

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.

Updating to 1.15

 * MediaWiki version: 1.14/1.15
 * PHP version: 5.2.9
 * MySQL version: 5.0.67-userstats-log
 * URL: http://www.baltowiki.com

How can I update the database from 1.14 to 1.15? I updated the files on the server but not the database files. When I try to edit the main page, I get the 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 "IndexPager::reallyDoQuery (LogPager)". MySQL returned error "1146: Table 'baltow.bw_tag_summary' doesn't exist (baltow.baltowiki.com)".

Which I'm guessing is a new table that was added from 1.14 to 1.15.

—137.104.121.136 22:34, 10 September 2009 (UTC)


 * Right. Run the update script. —Emufarmers(T 00:23, 11 September 2009 (UTC)


 * Any way to do that without SSH? -72.160.221.185 05:13, 11 September 2009 (UTC)


 * Never mind I reran the installer and now it works, thank you! -72.160.221.185 16:49, 11 September 2009 (UTC)

Error importing revision.txt - Error: 1261, Row 1 doesn't contain data for all columns

 * MediaWiki version:
 * PHP version:
 * MySQL version: Ver 14.14 Distrib 5.4.1-beta, for Win64
 * URL:

I used the xml2sql tool from mediawiki to convert last year's wikipedia dump into text, page, and revision .txt files for import using mysqlimport. I set up my tables using the tables.sql file in the maintenance folder of the mediawiki distribution. I successfully imported text and page into the database g_dev but when I try to import revision I get the following error:

C:\ProgramData\MySQL\MySQL_Server_5.4\data\g_dev>mysqlimport -u root -p -f -v -r g_dev revision.txt Enter password: **** Connecting to localhost Selecting database g_dev Loading data from SERVER file: revision.txt into revision mysqlimport: Error: 1261, Row 1 doesn't contain data for all columns, when using table: revision Disconnecting from localhost

The head (20 lines) of the revision.txt file looks like:

C:\ProgramData\MySQL\MySQL_Server_5.4\data\g_dev>head -20 revision.txt 133452270      6       133452270       Revert edit(s) by Ngaiklin to last version by [[Special
 * Contributions/Docu|Docu]]     241822  Gurch   20070525171206  1       0

133452279      8       133452279       Revert edit(s) by Ngaiklin to last version by [[Special
 * Contributions/Rory096|Rory096]]       241822  Gurch   20070525171209  1       0

133452289      10      133452289       Revert edit(s) by Ngaiklin to last version by [[Special
 * Contributions/Rory096|Rory096]]       241822  Gurch   20070525171212  1       0

215126027      12      215126027       /* External links */ remove link per WP:EL      2670733 Kni00080526204455 74466652       13      74466652        cat rd  750223  Rory096 20060908041552  0       0 74466619       14      74466619        cat rd  750223  Rory096 20060908041536  0       0 135089040      15      135089040       Robot: Fixing double-redirect -"Demographics of Afghanistan" + "Demography of Afghanistan"    279219  RussBot 20070601135937  1       0 74466531       17      74466531        cat rd  750223  Rory096 20060908041458  0       0 74466499       18      74466499        cat rd  750223  Rory096 20060908041442  0       0 74466423       19      74466423        cat rd  750223  Rory096 20060908041407  0       0 74466354       20      74466354        cat rd  750223  Rory096 20060908041327  0       0 46448859       21      46448859            241822  Gurch   20060401120842  1  0 74466798       23      74466798        cat rd  750223  Rory096 20060908041700  0       0 74466889       24      74466889        cat rd  750223  Rory096 20060908041751  0       0 214727768      25      214727768       Add DOI for Francis 2005. 3573537 Eubulides      20000525001710 74467016       27      74467016        cat rd  750223  Rory096 20060908041856  0       0 74466319       28      74466319        cat rd  750223  Rory096 20060908041309  0       0 74466817       29      74466817        cat rd  750223  Rory096 20060908041712  0       0 74467061       30      74467061        cat rd  750223  Rory096 20060908041917  0       0 197516257      33      197516257       restore redirect. No evidence of notability of the lothing00080311174540

The columns of table revision look like this:

mysql> show columns from revision; ++-+--+-+++ ++-+--+-+++ ++-+--+-+++ 11 rows in set (0.01 sec)
 * Field         | Type                | Null | Key | Default        | Extra          |
 * rev_id        | int(10) unsigned    | NO   | PRI | NULL           | auto_increment |
 * rev_page      | int(10) unsigned    | NO   | MUL | NULL           |                |
 * rev_text_id   | int(10) unsigned    | NO   |     | NULL           |                |
 * rev_comment   | tinyblob            | NO   |     | NULL           |                |
 * rev_user      | int(10) unsigned    | NO   | MUL | 0              |                |
 * rev_user_text | varchar(255)        | NO   | MUL |                |                |
 * rev_timestamp | binary(14)          | NO   | MUL |                |                |
 * rev_minor_edit | tinyint(3) unsigned | NO  |     | 0              |                |
 * rev_deleted   | tinyint(3) unsigned | NO   |     | 0              |                |
 * rev_len       | int(10) unsigned    | YES  |     | NULL           |                |
 * rev_parent_id | int(10) unsigned    | YES  |     | NULL           |                |

If anyone can help on this, please let me know here or email me at daryl.woodward@gmail.com Thank you.


 * MediaWiki version: 1.15.1
 * PHP version: 5.2.4-2ubuntu5.7
 * MySQL version: 5.0.51a-3ubuntu5.4
 * URL: http://wiki.smartouch.fr/config/index.php

Hi,

I have this error :

'''Sorry! This site is experiencing technical difficulties.''' Try waiting a few minutes and reloading.

(Can't contact the database server: Unknown error (91.121.113.174:3306))

I'm sure the password and the ip are right.

Here the previous operations done :


 * 1) PHP 5.2.4-2ubuntu5.7 installed
 * 2) Found database drivers for: MySQL
 * 3) PHP server API is apache2handler; ok, using pretty URLs (index.php/Page_Title)
 * 4) Have XML / Latin1-UTF-8 conversion support.
 * 5) Session save path (/var/lib/php5) appears to be valid.
 * 6) PHP's memory_limit is 32M.
 * 7) Couldn't find Turck MMCache, eAccelerator, APC or XCache; cannot use these for object caching.
 * 8) Found GNU diff3: /usr/bin/diff3.
 * 9) Found GD graphics library built-in, image thumbnailing will be enabled if you enable uploads.
 * 10) Installation directory: /var/www/mediawiki-1.15.1
 * 11) Script URI path:
 * 12) Installing MediaWiki with php file extensions
 * 13) Environment checked. You can install MediaWiki.

Generating configuration file...
 * 1) Database type: MySQL
 * 2) Loading class: DatabaseMysql
 * 3) Attempting to connect to database server as root...success.
 * 4) Connected to mysql 5.0.51a-3ubuntu5.4; enabling MySQL 4.1/5.0 charset mode
 * 5) Attempting to create database...
 * 6) Created database wikidb1
 * 7) Creating tables... done.
 * 8) Initializing statistics...
 * 9) Granting user permissions to wikiuser on wikidb1...success.

—192.44.77.39 07:11, 6 October 2009 (UTC)

Can't contact the database server

 * MediaWiki version: 1.15.1
 * PHP version: 5.2.4-2ubuntu5.7
 * MySQL version: 5.0.51a-3ubuntu5.4
 * URL: http://wiki.smartouch.fr/config/index.php

Hi,

I have this error :

'''Sorry! This site is experiencing technical difficulties.''' Try waiting a few minutes and reloading.

(Can't contact the database server: Unknown error (91.121.113.174:3306))

I'm sure the password and the ip are right.

Here the previous operations done :


 * 1) PHP 5.2.4-2ubuntu5.7 installed
 * 2) Found database drivers for: MySQL
 * 3) PHP server API is apache2handler; ok, using pretty URLs (index.php/Page_Title)
 * 4) Have XML / Latin1-UTF-8 conversion support.
 * 5) Session save path (/var/lib/php5) appears to be valid.
 * 6) PHP's memory_limit is 32M.
 * 7) Couldn't find Turck MMCache, eAccelerator, APC or XCache; cannot use these for object caching.
 * 8) Found GNU diff3: /usr/bin/diff3.
 * 9) Found GD graphics library built-in, image thumbnailing will be enabled if you enable uploads.
 * 10) Installation directory: /var/www/mediawiki-1.15.1
 * 11) Script URI path:
 * 12) Installing MediaWiki with php file extensions
 * 13) Environment checked. You can install MediaWiki.

Generating configuration file...
 * 1) Database type: MySQL
 * 2) Loading class: DatabaseMysql
 * 3) Attempting to connect to database server as root...success.
 * 4) Connected to mysql 5.0.51a-3ubuntu5.4; enabling MySQL 4.1/5.0 charset mode
 * 5) Attempting to create database...
 * 6) Created database wikidb1
 * 7) Creating tables... done.
 * 8) Initializing statistics...
 * 9) Granting user permissions to wikiuser on wikidb1...success.

—192.44.77.39 07:13, 6 October 2009 (UTC)

EDIT ; Problem is resolved !

The install was stopped here :

if ( $conf->Root ) { $conn = $dbc->newFromParams( $wgDBserver, $wgDBuser, $wgDBpassword, $wgDBname, 1 ); if ( $conn->isOpen ) { print "DB user account ok\n"; $conn->close; } else { print "Granting user permissions..."; if( $mysqlOldClient && $mysqlNewAuth ) { }     print "\n"; dbsource( "../maintenance/users.sql", $wgDatabase ); } }

I used a new user that would be created bu my root user. I change my options of the install by using the root user, now it works good.

backups just stopped working
hello. As of 10/6, the backups seemed to be working just fine. Then, all of a sudden backups seemed to just stop working. The site works fine and so does the web GUI, but the backups just will not run whether run manually or during the scheduled backup timeframe. This is what I get in the Appliance Log now.

Thu, 08 Oct 2009 12:47:49 EDT	Failed: A permanent failure has occurred: Shell command "tar -rpST /tmp/raa-backup-filesvrTwN6.lst --ignore-failed-read -f /tmp/raa-backup-ieepOi.tar" exited with exit code 2	Backup and Restore	Error

Any help I can get would be greatly appreciated. MediaWiki version: 2.0.3

--192.44.77.39 07:34, 6 October 2009 (UTC)

merging two different wikimedia databases

 * MediaWiki version: 1.14
 * PHP version: 5.1.6
 * MySQL version: 5.0.45
 * URL:

We have two different wikimedia systems on two different servers (both have the same versions for MediaWiki, PHP and MySQL) and now we want to merge them into a single wiki system on one of the server. The problem is, I can't just restore a dump file since both databases have the same ids for different pages and images, and with 870 uploaded images, the idea of manually editing the dump file doesn't seem so charming. Is there a way to merge both databases and somehow automatically change the ids? Or is the best way simply copying the pages from one wiki to the other and re-uploading the images?

—212.25.124.157 14:31, 22 October 2009 (UTC)