Project:Support desk

Jump to navigation Jump to search

About this board

vde   Welcome to MediaWiki.org's Support desk, where you can ask MediaWiki questions!

There are also other places where to askCommunication: IRCCommunication#Chat, mailing listsMailing lists, Wikimedia Developer Support, Q&A, mwusers (unofficial forum) etc.

Before you post

Post a new question

  1. To help us answer your questions, please always indicate which versions you are using (reported by your wiki's Special:Version page):
    • MediaWiki
    • PHP
    • Database
  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 topic".

How do I enable deleting user accounts?

5
Monocero (talkcontribs)

How do I enable deleting user accounts? Where do I have to set it?


I am asking for a guide.

AhmadF.Cheema (talkcontribs)

The common, non-problematic MediaWiki method of user accounts "deletion" is by merging the undesired account into an anonymous account.

For details, see Extension:UserMerge.

Monocero (talkcontribs)

I mean deletion a normal user account. I would like to add such a feature.

AhmadF.Cheema (talkcontribs)

Actual deletion can probably be done through working directly on the database, but such is highly discouraged. Deleting a user will mess up various MediaWiki functions such as page histories, due to which it is better to merge users instead of deleting them.

Monocero (talkcontribs)

I understand. So I can delete an empty test account in the database?

Reply to "How do I enable deleting user accounts?"

How can I create a new page (article)?

8
Monocero (talkcontribs)

Hi,

I would like to know how to enter the function of creating new pages? How to create a link to create new pages (articles)? Do I have to enter some code to LocalSettings.php file or use an extension?  

I have installed the "InputBox" plugin and on this page: Help:Starting a new page is the code for creating a new page "Using article creation template", but how can I create a new page at all? What should I click?

I would like to have a link to create a page immediately, something like Upload file in Tools tab.

I'm a beginner at MediaWiki.

Please help me.

Examknow (talkcontribs)

What I did for my wiki is that I put in a link on the sidebar. Using the MediaWiki:Sidebar page I put this code into the side bar page ** Create Page|Create Page. Now you will need to make a page called Create Page. In the page input the following wiki text <inputbox> type=create break=no </inputbox> . Then you should be good to go.

Monocero (talkcontribs)

Thank you for the information.

"What I did for my wiki is that I put in a link on the sidebar. Using the MediaWiki:Sidebar page I put this code into the side bar page".

How can I put the same link? How to do it exactly?

Is this explained here?

Manual:Configuration settings

AhmadF.Cheema (talkcontribs)
  1. Install Extension:InputBox.
  2. Browse to any page on your Wiki, in the address bar of your browser, replace the Wiki page name with: Project:Create Page.
  3. Click on the Create tab and then enter the following text: <inputbox> type=create break=no </inputbox>.
  4. Go to your Wiki's version of the page MediaWiki:Sidebar.
  5. Add: ** Project:Create Page|Create Page (better to replace "Project" with your site name).


You can also use some extensions. See Extension:Create Page and Extension:CreatePageUw.


Monocero (talkcontribs)

1. I have this extension installed.

2. Explain it to me more clearly. Example link: https://www.golarze.pl/golarzopedia/index.php?title=Brzytwa.&action=edit&redlink=1 how to change this link in "Project: Create Page"?

In this way?

https://www.golarze.pl/golarzopedia/index.php?title=Golarzopedia:Create_Page

3. If so then after going to the editor and after entering this code an error occurred: Input box type "create break=no" not recognized. Please specify "create", "comment", "search", "search2" or "fulltext".

4. Can you explain it more clearly? I do not really understand.

////////////////////////////////////

I installed this extension https://www.mediawiki.org/wiki/Extension:CreatePageUw and the link to create a new page is located in the special pages tab. How can I add this link to the Tools tab on the main page?

And in the Configuration tab is such a code, should I add this code to LocalSettings.php file?

$wgCreatePageUwUseVE = true;

AhmadF.Cheema (talkcontribs)
This post was hidden by Tomybrz (history)
Monocero (talkcontribs)

Thank you for the explanation.


To go to edit the sidebar should to do it this way:


.../index.php?title=MediaWiki:Sidebar


Only now I realized how to do it. :)


I managed to add this link to this sidebar but I would like to know whether I can add this link below to the Tools tab?


https://i.imgur.com/WAbZBG1.png


I added the same post by case as a guest. How can I report that post to be deleted?

Reply to "How can I create a new page (article)?"

Hook to position template above Category links

3
Spiros71 (talkcontribs)

Following this Topic:Rmxayk3g7uxk0t1h I have used the snippet indicated below to display a template on every article page. I tried to wrap the template into a div, but there seemed no way to position it above the Category links (or end of page content). Is there a hook that would allow that? I could not find one in Manual:Hooks. Also, how can I make it not display on Home page?

$wgHooks['ArticleViewHeader'][] = 'addHeaderToPages';

function addHeaderToPages( &$article, &$outputDone, &$pcache ) {
  global $wgOut;
  $wgOut->addWikiText('Template:AdditionalHeader');
  return true;
}


MarkAHershberger (talkcontribs)

Which skin are you using?

In any case, it looks like you can use the SkinTemplateOutputPageBeforeExec to modify $template's catlinks data like (I'm guessing) this:

$template->set( 'catlinks', 'YOUR-STUFF' . $template->get( 'catlinks' ) );

If you don't mind it being after the categorylinks, then you can use the SkinAfterContent hook.

Spiros71 (talkcontribs)
Reply to "Hook to position template above Category links"
Semako96 (talkcontribs)

Currently I can't open Spezial:Verwaiste Seiten (https://mariowiki.net/wiki/Spezial:Verwaiste_Seiten), because I get a database errror: [5583067846a46113244ad127] 2019-01-25 17:15:11: Fataler Ausnahmefehler des Typs „Wikimedia\Rdbms\DBQueryError“

What is the problem here? Other pages work and I can upload files and create new articles.

AhmadF.Cheema (talkcontribs)

In LocalSettings.php, set:

$wgShowExceptionDetails = true;
$wgDevelopmentWarnings = true; error_reporting( -1 ); ini_set( 'display_errors', 1);
# SQL errors:
$wgShowuserSQLErrors = true; $wgShowDBErrorBacktrace = true;

Manual:How to debug

Semako96 (talkcontribs)

Do you have any idea why this single page doesn't work? Does it use a specific MySQL table or query, so that I can test it manually? I don't want to have all those warnings from open_basedir showing up again, so I decativated PHP warning reports in the server config.

AhmadF.Cheema (talkcontribs)

After you turn on debugging, probably especially the portion related to SQL errors, will anyone "have any idea why this single page doesn't work?" Which "specific MySQL table or query" is the issue here?

Debugging needs to be turned On temporarily. Turn it On > Reload the page > Note down the error > Turn Off debugging.

Semako96 (talkcontribs)

Activated debug mode, and got that error on Spezial:Verwaiste_Seiten

[9599436522e6674869066803] /wiki/Spezial:Verwaiste_Seiten   Wikimedia\Rdbms\DBQueryError from line 1457 of /home/.sites/327/site4525714/web/wiki/w/includes/libs/rdbms/database/Database.php: A database query error has occurred. Did you forget to run your application's database schema updater after upgrading? 

 Query: SELECT  page_namespace AS `namespace`,page_title AS `title`,page_title AS `value`  FROM `page` LEFT JOIN `pagelinks` ON ((pl_namespace = page_namespace) AND (pl_title = page_title)) LEFT JOIN `templatelinks` ON ((tl_namespace = page_namespace) AND (tl_title = page_title))   WHERE (pl_namespace IS NULL) AND page_namespace = '0' AND page_is_redirect = '0' AND (tl_namespace IS NULL)  ORDER BY page_title LIMIT 101  

 Function: LonelyPagesPage::reallyDoQuery

 Error: 1104 The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay (mysqlsvr39.world4you.com)

Backtrace:

#0 /home/.sites/327/site4525714/web/wiki/w/includes/libs/rdbms/database/Database.php(1427): Wikimedia\Rdbms\Database->makeQueryException(string, integer, string, string)

 #1 /home/.sites/327/site4525714/web/wiki/w/includes/libs/rdbms/database/Database.php(1200): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean)

 #2 /home/.sites/327/site4525714/web/wiki/w/includes/libs/rdbms/database/Database.php(1653): Wikimedia\Rdbms\Database->query(string, string)

 #3 /home/.sites/327/site4525714/web/wiki/w/includes/specialpage/QueryPage.php(425): Wikimedia\Rdbms\Database->select(array, array, array, string, array, array)

 #4 /home/.sites/327/site4525714/web/wiki/w/includes/specialpage/QueryPage.php(599): QueryPage->reallyDoQuery(integer, integer)

 #5 /home/.sites/327/site4525714/web/wiki/w/includes/specialpage/SpecialPage.php(522): QueryPage->execute(NULL)

 #6 /home/.sites/327/site4525714/web/wiki/w/includes/specialpage/SpecialPageFactory.php(568): SpecialPage->run(NULL)

 #7 /home/.sites/327/site4525714/web/wiki/w/includes/MediaWiki.php(288): SpecialPageFactory::executePath(Title, RequestContext)

 #8 /home/.sites/327/site4525714/web/wiki/w/includes/MediaWiki.php(861): MediaWiki->performRequest()

 #9 /home/.sites/327/site4525714/web/wiki/w/includes/MediaWiki.php(524): MediaWiki->main()

 #10 /home/.sites/327/site4525714/web/wiki/w/index.php(42): MediaWiki->run()

 #11 {main}

I ran the update script after the update from MediaWiki 1.24, and it finished with success, so if that table didn't get updated in the process, there must be a critical bug in the update script.

2001:16B8:1063:9500:98C4:8EB:C659:9B56 (talkcontribs)

Does not seem so.

> The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay (mysqlsvr39.world4you.com)

The default value of max_join_size is 18446744073709551615. I think this value should not be exceeded in your case.

What is max_join_size set to? I guess it should be set to something higher!

Semako96 (talkcontribs)

Where do I find that setting in phpMyAdmin?

Semako96 (talkcontribs)

Anyone?

Ciencia Al Poder (talkcontribs)
Semako96 (talkcontribs)

How can I check wether my database is missing some indices?

If it was caused by a limitation from my hoster, why do the other similar special paged all work? Anything I can do? That page is important for the wiki...

Ciencia Al Poder (talkcontribs)

Check in Manual:Database layout or Manual:tables.sql for index definition and compare that on your database. Since there are a lot of tables, start checking only the tables involved in the query that failed: page, pagelinks and templatelinks

Semako96 (talkcontribs)

Compared those to my database and found out that profiling and change_tag_dev are missing. My database also contains some other tables that aren't listed there and probably leftovers from an older MediaWiki version or older extensions.

Semako96 (talkcontribs)

anyone has an Idea about what to do?

Ciencia Al Poder (talkcontribs)

Did you create the missing indices?

This post was hidden by 2A02:8388:6982:B700:64A6:9F4D:4333:2906 (history)
Semako96 (talkcontribs)

No, I haven't created them yet. Are those related to the issue with Spezial:Verwaiste Seiten?

Ciencia Al Poder (talkcontribs)

Indices prevent queries from scanning the entire table. This is the issue your host is limiting: The SELECT would examine more than MAX_JOIN_SIZE rows. If the index is in place, it shouldn't need to scan so many rows, apparently

Semako96 (talkcontribs)

Just noticed that the profiling table doesn't exist by default, and change_tag_dev exists only from MediaWiki 1.32 onwards, not 1.31. So there are no missing indices in my database. Is there anything I can do to make that page work? And why do pages like Spezial:Verwaiste_Dateien, Spezial:Verwaiste_Kategorien work anyways? There are much more files than article pages including redirects on our wiki.

Ciencia Al Poder (talkcontribs)

I don't know. However, your host is imposing limitations to database queries, and this is an issue that you may encounter more frequently as your wiki grows. You can try to live with that, or migrate to a better hosting.

Semako96 (talkcontribs)

I just got an answer from my hoster. I need to insert SET SQL_BIG_SELECTS=1; into the code where it does the database select request. Can you tell me where that is?

Ciencia Al Poder (talkcontribs)

It's somewhere in includes/libs/rdbms/database/Database.php: near or inside Wikimedia\Rdbms\Database->selectDomain(Wikimedia\Rdbms\DatabaseDomain)

Semako96 (talkcontribs)

that's really vague. Anyone who knows exactly where the database select request in question is done?

Reply to "Database error"

How can I block only the main wiki page before editing?

3
Monocero (talkcontribs)

Hi,


I would like to block the wiki's main page before editing by anyonee except the administrator. How to do it? I do not see this method here:

Manual:Configuration settings

AhmadF.Cheema (talkcontribs)
Monocero (talkcontribs)

Thanks for the clarification.

91.110.239.36 (talkcontribs)

I recently updated the company Mediawiki from 1.25 - 1.32, and as foreseen this has caused a few issues. Most resolved. However this one is still causing me a headache...


I've looked over the help pages on here and checked for cache and job issues.


I have disabled cache in LocalSettings.php using $wgParserCacheType = CACHE_NONE and $wgMainCacheType = CACHE_NONE

I have checked for any jobs using the maintenance script php showJobs.php which returns 0

I have purged the page.

Rebooted the system


The page shows when searching. The edit shows the correct category [[Category:correctone]]

When you view the page it shows the correct category at the bottom. However when you click on the link to view the category the page doesn't show.


Versions : Mediawiki 1.32.0, Ubuntu 18.04, PHP 7.2, MySQL 5.7


Please help!!!!!!!

MarkAHershberger (talkcontribs)

That is usually a job problem.

Do you have a cron job set up for runJobs? Does your log show any errors that might have happened that prevented MediaWiki from updating the category page?

Reply to "Pages not showing in Category"
Amirsara (talkcontribs)

HiMy number of edits on wikiTranslate and en.Wikipedia or fa.wikipedia isn’t match with each other.can I collect all of my edits in one Wikipedia?

Thanks

MarkAHershberger (talkcontribs)

Your edits on fawiki, enwiki, and other Wikimedia sites are collated on meta.

translatewiki (I think that is the site you meant) is not included there.

Reply to "Number of edits"

Categories are unable to auto updated

2
L626554583 (talkcontribs)

Hi,

I found that my wiki site is unable to handle the categories well these days. It worked well before.

After I edit some pages (e.g. AAA) with [[Category:XXX]], page AAA will show "Category:XXX". However, page Category:XXX (exist) would show the page AAA inside.

Some categories have contained some pages inside, e.g. BBB, and if I add page AAA to category of BBB, page Category:BBB will still show the previous pages in the category, instead of adding a page named AAA.


Here are the versions:

MediaWiki 1.32.0
PHP 7.1.20 (apache2handler)
MySQL 5.7.24
ICU 63.1
Lua 5.1.5


MarkAHershberger (talkcontribs)

Category handling has been one of the areas that changes in the job queue has affected.

If you set up a job to run runJobs.php regularly, you'll probably see that this problem is cleared up.

Reply to "Categories are unable to auto updated"
Tedrussell (talkcontribs)

I'd like to create a new Wiki. I've read through some of the basic help info, but the most obvious thing isn't jumping out at me. I found the following instructions:

Manual:FAQ#How do I create a new page

OK, so where do I go to "simply click the edit link ...".

I also downloaded mediawiki-1.32.0, but there doesn't appear to be an executable file in the files that I downloaded.

I'm sure there's something VERY simple I'm missing here. Can anyone help?

AhmadF.Cheema (talkcontribs)
Reply to "How to get started"

PROCEDURE c1_db_mediawiki.refresh_all_parents_for_page does not exist

7
Summary by Leaderboard

issue resolved

62.84.213.98 (talkcontribs)

Since yesterday Mediawiki suddenly stops to work. No one did an Update or something. On Page Save with VisualEditor it gives the Error in Subject.

This is the SQL Statement:

INSERT IGNORE INTO `page` (page_namespace,page_title,page_restrictions,page_is_redirect,page_is_new,page_random,page_touched,page_latest,page_len) VALUES ('0','Test_ergergegegegergegegege','','0','1','0.620618256636','20180925131212','0','0')

Malyacko (talkcontribs)
Seb35 (talkcontribs)

Perhaps a full disk or database?

62.84.213.98 (talkcontribs)

The version is 1.31.1


Another related error is when i want to delete a Page, it gives Error: 1305 PROCEDURE c1_db_mediawiki.refresh_parent_pages_for_parent_children does not exist


Why are there missing Procedures and where are they coming from? Can't find them in the Source Code, just tried to update via /mw-config/ but it says that everything is up-to-date.

77.245.46.62 (talkcontribs)

I am in the process of moving the wiki to a new server and have the same problem when creating a new article (on new server).

QUERY:

INSERT IGNORE INTO `page`   (page_id,page_namespace,page_title,page_restrictions,page_is_redirect,page_is_new,page_random,page_touched,page_late st,page_len) VALUES (NULL,'0','Hallo',</nowiki>,'0','1','0.849581375899','20190205083213','0','0')

ERROR:

1305 PROCEDURE mywiki.refresh_all_parents_for_page does not exist (localhost)

BACKTRACE:

#0 /var/www/html/mediawiki/includes/db/Database.php(1205): DatabaseBase->reportQueryError('PROCEDURE mywiki...', 1305, 'INSERT IGNORE I...', 'WikiPage::inser...', false)
#1 /var/www/html/mediawiki/includes/db/Database.php(2087): DatabaseBase->query('INSERT IGNORE I...', 'WikiPage::inser...')
#2 /var/www/html/mediawiki/includes/page/WikiPage.php(1219): DatabaseBase->insert('`page`', Array, 'WikiPage::inser...', 'IGNORE')
#3 /var/www/html/mediawiki/includes/page/WikiPage.php(1898): WikiPage->insertOn(Object(DatabaseMysqli))
#4 /var/www/html/mediawiki/includes/page/Article.php(2016): WikiPage->doEditContent(Object(WikitextContent), 'Die Seite wurde...', 97, false, Object(User), 'text/x-wiki')
#5 /var/www/html/mediawiki/includes/EditPage.php(1920): Article->__call('doEditContent', Array)
#6 /var/www/html/mediawiki/includes/EditPage.php(1305): EditPage->internalAttemptSave(Array, false)
#7 /var/www/html/mediawiki/includes/EditPage.php(539): EditPage->attemptSave(Array)
#8 /var/www/html/mediawiki/includes/actions/EditAction.php(56): EditPage->edit()
#9 /var/www/html/mediawiki/includes/actions/SubmitAction.php(40): EditAction->show()
#10 /var/www/html/mediawiki/includes/MediaWiki.php(395): SubmitAction->show()
#11 /var/www/html/mediawiki/includes/MediaWiki.php(273): MediaWiki->performAction(Object(Article), Object(Title))
#12 /var/www/html/mediawiki/includes/MediaWiki.php(566): MediaWiki->performRequest()
#13 /var/www/html/mediawiki/includes/MediaWiki.php(414): MediaWiki->main()
#14 /var/www/html/mediawiki/index.php(41): MediaWiki->run()
#15 {main}
Ciencia Al Poder (talkcontribs)

The procedure "refresh_all_parents_for_page" is not provided by MediaWiki core (MediaWiki core doesn't use procedures), but it's created by MediaWiki4Intranet/IntraACL extension:

https://github.com/mediawiki4intranet/IntraACL/blob/master/storage/intraacl-functions-mysql.sql#L112

One thing is clear: someone did change something in the database. Things don't suddenly break when people doesn't touch anything.

This extension creates the procedure, and also adds a trigger on the page table that calls to the procedure. However, looks like the procedure has been dropped, or the user has been denied the permission to execute procedures. If you want to uninstall the extension, read the instructions carefully. Otherwise, ask your host administrator about possible permission issues.

62.84.213.98 (talkcontribs)

Thank you, that was the reason. I removed the one line from the Trigger where it states "efresh_all_parents_for_page

"