Extension talk:WhosOnline

About this board

table 'fwonline' is full

3
Krabina (talkcontribs)

After quite some time of running, the wiki throws the following error

[05cd51e470bba66049647684] /w/index.php?title=Special:UserLogout&returnto=Correspondence+Collections Wikimedia\Rdbms\DBQueryError from line 1713 of /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?


Error 1114: The table 'fwonline' is full (localhost)
Function: WhosOnlineHooks::onBeforePageDisplay
Query: INSERT INTO `fwonline` (userid,username,timestamp) VALUES (0,'194.166.117.58','20231202161633') ON DUPLICATE KEY UPDATE timestamp = '20231202161633'

Backtrace:

#0 /includes/libs/rdbms/database/Database.php(1697): Wikimedia\Rdbms\Database->getQueryException()
#1 /includes/libs/rdbms/database/Database.php(1672): Wikimedia\Rdbms\Database->getQueryExceptionAndLog()
#2 /includes/libs/rdbms/database/Database.php(1241): Wikimedia\Rdbms\Database->reportQueryError()
#3 /includes/libs/rdbms/database/DatabaseMysqlBase.php(1358): Wikimedia\Rdbms\Database->query()
#4 /includes/libs/rdbms/database/Database.php(3363): Wikimedia\Rdbms\DatabaseMysqlBase->doUpsert()
#5 /includes/libs/rdbms/database/DBConnRef.php(68): Wikimedia\Rdbms\Database->upsert()
#6 /includes/libs/rdbms/database/DBConnRef.php(504): Wikimedia\Rdbms\DBConnRef->__call()
#7 /var/vps-wiki-config/extensions/ext-KM-A/WhosOnline/includes/WhosOnlineHooks.php(39): Wikimedia\Rdbms\DBConnRef->upsert()
#8 [internal function]: WhosOnlineHooks::{closure}()
#9 /includes/libs/rdbms/database/Database.php(4118): call_user_func()
#10 /includes/libs/rdbms/database/Database.php(3920): Wikimedia\Rdbms\Database->runOnTransactionIdleCallbacks()
#11 /includes/libs/rdbms/database/DBConnRef.php(68): Wikimedia\Rdbms\Database->onTransactionCommitOrIdle()
#12 /includes/libs/rdbms/database/DBConnRef.php(600): Wikimedia\Rdbms\DBConnRef->__call()
#13 /var/vps-wiki-config/extensions/ext-KM-A/WhosOnline/includes/WhosOnlineHooks.php(45): Wikimedia\Rdbms\DBConnRef->onTransactionCommitOrIdle()
#14 /includes/HookContainer/HookContainer.php(329): WhosOnlineHooks::onBeforePageDisplay()
#15 /includes/HookContainer/HookContainer.php(132): MediaWiki\HookContainer\HookContainer->callLegacyHook()
#16 /includes/HookContainer/HookRunner.php(991): MediaWiki\HookContainer\HookContainer->run()
#17 /includes/OutputPage.php(2617): MediaWiki\HookContainer\HookRunner->onBeforePageDisplay()
#18 /includes/MediaWiki.php(954): OutputPage->output()
#19 /includes/MediaWiki.php(967): MediaWiki->{closure}()
#20 /includes/MediaWiki.php(547): MediaWiki->main()
#21 /index.php(53): MediaWiki->run()
#22 /index.php(46): wfIndexMain()
#23 {main}

Is there some kind of maintenance requested? Running update.php did not help. Had to deactivate the extension to being able to log in again.

Krabina (talkcontribs)
Silkwood (talkcontribs)

Same horror here but the table is now:

Error 1114: The table 'online' is full (localhost)

Select count(*) from online=16

Product Version
MediaWiki 1.40.1
PHP 7.4.3-4ubuntu2.19 (apache2handler)
ICU 66.1
MariaDB 10.3.38-MariaDB-0ubuntu0.20.04.1
Pygments 2.11.2
Lua 5.1.5
LilyPond 2.20.0
Elasticsearch 7.10.2
Reply to "table 'fwonline' is full"

Use of User::getOption was deprecated in MediaWiki 1.35

1
Summary by Pascale.guyot

Found a patch in Gerrit.

Thanks for attention.

Pascale.guyot (talkcontribs)

Hi,

Recent upgrade to MediaWiki 1.39.1 showed this error in WhosOnlineHooks.php at line 27. Do you have any idea how to fix this? I am a simple Mediawiki user and downloaded the latest extension package.

Thanks a lot!

Reply to "Use of User::getOption was deprecated in MediaWiki 1.35"

Update.php failed with MariaDB 10.4.17

2
Hgmaerkle (talkcontribs)

Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'varchar(255) NOT NULL default '' AFTER `timestamp`' at line 1

SeelTeam6 (talkcontribs)

This appears to have been fixed in the 1.40 release, but for anyone facing this issue on the 1.39 release, you have to replace the line in "sql/patch-add-wikiid-field" with:

ALTER TABLE /*_*/online ADD COLUMN wikiid varchar(255) NOT NULL default '' AFTER `timestamp`;

Reply to "Update.php failed with MariaDB 10.4.17"

Does WhosOnline show bots that are logged in?

1
Revansx (talkcontribs)

If I use a bot, say pywikibot, to do maintenance on my wiki. Should I expect WhosOnline to list it as one of the users who is logged in? If so, is there a way to hide bots?

Reply to "Does WhosOnline show bots that are logged in?"

Feature Request - WhosOnline from a specific group

1
Revansx (talkcontribs)

How hard would it be to add a "group" parameter to the Special:Whosonline page? .. This would make it possible to show users which admins are online.

Reply to "Feature Request - WhosOnline from a specific group"

Error on line 89 of WhosOnlineSpecialPage.php

3
Revansx (talkcontribs)

Using:

  • MW - 1.31.1
  • WhosOnline - 1.7.2 (e23d87d) 05:31, 13 June 2019

I seeing the following error when I visit "Special:WhosOnline"

[XReHT@hdXZ97hNySFPpbLgAAAAA] /demo/index.php/Special:WhosOnline Error from line 89 of /opt/htdocs/mediawiki/extensions/WhosOnline/WhosOnlineSpecialPage.php: Call to undefined method PagerWhosOnline::buildPrevNextNavigation()

Backtrace:
#0 /opt/htdocs/mediawiki/extensions/WhosOnline/WhosOnlineSpecialPage.php(157): PagerWhosOnline->getNavigationBar()
#1 /opt/htdocs/mediawiki/includes/specialpage/SpecialPage.php(522): SpecialWhosOnline->execute(NULL)
#2 /opt/htdocs/mediawiki/includes/specialpage/SpecialPageFactory.php(568): SpecialPage->run(NULL)
#3 /opt/htdocs/mediawiki/includes/MediaWiki.php(288): SpecialPageFactory::executePath(Title, RequestContext)
#4 /opt/htdocs/mediawiki/includes/MediaWiki.php(861): MediaWiki->performRequest()
#5 /opt/htdocs/mediawiki/includes/MediaWiki.php(524): MediaWiki->main()
#6 /opt/htdocs/mediawiki/index.php(42): MediaWiki->run()
#7 {main}

Is this a new issue wrt MW 1.31.1?

Rajeshrajesh.35 (talkcontribs)

i am too getting this error, using mediawiki 1.30

Reply to "Error on line 89 of WhosOnlineSpecialPage.php"

Navigation Controls??

2
Revansx (talkcontribs)

I'm running v1.7.2 on MW 1.31.1 and {{:Special:WhosOnline/10/shownav}} doesn't do anything different than {{:Special:WhosOnline}}. Am I missing something?

Manorainjan (talkcontribs)

And if You omit "/shownav"?

Reply to "Navigation Controls??"
Manorainjan (talkcontribs)

I do not find information about how long (after the last user activity?) the display will be held?

Reply to "Time?"
There are no older topics