StopCountrySpam_v1_0_2.zip
Release 7/10/2012
Change Log:
- Admin Control Panel Options updated to show a list of tick boxes rather than a select dropdown box (making country selection obvious / easier)
Now includes a log section in the Admin Control Panel: Tools >> StopCountrySpam Log
Server Error
Mysqli prepare error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''sf_stopcountryspam_iso3166_codes', 'sf_stopcountryspam_log'' at line 2
1.Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
2.Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
3.Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
4.Zend_Db_Adapter_Abstract->query() in StopCountrySpam/Install.php at line 301
5.StopCountrySpam_Install::uninstallCode()
6.call_user_func() in XenForo/DataWriter/AddOn.php at line 193
7.XenForo_DataWriter_AddOn->_postDelete() in XenForo/DataWriter.php at line 1738
8.XenForo_DataWriter->delete() in XenForo/ControllerAdmin/AddOn.php at line 116
9.XenForo_ControllerAdmin_AddOn->actionDelete() in XenForo/FrontController.php at line 310
10.XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 132
11.XenForo_FrontController->run() in /home/coder/public_html/community/admin.php at line 13
Fixed bug with unistaller
Until XenForo supports IPv6, this plugin does not log the IPv6 attempts (but still blocks them if they are from a black listed country)
Server Error
Mysqli prepare error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''sf_stopcountryspam_iso3166_codes'' at line 2
1.Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
2.Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
3.Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
4.Zend_Db_Adapter_Abstract->query() in StopCountrySpam/Install.php at line 300
5.StopCountrySpam_Install::uninstallCode()
6.call_user_func() in XenForo/DataWriter/AddOn.php at line 193
7.XenForo_DataWriter_AddOn->_postDelete() in XenForo/DataWriter.php at line 1738
8.XenForo_DataWriter->delete() in XenForo/ControllerAdmin/AddOn.php at line 116
9.XenForo_ControllerAdmin_AddOn->actionDelete() in XenForo/FrontController.php at line 310
10.XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 132
11.XenForo_FrontController->run() in /home/coder/public_html/community/admin.php at line 13
That's was a user name attempt.
This user went to the sign up button (or simulated it with a bot) and then entered a user name
On clicking "No, Create an account now => Sign up" this user name is the sent to the registration page
The plug-in not quite completely working fine, I've still seen some issues when a user tries to register with IPv6 internet addresses (IPv6 seems to be mostly from Russia and China, and are not yet supported in XF). An error is thrown if they are from a black listed country and this plugin tries to log the data... I'm looking at a fix now, and a way to log the attempt.
(its only an error for those that are blacklisted anyway, and I believe will also be fixed by changing the column type of the ip_address)
can you attach image of the error? just in case i got the same error i would know its related to IPv6 registration attempt
We use essential cookies to make this site work, and optional cookies to enhance your experience.