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

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

royak
Member

@royak

15 years, 2 months ago

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);

Upload BuddyPress and install it.

Now you can create profiles & groups.

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

Burt Adsit
Participant

@burtadsit

15 years, 2 months ago

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

patchdoo
Member

@patchdoo

14 years, 11 months ago

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.

Jeff Sayre
Participant

@jeffsayre

14 years, 11 months ago

You have got to be kidding!

I’d recommend switching hosts.

patchdoo
Member

@patchdoo

14 years, 11 months ago

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.

yfm1017
Participant

@yfm1017

14 years, 11 months ago

Thank you! Thank you! This is SOOO helpful!