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.

Problem with MSSQL connection

 * MediaWiki version: 1.14.0
 * PHP version: 5.2.9
 * MySQL version:
 * MSSQL version: SQL Server 2005 Express edition
 * URL:

I have a setup where on one system I have MSSQL server 2005 express edition and on another system I have the wiki in IIS 5.1 on Windows XP Pro SP2 system. I have run the mediawiki setup on that system and also got the LocalSettings.php file also. Now when I try to open the mediawiki site I get only a blank page.

I did some debugging and found out where the problem is coming. The problem is in WebStart.php file in the line of code where we load the LocalSettings.php file. "require_once("$IP/LocalSettings.php");" Till this line every debug statements are printed but anything after this line is not getting printed. Can you please let me know what could be the problem and is there any solution or workaround?


 * Sounds like you're hitting a non-resolvable error; check the error log for details and post them back here if that doesn't clear up the problem for you?

—59.163.223.130 10:37, 20 May 2009 (UTC)

Answer to Problem with MSSQL connection
SQL Name: MYSQL Username: WHAT EVERY YOU USE TO LOGIN TO MYSQL Password:WHAT EVERY YOU USE TO LOGIN TO MYSQL DB Name: Somthing like "Wike" Make shour it is the name when you install.

Articles are not shown in the right Namespace

 * MediaWiki version: 1.13.3
 * PHP version: 5.2.8
 * MySQL version: 5.1.30
 * URL: intranet

Some weeks ago, I defined some customized namespaces and everything worked fine. But now I have a problem: Let's say one namespace I recently defined is called "NewNamespace". Now I want to create a new article within this namespace, let's say "NewNamespace:HelloWorld". Then what happens is, that the new article is stored in the (Main) namespace with title "NewNamespace:HelloWorld", but not in the "NewNamespace". The strange thing about it is, that the articles which are already in the "NewNamespace" still work fine, so I don't think that it's a problem with the namespace definition. Can you help me? Do you have an explanation for this?

PS: I checked about a hundred times that I don't have any typing errors within the article's name, so this easiest explanation drops out as well PSS: A friend of mine just told me that he has the same problem (he uses MW 1.14)

—62.157.208.213 12:41, 3 July 2009 (UTC)


 * How did you go about "defin[ing] some customized namespaces"? What config variables have you set? Happy ‑ melon 13:39, 3 July 2009 (UTC)

(RESOLVED) Database Error, Not able to block IP addy

 * MediaWiki version: 1.14.0
 * PHP version: 5.2.5 (cgi-fcgi
 * MySQL version: 4.1.22-max-log
 * URL: http://innewscenter.net/wiki

When I tried to block an IP address/username, I got this message:

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 "Block::insert". MySQL returned error "1054: Unknown column 'ipb_allow_usertalk' in 'field list' (p41mysql169.secureserver.net)". Retrieved from "http://www.innewscenter.net/wiki/index.php?title=Special:Block"

—Nsgaeverine 11:43, 13 July 2009 (UTC)


 * Looks like you didn't run the update script, update.php. You can fix this issue either by running update.php (preferred) or manually applying /maintenance/archives/patch-ipb_allow_usertalk.sql against your wiki's database. --Jack Phoenix (Contact) 12:03, 13 July 2009 (UTC)


 * I just upgraded to MediaWiki version 1.15.0 and the symtom has been fixed. Nsgaeverine 04:57, 14 July 2009 (UTC)