Project:Support desk/Archives/Database/002

From MediaWiki.org
Jump to: navigation, search
This is an archive of past discussions.
Archive
Please do not edit the contents of this page. If you wish to start a new discussion or revive an old one, please do so on the current talk page.

Contents

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

  • MediaWiki version: SVN build TortoiseSVN
  • PHP version: LATEST
  • MySQL version: LATEST
  • URL:

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)

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

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!

  • 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|C) 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|C) 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

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 require_once("$IP/extensions/UserRightsList/UserRightsList.php");Emufarmers(T|C) 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|C) 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|C) 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

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: 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?
GRANT ALL PRIVILEGES ON `your-mediawiki-database-name` . * TO 'bnl'@'localhost';

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


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|C) 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[1]; 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|C) 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"
  • 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

  • MediaWiki version: 1.13.4
  • PHP version: 5
  • MySQL version:
  • URL:

When i try editing any page by editing section wise, i get he following error


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

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)

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

# php update.php --aconf ../AdminSettings.php
MediaWiki 1.14.0 Updater

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:
#0 /x1/www/mediawiki-1.14.0/includes/db/Database.php(591): DatabasePostgres->reportQueryError('ERROR:  default...', 1, 'ALTER TABLE ipb...', '', false)
#1 /x1/www/mediawiki-1.14.0/maintenance/updaters.inc(1626): Database->query('ALTER TABLE ipb...')
#2 /x1/www/mediawiki-1.14.0/maintenance/updaters.inc(1068): do_postgres_updates()
#3 /x1/www/mediawiki-1.14.0/maintenance/update.php(62): do_all_updates(false, true)
#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

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

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

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
<mediawiki xmlns="http://www.mediawiki.org/xml/export-0.3/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.mediawiki.org/xml/export-0.3/ http://www.mediawiki.org/xml/export-0.3.xsd" version="0.3" xml:lang="en">
  <siteinfo>
    <sitename>IzaziWiki</sitename>
    <base>http://minotaur/wiki/Main_Page</base>
    <generator>MediaWiki 1.14.0</generator>
    <case>first-letter</case>
      <namespaces>
      <namespace key="-2">Media</namespace>
      <namespace key="-1">Special</namespace>
      <namespace key="0" />
      <namespace key="1">Talk</namespace>
      <namespace key="2">User</namespace>
      <namespace key="3">User talk</namespace>
      <namespace key="4">IzaziWiki</namespace>
      <namespace key="5">IzaziWiki talk</namespace>
      <namespace key="6">File</namespace>
      <namespace key="7">File talk</namespace>
      <namespace key="8">MediaWiki</namespace>
      <namespace key="9">MediaWiki talk</namespace>
      <namespace key="10">Template</namespace>
      <namespace key="11">Template talk</namespace>
      <namespace key="12">Help</namespace>
      <namespace key="13">Help talk</namespace>
      <namespace key="14">Category</namespace>
      <namespace key="15">Category talk</namespace>
      <namespace key="100">Developers</namespace>
    </namespaces>
  </siteinfo>
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

Backtrace:
#0 /srv/www/htdocs/mediawiki-1.14.0/includes/db/Database.php(591): DatabasePostgres->reportQueryError('No database con...', 0, 'SELECT  /*! STR...', 'WikiExporter::d...', false)
#1 /srv/www/htdocs/mediawiki-1.14.0/includes/Export.php(260): Database->query('SELECT  /*! STR...', 'WikiExporter::d...')
#2 /srv/www/htdocs/mediawiki-1.14.0/includes/Export.php(95): WikiExporter->dumpFrom('')
#3 /srv/www/htdocs/mediawiki-1.14.0/maintenance/backup.inc(207): WikiExporter->allPages()
#4 /srv/www/htdocs/mediawiki-1.14.0/maintenance/dumpBackup.php(63): BackupDumper->dump(0, 0)
#5 {main}

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.


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

Did you set up AdminSettings.php?. —Emufarmers(T|C) 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"

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

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

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

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

  • MediaWiki version:1.13.2
  • PHP 5.1.6 (apache2handler)
  • MySQL 5.0.27

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.




200.125.161.205 12:38, 21 April 2009 (UTC)


Wiki Encoding Problem

I have the same problem as here: 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? Happymelon 13:39, 3 July 2009 (UTC)

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

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?

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)

Updating to 1.15

How can I update the database from 1.14 to 1.15? I updated the files on the server but not the database files. When I try to edit the main 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 "IndexPager::reallyDoQuery (LogPager)". MySQL returned error "1146: Table 'baltow.bw_tag_summary' doesn't exist (baltow.baltowiki.com)".

Which I'm guessing is a new table that was added from 1.14 to 1.15.

137.104.121.136 22:34, 10 September 2009 (UTC)

Right. Run the update script. —Emufarmers(T|C) 00:23, 11 September 2009 (UTC)
Any way to do that without SSH? -72.160.221.185 05:13, 11 September 2009 (UTC)
Never mind I reran the installer and now it works, thank you! -72.160.221.185 16:49, 11 September 2009 (UTC)

Error importing revision.txt - Error: 1261, Row 1 doesn't contain data for all columns

  • MediaWiki version:
  • PHP version:
  • MySQL version: Ver 14.14 Distrib 5.4.1-beta, for Win64
  • URL:

I used the xml2sql tool from mediawiki to convert last year's wikipedia dump into text, page, and revision .txt files for import using mysqlimport. I set up my tables using the tables.sql file in the maintenance folder of the mediawiki distribution. I successfully imported text and page into the database g_dev but when I try to import revision I get the following error:

C:\ProgramData\MySQL\MySQL_Server_5.4\data\g_dev>mysqlimport -u root -p -f -v -r g_dev revision.txt
Enter password: ****
Connecting to localhost
Selecting database g_dev
Loading data from SERVER file: revision.txt into revision
mysqlimport: Error: 1261, Row 1 doesn't contain data for all columns, when using table: revision
Disconnecting from localhost

The head (20 lines) of the revision.txt file looks like:

C:\ProgramData\MySQL\MySQL_Server_5.4\data\g_dev>head -20 revision.txt
133452270       6       133452270       Revert edit(s) by [[Special:Contributions/Ngaiklin|Ngaiklin]] to last version by [[Special
:Contributions/Docu|Docu]]      241822  Gurch   20070525171206  1       0
133452279       8       133452279       Revert edit(s) by [[Special:Contributions/Ngaiklin|Ngaiklin]] to last version by [[Special
:Contributions/Rory096|Rory096]]        241822  Gurch   20070525171209  1       0
133452289       10      133452289       Revert edit(s) by [[Special:Contributions/Ngaiklin|Ngaiklin]] to last version by [[Special
:Contributions/Rory096|Rory096]]        241822  Gurch   20070525171212  1       0
215126027       12      215126027       /* External links */ remove link per WP:EL      2670733 Kni00080526204455
74466652        13      74466652        cat rd  750223  Rory096 20060908041552  0       0
74466619        14      74466619        cat rd  750223  Rory096 20060908041536  0       0
135089040       15      135089040       Robot: Fixing [[Special:DoubleRedirects|double-redirect]] -"Demographics of Afghanistan" +
"Demography of Afghanistan"     279219  RussBot 20070601135937  1       0
74466531        17      74466531        cat rd  750223  Rory096 20060908041458  0       0
74466499        18      74466499        cat rd  750223  Rory096 20060908041442  0       0
74466423        19      74466423        cat rd  750223  Rory096 20060908041407  0       0
74466354        20      74466354        cat rd  750223  Rory096 20060908041327  0       0
46448859        21      46448859        {{R from CamelCase}}    241822  Gurch   20060401120842  1  0
74466798        23      74466798        cat rd  750223  Rory096 20060908041700  0       0
74466889        24      74466889        cat rd  750223  Rory096 20060908041751  0       0
214727768       25      214727768       Add DOI for Francis 2005.       3573537 Eubulides       20000525001710
74467016        27      74467016        cat rd  750223  Rory096 20060908041856  0       0
74466319        28      74466319        cat rd  750223  Rory096 20060908041309  0       0
74466817        29      74466817        cat rd  750223  Rory096 20060908041712  0       0
74467061        30      74467061        cat rd  750223  Rory096 20060908041917  0       0
197516257       33      197516257       restore redirect.  No evidence of notability of the lothing00080311174540

The columns of table revision look like this:

mysql> show columns from revision;
+----------------+---------------------+------+-----+----------------+----------------+
| Field          | Type                | Null | Key | Default        | Extra          |
+----------------+---------------------+------+-----+----------------+----------------+
| rev_id         | int(10) unsigned    | NO   | PRI | NULL           | auto_increment |
| rev_page       | int(10) unsigned    | NO   | MUL | NULL           |                |
| rev_text_id    | int(10) unsigned    | NO   |     | NULL           |                |
| rev_comment    | tinyblob            | NO   |     | NULL           |                |
| rev_user       | int(10) unsigned    | NO   | MUL | 0              |                |
| rev_user_text  | varchar(255)        | NO   | MUL |                |                |
| rev_timestamp  | binary(14)          | NO   | MUL |                |                |
| rev_minor_edit | tinyint(3) unsigned | NO   |     | 0              |                |
| rev_deleted    | tinyint(3) unsigned | NO   |     | 0              |                |
| rev_len        | int(10) unsigned    | YES  |     | NULL           |                |
| rev_parent_id  | int(10) unsigned    | YES  |     | NULL           |                |
+----------------+---------------------+------+-----+----------------+----------------+
11 rows in set (0.01 sec)

If anyone can help on this, please let me know here or email me at daryl.woodward@gmail.com Thank you.


Hi,

I have this error :

Sorry! This site is experiencing technical difficulties. Try waiting a few minutes and reloading.

(Can't contact the database server: Unknown error (91.121.113.174:3306))

I'm sure the password and the ip are right.

Here the previous operations done :

  1. PHP 5.2.4-2ubuntu5.7 installed
  2. Found database drivers for: MySQL
  3. PHP server API is apache2handler; ok, using pretty URLs (index.php/Page_Title)
  4. Have XML / Latin1-UTF-8 conversion support.
  5. Session save path (/var/lib/php5) appears to be valid.
  6. PHP's memory_limit is 32M.
  7. Couldn't find Turck MMCache, eAccelerator, APC or XCache; cannot use these for object caching.
  8. Found GNU diff3: /usr/bin/diff3.
  9. Found GD graphics library built-in, image thumbnailing will be enabled if you enable uploads.
  10. Installation directory: /var/www/mediawiki-1.15.1
  11. Script URI path:
  12. Installing MediaWiki with php file extensions
  13. Environment checked. You can install MediaWiki.

Generating configuration file...

  1. Database type: MySQL
  2. Loading class: DatabaseMysql
  3. Attempting to connect to database server as root...success.
  4. Connected to mysql 5.0.51a-3ubuntu5.4; enabling MySQL 4.1/5.0 charset mode
  5. Attempting to create database...
  6. Created database wikidb1
  7. Creating tables... done.
  8. Initializing statistics...
  9. Granting user permissions to wikiuser on wikidb1...success.


192.44.77.39 07:11, 6 October 2009 (UTC)

Can't contact the database server

Hi,

I have this error :

Sorry! This site is experiencing technical difficulties. Try waiting a few minutes and reloading.

(Can't contact the database server: Unknown error (91.121.113.174:3306))

I'm sure the password and the ip are right.

Here the previous operations done :

  1. PHP 5.2.4-2ubuntu5.7 installed
  2. Found database drivers for: MySQL
  3. PHP server API is apache2handler; ok, using pretty URLs (index.php/Page_Title)
  4. Have XML / Latin1-UTF-8 conversion support.
  5. Session save path (/var/lib/php5) appears to be valid.
  6. PHP's memory_limit is 32M.
  7. Couldn't find Turck MMCache, eAccelerator, APC or XCache; cannot use these for object caching.
  8. Found GNU diff3: /usr/bin/diff3.
  9. Found GD graphics library built-in, image thumbnailing will be enabled if you enable uploads.
  10. Installation directory: /var/www/mediawiki-1.15.1
  11. Script URI path:
  12. Installing MediaWiki with php file extensions
  13. Environment checked. You can install MediaWiki.

Generating configuration file...

  1. Database type: MySQL
  2. Loading class: DatabaseMysql
  3. Attempting to connect to database server as root...success.
  4. Connected to mysql 5.0.51a-3ubuntu5.4; enabling MySQL 4.1/5.0 charset mode
  5. Attempting to create database...
  6. Created database wikidb1
  7. Creating tables... done.
  8. Initializing statistics...
  9. Granting user permissions to wikiuser on wikidb1...success.


192.44.77.39 07:13, 6 October 2009 (UTC)


EDIT ; Problem is resolved !

The install was stopped here :


 if ( $conf->Root ) {
   $conn = $dbc->newFromParams( $wgDBserver, $wgDBuser, $wgDBpassword, $wgDBname, 1 );
   if ( $conn->isOpen() ) {
     print "DB user account ok\n";
     $conn->close();
   } else {
     print "Granting user permissions...";
     if( $mysqlOldClient && $mysqlNewAuth ) {
     }
     print "\n";
     dbsource( "../maintenance/users.sql", $wgDatabase );
   }
 }


I used a new user that would be created bu my root user. I change my options of the install by using the root user, now it works good.


backups just stopped working

hello. As of 10/6, the backups seemed to be working just fine. Then, all of a sudden backups seemed to just stop working. The site works fine and so does the web GUI, but the backups just will not run whether run manually or during the scheduled backup timeframe. This is what I get in the Appliance Log now.

Thu, 08 Oct 2009 12:47:49 EDT Failed: A permanent failure has occurred: Shell command "tar -rpST /tmp/raa-backup-filesvrTwN6.lst --ignore-failed-read -f /tmp/raa-backup-ieepOi.tar" exited with exit code 2 Backup and Restore Error

Any help I can get would be greatly appreciated. MediaWiki version: 2.0.3


--192.44.77.39 07:34, 6 October 2009 (UTC)

External 'USER' table

  • MediaWiki version: 1.51
  • PHP version: 5.2
  • MySQL version: 5.1

I want to build a few projects of wiki, but i want that the users will register once. how did i make cooperative 'USER' table for several projects?

Add the user table to $wgSharedTables -- Bryan (talk|commons) 15:10, 20 October 2009 (UTC)

merging two different wikimedia databases

  • MediaWiki version: 1.14
  • PHP version: 5.1.6
  • MySQL version: 5.0.45
  • URL:

We have two different wikimedia systems on two different servers (both have the same versions for MediaWiki, PHP and MySQL) and now we want to merge them into a single wiki system on one of the server. The problem is, I can't just restore a dump file since both databases have the same ids for different pages and images, and with 870 uploaded images, the idea of manually editing the dump file doesn't seem so charming. Is there a way to merge both databases and somehow automatically change the ids? Or is the best way simply copying the pages from one wiki to the other and re-uploading the images?

Update: I tried adding some INSERT lines from one dump to the other (the key columns are different, so there's no problem here) and restoring that dump. It seems to work fine, but with a small problem: any Hebrew link is in gibberish, instead, and links to a page with that Gibberish name, so I don't think it's just an encoding problem.


FishyWorm 14:31, 22 October 2009 (UTC)

How does the image system work?

  • MediaWiki version: 1.15.1
  • PHP version: 5.2.6
  • MySQL version: 5.0.51a  
  • URL: no can do

I have what should be a fairly simple question... I consider myself very well-rounded in mediawiki administration, but there is ONE thing that I cannot figure out how it works. Could anyone please explain where in the database images and files are linked to their physical file? Or direct me to the appropriate info. I have searched everywhere to figure out how this works but to no avail. I would like to know because porting a large amount of files or images would be made much easier if it could be batched in SQL.


Bsmithme 21:48, 28 October 2009 (UTC)

SQLite installed, but configure/index.php says no

  • MediaWiki version: 1.15.1
  • PHP version: $ php -v reports PHP 5.1.6 (cli) (built: Feb 26 2009 07:01:12)
  • MySQL version: ]$ sqlite3 -version reports 3.3.6

config/index.php reports "PHP 5.1.6 installed Could not find a suitable database driver!", yet SQLite is installed and supported by PHP:

$ php -i | grep -i ^configure | tr ' ' \\n | grep sqlite
'--without-sqlite'
'--with-pdo-sqlite=shared,/usr'

Is that sufficient? How can I test the database support independently, and/or diagnose why MediaWiki thinks it's not there? (I've never used PHP, famous as it is. I found several examples of PHP code to prove SQLite works, but none to display an error message when it doesn't.)

FWIW, I also put this in LocalSettings.php:

error_reporting(E_ALL);
ini_set("display_errors", 1);

$wgDebugLogFile  = '/tmp/mediawiki.debug_log.txt';

Many thanks.

206.218.223.52 17:36, 30 October 2009 (UTC) jkl

After an IRC discussion, it looked like that PDO support was needed. Max Semenik 12:00, 31 October 2009 (UTC)

Database Syntax error - tables not available ---- DONE

  • MediaWiki version: previously 1.11, upgraded now to 1.15.1
  • PHP version: 5.2.3
  • MySQL version: 5.0.27


I recently upgraded to MediaWiki 1.15.1. I face the following issue when I click on the 'history' tab or some other links on the page:

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 "ChangeTags::listDefinedTags". MySQL returned error "1146: Table 'erwikidb.valid_tag' doesn't exist (localhost)".

and on other pages I get - from within function "IndexPager::reallyDoQuery (LogPager)". MySQL returned error "1146: Table 'erwikidb.tag_summary' doesn't exist (localhost)".

and so forth..

When I checked the database I found that the tables valid_tag and tag_summary weren't created at all. I have run the installer again on my server for a fresh installation of 1.15.1 and have run the update.php script several times, but the same error keeps popping up.

SOLN - Sorry, the error was in my database administration. I had to create a new user with same privileges, or use the superuser account


Srutsam 18:39, 6 November 2009 (UTC)

Database error - "MediaWikiBagOStuff::_doquery"


This is the error message:
Database error
From Z-Wiki, your global connection to relevancy.

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 "1030: Got error 134 from storage engine (mysql)". Retrieved from "http://www.zamboanga.com/z/index.php?title=Rawda_S._Mustafa"

--Kuhitkuhit 18:31, 10 November 2009 (UTC)

The whole wiki is down

  • Now the whole Wiki is down. Over 40,000 pages can't be accessed.
  • Nobody can login.
  • This is the message we get no matter where anyone goes.

Database error
From Z-Wiki, your global connection to relevancy.

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 "1016: Can't open file: 'mz_objectcache.MYI' (errno: 145) (mysql)". Retrieved from "http://zamboanga.com/z/index.php?title=Main_Page"

Your database seems to be damaged. Refer to MySQL documentation on how to correct it, or restore from backup. Max Semenik 07:19, 11 November 2009 (UTC)
I resolved the problem by repairing the database. However, I suspect that the upload failure of images is causing this database corruption. This file was uploaded and there is an error: http://www.zamboanga.com/z/index.php?title=Image:Bolong_zamboanga_city_fun_in_sun_01.jpg

I think the easy solution is to delete this. But I do not how to delete this since I can't access the page at all. So, How do I delete a page without accessing it?

search finds some but not all pages

  • MediaWiki version: 1.13.2
  • PHP version: 5.2.6
  • MySQL version: 5.0.67-community-nt
  • URL: intranet only

My company has a MW installation that is working well for the most part. The only problem is that when searching, some words are not found in some articles that contain the word.

For example, searching for "xRon" or "boxing" or "Montreal" finds a list of articles that contain the word, but there is at least one article that contains all 3 of these words and that article is not in the search results. However, searching for "coupons" or "incentives" or "staples" does include this article in the search results.

I have tried the following:

What else can I do to get these articles found?

198.161.248.1 20:23, 16 November 2009 (UTC)

I found the solution. The article contained a less than sign (<), and later contained a greater than sign (>). MediaWiki thought this was a big HTML tag. The words between these 2 characters did not get indexed.
Temporary fix: Use a <nowiki> tag around the special characters.
Permanent fix: Upgrade MediaWiki to v1.15.1.

Can't access original database tables

MediaWiki 1.15.1

PHP 5.2.11 (apache)

MySQL 4.1.22

I upgraded to 1.15.0 and more recently to 1.15.1.

I had to use the re-installation route as I don't have root access to the host.

My problem is that I can't see the original pages that had been written. When I use phpMyAdmin to look at the database the tables seem to have been renamed. E.g. there is a table called page, containing the new page, and another called mw_page that contains the original.

I guess that I made a mistake setting up the re-install and didn't put the prefix in. I have tried repeating the reinstall and putting the prefix in but still can't see the old pages.

Is there a way of changing the tables that the wiki uses?

Alternatively, can I rename the tables in the database or just duplicate the data?

thanks

Dan

78.86.176.72 10:49, 27 November 2009 (UTC)

Edit LocalSettings.php and set $wgDBprefix = "mw_";. Then your wiki will use the original tables. Platonides 21:40, 29 November 2009 (UTC)

SQL error on Quercus

  • MediaWiki version: 1.14
  • PHP version: Quercus 4.0.2
  • MySQL version: 5.1.39
  • URL: local


After installation/configuration I try to edit main page and get:

INSERT INTO `qqqtext` (old_id,old_text,old_flags) VALUES (NULL,'\'\'\'MediaWiki has been successfully installed.\'\'\'\n\nConsult the User\'s Guide for information on using the wiki software.\n\nI was here!!!\n\n\n== Getting started ==\n* Configuration settings list\n* MediaWiki FAQ\n* MediaWiki release mailing list','utf-8') SQL ERROR: Column 'rev_user_text' cannot be null (localhost)

Is this a bug in Quercus, perhaps?


84.215.65.208 19:00, 29 November 2009 (UTC)

Quercus is not officially supported. It may or may not work, but there were no reports of such bug under normal PHP. Max Semenik 17:48, 30 November 2009 (UTC)

Change page_title in the page table

  • MediaWiki version: 14.1
  • PHP version: 
  • MySQL version: 
  • URL:

Dear MediaWiki Support,

is it possible to change the page_title in the page table or could this result in errors or other sideeffects. The reason why Im asking is, that I saw the page title also in other tables. But when I change the title in most cases its not sure that it would be changed in the other table. Hope you understand what I mean.

Many thanks Steve


217.110.99.237 08:25, 13 January 2010 (UTC)

  • MediaWiki version: recent
  • PHP version: 5
  • MySQL version: 5
  • URL:

while upgrading MySql, I accidently uninstalled MySql..

Is there any way I can restore the pages?

I got all other files like image, video

Does MediaWiki really stores all the text files in the MySql DB?

I am so miserable

147.46.112.181 15:10, 14 January 2010 (UTC)

Using database + slave

  • MediaWiki version: 1.16alpha
  • PHP version: 5.2.9 (cgi)
  • MySQL version: 5.0.45

Hi,

I want to use one maindatabase and 1 slave so I should use the stuff written as on: Manual:$wgDBservers right?

But if I create the database that is going to be the slave should I be sure its complete up to date or will it copy itsself?

Or is there a easy way to make a copy?

Best regards,

84.241.164.33 16:15, 18 January 2010 (UTC)

Migration from SQLite TO MYSQL

  • MediaWiki version: 1.15  
  • PHP version:  php-5.3.1-nts-Win32-VC9-x86
  • MySQL version: mysql-5.1.40-win32
  • URL:


Hello,

I migrated my wiki in order to roll on a given Mysql instead of SQLite it's work well except for links, images and attach files, can you help me to solve my problem

Thank you


142.213.254.2 18:49, 17 December 2009 (UTC)

How can I migrate from mysql to sqlite ?78.138.154.133 17:36, 21 January 2010 (UTC)

Error 1054 (Sha1) followed by MediaWiki internal error. Exception caught inside exception handler as I upgraded from version 1.10 to 1.15.1

  • MediaWiki version: upgraded from 1.10 to 1.15.1
  • PHP version: 5.X
  • MySQL version: 4.1
  • URL: www.questions-science.com

I copied all files from Wiki 1.15.1 to the server to replace the files from version 1.10, and at first got a 1054 error (relative to Sha1 in SQL database), I installed the FlaggedRevs 1.15 files as the MediaWiki error FAQ seemed to suggest, still got the error, and since recently get a MediaWiki internal error. Exception caught inside exception handler error. Can someone please help? I also cannot access the line command function, and just use FileZilla to upload my files. Thanks in advance !

72.138.10.140 00:07, 15 February 2010 (UTC)

Update from 1.3.9 (latin1) to 1.15.1 (UTF8) - problem with converting latin to utf8

  • MediaWiki version: upgraded from 1.3.9 to 1.15.1
  • PHP version: 5.x
  • MySQL version: 4.x
  • URL: not public

I make an update via web. After update i have encoding-errors in some (not all!) sections: e.g. Special:ListFiles (Comments), RecentChanges etc. The Main-Content (?title=Mainpage) is ok. No Problems mit Umlauts, Special-Chars. On some pages i get a Collation-Error. (search in ListFiles a Filename with Umlaut) Look @ Database: many Table/Rows has collation latin1 (why?!). I change it manually to utf8-bin/general => collation-errors are fixed. I make a Dump from "images" with mysqldumper (webbased tool), i say his encoding is "latin1". I opened the .sql with notepad++ (windows) and change format from ansi to utf8/boms. Import with mysqldumper. Now: no Encoding-Errors in Special:ListFiles. Fine! Same withe the revision-Table. No Errors in History. Fine! Have I do this with EVERY Table?! :( (49 after update, fresh install 41 ... normal?)

But whats the problem with update-procedure? Only some Tables are converting. Only some rows are utf8 :( How i can update correctly to 1.15.1 utf8 ?. Before update -> dump (latin1) -> convert to utf8 -> import sql -> update? 1-2 Years ago this doesn't work :( Pagenames with Umlauts are broken und many encoding-Errors! :((

Sorry for my bad englisch :( Thanks in advance

  • MediaWiki version: 
  • PHP version: 
  • MySQL version: 
  • URL:

The following error popped up during my install process. I have been unable to fix this. Please help!

   * PHP 5.3.2 installed
   * Found database drivers for: PostgreSQL SQLite
   * PHP server API is apache2handler; ok, using pretty URLs (index.php/Page_Title)
   * Have XML / Latin1-UTF-8 conversion support.
   * Session save path (/var/lib/php/session) appears to be valid.
   * 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.
   * Found ImageMagick: /usr/bin/convert; image thumbnailing will be enabled if you enable uploads.
   * Installation directory: /var/www/html/wiki
   * Script URI path: /wiki
   * Installing MediaWiki with php file extensions
   * Environment checked. You can install MediaWiki.
   *
     Generating configuration file...
   * Database type: PostgreSQL
   * Loading class: DatabasePostgres
   * Attempting to connect to database "postgres" as superuser "andyyen"...
   * Checking the version of Postgres...version 8.1.18 is OK.
   * User "wikiuser" already exists, skipping account creation.
   * Database "wikidb" already exists, skipping database creation.
   * Connecting to "wikidb" as superuser "andyyen" to check rights...OK
   * Checking that tsearch2 is installed in the database "wikidb"...OK
   * Ensuring that user "wikiuser" has select rights on the tsearch2 tables...OK
   * Schema already exists, explicitly granting rights... OK
   * Checking for Pl/Pgsql ...OK
   * Attempting to connect to database "wikidb" as "wikiuser"...
   * Checking the version of Postgres...version 8.1.18 is OK.
   * Checking for tsearch2 in the schema "public"...OK
   * Checking tsearch2 permissions...OK
   * Verifying tsearch2 locale with en_US.UTF-8...not found
   * Attempting to set default tsearch2 locale to "en_US.UTF-8"... Warning: pg_query(): Query failed: ERROR: permission denied for relation pg_ts_cfg in /var/www/html/wiki/includes/db/DatabasePostgres.php on line 580 FAILED. Please make sure that the locale in pg_ts_cfg for "default" is set to "en_US.UTF-8"


131.215.22.175 12:07, 9 March 2010 (UTC)

All tables are populated, but I can't get the text to show

After moving my wiki, I can't get the text to show. Tried rebuilding the text index, refreshing links... nothing is fixing it. I'm pretty new at this and could really use some help.

Thanks.

DPM

88.252.140.240 03:19, 17 March 2010 (UTC)


So, it seems that the database backed up, but I have to do an xml dump from the old location and import it to the new one. mwdumper seems to be just the tool...if only I could figure out how to use it.

You know, guys, a basic manual for beginners would be a good idea.

issues upgrading to 1.15.2

  • mediawiki version [old]: 1.11.0 and 1.11.2
  • mediawiki version [new]: 1.15.2
  • php version: 5.2.6
  • mysql version: 5.0.67

INDEX command denied to user

i am trying to upgrade a number of wikis [1.11.0 and 1.11.2] to 1.15.2. on virtually all the upgrades i am getting an error:

MySQL returned error "1142: INDEX command denied to user '$WIKIadm'@'localhost' for table 'pagelinks' (localhost)"

the problem being that on each of them, when i go into mysql and issue a show grants, all of those users have INDEX:

mysql> show grants for '$WIKIadm'@'localhost';
+---------------------------------------------------------------------------------------------------------------+
| Grants for $WIKIadm@localhost                                                                                 |
+---------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO '$WIKIadm'@'localhost' IDENTIFIED BY PASSWORD '$PASSWORD'                               |
| GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER, LOCK TABLES ON `$WIKI`.* TO '$WIKIadm'@'localhost'       |
+---------------------------------------------------------------------------------------------------------------+
2 rows in set (0.01 sec)

i don't quite understand the error, considering mysql seems to think i have the necessary access.

-Zeefreak 18:19, 2 April 2010 (UTC)

Accidentally deleted database

Hi, After just installing MediaWiki and setting everything up I accidentally deleted the database (good news, I didn't lose anything). Now, though, nothing works. Is there a way to easily create a new database with everything needed for my site to run?

resolution

i think if you remove or rename ./LocalSettings.php and then just go to your wiki you can rerun the config. that will recreate all the tables for you.

Zeefreak 18:13, 5 April 2010 (UTC)

No text on page, no user account!

  • MediaWiki version: 1.13.2
  • PHP version:  5.2.13 (cgi-fcgi)
  • MySQL version:  5.0.89-userstats-log
  • URL: http://mountmoriah.info/

Website now reports "Login error: There is no user by the name "Jellings". Check your spelling." when trying to login.

Also, pages with known content now report "There is currently no text in this page, you can search for this page title in other pages or edit this page"

Here is a dump from logfile:

GET /index.php?title=Thomas_Jones_%28%3F-%3F%29
Main cache: FakeMemCachedClient
Message cache: MediaWikiBagOStuff
Parser cache: MediaWikiBagOStuff
session_set_cookie_params: "0", "/", "", "", "1"
Zend Optimizer detected; skipping debug_backtrace for safety.
Unstubbing $wgUser on call of $wgUser->isAllowed from unknown
Zend Optimizer detected; skipping debug_backtrace for safety.
Unstubbing $wgMessageCache on call of $wgMessageCache->addMessages from unknown
Zend Optimizer detected; skipping debug_backtrace for safety.
Unstubbing $wgParser on call of $wgParser->setHook from unknown
Zend Optimizer detected; skipping debug_backtrace for safety.
Unstubbing $wgContLang on call of $wgContLang->getMagic from unknown
MimeMagic::__construct: loading mime types from /home/jellings/wiki.mountmoriahcemetery.org/includes/mime.types
MimeMagic::__construct: loading mime info from /home/jellings/wiki.mountmoriahcemetery.org/includes/mime.info
Fully initialised
Article: Thomas Jones (?-?)
Connecting to db.mountmoriahcemetery.org mountmoriahwiki...
IP: *.*.54.49
Connected
Zend Optimizer detected; skipping debug_backtrace for safety.
Unstubbing $wgOut on call of $wgOut->setSquidMaxage from unknown
Language::loadLocalisation(): got localisation for en from source
Zend Optimizer detected; skipping debug_backtrace for safety.
Unstubbing $wgLang on call of $wgLang->getCode from unknown
Connecting to db.mountmoriahcemetery.org mountmoriahwiki...
Connected
MessageCache::load: Loading en... cache is empty, loading from database
OutputPage::checkLastModified: CACHE DISABLED, NO TIMESTAMP
Article::tryFileCache(): not cacheable
Article::view using parser cache: no
Zend Optimizer detected; skipping debug_backtrace for safety.
OutputPage::sendCacheControl: private caching;  **
Request ended normally

It doesn't look like there is anything problematic in the logfile; I enabled PHP error reporting on the site and there were none.

I'd appreciate any advice.

John.ellingsworth 16:01, 25 April 2010 (UTC)


Resolved

  • MediaWiki version: 1.15.3
  • PHP version: 5.0.5 (cgi)
  • MySQL version: 5.0.77mm0.1-log
  • URL: www.wilcommscan.com

I am having the same issue as above user (John Ellingsworth).
No errors exist in Cpanel.
Content still exists in database.
Looks like mediawiki has lost access to db but using special:allpages I can view page titles.
What gives? Anyone?


Resolution: via Cpanel, I checked the database. Lots of notices:
[database].[table] error : Table upgrade required. Please do "REPAIR TABLE `[table]`" to fix it!
Ran the required REPAIR TABLE on tables. Now my wiki loads beautifully!


Fraser.Wilkinson 05:57, 5 May 2010 (UTC)



80.191.89.41 09:26, 3 May 2010 (UTC)

<! - IMPORTANTE: Preencha o "Assunto / cabeçalho" caixa acima. Em seguida, vá no seu wiki Special: Versão página e sua nota a informação de versão de software abaixo. ->

  • Versão do MediaWiki:
  • Versão do PHP:
  • Versão do MySQL:
  • URL:

<! - Agora, por favor informe o seu erro, ou pedir o seu apoio pergunta abaixo. (Você pode remover esta linha antes de salvar.) ->



<! - O pouco que se seguem serão convertidos para uma assinatura com hora e data. (Você pode remover esta linha antes de salvar.) -> -

[Resolved] Database returned error "1: no such table: page"

  • MediaWiki version: 1.15.4 – 2010-05-28
  • PHP version: 5.2.6-1+lenny8
  • SQLite version: phpinfo says: 2.8.17
  • URL: https://f4bs.eu/
   Please include all of the lines below when reporting installation problems.
   * PHP 5.2.6-1+lenny8 installed
   * Found database drivers for: SQLite
   * PHP server API is cgi-fcgi; using ugly URLs (index.php?title=Page_Title)
   * Have XML / Latin1-UTF-8 conversion support.
   * Session save path (/var/lib/php5) appears to be valid.
   * PHP's memory_limit is 128M.
   * APC installed
   * Found GNU diff3: /usr/bin/diff3.
   * Found ImageMagick: /usr/bin/convert; image thumbnailing will be enabled if you enable uploads.
   * Installation directory: /var/www/secure/1
   * Script URI path: /1
   * Installing MediaWiki with php file extensions
   * Environment checked. You can install MediaWiki.
     Generating configuration file...
   * Database type: SQLite
   * Loading class: DatabaseSqlite
   * Attempting to connect to SQLite database at "data"ok
   * Connected to sqlite 3.5.9
   * Creating tables... done.
   * Initializing statistics...
   * Created sysop account WikiSysop.
     Creating LocalSettings.php...
     Installation successful! Move the config/LocalSettings.php file to the parent directory, then follow this link to your wiki.

When accessing https://f4bs.eu/ i get 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 "MessageCache::loadFromDB". Database returned error "1: no such table: page".

update: phpinfo says also:

pdo_sqlite
PDO Driver for SQLite 3.x       enabled
PECL Module version     1.0.1 $Id: pdo_sqlite.c,v 1.10.2.6.2.3 2007/12/31 07:20:10 sebastian Exp $
SQLite Library  3.5.9 

195.212.29.187 14:51, 3 June 2010 (UTC)

This is a bug in installer that has already been fixed in 1.16 branch. You need to move your databse file /var/www/secure/1/config/data/wikidb.sqlite to some directory not readable by web server and modify $wgSQLiteDataDir in LocalSettings.php to make it point to that directory. By the way, MediaWiki 1.16 that will be released soon will contain massive SQLite-related improvements, so upgrade is a must. Max Semenik 17:42, 3 June 2010 (UTC)
installed MediaWiki 1.16.0beta3 —195.212.29.187 11:18, 4 June 2010 (UTC)

Convert From MyISAM to InnoDB

  • MediaWiki version: 1.16beta3
  • PHP version: 5.2.11
  • MySQL version: 5.1.47-log
  • URL: http://ww.softx.tk/

I moved my wiki to another hosting company. The old one doesn't support InnoDB so I have to use MyISAM. The new one does. So I want to convert my database to InnoDB, but how?


Xiaomao123 16:11, 19 July 2010 (UTC)

Database Error 1205 when accessing a particular Article in my Wiki

  • MediaWiki version: 1.16.0
  • PHP version: 5.2.6 (cgi-fcgi)
  • MySQL version: 5.1.26-rc-5.1.26rc
  • URL: http://konton.us/wiki

Hey there. I installed a copy of mediawiki on my server a couple of days ago and began having fun with my wiki. However, a couple of hours later, something happened with one article I was writing and it seemingly got corrupted. To be precise, I began writing an article, used the preview function several times, had to answer the door and left the computer on for 20+ minutes, then came back, edited some more and clicked 'save changes'. The article did not save and everything slowed down to a crawl. I got so tired of this that I deleted my whole installation and database and tried it all over again. I didn't stumble upon the same error until now, 2 days later. The same thing happened, I was editing an article, I had to go out, came back, changed the text and pressed save again. From the looks of it 'merely my guess', something odd happens with the article updating and the session timeout which 'corrupts' the article. If I wait 5-10 minutes, I can log out and then view ALL other articles, but not the one in question.

After clicking 'save changes', I had a blank page and was then taken to this URL: http://konton.us/w/index.php?title=Gameplay_Mechanics&action=submit

And the error message there was: 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::updateRevisionOn". Database returned error "1205: Lock wait timeout exceeded; try restarting transaction (internal-db.s76387.gridserver.com)".

So my guess is that...the article became somehow corrupted? How do I uncorrupt it? I googled like crazy and searched everywhere and...I don't seem to be able to find someone with this particular problem =/

All help is appreciated. G.Campos


189.138.166.137 15:42, 3 August 2010 (UTC)

Database error when registered user or Admin try to modify Main page contents

Hello, I have a quite strange problem.

When a logged registered user or logged Admin try to modify the Main page contents he receive an error message: Sorry! This site is experiencing technical difficulties. Try waiting a few minutes and reloading. (Can't contact the database server: Unknown error (sql.4copter.com))

Any non logged user can modify the main page ! Registered users and Admin when logged can access to their pages.

It is a bug !

If I click on the edit link on the left side of the Main page , the hyperlink is something like http://www.mysite.com/mediawiki/index.php?title=main_page&action=edit&section=1

But if I click on the "modify" tab on the top menu of the same page hyperlink is something like http://www.mysite.com/mediawiki/index.php?title=main_page&action=edit

Without the final part of link "&section=1" the page can be modified also by registred user and Admin.

Why solved ? where ? I experienced the very same problem.

I will hide editsection until a solution will be found.

i removed the "solved" Adamtheclown 01:10, 14 November 2010 (UTC)

shared user table

  • MediaWiki version: 1.16.0
  • PHP version: 5.2.6-1+lenny9
  • MySQL version: 5.0.51a-24+lenny4
  • URL: http://simpsonspedia.net

In Sept. my site has 5th anniversary and I want to add two new wikis in English and French. I installed both. Shared images works. Now I want to share user table. My site has no prefix, the new English Wiki has _en_ and the French wiki has _fr_. All three user tables are in the same DB simpsonspedia.

I added in LocalSettings.php for both new wikis $wgSharedDB = "simpsonspedia"; $wgSharedPrefix = ""; # Defaults to $wgDBprefix $wgSharedTables = array( 'user', 'user_properties' ); $wgCookieDomain = "simpsonspedia.net";

But this entries doesn't work. both wikis use their own user table with prefixes _en_ or _fr_

What is my mistake?

Best regards —178.25.248.71 19:36, 9 August 2010 (UTC)