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)

(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)

(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)