Skip to:
Content
Pages
Categories
Search
Top
Bottom

One Click Forum BBpress Install Did Not Created BBPress Table

  • Avatar of Arghagain
    arghagain
    Participant

    @arghagain

    One click installation forum bbpress did not create a global table. Forum is broken because no topic can be created due to the reason I stated. So what is the mysql code to create bbpress table? In bb-config.php I saw a default table name listed, and so I know I need to create a table with the same name as in bb-config.php in global db. But I need to find the mysql code for creating bbpress table. Any help anyone? Thanks…

Viewing 15 replies - 1 through 15 (of 15 total)
  • Avatar of John James Jacoby
    John James Jacoby
    Keymaster

    @johnjamesjacoby

    Was this a fresh installation or did you have bbPress installed previously?

    Avatar of Arghagain
    arghagain
    Participant

    @arghagain

    I did not use bbpress for buddypress 1.0.0, but after upgrade to buddypress 1.1.2, I use the one click install bbpress mode. No existing bbpress before that.

    Avatar of John James Jacoby
    John James Jacoby
    Keymaster

    @johnjamesjacoby

    When you try the one click installation, does it say it did it successfully?

    Avatar of Arghagain
    arghagain
    Participant

    @arghagain

    John, yes it say it did it successfully. I’m looking into defaults.bb-schema.php right now to see if I can find anything. I’m clueless now. Funny thing is that this file is not in buddypress plugin before, but I downloaded the buddypress again from buddypress.org and found it. This file supposed to be gone after buddypress got upgraded or installed?

    Avatar of Arghagain
    arghagain
    Participant

    @arghagain

    After looking through global db, I saw the buddypress did not installed any bbpress table at all. After looking into defaults.bb-schema.php, I recreated the bbpress tables as follow:

    CREATE TABLE mydb_global.wp_bb_forums (

    forum_id int(10) NOT NULL auto_increment,

    forum_name varchar(150) NOT NULL default ”,

    forum_slug varchar(255) NOT NULL default ”,

    forum_desc text NOT NULL,

    forum_parent int(10) NOT NULL default 0,

    forum_order int(10) NOT NULL default 0,

    topics bigint(20) NOT NULL default 0,

    posts bigint(20) NOT NULL default 0,

    PRIMARY KEY (forum_id),

    KEY forum_slug (forum_slug)

    );

    CREATE TABLE mydb_global.wp_bb_meta (

    meta_id bigint(20) NOT NULL auto_increment,

    object_type varchar(16) NOT NULL default ‘bb_option’,

    object_id bigint(20) NOT NULL default 0,

    meta_key varchar(255) default NULL,

    meta_value longtext default NULL,

    PRIMARY KEY (meta_id),

    KEY object_type__meta_key (object_type, meta_key),

    KEY object_type__object_id__meta_key (object_type, object_id, meta_key)

    );

    CREATE TABLE mydb_global.wp_bb_posts (

    post_id bigint(20) NOT NULL auto_increment,

    forum_id int(10) NOT NULL default 1,

    topic_id bigint(20) NOT NULL default 1,

    poster_id int(10) NOT NULL default 0,

    post_text text NOT NULL,

    post_time datetime NOT NULL default ‘0000-00-00 00:00:00′,

    poster_ip varchar(15) NOT NULL default ”,

    post_status tinyint(1) NOT NULL default 0,

    post_position bigint(20) NOT NULL default 0,

    PRIMARY KEY (post_id),

    KEY topic_time (topic_id, post_time),

    KEY poster_time (poster_id, post_time),

    KEY post_time (post_time),

    FULLTEXT KEY post_text (post_text)

    ) TYPE = MYISAM;

    CREATE TABLE mydb_global.wp_bb_terms (

    term_id bigint(20) NOT NULL auto_increment,

    name varchar(55) NOT NULL default ”,

    slug varchar(200) NOT NULL default ”,

    term_group bigint(10) NOT NULL default 0,

    PRIMARY KEY (term_id),

    UNIQUE KEY slug (slug),

    KEY name (name)

    );

    CREATE TABLE mydb_global.wp_bb_term_relationships (

    object_id bigint(20) NOT NULL default 0,

    term_taxonomy_id bigint(20) NOT NULL default 0,

    user_id bigint(20) NOT NULL default 0,

    term_order int(11) NOT NULL default 0,

    PRIMARY KEY (object_id, term_taxonomy_id),

    KEY term_taxonomy_id (term_taxonomy_id)

    );

    CREATE TABLE mydb_global.wp_bb_term_taxonomy (

    term_taxonomy_id bigint(20) NOT NULL auto_increment,

    term_id bigint(20) NOT NULL default 0,

    taxonomy varchar(32) NOT NULL default ”,

    description longtext NOT NULL,

    parent bigint(20) NOT NULL default 0,

    count bigint(20) NOT NULL default 0,

    PRIMARY KEY (term_taxonomy_id),

    UNIQUE KEY term_id_taxonomy (term_id, taxonomy),

    KEY taxonomy (taxonomy)

    );

    CREATE TABLE mydb_global.wp_bb_topics (

    topic_id bigint(20) NOT NULL auto_increment,

    topic_title varchar(100) NOT NULL default ”,

    topic_slug varchar(255) NOT NULL default ”,

    topic_poster bigint(20) NOT NULL default 0,

    topic_poster_name varchar(40) NOT NULL default ‘Anonymous’,

    topic_last_poster bigint(20) NOT NULL default 0,

    topic_last_poster_name varchar(40) NOT NULL default ”,

    topic_start_time datetime NOT NULL default ‘0000-00-00 00:00:00′,

    topic_time datetime NOT NULL default ‘0000-00-00 00:00:00′,

    forum_id int(10) NOT NULL default 1,

    topic_status tinyint(1) NOT NULL default 0,

    topic_open tinyint(1) NOT NULL default 1,

    topic_last_post_id bigint(20) NOT NULL default 1,

    topic_sticky tinyint(1) NOT NULL default 0,

    topic_posts bigint(20) NOT NULL default 0,

    tag_count bigint(20) NOT NULL default 0,

    PRIMARY KEY (topic_id),

    KEY topic_slug (topic_slug),

    KEY forum_time (forum_id, topic_time),

    KEY user_start_time (topic_poster, topic_start_time),

    KEY stickies (topic_status, topic_sticky, topic_time)

    );

    CREATE TABLE mydb_global.wp_bb_users (

    ID bigint(20) unsigned NOT NULL auto_increment,

    user_login varchar(60) NOT NULL default ”,

    user_pass varchar(64) NOT NULL default ”,

    user_nicename varchar(50) NOT NULL default ”,

    user_email varchar(100) NOT NULL default ”,

    user_url varchar(100) NOT NULL default ”,

    user_registered datetime NOT NULL default ‘0000-00-00 00:00:00′,

    user_status int(11) NOT NULL default 0,

    display_name varchar(250) NOT NULL default ”,

    PRIMARY KEY (ID),

    UNIQUE KEY user_login (user_login),

    UNIQUE KEY user_nicename (user_nicename),

    KEY user_registered (user_registered)

    );

    CREATE TABLE mydb_global.wp_bb_usermeta (

    umeta_id bigint(20) NOT NULL auto_increment,

    user_id bigint(20) NOT NULL default 0,

    meta_key varchar(255),

    meta_value longtext,

    PRIMARY KEY (umeta_id),

    KEY user_id (user_id),

    KEY meta_key (meta_key)

    );

    Unfortunately, test user is still cannot create topic. BBpress forum is essentially broken.

    Avatar of Sarah Gooding
    Sarah Gooding
    Participant

    @pollyplummer

    I’m subscribing to this… maybe one click install is too good to be true?

    Avatar of Jeff Sayre
    Jeff Sayre
    Participant

    @jeffsayre

    @pollyplummer

    One click (or rather two clicks) bbPress install works great for me and many others.

    Avatar of Sarah Gooding
    Sarah Gooding
    Participant

    @pollyplummer

    I’ve had issues with it working sometimes and not others on clean installs with virtually no plugins. Maybe I’m doing something wrong. I’ll have to review my process :)

    Avatar of Jeff Sayre
    Jeff Sayre
    Participant

    @jeffsayre

    @pollyplummer-

    There are more detailed instructions here:

    http://codex.buddypress.org/developer-discussions/buddypress-forum/

    I hope that helps.

    Avatar of josephtravers
    josephtravers
    Participant

    @josephtravers

    Hi guys (and gals),

    I too am using the one-click new installation option… it only asks me to create a bb-config.php file (and gives me what I should put in it), after which it says that “bbPress forum integration in BuddyPress has been set up correctly. ” … but nothing will load on any forum pages… all that shows is a white page. No header, no nothing.

    By looking around in the files of the WPMU installation, I see all the bbpress files in the “wp-content/plugins/buddypress/bp-forums/bbpress” directory, including a “bb-config-sample.php” file, but no bb-config.php file.

    The one-click installation page mentioned at the beginning of this post told me to put the bb-config.php file in the root directory of my WPMU install, but maybe I should put it in the same directory as “bb-config-sample.php”?

    Thanks for any help… just installed BuddyPress today and love it! :)

    [UPDATE]

    Okay, I just checked my DB via cpanel, and the tables are there… but BuddyPress isn’t showing *anything* related to forums on my installation.

    The forums on my site are here: http://www.greenparenting.ca/forums

    Avatar of josephtravers
    josephtravers
    Participant

    @josephtravers

    I’ve posted my “White Screen” topic in a new thread, as it doesn’t fit here, as it looks like the tables have been created. Can’t seem to delete my above post.

    Avatar of enxaqueca
    enxaqueca
    Member

    @enxaqueca

    Hello! I had the same problem until I increased the memory limit of my PHP pages via php.ini – then I retried the one-click forum setup and it worked perfectly.

    Avatar of herzseben
    herzseben
    Member

    @herzseben

    This actually sounds like it might be the root cause of my own issue.

    After installing BuddyPress, I am getting the following error in my Dashboard under WordPress Development Blog, Incoming Links, and Plugins

    Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 30720 bytes) in /home/herzsage/public_html/wp-includes/class-simplepie.php on line 14271

    I’m not sure how it’s eating over 30MB to begin with, but the symptoms are there (no BBpress tables or files, Page Not Found error midway through group creation after installing BBpress, etc) and my Dashboard is clearly telling me I’m having memory issues.

    However, I never had this problem when integrating the three before. I’m even running BuddyPress off a single-blog WordPress installation because I have no use for Mu – how is it eating so much memory, and what did you set your memory limit at to resolve the issue?

    Avatar of herzseben
    herzseben
    Member

    @herzseben

    An update to the above.

    After looking around a bit, it seems that just changing the default memory allocation in wp-settings.php solves this problem. I ran into this while testing, however, so I was able to just reinstall WP and change this setting, then install BP and BBpress again.

    @herzseben,
    what/how exactly did you change if you could show some codes pls?

    Thanks

    (After looking around a bit, it seems that just changing the default memory allocation in wp-settings.php solves this problem. I ran into this while testing, however, so I was able to just reinstall WP and change this setting, then install BP and BBpress again.)

Viewing 15 replies - 1 through 15 (of 15 total)

You must be logged in to reply to this topic.