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)
  • Profile photo 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.

    Profile photo of Patchdoo
    patchdoo
    Member

    @patchdoo

    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.

    Profile photo of Jeff Sayre
    Jeff Sayre
    Participant

    @jeffsayre

    You have got to be kidding!

    I’d recommend switching hosts.

    Profile photo of Patchdoo
    patchdoo
    Member

    @patchdoo

    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.

    Profile photo of Yfm1017
    yfm1017
    Participant

    @yfm1017

    Thank you! Thank you! This is SOOO helpful!

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘1 and 1 server, Mysql 4, PHP 4, BuddyPress installation’ is closed to new replies.
Skip to toolbar