Project:Support desk

Jump to: navigation, 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, Q&A 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".
By clicking "Add topic", you agree to our Terms of Use and agree to irrevocably release your text under the CC BY-SA 3.0 License and GFDL
Cbo0485 (talkcontribs)

I recently followed the instructions found at http://www.linuxintro.org/wiki/Migrating_mediawiki_from_mysql_to_sqlite to move my database form MySql to SQLITE3.  In doing this, everything went pretty smoothly, however searches just don't work anymore.  The only way a search works is if I have the exact name of the page, in my search.  Obviously this removes the best benefit of a search.  I found through some research that I need to try to rebuild the searchindex table, but to do this I need to run the update.php.  When I do this, I get an error.  Anyone know how to get around this so I can try to rebuild my searchindex?

MediaWiki 1.25.1 Updater

Your composer.lock file is up to date with current dependencies!

Going to run database updates for wikidb

Using SQLite file: '/path/to/our/db/sqlite3/wikidb.sqlite'

Depending on the size of your database this may take a while!

Abort with control-c in the next five seconds (skip this countdown with --quick) ... 0

Turning off Content Handler DB fields for this part of upgrade.

...have ss_active_users field in site_stats table.

...ss_active_users user count set...

...have ipb_allow_usertalk field in ipblocks table.

Adding initial indexes ...PHP Notice:  Uninitialized string offset: 0 in /path/to/ourwiki/wiki/includes/db/Database.php on line 2717

Notice: Uninitialized string offset: 0 in /path/to/ourwiki/wiki/includes/db/Database.php on line 2717

PHP Notice:  Uninitialized string offset: 0 in /path/to/ourwiki/wiki/includes/db/Database.php on line 2717

Notice: Uninitialized string offset: 0 in /path/to/ourwiki/wiki/includes/db/Database.php on line 2717

A database query error has occurred.

Query: CREATE TABLE archive_tmp (

 ar_id NOT NULL PRIMARY KEY clustered IDENTITY,

 ar_namespace INTEGER NOT NULL DEFAULT 0,

 ar_title NVARCHAR(255) NOT NULL DEFAULT '',

 ar_text NVARCHAR(MAX) NOT NULL,

 ar_comment NVARCHAR(255) NOT NULL,

 ar_user INTEGER NULL REFERENCES [user](user_id) ON DELETE SET NULL,

 ar_user_text NVARCHAR(255) NOT NULL,

 ar_timestamp TEXT NOT NULL DEFAULT GETDATE(),

 ar_minor_edit BIT NOT NULL DEFAULT 0,

 ar_flags NVARCHAR(255) NOT NULL,

 ar_rev_id INTEGER,

 ar_text_id INTEGER,

 ar_deleted BIT NOT NULL DEFAULT 0,

 ar_len INTEGER DEFAULT NULL,

 ar_page_id INTEGER NULL,

 ar_parent_id INTEGER NULL

 )

Function: DatabaseBase::sourceFile( /path/to/ourwiki/wiki/maintenance/sqlite/archives/initial-indexes.sql )

Error: 1 near "clustered": syntax error

MarkAHershberger (talkcontribs)

What version of sqlite are you using?

Cbo0485 (talkcontribs)

sqlite3 --version

3.6.20

Cbo0485 (talkcontribs)

Don't like bumping threads, but i'm really stuck at this point, anyone seen this before and know how to fix it?

Reply to "Rebuild SearchIndex after DB Migration"

SimpleSAML extension with Mediawiki 1.27.1

3
Ashni rai (talkcontribs)

I'm trying to migrate our mediawiki from 1.23.5 to 1.27.1. But the SimpleSAML extension is throwing a HTTP 500 error. I'm not able to rectify the error since am quite new to SimpleSAML. PFB configuration changes made in Localsettings.php. Is there any other config changes to be made other than the following.Thanks.

wfLoadExtension( 'PluggableAuth' ); 
$wgPluggableAuth_EnableAutoLogin = false;
$wgPluggableAuth_EnableLocalLogin = false; 
$wgPluggableAuth_Class = "SimpleSAMLphp"; 
wfLoadExtension( 'SimpleSAMLphp' ); 
$wgSimpleSAMLphp_InstallDir = 'C:\MediaWiki\mediawiki-1.27.1\extensions\SimpleSAMLphp';
$wgSimpleSAMLphp_AuthSourceId = 'default-sp';
$wgSimpleSAMLphp_RealNameAttribute = //cn;
$wgSimpleSAMLphp_EmailAttribute = //mail;
$wgSimpleSAMLphp_UsernameAttribute = //uid;
MarkAHershberger (talkcontribs)

I'm confused about the last three lines. Why are you putting slashes in front of cn, mail, and uid instead of surrounding them with quotes?

MarkAHershberger (talkcontribs)
  1. What is the error you're seeing?
  2. Could you replace the backslashes in $wgSimpleSAMLphp_InstallDir with forward slashes so that you have
$wgSimpleSAMLphp_InstallDir = 'C:/MediaWiki/mediawiki-1.27.1/extensions/SimpleSAMLphp';
Reply to "SimpleSAML extension with Mediawiki 1.27.1"

Error creating thumbnail: Unable to save thumbnail to destination

11
Star Warden (talkcontribs)

Hey. I keep getting this error button and I don't know how to fix it. It can be seen here: http://dragon-mania-legends-wiki.mobga.me/Ruins, here: http://dragon-mania-legends-wiki.mobga.me/Habitats and here: http://dragon-mania-legends-wiki.mobga.me/Category:Images:Calendar_Events

I've tried setting a temp folder ($wgTmpDirectory = "$IP/images/temp";) and a debug file ($wgDebugLogFile = "/var/log/mediawiki/debug-{$wgDBname}.log";) as suggested and even made the temp folder writable by the server using chown, but that did not work.

The manual on how to debug specifies that this log can contain sensibile information, thus I won't post all of its contents and would like to know what could I share here from it that would help in solving this issue?

I mention the console is displaying some weird errors, but I cannot interpret them, sadly.

MarkAHershberger (talkcontribs)

Looking at your Special:NewFiles, it looks like you are able to upload images without problem, but those particular images cause a problem.

I can use thumb.php to create thumbnails of various sizes (see also).

thumb.php appears to work on images that show the problem.

Meanwhile, fails to produce thumb.php some thumbnails for the problematic images.

Maybe you can see what is produced in the debug log when one of the failing thumb.php links is called?

Star Warden (talkcontribs)

I found no recent instance of the cupcake thumb (at least the date isn't displayed when such calls are made, so it might be recent), thus I also included something more recent. The cupcake thumb is at the very top, the others are separated by a large space: http://pastebin.com/Yg6V1Zr6 Hope it helps!

MarkAHershberger (talkcontribs)

I'm at a loss. I don't really know how to help you without access to your machine. Sorry. Perhaps you can check the permissions on all the directories in your images folder to see if one or two has funky permissions.

Ciencia Al Poder (talkcontribs)

What if you set $wgShowExceptionDetails to true temporarily and open the problematic thumb.php URL?

Star Warden (talkcontribs)

That string was already set to true even before the problem occurred. But here's the strange thing. If you go and check my first two links (ruins and habitats), you'll see that the problem was solved on its own...

Here's a screenshot of the permissions that all folders seem to have: http://prnt.sc/em8bhd I selected all of them, and made sure they are all set to that. Do I need to change anything?

I forgot to mention that when renaming the file, the issue seems to disappear (of course, there's a reason I named them the way I did, in the first place, thus this isn't a good solution or the solution for that matter). And, in some cases, the issue is triggered only if I get over a certain pixel size while adding it to the article. Would manually moving the images (on the server) from one folder to another solve it? Is it even safe to do that?

MarkAHershberger (talkcontribs)

The permissions look fine if that user is the user that runs as the web server. You could also change the permissions on images to the numeric code 777 and recurse through the images directory.

You could move the images directory, but you would need to change a few configuration options like Manual:$wgUploadPath or Manual:$wgUploadPath. You might also need to use Manual:Img auth.php to stream images.

Star Warden (talkcontribs)

I am not sure if that user is the one that runs as the web server.. I was using the root account. How do I find out who it is?

Also, the second option you gave me is the same as the first one. I was asking if I could only move the images that cause trouble, not the whole directory. Seems kinda pointless to move the whole thing just for a few troublemakers.

MarkAHershberger (talkcontribs)
  • I don't recognize the tool you are using for ftp. But what does the full listing of the mediawiki directory show? Maybe that would have user names on it.
  • If you can physically remove the primary uploaded problematic file, then I think you could re-upload it. That might solve the problem.
Star Warden (talkcontribs)
  • I use FileZilla Client. I am not sure what you're referring to. Is this it:http://prnt.sc/emeu0n ?
  • By physically removing it, you mean to manually delete it from the server itself or from the wiki? Because if it's the latter, it doesn't work.
MarkAHershberger (talkcontribs)
  • That has the information I wanted. It looks like you're on a Debian server and the permissions are set correctly.
  • I meant from the server itself.
  • Could you use FileZilla to get the listing of the images/thumb/9/90 and images/thumb/9/90/The_Winds_of_November_Event_%2816.11.14%29.jpg directory?
Reply to "Error creating thumbnail: Unable to save thumbnail to destination"

docserver-http-error: (curl error: 28)

4
Summary by Exodk

Moving to ubuntu server

Exodk (talkcontribs)

Using Visual editor

Windows Server 2012 R2

when trying to save page iv have just made - times out with the following error:

docserver-http-error: (curl error: 28) Timeout was reached

any help will be greatly appreciated

AKlapper (WMF) (talkcontribs)

Parsoid#Troubleshooting ? :)

Exodk (talkcontribs)

isn't Parsoid only used if using linux as the operating system?

Exodk (talkcontribs)

ive decided im going to move to ubuntu server.

Sasazuka! (talkcontribs)

On my local wiki I'm using MediaWiki:Gadget-Edittools.js & MediaWiki:Edittools (the code's copied from this wiki), and it works fine, but the charinsert toolbar is placed below the text field and save/preview buttons. How can I move the Edittools bar on top (above the "enhanced editing toolbar")? Is there any code to do so?

MediaWiki: 1.29-wmf15

Skin: Vector

Sasazuka! (talkcontribs)

Bump

Ciencia Al Poder (talkcontribs)

You'll need a script like this:

// Move edittools charinsert before wikieditor toolbar
$(function() { $('#mw-edittools-charinsert').insertBefore('.wikiEditor-ui'); });
Reply to "Edittools bar on top"

Two sections of blank parameters in a template are generating a break tag

2
Ms784 (talkcontribs)

I've created a template for listing specifications for fire apparatus in my mediawiki. The headers have an #if statement that hide them if certain parameters are blank. If two (or more) consecutive sections are blank, a <BR /> is being generated and creating an unwanted space in the middle of my text. Any thoughts on how to prevent this?

In the example, the "aerial" and "body" sections are left blank and are causing a space between the "pump & tank" and "equipment" sections.

URL to template: http://signal-12.com/wiki/Template:Apparatus_specifications

URL to page showing the break: http://signal-12.com/wiki/2-Tanker_(1995)

Ciencia Al Poder (talkcontribs)

This happens because there's a blank line before the {{#if that open each group. You should put it next to the end }} of the previous. If you need a new line when the parameter is filled, you need to add it inside the {{#if:, by adding a <nowiki> before it to prevent the parser function to trim blank spaces.

If you want newlines to make your code more readable, you can use it inside HTML comments, like:

}}<!--

-->{{#if: whatever
Reply to "Two sections of blank parameters in a template are generating a break tag"
Jfoster81747 (talkcontribs)

Ive an installed working Mediawiki 1.28.0 For some reason when a system call for example the portal page call Ducks in a row which this mediawiki interprets correctly as asking for a portal page, on my site the system interprets this same exact call as asking for a template. Template:Ducks in a row which does not exist

any idea on what is configured incorrectly so that I can get this corrected. I have a thought that it may be a namespace issue, but I have no way to be sure. Any tips are appreciated.

John

MarkAHershberger (talkcontribs)

Have you created a portal namespace?

Jfoster81747 (talkcontribs)

No I was not sure that is what I need to do. I will do that and report back.

Thanks

John

Reply to "Portal vs Template Recognition"

Page refresh / update problem after upgrading MW from v1.24 to v1.28

4
Danielator (talkcontribs)

Hello,

after upgrading our previous V1.24 MW to a new fresh 1.28, I notice that we need multiple browser refresh after a page modification, particularly noticeable on Template pages.

Installed software

MediaWiki v1.28.0 PHP v5.6.28 (fpm-fcgi)

MySQL v5.6.34

ICU v52.1

It's a private wiki on a private network.

has someone encountered this problem ?

Thanks

Daniel

MarkAHershberger (talkcontribs)

Job queue handling has changed and this is probably what causes the behavior you are seeing.

See the history section here: Manual:Job queue

Danielator (talkcontribs)

Thanks MarkAHershberge

you are right, it is a job problem.

Using the api's statistics I found more than 800 jobs waiting.

In a console, I ran the maintenance script "runJobs.php", it worked during 20s, while the jobs decreased in the statistics page, down to zero.

Now, sometime, the job counter stay non-zero, like if some jobs are stuck.

Is there a way to debug "jobs queuing", through logs ?

MarkAHershberger (talkcontribs)

You should probably set up a cron job to run the job queue periodically.

Reply to "Page refresh / update problem after upgrading MW from v1.24 to v1.28"
শাহাদাত সায়েম (talkcontribs)

in my wiki site google ocr buttton do not show , how can I solve this problem ? please help . thanks-~~~~

MarkAHershberger (talkcontribs)

I'm not sure why a Google OCR button would show up. I don't even know what one is. The closest relevant thing that I found was a Google Drive feature but it doesn't look like you're talking about that.

শাহাদাত সায়েম (talkcontribs)

Please see : https://www.mediawiki.org/wiki/Manual:Custom_edit_buttons But I don't konw how Can I add this. Please help

Malyacko (talkcontribs)

The page that you link to explains how you can add this. If some specific parts are unclear, please explain why so someone else could provide an explanation.

শাহাদাত সায়েম (talkcontribs)

example: Google OCR button . please tell me this code for ocr button . thanks

MarkAHershberger (talkcontribs)

I'm still confused about what you would want such a button to do. Adding an OCR button seems meaningless.

শাহাদাত সায়েম (talkcontribs)

I want to proofing pdf book

MarkAHershberger (talkcontribs)

It sounds like you want to hire a developer to implement this for you. I cannot help you to accomplish what you want here on the support desk.

Reply to "OCR button"

VisualEditor 404 after changing Wiki's LocalSettings.php

8
Quinnj09 (talkcontribs)

I have set up a new mediawiki (1.28.0) and added the extension VisualEditor. When browsing to the wiki on the local machine using http://localhost/wiki/ it all works fine and visualeditor and parsoid works as expected. But as soon as I change mediawiki LocalSettings.php $wgServer = "http://localhost"; to $wgServer = "http://serverdomainname"; I get the following in Parsoid:

{"name":"parsoid","hostname":"serverdomainname","pid":4132,"level":60,"err":{"message"
:"Invalid domain: serverdomainname","name":"lib/index.js","stack":"lib/index.js:
 Invalid domain: serverdomainname\n    at errOut (C:\\Program Files (x86)\\parso
id\\lib\\api\\routes.js:30:13)\n    at routes.v3Middle (C:\\Program Files (x86)\
\parsoid\\lib\\api\\routes.js:94:11)\n    at Layer.handle [as handle_request] (C
:\\Program Files (x86)\\parsoid\\node_modules\\express\\lib\\router\\layer.js:95
:5)\n    at next (C:\\Program Files (x86)\\parsoid\\node_modules\\express\\lib\\
router\\route.js:131:13)\n    at Route.dispatch (C:\\Program Files (x86)\\parsoi
d\\node_modules\\express\\lib\\router\\route.js:112:3)\n    at Layer.handle [as
handle_request] (C:\\Program Files (x86)\\parsoid\\node_modules\\express\\lib\\r
outer\\layer.js:95:5)\n    at C:\\Program Files (x86)\\parsoid\\node_modules\\ex
press\\lib\\router\\index.js:277:22\n    at param (C:\\Program Files (x86)\\pars
oid\\node_modules\\express\\lib\\router\\index.js:349:14)\n    at param (C:\\Pro
gram Files (x86)\\parsoid\\node_modules\\express\\lib\\router\\index.js:365:14)\
n    at param (C:\\Program Files (x86)\\parsoid\\node_modules\\express\\lib\\rou
ter\\index.js:365:14)\n    at param (C:\\Program Files (x86)\\parsoid\\node_modu
les\\express\\lib\\router\\index.js:365:14)\n    at param (C:\\Program Files (x8
6)\\parsoid\\node_modules\\express\\lib\\router\\index.js:365:14)\n    at Functi
on.process_params (C:\\Program Files (x86)\\parsoid\\node_modules\\express\\lib\
\router\\index.js:410:3)\n    at next (C:\\Program Files (x86)\\parsoid\\node_mo
dules\\express\\lib\\router\\index.js:271:10)\n    at C:\\Program Files (x86)\\p
arsoid\\lib\\api\\ParsoidService.js:159:3\n    at Layer.handle [as handle_reques
t] (C:\\Program Files (x86)\\parsoid\\node_modules\\express\\lib\\router\\layer.
js:95:5)","httpStatus":404,"suppressLoggingStack":true,"levelPath":"fatal/reques
t"},"msg":"Invalid domain: serverdomainname","time":"2017-03-09T08:48:29.886Z","
v":0}

Can anyone help? I can provide more config settings if im looking in the wrong place?

Ciencia Al Poder (talkcontribs)

Looks like your server can't resolve the domain name you provided

Quinnj09 (talkcontribs)

I dont understand why not when 'serverdomainname' is the server that both the mediawiki installation and parsoid is on. should it be pointing at 'serverdomainname' or 'localhost'? but neither seem to work

Quinnj09 (talkcontribs)

No matter what I set it to, it tells me invalid domain

MarkAHershberger (talkcontribs)

If you are running parsoid on the same server as your wiki, try "localhost". Otherwise, try pinging the hostname from the parsoid server on the command line. If that fails (it should in your case) then add the host's name and IP to /etc/hosts.

This comment was hidden by Quinnj09 (history)
Quinnj09 (talkcontribs)

Oddly, the thing that fixed it, was I put parsoid into debug mode, it worked fine, took it back out of debug mode, it continued to work, maybe theres some rare bug I stumbled over?

Ciencia Al Poder (talkcontribs)

Maybe the change in setting wasn't saved correctly, or the value was cached somehow, or you needed to restart some service...