nukeSEO.com - PHPNuke SEO Search engine optimization, professional tools including nukeSEO, nukeSPAM, nukeFEED, nukePIE, nukeWYSIWYG and more

 

. Welcome to nukeSEO.com  ! 
.
.
.
Support nukeSEO
Make donations with PayPal!
September´s Goal: $100.00
Due Date:   Sep 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Donations


Tag This

tag on del.icio.us digg this reddit this


.
nukeSEO.com: Forums


nukeSEO.com :: View topic - nukeSPAM™ update
 Forum FAQForum FAQ   SearchSearch   UsergroupsUsergroups   ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

nukeSPAM™ update
Goto page Previous  1, 2, 3, 4, 5  Next
 
Post new topic   Reply to topic    nukeSEO.com Forum Index -> nukeSPAM (tm)
View previous topic :: View next topic  
Author Message
Palbin
webmaster


Joined: Nov 28, 2007
Posts: 39

PostPosted: Fri Feb 10, 2012 5:31 pm    Post subject: Reply with quote

Yes that is what it takes to work with PHP 5.3.8 and MySQL 5.5.16.
Back to top
View user's profile Send private message
kguske
Site Admin
Site Admin


Joined: May 12, 2005
Posts: 907

PostPosted: Fri Feb 10, 2012 5:49 pm    Post subject: Reply with quote

Thanks! It has been updated in the download file.
_________________
Back to top
View user's profile Send private message Visit poster's website
Guardian
webmaster


Joined: Dec 25, 2005
Posts: 371
Location: Angra do Heroismo

PostPosted: Thu Feb 16, 2012 12:46 pm    Post subject: Reply with quote

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).
_________________
Script Shack
Back to top
View user's profile Send private message Visit poster's website
kguske
Site Admin
Site Admin


Joined: May 12, 2005
Posts: 907

PostPosted: Thu Feb 16, 2012 1:15 pm    Post subject: Reply with quote

I'm still waiting for fSpamList to reply...I can't test that without it.
_________________
Back to top
View user's profile Send private message Visit poster's website
kguske
Site Admin
Site Admin


Joined: May 12, 2005
Posts: 907

PostPosted: Mon Feb 27, 2012 11:49 pm    Post subject: Reply with quote

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.
_________________
Back to top
View user's profile Send private message Visit poster's website
hicux
webmaster


Joined: Apr 28, 2008
Posts: 32

PostPosted: Sun Jul 01, 2012 7:17 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Visit poster's website
kguske
Site Admin
Site Admin


Joined: May 12, 2005
Posts: 907

PostPosted: Sun Jul 01, 2012 12:16 pm    Post subject: Reply with quote

Generally, the newer files should be used. If you compare them, the version will be identified near the top of the files.
_________________
Back to top
View user's profile Send private message Visit poster's website
neralex
webmaster


Joined: Feb 22, 2008
Posts: 29

PostPosted: Sat Aug 18, 2012 2:02 pm    Post subject: Reply with quote

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


Confused
Back to top
View user's profile Send private message
kguske
Site Admin
Site Admin


Joined: May 12, 2005
Posts: 907

PostPosted: Sun Aug 19, 2012 5:18 pm    Post subject: Reply with quote

dextar, nukeSPAM only works with RavenNuke 2.5+.
_________________
Back to top
View user's profile Send private message Visit poster's website
neralex
webmaster


Joined: Feb 22, 2008
Posts: 29

PostPosted: Tue Aug 21, 2012 4:05 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
kguske
Site Admin
Site Admin


Joined: May 12, 2005
Posts: 907

PostPosted: Tue Aug 21, 2012 6:30 am    Post subject: Reply with quote

Thank you for confirming 2.5.

I'll check on this further tonight.
_________________
Back to top
View user's profile Send private message Visit poster's website
kguske
Site Admin
Site Admin


Joined: May 12, 2005
Posts: 907

PostPosted: Tue Aug 21, 2012 7:36 pm    Post subject: Reply with quote

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.
_________________
Back to top
View user's profile Send private message Visit poster's website
neralex
webmaster


Joined: Feb 22, 2008
Posts: 29

PostPosted: Sat Aug 25, 2012 11:34 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
kguske
Site Admin
Site Admin


Joined: May 12, 2005
Posts: 907

PostPosted: Sat Aug 25, 2012 4:00 pm    Post subject: Reply with quote

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
_________________
Back to top
View user's profile Send private message Visit poster's website
neralex
webmaster


Joined: Feb 22, 2008
Posts: 29

PostPosted: Sun Aug 26, 2012 7:00 am    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    nukeSEO.com Forum Index -> nukeSPAM (tm) All times are GMT - 5 Hours
Goto page Previous  1, 2, 3, 4, 5  Next
Page 2 of 5

 

Jump to:   
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum

Powered by phpBB © 2001-2008 phpBB Group


nukeSEO™, nukeFEED™, nukeINFO™, nukeNAV™, nukePIE™, nukeREADER™, nukeSLIDER™, nukeSOCIAL™, nukeSPAM™, nukeTIDY™, nukeWYSIWYG™ are trademarks of nukeSEO.com.

RavenNuke™ CMS is distributed by Raven PHP Scripts
New code written and maintained by the RavenNuke™ TEAM


PHP-Nuke Copyright © 2004 by Francisco Burzi. This is free software, and you may redistribute it under the GPL. PHP-Nuke comes with absolutely no warranty, for details, see the license.
Page Generation: 0.51 Seconds