AntiSpam by CleanTalk 2.9

[CleanTalk Team]

I'm surprised there's not more discussion of this plug in. I installed it yesterday and in the last 24 hours, it has banned 400 Russian spammers. These spammers were getting through the normal defenses, despite using Captcha and StopForumSpam. It was so bad that my moderators were on the verge of resigning, all they did all day was delete bogus registrations.

Yes, there is a noticable, but not terrible, performance hit. My forum responded instantly previously, now there is a short, but noticeable pause. But it's not bad, and it's much better than finding spam after spam on the forum and in PMs which was happening constantly.

Why aren't more folks using this? What have I overlooked?

Hello, Bob.

Thank you for your kind words!

Probably, seeing your review there are few more Xenforo community members become CleanTalk clients.

 

[GeekyPhilip]

I'm surprised there's not more discussion of this plug in. I installed it yesterday and in the last 24 hours, it has banned 400 Russian spammers. These spammers were getting through the normal defenses, despite using Captcha and StopForumSpam. It was so bad that my moderators were on the verge of resigning, all they did all day was delete bogus registrations.

Yes, there is a noticable, but not terrible, performance hit. My forum responded instantly previously, now there is a short, but noticeable pause. But it's not bad, and it's much better than finding spam after spam on the forum and in PMs which was happening constantly.

Why aren't more folks using this? What have I overlooked?

I use it on all my forum installs and would not be without it.

 

[CleanTalk Team]

I use it on all my forum installs and would not be without it.

Thank you for trusting us.

 

[RobinHood]

Not tried your XF offering, but I do use you on a few of my WP sites, the service works well.

 

[CleanTalk Team]

CleanTalk Team updated AntiSpam by CleanTalk with a new update entry:

2.9

• Fix: check sfw_temp table before insert.
• Fix: E_DEPRECATED exception in Cleantalk.php.
• Fix: http__get_headers() renamed to httpGetHeaders() and fixed.
• Fix: Cron. Fix: Cron. Cron last start flag improved.
• Fix: drop if exists.
• Fix. SFW log query fixed.

Read the rest of this update entry...

 

[Alpha1]

@CleanTalk Team the version of the latest release is displayed wrong here on the resource. '2022-02-21' is not a version number. Please correct this. Its causing the version check to display a false negative.

 

[CleanTalk Team]

@CleanTalk Team the version of the latest release is displayed wrong here on the resource. '2022-02-21' is not a version number. Please correct this. Its causing the version check to display a false negative.

Hello.

Thank you for your feedback.

We'll fix this shortly.

Best regards.

 

[CleanTalk Team]

CleanTalk Team updated AntiSpam by CleanTalk with a new update entry:

2.9

• Version number fixed.

Read the rest of this update entry...

 

[CleanTalk Team]

@CleanTalk Team the version of the latest release is displayed wrong here on the resource. '2022-02-21' is not a version number. Please correct this. Its causing the version check to display a false negative.

Done, version number changed to 2.9.

Thank you for your cooperation.

 

[mazzly]

@CleanTalk Team I'm still seeing errors related to the sfw_temp table.. I tried reinstalling in case it would help..

XF\Db\Exception: Error rendering widget: MySQL statement prepare error [1146]: Table 'forumdb.xf_cleantalk_sfw_temp' doesn't exist
src/XF/Db/AbstractStatement.php:228
Generated by: Unknown account
Nov 9, 2022 at 4:29 PM

Stack trace
INSERT INTO xf_cleantalk_sfw_temp (network, mask, status) VALUES (3118229241,4294967295,0),(3118229242,4294967295,0),(3118229243,4294967295,0),(3118229244,4294967295,0),(3118229245,4294967295,0)....(stripped out because it is loooong);
-----------

#0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException('MySQL statement...', 1146, '42S02')
#1 src/XF/Db/Mysqli/Statement.php(39): XF\Db\Mysqli\Statement->getException('MySQL statement...', 1146, '42S02')
#2 src/XF/Db/Mysqli/Statement.php(54): XF\Db\Mysqli\Statement->prepare()
#3 src/XF/Db/AbstractAdapter.php(94): XF\Db\Mysqli\Statement->execute()
#4 src/addons/CleanTalk/lib/CleanTalk/ApbctXF2/DB.php(47): XF\Db\AbstractAdapter->query('INSERT INTO xf_...')
#5 src/addons/CleanTalk/lib/CleanTalk/Common/Firewall/FirewallUpdater.php(187): CleanTalk\ApbctXF2\DB->execute('INSERT INTO xf_...')
#6 src/addons/CleanTalk/lib/CleanTalk/ApbctXF2/Funcs.php(103): CleanTalk\Common\Firewall\FirewallUpdater->update()
#7 src/addons/CleanTalk/lib/CleanTalk/ApbctXF2/RemoteCalls.php(28): CleanTalk\ApbctXF2\Funcs::apbct_sfw_update('epy7yganabut')
#8 src/addons/CleanTalk/lib/CleanTalk/Common/RemoteCalls.php(89): CleanTalk\ApbctXF2\RemoteCalls->action__sfw_update__write_base()
#9 src/addons/CleanTalk/lib/CleanTalk/ApbctXF2/Funcs.php(127): CleanTalk\Common\RemoteCalls->perform()
#10 src/addons/CleanTalk/XF/Template/Templater.php(116): CleanTalk\ApbctXF2\Funcs::ctRemoteCalls()
#11 src/addons/MaZ/AMPvw/XF/Template/Templater.php(17): CleanTalk\XF\Template\Templater->renderTemplate('public:_widget_...', Array, true, NULL)
#12 src/addons/vw/vw/XF/Template/Templater22.php(34): MaZ\AMPvw\XF\Template\Templater->renderTemplate('public:_widget_...', Array, true, NULL)
#13 src/addons/MaZ/AMP/XF/Template/XF22/Templater.php(52): vw\vw\XF\Template\Templater22->renderTemplate('public:_widget_...', Array, true, NULL)
#14 src/XF/Widget/Html.php(16): MaZ\AMP\XF\Template\XF22\Templater->renderTemplate('public:_widget_...', Array)
#15 internal_data/code_cache/widgets/_18_frododuck_aff.php(8): XF\Widget\Html->render()
#16 src/XF/Template/Templater.php(7472): XF\SubContainer\Widget->{closure}(Object(MaZ\AMP\XF\Template\XF22\Templater), Array, Array)
#17 src/XF/SubContainer/Widget.php(168): XF\Template\Templater->renderWidgetClosure(Object(Closure), Array)
#18 src/addons/vw/vw/XF/SubContainer/Widget.php(34): XF\SubContainer\Widget->getCompiledWidget(Array, Array)
#19 src/XF/Template/Templater.php(1903): vw\vw\XF\SubContainer\Widget->getCompiledWidget(Array, Array)
#20 src/addons/vw/vw/XF/Template/Templater.php(1109): XF\Template\Templater->widgetPosition('forum_list_side...', Array)
#21 internal_data/code_cache/templates/l1/s6/public/forum_list.php(216): vw\vw\XF\Template\Templater->widgetPosition('forum_list_side...', Array)
#22 src/XF/Template/Templater.php(1628): XF\Template\Templater->{closure}(Object(MaZ\AMP\XF\Template\XF22\Templater), Array, NULL)
#23 src/addons/CleanTalk/XF/Template/Templater.php(106): XF\Template\Templater->renderTemplate('forum_list', Array, true, NULL)
#24 src/addons/MaZ/AMPvw/XF/Template/Templater.php(17): CleanTalk\XF\Template\Templater->renderTemplate('public:forum_li...', Array, true, NULL)
#25 src/addons/vw/vw/XF/Template/Templater22.php(34): MaZ\AMPvw\XF\Template\Templater->renderTemplate('public:forum_li...', Array, true, NULL)
#26 src/addons/MaZ/AMP/XF/Template/XF22/Templater.php(52): vw\vw\XF\Template\Templater22->renderTemplate('public:forum_li...', Array, true, NULL)
#27 src/XF/Template/Template.php(24): MaZ\AMP\XF\Template\XF22\Templater->renderTemplate('public:forum_li...', Array)
#28 src/XF/Mvc/Renderer/Html.php(48): XF\Template\Template->render()
#29 src/XF/Mvc/Dispatcher.php(458): XF\Mvc\Renderer\Html->renderView('XF:Forum\\Listin...', 'public:forum_li...', Array)
#30 src/XF/Mvc/Dispatcher.php(440): XF\Mvc\Dispatcher->renderView(Object(XF\Mvc\Renderer\Html), Object(XF\Mvc\Reply\View))
#31 src/XF/Mvc/Dispatcher.php(400): XF\Mvc\Dispatcher->renderReply(Object(XF\Mvc\Renderer\Html), Object(XF\Mvc\Reply\View))
#32 src/XF/Mvc/Dispatcher.php(58): XF\Mvc\Dispatcher->render(Object(XF\Mvc\Reply\View), 'html')
#33 src/XF/App.php(2337): XF\Mvc\Dispatcher->run()
#34 src/XF.php(488): XF\App->run()
#35 index.php(20): XF::runApp('XF\\Pub\\App')
#36 {main}

Request state
array(4) {
  ["url"] => string(539) "/?spbc_remote_call_action=sfw_update__write_base&plugin_name=apbct&spbc_remote_call_token=***&file_urls=apix2.cleantalk.org%2Fstore%2Fbl_list_161c65afa5f3ced31e320996972ca205.multifiles.csv.gz&url_count=4&current_url=2&firewall_updating_id=0?spbc_remote_call_action=sfw_update__write_base&plugin_name=apbct&spbc_remote_call_token=***&file_urls=apix2.cleantalk.org%2Fstore%2Fbl_list_161c65afa5f3ced31e320996972ca205.multifiles.csv.gz&url_count=4&current_url=2&firewall_updating_id=0"
  ["referrer"] => bool(false)
  ["_GET"] => array(7) {
    ["spbc_remote_call_action"] => string(22) "sfw_update__write_base"
    ["plugin_name"] => string(5) "apbct"
    ["spbc_remote_call_token"] => string(32) "28f82499b0bc4e047784637ee1ed8701"
    ["file_urls"] => string(84) "apix2.cleantalk.org/store/bl_list_161c65afa5f3ced31e320996972ca205.multifiles.csv.gz"
    ["url_count"] => string(1) "4"
    ["current_url"] => string(1) "2"
    ["firewall_updating_id"] => string(1) "0"
  }
  ["_POST"] => array(0) {
  }
}

 

[CleanTalk Team]

@CleanTalk Team I'm still seeing errors related to the sfw_temp table.. I tried reinstalling in case it would help..

XF\Db\Exception: Error rendering widget: MySQL statement prepare error [1146]: Table 'forumdb.xf_cleantalk_sfw_temp' doesn't exist
src/XF/Db/AbstractStatement.php:228
Generated by: Unknown account
Nov 9, 2022 at 4:29 PM

Stack trace
INSERT INTO xf_cleantalk_sfw_temp (network, mask, status) VALUES (3118229241,4294967295,0),(3118229242,4294967295,0),(3118229243,4294967295,0),(3118229244,4294967295,0),(3118229245,4294967295,0)....(stripped out because it is loooong);
-----------

#0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException('MySQL statement...', 1146, '42S02')
#1 src/XF/Db/Mysqli/Statement.php(39): XF\Db\Mysqli\Statement->getException('MySQL statement...', 1146, '42S02')
#2 src/XF/Db/Mysqli/Statement.php(54): XF\Db\Mysqli\Statement->prepare()
#3 src/XF/Db/AbstractAdapter.php(94): XF\Db\Mysqli\Statement->execute()
#4 src/addons/CleanTalk/lib/CleanTalk/ApbctXF2/DB.php(47): XF\Db\AbstractAdapter->query('INSERT INTO xf_...')
#5 src/addons/CleanTalk/lib/CleanTalk/Common/Firewall/FirewallUpdater.php(187): CleanTalk\ApbctXF2\DB->execute('INSERT INTO xf_...')
#6 src/addons/CleanTalk/lib/CleanTalk/ApbctXF2/Funcs.php(103): CleanTalk\Common\Firewall\FirewallUpdater->update()
#7 src/addons/CleanTalk/lib/CleanTalk/ApbctXF2/RemoteCalls.php(28): CleanTalk\ApbctXF2\Funcs::apbct_sfw_update('epy7yganabut')
#8 src/addons/CleanTalk/lib/CleanTalk/Common/RemoteCalls.php(89): CleanTalk\ApbctXF2\RemoteCalls->action__sfw_update__write_base()
#9 src/addons/CleanTalk/lib/CleanTalk/ApbctXF2/Funcs.php(127): CleanTalk\Common\RemoteCalls->perform()
#10 src/addons/CleanTalk/XF/Template/Templater.php(116): CleanTalk\ApbctXF2\Funcs::ctRemoteCalls()
#11 src/addons/MaZ/AMPvw/XF/Template/Templater.php(17): CleanTalk\XF\Template\Templater->renderTemplate('public:_widget_...', Array, true, NULL)
#12 src/addons/vw/vw/XF/Template/Templater22.php(34): MaZ\AMPvw\XF\Template\Templater->renderTemplate('public:_widget_...', Array, true, NULL)
#13 src/addons/MaZ/AMP/XF/Template/XF22/Templater.php(52): vw\vw\XF\Template\Templater22->renderTemplate('public:_widget_...', Array, true, NULL)
#14 src/XF/Widget/Html.php(16): MaZ\AMP\XF\Template\XF22\Templater->renderTemplate('public:_widget_...', Array)
#15 internal_data/code_cache/widgets/_18_frododuck_aff.php(8): XF\Widget\Html->render()
#16 src/XF/Template/Templater.php(7472): XF\SubContainer\Widget->{closure}(Object(MaZ\AMP\XF\Template\XF22\Templater), Array, Array)
#17 src/XF/SubContainer/Widget.php(168): XF\Template\Templater->renderWidgetClosure(Object(Closure), Array)
#18 src/addons/vw/vw/XF/SubContainer/Widget.php(34): XF\SubContainer\Widget->getCompiledWidget(Array, Array)
#19 src/XF/Template/Templater.php(1903): vw\vw\XF\SubContainer\Widget->getCompiledWidget(Array, Array)
#20 src/addons/vw/vw/XF/Template/Templater.php(1109): XF\Template\Templater->widgetPosition('forum_list_side...', Array)
#21 internal_data/code_cache/templates/l1/s6/public/forum_list.php(216): vw\vw\XF\Template\Templater->widgetPosition('forum_list_side...', Array)
#22 src/XF/Template/Templater.php(1628): XF\Template\Templater->{closure}(Object(MaZ\AMP\XF\Template\XF22\Templater), Array, NULL)
#23 src/addons/CleanTalk/XF/Template/Templater.php(106): XF\Template\Templater->renderTemplate('forum_list', Array, true, NULL)
#24 src/addons/MaZ/AMPvw/XF/Template/Templater.php(17): CleanTalk\XF\Template\Templater->renderTemplate('public:forum_li...', Array, true, NULL)
#25 src/addons/vw/vw/XF/Template/Templater22.php(34): MaZ\AMPvw\XF\Template\Templater->renderTemplate('public:forum_li...', Array, true, NULL)
#26 src/addons/MaZ/AMP/XF/Template/XF22/Templater.php(52): vw\vw\XF\Template\Templater22->renderTemplate('public:forum_li...', Array, true, NULL)
#27 src/XF/Template/Template.php(24): MaZ\AMP\XF\Template\XF22\Templater->renderTemplate('public:forum_li...', Array)
#28 src/XF/Mvc/Renderer/Html.php(48): XF\Template\Template->render()
#29 src/XF/Mvc/Dispatcher.php(458): XF\Mvc\Renderer\Html->renderView('XF:Forum\\Listin...', 'public:forum_li...', Array)
#30 src/XF/Mvc/Dispatcher.php(440): XF\Mvc\Dispatcher->renderView(Object(XF\Mvc\Renderer\Html), Object(XF\Mvc\Reply\View))
#31 src/XF/Mvc/Dispatcher.php(400): XF\Mvc\Dispatcher->renderReply(Object(XF\Mvc\Renderer\Html), Object(XF\Mvc\Reply\View))
#32 src/XF/Mvc/Dispatcher.php(58): XF\Mvc\Dispatcher->render(Object(XF\Mvc\Reply\View), 'html')
#33 src/XF/App.php(2337): XF\Mvc\Dispatcher->run()
#34 src/XF.php(488): XF\App->run()
#35 index.php(20): XF::runApp('XF\\Pub\\App')
#36 {main}

Request state
array(4) {
  ["url"] => string(539) "/?spbc_remote_call_action=sfw_update__write_base&plugin_name=apbct&spbc_remote_call_token=***&file_urls=apix2.cleantalk.org%2Fstore%2Fbl_list_161c65afa5f3ced31e320996972ca205.multifiles.csv.gz&url_count=4&current_url=2&firewall_updating_id=0?spbc_remote_call_action=sfw_update__write_base&plugin_name=apbct&spbc_remote_call_token=***&file_urls=apix2.cleantalk.org%2Fstore%2Fbl_list_161c65afa5f3ced31e320996972ca205.multifiles.csv.gz&url_count=4&current_url=2&firewall_updating_id=0"
  ["referrer"] => bool(false)
  ["_GET"] => array(7) {
    ["spbc_remote_call_action"] => string(22) "sfw_update__write_base"
    ["plugin_name"] => string(5) "apbct"
    ["spbc_remote_call_token"] => string(32) "28f82499b0bc4e047784637ee1ed8701"
    ["file_urls"] => string(84) "apix2.cleantalk.org/store/bl_list_161c65afa5f3ced31e320996972ca205.multifiles.csv.gz"
    ["url_count"] => string(1) "4"
    ["current_url"] => string(1) "2"
    ["firewall_updating_id"] => string(1) "0"
  }
  ["_POST"] => array(0) {
  }
}

Hello.
Can you reach out to our support team so we can gather some more information from you concerning this issue?
Login to dashboard
Thank you.

 

[Nicolas FR]

Hello @CleanTalk Team there seems to be a problem with the phrases, right?

 

[CleanTalk Team]

Hello @CleanTalk Team there seems to be a problem with the phrases, right?

View attachment 276392

Hello,
Could you please reinstall our plugin and check it again?

 

[Nicolas FR]

re-download, re-install, re-build... same result.

 

[Nicolas FR]

update : only appears on my local XF with debug and dev modes enabled.

 

[CleanTalk Team]

Could you please disable these modes and check again?

 

[Nicolas FR]

Could you please disable these modes and check again?

update : only appears on my local XF with debug and dev modes enabled.

 

[CleanTalk Team]

We found out a few bugs while testing the CleanTalk add-on today.
Please, wait up to 3 business days for our fixes.
Thank you.

 

[CleanTalk Team]

update : only appears on my local XF with debug and dev modes enabled.

Hello.
We've checked and can say that there is nothing strange in the shown service fields and it's totally OK for debugging mode. Could you clarify what is exactly wrong?

 

[Nicolas FR]

I thought he couldn't get any clearer than a screenshot. But maybe it's me who's wrong and it's specific to debug or dev mode but it's the first time I see it... Field titles and descriptions are in the form this_is_my_title instead of phrases like This is my title...