Extension talk:FlaggedRevs

Jump to: navigation, search

About this board


By clicking "Add topic", you agree to our Terms of Use and agree to irrevocably release your text under the CC BY-SA 3.0 License and GFDL (talkcontribs)

Hello. I've some troubles installing FlaggedRevs extension. I've followed the process (except the cron part §6.2) and when returning on the wiki I've the following message :

"A database query error has occurred. This may indicate a bug in the software."

I've checked the data base : there is a table called "approved_revs" with 5 lines.

I'm on a shared hosting (PHP 5.6.24).

Does anybody knows what I may try to do ? (talkcontribs)

I've ran the maintenance/populateImageSha1.php script using the Maintenance extension with a new line in the metadata.ini. The message told me it ran succesfully. (talkcontribs)

"I've checked the data base : there is a table called "approved_revs" with 5 lines." sorry this has no link with the subjet

Ciencia Al Poder (talkcontribs)

Set Manual:$wgShowExceptionDetails to true to see details about the error. I don't know what's the relation about the error and having to run the populateImageSha1.php script (talkcontribs)

I've set $wgShowExceptionDetails to true, but unfortunately, I've then a blank page. Even the message "A database query error has occurred. This may indicate a bug in the software." disappear.

Ciencia Al Poder (talkcontribs)

You must have been messed something up in LocalSettings.php when adding $wgShowExceptionDetails, like introducing a syntax error. Common causes are a missing semicolon, a typo or introduction of garbage characters. (talkcontribs)

OK, you were wright, thanks. Anyway, I don't have any new message in addition of "A database query error has occurred. This may indicate a bug in the software."

Is it possible the update.php didn't run well : are there some new tables that should have been add in the wiki database ?

Here is the log for the update :

"Turning off Content Handler DB fields for this part of upgrade.

...have ipb_id field in ipblocks table.

...have ipb_expiry field in ipblocks table.

...already have interwiki table

...indexes seem up to 20031107 standards.

...have rc_type field in recentchanges table.

...index new_name_timestamp already set on recentchanges table.

...have user_real_name field in user table.

...querycache table already exists.

...objectcache table already exists.

...categorylinks table already exists.

...have pagelinks; skipping old links table updates

...il_from OK

...have rc_ip field in recentchanges table.

...index PRIMARY already set on image table.

...have rc_id field in recentchanges table.

...have rc_patrolled field in recentchanges table.

...logging table already exists.

...have user_token field in user table.

...have wl_notificationtimestamp field in watchlist table.

...watchlist talk page rows already present.

...user table does not contain user_emailauthenticationtimestamp field.

...page table already exists.

...have log_params field in logging table.

...logging table has correct log_title encoding.

...have ar_rev_id field in archive table.

...have page_len field in page table.

...revision table does not contain inverse_timestamp field.

...have rev_text_id field in revision table.

...have rev_deleted field in revision table.

...have img_width field in image table.

...have img_metadata field in image table.

...have user_email_token field in user table.

...have ar_text_id field in archive table.

...page_namespace is already a full int (int(11)).

...ar_namespace is already a full int (int(11)).

...rc_namespace is already a full int (int(11)).

...wl_namespace is already a full int (int(11)).

...qc_namespace is already a full int (int(11)).

...log_namespace is already a full int (int(11)).

...have img_media_type field in image table.

...already have pagelinks table.

...image table does not contain img_type field.

...already have unique user_name index.

...user_groups table exists and is in current format.

...have ss_total_pages field in site_stats table.

...user_newtalk table already exists.

...transcache table already exists.

...have iw_trans field in interwiki table.

...wl_notificationtimestamp is already nullable.

...index times already set on logging table.

...have ipb_range_start field in ipblocks table.

...no page_random rows needed to be set

...have user_registration field in user table.

...templatelinks table already exists

...externallinks table already exists.

...job table already exists.

...have ss_images field in site_stats table.

...langlinks table already exists.

...querycache_info table already exists.

...filearchive table already exists.

...have ipb_anon_only field in ipblocks table.

...index rc_ns_usertext already set on recentchanges table.

...index rc_user_text already set on recentchanges table.

...have user_newpass_time field in user table.

...redirect table already exists.

...querycachetwo table already exists.

...have ipb_enable_autoblock field in ipblocks table.

...index pl_namespace on table pagelinks includes field pl_from.

...index tl_namespace on table templatelinks includes field tl_from.

...index il_to on table imagelinks includes field il_from.

...have rc_old_len field in recentchanges table.

...have user_editcount field in user table.

...page_restrictions table already exists.

...have log_id field in logging table.

...have rev_parent_id field in revision table.

...have pr_id field in page_restrictions table.

...have rev_len field in revision table.

...have rc_deleted field in recentchanges table.

...have log_deleted field in logging table.

...have ar_deleted field in archive table.

...have ipb_deleted field in ipblocks table.

...have fa_deleted field in filearchive table.

...have ar_len field in archive table.

...have ipb_block_email field in ipblocks table.

...index cl_sortkey on table categorylinks includes field cl_from.

...have oi_metadata field in oldimage table.

...index usertext_timestamp already set on archive table.

...index img_usertext_timestamp already set on image table.

...index oi_usertext_timestamp already set on oldimage table.

...have ar_page_id field in archive table.

...have img_sha1 field in image table.

...protected_titles table already exists.

...have ipb_by_text field in ipblocks table.

...page_props table already exists.

...updatelog table already exists.

...category table already exists.

...category table already populated.

...have ar_parent_id field in archive table.

...have user_last_timestamp field in user_newtalk table.

...protected_titles table has correct pt_title encoding.

...have ss_active_users field in site_stats table.

...ss_active_users user count set...

...have ipb_allow_usertalk field in ipblocks table.

...pl_namespace, tl_namespace, il_to indices are already UNIQUE.

...change_tag table already exists.

...tag_summary table already exists.

...valid_tag table already exists.

...user_properties table already exists.

...log_search table already exists.

...have log_user_text field in logging table.

...l10n_cache table already exists.

...index ls_field_val already set on log_search table.

...index change_tag_rc_tag already set on change_tag table.

...have rd_interwiki field in redirect table.

...transcache tc_time already converted.

...*_mime_minor fields are already long enough.

...iwlinks table already exists.

...index iwl_prefix_title_from already set on iwlinks table.

...have ul_value field in updatelog table.

...have iw_api field in interwiki table.

...iwl_prefix key doesn't exist.

...have cl_collation field in categorylinks table.

...categorylinks up-to-date.

...module_deps table already exists.

...ar_page_revid key doesn't exist.

...index ar_revid already set on archive table.

...ll_lang is up-to-date.

...user_last_timestamp is already nullable.

...index user_email already set on user table.

...up_property in table user_properties already modified by patch patch-up_property.sql.

...uploadstash table already exists.

...user_former_groups table already exists.

...index type_action already set on logging table.

...have rev_sha1 field in revision table.

...batch conversion of user_options: nothing to migrate. done.

...user table does not contain user_options field.

...have ar_sha1 field in archive table.

...index page_redirect_namespace_len already set on page table.

...have us_chunk_inx field in uploadstash table.

...have job_timestamp field in job table.

...index page_user_timestamp already set on revision table.

...have ipb_parent_block_id field in ipblocks table.

...index ipb_parent_block_id already set on ipblocks table.

...category table does not contain cat_hidden field.

...have rev_content_format field in revision table.

...have rev_content_model field in revision table.

...have ar_content_format field in archive table.

...have ar_content_model field in archive table.

...have page_content_model field in page table.

Content Handler DB fields should be usable now.

...site_stats table does not contain ss_admins field.

...recentchanges table does not contain rc_moved_to_title field.

...sites table already exists.

...have fa_sha1 field in filearchive table.

...have job_token field in job table.

...have job_attempts field in job table.

...have us_props field in uploadstash table.

...ug_group in table user_groups already modified by patch patch-ug_group-length-increase-255.sql.

...ufg_group in table user_former_groups already modified by patch patch-ufg_group-length-increase-255.sql.

...index pp_propname_page already set on page_props table.

...index img_media_mime already set on image table.

...iwl_prefix_title_from index is already non-UNIQUE.

...index iwl_prefix_from_title already set on iwlinks table.

...have ar_id field in archive table.

...have el_id field in externallinks table.

...have rc_source field in recentchanges table.

...index log_user_text_type_time already set on logging table.

...index log_user_text_time already set on logging table.

...have page_links_updated field in page table.

...have user_password_expires field in user table.

...have pp_sortkey field in page_props table.

...recentchanges table does not contain rc_cur_time field.

...index wl_user_notificationtimestamp already set on watchlist table.

...have page_lang field in page table.

...have pl_from_namespace field in pagelinks table.

...have tl_from_namespace field in templatelinks table.

...have il_from_namespace field in imagelinks table.

...img_major_mime in table image already modified by patch patch-img_major_mime-chemical.sql.

...oi_major_mime in table oldimage already modified by patch patch-oi_major_mime-chemical.sql.

...fa_major_mime in table filearchive already modified by patch patch-fa_major_mime-chemical.sql.

...user_id is already unsigned int.

...rc_comment in table recentchanges already modified by patch patch-editsummary-length.sql.

...hitcounter doesn't exist.

...site_stats table does not contain ss_total_views field.

...page table does not contain page_counter field.

...msg_resource_links doesn't exist.

...msg_resource doesn't exist.

...bot_passwords table already exists.

...have wl_id field in watchlist table.

...cl_collation key doesn't exist.

...index cl_collation_ext already set on categorylinks table.

...collations up-to-date.

...site_stats is populated...done.

Purging caches...done."

Ciencia Al Poder (talkcontribs)

Ok, maybe the right setting here is $wgShowSQLErrors = true; (talkcontribs)

OK it works. The error is :

  • Query: SELECT page_id,page_namespace,page_title,page_restrictions,page_is_redirect,page_is_new,page_random,page_touched,page_links_updated,page_latest,page_len,page_content_model,fpc_override,fpc_level,fpc_expiry,fp_pending_since,fp_stable,fp_reviewed FROM `HELIOCENTRIXpage` LEFT JOIN `HELIOCENTRIXflaggedpages` ON ((fp_page_id = page_id)) LEFT JOIN `HELIOCENTRIXflaggedpage_config` ON ((fpc_page_id = page_id)) WHERE page_namespace = '0' AND page_title = 'Accueil' LIMIT 1
  • Function: FlaggableWikiPage::pageData
  • Error: 1146 Table 'gditrisk_heliocentrix.HELIOCENTRIXflaggedpages' doesn't exist (localhost)

So the flaggedpages table doesn't exist. I don't understand why : I've followed all the steps of the installation. May the problem come from the fact that I'm on a shared host ?

Ciencia Al Poder (talkcontribs)

From the output of the update.php process, apparently it hasn't populated any of the tables/fields of this extension. I'm not sure why.

FlaggedRevsUpdater.hooks.php contains the instructions to update the database, which in turn runs some of the scripts in the folders. You could run them manually but that's far from ideal, and you'll need to manually add the table prefix you're using.

Reply to "Problem with installation MW1.27"

Question to set Site to Sighted

Summary by Tacsipacsi

It's working now.

MeikelHH (talkcontribs)

I can´t set a page to "Sighted". I have not the box with buttons at the bottom of an article.

I want this box with the "Sighted"-Button. https://upload.wikimedia.org/wikipedia/commons/2/2e/Flaggedrevs_review_bar.png

But i have a box where is "Prose" (with Average, Good and Excellent) and not "Accuracy".

I hope you understand me.

Tacsipacsi (talkcontribs)

Which wiki? Which page? What's in your LocalSettings.php (if not a Wikimedia wiki)?

2003:86:AD52:8300:EC9A:B93F:B98E:4E78 (talkcontribs)

It is a Mediawiki, Version 1.26.2. it is on a Server in my Office. We will try to run a wiki for our Company. I have on every site in my Wiki a Button in the right upper corner an Image ( not sighted).

In the LocalSettings.php i have added this Lines: $wgFlaggedRevsStatsAge = false;

$wgGroupPermissions['sysop']['review'] = true; //allow administrators to review revisions

Tacsipacsi (talkcontribs)

Are there any custom MediaWiki messages (Special:PrefixIndex/MediaWiki:revreview-)?

2003:86:AD52:8300:EC9A:B93F:B98E:4E78 (talkcontribs)

Nope, its empty

Tacsipacsi (talkcontribs)

Then I have no idea, hopefully a developer will figure it out.

MeikelHH (talkcontribs)

It´s working now!

I used a backup and installed the extension again. Now it is working.

Thanks (talkcontribs)

In my wiki when user without high permissions create a new page this page is unreviewed so next edits aren't reviewed. Is it possible to set up that every new page create by user automatically has stable version?

Tacsipacsi (talkcontribs)

Why would it be good? The goal of FlaggedRevs is to have all edits manually flagged—it includes page creations. (Of course it doesn’t refer to “high permissions”, i.e. at least autoconfirmed users, whose edits to flagged pages are always flagged—again regardless of whether it’s a page creation or a normal edit.) (talkcontribs)

You are right but when user without autoconfirmed perimissions created a new page and wrote content, reviewer can't reject this revision only accept. So it is possible to set up that first automatically stable version of new page is blank page and all content which user wrote will be pending changes?

Tacsipacsi (talkcontribs)

We use this extension on the Hungarian Wikipedia, and the general rule is that a reviewer should flag the revision (while reverting or tagging it if not correct). The technical equivalent of reverting at new pages is speedy deletion (for non-sysops it’s of course marking for speedy, while flagging it). Why would be the stable version a never-existed one?

P.gibellini (talkcontribs)

Is there a way to hide the new pages until they aren't revised?

Tacsipacsi (talkcontribs)

Currently there isn't. How do you think it (i.e. what would anonymous users see instead of the article; what would be the color of links pointing to such articles, red or blue)? Or what do you mean under "hiding" of these articles?

P.gibellini (talkcontribs)

This is a good question. A new page created by a normal user at the moment is immediately visible to all the users (with the flag of "to be revised", of course).

Perhaps it could be added a parameter in LocalSettings.php in order to choose wether show the page as in current version of FlaggedRevs or to show instead a simple placeholder (something like "This is a new page and needs to be revised"). I'd not bother to change the colors of the links.

Tacsipacsi (talkcontribs)

Thank you for clearing your conception. (I don't know if anyone's going to implement it.)

Reply to "Creating new page"
Malarz pl (talkcontribs)

How can i check via API who reviewed specific revision? I'd like to have revision history with information which revision was flagged and who did it.

Tacsipacsi (talkcontribs)

It can be queried with the page history (example query). It seems to be available only with prop=revisions (not with list=allrevisions).

Malarz pl (talkcontribs)

Thanks for help. I added rvprop-flagged to API:Revisions.

Reply to "API"
Bennkenn (talkcontribs)

I installed the latest version of FlaggedRevs on my wiki which is 1.25.1. When I go and accept a revision on an editable page it says No Such Special Page. I'm not sure what I did wrong or what I need to change.

Nemo bis (talkcontribs)

Do you see the special page in "Special:SpecialPages" on your wiki?

Пика Пика (talkcontribs)

Have the same problem with MediaWiki 1.25.3 and FlaggedRevs REL1_25 2015-06-16T21:07:19. I can't see anything suspicious in the logs, and reviewing works, but the special pages related to FlaggedRevs have disappeared.

Ibutakov.smartec (talkcontribs)

I have found the cause of that problem: some extensions cannot create special pages if inside LocalSettings.php $wgGroupPermissions['*']['read'] = false; is set. so not working on private wiki.

btw i have same problem on 1.26.2 (latest stable)

Reply to "No Such Special Page"
Ата (talkcontribs)

User rights are extremely confusing.

  • autoreview receives autoreview right,
  • editor receives review as his main right (why is he not reviewer then?),
  • reviewer receives validate as his main right (why is he not validator then?).

Years extension enabled in uk.wiki I am still confused.

Reply to "User rights"
ParaSigma (talkcontribs)

What's this table role and how to prevent it's overgrowing?

Reply to "Size of 'flaggedrevs_statistics'"

Show non-checked page version until review = quality or higher

4 (talkcontribs)

This extension could be very useful to my agency, if I can get the configuration set to meet our requirements. I followed the instructions for restricting unapproved revisions, which almost works for my purposes. I have multiple tags, and my wgFlaggedRevsTags array is set such that each tag requires a level 2 in order to be considered "quality". The behavior I'd like to see is that each tag is controlled by a different reviewer, and only when all reviewers have set level 2, and we have "quality" achieved, is the revised page shown to anonymous users. Instead, what I see is that when any of the tags reaches level 2, putting the page into a "checked" state, the page is then displayed to anonymous users prior to the "quality" state being reached. How might I go about fixing this? (talkcontribs)

It looks as though there is not an available configuration option that I can set to modify the default behavior from accepting draft revisions (i.e. less than quality) as reviewed/stable. I can work around the need for having each reviewer control different levels on different tags, but I really need the viewable versions for anonymous users to only show once quality or pristine levels are reached. Having pages viewable after they have just been checked, but not yet reached quality will not work for my purposes. Can anyone help suggest what modifications I might try to this extension in order to get what I'm after? Many thanks.

Aaron Schulz (talkcontribs)

Maybe look at https://www.mediawiki.org/wiki/Extension:FlaggedRevs/Restricting_unapproved_revisions .

Bruno Spy (talkcontribs)

In fact the issue is not "how to not show unstable versions" but how to have stable versions only if a tag has reach a certain level.

For exemple, with only one tag with 3 levels Draft-Verified-Approved : how to tell the extension to consider that "Verified" is not a stable state and thus not shown by default (with $wgFlaggedRevsOverride = true)

Reply to "Show non-checked page version until review = quality or higher"
Bob.spencer (talkcontribs)

I use AutoWikiBrowser to review and script alot of autoedits within my wiki. I would like to be able to review pages with FlaggedRevs at the same time. Is there any collaboration between the two, or has anyone developed any plugins or modules that would allow the cross functionality?

This post was posted by Bob.spencer, but signed as Sdsolutions.

Reply to "FlaggedRevs with AutoWikiBrowser"

Everyone sees Edit Review widget after installation

Edga~mediawikiwiki (talkcontribs)


I successfully installed FlaggedRevs extension for my internal wiki. However even if I log-in as user I can see Edit Review widget even though in installation notes it says nobody would see it until relevant permissions are granted. the only line for this extension in localsettings I have is require_once..

Any idea?

This post was posted by Edga~mediawikiwiki, but signed as Edga.

Jackmcbarn (talkcontribs)

The reviewer's widget isn't the little box in the top right corner. Everyone is supposed to be able to see that. The reviewer's widget is the big box all along the top of the page with buttons to accept or reject the revision.

Reply to "Everyone sees Edit Review widget after installation"