[@oceandoctor Member 15 years, 12 months ago]

I’m experiencing the same problem. In addition, the align formatting doesn’t work, so no matter whether I specify left, right, etc., I get default.

[@oceandoctor Member 16 years ago]

I can confirm that globally changing “DEFAULT CHARACTER SET” to “CHARACTER SET” in all bp code prior to installation appears to solve the problem. All databases are created successfully and automatically once I enter the back-end admin area as admin. Everything seems to work based on a quick shakedown. There seems to be hope. But do tell, what does it all mean? And are there any adverse consequences of my desperate code fiddling?

[@oceandoctor Member 16 years ago]

I do think we’ve zeroed in on the problem. In phpMyAdmin, this (which resembles the syntax that BP is creating) results in the syntax error that follows:

CREATE TABLE testme (

field1 int(11) ,

field2 varchar(100) NOT NULL

) DEFAULT CHARACTER SET utf8

#1064 – 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 4

The following works, however (removing the word “DEFAULT” from the last line):

CREATE TABLE testme (

field1 int(11) ,

field2 varchar(100) NOT NULL

) CHARACTER SET utf8

If I type in “DEFAULT CHARACTER SET utf8” or “DEFAULT CHARACTER SET latin1” or anything with the word “DEFAULT,” I get the syntax error. I’m running MySQL 5.0.32 and PHP 4.4.9

As a temporary workaround, what if I simply nuked the word “DEFAULT” from the code for now? Reckless?

[@oceandoctor Member 16 years ago]

Ran it in phpMyAdmin. Worked just fine.

[@oceandoctor Member 16 years ago]

I’m using wordpress-mu-2.6.5 and bp combo beta. No other plug-ins, etc.

[@oceandoctor Member 16 years ago]

Thanks for your reply. I’ve never had to fiddle with mysql user permissions with other WP databases — where is this done? I tried entering, “DEFAULT CHARACTER SET utf8” (sans quotes) manually via phpMyAdmin and received the same syntax error message. Is this a clue or a rabbit hole?

[@oceandoctor Member 16 years ago]

Permissions look OK. To be clear, the problem is that the image appears but the cropper doesn’t display.

[@oceandoctor Member 16 years ago]

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

[@oceandoctor Member 16 years ago]

Yes, I’m definitely logging into the admin area as site admin. I’ve tried just about everything, but the only solution has been for me to pre-create the tables “manually”…BP just won’t do it no matter what I try.

@burtadsit I’m poring through log file now, but I had already posted (earlier in this thread) what appeared to be the relevant portions of the log when invoking BP to create tables, etc. I’ll keep looking, but nothing’s jumped out — first sign of trouble is when it can’t find the tables during operations subsequent to when they’re supposed to have been created.

[@oceandoctor Member 16 years ago]

Update: After a fresh install of WPMU, I “manually” pre-created the wp_bp_* tables before installing and running BP. Almost everything, including groups, works fine, with one exception: While new users can sign up and have a blog created without a problem, if they (or the admin for that matter) tries to create a second blog (e.g., My Blogs > Create a Blog!), it appears to work, but trying to access the newly-minted blog yields, “The blog you have requested is not installed properly. Please contact the system administrator.” (Remember that WPMU was installed using subdirectories since I can’t get subdomains to work on 1and1.) Thanks.

[@oceandoctor Member 16 years ago]

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?

[@oceandoctor Member 16 years ago]

Yes…mu is installed in a subdir under the doc root. Right…those meta keys are from the fresh install. For “fun” I deleted one of the fields (bp-groups-version) from the wp_sitemeta table, then clicked around in the back-end admin area. The field then reappears in wp_sitemeta, but no wp_bp_* tables ever appear.

[@oceandoctor Member 16 years ago]

Yes…it’s installed under a subdirectory as you specified.

[@oceandoctor Member 16 years ago]

I saw earlier posts about using large images, so I’ve tried everything from 450×450 to 125×125. Largest file < 100kb.

[@oceandoctor Member 16 years ago]

lol! OK, I just did a clean install (1and1). Same symptom…tables not created. Here are the relevant fields from wp_sitemeta:

bp-activity-version 1.0b1

bp-core-version 1.0b1

bp-xprofile-base-group-name Base

bp-xprofile-fullname-field-name Full Name

bp-xprofile-fullname-conversion 1

bp-xprofile-version 1.0b1

bp-messages-version 1.0b1

bp-groups-version 1.0b1

bp-friends-version 1.0b1

bp-blogs-first-install 1

bp-blogs-version 1.0b1

P.S. Actually I liked the lady floating in space with the bowl on her head. I have exotic tastes.

[@oceandoctor Member 16 years ago]

Are there javascript libs being sent to the browser?

In the viewed source for the avatar crop page you should have bunches of js libs being sent to your browser. Including a line something like this:

<script type=’text/javascript’ src= …[snip]… /wp-includes/js/crop/cropper.js …[snip]

Here’s what I see:

<script type=’text/javascript’ src=…[snip]…/wp-includes/js/prototype.js?ver=1.6′[snip]

<script type=’text/javascript’ src=…[snip]…/wp-includes/js/jquery/jquery.js?ver=1.2.6′[snip]

<script type=’text/javascript’ src=…[snip]…/wp-content/mu-plugins/bp-core/js/jquery/jquery.livequery.pack.js?ver=2.6.5′[snip]

<script type=’text/javascript’ src=…[snip]…/wp-content/mu-plugins/bp-core/js/general.js?ver=2.6.5′[snip]

<script type=’text/javascript’ src=…[snip]…/wp-includes/js/scriptaculous/scriptaculous.js?ver=1.8.0′[snip]

<script type=’text/javascript’ src=…[snip]…/wp-includes/js/scriptaculous/builder.js?ver=1.8.0′[snip]

<script type=’text/javascript’ src=…[snip]…/wp-includes/js/scriptaculous/effects.js?ver=1.8.0′[snip]

<script type=’text/javascript’ src=…[snip]…/wp-includes/js/scriptaculous/dragdrop.js?ver=1.8.0′[snip]

<script type=’text/javascript’ src=…[snip]…/wp-includes/js/crop/cropper.js?ver=20070118′[snip]

Do you have js turned on in your browser?

I do, and I’m getting the same symptom in both Firefox and IE.

One note: This now appears to be only a BlueHost issue. Cropping works fine on 1and1…guess I was mixed up yesterday.

[@oceandoctor Member 16 years ago]

Spare me, you bubble-headed booby. I was born in the Eisenhower Administration. Loved Lost in Space as a kid. OK, OK…still love it. Thanks for your help. The site isn’t live yet so no worries about nuking, renuking, etc.

[@oceandoctor Member 16 years ago]

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.

[@oceandoctor Member 16 years ago]

@burtadsit My symptoms are the same as @st9bp’s, per above:

The image uploads fine.

The actual selector does not appear, nor does the preview image below it.

The image uploads, but you can’t crop it because the selector/overlay tool simply isn’t there. The uploaded avatar will not save, so you end up with a default avatar. This applies to both Group and Member avatars. Thanks.

[@oceandoctor Member 16 years ago]

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?

[@oceandoctor Member 16 years ago]

Thanks for the workaround advice.

I’ve worked to confirm GD2 and ImageMagick:

Running phpinfo on BlueHost shows GD2 installed(2.0.34 compatible)

According to Tech Support, ImageMagick is installed and accessible at /usr/bin. Running version 6.0.7.

Any other possible culprits here?

[@oceandoctor Member 16 years ago]

…lots more where that came from. I don’t have much experience with these logs, so I’d be grateful for your eyes on this. Let me know if you need to see more and the best way of getting it to you. Again, thanks.

[@oceandoctor Member 16 years ago]

Not sure…checking. But this problem is occurring on two fresh beta installations on two separate hosts (one on BlueHost shared server, the other on 1and1 dedicated (managed) server). Is there a short-term workaround, e.g., requiring upload of an image of specific dimensions?

[@oceandoctor Member 16 years ago]

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

[@oceandoctor Member 16 years ago]

I’m having the same issue on a new install of beta. My permissions are correct. Was this resolved?