Extension talk:FlaggedRevs/archive 4

I updated my wiki to 1.40, the latest stable release. Then I got this:

Fatal error: Uncaught ExtensionDependencyError: FlaggedRevs is not compatible with the current MediaWiki core (version 1.40.0), it requires: >= 1.41.

I posted about this issue on the support desk. Please post responses there.

Ok, fixed.

I am unable to consistently get this to work. I want to make it so that any changes need to be approved first. I've played around with Help:Pending changes, but can't seem to get it to work every time.

Sometimes it works, othertimes not. Sometimes if I leave it for 5mins, then it works, but doesn't for another page...

I'm really dumbstruck. Any advice?

Running mw1.39

Yes, FlaggedRevs can be a pain. I got it working on my wiki after about a week of trying. Do you use Google Chrome? If so, you can press Ctrl + Shift + I on Windows, or Cmd + Option + I on Mac. Then go to "Console", and see what kind of error messages your site is giving. You can also check the error logs of the server to see what goes wrong.

Thanks! This is a good hint!

I recently installed MediaWiki and FlaggedRevs on my Windows laptop with XAMPP/Apache. I encountered two major issues which strangely are not mentioned on this site. Both are related to accessing rest.php.

Issue one: FlaggedRevs on Apache did not like this url format: localhost/Article. It prevented rest.php from being accessed. I had to change it to localhost/wiki/Article.

Issue two: FlaggedRevs on Apache did not work on subpages because their titles contain forward slashes. To fix this you need to set AllowEncodedSlashes to "NoDecode". On Apache, this feature is set to "Off" by default.

I wrote about these problems at bigger length on the support desk, see here. I do believe this site should have notes about these hurdles to prevent other people from wasting time on them like I did.

Since I heard no objections, I added a little bit about the 2nd issue. As for the 1st issue, I asked the folks at Stack Overflow. Maybe they know what to do.

Oh, and btw... what's up with these <translate> tags all over this page? What is there purpose?

Thanks to Stack Overflow, I now also fixed the 1st issue. I added the solution to the support desk thread.

Hello. In Georgian Wikipedia, for reasons unknown to me, there are two identical user groups for auto checking of edit. Please see special page in English, where you can see Autochecked users და Trusted users. What should we do first?

That's something that should be reported at phabricator for investigation and fix, since that's a configuration issue.

Hi, I am upgrading from a very old version. I've been using $wgFlaggedRevsWhitelist to exclude some pages from the revisions system. After the update these pages have the revision information on them again. Looks like $wgFlaggedRevsWhitelist option has been removed. Is there any way to exclude specific pages from the revisions, or at least hide the revision bar on them?

It was indeed removed in 0fe4ed9a6842b04324d7525447f2c80855c5dd74. There is no direct replacement, although you can configure these pages on Special:Stabilization so that their latest revision appears even if it’s not yet reviewed—this still makes the UI elements (review form, revision tag etc.) appear, but the content itself is always the latest. (Or you can switch to the protection-based system, but then you need to configure all pages that you do want to be reviewable, which is probably not feasible if you had just a few exempted pages.) You could also hide the UI elements using CSS, but that’s quite hackish and will probably break somewhere or at some time.

A code change resolved the issue.

Hi team,

We are using MediaWiki 1.37.1 on PostgreSQL 10 with FlaggedRevs (tested branch REL1_37 & wmf/1.37.0-wmf.9).

Unfortunately when adding a new Wiki page we receive an error:

[22c5ffc28c0120bd38673b6d] /index.php?title=Testpagina&action=submit Wikimedia\Rdbms\DBQueryError: A database query error has occurred. Did you forget to run your application's database schema updater after upgrading or after adding a new extension?

Please see link and link for more information.

Error 22007: ERROR: invalid input syntax for type timestamp with time zone: "" LINE 1: ... WHERE fr_page_id = 268 AND (fr_rev_timestamp > ) AND (r... ^

Function: FlaggableWikiPage::updatePendingList

Query: SELECT fr_rev_id,rev_timestamp FROM "flaggedrevs","revision" WHERE fr_page_id = 268 AND (fr_rev_timestamp > ) AND (rev_id = fr_rev_id) AND (rev_page = fr_page_id) AND ((rev_deleted & 1) = 0) ORDER BY fr_rev_timestamp DESC LIMIT 1

Trying the query myself in PG, I receive the same error, however after more investigation, this is the issue:

AND (fr_rev_timestamp > '')

I have tried to run the php maintenance/update.php multiple times, but always succeeds without issues and no changes.

I also couldn't find a mention anywhere on the Extensions page that PostgreSQL isn't supported.

What can I do to resolve this?

Thank you

I don’t know whether Postgres is officially supported (the whole extension as such is rather unsupported, though), however this seems to be a bug not directly related to PostgreSQL: comparing a timestamp with the empty string simply doesn’t make any sense; I wonder why MariaDB doesn’t cry about this. It was set to the empty string by Ladsgroup in phab:rEFLR04ffb5f56f2331138f2463584aacbb702e8d243e, maybe they can tell whether that filter is still needed and if yes, how to fix it in Postgres.

Sorry for this error. Let us see how this can be fixed.

This would fix it: https://gerrit.wikimedia.org/r/c/mediawiki/extensions/FlaggedRevs/+/767919

Feel free to add it locally until we get it merged and backported (and released).

Best

Thank you for looking into this!

Removing the line from the file as seen in the commit fixes the issue :)

Hi team,

Just found another clash with PostgreSQL 10 while running php maintenance/updateStats.php on REL1_37 branch:

SELECT  AVG( 1646323491 - UNIX_TIMESTAMP(fp_pending_since) )  

FROM "flaggedpages","page"    

WHERE (fp_pending_since IS NOT NULL)

AND (fp_page_id = page_id)

AND page_namespace IN (0,6,10)  

LIMIT 1;

Fails with error: Error 42883: ERROR:  function unix_timestamp(timestamp with time zone) does not exist

Thank you for checking!

I've now added these to functions to PG 10 in order to resolve the error.

CREATE OR REPLACE FUNCTION UNIX_TIMESTAMP(TIMESTAMP

WITHOUT TIME ZONE)

RETURNS BIGINT

LANGUAGE SQL

IMMUTABLE STRICT

AS 'SELECT EXTRACT(EPOCH FROM $1)::bigint;';

CREATE OR REPLACE FUNCTION UNIX_TIMESTAMP(TIMESTAMP

WITH TIME ZONE)

RETURNS BIGINT

LANGUAGE SQL

IMMUTABLE STRICT

AS 'SELECT EXTRACT(EPOCH FROM $1)::bigint;';

However now receive a new error:

Wikimedia\Rdbms\DBQueryError from line 1809 of /mediawiki/includes/libs/rdbms/database/Database.php: Error 23502: ERROR:  null value in column "frs_stat_val" violates not-null constraint

DETAIL:  Failing row contains (2022-03-04 09:48:17+00, reviewLag-anon-sampleStartTimestamp, null).

Function: FlaggedRevsStats::updateCache

Query: INSERT INTO "flaggedrevs_statistics" (frs_stat_key,frs_stat_val,frs_timestamp) VALUES ('reviewLag-anon-sampleStartTimestamp',NULL,'2022-03-04 09:48:17+00'),('reviewLag-user-sampleStartTimestamp',NULL,'2022-03-04 09:48:17+00'),('reviewLag-anon-sampleEndTimestamp',NULL,'2022-03-04 09:48:17+00'),('reviewLag-user-sampleEndTimestamp',NULL,'2022-03-04 09:48:17+00'),('reviewLag-anon-sampleSize',0,'2022-03-04 09:48:17+00'),('reviewLag-user-sampleSize',0,'2022-03-04 09:48:17+00'),('reviewLag-anon-average',0,'2022-03-04 09:48:17+00'),('reviewLag-user-average',0,'2022-03-04 09:48:17+00'),('reviewLag-anon-median',0,'2022-03-04 09:48:17+00'),('reviewLag-user-median',0,'2022-03-04 09:48:17+00'),('pendingLag-average',0,'2022-03-04 09:48:17+00'),('totalPages-NS:0',2,'2022-03-04 09:48:17+00'),('reviewedPages-NS:0',1,'2022-03-04 09:48:17+00'),('syncedPages-NS:0',1,'2022-03-04 09:48:17+00'),('totalPages-NS:6',0,'2022-03-04 09:48:17+00'),('reviewedPages-NS:6',0,'2022-03-04 09:48:17+00'),('syncedPages-NS:6',0,'2022-03-04 09:48:17+00'),('totalPages-NS:10',0,'2022-03-04 09:48:17+00'),('reviewedPages-NS:10',0,'2022-03-04 09:48:17+00'),('syncedPages-NS:10',0,'2022-03-04 09:48:17+00') ON CONFLICT DO NOTHING

After updating the mediawiki version from 1.15 to 1.35 I have a problem. All pages are marked as requiring approval. Changes are shown in the page history, but the page is not validated. Any idea what to do?

i answered questions

Hi there! how can I change the buttons and inputs styles on the local wiki?

Yes, using CSS

Hi @Krzysiek 123456789 I know, but where is the MediaWiki official CSS files? can you show me?

You can simply override them with CSS for a single user or a global CSS file for a wiki(MediaWiki:Common.css). For security reasons it is not possible to modify the default styles directly. HERE you can learn more.

Is there a script that allows mass flagging?

There is https://github.com/wikimedia/mediawiki-extensions-FlaggedRevs/blob/REL1_35/maintenance/reviewAllPages.php

But it does not allow to specify a list of pages, but instead will really flag all pages in the activated namespaces.

There is also https://github.com/wikimedia/mediawiki-extensions-BlueSpiceFlaggedRevsConnector/blob/REL1_35/maintenance/BSBatchReview.php

AFAIK you don't even need to install BlueSpiceFlaggedRevsConnector. Just downloading and executing the script should be okay,

Ok, thanks.