bbPress.org

I installed the plugin, deleted the table … then walked through rebuilding the database from what I saw in the code. The following SQL is an export of my bb_bbpm table direct from mySQL. If you run it, you should get PMs back up and running.

CREATE TABLE IF NOT EXISTS bb_bbpm (

ID bigint(20) unsigned NOT NULL auto_increment,

pm_title varchar(100) collate utf8_unicode_ci NOT NULL,

pm_read tinyint(1) NOT NULL default 0,

pm_from bigint(20) unsigned NOT NULL,

pm_to bigint(20) unsigned NOT NULL,

pm_text text collate utf8_unicode_ci NOT NULL,

sent_on int(10) NOT NULL,

del_sender tinyint(1) NOT NULL default 0,

del_reciever tinyint(1) NOT NULL default 0,

reply_to bigint(20) unsigned default NULL,

thread_depth int(10) unsigned NOT NULL default 0,

pm_thread bigint(20) unsigned NOT NULL,

PRIMARY KEY (ID),

KEY pm_to (pm_to,pm_from,reply_to),

KEY pm_thread (pm_thread)

) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;

Amazing Paul