Extension talk:SpamRegex

questions: how, what, where, when
Some discussion to answer the questions: how, what, where, when, &tc. would be nice.

Previous versions
what about ver 1.11? --217.132.70.182 21:28, 25 September 2009 (UTC)
 * If you're using MediaWiki 1.11, you seriously should upgrade your MW to a newer version. After all, 1.11 is considered obsolete (see Version lifecycle for details). --Jack Phoenix (Contact) 22:25, 25 September 2009 (UTC)
 * so the answer is no, it is not compatible with 1.11? Errectstapler 03:50, 17 July 2011 (UTC)

SQL statement is not postgres compatible
the sql statment that has to be executed does not work on a postgres based installation. it doesn't like the backticks and after removing them it does not like the int( part.

Un-block a phrase?
I'll be downloanding and installing this when I get home tonight, but I'd like to know what to do to remove a phrase from the black list if necessary. Thanks! FrankCarroll 23:56, 16 February 2011 (UTC)
 * Ok, now that it's installed I see how it works. Thanks! FrankCarroll 02:24, 17 February 2011 (UTC)

Admin immunity
It would be nice if there was a way to make admins immune from the spam regex. I add to my wiki a lot and occasionally have to unblock myself when editing articles that legitimacy have words that are banned in them. 01:35, 17 August 2011 (UTC)

Bulk Additions?
Is there a way to add large groups of expressions in one go easily? 98.180.57.100 08:00, 5 October 2011 (UTC)

Manual needed!
Could anybody provide a How-to? There's barely any information available! Thanks, 88.73.159.136 02:48, 26 March 2012 (UTC)
 * If you need help with regex, read en:Regular expression.Jasper Deng (talk) 02:52, 26 March 2012 (UTC)
 * No no, I need help with this extension. I can't get it working right on our wiki. 88.73.159.136 02:53, 26 March 2012 (UTC)
 * What's your problem?Jasper Deng (talk) 03:01, 26 March 2012 (UTC)
 * My problem is, I need a more detailed explanation of how to get this extension to work because I tried to do it as described; but it's not working. 88.73.159.136 03:06, 26 March 2012 (UTC)
 * What's the issue with your extension install?Jasper Deng (talk) 03:08, 26 March 2012 (UTC)
 * I don't know, that's my issue. As I stated above: I just need a more detailed instruction; manual; tutorial; whatever you wanna call it. 88.73.159.136 03:13, 26 March 2012 (UTC)
 * I mean, is it that you're getting 500 errors or database errors or what?Jasper Deng (talk) 03:17, 26 March 2012 (UTC)
 * It doesn't even show up on the Special:... Page because I don't know what else I have to configure in my localsettings.php and elsewhere, that's what I'm missing on this extension page - a more detailed instruction. Like, what "require_once..." codes I have to enter and whatnot. 88.73.159.136 03:24, 26 March 2012 (UTC)
 * Looks like you need to set up user rights, like:


 * Also, did you follow the instructions on the page about if the special page is not accessible?Jasper Deng (talk) 03:27, 26 March 2012 (UTC)
 * Yes, seems I forgot to add the user rights, I thought they were set to sysop by default. I will try again. 88.73.159.136 03:30, 26 March 2012 (UTC) EDIT: Do I have to include "$wgAvailableRights[] = 'spamregex';" in the localsettings too? 88.73.159.136 03:35, 26 March 2012 (UTC)
 * Probably not, that's something that I've never seen called in LocalSettings.php.Jasper Deng (talk) 03:37, 26 March 2012 (UTC)
 * Now it shows up on Special but I'm getting an error message about the table, because I also don't know how and where to set up that table... 88.73.159.136 03:43, 26 March 2012 (UTC)
 * When having table errors, it usually helps to run maintenance.php. Linux users can use  after switching to the MediaWiki installation directory. Windows users can use   after switching to their MediaWiki installation directory.Jasper Deng (talk) 03:47, 26 March 2012 (UTC)
 * Look, it says: "2.Create the spam_regex table with the SQL query below..." but it does not say where to create it and how (for dummies like me) I'm a bit of a noob and need a step-by-step instruction... 88.73.159.136 03:51, 26 March 2012 (UTC)
 * Well, it means inside the database your wiki uses, which can be done using maintenance.php. PhpMyAdmin would really help if you want to be simple. You would run the SQL query specified on the extension page for the database your wiki uses.Jasper Deng (talk) 03:54, 26 March 2012 (UTC)

Ok, I finally found out how to open phpMyAdmin on our server, now if you could explain where and how exactly I have to enter that "SQL query to create the table" or where and how to run "SpamRegex.sql", I promise I will never ever bother you again... :P 88.73.159.136 04:41, 26 March 2012 (UTC)
 * No, it's OK :) . So you login to PHPMyAdmin as root or another user that can access the database. Then you click the database your wiki's installed on, and you run this SQL. However, I need to know if you're using $wgDBprefix.Jasper Deng (talk) 04:45, 26 March 2012 (UTC)
 * No, I haven't used that yet. 88.73.159.136 04:47, 26 March 2012 (UTC)
 * I mean, open LocalSettings.php and Ctrl-F for $wgDBprefix. Tell me what it's set to.Jasper Deng (talk) 04:54, 26 March 2012 (UTC)
 * $wgDBprefix        = "nameofourwiki_"; -- 88.73.159.136 04:59, 26 March 2012 (UTC)
 * Hhm, that means you need to go to your database in PHPMyAdmin, and run the SQL twice, once as is written, and the second time as:

because I'm unsure of whether this particular extension has support for $wgDBprefix.Jasper Deng (talk) 05:05, 26 March 2012 (UTC)
 * Gives me this error:
 * import.php: Missing parameter: import_type (FAQ 2.8)
 * import.php: Missing parameter: format (FAQ 2.8)


 * Or I'm doing it wrong again... 88.73.159.136 05:10, 26 March 2012 (UTC)
 * What did you do?Jasper Deng (talk) 05:12, 26 March 2012 (UTC)
 * I simply copied and pasted that query into the window, replaced the wiki names and hit "OK", then it gave me the error messages. 88.73.159.136 05:16, 26 March 2012 (UTC)
 * Which field did you use? I mean, there's more than one possible place you can enter that into.Jasper Deng (talk) 05:19, 26 March 2012 (UTC)
 * This one -- 88.73.159.136 05:23, 26 March 2012 (UTC)
 * OK, you don't do it for one table, you do this SQL for the database. Click the database link, then SQL, without clicking any table links.Jasper Deng (talk) 05:26, 26 March 2012 (UTC)
 * I'm kinda lost... O.o -- 88.73.159.136 05:29, 26 March 2012 (UTC)
 * Well, the root of each tree is your database. Click that. Then click SQL and execute the SQL above. I know, it's hard.Jasper Deng (talk) 05:38, 26 March 2012 (UTC)
 * Can you show me a pic? I have absolutely no idea what that tree looks like and I feel totally clueless and I apologize for probably being the worst case of noobness... :-/ 88.73.159.136 05:42, 26 March 2012 (UTC)

The SQL above is wrong; the only place where $wgDBprefix should be substituted is the table name; if our $wgDBprefix is mw_, then spam_regex would become mw_spam_regex; the field names (spam_id, spam_summary, etc.) should be left as-is!

Really, the simplest way to do this is to SSH to the server and run. --Jack Phoenix (Contact) 13:24, 26 March 2012 (UTC)