Project:Support desk/Sections/Database

__NEWSECTIONLINK__ = MediaWiki Database Support =

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

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)

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)

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)

Text table question
I installed the latest, it works well. However, I'm on WAMP, and I have PHPMyadmin, how do I view the text table?? AC —82.42.237.84 13:10, 20 December 2008 (UTC)
 * MediaWiki version: SVN build TortoiseSVN
 * PHP version: LATEST
 * MySQL version: LATEST
 * URL:

Page links with national characters disappeared after database migration

 * MediaWiki: 1.10alpha
 * PHP: 5.2.6 (ucgi5)
 * MySQL: 5.0.66a-log
 * URL: http://www.krokpokroku.pl/wiki/index.php?title=Inspiracje


 * MediaWiki: 1.13.3
 * PHP: 5.2.6 (cgi-fcgi)
 * MySQL: 5.0.67-log
 * URL: http://mat.extremefaith.info/kpk/mediawiki-1.13.3/index.php?title=Inspiracje

Hello,

I need help with the following problem.

I am moving a MediaWiki based webpage from one server to another. After exporting the database and importing it to the new server I got the message "1271: Illegal mix of collations for operation ' IN ' (mysql.extremefaith.info)". So I updated MediaWiki to the newest stable version (1.13.3) which caused the change of the $wgDBmysql5 variable value to "true" and that solved the problem.

Yet another one appeared. Although the content of the present pages remained unchanged (all the national characters were present) all the links with national characters became "red" (f.ex. "Śnieżnobiałe światło") and I can't access the content of those pages. What's more when I add the content manually some pages still remain "red". When I click on this kind of edited-"red" page I can see the content but it's being opened in "edit" tab by default. All the tables have "latin2_general_ci" collation set.

Could you please help me to fix the "red" links with national characters?

(You can see the red links f.ex. here: http://mat.extremefaith.info/kpk/mediawiki-1.13.3/index.php?title=Teksty_pie%C5%9Bni)

—Smatric 19:38, 27 December 2008 (UTC)

Content is no longer visible, and I cannot log in to my account

 * MediaWiki version: 1.13.3
 * PHP version: 5.2.8
 * MySQL version: 5.0.67

All my pages are showing me the "There is currently no text in this page..." message, and I cannnot log in to my account. I can view the 'recent changes' page. I can't see the history of any pages, yet I can see the diffs. My web host recently upgraded from MySQL 4 to 5, so perhaps it's something to do with that.

Does anyone know of something I can do to restore my wiki? Being able to view the diffs, I think the content is still in there somewhere.

—WabsBio 10:24, 19 January 2009 (UTC)

Can't view content pages - DB Error!

 * MediaWiki version: 1.13 (upgraded from 1.11)
 * PHP version: 5.2.6
 * MySQL version:  5.0.45-community-nt
 * URL: http://www.bandwiki.net/

We recently updated to ver.1.13 from 1.11 as well as changed over to a new server for both our site and db server. When we view any content page we recieve the following error:

A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was: SELECT page_id, page_namespace, page_title, page_len, page_is_redirect, pp_value FROM `sb_wiki_page` LEFT JOIN `sb_wiki_page_props` ON pp_propname='hiddencat' AND pp_page=page_id WHERE (page_namespace=14 AND page_title='Band♪Wiki_Extensions')

from within function "OutputPage::addCategoryLinks". MySQL returned error "1146: Table 'nwpos09_bandwiki.sb_wiki_page_props' doesn't exist (lord.my-hosting-panel.com)".”

The same error pretty-much occurs with 'sb_wiki_protected_titles' when viewing pages like the 'Privacy Policy' as well.

—64.91.123.139 14:11, 19 January 2009 (UTC)


 * Run the update script. —Emufarmers(T 14:38, 19 January 2009 (UTC)