Extension talk:AbuseFilter

Jump to navigation Jump to search

About this board

19 previous topics. Previous discussion was archived at Extension talk:AbuseFilter/Archive 1 on 2016-10-24.

JakePotrebic (talkcontribs)

Maybe I'm missing something but is there no event that is triggered when a filter is triggered? I see the AbuseFilterShouldFilterAction but that is supposed to return a value telling the extension whether to filter the action or not.

Daimona Eaytoy (talkcontribs)

Do you mean a hook that is called by AbuseFilter whenever a filter is triggered? If so, no, there's nothing like that at the moment. Here is the full list of hooks currently available. May I ask you what your use case would be?

JakePotrebic (talkcontribs)

Yeah thats exactly what I was hoping this extension had.


I am working on an extension to forward info from certain hooks (page edits, creations, deletes, etc. ) to a configurable URL for custom webhooks for various applications (discord, slack, etc.). Since Gamepedia uses this extension, I was hoping to include this.

Daimona Eaytoy (talkcontribs)

Yeah, I confirm that such a feature doesn't exist. However, we do send this information to other consumers: the $wgAbuseFilterNotifications global variable can be used to tell AF where this info should be sent; the options are RC, UDP, or both. Maybe it would be possible to use it for your use case?

Reply to "Event when an filter is triggered"
STITCH+COFFEE (talkcontribs)

Hi, I'm not sure if this is the place to ask this question but I am having a increasing attack of spambots on my wiki site. They don't harm any important pages but I get a massive user account creation of about 250 a day and they all edit on their own user page with spam like articles or comments (this is not allowed on my wiki site). Is there something broken on my site? Or is there a better way to prevent spambots to create user accounts. Any help or links would be appreciated.

Ciencia Al Poder (talkcontribs)
Reply to "Tackling spambots"

User is triggering abuse filter but their edit doesn't contain the words?

13
STITCH+COFFEE (talkcontribs)

Hi MediaWiki community,


I have a user in one of my sites who can't edit because they keep triggering one of my abuse filters that prohibit them from writing specific words.

The problem is, there are no words in the edit they provided me with that could trigger the abuse filter.

It seems like he is the only one experiencing it, as I am able to edit with his intended edits.

Any idea what is happening?

DannyS712 (talkcontribs)

Hi. Is the wiki public / can you post a link to the abuse logs? Or, can you post the contents of the `details` view?

Daimona Eaytoy (talkcontribs)

Indeed, we'd need some more info to understand what's going on. Ideally, links to (or copypaste if the wiki/the filter is private) the faulty filter and the AbuseLog entry for the edit. And also your MediaWiki version, and the version of the AbuseFilter extension (the git hash you can find in Special:Version). Thanks!

STITCH+COFFEE (talkcontribs)

Hi my abuse filter simply blocks users from adding the obscene word and there is no fault in it. One example is the word "travellers" the user wanted to add that word and wasn't allowed to. But he added another edit that was completely different and that was blocked too. I am wondering if something on the user end could trigger a false response?

DannyS712 (talkcontribs)

Can you please post the details and stuff? Without that its hard to help

STITCH+COFFEE (talkcontribs)

spamfilter:= "(helpdesk|applesupport|applenumber|\bkeygen\b|starcraft|microsoftsupport|cryptocurrency|flappybird|netflix|quickbooks‎|voyance|sheneverreallyliked|heneverreallyliked|moneyhack|\bseo\b|everybodycallsme|meuweblog|digsthatnickname|digsthatname|searchenginemarketing|meushobbies|introducingtheauthor|introducetheauthor|testosterone|sitedaweb|writtenonherbirthcertificate|notherbirthcall|hackgame|gamehack|surfemeulocal|howtomakemoney|meuhobby|myparentsgaveme|visitmyblog|thewriteriscalled|garciniacambogia|thewritersnameis|iadoreit|meulocal|earnmoremoney|introducemyselftoyou|astrologique|blockchain|emailmarketing|spouseenjoys|lovestophoneme|masculinename|happywheelsdemo|pussy|songdownload|roofrepair|onlinecasino|unifytotheentireglobe|mywebblog|viagra|investmentbanking|linkbuilding|seostrategies|meublog|meuhomepage|backlinks|theauthorsnameis|unitetothewholeglobe|avastinternet|ididmyschooling|surftomyweblog|meupágina|visitmysite|visitmywebsite|\bcialis\b|myweblog|ventolin|designershoes|apexatropin|zyntix|gotomysite|notherbirthtitle|cardsharing|nothisbirthtitle|landscaping|directTelescope|metalfabricator|prednisone|curlingwandreviews|adorethisname|introducingmyself|makemoneyonline|triptofano|surftomyblog|vaping|mercedesengines|mercedesengine|rangefinder|letmeintroducemyself|maleenhancement|designerwomenshoes|meuwebpage|moneylenders|totallydigthattitle|horoscopo|howshescalled|creditscore|ameritrade|debtcollectors|businessloans|thingsshelovesmost|uggboots|nikeshox|zoomair|basketballshoe|husbanddoesntlikeitatall|thewriterisknown|multilevelmarketing|hintingtheauthorsname|weightlossgoals|authorisknownbythename|namepeopleusetocallme|feminineofnames|paydayloans|masuclinetitle|titleshelovestobecalled|jointotheentireworld|sexyvideo|breastimplants|unifytotheentireworld|zithromax|captchasolvingservices|letusmowthelawn|lookintomysite|

hereismyhomepage|reviewmypage|myblogpost|examinemywebsite|ourownwebsite|bypassrecaptcha|hereismypagе|checkmysite|checkthisweblog|redessociais|tarotcard|hereismywebsite|spendstimewithhobbies|hobbiesthatinclude|myhobbiesare|fuerdai|windowsupdatesserver|insurancecoverage|minecraft|bestbabyseat|babycarseat|meuincrívelwebblog|dailyhoroscope|littleaboutmyself|mbactrosegroff|onlinepoker|Electronicdogfence|cliqueaqui|antioxidantes|sayingmytitle|checkouthiswebsite|checkoutherwebsite|\bmyhomepage\b|youcanfindmywebsite|introducethewriter|vedicastrology|moreonoursite|mbactrosdpfoff|concealedpetfence|dopamin|phenibut|wweporn|sexvideo|justclickthenextsite|poop|pee|poopee|poo|mealreplacements|estewebblog|completelylovethisname|homebasedbusiness|andhelovesit|kindlystopbyourpage|aoweblog|meunetwork|whatindividualscallher|visitourwebsite|decidingonamountainbike|Hereismyblog|petpharmacy|hereismywebpage|visitmyweblog|hasseveralhobbiesandinterests|ThunderingTyphoons|Vagina|vagina|Vaginan|\b卐\b)";

rmspecials(ccnorm(ADDED_LINES))  irlike spamfilter  & !('sysop' in user_groups) & !('bureaucrat' in user_groups) & !('autoconfirmed' in user_groups)

STITCH+COFFEE (talkcontribs)

I'm wondering if its because I didn't add \b to the words so it blocks any word with that sequence in it?

Daimona Eaytoy (talkcontribs)

It could be. Handling boundaries is up to the person writing the filter. It's also possible that the ccnorm could have caused a false positive. However, I'd need the AbuseLog entry for the edit in order to understand what's going on. If the wiki is private, it's also fine to just post the content of added_lines.

STITCH+COFFEE (talkcontribs)

This is one of the edits: the only difference is deleting a space.

*''' Great Burn Brewing''', [https://www.greatburnbrewing.com/] Woods-themed taproom with great selection in the south end of town. Often has a food truck. *''' Great Burn Brewing''', [https://www.greatburnbrewing.com/] Woods-themed taproom with great selection in the south end of town. Often has a food truck.
*''' Western Cider''', [https://westerncider.com/] Fantastic cider selection brewed using fruit from local orchards. They also offer tours. + *'''Draught Works Brewery''' [http://www.draughtworksbrewery.com/] Big selection of original beers. Has live music Thursdays, Saturdays and Sundays.  
*''' Conflux Brewing''', [http://confluxbrewing.com/] Great brewery downtown with a full restaurant. + *''' Western Cider''' [https://westerncider.com/] Fantastic cider selection brewed using fruit from local orchards. They also offer tours.
+
+ *''' Conflux Brewing''' [http://confluxbrewing.com/] Great brewery downtown with a full restaurant.
=== Wine === === Wine ===
Missoula wineries include: Missoula wineries include:
*''' Lolo Peak Winery''', [http://www.lolopeak.com] for fruit wines. + *''' Lolo Peak Winery''' [http://www.lolopeak.com] for fruit wines.
*''' Ten Spoons Vineyard''', [http://tenspoonvineyard.com/] is another local favorite. + *''' Ten Spoons Vineyard''' [http://tenspoonvineyard.com/] is another local favorite.
*''' Lake Missoula Cellars''', [http://www.lakemissoulacellars.com]. Another Great Montana Winery.  Tasting Room and Event Center. Complementary tastings. Friday night music and special events. New Bocce Court. Open Noon to 7:30 pm Tuesdays through Saturdays. + *''' Lake Missoula Cellars''' [http://www.lakemissoulacellars.com]. Another Great Montana Winery.  Tasting Room and Event Center. Complementary tastings. Friday night music and special events. New Bocce Court. Open Noon to 7:30 pm Tuesdays through Saturdays.
===Whiskey and Spirits=== ===Whiskey and Spirits===
STITCH+COFFEE (talkcontribs)

Here is another one

Long distance buses from Hong Kong such as to Guangzhou use Shenzhen Bay Checkpoint. Long distance buses from Hong Kong such as to Guangzhou use Shenzhen Bay Checkpoint.
+
+ ===China High Speed Rail from Hong Kong===
+
+ Trains run Northbound from West Kowloon station in Hong Kong to 3 stations in Shenzhen starting from 7 am with the last departure gone by 11 pm. As at September 2019, journey times and one way adult ticket costs from West Kowloon station are:
+
+ * Futian:        14 mins, HKD76, 36 trains per weekday plus additional trains at weekends
+ * Shenzhen North: 18 mins, HKD84, 66 trains per day
+ * Guangmingcheng: 31 mins, HKD106, 3 trains per day
+
+ See the MTR high speed rail website for more and latest info.
===By train=== ===By train===
'''Shenzhen Tong''' '''Shenzhen Tong'''
The most convenient way to travel is to buy a Shenzhen Tong (深圳通) card. This is a stored value ticket. Touch it on the turnstile reader on entering and leaving the station. It can also be used for purchases in convenience stores. The card can be bought from a separate stand at metro stations, as well as special machines. At Luohu station, the stand is located at Exit A. The stand displays the Shenzhen Tong cards and they cost 50 yuan. The most convenient way to travel is to buy a Shenzhen Tong (深圳通) card. This is a stored value ticket. Touch it on the turnstile reader on entering and leaving the station. It can also be used for purchases in convenience stores. The card can be bought from a separate stand at metro stations, as well as special machines. At Luohu station, the stand is located at Exit A. The stand displays the Shenzhen Tong cards and they cost 50 yuan.
===China High Speed Rail from Hong Kong===
Trains run Northbound from West Kowloon station in Hong Kong to 3 stations in Shenzhen starting from 7 am with the last departure gone by 11 pm. As at September 2019, journey times and one way adult ticket costs from West Kowloon station are:
* Futian:        14 mins, HKD76, 36 trains per weekday plus additional trains at weekends
* Shenzhen North: 18 mins, HKD84, 66 trains per day
* Guangmingcheng: 31 mins, HKD106, 3 trains per day
See the MTR high speed rail website for more and latest info.
===By bus=== ===By bus===
Daimona Eaytoy (talkcontribs)

OK, now it's clear. There are two problems with your filter:

  • There are no boundaries in some words. For instance, "poo" is causing a false positive in the first edit you reported.
  • added_lines contains all the changed lines, i.e. the ones appearing in the right side of the diff. Hence, it includes moved lines; it also includes whole paragraphs, even if only a single character was changed inside that paragraph. So you should check that, for instance with rmspecials(ccnorm(added_lines)) irlike spamfilter & !(rmspecials(ccnorm(removed_lines)) irlike spamfilter)
STITCH+COFFEE (talkcontribs)

Thank you so much! How do I change the added_lines part?

STITCH+COFFEE (talkcontribs)

Oh actually I think you already gave me it. Thank you!

Reply to "User is triggering abuse filter but their edit doesn't contain the words?"

Trying to create an abuse filter that blocks certain images from being posted.

8
98.158.206.112 (talkcontribs)

Hi! I am an admin on a fairly big wiki software site. I have been encountering spams with hitler images and porn gifs. Would anyone know a way to block these images?

I don't have a bad media list. Or does anyone know how to create a bad media list?


Thank you!

Ciencia Al Poder (talkcontribs)

Are images already uploaded? Or are you using Wikimedia Commons images?

You can add specific image names to MediaWiki:Bad image list (on your wiki) to prevent them from being displayed on pages other than the allowed there.

If the images are being uploaded on your wiki, there's nothing much to do than to adjust upload permissions to autoconfirmed, or restrict uploads at all to trusted users or admins

98.158.206.112 (talkcontribs)

Hi Ciencia,

I would like to prevent the upload of all gifs in general.

Matěj Suchánek (talkcontribs)

You can try to ban .gif extensions, like action == 'upload' & page_title irlike '\.gif$'. But this can be bypassed easily.

Perhaps you want to raise permission for uploading files and grant them explicitly.

Ciencia Al Poder (talkcontribs)

To disallow upload of gifs, redefine $wgFileExtensions in LocalSettings.php without including gif. However, that can be bypassed by uploading static images. As Matěj Suchánek, you should limit who can upload files with permissions.

STITCH+COFFEE (talkcontribs)

Hi @Matěj Suchánek , thank you for the information. Is that the full code?And does it work on the abuse filter configuration page? I have just been copying/pasting abuse filters from public sources to block my current spam.

@Ciencia Al Poder , I apologize in advance for my lack of knowledge, how do I access the LocalSettings.php on my Wiki Software page?


As for static images, the business owner does not want to implement the limit.

Matěj Suchánek (talkcontribs)

I have never created filters for uploads, so I might be missing something but if you want to prevent uploading gifs (where gifs are identified with .gif extension), this should work.

There is a good and maintained documentation for filters you may want to read: Extension:AbuseFilter/Rules format.

Ciencia Al Poder (talkcontribs)

LocalSettings.php is a file in the server. You'll need server access by FTP or ssh (or remote desktop on windows) to modify it.

Reply to "Trying to create an abuse filter that blocks certain images from being posted."
Star Warden (talkcontribs)

Hey. Would anyone be kind enough to help me with an issue? I am getting the following error (https://pastebin.com/cGTxCEbW) when trying to create a new filter and I am not sure why. It's asking me if I've run a database update, but I did, assuming it refers to php update.php. Could anyone tell me what the issue is?

Daimona Eaytoy (talkcontribs)

@Star Warden: Hi! I'd need a few more info in order to understand what's going on... First of all, what DBMS are you using? And second, what MW version are you on? That query executes correctly for me, so it really sounds like the schema is wrong. It could have to do with missing db patches, or something wrong with the table prefix, or anything else; especially if you confirm that update.php ran without errors. Could you also post the result of running DESCRIBE dmlw_abuse_filter_history on your DB? Thanks.

Star Warden (talkcontribs)
Daimona Eaytoy (talkcontribs)

@Star Warden: Thanks! So, the last link shows that the column afh_deleted is indeed missing from the schema. And I see the afh_group column is also missing. And at this point, I also suspect other inconsistencies in the other tables. I see that afh_group is added together with abuse_filter.af_group, and afh_deleted together with abuse_filter.af_deleted. So, could you please post the result of DESCRIBE dmlw_abuse_filter? This way I'll be able to check why the DB patch wasn't applied. If that's possible for you, I'd also like to see the output of php update.php for what concerns AbuseFilter. That should be the part between ...abuse_filter table already exists and ...afl_namespace in table abuse_filter_log. It'd also be useful to see the schema for the other tables, i.e. the results of DESCRIBE dmlw_abuse_filter_action and DESCRIBE dmlw_abuse_filter_log, so to see if there are other inconsistencies. Thanks!

Star Warden (talkcontribs)
Daimona Eaytoy (talkcontribs)

@Star Warden: That's weird. The corresponding fields in the abuse_filter table exist, and they're added by the same patch, example. The updater is not re-applying the patch because it only checks if the field in the abuse_filter table is there. Since it is, it considers the update as already executed. This is weird, though, because the db patch hasn't been changed since 2012. At this point, I can't really say what happened. My only suggestion is to manually re-apply the missing part of the patches, so: ALTER TABLE dmlw_abuse_filter_history add column afh_group varchar(64) binary NULL; ALTER TABLE dmlw_abuse_filter_history ADD COLUMN afh_deleted tinyint(1) NOT NULL DEFAULT 0; The other tables are fine.

Star Warden (talkcontribs)

That solved it. Thanks a lot!

Jer Hughes (talkcontribs)

I see the script creates a user called "Abuse filter". Is this accounted needed? And if it is needed, can I rename it to something else?

Daimona Eaytoy (talkcontribs)

@Jer Hughes: Yes, it is needed to perform some actions like block, degroup and blockautopromote, if they are enabled (ref). It may also occasionally perform maintenance tasks, if we change something in the filter syntax. As for renaming, yes, you can. The name of the user is the message abusefilter-blocker. Note that, if you change the message, any previous log for the old name won't be moved. Moreover, we're planning on making it use the same name everywhere (T160666), and at that point, it would only be renamable if you change the source code.

Jer Hughes (talkcontribs)

Thank you very much. If I rename the user, how would I know in the future and what point its no longer working and I'd have to change the name in the source code?

Daimona Eaytoy (talkcontribs)

The user will be automatically renamed to the new name ("Abuse filter") during update.php, and changing the message above won't work. Although I have to say, this shouldn't happen anytime soon.

Reply to "User:Abuse filter"

New "Abuse filter" administrators on "all" WM wikis

6
Dcljr (talkcontribs)

Does anyone here know why (apparently) all Wikimedia content wikis just got a new adminstrator called "Abuse filter" (in the local language)? This happened on December 17th at around 3–6am UTC. Shouldn't this have happened long ago when the AbuseFilter extension was first installed/enabled on Wikimedia wikis?

Ejs-80 (talkcontribs)
MusikAnimal (talkcontribs)

Special:CentralAuth/Abuse_filter shows only a handful of wikis (presumably the ones that have AbuseFilter-imposed blocks enabled), and the accounts were attached between July 2014 and April 2015. You say there are other accounts with localized names?

Dcljr (talkcontribs)

Just look at 'Special:ListAdmins' on "any" Wikimedia wiki (examples: w:csb: s:eo: voy:uk:). You'll probably see a redlinked username that corresponds to "Abuse filter" in the local language of that wiki, that was created on 17 December 2018. The list at 'Special:CentralAuth/Abuse_filter' presumably (per Daimona Eaytoy below) contains the only WM wikis that didn't get a new admin created on that date.

Thanks to everyone for the info.

Daimona Eaytoy (talkcontribs)

The task above has all the info, which I'll sum up below. Yes, the AbuseFilter extension owns a system user with localized name (msg is "abusefilter-blocker"), used mainly to block users (and a couple of minor other things). In the linked patch we launched a script to clean up some filters across wikis which have wrong syntax, and we decided to use such user to perform the task. While the script hasn't made any changes for now, the account has been automatically created where it didn't exist. On wikis with block enabled, the user exists since the day block was enabled, which could be back to 2008 when the extension was created. In short, don't worry about it; we'll write a couple of lines in tech news before the final run.

Ejs-80 (talkcontribs)
Reply to "New "Abuse filter" administrators on "all" WM wikis"

How does Abuse Filter block this text?

3
116.192.183.44 (talkcontribs)
[[Cate<noinclude></noinclude>gory:Something unwanted]]

In Abuse Filter parameters, only new_text, new_html variables can be used, there is no variable of Template-Expanded text.

MusikAnimal (talkcontribs)

Try using added_lines_pst or new_pst. These represent pre-save transformed wikitext and should contain things like substitution syntax, and I presume the noinclude tags. I will warn you that the pst variables tend to be rather slow. If you're only looking within category syntax, you might first check added_lines contains "[[Category as this is cheap, then run the more expensive check against pst.

116.192.183.44 (talkcontribs)

Thanks, but how to deal this:

[[Cate{{{|gory}}}:Something unwanted]]
[[Cate{{{anyname|gory}}}:Someth{{{anyname|ing unw}}}anted]]
Reply to "How does Abuse Filter block this text?"

Is there a way to detect the use of spaces to get around filters?

2
Diamond Blizzard (talkcontribs)

I'm asking because I just saw someone adding stuff such as what can be seen in this diff: https://en.wikipedia.org/w/index.php?title=Del_City_High_School&diff=prev&oldid=854268628 Presumably, it was the spaces that prevented the change from being detected, as things such as this: https://en.wikipedia.org/wiki/Special:AbuseLog/21759611 were detected and blocked immediately. I do not feel confident at all in my ability to successfully make any changes myself to filters, so I'm asking this question.

MusikAnimal (talkcontribs)

You can use rmwhitespace() but we'd need to be careful with that filter to make sure no false positives happen as a result. E.g. "ass" matching "as soon" -- though this specific example shouldn't happen.

Reply to "Is there a way to detect the use of spaces to get around filters?"
Summary by PlavorSeol

Problem fixed

PlavorSeol (talkcontribs)

When I go to Special:AbuseFilter after installing AbuseFilter and run update.php, it shows following database error:

[bfb1bf7c329d630ebc5d6e00] 2018-06-25 15:18:44: Fatal exception of type "Wikimedia\Rdbms\DBQueryError"

Matěj Suchánek (talkcontribs)
PlavorSeol (talkcontribs)

Database error on Special:AbuseFilter:

[7584d3a6d8cb66b963a8b9a0] /plavormindtest/index.php?title=Special:AbuseFilter Wikimedia\Rdbms\DBQueryError from line 1443 of C:\NGINX\html\plavormindtest\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 af_id,af_enabled,af_deleted,af_pattern,af_global,af_public_comments,af_hidden,af_hit_count,af_timestamp,af_user_text,af_user,af_actions,af_group,af_throttled FROM abuse_filter WHERE af_deleted = '0' ORDER BY af_id LIMIT 51

Function: IndexPager::buildQueryInfo (AbuseFilterPager)

Error: 1 no such table: abuse_filter

Backtrace:

  1. 0 C:\NGINX\html\plavormindtest\includes\libs\rdbms\database\Database.php(1413): Wikimedia\Rdbms\Database->makeQueryException(string, integer, string, string)
  1. 1 C:\NGINX\html\plavormindtest\includes\libs\rdbms\database\Database.php(1186): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean)
  1. 2 C:\NGINX\html\plavormindtest\includes\libs\rdbms\database\Database.php(1640): Wikimedia\Rdbms\Database->query(string, string)
  1. 3 C:\NGINX\html\plavormindtest\includes\pager\IndexPager.php(368): Wikimedia\Rdbms\Database->select(array, array, array, string, array, array)
  1. 4 C:\NGINX\html\plavormindtest\includes\pager\IndexPager.php(224): IndexPager->reallyDoQuery(string, integer, boolean)
  1. 5 C:\NGINX\html\plavormindtest\includes\pager\IndexPager.php(608): IndexPager->doQuery()
  1. 6 C:\NGINX\html\plavormindtest\includes\pager\TablePager.php(292): IndexPager->isNavigationBarShown()
  1. 7 C:\NGINX\html\plavormindtest\extensions\AbuseFilter\includes\Views\AbuseFilterViewList.php(284): TablePager->getNavigationBar()
  1. 8 C:\NGINX\html\plavormindtest\extensions\AbuseFilter\includes\Views\AbuseFilterViewList.php(134): AbuseFilterViewList->showList(array, array)
  1. 9 C:\NGINX\html\plavormindtest\extensions\AbuseFilter\includes\special\SpecialAbuseFilter.php(122): AbuseFilterViewList->show()
  1. 10 C:\NGINX\html\plavormindtest\includes\specialpage\SpecialPage.php(565): SpecialAbuseFilter->execute(NULL)
  1. 11 C:\NGINX\html\plavormindtest\includes\specialpage\SpecialPageFactory.php(569): SpecialPage->run(NULL)
  1. 12 C:\NGINX\html\plavormindtest\includes\MediaWiki.php(288): SpecialPageFactory::executePath(Title, RequestContext)
  1. 13 C:\NGINX\html\plavormindtest\includes\MediaWiki.php(867): MediaWiki->performRequest()
  1. 14 C:\NGINX\html\plavormindtest\includes\MediaWiki.php(524): MediaWiki->main()
  1. 15 C:\NGINX\html\plavormindtest\index.php(42): MediaWiki->run()
  1. 16 {main}
PlavorSeol (talkcontribs)

Also update.php shows following error:

Creating abuse_filter table ...[b894800c426189ba94cbe1ab] [no req] Wikimedia\Rdbms\DBQueryError from line 1443 of C:\NGINX\html\plavormindtest\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: CREATE TABLE abuse_filter (

af_id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
af_pattern BLOB NOT NULL,
af_user INTEGER  NOT NULL,
af_user_text BLOB NOT NULL,
af_timestamp BLOB NOT NULL,
af_enabled INTEGER not null default 1,
af_comments BLOB,
af_public_comments BLOB,
af_hidden INTEGER not null default 0,
af_hit_count INTEGER not null default 0,
af_throttled INTEGER NOT NULL default 0,
af_deleted INTEGER NOT NULL DEFAULT 0,
af_actions BLOB NOT NULL DEFAULT ,
af_global INTEGER NOT NULL DEFAULT 0
af_group BLOB  NOT NULL DEFAULT 'default'
)

Function: Wikimedia\Rdbms\Database::sourceFile( C:\NGINX\html\plavormindtest\extensions\AbuseFilter/abusefilter.tables.sqlite.sql ) Error: 1 near "af_group": syntax error

Backtrace:

  1. 0 C:\NGINX\html\plavormindtest\includes\libs\rdbms\database\Database.php(1413): Wikimedia\Rdbms\Database->makeQueryException(string, integer, string, string)
  2. 1 C:\NGINX\html\plavormindtest\includes\libs\rdbms\database\Database.php(1186): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean)
  3. 2 C:\NGINX\html\plavormindtest\includes\libs\rdbms\database\Database.php(4260): Wikimedia\Rdbms\Database->query(string, string)
  4. 3 C:\NGINX\html\plavormindtest\includes\libs\rdbms\database\Database.php(4195): Wikimedia\Rdbms\Database->sourceStream(resource (closed), NULL, NULL, string, NULL)
  5. 4 C:\NGINX\html\plavormindtest\includes\installer\DatabaseUpdater.php(683): Wikimedia\Rdbms\Database->sourceFile(string)
  6. 5 C:\NGINX\html\plavormindtest\includes\installer\DatabaseUpdater.php(726): DatabaseUpdater->applyPatch(string, boolean, string)
  7. 6 C:\NGINX\html\plavormindtest\includes\installer\DatabaseUpdater.php(482): DatabaseUpdater->addTable(string, string, boolean)
  8. 7 C:\NGINX\html\plavormindtest\includes\installer\DatabaseUpdater.php(450): DatabaseUpdater->runUpdates(array, boolean)
  9. 8 C:\NGINX\html\plavormindtest\maintenance\update.php(200): DatabaseUpdater->doUpdates(array)
  10. 9 C:\NGINX\html\plavormindtest\maintenance\doMaintenance.php(94): UpdateMediaWiki->execute()
  11. 10 C:\NGINX\html\plavormindtest\maintenance\update.php(245): require_once(string)
  12. 11 {main}
Matěj Suchánek (talkcontribs)

Try downloading the newest version now. It seems Daimona Eaytoy fixed some syntax errors related to sqlite after your report.

Daimona Eaytoy (talkcontribs)

Yeah, I noticed it independently. BTW, @PlavorSeol, I suggest you to report these bugs on phabricator, so that they won't probably get unnoticed.

PlavorSeol (talkcontribs)

@Daimona Eaytoy Thanks, it works now. At first, I thought I configured my wiki incorrectly so that it had a problem.