BuddyPress.org

Enjoying your shared hosting experience yet?

You’re kidding? No you’re not kidding. Well let me be the first to welcome you to the ranks of the Revolution. You didn’t know we were starting a Revolution? I’ll send you a copy of the memo.

Congratulations!

1and1 just notified me that they’re redirecting Apache error logging to a file I can access. I went to the back site admin area, which is supposed to trigger the creation of the BP tables. Some of the log corresponding to that looks like what I’ve pasted below. Not sure if the SQL syntax error is causing all the trouble. Please let me know what else you need. Again, thanks.

exec 11368] Executing PHP5 /usr/lib/cgi-bin/php5 /kunden/homepages/14/d123456789/htdocs/exploreouroceans/index.php

WordPress database error Table ‘db270846977.wp_bp_xprofile_data’ doesn’t exist for query SELECT d.value, f.name FROM wp_bp_xprofile_data d, wp_bp_xprofile_fields f WHERE d.field_id = f.id AND d.user_id = 1 AND f.parent_id = 0 AND f.name = ‘Full Name’ made by get_value_byfieldname

WordPress database error Table ‘db270846977.wp_bp_xprofile_data’ doesn’t exist for query SELECT d.value, f.name FROM wp_bp_xprofile_data d, wp_bp_xprofile_fields f WHERE d.field_id = f.id AND d.user_id = 0 AND f.parent_id = 0 AND f.name = ‘Full Name’ made by get_value_byfieldname

WordPress database error You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ‘DEFAULT CHARACTER SET utf8’ at line 17 for query CREATE TABLE wp_bp_activity_sitewide (

id int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,

user_id int(11) NOT NULL,

item_id int(11) NOT NULL,

secondary_item_id int(11),

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,

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)

) DEFAULT CHARACTER SET utf8; made by dbDelta

WordPress database error You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ‘DEFAULT CHARACTER SET ‘utf8” at line 1 for query ALTER TABLE wp_bp_activity_sitewide DEFAULT CHARACTER SET ‘utf8’ made by bp_activity_sitewide_install

Here’s another snippet. This is the first error log entry that appears after invoking BP:

[suexec 11345] kundenfile = 1, mustkundenfile = 1, file = /kunden/homepages/14/d123456789/htdocs/exploreouroceans/index.php, cgifeature = 350

[suexec 11345] Chdir to /kunden/homepages/14/d123456789/htdocs/exploreouroceans

[suexec 11345] Executing PHP5 /usr/lib/cgi-bin/php5 /kunden/homepages/14/d123456789/htdocs/exploreouroceans/index.php

WordPress database error Table ‘db270846977.wp_bp_xprofile_data’ doesn’t exist for query SELECT d.value, f.name FROM wp_bp_xprofile_data d, wp_bp_xprofile_fields f WHERE d.field_id = f.id AND d.user_id = 0 AND f.parent_id = 0 AND f.name = ‘Full Name’ made by get_value_byfieldname

WordPress database error Table ‘db270846977.wp_bp_xprofile_data’ doesn’t exist for query SELECT d.value, f.name FROM wp_bp_xprofile_data d, wp_bp_xprofile_fields f WHERE d.field_id = f.id AND d.user_id = 0 AND f.parent_id = 0 AND f.name = ‘Full Name’ made by get_value_byfieldname

WordPress database error Table ‘db270846977.wp_bp_messages_recipients’ doesn’t exist for query SELECT unread_count FROM wp_bp_messages_recipients WHERE user_id = 0 AND is_deleted = 0 made by get_inbox_count

WordPress database error Table ‘db270846977.wp_bp_messages_recipients’ doesn’t exist for query SELECT unread_count FROM wp_bp_messages_recipients WHERE user_id = 0 AND is_deleted = 0 made by get_inbox_count

WordPress database error Table ‘db270846977.wp_bp_groups’ doesn’t exist for query SELECT id FROM wp_bp_groups WHERE slug = ‘public’ made by group_exists

WordPress database error Table ‘db270846977.wp_bp_groups_groupmeta’ doesn’t exist for query SELECT gm.group_id FROM wp_bp_groups_groupmeta gm, wp_bp_groups g WHERE g.id = gm.group_id AND g.status != ‘hidden’ AND gm.meta_key = ‘total_member_count’ ORDER BY CONVERT(gm.meta_value, SIGNED) DESC made by get_popular

[Sat Dec 27 13:46:21 2008] [warn] (2)No such file or directory: mod_mime: analyze_ct: cannot get media type from ‘x-mapp-php5’

[Sat Dec 27 13:46:21 2008] [warn] mod_mime: analyze_ct: cannot get media type from ‘x-mapp-php5’

[suexec 11347] started: /usr/lib/apache-ssl/suexec dummywwwexecuser ftpusers php5exe

[suexec 11347] REDIRECT_STATUS: 200

[suexec 11347] doing chroot

Can you tell I’m desperate?

Correct (1and1 logs) and correct (no tables). That’s been the issue for me…BP isn’t creating the tables automatically. I just created the 4 group tables manually, then reran BP and it seems to work fine (hopefully no gotchas with the other tables that must be created by hand). I’m fine with this workaround if it’s safe for now as it lets me move ahead, but it’s still a mystery why BP isn’t able to create the tables automatically.

If that’s the case then, if I were you, I’d wipe the db on 1and1 clean and do a complete re-install of mu and bp. It might be the easiest way to do things. If things are out of sync then neither you nor I know how to manually edit them back into sync.

I don’t doubt that it’s possible, just why bother?

Depending on how old you are, that obscure reference to Lost In Space, may or may not mean something to you.

lol. We don’t want this to degenerate into a digression on who I thought was hotter. Penny or Judy? No, no. Just stop this right now. Stop it. Just stop it.

Looking at your js being sent on the other thread.

Is mu running in a subdir under the doc root here also? Those meta keys are from the just recently installed bp right? No error msgs in the error log after bp install?

Does mu seem happy living in a subdir on 1and1? You can create new blogs and then access them. Make and edit posts on a blog other than the root blog? Any errors in the error log after bp install and no tables being created?

There should be major whining and complaining in there.

MU seems fine with subdirs on 1and1. The only thing it’s unhappy about are subdomains. (Blogs created with subdomains yield 404s.) I’ve installed it both ways to see if that changed anything with creating the tables, but alas, no.

I’ve included some of the relevant portions of my Apache log earlier in this thread, but perhaps I’m missing something?

The error logs I was referring to were those directly after your recent install of bp on 1and1. bp will try and create the tables. If it can’t there will be some evidence of it in the error logs. Perhaps why also.