Page MenuHomePhabricator

Fatal exception: Invalid non-numeric limit passed to limitResult()
Closed, ResolvedPublic


I'm attempting to install the Patroller extension. I backed up my db, added the extension to LocalSettings.php, and then ran the update script (which appeared to run successfully), but when I navigate to the special page for the extension I get the fatal exception error:
Fatal exception of type "Wikimedia\Rdbms\DBUnexpectedError"

I'm running
MediaWiki 1.33.0
PHP 7.2.19-0ubuntu0.18.04.2 (fpm-fcgi)
MySQL 5.7.27-0ubuntu0.18.04.1
Patroller 2.1

Event Timeline

Hi @Blinkingline, thanks for taking the time to report this and welcome to Wikimedia Phabricator!

Please provide a stacktrace:

Here you go:

[dd3bae3cd896836f9aeef60c] /index.php?title=Special:Patroller Wikimedia\Rdbms\DBUnexpectedError from line 3215 of /var/www/html/mediawiki/includes/libs/rdbms/database/Database.php: Invalid non-numeric limit passed to limitResult()

#0 /var/www/html/mediawiki/includes/libs/rdbms/database/Database.php(1859): Wikimedia\Rdbms\Database->limitResult(string, string, boolean)
#1 /var/www/html/mediawiki/includes/libs/rdbms/database/Database.php(1782): Wikimedia\Rdbms\Database->selectSQLText(array, string, string, string, array, array)
#2 /var/www/html/mediawiki/extensions/Patroller/SpecialPatroller.php(242): Wikimedia\Rdbms\Database->select(array, string, array, string, array, array)
#3 /var/www/html/mediawiki/extensions/Patroller/SpecialPatroller.php(97): SpecialPatroller->fetchChange(User)
#4 /var/www/html/mediawiki/includes/specialpage/SpecialPage.php(569): SpecialPatroller->execute(NULL)
#5 /var/www/html/mediawiki/includes/specialpage/SpecialPageFactory.php(558): SpecialPage->run(NULL)
#6 /var/www/html/mediawiki/includes/MediaWiki.php(288): MediaWiki\Special\SpecialPageFactory->executePath(Title, RequestContext)
#7 /var/www/html/mediawiki/includes/MediaWiki.php(865): MediaWiki->performRequest()
#8 /var/www/html/mediawiki/includes/MediaWiki.php(515): MediaWiki->main()
#9 /var/www/html/mediawiki/index.php(42): MediaWiki->run()
#10 {main}

Aklapper renamed this task from Fatal exception of type "Wikimedia\Rdbms\DBUnexpectedError" to Fatal exception: Invalid non-numeric limit passed to limitResult().Sep 16 2019, 12:36 PM
Cblair91 claimed this task.
Cblair91 added a subscriber: Cblair91.

This got resolved already, sorry for the delay :P

Can you clarify "resolved", as I just installed the extension this morning and am still seeing the error? Has it been pushed to the stable release yet?

Ah, I had downloaded the release version. Thanks!

I just got this message after installing Patroller for the first time a few minutes ago, two and a half years after the most recent activity on this thread. I guess it hasn't been pushed to the stable release version yet? Unless there's some problem with it, maybe it's time? Thanks.