Project:Support desk/Sections/Database

From mediawiki.org
This page is no longer used.
Please ask questions on the new support desk.



MediaWiki Database Support

(Resolved) Wired Data after upgrading of Debian

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

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.

I had a the same error because I hadn't installed the php5 pgsql drivers so mediawiki couldn't connect to the postgres database containing the content.

Illegal mix of collations for operation after Upgrade

Latest comment: 9 years ago1 comment1 person in discussion
  • MediaWiki: 1.14.0 (upgrade from: 1.3.9)
  • PHP: 5.2.4 (apache2handler)
  • MySQL: 5.1.33-community
  • Url: test-machine @ home (Windows)

Live-Wiki (1.3.9) has charset=iso-8859-1 // (German)

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.
This page may point to a way out. Cheers --[[kgh]] (talk) 22:46, 27 February 2015 (UTC)Reply

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

I get something similar now, after at least a year of the Wiki working perfectly. Now no writes are possible:

from within function "Revision::insertOn": MySQL returned error "1048: Column 'old_id' cannot be null (..."

This is in MediaWiki 1.15 and PHP 5.2.5.

No changes to code or settings was made between functioning and non-functioning states. However, God knows what the hosting service has done to contribute to this.

Bob

I had this error after upgrading FreeBSD. MediaWiki in the FreeBSD Ports collection was an old version and the "upgrade" process had silently downgraded the system from MediaWiki 1.16 to MediWiki 1.14.

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 : 

#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,
 KEY `ArticleId` (`ArticleId`)
) ENGINE=MyISAM DEFAULT CHARSET=lat' at line 13

database content, wikitable wiki_category : 

#1033 - Incorrect information in file: './wikidb2/wiki_category.frm'

simple PHP query in wikisite, works only in preview mode, after saving I get an error!

  • MediaWiki version: MediaWiki 1.15.4
  • PHP version: ?
  • MySQL version: webserver Apache, MySQL-Client-Version: 5.0.45
  • URL: http://www.xtra1.ch/wiki


Hi, I'll try to make it short! I have installed 2 extensions for the wiki, the first one was: "PHPSecure" and the second one "StubManager" because I will use the <runphp> Tags in the wiki-site, wich is still a sandbox at the moment. After installation, I added this lines in the LocalSettings.php like in the descriptions: SecurePHP Extension:StubManager

require_once( "$IP/extensions/StubManager/StubManager.php" ); require_once( "$IP/extensions/SecurePHP/SecurePHP.php" ); $wgGroupPermissions['sysop']['bureaucrat']['coding'] = true;


So when I try to make a simple query,like: 

<runphp>
require_once "db_mo_con.php";

   
    $sql="SELECT Marke, Preis FROM cigars WHERE id = 1";
    $result=mysql_query($sql) or exit("Fehler im SQL-Kommando: $sql");
    echo "<table align=\"center\" border=\"1\"  style=\"border:thin\" >\n";
    while ($row=mysql_fetch_row($result))
    {
        echo "";
        foreach ($row as $item)
            echo "<td class=\"Daten_DB\">$item";
        echo "\n";
    }
    echo "\n";
</runphp>

then the query works, but only in the preview modus????? When I try to save the page it gives this error:

Es ist ein Datenbankfehler aufgetreten. Der Grund kann ein Programmierfehler sein. Die letzte Datenbankabfrage lautete, SQL-Abfrage versteckt aus der Funktion „MediaWikiBagOStuff::_doquery“. Die Datenbank meldete den Fehler „1146: Table 'usr_web433_1.test_objectcache' doesn't exist (localhost)“.

wiki tells me that the Table (usr_web433_1.test_....) doesn't exist. this is right, the table doesn't exist, but I didn't ask in the query for this table. And why the query works in preview mode??? Can somebody help me, I'm not a PHP crack, and I'm driving crazy, since 2 days.. it is very strange..

Many thanxs in advance for your Help

Retrieved from "https://www.mediawiki.org/w/index.php?title=Project:Support_desk/Sections/Database&oldid=5099727"