Project:Support desk/Archives/Database/002

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

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:
 * I don't really get your question, if you have PHPMyAdmin and you want to see the text table just do so. --IvanStepaniuk 15:37, 28 January 2009 (UTC)

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)

I have the same problem. I checked the DB. The content still there. How to solve this problem?

--Nasario 11:30, 12 February 2009 (UTC)

(RESOLVED) Can't view content pages - DB Error!
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:
 * 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/

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)

Database error

 * MediaWiki version: 1.14alpha (r4589)
 * PHP version: 5.2-4-2ubuntu5wm (apache2handler)
 * MySQL version: 4.0.40-wikipedia-log
 * URL: http://www.marinegouge.com

When trying to access this page, I get the 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::_doinsert". MySQL returned error "1044: Access denied for user: 'dbo164288558@%' to database 'db164288558' (db388.perfora.net)". Retrieved from "http://marinegouge.com/mediawiki-1.6.6/index.php?title=Main_Page"

I cannot access anything on this page. How can I fix this?

paul_jones880@yahoo.com

—12.219.78.192 03:03, 21 January 2009 (UTC)


 * Sounds like your database user's permissions got mauled. If you can't fix the permissions yourself, complain to your host. —Emufarmers(T 13:19, 21 January 2009 (UTC)

Column user_id corrupted?

 * MediaWiki version: 1.12
 * PHP version: Unsure
 * MySQL version: 5.0.45
 * URL:

—74.0.37.138 22:45, 22 January 2009 (UTC)

After much investigation is appears that the column user_id in mySQL got deleted. Now all my users can see the wiki and even anonymously edit any page they would like. But they cannot login with their user ID's and cannot register. Anyone have any idea how I can fix this? I'm not a super mySQL user so as explicit detail as possible will be greatly appreciated.

Fixed: mysql>ALTER TABLE aw_user ADD COLUMN user_id INT(5) NOT NULL PRIMARY KEY AUTO_INCREMENT;

Database query error after minor mysql upgrade

 * MediaWiki version: 1.10.1
 * PHP version: PHP: 5.2.0-8+etch13 (apache2handler)
 * MySQL version: 5.0.32-Debian_7etch8-log
 * URL: intranet

Hello, I have few MW installations on an intranet, after upgrading mysql from 5.0.32-7etch6 to 5.0.32-7etch8 I got all my MW failing with the same following error.

Original exception: exception 'DBQueryError' with message 'A database error has occurred Query: SELECT value,exptime FROM `objectcache` WHERE keyname='mw_ultra:messages-hash' Function: MediaWikiBagOStuff::_doquery Error: 1033 Incorrect information in file: './mw_ultra/objectcache.frm' (localhost) ' in /home/albafotonica.com/ultra/includes/Database.php:806 ...

I have no idea what happened, and could not repair the error. Fortunately I have dumped all my databases before the upgrade, dropping the MW databases and putting everything where it was solved the problem. But i still wonder what happened, I googled for the error with no luck (except same symptoms when upgrading from some mysql4 versions as the FRM format changed somehow, but its not the case). Perhaps someone can throw some light over this, I believe it can happen to many people using Debian stable, and not everyone remembers to backup before upgrading.

—IvanStepaniuk 10:30, 26 January 2009 (UTC)


 * It seems that this error is related to changes in the InnoDB (binary log sizes mismatch during upgrade?). Restoring the backup was probably the fast/safe solution but not the only one. This is not MW related, I will try to track down the problem somewhere else anyway. --IvanStepaniuk 11:47, 27 January 2009 (UTC)

My wiki is inaccesible

 * MediaWiki version: 1.13
 * PHP version: 	5.2.8
 * MySQL version: 5.0.67-community
 * URL: http://wikimh.netsons.org

Hello, probably i have modified incorrectly LocalSetting.php and so when i go to my wiki appears:

‘’ Warning: require_once(/extensions/UserRightsList/UserRightsList.php) [function.require-once]: failed to open stream: No such file or directory in /home/wikimh/public_html/LocalSettings.php on line 19

Fatal error: require_once [function.require]: Failed opening required '/extensions/UserRightsList/UserRightsList.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/wikimh/public_html/LocalSettings.php on line 19 ‘’

I don't understand what is the problem and i don't succeed in resolving it.

Thanks in advance

—Mark 54 14:10, 26 January 2009 (UTC)Mark


 * Replace line 19 with  —Emufarmers(T 20:50, 26 January 2009 (UTC)

Thanks, but now appears "line 115". What and where are the line 115 and line 19? —Mark 54 23:10, 26 January 2009 (UTC)Mark


 * What's the new error? —Emufarmers(T 04:19, 27 January 2009 (UTC)

Unfortunately i don't know. I had modified only LocalSettings.php: before there was "line 19", now there is "line 115". —Mark 54 15:25, 27 January 2009 (UTC)Mark
 * His new error says (from his url)
 * "...failed to open stream: No such file or directory in /home/wikimh/public_html/LocalSettings.php on line 115"
 * So it's basically the same error, on another line (115) referencing the same file. Doesn't really make sense, as that file is already "required" by line 19. You can probably comment that line adding # at the begin of the line 115. Perhaps you should try to recover a working copy of your LocalSettings file, or generate a new one if you are not familiar with PHP. --IvanStepaniuk 16:58, 27 January 2009 (UTC)

Thanks. How do i recover a working copy of LocalSettings.php or how do i generate a new one? Unfortunately i am not fimiliar with PHP and very inexperienced. —Mark 54 21:10, 27 January 2009 (UTC)Mark


 * Thanks, Ivan. I hate when my brain stops working. :)
 * Just remove or comment out line 115; you probably added the require_once line twice. —Emufarmers(T 00:07, 28 January 2009 (UTC)

This is my LocalSettings.php file: (My Localsettings file is in my user page) —Mark 54 14:45, 28 January 2009 (UTC)Mark
 * I have edited your question ading source tags, now i see "[...]"!, change that whole line to just $wgRemoveGroups['bureaucrat'] = false; --IvanStepaniuk 16:13, 28 January 2009 (UTC)

I decide to write [...] not to write the complete user rights' list, but [...] there isn't in my localsettings.php; so in this file there isn't ***. Please, don't consider *** and [...]. —Mark 54 18:52, 28 January 2009 (UTC)Mark


 * Mark, it is very difficult to tell if there is an error in what you have posted, try to post your file again (perhaps in your user page instead, not here), and do not modify anything but passwrords and sensitive info. Anyway, now I see your problem is the database connection, so either your user or password is incorrect, or the database is just not there. I think the best you can do if you are just starting, is to start over, carefully following the indications on the Manual:Installation guide, good luck! --IvanStepaniuk 23:43, 28 January 2009 (UTC)

I have posted my LocalSettings.php file in my user page. I have assured myself that the password and the user are correct. In my wiki's database there are many files, so starting over is a big problem for me :( How can i generate a new Localsettings.php file? Or how do i recover the files which are in my database? Thanks for your help.

PS I have tried to modify my LocalSettings.php and now there is this message: "Error, Setup.php must be included from the file scope, after DefaultSettings.php ". —Mark 54 20:44, 30 January 2009 (UTC)Mark

Error installing MySQL database

 * MediaWiki version: MediaWiki 1.13.3
 * PHP version: PHP 5.2.5
 * MySQL version: Don't know
 * URL: www.dcoxdictionary.com

How do you install the mySQL database? I get an error that says to check the database username and password. I have gone into control panel on my site and created the database, and gave myself a user and password, and then set my privileges to all. Still will not get past that point. Anybody can help me?

David Cox

—189.242.40.41 05:10, 31 January 2009 (UTC)

Recover all files in my wiki

 * MediaWiki version: 1.12.0
 * PHP version: 5.2.8
 * MySQL version: 5.0.67-community
 * URL: http://wikimh.netsons.org

Hello, i have modified incorrectly my LocalSettings.php and now my wiki is inaccesible. So i want to star over and install another wiki. How do i recover the files which are in my wiki to transfer them to another database? I don't find them in my database. Thanks in advance.

—Mark 54 09:53, 1 February 2009 (UTC)Mark

MySQL error on UserPageViewTracker

 * MediaWiki version: MediaWiki 1.13.3
 * PHP version: PHP 5.2.8-0.dotdeb.1 (cgi-fcgi)
 * MySQL version: MySQL 5.0.67-0.dotdeb.1
 * URL: www.b40317.nl/wiki

-

I followed the instructions on: http://www.mediawiki.org/wiki/Extension:UserPageViewTracker

All went well and a table user_page_views was created. It all went wrong when I ran "UserPageHits.sql" as prescribed. Upon doing so I received an error as follows: #1142 - CREATE VIEW command denied to user 'bnl'@'localhost' for table 'user_page_hits'

The UserPageHits.sql is copy pasted as follows:

CREATE VIEW `user_page_hits` AS SELECT `u`.`user_name` AS `user_name`, `u`.`user_real_name` AS `user_real_name`, `p`.`page_namespace` AS `page_namespace`, `p`.`page_title` AS `page_title`, `v`.`hits` AS `hits`, `v`.`last` AS `last` FROM ((`user` `u` JOIN `page` `p`) JOIN `user_page_views` `v`) WHERE ((`u`.`user_id` = `v`.`user_id`) AND (`p`.`page_id` = `v`.`page_id`)) ORDER BY `u`.`user_id`,`v`.`hits` DESC;

Can anyone help me out what I have to do differently? Cheers.

Menno

—82.217.71.172 21:42, 5 February 2009 (UTC)
 * It is possible that your database user does not have the CREATE VIEW privilege granted, did you try to grant all privileges for your user for this database?

--IvanStepaniuk 10:07, 6 February 2009 (UTC)

Cheers Ivan, Can't do apparently; when I run your advice, I get the following feed back: #1044 - Access denied for user 'bnl'@'localhost' to database 'my-mediawiki-database-name'

Menno

--82.217.71.172 09:20, 7 February 2009 (UTC)

Wiki wont load

 * MediaWiki version: 1.11.0
 * PHP version: 5.2.6
 * MySQL version: 4.1.22
 * URL: http://seekcreativity.com/splash/wiki/

I just went to my wiki one day and I saw this... I used InnoDB

MediaWiki internal error.

Original exception: exception 'DBQueryError' with message 'A database error has occurred Query: SELECT value,exptime FROM `wiki_objectcache` WHERE keyname='seekcrea_wiki1-wiki_:messages-hash' Function: MediaWikiBagOStuff::_doquery Error: 1146 Table 'seekcrea_wiki1.wiki_objectcache' doesn't exist (localhost) ' in /home/seekcrea/public_html/splash/wiki/includes/Database.php:824 Stack trace:
 * 1) 0 /home/seekcrea/public_html/splash/wiki/includes/Database.php(779): Database->reportQueryError('Table 'seekcrea...', 1146, 'SELECT value,ex...', 'MediaWikiBagOSt...', false)
 * 2) 1 /home/seekcrea/public_html/splash/wiki/includes/BagOStuff.php(405): Database->query('SELECT value,ex...', 'MediaWikiBagOSt...')
 * 3) 2 /home/seekcrea/public_html/splash/wiki/includes/BagOStuff.php(300): MediaWikiBagOStuff->_doquery('SELECT value,ex...')
 * 4) 3 /home/seekcrea/public_html/splash/wiki/includes/BagOStuff.php(234): SqlBagOStuff->_query('SELECT value,ex...', 'seekcrea_wiki1-...')
 * 5) 4 /home/seekcrea/public_html/splash/wiki/includes/MessageCache.php(205): SqlBagOStuff->get('seekcrea_wiki1-...')
 * 6) 5 /home/seekcrea/public_html/splash/wiki/includes/MessageCache.php(441): MessageCache->load
 * 7) 6 /home/seekcrea/public_html/splash/wiki/includes/GlobalFunctions.php(467): MessageCache->get('mainpage', true, true)
 * 8) 7 /home/seekcrea/public_html/splash/wiki/includes/GlobalFunctions.php(421): wfMsgGetKey('mainpage', true, true, true)
 * 9) 8 /home/seekcrea/public_html/splash/wiki/includes/GlobalFunctions.php(368): wfMsgReal('mainpage', Array, true, true)
 * 10) 9 /home/seekcrea/public_html/splash/wiki/includes/Title.php(268): wfMsgForContent('mainpage')
 * 11) 10 /home/seekcrea/public_html/splash/wiki/includes/Wiki.php(92): Title::newMainPage
 * 12) 11 /home/seekcrea/public_html/splash/wiki/index.php(58): 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 'seekcrea_wiki1.wiki_page' doesn't exist (localhost)' in /home/seekcrea/public_html/splash/wiki/includes/Database.php:953 Stack trace:
 * 1) 0 /home/seekcrea/public_html/splash/wiki/includes/MessageCache.php(314): Database->fetchObject(false)
 * 2) 1 /home/seekcrea/public_html/splash/wiki/includes/MessageCache.php(251): MessageCache->loadFromDB
 * 3) 2 /home/seekcrea/public_html/splash/wiki/includes/MessageCache.php(441): MessageCache->load
 * 4) 3 /home/seekcrea/public_html/splash/wiki/includes/GlobalFunctions.php(467): MessageCache->get('databaseerror', true, false)
 * 5) 4 /home/seekcrea/public_html/splash/wiki/includes/GlobalFunctions.php(421): wfMsgGetKey('databaseerror', true, false, true)
 * 6) 5 /home/seekcrea/public_html/splash/wiki/includes/Exception.php(23): wfMsgReal('databaseerror', Array)
 * 7) 6 /home/seekcrea/public_html/splash/wiki/includes/Database.php(276): MWException->msg('databaseerror', 'Database error')
 * 8) 7 /home/seekcrea/public_html/splash/wiki/includes/Exception.php(125): DBQueryError->getPageTitle
 * 9) 8 /home/seekcrea/public_html/splash/wiki/includes/Exception.php(88): MWException->htmlHeader
 * 10) 9 /home/seekcrea/public_html/splash/wiki/includes/Exception.php(111): MWException->reportHTML
 * 11) 10 /home/seekcrea/public_html/splash/wiki/includes/Exception.php(191): MWException->report
 * 12) 11 /home/seekcrea/public_html/splash/wiki/includes/Exception.php(225): wfReportException(Object(DBQueryError))
 * 13) 12 [internal function]: wfExceptionHandler(Object(DBQueryError))
 * 14) 13 {main}

—Chavoc 22:23, 9 February 2009 (UTC)


 * Make sure that you're connecting to the right database, and that you're using the right database prefix. If you are, then you're missing some tables, and will need to restore from a backup. —Emufarmers(T 21:46, 10 February 2009 (UTC)

While none of that information has changed... I have noticed errors when viewing the tables with phpMyAdmin... All except the search index seem to be broken. This exact same thing has happened to annother media wiki of mine on annother server, with a completly different set up. Unfortunatly my backup was lost when I had a personal harddrive failure (didnt backup the backup.) Why might this have happened ONLY to 2 media wiki databases, when all the other databases on the mysql servers stay fine? Are there any tools out there that I could run that can try and recover corrupt InnoDB tables? --Chavoc 00:33, 11 February 2009 (UTC)


 * I would guess that the other databases on the servers aren't using InnoDB. You could try repairing the tables in phpMyAdmin; you could also dump, drop, and recreate the tables; and, of course, you could just ask your host for a backup (whether or not they'll have one to give you depends on the host). —Emufarmers(T 12:31, 11 February 2009 (UTC)

SAMPLE COMMANDS & OUTPUT

 * "mediawiki=# \d mediawiki.ipblocks
 * ERROR: expected "[" to start datum, but got "4 [ 1 0 0 0 ]})}"; length = 0
 * mediawiki=# select * from mediawiki.ipblocks;
 * ipb_id | ipb_address | ipb_user | ipb_by | ipb_reason | ipb_timestamp | ipb_auto | ipb_anon_only | ipb_create_account | ipb_enable_autoblock | ipb_expiry | ipb_range_start | ipb_range_end | ipb_deleted | ipb_block_email"


 * "/usr/local/pgsql/bin/pg_dump mediawiki -v -U postgres -f mediawiki_dump.sql
 * pg_dump: finding default expressions of table "ipblocks"
 * pg_dump: SQL command failed
 * pg_dump: Error message from server: ERROR: expected "[" to start datum, but got "4 [ 1 0 0 0 ]})}"; length = 0
 * pg_dump: The command was: SELECT tableoid, oid, adnum, pg_catalog.pg_get_expr(adbin, adrelid) AS adsrc FROM pg_catalog.pg_attrdef WHERE adrelid = '16637'::pg_catalog.oid
 * pg_dump: *** aborted because of error"
 * pg_dump: Error message from server: ERROR: expected "[" to start datum, but got "4 [ 1 0 0 0 ]})}"; length = 0
 * pg_dump: The command was: SELECT tableoid, oid, adnum, pg_catalog.pg_get_expr(adbin, adrelid) AS adsrc FROM pg_catalog.pg_attrdef WHERE adrelid = '16637'::pg_catalog.oid
 * pg_dump: *** aborted because of error"


 * Any ideas on how to fix this would be appreciated.

—216.187.127.35 16:18, 11 February 2009 (UTC) jdext

RESOLVED: Issue no longer encountered after restarting postgresql.


 * MediaWiki version: 1.13.2
 * PHP version: 5.2.8
 * MySQL version: - using postgresql 8.3
 * URL:

I am trying to restore from a previous backup. After I restore the database in Postgres and try to connect to my wiki, I receive the following error:

Could not determine the numeric version from !

I am clueless whats going wrong. Please help.

—122.166.21.40 06:54, 17 February 2009 (UTC)

Can't contact the database server: Unknown error, Technical Problem
When i try editing any page by editing section wise, i get he following error
 * MediaWiki version: 1.13.4
 * PHP version: 5
 * MySQL version:
 * URL:

******* (mysite) has a problem

Sorry! This site is experiencing technical difficulties.

Try waiting a few minutes and reloading.

(Can't contact the database server: Unknown error (mysql6.000webhost.com)

—58.27.155.168 18:10, 17 February 2009 (UTC)Jawad Ahmed


 * MediaWiki version: 1.13.5
 * PHP version: 5.2.6 (apache2handler)
 * MySQL version: 5.0.67-community
 * URL:http://www.wikiarmero.site90.com

I have the same problem/error. With same host 000webhost. But its so interesting that if you change by hand in navigator adress bar &section=X to &section=0, then work and open edit section page 0, with other number dont work. Anyone can help us?

--88.1.227.38 16:24, 25 March 2009 (UTC)


 * MediaWiki version: 1.14.0
 * PHP version: 5.2.*
 * MySQL version: 5.0.51-community
 * URL:

Got the same problem ... same hoster... can't delete Files pretty disgusting this happens only if want to delete a article

-- 87.212.44.67 15:24, 3 May 2009 (UTC)


 * MediaWiki version: 1.14.0
 * PHP version: 5.2.9
 * MySQL version: 5.0.67
 * URL: http://stafleu.netne.net

Also got the problem when editing sections on the same server (000webhost.com). I found out the problem probably arises due to the maximum of two DB connections enforced by the server, while editing sections opens at least three simultaneous connections. Haven't checked deletes though.

Possible solution: more close statements? Don't know where they can be safely added though...

-- 15:24, 3 May 2009 (UTC)

[SOLVED] Articles content location for new developments

 * MediaWiki version: 1.10.0
 * PHP version: 5
 * MySQL version: 5.0.27
 * URL: localhost

I'm looking for the articles content, where they're phisically stored. I would like to reach them with some php code, to develop my own pages, for my company.

I've been trying for days to find them in the database (with the blob fields) or in some obscure text file within the mediawiki folder, but nothing to do.

Can anyone help ? Thanks a lot !

Edit : OK, found it. PHPMyAdmin just can't display the BLOB fields properly. I used the MySQL Query Browser Tool

—138.102.135.242 09:42, 20 February 2009 (UTC)

Error with Postgres Upgrade to 1.14.0

 * MediaWiki version: 1.12alpha (r26964) upgrade to 1.14.0
 * PHP version: 5.2.0-8+etch13(apache2handler)
 * Postgres version: 8.2.12
 * URL: Internal

When running the schema update the following happens

MediaWiki 1.14.0 Updater
 * 1) php update.php --aconf ../AdminSettings.php

Going to run database updates for wikidb Depending on the size of your database this may take a while! Abort with control-c in the next five seconds...0 ... search_path for user "wikiuser" looks correct (mediawiki, public) ... default value of "client_min_messages" is correctly set to "error" for user "wikiuser" ... default value of "DateStyle" is correctly set to "ISO, YMD" for user "wikiuser"

...

... column "ipblocks.ipb_block_email" is already of type "smallint" ... column "ipblocks.ipb_address" is already of type "text" Changing column type of "ipblocks.ipb_deleted" from "char" to "smallint"

Warning: pg_query: Query failed: ERROR: default for column "ipb_deleted" cannot be cast to type "pg_catalog.int2" in /x1/www/mediawiki-1.14.0/includes/db/DatabasePostgres.php on line 578 A database error has occurred Query: ALTER TABLE ipblocks ALTER ipb_deleted TYPE smallint USING ipb_deleted::smallint; COMMIT;

Function: Error: 1 ERROR: default for column "ipb_deleted" cannot be cast to type "pg_catalog.int2"

Backtrace:
 * 1) 0 /x1/www/mediawiki-1.14.0/includes/db/Database.php(591): DatabasePostgres->reportQueryError('ERROR: default...', 1, 'ALTER TABLE ipb...', '', false)
 * 2) 1 /x1/www/mediawiki-1.14.0/maintenance/updaters.inc(1626): Database->query('ALTER TABLE ipb...')
 * 3) 2 /x1/www/mediawiki-1.14.0/maintenance/updaters.inc(1068): do_postgres_updates
 * 4) 3 /x1/www/mediawiki-1.14.0/maintenance/update.php(62): do_all_updates(false, true)
 * 5) 4 {main}

The Wiki seems to run fine though...., but the error is disturbing.

—Cleopold73 22:27, 26 February 2009 (UTC)


 * This has been fixed in subversion. You can fix your system in one of two ways:
 * 1) Run this SQL directly inside your database: ALTER TABLE ipblocks ALTER ipb_deleted TYPE smallint USING ipb_deleted::smallint DEFAULT 0
 * 2) Edit your updaters.inc file: find the spot that says "ipb_deleted::smallint", change it to "ipb_deleted::smallint DEFAULT 0", and then rerun the updater (by running php update.php or running the installer via the web page)

Creating Groups

 * MediaWiki version: 1.13.4
 * PHP version: 5.2.8
 * MySQL version: 5.2
 * URL:

How do I create Groups on Mediawiki?

—84.174.213.154 19:55, 2 March 2009 (UTC)

Getting table 'page' is full errors when trying to create article

 * MediaWiki version: 1.13.2
 * PHP version: 5.2.6-pl2-gentoo
 * MySQL version: 5.0.26
 * URL: http://www.bloomingpedia.org/

Hello, I've been running this wiki for quite a while without issues of this kind. Recently, the server that the database is on crashed. After this we have had some strange errors from Mediawiki related to the database. I tried running CHECK TABLE on each of the mediawiki tables and they all reported ok, so I'm not sure where the error lies. Here is the specific error I'm getting when trying to create an article:

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::insertOn". MySQL returned error "1114: The table 'page' is full (db-hostname-omitted)".

Thanks for your help. -- Deltaray 15:06, 9 March 2009 (UTC)


 * Is the disk at or near capacity? If you don't run your server yourself, you should contact your host; otherwise, start reading up on MySQL error 1114. —Emufarmers(T 20:50, 9 March 2009 (UTC)
 * Thanks, appearently my innodb file reached its configured max capacity of 128MB. Sillyness. I'll have to break out the tables into multiple files when I get a chance. -- Deltaray 12:53, 10 March 2009 (UTC)

Error when attempting full export of wiki with a postgres db
Hi, I am trying to do a full xml export of my wiki with the following command: php5 -d error_reporting=E_ERROR maintenance/dumpBackup.php --full After switching on exception reporting, I get this output: minotaur:/srv/www/htdocs/mediawiki-1.14.0 # php5 -d error_reporting=E_ERROR maintenance/dumpBackup.php --full  IzaziWiki http://minotaur/wiki/Main_Page MediaWiki 1.14.0 first-letter Media Special Talk User User talk IzaziWiki IzaziWiki talk File File talk MediaWiki MediaWiki talk Template Template talk Help Help talk Category Category talk Developers A database error has occurred Query: SELECT /*! STRAIGHT_JOIN */ * FROM page , revision , pagecontent WHERE page_id=rev_page AND rev_text_id=old_id ORDER BY page_id Function: WikiExporter::dumpFrom Error: 0 No database connection
 * MediaWiki version: 1.14.0
 * PHP version: 5.1.2 (apache2handler)
 * PostgreSQL version: 8.3.3 (running on a different machine)
 * URL: http://intranet.izazi.com/wiki (sorry, it is not open, but I can give you access if required)

Backtrace: From what I can gather it is because no database connection is available. However, my wiki appears to be fully functional. I can edit pages etc. I can even connect to the Postgres db using PgAdmin. I can only assume there is some additional settings I need to change when using a postgres database? Or is such an export not supported for Postgres? Please help.
 * 1) 0 /srv/www/htdocs/mediawiki-1.14.0/includes/db/Database.php(591): DatabasePostgres->reportQueryError('No database con...', 0, 'SELECT /*! STR...', 'WikiExporter::d...', false)
 * 2) 1 /srv/www/htdocs/mediawiki-1.14.0/includes/Export.php(260): Database->query('SELECT /*! STR...', 'WikiExporter::d...')
 * 3) 2 /srv/www/htdocs/mediawiki-1.14.0/includes/Export.php(95): WikiExporter->dumpFrom('')
 * 4) 3 /srv/www/htdocs/mediawiki-1.14.0/maintenance/backup.inc(207): WikiExporter->allPages
 * 5) 4 /srv/www/htdocs/mediawiki-1.14.0/maintenance/dumpBackup.php(63): BackupDumper->dump(0, 0)
 * 6) 5 {main}

—Johan Hoogenboezem 07:47, 19 March 2009 (UTC)


 * Did you set up AdminSettings.php?. —Emufarmers(T 08:16, 19 March 2009 (UTC)
 * Boy, you're quick. I just tried it and came back to close the issue before someone read it :-). That solved the problem all right. Thanks for the help. Johan Hoogenboezem 08:23, 19 March 2009 (UTC)

MySQL returned error "1205: Lock wait timeout exceeded"

 * MediaWiki version: mediawiki-1.14.0
 * PHP version: PHP Version 5.2.6
 * MySQL version: MySQL client version: 4.1.11
 * URL: http://wiki.freeearth.org.cn/index.php?title=FC22Q来A去
 * Server version: 4.1.25-Debian_mt1

I can login successfully. When I edit a page, I can see preview. But when I want to save page, it shows the error below: 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 "1205: Lock wait timeout exceeded; try restarting transaction (localhost)".

Then I logout, and wait for hours. I login and try to save the page again, it also breaks..

Util now, I cannot edit the page anymore.(I try to use another user name, it breaks also) The page was locked forever..

Any help would be appreciated.

thank you, Michael

—Wxiluo 09:01, 22 March 2009 (UTC)


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

Database error

 * Wiki location: http://www.larp.pl/
 * SQL errorrs: http://www.larp.pl/Fantazjada
 * http://www.larp.pl/Kategoria:LARP
 * Version: http://www.larp.pl/Specjalna:Wersja

Pls help. Abdel

—79.184.179.156 14:23, 3 April 2009 (UTC)

SELECTing and INSERTing pages vom Outside into WikiDB

 * MediaWiki version: 1.5
 * PHP version: 5
 * MySQL version: 5
 * URL: (internal)

Is it possible to insert and query pages from a program other than MediaWiki? MediaWiki-Pages should be integrated in another project like SELECT * FROM (???) WHERE [Pagetitle] LIKE '10--%' or INSERT INTO (???) VALUES (Title, Pagecontent);

—88.77.128.127 14:04, 6 April 2009 (UTC)

Statistics page is broken

 * MediaWiki version: 1.14.0
 * PHP version: 5+
 * MySQL version: 5+
 * URL: http://wikademia.org/Special:Statistics

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 "SiteStatsUpdate::cacheUpdate". MySQL returned error "1054: Unknown column 'ss_active_users' in 'field list' (mysql.wikademia.org)". My statistics page does not work.

—Wikademia 07:11, 13 April 2009 (UTC)

Media Wiki is blank after upgrading MySQL version

 * MediaWiki version: 1.13.3
 * PHP version: 5.2.9
 * MySQL version: 5.0.67-community
 * URL: http://podcast.eternaltruthministry.com

We have been running fine on MySQL 4 for a while now, but today when I went to my site it was completely blank. It has no record of any page and says my user id does not exist.

My first thought was that I got hacked, so I checked and my database size is the same as my backups, and all data looks like it is there in the current db.

I checked the db connection settings in the LocalSettings.php file and everything looks good there. What's weird is that there are no mysql connection errors, or errors of any kind displaying.

So why I mentioned MySQL 4, this week my host upgraded all of their servers to mysql 5. It is the only change to the system that I can find, but I don't know why this doesn't work anymore.

I'm having the same problem on 3/4 of my MediaWiki sites (http://www.ipTVwiki.com & http://www.zssites.net/wiki).

Do you have any ideas what I can check or what might be causing this problem?

Thank you.

—MasterZ 01:36, 14 April 2009 (UTC)


 * MediaWiki version: 1.12.0
 * PHP version: 5.2.4 (apache2handler)
 * MySQL version: 5.0.45-community-nt
 * URL:

how to create new tables which i need to use in an extension? any standard / recommended practice to create new tables and use it in a extension?

—192.8.211.11 11:04, 14 April 2009 (UTC)

Searching the wiki
Searching the WIKI Hi I am not sure I posted in the right sections sorry if it is not. I am trying to search my wiki for ip addresses, however only i keep getting results that in terms of posts made by that ip address. I wish to obtain posts that contain the ip address I am looking for. Any help obtained will be fully appreciated.
 * MediaWiki version:1.13.2
 * PHP 5.1.6 (apache2handler)
 * MySQL 5.0.27

—200.125.161.205 12:38, 21 April 2009 (UTC)

Wiki Encoding Problem

 * MediaWiki version: 1.13.3
 * PHP version: 5.2.6
 * MySQL version: 5.0.22
 * URL: http://wiki.balata-albalad.org/

I have the same problem as here: http://www.mediawiki.org/wiki/Project:Support_desk/Archives/Database/001#.28RESOLVED.29_Wiki_Encoding_Problem

I installed the wiki on my localhost and it worked fine, but I installed it on my webserver: http://wiki.balata-albalad.org/

it gives me:

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.

I am using Arabic, and it's the first time I am installing on my webserver, any help please..

PS:

it works fine using the link:

http://wiki.balata-albalad.org/index.php?title=الصفحة_الرئيسية

but it displays that error if I used:

http://wiki.balata-albalad.org/

Thanks in advance --Ibro84 14:37, 30 April 2009 (UTC)

Problem with MSSQL connection

 * MediaWiki version: 1.14.0
 * PHP version: 5.2.9
 * MySQL version:
 * MSSQL version: SQL Server 2005 Express edition
 * URL:

I have a setup where on one system I have MSSQL server 2005 express edition and on another system I have the wiki in IIS 5.1 on Windows XP Pro SP2 system. I have run the mediawiki setup on that system and also got the LocalSettings.php file also. Now when I try to open the mediawiki site I get only a blank page.

I did some debugging and found out where the problem is coming. The problem is in WebStart.php file in the line of code where we load the LocalSettings.php file. "require_once("$IP/LocalSettings.php");" Till this line every debug statements are printed but anything after this line is not getting printed. Can you please let me know what could be the problem and is there any solution or workaround?


 * Sounds like you're hitting a non-resolvable error; check the error log for details and post them back here if that doesn't clear up the problem for you?

—59.163.223.130 10:37, 20 May 2009 (UTC)

Answer to Problem with MSSQL connection
SQL Name: MYSQL Username: WHAT EVERY YOU USE TO LOGIN TO MYSQL Password:WHAT EVERY YOU USE TO LOGIN TO MYSQL DB Name: Somthing like "Wike" Make shour it is the name when you install.

Articles are not shown in the right Namespace

 * MediaWiki version: 1.13.3
 * PHP version: 5.2.8
 * MySQL version: 5.1.30
 * URL: intranet

Some weeks ago, I defined some customized namespaces and everything worked fine. But now I have a problem: Let's say one namespace I recently defined is called "NewNamespace". Now I want to create a new article within this namespace, let's say "NewNamespace:HelloWorld". Then what happens is, that the new article is stored in the (Main) namespace with title "NewNamespace:HelloWorld", but not in the "NewNamespace". The strange thing about it is, that the articles which are already in the "NewNamespace" still work fine, so I don't think that it's a problem with the namespace definition. Can you help me? Do you have an explanation for this?

PS: I checked about a hundred times that I don't have any typing errors within the article's name, so this easiest explanation drops out as well PSS: A friend of mine just told me that he has the same problem (he uses MW 1.14)

—62.157.208.213 12:41, 3 July 2009 (UTC)


 * How did you go about "defin[ing] some customized namespaces"? What config variables have you set? Happy ‑ melon 13:39, 3 July 2009 (UTC)

(RESOLVED) Database Error, Not able to block IP addy

 * MediaWiki version: 1.14.0
 * PHP version: 5.2.5 (cgi-fcgi
 * MySQL version: 4.1.22-max-log
 * URL: http://innewscenter.net/wiki

When I tried to block an IP address/username, I got this message:

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 "Block::insert". MySQL returned error "1054: Unknown column 'ipb_allow_usertalk' in 'field list' (p41mysql169.secureserver.net)". Retrieved from "http://www.innewscenter.net/wiki/index.php?title=Special:Block"

—Nsgaeverine 11:43, 13 July 2009 (UTC)


 * Looks like you didn't run the update script, update.php. You can fix this issue either by running update.php (preferred) or manually applying /maintenance/archives/patch-ipb_allow_usertalk.sql against your wiki's database. --Jack Phoenix (Contact) 12:03, 13 July 2009 (UTC)


 * I just upgraded to MediaWiki version 1.15.0 and the symtom has been fixed. Nsgaeverine 04:57, 14 July 2009 (UTC)

(RESOLVED) is it possible to "delete" archived articles and images?

 * MediaWiki 	1.15.1
 * PHP 	       5.2.5 (cgi)
 * MySQL 	       5.0.77mm0.1-log
 * URL:          http://clev9.com/~platfor1/sandboxlj/index.php?title=Main_Page

Hi -

We have a MediaWiki site hosted at siteground, so I only have the usual CPanel access to the database.

We use the site as online help for a software product, and we want to benchmark the wiki contents to a software version. To do this, we would like to clean out any "old" content, including text articles and images.

I would appreciate any information you may have.

—Applicationswhisperer 22:45, 19 August 2009 (UTC)


 * ——I found this extension and will try it: Extension:SpecialDeleteOldRevisions2
 * ——Applicationswhisperer 18:22, 20 August 2009 (UTC)