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)".

Empty database
MediaWiki 	1.15.1 PHP 	5.2.6-1+lenny8 (apache2handler) MySQL 	5.0.51a-24+lenny3

I try to stop apache and export the database at the same time.

I have this error message in my home page :

MediaWiki internal error.

Exception caught inside exception handler

in phpmyadmin, all datatable are present but empty.

in phpmyadmin, I have an error message [in french] : La connexion au "controluser" tel que défini dans votre configuration a échoué.

I try to import a dump I have that error message :

KEY `ArticleId` (`ArticleId`) ) ENGINE=MyISAM DEFAULT CHARSET=lat' at line 13
 * 1) 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'USING BTREE,

database content, wikitable wiki_category :


 * 1) 1033 - Incorrect information in file: './wikidb2/wiki_category.frm'

No text on page, no user account!

 * MediaWiki version: 1.13.2
 * PHP version:  5.2.13 (cgi-fcgi)
 * MySQL version:  5.0.89-userstats-log
 * URL: http://mountmoriah.info/

Website now reports "Login error: There is no user by the name "Jellings". Check your spelling." when trying to login.

Also, pages with known content now report "There is currently no text in this page, you can search for this page title in other pages or edit this page"

Here is a dump from logfile:

GET /index.php?title=Thomas_Jones_%28%3F-%3F%29 Main cache: FakeMemCachedClient Message cache: MediaWikiBagOStuff Parser cache: MediaWikiBagOStuff session_set_cookie_params: "0", "/", "", "", "1" Zend Optimizer detected; skipping debug_backtrace for safety. Unstubbing $wgUser on call of $wgUser->isAllowed from unknown Zend Optimizer detected; skipping debug_backtrace for safety. Unstubbing $wgMessageCache on call of $wgMessageCache->addMessages from unknown Zend Optimizer detected; skipping debug_backtrace for safety. Unstubbing $wgParser on call of $wgParser->setHook from unknown Zend Optimizer detected; skipping debug_backtrace for safety. Unstubbing $wgContLang on call of $wgContLang->getMagic from unknown MimeMagic::__construct: loading mime types from /home/jellings/wiki.mountmoriahcemetery.org/includes/mime.types MimeMagic::__construct: loading mime info from /home/jellings/wiki.mountmoriahcemetery.org/includes/mime.info Fully initialised Article: Thomas Jones (?-?) Connecting to db.mountmoriahcemetery.org mountmoriahwiki... IP: *.*.54.49 Connected Zend Optimizer detected; skipping debug_backtrace for safety. Unstubbing $wgOut on call of $wgOut->setSquidMaxage from unknown Language::loadLocalisation: got localisation for en from source Zend Optimizer detected; skipping debug_backtrace for safety. Unstubbing $wgLang on call of $wgLang->getCode from unknown Connecting to db.mountmoriahcemetery.org mountmoriahwiki... Connected MessageCache::load: Loading en... cache is empty, loading from database OutputPage::checkLastModified: CACHE DISABLED, NO TIMESTAMP Article::tryFileCache: not cacheable Article::view using parser cache: no Zend Optimizer detected; skipping debug_backtrace for safety. OutputPage::sendCacheControl: private caching; ** Request ended normally

It doesn't look like there is anything problematic in the logfile; I enabled PHP error reporting on the site and there were none.

I'd appreciate any advice.

—John.ellingsworth 16:01, 25 April 2010 (UTC)

Resolved

 * MediaWiki version: 1.15.3
 * PHP version: 5.0.5 (cgi)
 * MySQL version: 5.0.77mm0.1-log
 * URL: www.wilcommscan.com

I am having the same issue as above user (John Ellingsworth). No errors exist in Cpanel. Content still exists in database. Looks like mediawiki has lost access to db but using special:allpages I can view page titles. What gives? Anyone?

Resolution: via Cpanel, I checked the database. Lots of notices: [database].[table] error : Table upgrade required. Please do "REPAIR TABLE `[table]`" to fix it! Ran the required REPAIR TABLE on tables. Now my wiki loads beautifully!

Fraser.Wilkinson 05:57, 5 May 2010 (UTC)

—80.191.89.41 09:26, 3 May 2010 (UTC)

<! - IMPORTANTE: Preencha o "Assunto / cabeçalho" caixa acima. Em seguida, vá no seu wiki Special: Versão página e sua nota a informação de versão de software abaixo. -> <! - Agora, por favor informe o seu erro, ou pedir o seu apoio pergunta abaixo. (Você pode remover esta linha antes de salvar.) ->
 * Versão do MediaWiki:
 * Versão do PHP:
 * Versão do MySQL:
 * URL:

<! - O pouco que se seguem serão convertidos para uma assinatura com hora e data. (Você pode remover esta linha antes de salvar.) -> -

[Resolved] Database returned error "1: no such table: page"

 * MediaWiki version: 1.15.4 – 2010-05-28
 * PHP version: 5.2.6-1+lenny8
 * SQLite version: phpinfo says: 2.8.17
 * URL: https://f4bs.eu/

Please include all of the lines below when reporting installation problems. * PHP 5.2.6-1+lenny8 installed * Found database drivers for: SQLite * PHP server API is cgi-fcgi; using ugly URLs (index.php?title=Page_Title) * Have XML / Latin1-UTF-8 conversion support. * Session save path (/var/lib/php5) appears to be valid. * PHP's memory_limit is 128M. * APC installed * Found GNU diff3: /usr/bin/diff3. * Found ImageMagick: /usr/bin/convert; image thumbnailing will be enabled if you enable uploads. * Installation directory: /var/www/secure/1 * Script URI path: /1 * Installing MediaWiki with php file extensions * Environment checked. You can install MediaWiki. Generating configuration file... * Database type: SQLite * Loading class: DatabaseSqlite * Attempting to connect to SQLite database at "data"ok * Connected to sqlite 3.5.9 * Creating tables... done. * Initializing statistics...   * Created sysop account WikiSysop. Creating LocalSettings.php...     Installation successful! Move the config/LocalSettings.php file to the parent directory, then follow this link to your wiki.

When accessing https://f4bs.eu/ i get 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 "MessageCache::loadFromDB". Database returned error "1: no such table: page".

update: phpinfo says also:

pdo_sqlite PDO Driver for SQLite 3.x	enabled PECL Module version 	1.0.1 $Id: pdo_sqlite.c,v 1.10.2.6.2.3 2007/12/31 07:20:10 sebastian Exp $ SQLite Library 	3.5.9

—195.212.29.187 14:51, 3 June 2010 (UTC)
 * This is a bug in installer that has already been fixed in 1.16 branch. You need to move your databse file /var/www/secure/1/config/data/wikidb.sqlite to some directory not readable by web server and modify $wgSQLiteDataDir in LocalSettings.php to make it point to that directory. By the way, MediaWiki 1.16 that will be released soon will contain massive SQLite-related improvements, so upgrade is a must. Max Semenik 17:42, 3 June 2010 (UTC)
 * installed MediaWiki 1.16.0beta3 —195.212.29.187 11:18, 4 June 2010 (UTC)