Project:Support desk/Archives/Database/001

= 2008 =

(RESOLVED) Wiki Encoding Problem

 * MediaWiki: 1.11.0
 * PHP: 5.2.3 (cgi-fcgi)
 * MySQL: 5.0.37-community-nt
 * URL: http://wiki.myelectrical.com/

I have had a wiki up and running for a year or so without problems. Recently I have just moved to Dubai and when I first tried the wiki here I received the following error (on some pages only):

''Content Encoding Error (content_encoding_error) Server response could not be decoded using encoding type returned by server. This is typically caused by a Web Site presenting a content encoding header of one type, and then encoding the data differently. For assistance, contact your network support team.''

The wiki was fully functional before I arrived in Dubai (and may still be in other countries). After further investigation I found that the wiki is functional except for certain pages:


 * http://wiki.myelectrical.com
 * http://wiki.myelectrical.com/index.php
 * http://wiki.myelectrical.com/index.php?title=Special:Random
 * http://wiki.myelectrical.com/index.php?search=iec
 * etc.

Example working pages are:
 * http://wiki.myelectrical.com/index.php?title=Main_Page
 * http://wiki.myelectrical.com/index.php?title=Special:Recentchanges
 * http://wiki.myelectrical.com/index.php?title=CT_Dimensioning

... most article pages seem to be working

http://wiki.myelectrical.com/index.php?xx (where xx can be a lot of things)

etc.

I've tried quite a lot of things to resolve this without success. Any suggestions/help would be much appreciated.

—62.140.211.130 06:55, 6 February 2008 (UTC)


 * The non-working pages are now working. -PatPeter, [[Image:Tournesol.png|20px]] MediaWiki Support Team  21:09, 27 February 2008 (UTC)

Peter, the pages are only working in some countries (for example I know they are working in the US). I'm here in the UAE and they are still not working. It appears to be pages that redirect to other pages that do not work (wiki.myelectrical.com and special:random for example). Other mediawiki sites work here in the UAE and I have used the same notebook here and in the US (so firewalls/IE settings would not appear the be the problem).


 * Huh... didn't get that part ok. First of all could you sign your posts with ? My geography knowledge is... well... horrible, so does where ever you are use Latin characters in their language? -PatPeter, [[Image:Tournesol.png|20px]] MediaWiki Support Team  21:07, 28 February 2008 (UTC)

Peter, I'm quite new here in the UAE and I'm not sure if they use Latin or not. If you know of some testing I could carry out to see if things are affected by this please let me know., Steven  62.140.211.130 05:03, 3 March 2008 (UTC)


 * UAE? -PatPeter, [[Image:Tournesol.png|20px]] MediaWiki Support Team  04:43, 6 March 2008 (UTC)

UAE - United Arab Emirates. Anyhow for some strange reason things started working today. I've marked the issue as resolved and will remove the resolve if it happens again. 62.140.211.130

(OUTDATED) Sorting of category page

 * MediaWiki: 1.11.0
 * PHP: 5.1.4 (apache2handler)
 * MySQL: 5.0.21-community-nt

On a Category:XX page of my wiki I see page links grouped by first letter, that is OK, but groups themselves (letters) are arranged in random order (page names are non-english!), is it possible to alphabetize them?

—Konstbel 16:55, 7 February 2008 (UTC)


 * The order is imposed by the database, and the order is probably not "random", but byte-wise, instead of alphabetically. You may get better results when using the "experimental utf8" veriation of the database setup, instead of "compatibility mode". This is an option diring installation, i have no idea how to change it later. Also note that "experimental utf8" mode relies on mysql's own utf8 support, which is incomplete. It may work better than "compatibe" (binary) mode for your language, but as soon as you use a character from some ''very' odd language (like, for example, gothic), it will not work at all, producing a fatal error.
 * Sadly, I don't know a good way out of this dilemma, short of waiting for real unicode support in mysql. -- Duesentrieb ⇌ 10:09, 8 February 2008 (UTC)


 * I looked at wiki database, and noticed, that most varchar fields have utf8_bin comparison instead of utf8_general_ci. Is this the reason? I tried to change to utf8_general_ci, but without visible effect :-( --Konstbel 15:13, 12 February 2008 (UTC)


 * Is your Wiki set to the language that you are writing in? And can you give a URL? -PatPeter, [[Image:Tournesol.png|20px]] MediaWiki Support Team  23:29, 28 February 2008 (UTC)


 * Yes, the language is the same. Sorry, it is intranet wiki, without external access --89.175.73.253 12:41, 19 March 2008 (UTC)

(RESOLVED) Incorrect UTF-8 chars conversion

 * MediaWiki: 1.11.0
 * PHP: 5.1.4 (apache2handler)
 * MySQL: 5.0.21-community-nt

I suppose, that UTF-8 chars converted to lower/uppercase incorrectly. It makes a really HUGE problems in wiki: the search does not find what I'm looking for, the categories sorted incorrectly (see problem above), the Extension:SearchLog also displays incorrect characters (also see problem above).

Is it possible to fix that?

—Konstbel 10:12, 14 February 2008 (UTC)


 * Searching and sorting are done by the database, and per default, mediawiki tells mysql to treat all data as binary. The reason is that mysql's utf-8 support is broken for some "rare" scripts (those using 4-byte codes), like gothic. You can specify "experimental utf-8 mode" during installation, then unicode collation should apply correctly (but you will get database errors when you try to use "unsupported" characters). I don't know how this can be changed after the wiki has already been installed. I suppose you would have to change the charset/collations on all tables manually. -- Duesentrieb ⇌ 11:54, 14 February 2008 (UTC)


 * Do I need to convert only database or I need also some modifications in wiki code? --Konstbel 09:32, 15 February 2008 (UTC)


 * Have there been any updates on this? --Kimon 20:09, 6 August 2008 (UTC)
 * Never mind, I fixed it. Add the "$filteredText = $wgContLang->lc($filteredText);" line to the function parseQuery in SearchMySQL4.php:

--Kimon 20:47, 6 August 2008 (UTC)


 * Newbie question. Does a lack of using "experimental utf-8 mode" explain why some characters at wikipedia display fine but when used in mine it displays as the little boxes. For instance this reference ˈwɪkə which doesn't seem to convert here either. It certainly does at wikipedia though. --WilHatfield 21:29, 14 March 2008 (UTC)

(OUTDATED) Long String of Numbers after moving Wiki

 * MediaWiki: (Reported by your Wiki's Special:Version page)
 * PHP:
 * MySQL:
 * URL:

My company has an internal wiki which we use for internal standardization. We just recently moved the wiki from one box to a newer more up to date box. I did a SQL Dump of the database, recreated the username with all the permssions, copied the Wiki directory to the new box, everything seemed to go smoothly but then when I opened the main page in the content area there is a long string of number of letters. This is on every page. I have no idea where to trouble shoot on this. Any help would be greatly appreciated.

Steve,  mailto:sbarbera@newportharbor.com —24.249.29.209 14:33, 26 February 2008 (UTC)


 * You should post those strange string right here, maybe someone knows what it means ... letters or numbers or both??
 * And don't forget to complete those version lines above. --Detlef Lindenthal 20:40, 26 February 2008 (UTC)

(RESOLVED) Lost sysop access
OH CRAP!!!!! I was trying to figure out how to turn on uploads (still haven't figured that one out yet: documentation is not easily found on this site) and I accidentally killed my bureaucrat privileges on the Userrights Page. Poof! How do I restore them???? No one else is a Bureaucrat and I can't find anything on this site to help me fix this.
 * MediaWiki: 1.10.1
 * PHP: 5.1.4
 * MySQL: 4.1.22
 * URL: I'm too embarrassed to release this!

I'm just starting to learn the ins and now especially the outs of PHP and SQL...is there a way of fixing this in MySQL? or in one of the myriad of PHP files?

Thanks! —Keng 23:45, 10 March 2008 (UTC)
 * You'll need to update the database directly with the following query. First login and go to Special:Preferences to get your user id number (I've used 999 in the example below, so replace that with your own user id), then shell in to your server or do a query with whatever means you have of accessing your database. Also note that if you're using a table prefix you'll need to prepend that to the user_groups table name.

INSERT INTO user_groups (ug_user,ug_group) VALUES(999,'sysop');
 * --Nad 02:18, 13 March 2008 (UTC)
 * Also regarding uploads, you need to set $wgEnableUploads to true in your LocalSettings.php. There are also a number of other settings relating to uploads, see Category:Upload variables. --Nad 02:27, 13 March 2008 (UTC)

(RESOLVED) Rename user using SQL

 * MediaWiki: 1.7.1
 * PHP: 5.2.0-8+etch10 (apache2handler)
 * MySQL: 5.0.32-Debian_7etch5-log
 * URL: RISE

I renamed a user using the SQL instructions in MediaWiki FAQ (See But can I rename the user, then?). But MySQL complains: ERROR 1146 (42S02) at line 3: Table 'mediawiki.cur' doesn't exist (mediawiki is the name of the database). Kindly help.

—203.199.213.130 09:37, 13 March 2008 (UTC)
 * Why not use Extension:Renameuser? Aaron 11:51, 28 March 2008 (UTC)

(OUTDATED) Promote user MySQL statement update
For MediaWiki version 1.9.3 the mysql command to promote a user to a sysop is incorrect. INSERT INTO user_group SET ug_id = youruserid, ug_group = "sysop" the table is now 'user_groups' and the ug_id field has changed to ug_user, hence the correct command would be: INSERT INTO user_groups SET ug_user = , ug_group = "sysop"

Also, you would probably want to do a select user_id, user_name from user; first, so you can find the correct user_id value
 * Thanks! Interestingly enough, that SQL must have been wrong since the beginning, because I don't see any changes that were done to that table... Titoxd (?!?) 04:40, 17 March 2007 (UTC)

(RESOLVED) Reading passwords of users

 * MediaWiki: 1.12.0
 * PHP: 5
 * MySQL: 4.1
 * URL: www.wikilh.tk

Hi. I have question. How I can read the password of my users? I dont want to change them, but i need to read them. I need fast answer. Thank you.

drake

—83.26.71.3 20:21, 23 March 2008 (UTC)
 * You can't. —Emufarmers(T 21:54, 23 March 2008 (UTC)
 * I don't know the answer, but I must assume that since they are stored somewhere in the database, there must be some way to read them, even if it requires some decryption. Smaug 00:33, 24 March 2008 (UTC)
 * MediaWiki salts its MD5-hashed passwords, which, as far as I know, makes decryption impractical, if not impossible.


 * The only sort of counsel that I'll offer is that this is not ethical, and you're wasting your time anyway. —Emufarmers(T 05:49, 24 March 2008 (UTC)

(OUTDATED) Pagetitle Encoding Problems (Chinese) after Move & Upgrade of MediaWiki

 * MediaWiki: 1.12.0
 * PHP: 5.2.4 (cgi)
 * MySQL: 4.1.13
 * URL: Rock in China Wiki

Hi, I upgraded MediaWiki and moved Servers from to the one mentioned above.
 * MediaWiki: 1.6.8
 * PHP: 4.3.10-22 (cgi-fcgi)
 * MySQL: 4.1.11-Debian_4sarge7-log
 * URL: http://web125.burns.kundenserver42.de/rockinchina/wiki/

I exported the complete database via phpMyAdmin 2.11.0-rc1 on the old server and imported it via mysql command line. Settings for collation on database and tables seem to be the same. Files have been moved completely and then upgraded to the new version.

The problem now is that pages with Chinese titles are broken. An example can be seen here:
 * Old/Good: http://web125.burns.kundenserver42.de/rockinchina/wiki/index.php?title=Badhead_3_%E8%8A%B1%E5%9B%AD%E6%9D%91_%28VA%29
 * New/Broken: http://wiki.rockinchina.com/index.php?title=Badhead_3_%C3%A8%C5%A0%C2%B1%C3%A5%E2%80%BA%C2%AD%C3%A6%3F%E2%80%98_%28VA%29

The pages show up wrong in category lists and links to these pages are broken.

Any pointers on this problem would be highly appreciated.

Thank you very much!

—Matsch 22:49, 25 March 2008 (UTC)

(RESOLVED) Delete history
Hello! Is there a way to delete the history of an article in my wiki? So often I change an article so longer will be the list of the versions. Isn't it space on my disc, if there are so many versions to an article in my wiki? So I want to delete the history time to time, but how? Thank you for your replies, Doc Taxon 17:22, 27 March 2008 (UTC)
 * Are you using compression? Aaron 11:50, 28 March 2008 (UTC)
 * I do not know, whether I am using compression. How can I find out? Doc Taxon 15:01, 28 March 2008 (UTC)

There are php scripts you can use to delete the whole history of old revisions for the entire database. Log in as root and follow these steps: 1) Change into your mediawiki directory on your server.  2) Now you can see a directory named "maintenance". Change into this directory. 3) use the command : php deleteOldRevisions.php --delete  4) If it works, you're done. There is only one version of every page left now. If it does not work, you have not specified the necessary database access in the file AdminSettings.php If you don't even have this file, make a copy of AdminSettings.sample and change admin name and password. Go back to 3)

(OUTDATED) Does mediawiki work if I change table InnoDB to MyIsam ?

 * MediaWiki: 1.9.3
 * PHP: 5.2.5 (cgi)
 * MySQL: 5.0.45-log
 * URL: http://aspic-dti.ovh.org/index.php?title=Accueil

Hello,

To save sql space, I have passed all InnoDB sql tables in MyIsam type.

Will there be some problems or will it just be a more bit slower ?

Best Regards —Aspic 22:28, 31 March 2008 (UTC)

(OUTDATED) Identifying the Name of the Namespace from the ID in the Page table
Where is the name of the namespace stored in the database tables? Want to utilize the namespace feature to origanize user information. --31 March 2008

(OUTDATED) DB Error

 * MediaWiki: 1.12.0.
 * PHP:
 * MySQL: 5.0.33-log
 * URL:

Hi

i need help. i have configured wiki and than this :(

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 "Article::pageData". MySQL returned error "1267: Illegal mix of collations (latin2_bin,IMPLICIT)     and (latin1_swedish_ci,COERCIBLE) for operation '=' (db2.clevernet.cz)".

Could anyone help me what can i do with this?

Sari —85.160.33.115 19:03, 4 April 2008 (UTC)

(OUTDATED) Wikipedia
I've downloaded from wikipedia the database. And there i didn't find any explications about how can i integrate the database into my wiki website. The database is in XML format. Please tell me how can i import that database into my wiki site.

Thank you! —79.119.149.93 16:04, 6 April 2008 (UTC)

(RESOLVED) NDB Cluster issue during installation

 * MediaWiki: 1.11.2
 * PHP: 5.25
 * MySQL: 5.1.23
 * URL: http://lab-lamp.ssd.loral.com

* PHP 5.2.5 installed * Found database drivers for: MySQL * PHP server API is apache2handler; ok, using pretty URLs (index.php/Page_Title) * Have XML / Latin1-UTF-8 conversion support. * Warning: A value for session.save_path has not been set in PHP.ini. If the default value causes problems with saving session data, set it to a valid path which is read/write/execute for the user your web server is running under. * PHP's memory_limit is 128M. * Couldn't find Turck MMCache, eAccelerator, APC or XCache; cannot use these for object caching. * Found GNU diff3: /usr/bin/diff3. * Couldn't find GD library or ImageMagick; image thumbnailing disabled. * Installation directory: /mnt/www/apache/html/MediaWiki * Script URI path: * 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 wikIT...success. * Connected to 5.1.23-rc * Database wikidb exists * There are already MediaWiki tables in this database. Checking if updates are needed...   * Warning: you requested the InnoDB storage engine, but the existing database uses the ndbcluster engine. This upgrade script can't convert it, so it will remain ndbcluster.

...hitcounter table already exists. Creating querycache table...ok Creating objectcache table...ok ...categorylinks table already exists. Creating logging table...ok ...user_newtalk table already exists. ...transcache table already exists. ...trackbacks table already exists. Creating externallinks table...Query "CREATE TABLE `externallinks` ( el_from int(8) unsigned NOT NULL default '0', el_to blob NOT NULL, el_index blob NOT NULL, KEY (el_from, el_to(40)), KEY (el_to(60), el_from), KEY (el_index(60)) ) TYPE=ndbcluster " failed with error code "BLOB column 'el_to' can't be used in key specification with the used table type (lab-mysql)--> —158.184.23.102 19:48, 9 April 2008 (UTC)


 * In the MySQL Cluster Documentation they explicitly state:

Indexes and keys in NDB tables. Keys and indexes on MySQL Cluster tables are subject to the following limitations: TEXT and BLOB columns. You cannot create indexes on NDB table columns that use any of the TEXT or BLOB data types.
 * So it seems like this simply does not work on NDBCLUSTER engines ... alas
 * —dec 16:00, 18 July 2008 (CET)

(OUTDATED) active/active mysql setup

 * MediaWiki: (Reported by your Wiki's Special:Version page)
 * PHP: NA
 * MySQL: NA
 * URL: NA

I was debating how to go about setting up a MediaWiki farm. Does mediawiki work with/ or support an active/active mysql setup?

Thank you for your time, Danko —63.115.78.28 10:56, 11 April 2008 (UTC)

(OUTDATED) Wiki site launch preperation

 * MediaWiki: 1.12
 * PHP: 5.x
 * MySQL: 5.x

What should be done to prepare a wiki (in development) for release? I can think of removing old revision (with deleteOldRevisions.php) and permanently removing the history of deleted pages.

DELETE FROM archive;

But is there more needed? For example, how can the hit counters be cleared? Like maybe flush caches, or something? Clearing the log?

—Rebbyte 09:46, 18 April 2008 (UTC)

(RESOLVED) Failed move of Mediawiki between servers

 * MediaWiki: 1.6.5
 * PHP: 5.2.5
 * MySQL: 5.0.51a
 * URL: intranet

My moved mediawiki gives a blank screen on entering utf-8 (Chinese multibyte characters) in the text of a page. (On preview or save).

My log of the procedure is as follows.

Failing to move a wiki to another server:

hope this is a frequently asked question: I have been asked to move a small wikimedu maybe 100 - 200  pages  from Solaris to Linux it seems ok except for multibyte character entry, what am I missing? I have tried creating the mysql database in utf8 and default (latin1) format what should I do next?

Some older utf8 entries suggest that collation could be important. The actual error is browser screen goes white on Chinese multibyte character preview and save.

I tried strace on httpd and mysqld but there was no obvious smoking gun i.e. no obvious error returning code. I suppose there could be different php modules - but I would expect Linux to have more php options than sun not less.

Here is a rough log of what I tried so far:

Resources: http://www.mediawiki.org/wiki/Manual:Moving_a_wiki http://www.mediawiki.org/wiki/Manual:Backing_up_a_wiki http://kb.mediatemple.net/article.php?id=138 mediawiki mailing list search on utf8

The procedure is get a dump of the database: /usr/bin/nice -n 19 /usr/bin/mysqldump -u $USER -p$PASSWORD --default-character-set= $CHARSET $DATABASE -c > mydumpout.sql

[Tried with and without --default-charset]

backup all the mediawiki or wiki folder.

cp -Rp mediawiki ~username/tmp cd ~username/tmp zip -r mediawiki.zip mediawiki

cp the files to the destination machine.

unzip the mediawiki.zip alter the database login

create the database in the destination machine add the user

mysql> create database wikifinal default character set utf8 [tried with and without utf8] mysql> grant all privileges on wikifinal.* to wikiuser2@localhost identified by ' ' with grant option;

build the tables /opt/lampp/bin/mysql -u wikiuser2 -p wikifinal < dumpoutnonlatinalt.sql Enter password:

a few TYPE=InnoDB DEFAULT CHARSET=utf8; on "Specified key was too long; max key length is 1000 bytes" with utf8 errors since I am putting utf8 everywhere x2; dubious workaround on those two table switch to latin1 TYPE=InnoDB DEFAULT CHARSET=latin1;

stop apache link the media wiki to the same link as before in this case wiki make the images directory and sub directories writable. start apache

Tests: Viewing wikipedia contents:Pass uploaded an image:Pass editing with multibye content.FAIL

Multibyte edits fail could well be a symptom of something else, like trying to copy mediawiki with little in depth mediawiki knowledge.

Source and destination mediawiki versions 1.6.5 source mysql version 4.0.27-standard destination mysql version  5.0.51a Source OS Solaris, destination Linux and xampp

Addendum Apr24 21:00 Dublin Time.

Just tried to put in all the collations and sort order by hand- to no real benefit. Funny though I have a Chinese names page and I can view it, but previewing or posting with Chinese text results in a blank screen. There are some SSL warnings - I am assuming that would be a red herring to follow.

Addendum 19 May 2008


 * 1) I created a new wiki
 * 2) I exported/imported the 240 wiki pages using XML there is a script for doing this in the maintenance directory.
 * 3) I then copied over ther 20 or so images by hand.
 * 4) About 20 people had to re register but that was not a big issue.
 * 5) Added a few redirects to apache so the mediawiki was redirected to from the other server and mediawiki was the home page.

Worked for me your mileage may vary.

—193.32.3.83 11:05, 24 April 2008 (UTC)

(OUTDATED) Creating a MediaWiki mirror
Hey. I wasent sure were to post this as its not really an error but a question of functionality.

Are there any known or premade ways to create a MediaWiki mirror.

We want to create 3 separate Wiki's which mirror each others content, every update, every edit should instantly be mirrored.

Thanks —213.113.166.32 20:53, 28 April 2008 (UTC)

(RESOLVED) Database Error

 * MediaWiki: 1.10.1
 * PHP: 5.1.6 (apache2handler)
 * MySQL: 5.0.22
 * URL: http://redbookswiki.tap.ibm.com (note this is not accessible from the internet - it is an intranet only accessible wiki running within the IBM intranet. Including the URL just to be complete w/this post...)

Problem

Loading http://redbookswiki.tap.ibm.com/index.php/Special:Popularpages generates a database error:

This error roughly coincides with the timing of installation and first use of the DPL extension. This is the only page that generates this database error (that we've found so far). I'm including the Extensions and Hooks section of the version page output for the wiki (HTML paste) below my sig.

Thanks in advance for any help on this! - Chris -Calmo 17:36, 7 May 2008 (UTC)

Extensions (from affected server Version page) Hooks (from affected server Version page) —Calmo 17:36, 7 May 2008 (UTC)

We have exactly the same error! --Danielp 07:37, 19 May 2008 (UTC)
 * MediaWiki 	1.12.0
 * PHP 	5.2.6 (apache2handler)
 * MySQL 	5.0.32-Debian_7etch5-log


 * We had a similar error on Fan History after upgrading from 1.10 to 1.12. The problem was resolved when we upgraded our php version to 5.2.6.  For DPL, you might also want to post the request here as they've been helpful. --PurplePopple 03:30, 18 June 2008 (UTC)

And us! "MySQL returned error "1146: Table 'textadventure.gameswiki_page_props' doesn't exist"
 * MediaWiki: 1.13.0
 * PHP: 5.2.6 (cgi-fcgi)
 * MySQL: 5.0.67-log
 * URL: textadventure.org.uk

Help! O please help great support desk people!

Today at 2pm one of our team went to http://textadventure.org.uk/index.php?title=Spaceship:Canteen and several other pages and discovered this very ugly message: "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 "OutputPage::addCategoryLinks". MySQL returned error "1146: Table 'textadventure.gameswiki_page_props' doesn't exist (mysql.textadventure.org.uk)"." The last time this page was checked previously was approximately 1 week ago

We have been inundated with spam and the same message comes up when I try to block any of the hundreds of new anonymous IP addresses that have appeared on my site in the recent changes page.

The community portal has been modified with external links and when I try to edit it, I get the same thing.

I DON'T KNOW WHAT TO DO

I thought I had been made an admin by the person who originally set this page up. we're currently trying to track him down.

We'd clearly like to set up a spam filter, but are unable to do this because of these errors, and more spam is coming in by the bucketload by the second.

Any help to stop this flow and to explain the database error is greatly GREATLY appreciated. And if you could even find where the missing content went, I'll buy you dinner.

Many many thanks,

Aleks (akrotoski +at+ yahoo+dot+com) —Aleksk 17:07, 2 September 2008 (UTC)


 * It looks like somebody updated the wiki to 1.13.0 but forgot to run update.php.


 * You can set up a CAPTCHA or use $wgSpamRegex to block the bots; as a stopgap measure, just restrict editing to sysops. —Emufarmers(T 03:47, 3 September 2008 (UTC)


 * Many many thanks! This sorted it out. --Aleksk 09:19, 4 September 2008 (UTC)

(OUTDATED) Extracting wiki text as plain text from MySQL database

 * MediaWiki: ??? that's part of my problem
 * PHP: 5.2.5
 * MySQL: 4.1.12
 * URL: internal

Hi, I've backed up my Wiki install but stupidly have got only the partial filesystem, but all of the database. I can't work out what version of Wiki I had, and I can't figure out how to extract the content out so I can rebuild into a new wiki by hand.

Does anybody know how to extract the BLOB's from the text table as plain text so i can rebuild my wiki?

Thanks in advance, Jase. —150.101.163.28 22:30, 16 May 2008 (UTC)

(RESOLVED) "DB connection error" when trying to run the maintenance script "rebuildall.php" (using PostgreSQL)

 * MediaWiki: 1.12.0
 * PHP: 5.2.0-8+etch11 (apache2handler)
 * PostgreSQL: PostgreSQL 8.1.11 on i486-pc-linux-gnu, compiled by GCC cc (GCC) 4.1.2 20061115 (prerelease) (Debian 4.1.1-21)
 * URL: david.theparticulars.org/wiki/

I used the mediawiki for e few weeks right now and everything worked okay. Now I wanted to try to use a maintenance script for the first time - so I insertet into the AdminSettings.php the same username and password for the PostgreSQL-Server as in the LocalSettings.php. With exactly this username and password, I can log in on the PostgreSQL-Server from the shell (using the command-line tool psql...). But when I run the script rebuildall.php, it keeps saying: "DB connection error: Access denied for user '(...)'@'localhost' (using password: YES) (localhost)". Even with a newly created superuser for PostgreSQL, with which I can log in from the shell and who's data I inserted into the AdminSettings.php, it does not work. Do you have any suggestions? Thanks you.

—Shape 13:02, 28 May 2008 (UTC)


 * I have updatet to a newer Verion from svn - this error doesn't occur no more. --Shape 21:35, 3 June 2008 (UTC)

(OUTDATED) error message when running configure wiki - Could not find a suitable database driver
I am getting this error when running the config page for the wiki, I have both PHP and MSQL installed with a user created.

* PHP 5.2.3 installed Could not find a suitable database driver! o For MySQL, compile PHP using --with-mysql, or install the mysql.so module o For PostgreSQL, compile PHP using --with-pgsql, or install the pgsql.so module

—Groedel99 16:40, 6 June 2008 (UTC)

(OUTDATED) Interwiki SQL error
I installed the latest version successfully on my localhost wiki, for testing. However, interwiki links do not work from the interwiki-sql file. This is the error message I get: SQL query:
 * MediaWiki: 1.13alpha trunk version
 * PHP: 5
 * MySQL:
 * URL:

( 'zh', 'http://zh.wikipedia.org/wiki/$1', 1 ), ( 'zh-cfr', 'http://zh-min-nan.wikipedia.org/wiki/$1', 1 ), ( 'zh-classical', 'http://zh-classical.wikipedia.org/wiki/$1', 1 ), ( 'zh-cn', 'http://zh.wikipedia.org/wiki/$1', 1 ), ( 'zh-min-nan', 'http://zh-min-nan.wikipedia.org/wiki/$1', 1 ), ( 'zh-tw', 'http://zh.wikipedia.org/wiki/$1', 1 ), ( 'zh-yue', 'http://zh-yue.wikipedia.org/wiki/$1', 1 ), ( 'zu', 'http://zu.wikipedia.org/wiki/$1', 1 ),

MySQL said: Documentation ('zh-cfr','http://zh-min-nan.wikiped' at line 1
 * 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 ''zh','http://zh.wikipedia.org/wiki/$1',1),

I did this via phpMyAdmin, since it is hard for me to use maintenance scripts with XAMPP (the platform I am hosting this on!) If anyone can help me, it's much appreciated!! Thanks, AP aka —Sunstar 18:52, 8 June 2008 (UTC)

(RESOLVED) Can't get past the "Could not find a suitable database driver!" message.

 * MediaWiki: (Reported by your Wiki's MediaWiki 1.12.0 Installation page)
 * PHP: 5.2.6
 * MySQL: 5.0
 * URL: http://localhost/mediawiki-1.12.0/config/index.php

This is what I get - it's our old facourite:
 * PHP 5.2.6 installed Could not find a suitable database driver!
 * For MySQL, compile PHP using --with-mysql, or install the mysql.so module
 * For PostgreSQL, compile PHP using --with-pgsql, or install the pgsql.so module

Bear with me, I'm a newbie at wiki work.

I'm trying to install MediaWiki onto a Vista PC. (I know I ought to be using Linux but there have been problems - another long story.)

I installed MySQL some time ago into C:\Program Files\MySQL\MySQL Server 5.0 and I have been using it fairly successfully with Java apps developed in Eclipse, so I'm fairly sure that's all right. Yes, it is configured as "root" and uses port 3306, as it should.

I had bad experiences with various Wamp packages, mainly because there were problems with the MySQL installation. XAMPP was worst. So I decided to go with the manual downloads.

Apache 2.2.9 is installed in C:\Program Files\Apache Software Foundation\Apache2.2 and configured to work on port 80.

PHP is installed in C:\PHP\php-5.2.6-Win32 and it has been configured as per the instructions.

I have ensured that all DLLs are in the \ext directory of the PHP installation.

I have added ";C:\PHP\php-5.2.6-Win32" to my path file and made sure it occurs BEFORE the one for MySQL (I'm up to speed on environment variables, I use this technique all the time in the day job). The point about it being before the MySQL entry is in response to something I read on another help page.

I have made sure that the php_mysql.dll and php_mysqli.dll entries are uncommented out of the php.ini file so as to enable them.

I have made sure that the line extension_dir="C:\PHP\php-5.6.2-Win32\ext" is in the php.ini file.

I have copied the libmysql.dll, php_mysql.dll and php_mysqli.dll files have been copied into the Apache2.2\bin directory (again in response to a comment on a help forum).

PHP works, I've tested that. Apache works (eventually), I tested that. (If they didn't I wouldn't have got this far.)

I've scoured all the help forums I can find and applied all the solutions I've been offered, but I still get the pesky page:

MediaWiki 1.12.0 Installation

Don't forget security updates! Keep an eye on the low-traffic release announcements mailing list.

Checking environment...

Please include all of the lines below when reporting installation problems.


 * PHP 5.2.6 installed Could not find a suitable database driver!
 * For MySQL, compile PHP using --with-mysql, or install the mysql.so module
 * For PostgreSQL, compile PHP using --with-pgsql, or install the pgsql.so module


 * SORTED IT ...
 * It was me being silly. Although I'd put my PHP stuff into C:\PHP\php-5.2.6-Win32, in the php.ini I was actually invoking the extension directory as C:\PHP\php-5.6.2-Win32.
 * I found this by finding and checking the Apache error log. I also found I was invoking a dll that it couldn't invoke (which I didn't need) so I got rid of that and now I'm up and running.
 * Apologies for bothering you, but might be worth leaving this post up in case someone else gets the same trouble.
 * —82.3.223.23 14:38, 14 July 2008 (UTC)

(OUTDATED) backuped version shows all articles as ???????
Hi! I have prblem by custom backup of my Wiki DB. On both server I have default-character-set UTF8. Everything is in UTF-8 and the data into the backuped database is UTF-8 too. But the backuped version of the wiki shows all articles like this ??????? and could find anything on the main page. The data into the tables are the same like the original wiki. What can I do?

How can I solve this problem?

Regards Nik —62.143.184.50 07:38, 18 July 2008 (UTC)

(OUTDATED) Put data into MediaWiki with SQL-Dump

 * MediaWiki: 1.12.0
 * PHP: 5.2.5
 * MySQL: 5.0.51a
 * URL: its local

I wanted to ask, if it is possible to move data into MediaWiki with using SQL-Dumps.

I have tonnes of Text & Pictures/MediaFiles I need to insert into MediaWiki. So I've created a small Tool, which converts the text into the MediaWiki format with its StyleTags for Title and so on. But now, I need to create a SQL-Dump (Not direct to Databese, first I have to make a dump) to insert the Data into the Database. Problem is, I don't get it by looking trough the MediaWiki Database.

I dont know on which Tables I must do my Inserts for it. I was looking around, but I didn't find any example. So I would be glad, if someone can help.

—193.26.130.189 09:29, 25 July 2008 (UTC)

(OUTDATED) Searchindex always crashing

 * MediaWiki: 1.12.0
 * PHP: 5.2.5
 * MySQL: 5.0.51a-log

Hello everybody,

i am new here, but i've got an big issue. My wiki is showing me this failure:

"SearchMySQL4::update". MySQL returned error "145: Table './wikidb/searchindex' is marked as crashed and should be repaired (localhost)"

And i tried to repair it, and the repair function of mysql don't help. It seems that mediawiki is crashing the searchindex again and again?

My configuration: Server; Mac OS X Server Leopard Environment: Xampp for Mac OS X 0.7.2 (Apache, MySQL 5.0.51a-log, Phpmyadmin 2.11.4)

The failure: I am configurating the wiki. (/config/...) After that, i am moving the LocalSettings.php to the right place. Then i am opening the Wiki Website. I am changing something on the Wiki, adding some text. -> OK First time: everyting ok. No failure. When i then editing the Wiki again, and saving then ->

SearchMySQL4::update "145: Table './wikidb/searchindex' is marked as crashed and should be repairded (localhost)".

(i installed mediawiki and the mysql database two times now..)

Try to repair: Phpmyadmin - check table "Table is marked as crashed - Can't read key from filepos:0 - Incorrect key file for table './wikidb/searchindex.MYI'; try to repair it. - Corrupt Phpmyadmin - repair table 'searchindex' repair - status - ok then i check again with Phpmyadmin - check table: "Table is marked as crashed - Can't read key from filepos:0 - Incorrect key file for table './wikidb/searchindex.MYI'; try to repair it. - Corrupt

I also tried it on mysql commandline and with "myisamchk -r /path/to/the/table"

like described in: http://www.karakas-online.de/EN-Book...upt-table.html

But i cant repair it! It is a real shit. Because i wanted to put data into the Wiki, and work on it all the time. And now i am just reading thrue google "try -repair table '$tablename'".

Does someone have any knowledge about this problem? And how to fix it?

Best regards,

eibi —213.3.36.247 14:15, 30 July 2008 (UTC)

(OUTDATED) delete old revisions

 * MediaWiki: 1.13.0rc1
 * PHP: 	5.2.6
 * MySQL: 5.0.51a
 * URL:

Hello,

I use a MediaWiki as private CMS. For saving webspace, I want to delete the old revisions.

The problems:
 * I have no shell access
 * phpShell wont work on my webspace, because clamav claims, phpshell is a virus an deletes it immediately
 * Extension:SpecialDeleteOldRevisions doesn't work since 1.12. Well, I could copy the missing htmlform.php from an older MediaWiki version, but I still don't know if Extension:SpecialDeleteOldRevisions will mess up my database due to changes since 1.9.

Is there a way to use the maintenance scripts without shell access, or can I use Extension:SpecialDeleteOldRevisions without danger, or are there other ways to delete old revisions?

Regards, —Tuwan 20:43, 30 July 2008 (UTC)

(OUTDATED) SQL Database and Media-Wiki Issue (Is there a way to restore the database or pages to a specific date and time if the database was copied over)

 * MediaWiki: ?
 * PHP: PHP5, PHP6
 * MySQL: Appserv SQL Database
 * URL: [http://69.21.97.17/Dictionary/index.php Aoiro Joukai Dictionary

Database/Media-wiki issue:

I was working on my wiki the other day and I noticed that there were two pages that were mysteriously missing. I do not work with sql much and I just started somewhat working on media wiki for my site, so after trying to find the pages I ended up copying the database over from an earlier version to see if I could recover them.

I knew that more or less I was pushing back pages that were not updated, but I was sort of suprised that it wiped out 3 pages that I had worked on just that day. I was wondering if there was any way to restore those pages in the database or if there was somehow an area that would list those three pages for me to simply restore. I know that there is a restore feature on media wiki but I am not sure how to use it.

I was not sure if just by copying the older database over to what I had now if the pages were simply, and completely, removed that were not there previously? Or if they are simply hiding since the old version did not have those 3 pages whatsoever. Everything else is up to date, its just that I cannot find those three particular pages anymore.

If there is a way to restore the database then that would be great, I am not sure if there is a way to do this but I would love it if anyone did know how to solve the issue was able to tell me how to get back the pages from the past 24 hours. Is there a dump file or something that holds that information?

—69.21.97.170 06:47, 5 August 2008 (UTC)

(RESOLVED) share table user for multiwikis

 * MediaWiki: 1.11.0
 * PHP: version 5
 * MySQL: version 4

hi

i am working with mediawiki-1.11.0 i am working with multiples wikis using same database, same souce code, same host and i use tables prefixes to identify which tables belong to each wiki.

how i can do for share all users on each wiki created?

thanks --200.77.227.68 21:28, 8 August 2008 (UTC)


 * I would recommand updating to 1.13 as this version has better support for shared tables. Then see Manual:$wgSharedDB, Manual:$wgSharedPrefix and Manual:$wgSharedTables. i Alex  21:45, 16 August 2008 (UTC)

(OUTDATED) "Something's not quite right yet; make sure everything below is filled out correctly."

 * MediaWiki: 1.11.0
 * PHP: 5.2.6
 * MySQL: 5.0.51b
 * URL:

Hi. I get this error after hitting submit on the installation: Something's not quite right yet; make sure everything below is filled out correctly. It is reffering to my SQL details, that re correct, and I have re-entered them 14 times, and asked 2 other people to do it for me tocheck i'm not being a fool. If someone could help me sort this problem it would be great.

Chris christopher.phillip.king@googlemail.com —91.111.20.170 14:43, 11 August 2008 (UTC)

(OUTDATED) "Read database pages text - Wrong correspondency of text in the db with the one in the wiki"
Hello,

I can't find my the actual pages text in the database, i find but it isn't the actual version but an old version or not correct one. I correspond the last rev_text_id (of a page) in the table_revision with the table_text old_id but the text isn't the actual one (it's an old or a completely different). Did i made something wrong? Did i miss something? What can i do? I need to acces the pages actual text (all revisions if possible).

António antonioavf@gmail.com —213.138.228.242 23:54, 16 August 2008 (UTC)

(RESOLVED) mysql database error 1146

 * MediaWiki: 1.12.0
 * PHP: 5.2.6
 * MySQL: 5.0.45
 * URL: http://csdms.colorado.edu

Hi all, I just did a wiki upgrade 1.11.0 -> 1.12.0, all according to the upgrade help page. The upgrade went pretty smooth but I'm facing some errors now. When I try to create any template it will give me 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 "Database::select". MySQL returned error "1146: Table 'wikidb.mw_protected_titles' doesn't exist (localhost)".

Any idea how I can get ride of that error message? Thanks in advance, Albert.

—128.138.77.41 16:09, 26 August 2008 (UTC)
 * Solved. I forgot to ran the 'update script'. /maintenance/update.php. That did the trick.--Albert Ke 18:04, 26 August 2008 (UTC)

(OUTDATED) Database Error

 * MediaWiki: 1.6.6
 * PHP: 5.2.2 (cgi)
 * MySQL: 5.0.24a-log
 * URL: http://teachinghacks.com/wiki/

I had a database issue and had to repair the Revision Table in the MySQL database. Once I repaired I could not get the Main Page Back. The History for the last year was lost and any time I try to revert back. I get the following error:

The database did not find the text of a page that it should have found, named "Main Page". This is usually caused by following an outdated diff or history link to a page that has been deleted. If this is not the case, you may have found a bug in the software. Please report this to an administrator, making note of the URL.

Help would be appreciated.

—207.236.90.177 16:45, 2 September 2008 (UTC)

(OUTDATED) SQL syntax error

 * MediaWiki version: 1.5.8
 * PHP version: 5.2.6
 * MySQL version: 5.0.51
 * URL: intra net- not available

I created a form from a module for Joomla called Chronoforms, Then I deleted the module without deleting the form. It seems like the form created overwrote a table in database... specifically to the data in the wiki data...and e somehow corrupted a table in the SQL...

How can I fix this issue....when try to open the wikisite i get the following 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 "MediaWikiBagOStuff:_doquery". MySQL returned error "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 '`��TV��@����ĴS���i�Vɽ�O�?�����g��!oj�C������2��>������/��پ���''�z��ͻ��?A�?'  at line 1 (localhost)".

luis (lucher100@hotmail.com)

—208.60.167.66 15:52, 3 September 2008 (UTC)

(OUTDATED) User permissions
I installed already the third version of MediaWiki according to the database I am the sysop and bureaucrat, my profile says I have the following rights Member of groups:	Users, Autoconfirmed users, Sysop, bureaucrat (User group rights)
 * MediaWiki version: 1.13.1
 * PHP version: 5.2.5
 * MySQL version: 5.0.62
 * URL: http://www.genealogy.henny-savenije.pe.kr/mediawiki/

Yet, I don't seem to have those rights, if I try to edit the Monobook css page

http://www.genealogy.henny-savenije.pe.kr/mediawiki/index.php?title=MediaWiki:Monobook.css&action=edit

You do not have permission to edit pages, for the following reason: This page provides interface text for the software, and is locked to prevent abuse. You can view and copy the source of this page:

If I search for users, there are none, yet according to the database there are three.

Can anybody help me more with this. I am at my wits end.

—Henny 13:07, 16 September 2008 (UTC)

(OUTDATED) latin1/binary …

 * MediaWiki - 1.13.1
 * PHP 	    - 5.2.6 (apache2handler)
 * MySQL     - 5.0.51b-community-nt
 * URL:      - Intranet use only

Hello,

I am a newbie at wiki's, so any additional explanations/link/docs will be more than welcome.

Here is my issue. I am trying to set up wiki as a intranet KB (Knowledge Base) tool. And before doing that, i am just testing what is what and which is which and how everything works. I managed to install the wiki and it works just fine. I am now going through the Backup procedures for a wiki, and going through the charset issues, quite frankly leaves me staring.

Not having that much experience, i chose the recommended option of binary charset. If i create the database myself, and set collation to Binary, i get an error when trying to run the installation script (i am running a WAMP server at home, for testing purposes, and will be doing the same on-location, i really don't need to bother on this aspect - or so i think. Database management is via PhpMyAdmin):

Creating tables...Query "CREATE TABLE `searchindex` ( si_page int unsigned NOT NULL, si_title varchar(255) NOT NULL default '', si_text mediumtext NOT NULL, UNIQUE KEY (si_page), FULLTEXT si_title (si_title), FULLTEXT si_text (si_text) ) ENGINE=MyISAM " failed with error code "Column 'si_title' cannot be part of FULLTEXT index (localhost)".

I don't change the options in the installation script, i pretty much leave them the way they are, just fill in the wiki name, the DB name, user and pwd.

If, however, i don't create the database myself, and let the script do it for me, it works like a charm. But i do notice that 2 of the tables are created with different storage engines, as opposed to InnoDB, the one i selected. (I am refering to searchindex and hitcounter). Also, their charset is different, as opposed to binary (the way i requested in the setup script). They are latin1_swedish_ci. I think these 2 exceptional tables are the source for the above error, so i should let the script create the database.

I started going through Manual:Backing up a wiki. And i found the note saying that:

'''In some common configurations of MySQL 4.1 and later, mysqldump can corrupt MediaWiki's stored text. If your database's character set is set to "latin1" rather than "UTF-8", mysqldump in 4.1+ will apply a character set conversion step which can corrupt text containing non-English characters as well as punctuation like "smart quotes" and long dashes used in English text.'''

Now, if i do a STATUS in the mysql console (after selecting the proper database), i get the following: mysql> status -- F:\wamp\bin\mysql\mysql5.0.51b\bin\mysql.exe Ver 14.12 Distrib 5.0.51b, for Win 32 (ia32)

Connection id:         386 Current database:      wspedia Current user:          ODBC@localhost SSL:                   Not in use Using delimiter:       ; Server version:        5.0.51b-community-nt MySQL Community Edition (GPL) Protocol version:      10 Connection:            localhost via TCP/IP Server characterset:   latin1 Db    characterset:    latin1 Client characterset:   latin1 Conn. characterset:    latin1 TCP port:              3306 Uptime:                1 hour 57 min 29 sec

Threads: 1 Questions: 10265  Slow queries: 0  Opens: 1032  Flush tables: 1  Ope n tables: 40 Queries per second avg: 1.456

What this is showing is latin1. But i selected binary, did i not?

If my understanding of the warning in the article is correct, then in my situation i should make sure to mention the charset in the dumping entry, to make sure my tables won't get converted to another charset right? To make sure they remain latin1 and i won't lose information.

Of course, several issues arise here. Or better yet, questions:


 * Why is it showing latin1 if i selected binary?
 * Considering the STATUS above, what will msqldump convert my database into when i dump? I have latin1, but what will it convert it into if i don't select --default-charater-set? Can i tell from this window?
 * Considering i select binary during installation, STATUS shows latin1, should --default-charater-set still say latin1 in the dump entry?

Can anyone please advise on this situation?

Thank you!

Alex - alex@hostingsolution.ro —Screwy 22:32, 20 September 2008 (UTC)

(OUTDATED) Sleepy/slow wiki

 * MediaWiki version: 1.12.0
 * PHP version: 5.2.6 (apache2handler)
 * MySQL version: 4.1.20
 * URL:

Hello, my server disk became full over the weekend (both /, on which mediawiki is installed, and /var). After deleting some files (not related to mediawiki) to free up space, and restarting apache and mysql, the wiki was back online. It is however extremely slow.

When I request a page, it will show up after 20-30 seconds. After the request, if I do mysqladmin processlist I will see a thread showing up as: ++--+---+--+-+--+---+--+ | Id | User    | Host      | db           | Command | Time | State | Info             | ++--+---+--+-+--+---+--+ | 60 | wikiuser | localhost | mediawiki   | Sleep   | 21   |       |                  |

The thread sleeps for ~20s. After that, the request goes through and the page shows up.

Looks like some type of corruption of the way mediawiki talks with the mysql server. Any suggestions on how to fix this problem?

Thanks very much.

—Jusylves 13:03, 29 September 2008 (UTC)

(OUTDATED) Lost database

 * MediaWiki version: 1.13.0
 * PHP version: 5.2.5
 * MySQL version: 5.0.51a
 * URL: www.ignorantinc.com/www/ignorantwiki

I had a power outage last night. MediaWiki was working fine and updating the database fine before the outage. I brought the server back up and found my "wiki" database completely empty. The database has been removed as well. However, its just that wiki database and no others. Have you seen/heard of this behavior? At the moment, I have no data.

—67.85.135.74 14:45, 29 September 2008 (UTC) Austin
 * Yup. Scribblewiki crashed also and lost all it's data... --76.65.3.32 03:42, 16 October 2008 (UTC)

(RESOLVED) Move wiki

 * MediaWiki: 1.11.0
 * PHP: 5.2.3 (apache2handler)
 * MySQL: 5.0.41-community-nt

Hello everybody,

I need to move our Company-Wiki from one server to another. Is there a good "how-to"-Page anywhere? All I found was not really usefull for beginners.

Thanks for any idea! chaos-wiki —91.17.53.49 12:23, 1 October 2008 (UTC)


 * Did you check Manual:Moving a wiki? -- :bdk: 17:13, 1 October 2008 (UTC)

(OUTDATED) Only SQLite available on setup

 * MediaWiki version: 1.13.1
 * PHP version: 5.2.6
 * MySQL version: 5.0.51a-1.fc9
 * URL:

Hi Folks, I've fallen at the final hurdle. I have managed to install mediawiki on my webserver, however, when I go to the setup page, under database type I only have SQLite available. MediaWiki doesn't detect that mysqld is running. How can I get MySQL to appear as an option on the setup page? I have already created a wikidb and a wiki user with required privileges.

—192.193.245.16 16:45, 1 October 2008 (UTC)

(RESOLVED) Error after atempted recovery of old server

 * MediaWiki version: unsure
 * PHP version: 5.1
 * MySQL version: 5.1
 * URL:

I have recovered data from a previous install that had the server died. I am now getting this: MediaWiki internal error.

Original exception: exception 'DBQueryError' with message 'A database error has occurred Query: SELECT value,exptime FROM `objectcache` WHERE keyname='wikidb:messages-hash' Function: MediaWikiBagOStuff::_doquery Error: 1146 Table 'wikidb.objectcache' doesn't exist (localhost) ' in /var/www/html/wiki/includes/Database.php:708 Stack trace:
 * 1) 0 /var/www/html/wiki/includes/Database.php(665): Database->reportQueryError('Table 'wikidb.o...', 1146, 'SELECT value,ex...', 'MediaWikiBagOSt...', false)
 * 2) 1 /var/www/html/wiki/includes/BagOStuff.php(396): Database->query('SELECT value,ex...', 'MediaWikiBagOSt...')
 * 3) 2 /var/www/html/wiki/includes/BagOStuff.php(296): MediaWikiBagOStuff->_doquery('SELECT value,ex...')
 * 4) 3 /var/www/html/wiki/includes/BagOStuff.php(236): SqlBagOStuff->_query('SELECT value,ex...', 'wikidb:messages...')
 * 5) 4 /var/www/html/wiki/includes/MessageCache.php(206): SqlBagOStuff->get('wikidb:messages...')
 * 6) 5 /var/www/html/wiki/includes/MessageCache.php(442): MessageCache->load
 * 7) 6 /var/www/html/wiki/includes/GlobalFunctions.php(420): MessageCache->get('mainpage', true, true)
 * 8) 7 /var/www/html/wiki/includes/GlobalFunctions.php(379): wfMsgGetKey('mainpage', true, true, true)
 * 9) 8 /var/www/html/wiki/includes/GlobalFunctions.php(328): wfMsgReal('mainpage', Array, true, true)
 * 10) 9 /var/www/html/wiki/includes/Title.php(275): wfMsgForContent('mainpage')
 * 11) 10 /var/www/html/wiki/includes/Wiki.php(74): Title::newMainPage
 * 12) 11 /var/www/html/wiki/index.php(17): MediaWiki->checkInitialQueries(NULL, 'view', Object(StubObject), Object(WebRequest), Object(StubContLang))
 * 13) 12 {main}

Exception caught inside exception handler: exception 'DBUnexpectedError' with message 'Error in fetchObject: Table 'wikidb.page' doesn't exist (localhost)' in /var/www/html/wiki/includes/Database.php:825 Stack trace: I do not know what to make of it. I am not sure the database is actually intact, I have webmin installed and it gives me this error when I try to access the wikidb:
 * 1) 0 /var/www/html/wiki/includes/MessageCache.php(315): Database->fetchObject(false)
 * 2) 1 /var/www/html/wiki/includes/MessageCache.php(252): MessageCache->loadFromDB
 * 3) 2 /var/www/html/wiki/includes/MessageCache.php(442): MessageCache->load
 * 4) 3 /var/www/html/wiki/includes/GlobalFunctions.php(420): MessageCache->get('databaseerror', true, false)
 * 5) 4 /var/www/html/wiki/includes/GlobalFunctions.php(379): wfMsgGetKey('databaseerror', true, false, true)
 * 6) 5 /var/www/html/wiki/includes/Exception.php(18): wfMsgReal('databaseerror', Array)
 * 7) 6 /var/www/html/wiki/includes/Database.php(212): MWException->msg('databaseerror', 'Database error')
 * 8) 7 /var/www/html/wiki/includes/Exception.php(109): DBQueryError->getPageTitle
 * 9) 8 /var/www/html/wiki/includes/Exception.php(76): MWException->htmlHeader
 * 10) 9 /var/www/html/wiki/includes/Exception.php(95): MWException->reportHTML
 * 11) 10 /var/www/html/wiki/includes/Exception.php(171): MWException->report
 * 12) 11 /var/www/html/wiki/includes/Exception.php(205): wfReportException(Object(DBQueryError))
 * 13) 12 [internal function]: wfExceptionHandler(Object(DBQueryError))
 * 14) 13 {main}

SQL show index from `archive` failed : Table 'wikidb.archive' doesn't exist

Ideas? No, this was not backed up before it all died.

—205.189.93.240 19:44, 1 October 2008 (UTC)


 * Run update.php. —Emufarmers(T 22:49, 1 October 2008 (UTC)

(RESOLVED) Get Password from the database

 * MediaWiki version: 1.12.0
 * PHP version: 5.2.6
 * MySQL version: 5.0.51

Hello, I'd like to know if I can get my password from the mediawiki's database (I'm the admin, of course). Someone hacked my user, and now I don't know how to change it. I have full access to the mysql database and the files. I can't provide more information because I don't know english very well, sorry.

Thanks for reading. Bye —194.158.77.76 19:17, 3 October 2008 (UTC)


 * Reset the password. —Emufarmers(T 23:36, 4 October 2008 (UTC)

(OUTDATED) CentralAuth does not work
I tried to install CentralAuth following the instructions but it did not work. I cannot merge my accounts with my other two DBs.
 * MediaWiki version: SVN trunk
 * PHP version:
 * MySQL version:
 * URL: Localhost

Here's a section from LocalSettings.php: require_once ("$IP/extensions/CentralAuth/CentralAuth.php"); $wgSharedDB = 'wiki2008'; $wgSharedTables = array( 'user', 'user_groups', 'interwiki'); $wgSharedPrefix = ''; $wgSharedDBUserTable = null; My wiki's databases are wiki2008, wiki2009, testwiki and wikisite1

What have I done wrong?? —82.42.237.84 10:44, 4 October 2008 (UTC)

(RESOLVED) Local copy of all images needed ?

 * MediaWiki version: 1.12.0
 * PHP version: 5.2.4
 * MySQL version: 14.12
 * URL:

I have installed a server with a local copy of the french wikipedia database (from the last dump). I got images for some articles with the wikix tool. Everything is working well, I can browse in the encyclopedia from my server. If it is possible, I'd like to load images directly from the web instead of downloading all of them on my hard drive. My question is : is it possible to do it ? and if yes, how can I configure mediawiki ? I've only seen stuffs about the configuration of the local directory that store images in manuals and FAQs. Thank you for your help

—129.175.11.241 16:14, 7 October 2008 (UTC)


 * Have a look at Manual:$wgForeignFileRepos -- :bdk: 18:20, 13 December 2008 (UTC)

(OUTDATED) MediaWiki 1.13.1 Installation problem (could not find a suitable database driver)

 * MediaWiki version: 1.13.1
 * PHP version: 5.2.6
 * MySQL version: 5.0
 * URL: http://www.niva.com/nivawiki/config/index.php

I have an installation problem. Following message is display:

PHP 5.2.6 installed Could not find a suitable database driver!
 * For MySQL, compile PHP using --with-mysql, or install the mysql.so module
 * For PostgreSQL, compile PHP using --with-pgsql, or install the pgsql.so module
 * For SQLite, compile PHP using --with-pdo_sqlite, or install the pdo_sqlite.so module
 * For MSSQL, compile PHP using --with-mssql not ready, or install the mssql not ready.so module

(OUTDATED) MediaWiki working with Oracle 10i?

 * MediaWiki version:
 * PHP version:
 * MySQL version:
 * URL:

Will the Latest version Of MediaWiki work with Oracle 10i ? I've tried to search for this answer but haven't found it.

Thanks, Ken —205.141.247.28 19:09, 8 October 2008 (UTC)
 * I don't think so... Anyways just use MYSQL. --76.65.3.32 03:47, 16 October 2008 (UTC)

(OUTDATED) How to view the text table's contents?
I've got MediaWiki working, however, I'm curious to know how to view the text table's contents in PHPmyadmin as I can't see the deleted page's text. Anyone know how it's done! Ta, —82.42.237.84 22:40, 16 October 2008 (UTC)
 * MediaWiki version: SVN trunk
 * PHP version: 5.26
 * MySQL version:
 * URL: N/A, testing on localhost

(OUTDATED) Installation problem with 1.14alpha and PostgreSQL
While the installation of 1.13.2 works fine, 1.14alpha cannot be installed with PostgreSQL (updating from 1.13.2 also does not work properly). Installing on a MySQL-Server also worked fine.
 * MediaWiki version: 1.14alpha
 * PHP version: 5.2.6
 * PostgreSQL version: 8.3.4
 * URL:

PostgreSQL says: DB Connection error: Unable to connect to PostgreSQL server: FATAL: no PostgreSQL user name specified in startup packet

—141.44.21.8 11:25, 29 October 2008 (UTC)

(OUTDATED) Error 1062: Duplicate entry '305' for key 1 (localhost)

 * MediaWiki version:
 * PHP version:
 * MySQL version:
 * URL:

Hi,

Please note that while I am trying to save some content in a wiki page I am getting this 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 "RecentChange::save". MySQL returned error "1062: Duplicate entry '305' for key 1 (localhost)".

The error appears when I try to save the page for the first time. If I press the Back button of browser and retry it works.

Can you pls shed some lights on whats the error may be?

Regards, —Jagbir 14:06, 4 November 2008 (UTC)

(OUTDATED) Oracle Support?

 * MediaWiki version: in general
 * PHP version:      5.2
 * MySQL version:    5.0.22
 * URL:

I'm interested in Mediawiki support of Oracle as a DBMS. I've read this support is discontinued some time ago but at the same time I didnot find any comments why this happened, what is the way to get the latest source, what were the bugs and so on. If anyone can help finding a documentation and the way i may use Oracle with Mediawiki, please write to velislav.bg at gmail dot com

—79.110.116.161 07:37, 13 November 2008 (UTC)

(RESOLVED) 1048: Column 'old_id' cannot be null

 * Product 	Version
 * MediaWiki 	1.13.2
 * PHP 	5.2.4-2ubuntu5.3 (apache2handler)
 * MySQL 	5.0.51a-3ubuntu5.3

I have upgraded from one machine running 1.13.0 to a different machine with the latest 1.13.2.

'Old' machine:


 * Product 	Version
 * MediaWiki 	1.13.0
 * PHP 	5.1.2 (apache2handler)
 * MySQL 	5.0.18

I have maintained the old LocalSettings.php and updated the MySQL database from a mysqldump. At a glance things appear to be in order (page histories, images, user accounts, page contents etc.). However, when I try to perform a 'Save page' I get:

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_id' cannot be null (localhost)".

Any advice?

—147.96.5.37 17:41, 13 November 2008 (UTC)


 * Did you run update.php? I wouldn't expect a schema change between 1.13.0 and 1.13.2, but it's usually a good idea to run the update script even after minor upgrades (especially if something stops working!). —Emufarmers(T 19:58, 13 November 2008 (UTC)


 * Yep, I did run it, with no apparent problems (it did seem a bit *fast*, but then again my new machine is much more powerful). Is there anything in the database that is host specific? Has there been any minor change in LocalSettings.php between 1.13.0 and 1.13.2? Like I said, superficially everthing appears to be in place. It is only on 'Save page' that things go egg-shaped. Could it be a matter of incorrect passwords or usernames that have permission to query the db, but not write to it? Any suggestions are obviously most welcome! All the best --147.96.5.37 10:55, 14 November 2008 (UTC)

Solved: For some reason my daily backup script invoking mysqldump had the flag --skip-opt. Removing this flag and loading this new dump (efectivley with the flag --opt) resolved the situation (dont ask me why I used --skip-opt...). All the best --147.96.5.37 13:07, 14 November 2008 (UTC)
 * Hi, this was very helpful. I was checking to install a copy of a Wiki to another server. In principle that worked, but I had your problem and simultaneously some trouble with the character sets. Canging --skip-opt by --opt solved both problems.
 * 82.135.89.216 20:56, 12 December 2008 (UTC)