Project:Support desk

From MediaWiki.org
(Redirected from Support desk)
Jump to: navigation, search
vde   This page is for questions relating to the MediaWiki software.

Welcome to MediaWiki.org's Support desk, the central on-wiki place to ask MediaWiki questions!

The greater purpose of this page is to make our Manual and other available help so good that you do not have to come here to ask questions, or making them easier to find.

There are other ways for of communication as well (IRC, mailing lists etc.). Read more here.

Before you post

Post a new question

  1. To help us answer your questions, please always indicate which versions you are using:
    • MediaWiki (reported by your wiki's Special:Version page)
    • PHP (likewise)
    • Database (likewise, e.g. MySQL 5.5)
  2. Please include the URL of your wiki unless you absolutely can't. It's often a lot easier for us to identify the source of the problem if we can look for ourselves.
  3. To start a new thread, click "Start a new discussion".

Archiving topics

Topics are automatically archived when they have been inactive for three weeks. If a question you have asked is approaching this limit and still has not been answered, please 'bump' it to prevent it being archived. However do not 'bump' for other reasons.

Start a new discussion
First page
First page
Previous page
Previous page
Last page
Last page

[RESOLVED] PHP Fatal errors after installing Version 1.23.3

I just installed 1.23.3 using Softaculous. I am seeing an error in my log:

PHP Fatal error: Call to a member function getTitle() on a non-object in /home/rulemlso/public_html/wiki.ruleml.org/includes/Feed.php on line 309

This error message seems odd because line 309 in Feed.php reads

return gmdate( 'D, d M Y H:i:s \G\M\T', wfTimestamp( TS_UNIX, $ts ) );

There is no obvious affect on the wiki itself - I'm not really sure where to look for it.

I have the following extensions installed: Multi-Category Search (1.66) Replace Text (1.0) Cite (-) ParserFunctions(1.6.0) Privacy(1.2.3) SyntaxHighlight(1.0.8.11-wmfm1) Lockdown (d08bc8) WikiEditor (0.4.0)

PHP is 5.3.29 (litespeed) MYSQL is 5.5.36-cll-lve

I reported this at https://bugzilla.wikimedia.org/show_bug.cgi?id=70709, and they suggest I also post here.

Since I reported that bug I am also seeing another error: PHP Fatal error: Call to a member function getUniqueId() on a non-object in /home/rulemlso/public_html/wiki.ruleml.org/includes/Feed.php on line 395

As suggested from bugzilla, I have created a .htaccess files with

php_value error_reporting -1 php_flag display_errors On

and have included $wgShowExceptionDetails =true; in LocalSettings.php

No results to report yet.

I have yet to see an ill effects from this error, I just want to keep on top of things.

Where would problems in Feed.php show up?

Taraathan (talk)19:50, 11 September 2014

Have you upgraded from another MediaWiki installation?

Florianschmidtwelzow (talk)20:50, 11 September 2014

Sorry to be so long in answering- apparently I don't get a notification for this thread.

Yes, I updated from MW 1.19.x (x probably 8, but I don't recall exactly)

Taraathan (talk)13:26, 22 September 2014
 

Errors, which seem to be random and completely unrelated to your actual code - like your first one -, are often caused by cached stuff, e.g. in a PHP accelerator. Make sure to empty all caches before you try again!

88.130.122.19120:54, 11 September 2014

This wiki is running on a shared host, so I'm not sure how or if I can empty caches. I have a feeling that we do not have any caches, but not sure how to verify this.

Taraathan (talk)13:28, 22 September 2014

The errors seem to have disappeared on their own, so this seems like a likely culprit.

Taraathan (talk)16:59, 22 September 2014

I was incorrect about the errors disappearing - I was just looking for them in the wrong place. The errors continue to appear, at a rate of between 2-8 times per day, in the error_log file in my wiki directory.

98.222.200.17211:25, 23 September 2014
 
 
 
 

sphinx search only search main namespace

A thread, Thread:Project:Support desk/sphinx search only search main namespace, was moved from here to Extension talk:SphinxSearch. This move was made by Florianschmidtwelzow (talk | contribs) on 23 September 2014 at 10:06.

[RESOLVED] How to embed and stream video?

Hello! I have sat up a local Wikimedia installation on lan. I want to use video content embedded in the Wikimedia pages. First I used the html and the iframe tag, and then I built in video content from YouTube. Then I made a new test storing local videos on the same Apache server where Wikimedia is running. I now use the html and the video tag, and it looks like things is running quite well. (But I have not tested it to much yet.) Is the use of the html and the video tag the right way to do this (video streaming) or should it be done in a different way using some extension? I guess there is some security related to opening up for and using the html tag?

152.93.57.9413:48, 21 September 2014

I made this first post, even though the ip address is different. I have now tested the video plugin, and it worked without a issue. This mean I can use video using a "standard setup". I now posted a new question if you are safe enough if you enable the use of the html tag, if you have the full control over those few persons that will do the editing of the wiki. Reason: If you have the full power of html in the wiki, you can do a lot of things, quite easy and without a plugin. (Like html5 video and sound layer and links with target _blank.

Best reg Arne

46.212.26.20623:12, 21 September 2014

One one other tread I was advised that using html is ok if you have control over all users that can edit. This mean that the html5 video player ant the mediawiki plugin can be used. (And the html5 audio control as well.) Problem can be considered as solved.

46.15.71.4618:39, 22 September 2014
 
 

change image size with screen resolution and/or browser

Can images be made to resize like tables? For example, a table with "width=70%" is always 70% of the screen size but an image set at "300px" will take up different space across the screen depending on browser and screen resolution/size.

Is there any way images can be set to automatically resize as with tables?
Thanks.

31.185.135.23317:18, 22 September 2014

No, and HTML doesn't provide a syntax for that.

You'd probably need JavaScript to accomplish this. Try looking for an answer on specialized HTML/JavaScript forums.

Ciencia Al Poder (talk)09:27, 23 September 2014
 

[RESOLVED] Security risk by enabeling html support.

Hello!

If there is only a few, one or two persons that have the permission to edit the wiki is is still a very bad idea (from a security point of view) to enable html support in the wiki?

If you have the full control over who will do all the editing of the wiki is it then ok to use the html tag ?

Best reg Arne

46.212.26.20623:04, 21 September 2014

Yes, HTML is safe as long as you restrict editing to trusted users.

Jackmcbarn (talk)02:31, 22 September 2014

Thanks a lot. This will simplify a lot of things. Arne

46.15.71.4618:31, 22 September 2014
 
 

Wikitravel

Hello. I am interested in studying the depth of Wikivoyage and Wikitravel. While stats.wikimedia.org gives an up-to-date or nearly up-to-date account of Wikivoyage as well as other WMF projects, I am told that Wikitravel does not have such a facility. Is there a way to find classified data similar stats.wikimedia.org for Wikitravel as the it also runs on MediaWiki software? Please help me. Hindustanilanguage (talk) 19:05, 22 September 2014 (UTC).

Hindustanilanguage (talk)19:05, 22 September 2014

Multilanguage MediaWiki manual

Please help with links to manuals or advices how to implement multilanguage support (2 language only) for the current version of MediaWiki.

I just want to make 2 language pages with crosslinks between them.

Thank you for help!

PrometheusAla (talk)10:52, 18 September 2014

Extension:Translate can help you in doing consistent translations, if you actively maintain one language and then translate it to the second language.

Ciencia Al Poder (talk)09:20, 19 September 2014

I don't need help in translation, I need information how to implement bilingual support to MediaWiki. Is it possible?

PrometheusAla (talk)08:57, 20 September 2014

So you want setup as on https://en.wikipedia.org/wiki/Main_Page where the links to articles in other languages appear on left sidebar?

Samuel Peter9 (talk)09:08, 20 September 2014

Yes. Is it possible?

PrometheusAla (talk)04:13, 22 September 2014

Yes. Set up 2 different wikis and set up interwiki links between them. See Manual:Interwiki#Interwiki links to other languages

Ciencia Al Poder (talk)09:32, 22 September 2014
 
 
 
 
 

Per [1], the wikimedia projects will switch unregistered contributors to https by default at some point. I'd like to know whether, upon registering or logging in, they would still have an option to switch back to HTTP (like I have in the first tab in preferences now).

I had raised a discussion here earlier, but it wasn't answered, so I figured that a folk with a MediaWiki instance could either answer or try to configure it in this way and check whether the preference would be gone or still remain.

Gryllida02:54, 21 September 2014

Maybe you find a bugtracker entry, where this issue has already been discussed, however I don't know of one currently. Anyway, the setting in the preferences can already be hidden today (I am not saying that it will be hidden when everything is switched to HTTPS, but hiding it already is possible today). So should you configure your system in a way so that only HTTPS can be used, then you can get rid of this (then superfluous) option.

88.130.67.2609:31, 21 September 2014

Ideally I'd get more details here. What is the configuration setting that is responsible for hiding or showing the "use HTTPS beyond the login form" preference?

Gryllida22:03, 21 September 2014

FWIW, this is the wrong place to ask about Wikimedia config issues.

There's several ways of doing https for unregistered users. However I'm unaware of any plans for this in Wikimedia land, and the answer would depend on what specifically is being discussed. The blog post your citing is from a year ago, and doesn't seem to mention anything about unregistered users defaulting to https. There are however some wikis (mostly the private wikis, but also uzwiki per bugzilla:43466) where the canonical url is https (Which would normally mean both http and https work, but all email notices, etc use https, and that pages have a rel=canonical header telling google to prefer the https version of a page over the http one in search results).

Bawolff (talk)05:09, 22 September 2014

Preferences can be hidden with $wgHiddenPrefs.

88.130.104.20509:05, 22 September 2014
 
 
 
 

Hello, I am one of the administrators of this wiki (http://www.ichscotlandwiki.org/index.php?title=Intangible_Cultural_Heritage_in_Scotland) that I will use for my PhD research. It has been affecting by massive spam for several months. We upgraded the software, we installed both Nuke and Block and Nuke (by putting in the white lists only the administrators) extensions, we regularly change the question for the registration (using Google reCAPTCHA), which also requires the confirmation through email link, and added a black list provided by MediaWiki. However, this wasn't enough to either stop the spam or even slow it down. Can anyone suggest further actions to be undertaken? Any advice welcome.

2.122.80.22718:23, 15 September 2014

Hello!

It seems, that you haven't setup ConfirmEdit correctly. If i go (logged out) to Special:UserLogin&type=signup to create a new account i can do that without solving a captcha. Have you set up ConfirmEdit, especially the Triggers, correcly?

To use ConfirmEdit to protect for spam registrations, you should have this line in your LocalSettings.php:

$wgCaptchaTriggers['createaccount'] = true;
Florianschmidtwelzow (talk)18:47, 15 September 2014

Ah, and: Everyone can, without solving a Captcha, edit the contents of this wiki, that's the heavon for spam bots :D

Florianschmidtwelzow (talk)18:48, 15 September 2014

Thank you very much, I'll try this solution.

2.122.80.22711:01, 16 September 2014

Hello Florianschmidtwelzow, the command was already $wgCaptchaTriggers['createaccount'] = true; however, we realised that some people are asked for the CAPTCHA question when they are about to fill the form to create an account, others are not. How can this happen?

2.122.80.22714:57, 16 September 2014

Ok, now i have a captcha, that's much better :) I can't say, why some users get a captcha and some not. Can you post all ConfirmEdit related configuration settings in your LocalSettings.php (remove the client and secret id from reCaptcha ;))?

Florianschmidtwelzow (talk)16:04, 16 September 2014
 
 
 
 
 

Low performance on Multiple installations on single Webserver

Hi,

I have multiple MW instances installed on an Apache on a LINUX box. Monitoring has shown that the usage threshold has gone very low post installation. More than 10 MW instances with 3-5 Concurrent users pushes the CPU usage to more than 70-80% though with around only 10-20% RAM usage. The DBMS server does not utilize more than 5% of the CPU at any given point. This is an anomaly.

Additionally, all the tips and tricks to speed up all the MW installations and the Apache installation has been incorporated and the tests are done on a dedicated server box for the same with constant monitoring.

Any out-of-the-box solutions available or can it be assumed that multiple MW installations on a single box is not a good idea.

The set-up is as follows:

MW: 1.18.2

Apache: 2,4

PHP: 5.4

Postgres: 9.2

Wiki Permissions: Read only open wiki.

Customization: On vector Skin only and that too only on CSS level.

Status: Not live. Cannot share as per company policy. Not on internet as yet.

Content type and quantity: Content is mix of small png images and voluminous text. Couple of short MP4 videos per instance. Average size per MW installation - 100MB, Per DB Schema: 100MB

Server: Quad Core. 12GB RAM. No clustering.

OS: RHEL 5.5.

Pdr3112 (talk)08:54, 18 September 2014

Please upgrade MediaWiki 1.18 to MediaWiki 1.23 because MediaWiki 1.18 is not supported any more.

151.225.137.14516:18, 19 September 2014
 

You can track down where MediaWiki is spending most of the time, by setting Profiling.

Ciencia Al Poder (talk)14:04, 20 September 2014

FWIW, MediaWiki's mysql db support is more performance optimized than the postgres support.

However, if I were to guess, I would say caching issues. That said, as Ciencia suggested, profiling would tell you more.

>Any out-of-the-box solutions available or can it be assumed that multiple MW installations on a single box is not a good idea.

Having multiple MW installs served from the same box should not be an issue. Lots of people set up wikifarms where all the wikis come from one box (Obviously if your site becomes super popular, you'd probably want to scale it by using multiple boxes).

Bawolff (talk)05:20, 22 September 2014
 
 

[RESOLVED] Is it possible to make REVISION*** to show the affected revision instead of the last one?

For example, I would like to use something like a "citation needed" template. But I would also like to use a human-readable timestamp to indicate when the "citation needed" template (actually just a user-friendly mark) was inserted to the page. Unfortunately REVISIONYEAR, REVISIONMONTH and REVISIONDAY2 show the last change date and time only.

Thanks. (195.234.75.155 11:54, 17 September 2014 (UTC))

195.234.75.15511:54, 17 September 2014

Put subst: in front of it. For example, use {{subst:REVISIONMONTH}} instead of {{REVISIONMONTH}}. It will then get "baked" into the page when you save it, so it won't change in the future.

Jackmcbarn (talk)23:25, 17 September 2014

Thanks, tat's interesting and I'll definitely try it later. Just a question: would it be "baked" if it's rendered using a template so a template could be used a timestamp-mark at a "regular" page?

195.234.75.15507:41, 18 September 2014
 

Can't edit the previous message. It should be:

"Thanks, that's interesting (I was not aware of "subst:" at all) and I'll definitely try it later. Just a question: would it be "baked" if it's rendered using a template so the template could be used as a timestamp-mark at a "regular" page?"

Update 1: I've just checked the "subst:" and it does not work for me. It simply renders the "substed" as plain text.

195.234.75.15509:14, 18 September 2014

Try editing your template to make it look like this:

{{ {{{|safesubst:}}}#if:{{ns:0}}|{{The name of your template|month={{ {{{|subst:}}}REVISIONMONTH}}|year={{ {{{|subst:}}}REVISIONYEAR}}}}|The original content of your template, using the month and year parameters}}

You should be able to adapt that to the exact parameters you require.

Jackmcbarn (talk)14:15, 18 September 2014

Thanks for the snippet, but I'm having another issue (if I use your code right after all): does it mean that the template should now accept parameters? The idea of the template was just to place a spot like {{Verify}} without arguments. Not sure if this is possible now...

194.44.30.512:59, 21 September 2014

It's possible, sort of. What will happen is that you'll add {{subst:Verify}} to the page, and then when you save it, MediaWiki will turn it into {{Verify|date=September 2014}} automatically.

Jackmcbarn (talk)15:33, 21 September 2014
 
 
 
 
 

"Error: 14 unable to open database file"

Edited by author.
Last edit: 00:05, 22 September 2014

Continuation from this thread

Recently, I've been having problems with certain functions on my domain http://grisaiawiki.net When I try to protect, undelete, or move a page, I get errors preventing me from doing so. After enabling the appropriate settings, I now get the following message when trying to do any of these: (this example from trying to protect the Main Page from non-administrators)


A database query error has occurred. This may indicate a bug in the software.

Query:

  • UPDATE page SET page_restrictions = '' WHERE page_id = '146'
  • Function: WikiPage::doUpdateRestrictions
  • Error: 14 unable to open database file

I still can't figure out why I'm having this issue, or even what's causing it. I've never made any changes to files like DefaultSettings.php or WikiPage.php, nor have I touched anything in /includes/db/. None of my extensions or changes to LocalSettings.php seem to have caused it either, as removing/undoing those changes doesn't help. I'm at a complete loss by this point.

Schiffy (talk)16:11, 20 September 2014

This seems to be an issue with SQLite.

The PDO SQLite driver requires that if you are going to do a write operation (INSERT,UPDATE,DELETE,DROP, etc), then the folder the database resides in must have write permissions, as well as the actual database file.

I found this information in a comment on php.net.

88.130.87.16317:26, 20 September 2014

That's what strikes me as odd, because this issue was not happening when I first installed 1.23.3. The most I could have done was create a database and a few tables in my cpanel that ended up not being even connected to the domain. I certainly never removed any permissions from the folder. Checking them, they don't seem to have the public allowed to write to them, but changing this still doesn't stop the problem.

Schiffy (talk)17:41, 20 September 2014
 
 

[RESOLVED] Can't edit preferences

To whom I may concern,

hakuson.de/index.php/

Software Version MediaWiki 1.23.3 PHP 5.5.16-nmm1 (apache2handler) MySQL 5.6.17-nmm1-log Lua 5.1.5

is my setting. The problem is that I cannot edit the preferences. I can see the specialpage, but i am not able to edit the content. (Can not change anything)

I searched in google and mediawiki documentation for two hours and found nothing, so i am asking for help.

Thank you very much. Greetings Christoph Endruschat

Answer to: cvcaq@gmx.de

93.214.198.12119:59, 17 September 2014
Edited by another user.
Last edit: 22:19, 18 September 2014

Hi Christoph,

what exactly do you mean with "I cannot edit"? Are you unable to actually change the values inside the different fields? Or can you not save them? Until hearing the contradictory I assume the later. In this case you obviously met some error condition. See How to debug, reproduce the error and then check the PHP error log for more information!

88.130.95.19621:54, 17 September 2014

Hi,

i mean that when i try to change anything, it just does show no sign of reaction. When I click on a checkbox or something, nothing happens. The textfields and checkboxes are gray, like their inactiv. I can select the text describing the preferences. So I am not able to change the the values. Maybe my question should have been: How can i activate the Preferences?

I am not sure if it is actually a bug, or if i am just too stupid, but I don`t find any information about in google, so I assumed something is wrong.

Thank you Greets Christoph

93.214.219.21720:53, 18 September 2014
 

Hi,

i mean that when i try to change anything, it just does show no sign of reaction. When I click on a checkbox or something, nothing happens. The textfields and checkboxes are gray, like their inactiv. I can select the text describing the preferences. So I am not able to change the the values. Maybe my question should have been: How can i activate the Preferences?

I am not sure if it is actually a bug, or if i am just too stupid, but I don`t find any information about in google, so I assumed something is wrong.

Thank you Greets Christoph

93.214.219.21720:54, 18 September 2014

So you can click around and see the different tabs on the preferences page? I do not know of a way to produce what you are seeing. You can hide some preferences using the $wgDefaultUserOptions option, but I would not know how you can deactivate them while keeping them visible. Can you check, how the things are deactivated? Is that done by some JavaScript? Or are there values in the HTML source code, which cause this?

88.130.70.24822:24, 18 September 2014

Problem solved on my wiki where I had the same problem !

Some new (and undocumented ?) rights manage the user features. Just add to your /LocalSettings.php file the following lines :

$wgGroupPermissions['user']['editmyusercss']                = true;
$wgGroupPermissions['user']['editmyuserjs']                 = true;
$wgGroupPermissions['user']['viewmywatchlist']              = true;
$wgGroupPermissions['user']['editmywatchlist']              = true;
$wgGroupPermissions['user']['viewmyprivateinfo']            = true;
$wgGroupPermissions['user']['editmyprivateinfo']            = true;
$wgGroupPermissions['user']['editmyoptions']                = true;
⇨ Dr Brains ∞ Doléances ∞12:55, 21 September 2014

> Some new (and undocumented ?)

This rights aren't new and undocumented. Introduced in MW 1.22 and documented at the user rights page:

https://www.mediawiki.org/wiki/Manual:User_rights#List_of_permissions

Florianschmidtwelzow (talk)14:11, 21 September 2014
 
 
 
 
 

Help with css in custom skin

Hi can i have some help please with css i am trying to get my skin to re size properly on different browsers and display but it doesent seems to work i try something and then it makes something else not work. source codes are at https://github.com/paladox2015/Metrolook and website is at http://en.random-wikisaur.tk i am trying to get the top bar on my site to resize properly on different screens. i tried it on a laptop and seems to work but on iPad it seems to put search bar out of the bar because it was pushed because it hasent got enough room i would like it to re size properly. it was a chrome bug that caused this.

86.135.248.24117:21, 20 September 2014

I Just need some help with the top bar because the search bar gets pushed down because theres not enough room. I tried some things ive searched google and tried the things I founded but it doesent work.

86.135.248.24121:13, 20 September 2014

What I mean is how can I get the top bar to move a bit to the right to fit the searchbar in on smaller screens because I have added something so that when scrolled the topbar comes to.

86.135.248.24117:21, 21 September 2014

How can I set the width to detect the device screen size and resize.

86.135.248.24118:55, 21 September 2014
 
 
 

database is suffering from InnoDB corruption, specifically in the mw_objectcache table.

Edited by another user.
Last edit: 09:33, 28 July 2014

I've been having some MySQL issues, and it appears to be stemming from the mediawiki db. Below the message I received from my server support, thoughts? The mediawiki db is patjk_wikidb.


I've checked for CREATE DATABASE statements for each of the affected databases:

root@host [~/support/462326]# zcat databases_with_innodb.sql.gz | grep 'CREATE DATABASE'
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `horde` /*!40100 DEFAULT CHARACTER SET latin1 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `patjk_gallery2` /*!40100 DEFAULT CHARACTER SET latin1 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `patjk_magen` /*!40100 DEFAULT CHARACTER SET latin1 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `patjk_vbdb` /*!40100 DEFAULT CHARACTER SET latin1 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `patjk_wikidb` /*!40100 DEFAULT CHARACTER SET latin1 */;

Unfortunately, it looks like the roundcube database is not present, and the patjk_wikidb is likely to be truncated. Here are the errors that occurred:

root@host [~/support/462326]# cat mysqldump_error.log 
Warning: option 'max_allowed_packet': unsigned value 1331691520000 adjusted to 2147483648
mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table `mw_objectcache` at row: 1697279

According to MySQL's internal uptime clock the database was started roughly 48 minutes ago, which was just before I noticed that the dump was no longer running:

| Uptime | 2915 |

Here are the MySQL error log messages that coincided with the apparent failure:

2014-07-27 05:30:43 29972 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.6.16' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL)
2014-07-27 06:46:57 76670b90 InnoDB: Assertion failure in thread 1986464656 in file btr0pcur.cc line 432
InnoDB: Failing assertion: btr_page_get_prev(next_page, mtr) == buf_block_get_page_no(btr_pcur_get_block(cursor))
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
InnoDB: If you get repeated assertion failures or crashes, even
InnoDB: immediately after the mysqld startup, there may be
InnoDB: corruption in the InnoDB tablespace. Please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/forcing-innodb-recovery.html
InnoDB: about forcing recovery.
10:46:57 UTC - mysqld got signal 6 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help
diagnose the problem, but since we have already crashed, 
something is definitely wrong and this may fail.

key_buffer_size=134217728
read_buffer_size=10485760
max_used_connections=151
max_threads=150
thread_count=151
connection_count=150
It is possible that mysqld could use up to 
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 1975685 K bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

Thread pointer: 0x77452f00
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 76670358 thread_stack 0x30000
/usr/sbin/mysqld(my_print_stacktrace+0x33)[0x856d843]
/usr/sbin/mysqld(handle_fatal_signal+0x43e)[0x82897ee]
/lib/libpthread.so.0[0xb7f740f8]
/lib/ld-linux.so.2[0xb7f8b7f2]
/lib/libc.so.6(gsignal+0x50)[0xb7cd0e30]
/lib/libc.so.6(abort+0x101)[0xb7cd2741]
/usr/sbin/mysqld[0x8709605]
/usr/sbin/mysqld[0x869ee49]
/usr/sbin/mysqld[0x85dfa87]
/usr/sbin/mysqld[0x85dfd31]
/usr/sbin/mysqld(_ZN7handler11ha_rnd_nextEPh+0x75)[0x81987f5]
/usr/sbin/mysqld(_Z13rr_sequentialP11READ_RECORD+0x49)[0x84860c9]
/usr/sbin/mysqld(_Z10sub_selectP4JOINP13st_join_tableb+0x16a)[0x82f190a]
/usr/sbin/mysqld(_ZN4JOIN4execEv+0x3c6)[0x82ef5d6]
/usr/sbin/mysqld[0x833d58d]
/usr/sbin/mysqld(_Z12mysql_selectP3THDP10TABLE_LISTjR4ListI4ItemEPS4_P10SQL_I_ListI8st_orderESB_S7_yP13select_resultP18st_select_lex_unitP13st_select_lex+0xed)[0x833d92d]
/usr/sbin/mysqld(_Z13handle_selectP3THDP13select_resultm+0x19d)[0x833db8d]
/usr/sbin/mysqld[0x8312a7b]
/usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x4cf5)[0x83189f5]
/usr/sbin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_state+0x32d)[0x831da7d]
/usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0x191c)[0x831fd8c]
/usr/sbin/mysqld(_Z10do_commandP3THD+0xee)[0x832182e]
/usr/sbin/mysqld(_Z24do_handle_one_connectionP3THD+0x135)[0x82e33c5]
/usr/sbin/mysqld(handle_one_connection+0x4d)[0x82e34ad]
/usr/sbin/mysqld(pfs_spawn_thread+0x179)[0x85b8dc9]
/lib/libpthread.so.0[0xb7f6b912]
/lib/libc.so.6(clone+0x5e)[0xb7d7d7ce]

Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (b7fed08): SELECT /*!40001 SQL_NO_CACHE */ * FROM `mw_objectcache`
Connection ID (thread ID): 3089
Status: NOT_KILLED

The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.
140727 06:46:58 mysqld_safe Number of processes running now: 0
140727 06:46:58 mysqld_safe mysqld restarted
2014-07-27 06:47:00 0 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
2014-07-27 06:47:00 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2014-07-27 06:47:00 30625 [Note] Plugin 'FEDERATED' is disabled.
2014-07-27 06:47:00 30625 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2014-07-27 06:47:00 30625 [Note] InnoDB: The InnoDB memory heap is disabled
2014-07-27 06:47:00 30625 [Note] InnoDB: Mutexes and rw_locks use InnoDB's own implementation
2014-07-27 06:47:00 30625 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-07-27 06:47:00 30625 [Note] InnoDB: Using Linux native AIO
2014-07-27 06:47:00 30625 [Note] InnoDB: Not using CPU crc32 instructions
2014-07-27 06:47:00 30625 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2014-07-27 06:47:00 30625 [Note] InnoDB: Completed initialization of buffer pool
2014-07-27 06:47:00 30625 [Note] InnoDB: Highest supported file format is Barracuda.
2014-07-27 06:47:00 30625 [Note] InnoDB: The log sequence numbers 133808751880 and 133808751880 in ibdata files do not match the log sequence number 133810301875 in the ib_logfiles!
2014-07-27 06:47:00 30625 [Note] InnoDB: Database was not shutdown normally!
2014-07-27 06:47:00 30625 [Note] InnoDB: Starting crash recovery.
2014-07-27 06:47:00 30625 [Note] InnoDB: Reading tablespace information from the .ibd files...
2014-07-27 06:47:06 30625 [Note] InnoDB: Restoring possible half-written data pages 
2014-07-27 06:47:06 30625 [Note] InnoDB: from the doublewrite buffer...
InnoDB: Last MySQL binlog file position 0 344931686, file name ./mysql-bin.000030
2014-07-27 06:47:09 30625 [Note] InnoDB: 128 rollback segment(s) are active.
2014-07-27 06:47:09 30625 [Note] InnoDB: Waiting for purge to start
2014-07-27 06:47:09 30625 [Note] InnoDB: 5.6.16 started; log sequence number 133810301875
2014-07-27 06:47:09 30625 [Note] Server hostname (bind-address): '*'; port: 3306
2014-07-27 06:47:09 30625 [Note] IPv6 is available.
2014-07-27 06:47:09 30625 [Note] - '::' resolves to '::';
2014-07-27 06:47:09 30625 [Note] Server socket created on IP: '::'.
2014-07-27 06:47:10 30625 [Note] Event Scheduler: Loaded 0 events
2014-07-27 06:47:10 30625 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.6.16' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL)

Based on these symptoms and messages, I believe your patjk_wikidb database is suffering from InnoDB corruption, specifically in the mw_objectcache table.

If this were a MyISAM able, we could probably recover it with mysqlcheck or myisamrepsair. However, mysqlcheck can only repair InnoDB tables by dumping and rebuilding them, which is the same procedure we just attempted, so this is certain to fail as well.

We could attempt to recover the database with the innodb_force_recovery option. However, this is risky. It can cause even worse damage. Additionally, your VPS does not have enough free space to make an up-to-date raw copy of the InnoDB tablespaces before attempting this.

I'm not familiar with the wiki software you are using, so I'm not sure how vital the mw_objectcache table is to its operation, or if it can be replaced or regenerated easily. Discarding this table might be a more viable option if a repair using the gentlest settings of innodb_force_recovery do not succeed.

Another option which you might consider is consulting a developer or DBA with experience recovering InnoDB tables.

I wish I had better news for you. I'm afraid there is not going to be a good way to get rid of this overly large InnoDB tablespace without losing at least some of your patjk_wikidb data. Again, we can attempt innodb_force_recovery if you request it, but this poses the risk of more data loss.

110.171.63.612:27, 27 July 2014

Hi!

First of all this seems not to be a MediaWiki, but a MySQL problem.

A complete MediaWiki DB contains the tables listed on DB.

If you think that your objectcache table is corrupted, you can truncate it any time - MediaWiki will rebuild its contents.

The content of other tables however, cannot be rebuilt that easily: E.g. the content in the tables text, pages and revision is unique and is required for MediaWiki to function properly. Should these tables be corrupted as well, you should use a working backup to restore them (and with them the whole DB).

88.130.76.19813:00, 27 July 2014

Thanks for the info. How do you recommend I proceed with this? I'm not too familiar with this stuff. I'd be willing to hire someone to see if they can resolve this (please email me if interested *pj*kca*rds at gmail dot com [remove *'s]). The ibdata1 file on my server is huge now too, and needs to be cleaned.

110.171.63.609:23, 28 July 2014
Edited by 2 users.
Last edit: 11:10, 29 July 2014

Hi!

You can truncate the objectcache table. This will keep the table structure, but remove all its content thus making this table smaller (close to 0kb). However, MediaWiki should automatically do some kind of garbage collection in that table anyway; if you have a big wiki, this table will (automatically) become big again. And this will not solve the following problem:

Try to create a full backup of all the databases in your MySQL server (using the mysqldump tool), but with the error message you get, I don't know, if using mysqldump is still possible.

As far as I know the InnoDB ibdata1 file will never shrink and there also is no easy way to make it smaller again. A force recovery can give you a chance to get to your data. Be patient and use the lowest value possible to get the server started so you can make a backup of as much data as possible.

Another question: Do you have a current backup of the database? If so, that would make things way easier! Is it only your stuff in this MySQL server or is it a shared MySQL server? If it's only your stuff on the server, you could try the following:

If you have a backup, then stop MySQL and remove all the databases, ib_logfile* and ibdata* files. When you start MySQL again it will create a new fresh shared tablespace. This table space will then not be corrupted, hopefully solving your initial issue. Then, import your database dump again.

If there are any underlying hardware issues, those need to be addressed first.

88.130.76.19811:29, 28 July 2014

Would an upgrade resolve this issue? Or is it best to repair the corrupt object_cache tables prior to upgrading?

Thanks.

27.147.202.15109:50, 21 September 2014

A broken table is a MySQL problem. MediaWiki however is not MySQL, it only uses MySQL, it is based on MySQL. If you upgrade MediaWiki or not will most likely not influence the problem in MySQL - I can only imagine that it makes this problem's impact on MediaWiki worse. Generally it is better to solve issues before changing anything additional in the system. I would first fix the broken tables and do the upgrade afterwards.

88.130.67.2611:09, 21 September 2014
 
 
 
 
 

Wikispecies help

For Wikispecies, under the Navigation section on the left, the Help section is pointed back to MediaWiki even though there is a local help page. How can I modify it so that it points back to the local page?

OhanaUnitedTalk page15:32, 16 September 2014

This can be changed on wiki with the Interface message helppage:

wikispecies:MediaWiki:Helppage Just edit this page and insert the new link (e.g. "Help:Contents" without ") :) Hint: You need the right to edit interface messages.

Florianschmidtwelzow (talk)15:45, 16 September 2014

Yes I have the rights. I just didn't know which MediaWiki page I needed to edit. Thanks.

I carried out the change and it was reflected in Monobook. However, it didn't change in Vector skin. Any reason why?

OhanaUnitedTalk page15:08, 17 September 2014

I see the link in Vector :)

Florianschmidtwelzow (talk)13:41, 18 September 2014

Ah yes, must have been cache acting up. Thank you for your help.

OhanaUnitedTalk page21:14, 20 September 2014
 
 
 
 

Help with error

Hi I keep getting this error when using

error is '$' is undefined when using this

$(document).click(function(e) {

   if (!$(e.target).closest('#'+openDiv).length) {
       toggleDiv(openDiv);
   }

});

I get it in f12 internet explorer developer thing. please help.

151.225.137.14520:02, 11 September 2014

I aslo get this error with this code

function toggleDiv(divID) {

   $("#" + divID).fadeToggle(150, function() {
       openDiv = $(this).is(':visible') ? divID : null;
   });

}

151.225.137.14520:05, 11 September 2014

What exactly makes you believe that what all the Google hits tell you is wrong?

88.130.122.19121:17, 11 September 2014

Google wont tell me but that is the error I am getting in ie in developer I tried searching goolg eso I just added $ to var $ but then another error comes and so I search that on google and there is nothing about the new error I am getting.

151.225.137.14520:49, 12 September 2014

I now get this error

Line: 41 Error: Object expected

the link to project is https://github.com/paladox2015/Metrolook

151.225.137.14520:57, 12 September 2014

What it means by on line 41 is this code


$(document).click(function(e) {
    if (!$(e.target).closest('#'+openDiv).length) {
        toggleDiv(openDiv);
    }
});

151.225.137.14520:59, 12 September 2014
 
 
 
 
 

Transfering a XAMPP made mediawiki's site to a web hosting

Hello everybody. In these days I was able to install Mediawiki using the XAMPP program, and, for what I can see, it is working fine. I found myself then asking how could I transfer my wiki on the net, being it a private Wiki. I followed the backup and restore guide on the XAMPP Mediawiki installing guide and I tried to transfer the data upon a free web hosting, byethost, given the fact that a friend of mine was able to open a dokuwiki easily on this webhosting. I Imported the database created on XAMPP in MySQL service of the web hosting page, then I tried to go to the online file manager and I tried to upload the htdocs folder of the wiki. I find myself with this screen http://i132.photobucket.com/albums/q27/Axel_99/crist_zpse437bd6e.jpg I try to login using the user of the file hosting, but a dialogue box opens saying "Please Enter the FTP server" I'm stuck with this page and don't know how to go on. I was able to open the wiki on XAMPP, am I missing something? Or is there another way to transfer a Wiki from XAMPP to the net?

Losco (talk)12:47, 20 September 2014

If your hosting gave you a ftp server to connect to transfer your files, you can use any FTP client to connect to it and transfer your files. Filezilla is a very good FTP client for this.

Ciencia Al Poder (talk)14:11, 20 September 2014

So what should I do? I need to install Filezilla on the web hosting or what? I'm not that good in these things..

Losco (talk)14:20, 20 September 2014

You need to install FileZilla client on your PC and then take the credentials, which you got from your hosting provider, and put them into FileZilla in order to connect to the webspace.

88.130.87.16317:29, 20 September 2014
 
 
 

Install a bot

Hello everybody.

I want to install a bot on my wiki. How can I do that?


Yours,

Suriyaa Kudo (talk)12:50, 20 September 2014
 

Adding one more external link to a page, preview or save just causes my main page to appear.

I have a fairly simple page located at http://wiki.ptisecurity.com/index.php?title=Wire_Recommendations

I'm adding external links to a items listed in a table. All goes fine for the first three rows but when I add one more external link to the page (and it does not matter if I add it in the table or somewhere outside of it) then when I save or preview the page instead of it showing me the page it just opens my wiki's main page. No errors are shown.

It doesn't matter what page I link to, I get the same result.

Any Ideas?

RToy (talk)18:13, 19 September 2014

mod_security

Disable it or ask your host to disable it, or tune it so it allows more than X external links to a page.

Ciencia Al Poder (talk)14:06, 20 September 2014
 
First page
First page
Previous page
Previous page
Last page
Last page