Joined: Dec 25, 2005 Posts: 368 Location: Vsetin, Czech Republic
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). _________________ Total Project Design
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. _________________
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
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
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 _________________
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.
All times are GMT - 5 Hours Goto page Previous1, 2, 3, 4Next
Page 2 of 4
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
Welcome to nukeSEO.com !
Forum FAQ
Search
Usergroups
Profile
Log in to check your private messages
Log in
