nukeSPAM update

webmaster Joined: Nov 28, 2007 Posts: 38

Yes that is what it takes to work with PHP 5.3.8 and MySQL 5.5.16.

Site Admin Joined: May 12, 2005 Posts: 876

Thanks! It has been updated in the download file.
_________________

Posted: Thu Feb 16, 2012 12:46 pm Post subject:

Just installed this today and it's looking good. Now I just have to wait for ForumStopSpam to fix their site so I can get my API key (don't know where I put the last on).
_________________
Only registered users can see links on this board! Get registered or login!

Posted: Thu Feb 16, 2012 1:15 pm Post subject:

I'm still waiting for fSpamList to reply...I can't test that without it.

Posted: Mon Feb 27, 2012 11:49 pm Post subject:

nukeSPAM version 1.0.1 has been released. It contains some important fixes (namely, for the StopForumSpam and fSpamList checks), and a few minor enhancements / tweaks. There are no database changes in the new version, but the installation is slightly change for the Your_Account file changes, so please read the readme.txt file carefully, especially if you are updating.

The issues with StopForumSpam and fSpamList could cause missed positives, so if you use either or both of these services (both are good), you want to get this update.

Thanks to nuken for providing valuable feedback on the SFS issue.

webmaster Joined: Apr 28, 2008 Posts: 13

Ok, guys, my question is simple. I install the nukeWYSIWYG_3_6_3 but now I want to install nukeSPAM_1_0_1. The problem is I notice there are the same files in \includes\jquery\ from

nukeWYSIWYG_3_6_3: jquery.js ; jquery-ui.min.js

nukeSPAM_1_0_1: jquery.js

etc. there are more. What shoud I do guys?

Question

Posted: Sun Jul 01, 2012 12:16 pm Post subject:

Generally, the newer files should be used. If you compare them, the version will be identified near the top of the files.

webmaster Joined: Feb 22, 2008 Posts: 20

The install of 1_0_1 is dosen't work for me:

Code:

August 18, 2012, 8:59 pm File: F:\wamp\www\rn\db\mysqli.php - Line: 207


Code: 1064 - Message: 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 'where config_type = 'nukeSPAM' LIMIT 0' at line 1


SQL was: SELECT 1 FROM `nuke_seo_config` INTO @x where config_type = 'nukeSPAM' LIMIT 0


 remote addr: 127.0.0.1


August 18, 2012, 8:59 pm File: F:\wamp\www\rn\db\mysqli.php - Line: 207


Code: 1062 - Message: Duplicate entry 'nukeSPAM-baseMatch' for key 'PRIMARY'


SQL was: INSERT INTO `nuke_seo_config` VALUES ('nukeSPAM', 'baseMatch', '');


 remote addr: 127.0.0.1


August 18, 2012, 8:59 pm File: F:\wamp\www\rn\db\mysqli.php - Line: 207


Code: 1146 - Message: Table 'cabal.nuke_spam_log' doesn't exist


SQL was: SELECT 1 FROM `nuke_spam_log` LIMIT 0


 remote addr: 127.0.0.1


August 18, 2012, 8:59 pm File: F:\wamp\www\rn\db\mysqli.php - Line: 207


Code: 1071 - Message: Specified key was too long; max key length is 1000 bytes


SQL was: CREATE TABLE `nuke_spam_log` ( `slid` INT NOT NULL AUTO_INCREMENT PRIMARY KEY , `request` CHAR( 6 ) NOT NULL , `username` VARCHAR( 255 ) NOT NULL , `email` VARCHAR( 255 ) NOT NULL , `ip` INT UNSIGNED NOT NULL , `matched` VARCHAR( 255 ) NOT NULL , `added` INT( 11 ) NOT NULL , `count` INT UNSIGNED NOT NULL , INDEX ( `request` ), INDEX ( `username` , `email` , `ip` ), INDEX ( `email` , `ip` ), INDEX ( `ip` , `email` ) ) ENGINE=MyISAM;


 remote addr: 127.0.0.1


August 18, 2012, 8:59 pm File: F:\wamp\www\rn\db\mysqli.php - Line: 207


Code: 1064 - Message: 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 'where config_type = 'nukeSPAM' and config_name = 'useBLDE' LIMIT 0' at line 1


SQL was: SELECT 1 FROM `nuke_seo_config` INTO @x where config_type = 'nukeSPAM' and config_name = 'useBLDE' LIMIT 0


 remote addr: 127.0.0.1


August 18, 2012, 8:59 pm File: F:\wamp\www\rn\db\mysqli.php - Line: 207


Code: 1062 - Message: Duplicate entry 'nukeSPAM-useBLDE' for key 'PRIMARY'


SQL was: INSERT INTO `nuke_seo_config` VALUES ('nukeSPAM', 'useBLDE', '1');


 remote addr: 127.0.0.1


August 18, 2012, 8:59 pm File: F:\wamp\www\rn\db\mysqli.php - Line: 207


Code: 1064 - Message: 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 'where config_type = 'nukeSPAM' and config_name = 'theme' LIMIT 0' at line 1


SQL was: SELECT 1 FROM `nuke_seo_config` INTO @x where config_type = 'nukeSPAM' and config_name = 'theme' LIMIT 0


 remote addr: 127.0.0.1


August 18, 2012, 8:59 pm File: F:\wamp\www\rn\db\mysqli.php - Line: 207


Code: 1062 - Message: Duplicate entry 'nukeSPAM-theme' for key 'PRIMARY'


SQL was: INSERT INTO `nuke_seo_config` VALUES ('nukeSPAM', 'theme', 'smoothness');


 remote addr: 127.0.0.1

Posted: Sun Aug 19, 2012 5:18 pm Post subject:

dextar, nukeSPAM only works with RavenNuke 2.5+.

Posted: Tue Aug 21, 2012 4:05 am Post subject:

Code:

August 18, 2012, 8:59 pm File: F:\wamp\www\rn\db\mysqli.php

I know, its an RN25 and it dosen't work! only in RN25 exist the mysqli.php!

Code:

SELECT 1 FROM `nuke_seo_config` INTO @x where config_type = 'nukeSPAM' LIMIT 0

Explain me better, what is "@x" and please read my logfile Confused

Posted: Tue Aug 21, 2012 6:30 am Post subject:

Thank you for confirming 2.5.

I'll check on this further tonight.

Posted: Tue Aug 21, 2012 7:36 pm Post subject:

dextar, what versions of MySQL and PHP are you using on your test server?

In modues/nukeSPAM/admin/index.php, try changing line 29 to:

Code:

      $existSQL = 'SELECT 1 FROM `'.$prefix.'_seo_config` where config_type = \'nukeSPAM\' LIMIT 0 INTO @x';

and line 102 to:

Code:

      $existSQL = 'SELECT 1 FROM `'.$prefix.'_seo_config` where config_type = \'nukeSPAM\' and config_name = \'useBLDE\' LIMIT 0 INTO @x';

and finally, line 108 to:

Code:

      $existSQL = 'SELECT 1 FROM `'.$prefix.'_seo_config` where config_type = \'nukeSPAM\' and config_name = \'theme\' LIMIT 0 INTO @x';

Basically, this moves "INTO @x" (which is an output variable) to the end. This seemed to work on my test system.

Posted: Sat Aug 25, 2012 11:34 am Post subject:

Its Apache/2.2.22 (Win64) PHP/5.3.13, mysql 5.5.24! It seems it works a little bit better but i get a last error. How can i fix it?

Code:

August 25, 2012, 6:27 pm File: F:\wamp\www\cabal\db\mysqli.php - Line: 207


Code: 1146 - Message: Table 'cabal_test.nuke_spam_log' doesn't exist


SQL was: SELECT 1 FROM `nuke_spam_log` LIMIT 0


 remote addr: 127.0.0.1


August 25, 2012, 6:27 pm File: F:\wamp\www\cabal\db\mysqli.php - Line: 207


Code: 1071 - Message: Specified key was too long; max key length is 1000 bytes


SQL was: CREATE TABLE `nuke_spam_log` ( `slid` INT NOT NULL AUTO_INCREMENT PRIMARY KEY , `request` CHAR( 6 ) NOT NULL , `username` VARCHAR( 255 ) NOT NULL , `email` VARCHAR( 255 ) NOT NULL , `ip` INT UNSIGNED NOT NULL , `matched` VARCHAR( 255 ) NOT NULL , `added` INT( 11 ) NOT NULL , `count` INT UNSIGNED NOT NULL , INDEX ( `request` ), INDEX ( `username` , `email` , `ip` ), INDEX ( `email` , `ip` ), INDEX ( `ip` , `email` ) ) ENGINE=MyISAM;


 remote addr: 127.0.0.1

Posted: Sat Aug 25, 2012 4:00 pm Post subject:

Which character set are you using on the database? UTF 8? In order to support that, we will need to make changes to compress / decompress the user and email. That is being considered for the next release.

In the mean time, here are some options:
- use another character set that takes fewer bytes per character (UTF8 takes 4)
- reduce the combine size of the username (e.g. 25) and email fields (e.g. 200) to 225 (make sure to limit the maximum user name in Your Account Limits to the same size as the username in the table or less)
- remove the index with username and email (this could affect performance if you have lots of blocked registration attempts

Posted: Sun Aug 26, 2012 7:00 am Post subject:

Yes i'm using UTF-8 and have my RN25 and the database completely on UTF-8. I don't want switch to an another character set for one module. Sorry, but It makes no sense.

Btw... with the reducing of the size of username and email, it works now. The database is completely installed.

Thanks.

Welcome to nukeSEO.com !	Home News Stories Archive Forums Forums Unanswered Posts Modules Content Downloads Encyclopedia FAQ Feeds Tutorials Web Links Your Account Login Register Site Info Sitemap