Skip to:
Content
Pages
Categories
Search
Top
Bottom

Error when trying to create a group

  • Avatar of Zenseeker
    zenseeker
    Participant

    @zenseeker

    Posted this over at testbp.com, but perhaps should have put it here.

    I just upgraded to trunk-r640 this morning and I’m getting this error making a group: “There was an error saving group details. Please try again.” My bp-groups folder permissions is set to 755 and bp-groups.php is set to 644. Files inside of bp-groups are at 644. Any help or suggestions would be most appreciated. Thanks.

Viewing 25 replies - 26 through 50 (of 68 total)
  • Avatar of Oceandoctor
    oceandoctor
    Member

    @oceandoctor

    Not sure if this is helpful, but I installed WPMU on 1and1 specifying subdomains. As reported by others, it doesn’t work — 404s when trying to call up blogs created on subdomains. I installed BP anyway just to see if the databases would get created. They didn’t. Still awaiting Apache error logs promised by tech support.

    Avatar of Burt Adsit
    Burt Adsit
    Participant

    @burtadsit

    Enjoying your shared hosting experience yet?

    Avatar of Oceandoctor
    oceandoctor
    Member

    @oceandoctor

    Hah. The irony is that I have a dedicated (managed) server on 1and1, but everything works like a charm on BlueHost where I have the cheapest shared hosting plan!

    Avatar of Burt Adsit
    Burt Adsit
    Participant

    @burtadsit

    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!

    Avatar of Oceandoctor
    oceandoctor
    Member

    @oceandoctor

    I’m in.

    Avatar of Oceandoctor
    oceandoctor
    Member

    @oceandoctor

    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

    Avatar of Oceandoctor
    oceandoctor
    Member

    @oceandoctor

    …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.

    Avatar of Oceandoctor
    oceandoctor
    Member

    @oceandoctor

    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? :)

    Avatar of Burt Adsit
    Burt Adsit
    Participant

    @burtadsit

    These problems and error logs are from your 1and1 install, not the bluehost install right? Any problems on bluehost? Those error logs say that there isn’t any bp tables in the database that mu is hooked up to. From your earlier posts, specifically the one where you list all the tables in the mu db, you don’t have any bp tables.

    Hang on a sec lemme look at something…

    Avatar of Oceandoctor
    oceandoctor
    Member

    @oceandoctor

    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.

    Avatar of Burt Adsit
    Burt Adsit
    Participant

    @burtadsit

    I was thinking that if there was a problem initially on 1and1 creating tables, for whatever reason, and bp *thinks* they are there then it might not try to recreate them again.

    bp writes some stuff in the wp_sitemeta table. Versions of each installed component. I don’t know if that is how bp decides if a component is installed or not. I’m guessing, there I go again, that it is how bp decides to create or update a table structure for a component.

    Go get the ver number and do/not do something. These key/value pairs in the site meta table are bp-componentname-somethingelse. Example: meta_key = ‘bp-groups-version’, meta_value = ’1.0b1′ in the case of the groups component and the first beta.

    If bp finds goodies it likes in wp_sitemeta it happily goes along assuming that tables exist for a component. I don’t know if all the above is true or not. It’s the way I’d design it. We gotta ask Andy if that’s the way things work. Can you look in wp_sitemeta and see if key/value pairs exist for bp components that don’t have tables?

    Avatar of Burt Adsit
    Burt Adsit
    Participant

    @burtadsit

    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?

    Avatar of Burt Adsit
    Burt Adsit
    Participant

    @burtadsit

    Just a sec. Is 1and1 a live site? In that case edit the wp_sitemeta and remove anything that looks like bp-xxx-xxx and any tables you manually created.

    CAUTION. WARNING.

    Danger Will Robinson.

    Avatar of Burt Adsit
    Burt Adsit
    Participant

    @burtadsit

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

    Avatar of Oceandoctor
    oceandoctor
    Member

    @oceandoctor

    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. :)

    Avatar of Burt Adsit
    Burt Adsit
    Participant

    @burtadsit

    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.

    Avatar of Oceandoctor
    oceandoctor
    Member

    @oceandoctor

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

    Avatar of Burt Adsit
    Burt Adsit
    Participant

    @burtadsit

    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?

    Avatar of Oceandoctor
    oceandoctor
    Member

    @oceandoctor

    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.

    Avatar of Burt Adsit
    Burt Adsit
    Participant

    @burtadsit

    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.

    Avatar of Burt Adsit
    Burt Adsit
    Participant

    @burtadsit

    I’m gonna have to get back to you later with the two issues you have. I have to do 6 hrs of work on my site and theme before tomorrow morn.

    Avatar of Oceandoctor
    oceandoctor
    Member

    @oceandoctor

    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?

    Avatar of Oceandoctor
    oceandoctor
    Member

    @oceandoctor

    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.

    Avatar of Burt Adsit
    Burt Adsit
    Participant

    @burtadsit

    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.

    Avatar of Andy Peatling
    Andy Peatling
    Keymaster

    @apeatling

    Are you logging into the admin area as a site admin? The tables will only be created if you are a site admin and logged into the admin area.

Viewing 25 replies - 26 through 50 (of 68 total)

You must be logged in to reply to this topic.