Extension talk:Patroller/Archive

Bug?
It doesn't seem to find newly created pages, even though they show up as being unpatrolled in Recent Changes.

-Dean Garton

Question about view from groups
This extention looks and works great. Is there anyway that I can set it so that changes that have not been accepted cannot be viewed by a group? Something like: $wgGroupPermissions['*']['view_un-patrolled'] = false; $wgGroupPermissions['CompanyPerson']['view_un-patrolled'] = true; (obviously making up the "view_un-patrolled", but you get the idea.) If this doesn't exist, is there plans to add something like that? Thanks again for the great extension. LinuxSneaker 16:06, 27 October 2006 (UTC)


 * That's not what this extension is for. Wait until MediaWiki supports stable version tagging and reviewing proper. robchurch | talk 14:41, 20 November 2006 (UTC)

Design flaw
This is a great extension, but it has one major design flaw. If someone comes along and edits a page inappropriately, then immediately edits a different part of that same page, patrollers using this extension won't notice, since it only shows the most recent. It really ought to do a multi-revision diff, from the last unpatrolled edit to the most recent, and then mark all those intermediate revisions as patrolled. --71.224.196.239 21:02, 26 April 2007 (UTC)

I agreed...

- Shumz / 27 June 2013

Does this extension work if you're using Postgres for your database?
I personally use MySQL, but it appears after looking at the installation script that it is geared toward MySQL only. Is there a Postgres installation script, or does this work with Postgres as well? --Hoggwild5 15:52, 2 July 2008 (UTC)

Show title of the changed article
Great extension, but what I really miss, is a title or a link to the page that was changed. Is it possible to add these to the difference-view?

Special:Patrol has Database error ??? How Can I fix this?
A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was:

(SQL query hidden)

from within function "Patroller::fetchChange". Database returned error "1146: Table 'xxxxxxxxxxxxx.mw_patrollers' doesn't exist (xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx)".
 * How did you install it?. In it, did you run the SQL command? Bud0011 22:10, 19 September 2011 (UTC).

Fix for MySQL error upon installing
Tested on: MediaWiki version 1.17.1 MySQL version 5.5.9

MySQL will throw an error if you use the install.php script without modifying the patroller.sql file. Simply change: TYPE=MEMORY to ENGINE=MEMORY

--Lisa Ridley (talk) 22:03, 22 December 2011 (UTC)

Why do we need the patrollers table?
What is the patrollers table good for?

Edits are simply marked patrolled in the recentchanges table so why store diffs in the patrollers table? And why even temporary only?

For skipping? if so, couldn't there be a better solution? Shouldn't it store the user name so there could be a button "Flush all my skipped diffs"?

--Subfader (talk) 22:52, 18 August 2013 (UTC)

Nobody wants to keep this alive?
I requested to add this to MW core: https://bugzilla.wikimedia.org/show_bug.cgi?id=71607

Update
Can you update Patroller.allas.php because I added the name of the Serbian language among other languages. Here is the file. Zoranzoki21 (talk) 22:22, 29 January 2017 (UTC)

Slightly off error message
If a non-patroller tries to access Special:Patrol, they get the following error (emphasis mine): "You do not have permission to , for the following reason: ..."

We're on an older version of Patroller and of MediaWiki, so I can't diagnose if this is still an issue, but the relevant code looks to be highly similar in modern versions, so I suspect it still is. – Robin Hood  (talk)  01:03, 9 June 2017 (UTC)

Bug? Patroller Error
Extension:Patroller gives error, on browsing to Special:Patroller.

Reported here https://www.mediawiki.org/wiki/Topic:Uaf3x10pznudky6h

[WsAfET-@jcqxiKxPT0bRjQAAAUk] /index.php/Special:Patroller Wikimedia\Rdbms\DBUnexpectedError from line 2479 of /home/my_username/public_html/includes/libs/rdbms/database/Database.php: Invalid non-numeric limit passed to limitResult Backtrace:


 * 1) 0 /home/my_username/public_html/includes/libs/rdbms/database/Database.php(1395): Wikimedia\Rdbms\Database->limitResult(string, string, boolean)
 * 2) 1 /home/my_username/public_html/includes/libs/rdbms/database/Database.php(1341): Wikimedia\Rdbms\Database->selectSQLText(array, string, string, string, array, array)
 * 3) 2 /home/my_username/public_html/extensions/Patroller/SpecialPatroller.php(246): Wikimedia\Rdbms\Database->select(array, string, array, string, array, array)
 * 4) 3 /home/my_username/public_html/extensions/Patroller/SpecialPatroller.php(97): SpecialPatroller->fetchChange(User)
 * 5) 4 /home/my_username/public_html/includes/specialpage/SpecialPage.php(522): SpecialPatroller->execute(NULL)
 * 6) 5 /home/my_username/public_html/includes/specialpage/SpecialPageFactory.php(578): SpecialPage->run(NULL)
 * 7) 6 /home/my_username/public_html/includes/MediaWiki.php(287): SpecialPageFactory::executePath(Title, RequestContext)
 * 8) 7 /home/my_username/public_html/includes/MediaWiki.php(851): MediaWiki->performRequest
 * 9) 8 /home/my_username/public_html/includes/MediaWiki.php(523): MediaWiki->main
 * 10) 9 /home/my_username/public_html/index.php(43): MediaWiki->run
 * 11) 10 {main}

PS, i noticed my username appears in this error message, visible in this error message (obscured above). Might that be a security vulnerability?

-thx

Unknown column 'ptr_timestamp' in 'where clause'
Hi,

I'm really excited to use this extension but I'm getting an error:

[09e1b58d2c100debf29616db] /index.php/Special:Patroller Wikimedia\Rdbms\DBQueryError from line 1603 of /var/www/mediawiki2/mediawiki-1.34.1/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 * FROM `page`,`recentchanges` WHERE (ptr_timestamp IS NULL) AND (rc_namespace = page_namespace) AND (rc_title = page_title) AND (rc_this_oldid = page_latest) AND (rc_user != 9) AND rc_bot = '0' AND rc_patrolled = '0' AND rc_type = '0' LIMIT 1 Function: SpecialPatroller::fetchChange Error: 1054 Unknown column 'ptr_timestamp' in 'where clause' (localhost)

I ran the update.php already. Someone on another thread said to run SQL commands, but I'm not sure specifically what script I'm missing. Did I miss a step?