November 5, 2012 in Forum Blog
November 7, 2012 in Forum Blog
Hmm looks like i get to try out my new Prototype Anti-Comment Spam plugin on BuddyPress. Massive Group Spam comments are completely bypassing Akismet (actually Akismet does not check BuddyPress Groups so no wonder spammers splog Groups). I have been using the Prototype on the AITpro standard WordPress sites and it is 100% effective and blocks all Spammers so I assume it will be just as effective with BuddyPress – yeah a new challenge – Love it. I will be disabling registering and posting for a little while to get my new Prototype plugin in place – ETA 2 hours.
After looking around the Internet it appears the Spammers target the Groups feature in BuddyPress. Looks like Group Creation should be turned off in Settings >>> BuddyPress >>> Settings >>> Group Creation >>> Enable group creation for all users. I’ll give this a whirl and see what happens next. Will still be implementing my new Prototype Anti-Comment Spam plugin, but it appears that additional coding work would need to be done for it to be able to filter out Group Spam. Registration and posting is re-enabled.
FYI – you do not need to delete the Spam Groups and can just delete the Spam User account and then choose delete all posts associated with that Loser.
After 5 hours no new Group Spam has been posted so simply turning off Enable group creation for all users takes care of the numb nut Group Spammers.
November 6, 2012 in Forum Blog
I would like to sincerely thank Brajesh Singh, the creator of the BuddyPress Global Unified Search Plugin, for creating such an excellent search plugin that allows folks to search a BuddyPress site globally for any search term anywhere under the entire BuddyPress website. It is a truly brilliant plugin. If you have a BuddyPress website and it is not an MU site then I found only one issue that can be quickly remedied.
The minor issue:
A PHP Error was generated because this MU Database Table wp_blogs was not found since the BuddyPress site is not an MU site.
[05-Nov-2012 22:43:45] WordPress database error Table 'xxxxxxxxx.wp_blogs' doesn't exist for query SELECT COUNT(DISTINCT b.blog_id) FROM wp_bp_user_blogs b, wp_blogs wb, wp_bp_user_blogs_blogmeta bm, wp_bp_user_blogs_blogmeta bm2 WHERE b.blog_id = wb.blog_id AND bm.blog_id = b.blog_id AND bm2.blog_id = b.blog_id AND wb.archived = '0' AND wb.spam = 0 AND wb.mature = 0 AND wb.deleted = 0 AND bm.meta_key = 'name' AND bm2.meta_key = 'description' AND ( bm.meta_value LIKE '%%cheeseburger%%' || bm2.meta_value LIKE '%%cheeseburger%%' ) made by require('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), call_user_func_array, bp_buddydev_search, bp_core_load_template, load_template, require_once('/themes/AITpro/search-single.php'), do_action('advance-search'), call_user_func_array, bpmag_show_blogs_search, locate_template, load_template, require_once('/plugins/buddypress/bp-themes/bp-default/blogs/blogs-loop.php'), bp_has_blogs, BP_Blogs_Template->__construct, bp_blogs_get_blogs, BP_Blogs_Blog::get
Run a MySQL query in phpMyAdmin (the Adminer plugin makes this nice and simple to do from within your WordPress Dashboard) and create the wp_blogs Database Table.
DROP TABLE IF EXISTS `wp_blogs`;
CREATE TABLE `wp_blogs` (
`blog_id` bigint(20) NOT NULL AUTO_INCREMENT,
`site_id` bigint(20) NOT NULL DEFAULT '0',
`domain` varchar(200) NOT NULL DEFAULT '',
`path` varchar(100) NOT NULL DEFAULT '',
`registered` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`last_updated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`public` tinyint(2) NOT NULL DEFAULT '1',
`archived` enum('0','1') NOT NULL DEFAULT '0',
`mature` tinyint(2) NOT NULL DEFAULT '0',
`spam` tinyint(2) NOT NULL DEFAULT '0',
`deleted` tinyint(2) NOT NULL DEFAULT '0',
`lang_id` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`blog_id`),
KEY `domain` (`domain`(50),`path`(5)),
KEY `lang_id` (`lang_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;