Re: Error when trying to create a group
Is this creating the problem: “DEFAULT CHARACTER SET utf8” ??
From the Apache error log, this is the same syntax error I saw earlier when BP was trying to create tables (see earlier posts):
[suexec 11180] Chdir to /kunden/homepages/14/d123456789/htdocs/exploreouroceans
[suexec 11180] Executing PHP4 /usr/lib/cgi-bin/php4 /kunden/homepages/14/d123456789/htdocs/exploreouroceans/index.php
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 14 for query CREATE TABLE wp_user_3_activity (
id int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
item_id int(11) NOT NULL,
secondary_item_id int(11),
user_id int(11) NOT NULL,
component_name varchar(75) NOT NULL,
component_action varchar(75) NOT NULL,
date_recorded datetime NOT NULL,
is_private tinyint(1) NOT NULL,
KEY item_id (item_id),
KEY user_id (user_id),
KEY is_private (is_private),
KEY component_name (component_name)
) DEFAULT CHARACTER SET utf8; made by dbdelta
