Skip to:
Content
Pages
Categories
Search
Top
Bottom

1 and 1 server, Mysql 4, PHP 4, BuddyPress installation

  • 1) Upload WordPress Mu package

    2) open .htaccess and add :

    AddType x-mapp-php5 .php

    AddHandler x-mapp-php5 .php

    3) Install WordPress Mu with the subdirectory option ( subdomain option does not work)

    4) Enable blog+account creation from admin panel

    5) Test your installation by creating one test-user account+blog , then remove test-user account+blog

    6) Go to your PHPMyAdmin interface and create the following tables:

    CREATE TABLE wp_bp_activity_sitewide (

    id int(11) NOT NULL auto_increment,

    user_id int(11) NOT NULL,

    item_id int(11) NOT NULL,

    secondary_item_id int(11) default NULL,

    content longtext NOT NULL,

    primary_link varchar(150) NOT NULL,

    component_name varchar(75) NOT NULL,

    component_action varchar(75) NOT NULL,

    date_cached datetime NOT NULL,

    date_recorded datetime NOT NULL,

    PRIMARY KEY (id),

    KEY date_cached (date_cached),

    KEY date_recorded (date_recorded),

    KEY user_id (user_id),

    KEY item_id (item_id),

    KEY component_name (component_name)

    ) TYPE=MyISAM ;

    CREATE TABLE wp_bp_friends (

    id int(11) NOT NULL auto_increment,

    initiator_user_id int(11) NOT NULL,

    friend_user_id int(11) NOT NULL,

    is_confirmed tinyint(1) default ’0′,

    is_limited tinyint(1) default ’0′,

    date_created datetime NOT NULL,

    PRIMARY KEY (id),

    KEY initiator_user_id (initiator_user_id),

    KEY friend_user_id (friend_user_id)

    ) TYPE=MyISAM ;

    CREATE TABLE wp_bp_groups (

    id int(11) NOT NULL auto_increment,

    creator_id int(11) NOT NULL,

    name varchar(100) NOT NULL,

    slug varchar(100) NOT NULL,

    description longtext NOT NULL,

    news longtext NOT NULL,

    status varchar(10) NOT NULL default ‘open’,

    is_invitation_only tinyint(1) NOT NULL default ’0′,

    enable_wire tinyint(1) NOT NULL default ’1′,

    enable_forum tinyint(1) NOT NULL default ’1′,

    enable_photos tinyint(1) NOT NULL default ’1′,

    photos_admin_only tinyint(1) NOT NULL default ’0′,

    date_created datetime NOT NULL,

    avatar_thumb varchar(250) NOT NULL,

    avatar_full varchar(250) NOT NULL,

    PRIMARY KEY (id),

    KEY creator_id (creator_id),

    KEY status (status),

    KEY is_invitation_only (is_invitation_only)

    ) TYPE=MyISAM ;

    CREATE TABLE wp_bp_groups_groupmeta (

    id int(11) NOT NULL auto_increment,

    group_id int(11) NOT NULL,

    meta_key varchar(255) default NULL,

    meta_value longtext,

    PRIMARY KEY (id),

    KEY group_id (group_id),

    KEY meta_key (meta_key)

    ) TYPE=MyISAM ;

    CREATE TABLE wp_bp_groups_members (

    id int(11) NOT NULL auto_increment,

    group_id int(11) NOT NULL,

    user_id int(11) NOT NULL,

    inviter_id int(11) NOT NULL,

    is_admin tinyint(1) NOT NULL default ’0′,

    is_mod tinyint(1) NOT NULL default ’0′,

    user_title varchar(100) NOT NULL,

    date_modified datetime NOT NULL,

    comments longtext NOT NULL,

    is_confirmed tinyint(1) NOT NULL default ’0′,

    is_banned tinyint(1) NOT NULL default ’0′,

    invite_sent tinyint(1) NOT NULL default ’0′,

    PRIMARY KEY (id),

    KEY group_id (group_id),

    KEY is_admin (is_admin),

    KEY is_mod (is_mod),

    KEY user_id (user_id),

    KEY inviter_id (inviter_id),

    KEY is_confirmed (is_confirmed)

    ) TYPE=MyISAM ;

    CREATE TABLE wp_bp_groups_wire (

    id int(11) NOT NULL auto_increment,

    item_id int(11) NOT NULL,

    user_id int(11) NOT NULL,

    content longtext NOT NULL,

    date_posted datetime NOT NULL,

    PRIMARY KEY (id),

    KEY item_id (item_id),

    KEY user_id (user_id)

    ) TYPE=MyISAM ;

    CREATE TABLE wp_bp_messages_messages (

    id int(11) NOT NULL auto_increment,

    sender_id int(11) NOT NULL,

    subject varchar(200) NOT NULL,

    message longtext NOT NULL,

    date_sent datetime NOT NULL,

    message_order int(10) NOT NULL,

    sender_is_group tinyint(1) NOT NULL default ’0′,

    PRIMARY KEY (id),

    KEY sender_id (sender_id),

    KEY message_order (message_order),

    KEY sender_is_group (sender_is_group)

    ) TYPE=MyISAM ;

    CREATE TABLE wp_bp_messages_notices (

    id int(11) NOT NULL auto_increment,

    subject varchar(200) NOT NULL,

    message longtext NOT NULL,

    date_sent datetime NOT NULL,

    is_active tinyint(1) NOT NULL default ’0′,

    PRIMARY KEY (id),

    KEY is_active (is_active)

    ) TYPE=MyISAM ;

    CREATE TABLE wp_bp_messages_recipients (

    id int(11) NOT NULL auto_increment,

    user_id int(11) NOT NULL,

    thread_id int(11) NOT NULL,

    sender_only tinyint(1) NOT NULL default ’0′,

    unread_count int(10) NOT NULL default ’0′,

    is_deleted tinyint(1) NOT NULL default ’0′,

    PRIMARY KEY (id),

    KEY user_id (user_id),

    KEY thread_id (thread_id),

    KEY is_deleted (is_deleted),

    KEY sender_only (sender_only),

    KEY unread_count (unread_count)

    ) TYPE=MyISAM ;

    CREATE TABLE wp_bp_messages_threads (

    id int(11) NOT NULL auto_increment,

    message_ids longtext NOT NULL,

    sender_ids longtext NOT NULL,

    first_post_date datetime NOT NULL,

    last_post_date datetime NOT NULL,

    last_message_id int(11) NOT NULL,

    last_sender_id int(11) NOT NULL,

    PRIMARY KEY (id),

    KEY last_message_id (last_message_id),

    KEY last_sender_id (last_sender_id)

    ) TYPE=MyISAM ;

    CREATE TABLE wp_bp_notifications (

    id int(11) NOT NULL auto_increment,

    user_id int(11) NOT NULL,

    item_id int(11) NOT NULL,

    secondary_item_id int(11) default NULL,

    component_name varchar(75) NOT NULL,

    component_action varchar(75) NOT NULL,

    date_notified datetime NOT NULL,

    is_new tinyint(1) NOT NULL,

    PRIMARY KEY (id),

    KEY item_id (item_id),

    KEY secondary_item_id (secondary_item_id),

    KEY user_id (user_id),

    KEY is_new (is_new),

    KEY component_name (component_name),

    KEY component_action (component_action)

    ) TYPE=MyISAM ;

    CREATE TABLE wp_bp_user_blogs (

    id int(11) NOT NULL auto_increment,

    user_id int(11) NOT NULL,

    blog_id int(11) NOT NULL,

    PRIMARY KEY (id),

    KEY user_id (user_id),

    KEY blog_id (blog_id)

    ) TYPE=MyISAM ;

    CREATE TABLE wp_bp_user_blogs_blogmeta (

    id int(11) NOT NULL auto_increment,

    blog_id int(11) NOT NULL,

    meta_key varchar(255) default NULL,

    meta_value longtext,

    PRIMARY KEY (id),

    KEY blog_id (blog_id),

    KEY meta_key (meta_key)

    ) TYPE=MyISAM ;

    CREATE TABLE wp_bp_user_blogs_comments (

    id int(11) NOT NULL auto_increment,

    user_id int(11) NOT NULL,

    blog_id int(11) NOT NULL,

    comment_id int(11) NOT NULL,

    comment_post_id int(11) NOT NULL,

    date_created datetime NOT NULL,

    PRIMARY KEY (id),

    KEY user_id (user_id),

    KEY blog_id (blog_id),

    KEY comment_id (comment_id),

    KEY comment_post_id (comment_post_id)

    ) TYPE=MyISAM ;

    CREATE TABLE wp_bp_user_blogs_posts (

    id int(11) NOT NULL auto_increment,

    user_id int(11) NOT NULL,

    blog_id int(11) NOT NULL,

    post_id int(11) NOT NULL,

    date_created datetime NOT NULL,

    PRIMARY KEY (id),

    KEY user_id (user_id),

    KEY blog_id (blog_id),

    KEY post_id (post_id)

    ) TYPE=MyISAM ;

    CREATE TABLE wp_bp_xprofile_data (

    id int(11) unsigned NOT NULL auto_increment,

    field_id int(11) unsigned NOT NULL,

    user_id int(11) unsigned NOT NULL,

    value longtext NOT NULL,

    last_updated datetime NOT NULL,

    PRIMARY KEY (id),

    KEY field_id (field_id),

    KEY user_id (user_id)

    ) TYPE=MyISAM ;

    CREATE TABLE wp_bp_xprofile_fields (

    id int(11) unsigned NOT NULL auto_increment,

    group_id int(11) unsigned NOT NULL,

    parent_id int(11) unsigned NOT NULL,

    type varchar(150) NOT NULL,

    name varchar(150) NOT NULL,

    description longtext NOT NULL,

    is_required tinyint(1) NOT NULL default ’0′,

    is_default_option tinyint(1) NOT NULL default ’0′,

    field_order int(11) NOT NULL default ’0′,

    option_order int(11) NOT NULL default ’0′,

    order_by varchar(15) NOT NULL,

    is_public int(2) NOT NULL default ’1′,

    can_delete tinyint(1) NOT NULL default ’1′,

    PRIMARY KEY (id),

    KEY group_id (group_id),

    KEY parent_id (parent_id),

    KEY is_public (is_public),

    KEY can_delete (can_delete),

    KEY is_required (is_required)

    ) TYPE=MyISAM ;

    CREATE TABLE wp_bp_xprofile_groups (

    id int(11) unsigned NOT NULL auto_increment,

    name varchar(150) NOT NULL,

    description mediumtext NOT NULL,

    can_delete tinyint(1) NOT NULL,

    PRIMARY KEY (id),

    KEY can_delete (can_delete)

    ) TYPE=MyISAM ;

    CREATE TABLE wp_bp_xprofile_wire (

    id int(11) NOT NULL auto_increment,

    item_id int(11) NOT NULL,

    user_id int(11) NOT NULL,

    content longtext NOT NULL,

    date_posted datetime NOT NULL,

    PRIMARY KEY (id),

    KEY item_id (item_id),

    KEY user_id (user_id)

    ) TYPE=MyISAM ;

    7) Replace site name and site description and insert to database:

    INSERT INTO wp_bp_user_blogs VALUES (1, 1, 1);

    INSERT INTO wp_bp_user_blogs_blogmeta VALUES (1, 1, ‘name’, ‘site Name’);

    INSERT INTO wp_bp_user_blogs_blogmeta VALUES (2, 1, ‘description’, ‘Site Description’);

    INSERT INTO wp_bp_user_blogs_blogmeta VALUES (3, 1, ‘last_activity’, ’1′);

    INSERT INTO wp_bp_xprofile_fields VALUES (1, 1, 0, ‘textbox’, ‘Full Name’, ”, 1, 0, 1, 0, ”, 1, 0);

    INSERT INTO wp_bp_xprofile_groups VALUES (1, ‘Base’, ”, 0);

    8) Upload BuddyPress and install it.

    Now you can create profiles & groups.

Viewing 5 replies - 1 through 5 (of 5 total)
  • Avatar of Burt Adsit
    Burt Adsit
    Participant

    @burtadsit

    Well, well. Maybe we’re getting somewhere trying to understand why 1and1 doesn’t work well with bp. Thanks for this.

    hello, im pretty new at setting up tables.

    how do you set up the KEY part of the table. is there a radio button that select like a PRIMARY KEY for me to make the field a KEY?

    please help.

    Avatar of Jeff Sayre
    Jeff Sayre
    Participant

    @jeffsayre

    You have got to be kidding!

    I’d recommend switching hosts.

    i figured it out.

    in PHPAdmin go the the database for your wpmu then go the the SQL tab, then copy and paste the code above to the ‘Run SQL query/queries on database’ then click on ‘Go’ button.

    i can now edit profile field setup.

    Avatar of Yfm1017
    yfm1017
    Participant

    @yfm1017

    Thank you! Thank you! This is SOOO helpful!

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

You must be logged in to reply to this topic.