BuddyPress.org

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