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?

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 Syntax error - tables not available DONE

 * MediaWiki version: previously 1.11, upgraded now to 1.15.1
 * PHP version: 5.2.3
 * MySQL version: 5.0.27

I recently upgraded to MediaWiki 1.15.1. I face the following issue when I click on the 'history' tab or some other links on the page:

'' 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 "ChangeTags::listDefinedTags". MySQL returned error "1146: Table 'erwikidb.valid_tag' doesn't exist ''(localhost)".

and on other pages I get ''-	from within function "IndexPager::reallyDoQuery (LogPager)". MySQL returned error "1146: Table 'erwikidb.tag_summary' '' doesn't exist (localhost)".

and so forth..

When I checked the database I found that the tables valid_tag and tag_summary weren't created at all. I have run the installer again on my server for a fresh installation of 1.15.1 and have run the update.php script several times, but the same error keeps popping up.

SOLN - Sorry, the error was in my database administration. I had to create a new user with same privileges, or use the superuser account

—Srutsam 18:39, 6 November 2009 (UTC)

Database error - "MediaWikiBagOStuff::_doquery"

 * MediaWiki version: MediaWiki: 1.6.12
 * PHP version: PHP: 4.3.11 (cgi-fcgi)
 * MySQL version: MySQL: 4.1.14
 * Server: Yahoo
 * URL: http://www.zamboanga.com/z/index.php?title=Rawda_S._Mustafa
 * This error happened 11/09/09
 * URL: http://www.zamboanga.com/z/index.php?title=Neal_P._Gacrama
 * This error happened 11/10/09

This is the error message: Database error From Z-Wiki, your global connection to relevancy.

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 "MediaWikiBagOStuff::_doquery". MySQL returned error "1030: Got error 134 from storage engine (mysql)". Retrieved from "http://www.zamboanga.com/z/index.php?title=Rawda_S._Mustafa"

--Kuhitkuhit 18:31, 10 November 2009 (UTC)

The whole wiki is down

 * Now the whole Wiki is down. Over 40,000 pages can't be accessed.
 * Nobody can login.
 * This is the message we get no matter where anyone goes.

Database error From Z-Wiki, your global connection to relevancy.

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 "MediaWikiBagOStuff::_doquery". MySQL returned error "1016: Can't open file: 'mz_objectcache.MYI' (errno: 145) (mysql)". Retrieved from "http://zamboanga.com/z/index.php?title=Main_Page"
 * Your database seems to be damaged. Refer to MySQL documentation on how to correct it, or restore from backup. Max Semenik 07:19, 11 November 2009 (UTC)


 * I resolved the problem by repairing the database. However, I suspect that the upload failure of images is causing this database corruption. This file was uploaded and there is an error: http://www.zamboanga.com/z/index.php?title=Image:Bolong_zamboanga_city_fun_in_sun_01.jpg

I think the easy solution is to delete this. But I do not how to delete this since I can't access the page at all. So, How do I delete a page without accessing it?

search finds some but not all pages
My company has a MW installation that is working well for the most part. The only problem is that when searching, some words are not found in some articles that contain the word.
 * MediaWiki version: 1.13.2
 * PHP version: 5.2.6
 * MySQL version: 5.0.67-community-nt
 * URL: intranet only

For example, searching for "xRon" or "boxing" or "Montreal" finds a list of articles that contain the word, but there is at least one article that contains all 3 of these words and that article is not in the search results. However, searching for "coupons" or "incentives" or "staples" does include this article in the search results.

I have tried the following:
 * bypass MySQL's default stopword list and restarted MySQL.
 * run rebuildall.php.
 * run refreshLinks.php.
 * run rebuildtextindex.php.
 * use MySQL Administrator to repair the tables (only ldw_searchindex supported this action).

What else can I do to get these articles found?

—198.161.248.1 20:23, 16 November 2009 (UTC)


 * I found the solution. The article contained a less than sign ( < ), and later contained a greater than sign ( > ). MediaWiki thought this was a big HTML tag. The words between these 2 characters did not get indexed.
 * Temporary fix: Use a tag around the special characters.
 * Permanent fix: Upgrade MediaWiki to v1.15.1.

Can't access original database tables
MediaWiki 	1.15.1

PHP 	5.2.11 (apache)

MySQL 	4.1.22

I upgraded to 1.15.0 and more recently to 1.15.1.

I had to use the re-installation route as I don't have root access to the host.

My problem is that I can't see the original pages that had been written. When I use phpMyAdmin to look at the database the tables seem to have been renamed. E.g. there is a table called page, containing the new page, and another called mw_page that contains the original.

I guess that I made a mistake setting up the re-install and didn't put the prefix in. I have tried repeating the reinstall and putting the prefix in but still can't see the old pages.

Is there a way of changing the tables that the wiki uses?

Alternatively, can I rename the tables in the database or just duplicate the data?

thanks

Dan

—78.86.176.72 10:49, 27 November 2009 (UTC)


 * Edit LocalSettings.php and set . Then your wiki will use the original tables. Platonides 21:40, 29 November 2009 (UTC)

SQL error on Quercus

 * MediaWiki version: 1.14
 * PHP version: Quercus 4.0.2
 * MySQL version: 5.1.39
 * URL: local

After installation/configuration I try to edit main page and get:

INSERT INTO `qqqtext` (old_id,old_text,old_flags) VALUES (NULL,' \'\'\'MediaWiki has been successfully installed.\'\'\' \n\nConsult the User\'s Guide for information on using the wiki software.\n\nI was here!!!\n\n\n== Getting started ==\n* Configuration settings list\n* MediaWiki FAQ\n* MediaWiki release mailing list','utf-8') SQL ERROR: Column 'rev_user_text' cannot be null (localhost)

Is this a bug in Quercus, perhaps?

—84.215.65.208 19:00, 29 November 2009 (UTC)
 * Quercus is not officially supported. It may or may not work, but there were no reports of such bug under normal PHP. Max Semenik 17:48, 30 November 2009 (UTC)