My current setup, under which MW is running swimmingly:
Fedora 27
Apache 2.4.33
MariaDB 10.2.14
MediaWiki 1.30.0
I am attempting to upgrade to MW 1.31.0. I unzipped the tarball into a
fresh directory, copied over my LocalSettings.php file, and changed the
symlink that I use with Apache to point to the new location. I then
attempted to run maintenance/update.php and it cryptically ended with a
whimper:
====================
MediaWiki 1.31.0 Updater
Your composer.lock file is up to date with current dependencies!
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 (skip this countdown with
--quick) ... 0
Turning off Content Handler DB fields for this part of upgrade.
Adding ipb_id field to table ipblocks ...Set $wgShowExceptionDetails =
true; and $wgShowDBErrorBacktrace = true; at the bottom of
LocalSettings.php to show detailed debugging information.
====================
I added the suggested flags to LocalSettings and got the following in my
browser:
====================
[WyJ-joCjti3zg1lzHPXHqQAAAAM] /wiki/Main_Page Wikimedia\Rdbms\DBQueryError
from line 1457 of
/var/www/gpf/mediawiki-1.31.0/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
user_id,user_name,user_real_name,user_email,user_touched,user_token,user_email_authenticated,user_email_token,user_email_token_expires,user_registration,user_editcount
FROM `mediawiki`.`user` WHERE user_id = '1' LIMIT 1
Function: User::loadFromDatabase
Error: 1142 SELECT command denied to user 'wikiuser'@'localhost' for table
'user' (localhost)
Backtrace:
#0
/var/www/gpf/mediawiki-1.31.0/includes/libs/rdbms/database/Database.php(1427):
Wikimedia\Rdbms\Database->makeQueryException(string, integer, string,
string)
#1
/var/www/gpf/mediawiki-1.31.0/includes/libs/rdbms/database/Database.php(1200):
Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string,
boolean)
#2
/var/www/gpf/mediawiki-1.31.0/includes/libs/rdbms/database/Database.php(1653):
Wikimedia\Rdbms\Database->query(string, string)
#3
/var/www/gpf/mediawiki-1.31.0/includes/libs/rdbms/database/Database.php(1730):
Wikimedia\Rdbms\Database->select(array, array, array, string, array, array)
#4 /var/www/gpf/mediawiki-1.31.0/includes/user/User.php(1407):
Wikimedia\Rdbms\Database->selectRow(array, array, array, string, array,
array)
#5 /var/www/gpf/mediawiki-1.31.0/includes/user/User.php(537):
User->loadFromDatabase(integer)
#6
/var/www/gpf/mediawiki-1.31.0/includes/libs/objectcache/WANObjectCache.php(1240):
User->{closure}(boolean, integer, array, NULL)
#7
/var/www/gpf/mediawiki-1.31.0/includes/libs/objectcache/WANObjectCache.php(1110):
WANObjectCache->doGetWithSetCallback(string, integer, Closure, array)
#8 /var/www/gpf/mediawiki-1.31.0/includes/user/User.php(561):
WANObjectCache->getWithSetCallback(string, integer, Closure, array)
#9 /var/www/gpf/mediawiki-1.31.0/includes/user/User.php(482):
User->loadFromCache()
#10 /var/www/gpf/mediawiki-1.31.0/includes/user/User.php(420):
User->loadFromId(integer)
#11 /var/www/gpf/mediawiki-1.31.0/includes/session/UserInfo.php(88):
User->load()
#12
/var/www/gpf/mediawiki-1.31.0/includes/session/CookieSessionProvider.php(119):
MediaWiki\Session\UserInfo::newFromId(string)
#13 /var/www/gpf/mediawiki-1.31.0/includes/session/SessionManager.php(488):
MediaWiki\Session\CookieSessionProvider->provideSessionInfo(WebRequest)
#14 /var/www/gpf/mediawiki-1.31.0/includes/session/SessionManager.php(191):
MediaWiki\Session\SessionManager->getSessionInfoForRequest(WebRequest)
#15 /var/www/gpf/mediawiki-1.31.0/includes/WebRequest.php(736):
MediaWiki\Session\SessionManager->getSessionForRequest(WebRequest)
#16 /var/www/gpf/mediawiki-1.31.0/includes/session/SessionManager.php(130):
WebRequest->getSession()
#17 /var/www/gpf/mediawiki-1.31.0/includes/Setup.php(847):
MediaWiki\Session\SessionManager::getGlobalSession()
#18 /var/www/gpf/mediawiki-1.31.0/includes/WebStart.php(88):
require_once(string)
#19 /var/www/gpf/mediawiki-1.31.0/index.php(39): require(string)
#20 {main}
====================
Needless to say, I'm pretty confused here. Nothing has changed to my
configuration (and probably to the wiki's contents) since I successfully
upgraded to 1.30.0. If I switch my symlink back to point to my MW 1.30.0
install, the site loads just fine. So it appears the updater is bombing
when it tries to add the field "ipb_id" to table "ipblocks".
What confuses me is the "SELECT command denied to user 'wikiuser'@'localhost'"
error. My wiki has two MariaDB users: "wikuser" (the standard user set in
$wgDBuser) and an admin user set with $wgDBadminuser. Neither user account
has changed, either in the DB or in LocalSettings.
It *almost* looks like the updater is trying to use the standard user to do
admin functions, but even that doesn't make much sense. "wikiuser" has
SELECT access to all tables in the DB, while the admin user has all
permissions to the entire DB. So I don't see why that specific error would
crop up; even "wikiuser" should be able to perform a simple SELECT.
Fortunately, I can switch back to MW 1.30.0 pretty easily, but I thought I
ought to report the problem.
ADDENDUM: I just noticed the following in the 1.31 release notes:
====================
Important pre-upgrade notes for 1.31
- If you're using MySQL, SQLite, or MSSQL, are not using update.php to
apply schema changes, and cannot have downtime to run
migrateArchiveText.php and apply patch-drop-ar_text.sql manually, you'll
have to apply a default value to the ar_text and ar_flags columns of the
archive table or make those columns nullable before upgrading to MediaWiki
1.31. maintenance/archives/patch-nullable-ar_text.sql shows how to do this
for MySQL.
====================
Based on this, I think there's something screwy with update.php. I *am*
using update.php to apply schema changes, but I'm guessing it's not working
correctly. I have *not* tried this manual fix (and would prefer not to
unless absolutely necessary).
Jeffrey T. Darlington
General Protection Fault
https://www.gpf-comics.com/
Hello,
Is there any documentation or a link i could visit to
understand the concept of how the formatter URL works in wikibase for
external identifiers and what extensions or configuration needs to be
done to enable it. On wikidata we see that any external identifier with
a value on click redirects to the corresponding external domain page and
this functionality is missing from our local installation of mediawiki
with wikibase. Any assistance would be of help.
Thanks & Regards,
Srinivas
Heiya,
I think that the docu to $wgEmailAuthentication was wrong so I changed
it [0]. I have a wiki which was switched to "false" as a setting and I
still get notifications since the respective user preference options for
email notifications are selected on special page "Preferences". I want
to make sure that the docu is correct.
Moreover all the related configuration parameters like e.g.
$wgEnotifUserTalk state that they are being ignored if the setting to
$wgEmailAuthentication is "false". I guess these need to be changed too?
Alternatively it may be the case that the selection of a user via
special page Preferences for the respective preference options override
whatever one set via the respective configuration parameters. This would
have to be noted too.
I would like to sort this out properly. Thanks for your insights.
Cheers,
Karsten
PS I believe that it makes sense to send notifications to emails if
provided even if they were not authenticated in a second step. Probably
you would not like to have this on a public wiki with high activity but
this is another story.
[0]
https://www.mediawiki.org/w/index.php?title=Manual%3A%24wgEmailAuthenticati…
anyone know how to sync the pages of a namespace in one wiki to another wiki on the same server?
I the same server, I'd like to configure a wiki (say wiki 1) such that any page created or edited in namespace X on wiki 1 is automatically saved to namespace Y on wiki 2. I'd like this to be occur behind the scenes automatically. Has anyone done this before?
-Rich
WikiApiary has been giving the following error message as of this week:
Error in widget Website graphs: unable to write file
/srv/www/mediawiki/public_html/w/extensions/Widgets/compiled_templates/wrt5b
34f55b806fd6_80086149
Does anyone know what is the cause of this issue? As far as I can tell, it
is impacting all wikis being tracked.
Thanks.
Andrew
Andrew Geary | Publications Outreach and EVOLVE Program Manager
+1.918.497.4615 | ageary(a)seg.org
Society of Exploration Geophysicists (SEG)
8801 South Yale Ave, Ste. 500, Tulsa, OK 74137 USA
Hi,
A new episode of the MediaWiki podcast "Between the Brackets" was released
yesterday - this one an interview with Markus Krötzsch, now a CS professor,
formerly the co-creator and lead developer of Semantic MediaWiki, and an
important figure in the history of Wikidata. You can listen to the episode
here:
http://betweenthebrackets.libsyn.com/episode-11-markus-krtzsch
-Yaron
Hello, I'm the admin of a mediawiki, & have posted to an incorrect
thread & have been redirected here...
My main initial queries is/are
a) I occasionally check my wiki & see there are dozens / hundreds of
people signing up as users - but no one is creating any pages.
is there a place i can see that can check that people CAN create pages
- but they are pending / needing approval to be published ?
i'm guessing that people create new accounts but cant do anything. how
do i check ?
b) is there something i can do to force the wiki to send an email to
the admin (me) - to check that i am receiving emails. (I periodically
forget about this wiki as i'm not getting anything).
c) where do i (if i can) edit the script to use my own mailing process
instead of the default process to send emails.
--
Gordon.
Howdy,
There is an IRC office hour scheduled next week to discuss
improvements to the mobile MediaWiki web site for contribution tools
and workflows. It will be from 16:00-17:00 UTC Monday 25 June 2018.
Links to join are on Meta. [0]
The Readers web team would like to make more contribution tools (like
Special: pages) available on mobile. Come talk to us about what you
want to see the most. More information on what we'd like to discuss
can be found on MediaWiki.org. [1]
I hope you can make it. If not, please take a look at the project page
and leave any comments on the talk page.
[0] https://meta.wikimedia.org/wiki/IRC_office_hours#Upcoming_office_hours
[1] https://www.mediawiki.org/wiki/Reading/Web/Advanced_mobile_contributions
Yours,
Chris Koerner
Community Liaison
Wikimedia Foundation
Out of curiosity, why is the sidebar getting replaced by a blank sidebar
for private wikis not automatic yet requires hacks? Doesn't seem
particularly difficult to merge into core...setting read access hides the
wiki content yet left the sidebar exposed...
On Mon, Jun 18, 2018, 8:01 AM <mediawiki-l-request(a)lists.wikimedia.org>
wrote:
> Send MediaWiki-l mailing list submissions to
> mediawiki-l(a)lists.wikimedia.org
>
> To subscribe or unsubscribe via the World Wide Web, visit
> https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
> or, via email, send a message with subject or body 'help' to
> mediawiki-l-request(a)lists.wikimedia.org
>
> You can reach the person managing the list at
> mediawiki-l-owner(a)lists.wikimedia.org
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of MediaWiki-l digest..."
>
>
> Today's Topics:
>
> 1. Sidebar hacks for Timeless (Samuel Walker)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Sun, 17 Jun 2018 20:38:31 -0400
> From: Samuel Walker <samueledwardwalker3(a)gmail.com>
> To: mediawiki-l(a)lists.wikimedia.org
> Subject: [MediaWiki-l] Sidebar hacks for Timeless
> Message-ID:
> <CAEQSh_OZK4=
> 457zH9xLW3osD1rqY-gdJdhcpJRs9X242Xs4z1Q(a)mail.gmail.com>
> Content-Type: text/plain; charset="UTF-8"
>
> Hi, does anyone know how to make this sidebar hack work in Timeless?
> https://www.mediawiki.org/wiki/Manual:Interface/Sidebar/Hacks
>
> Or is there another hack that can accomplish the same thing in Timeless
> (making the sidebar blank for non-logged-in users, to protect the privacy
> of a non-public wiki)? Thanks. -Sam
>
>
> ------------------------------
>
> Subject: Digest Footer
>
> _______________________________________________
> MediaWiki-l mailing list
> MediaWiki-l(a)lists.wikimedia.org
> https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
>
>
> ------------------------------
>
> End of MediaWiki-l Digest, Vol 177, Issue 11
> ********************************************
>