BuddyPress Site-wide Search – Global Unified Search Plugin

[AITpro Admin]

Update:  bbPress has created a really nice bbPress Search Forums Widget.  We are now using that bbPress search Widget, but the Global Unified Search plugin was a great thing for a couple of years on this site.

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.

Note:  This Topic was created from an old Blog post dated November 6, 2012

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

Solution:

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 ;

[Author]

Posts