Extension talk:WhosOnline

Adding wikiid field to table online...Wikimedia\Rdbms\DBQueryError from line 1618 of /../includes/libs/rdbms/database/Database.php: 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
Function: Wikimedia\Rdbms\Database::sourceFile( /../extensions/WhosOnline/includes/../sql/patch-add-wikiid-field.sql )
Query: ALTER TABLE `07000_online` ADD COLUMN varchar(255) NOT NULL default '' AFTER `timestamp`


#0 /../includes/libs/rdbms/database/Database.php(1602): Wikimedia\Rdbms\Database->getQueryException()
#1 /../includes/libs/rdbms/database/Database.php(1576): Wikimedia\Rdbms\Database->getQueryExceptionAndLog()
#2 /../includes/libs/rdbms/database/Database.php(952): Wikimedia\Rdbms\Database->reportQueryError()
#3 /../includes/libs/rdbms/database/Database.php(3302): Wikimedia\Rdbms\Database->query()
#4 /../includes/libs/rdbms/database/Database.php(3241): Wikimedia\Rdbms\Database->sourceStream()
#5 /../includes/libs/rdbms/database/DBConnRef.php(103): Wikimedia\Rdbms\Database->sourceFile()
#6 /../includes/libs/rdbms/database/DBConnRef.php(807): Wikimedia\Rdbms\DBConnRef->__call()
#7 /../includes/installer/DatabaseUpdater.php(729): Wikimedia\Rdbms\DBConnRef->sourceFile()
#8 /../includes/installer/DatabaseUpdater.php(802): DatabaseUpdater->applyPatch()
#9 /../includes/installer/DatabaseUpdater.php(547): DatabaseUpdater->addField()
#10 /../includes/installer/DatabaseUpdater.php(515): DatabaseUpdater->runUpdates()
#11 /../maintenance/update.php(209): DatabaseUpdater->doUpdates()
#12 /../maintenance/includes/MaintenanceRunner.php(309): UpdateMediaWiki->execute()
#13 /../maintenance/doMaintenance.php(85): MediaWiki\Maintenance\MaintenanceRunner->run()
#14 /../maintenance/update.php(319): require_once('/var/www/htdocs...')
#15 {main}

This is what I am getting on REL1_39 of the extension. If I move to REL1_40, the issue goes away due to this fix. To cut it short, use REL1_40 for MediaWiki 1.39.x!

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.

https://phabricator.wikimedia.org/T352602

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

Found a patch in Gerrit.

Thanks for attention.

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!

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

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`;

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?

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.

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?

i am too getting this error, using mediawiki 1.30

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?

And if You omit "/shownav"?

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