Alright, I was able to solve this by manually grabbing the wp_bp_gtm_* tables from my working BP install. I wouldn’t recommend messing with your DB if you don’t know exactly what you’re doing, but here’s what I imported:
–
– Table structure for table wp_bp_gtm_discuss
–
CREATE TABLE wp_bp_gtm_discuss (
id bigint(20) NOT NULL auto_increment,
text longtext NOT NULL,
author_id bigint(20) NOT NULL,
task_id bigint(20) NOT NULL default ’0′,
project_id bigint(20) NOT NULL default ’0′,
group_id bigint(20) NOT NULL default ’0′,
date_created datetime NOT NULL,
PRIMARY KEY (id),
KEY author_id (author_id),
KEY task_id (task_id),
KEY project_id (project_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
–
– Dumping data for table wp_bp_gtm_discuss
–
– ——————————————————–
–
– Table structure for table wp_bp_gtm_projects
–
CREATE TABLE wp_bp_gtm_projects (
id bigint(20) NOT NULL auto_increment,
name varchar(200) NOT NULL,
desc longtext NOT NULL,
status varchar(10) NOT NULL default ‘public’,
group_id bigint(20) default NULL,
creator_id bigint(20) NOT NULL,
resp_id varchar(500) NOT NULL,
date_created datetime NOT NULL,
deadline datetime NOT NULL,
done tinyint(1) NOT NULL default ’0′,
discuss_count bigint(20) NOT NULL default ’0′,
PRIMARY KEY (id),
KEY creator_id (creator_id),
KEY resp_id (resp_id(333)),
KEY status (status)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
–
– Dumping data for table wp_bp_gtm_projects
–
INSERT INTO wp_bp_gtm_projects VALUES (1, ‘FilamentFourDesign Website’, ‘
of the web variety.
n’, ‘hidden’, 35, 1, ‘admin’, ’2010-10-04 11:46:41′, ’2010-10-21 00:00:00′, 0, 0);
– ——————————————————–
–
– Table structure for table wp_bp_gtm_resps
–
CREATE TABLE wp_bp_gtm_resps (
task_id bigint(20) NOT NULL default ’0′,
project_id bigint(20) NOT NULL default ’0′,
group_id bigint(20) NOT NULL default ’0′,
resp_id bigint(20) NOT NULL,
KEY resp_id (resp_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
–
– Dumping data for table wp_bp_gtm_resps
–
INSERT INTO wp_bp_gtm_resps VALUES (0, 1, 35, 1);
INSERT INTO wp_bp_gtm_resps VALUES (1, 1, 35, 1);
INSERT INTO wp_bp_gtm_resps VALUES (2, 1, 35, 1);
INSERT INTO wp_bp_gtm_resps VALUES (3, 1, 35, 1);
– ——————————————————–
–
– Table structure for table wp_bp_gtm_tasks
–
CREATE TABLE wp_bp_gtm_tasks (
id bigint(20) NOT NULL auto_increment,
name varchar(200) NOT NULL,
desc longtext NOT NULL,
status varchar(10) NOT NULL default ‘public’,
parent_id bigint(20) NOT NULL default ’0′,
creator_id bigint(20) NOT NULL,
group_id bigint(20) default NULL,
project_id bigint(20) NOT NULL,
resp_id varchar(500) NOT NULL,
date_created datetime NOT NULL,
deadline datetime NOT NULL,
done tinyint(1) NOT NULL default ’0′,
discuss_count bigint(20) NOT NULL default ’0′,
PRIMARY KEY (id),
KEY parent_id (parent_id),
KEY creator_id (creator_id),
KEY resp_id (resp_id(333)),
KEY status (status)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
–
– Dumping data for table wp_bp_gtm_tasks
–
INSERT INTO wp_bp_gtm_tasks VALUES (1, ‘Make a logo’, ‘
and make it good.
n’, ”, 0, 1, 35, 1, ‘admin’, ’2010-10-04 11:47:31′, ’2010-10-18 00:00:00′, 0, 0);
INSERT INTO wp_bp_gtm_tasks VALUES (2, ‘subtask 1′, ‘
suuuub
n’, ‘hidden’, 1, 1, 35, 1, ‘admin’, ’2010-10-04 11:48:00′, ’2010-10-16 00:00:00′, 0, 0);
INSERT INTO wp_bp_gtm_tasks VALUES (3, ‘Another Sub Task’, ‘
suub2
n’, ‘hidden’, 1, 1, 35, 1, ‘admin’, ’2010-10-04 11:50:40′, ’2010-10-03 00:00:00′, 0, 0);
– ——————————————————–
–
– Table structure for table wp_bp_gtm_taxon
–
CREATE TABLE wp_bp_gtm_taxon (
id bigint(20) NOT NULL auto_increment,
task_id bigint(20) NOT NULL default ’0′,
project_id bigint(20) default NULL,
group_id bigint(20) default NULL,
term_id bigint(20) NOT NULL,
taxon varchar(20) NOT NULL,
PRIMARY KEY (id),
KEY task_id (task_id),
KEY project_id (project_id)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;
–
– Dumping data for table wp_bp_gtm_taxon
–
INSERT INTO wp_bp_gtm_taxon VALUES (1, 0, 1, 35, 2, ‘tag’);
INSERT INTO wp_bp_gtm_taxon VALUES (2, 0, 1, 35, 3, ‘tag’);
INSERT INTO wp_bp_gtm_taxon VALUES (3, 1, 1, 35, 1, ‘cat’);
INSERT INTO wp_bp_gtm_taxon VALUES (4, 3, 1, 35, 2, ‘tag’);
– ——————————————————–
–
– Table structure for table wp_bp_gtm_terms
–
CREATE TABLE wp_bp_gtm_terms (
id bigint(20) NOT NULL auto_increment,
taxon varchar(20) NOT NULL,
group_id bigint(20) default NULL,
name varchar(100) NOT NULL,
PRIMARY KEY (id)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
–
– Dumping data for table wp_bp_gtm_terms
–
INSERT INTO wp_bp_gtm_terms VALUES (1, ‘cat’, 35, ‘Websites’);
INSERT INTO wp_bp_gtm_terms VALUES (2, ‘tag’, 35, ‘web’);
INSERT INTO wp_bp_gtm_terms VALUES (3, ‘tag’, 35, ‘graphics’);
