Skip to:
Content
Pages
Categories
Search
Top
Bottom

Database Error


  • fpats
    Participant

    @fpats

    11 years, 11 months ago

    Hi

    WordPress database error: [Out of memory (Needed 11272160 bytes)]
    SELECT COUNT(DISTINCT m.group_id) FROM wp_bp_groups_members m, wp_bp_groups g WHERE m.group_id = g.id AND m.user_id = 1 AND m.is_confirmed = 1 AND m.is_banned = 0

    This only happens with Buddypress installed, once i remove it the errors disappear.

    Bit of a nightmare, any help appreciated!

Viewing 9 replies - 1 through 9 (of 9 total)

  • fpats
    Participant

    @fpats

    11 years, 11 months ago

    just to add, i’m using latest versions of both WP and BP


    John James Jacoby
    Keymaster

    @johnjamesjacoby

    11 years, 11 months ago

    Like the error message suggests, your server ran out of memory.

    https://codex.buddypress.org/troubleshooting/blank-pages/


    fpats
    Participant

    @fpats

    11 years, 10 months ago

    Hi,
    i’ve spoken to my hosts who’ve increased the memory limit to 256m but nothng’s changed and they’ve shifted the blame to us saying we need to optimize the database. I’ve done that via a plugin and still we’re getting the errors so i’m now totally confused and stressed out. Can’t believe i’m doing this on NYE to be honest but it needs fixing asap.

    Could it be time to change hosts to someone better, are they full of cr @p or is there anything else i can do?

    thanks alot


    Paul Wong-Gibbs
    Keymaster

    @djpaul

    11 years, 10 months ago

    They might be full of crap; who are you using for hosting? Can you share the error message you get after the memory has been switched to 256Mb please?


    fpats
    Participant

    @fpats

    11 years, 10 months ago

    Here’s one of many errors we get, this one is currently showing in the sidebar Groups widget..

    WordPress database error: [Out of memory (Needed 12582880 bytes)]
    SELECT COUNT(DISTINCT g.id) FROM wp_bp_groups g, wp_bp_groups_members gm1, wp_bp_groups_groupmeta gm2 WHERE g.id = gm1.group_id AND g.id = gm2.group_id AND gm2.meta_key = ‘last_activity’

    With VPS.net


    @mercime
    Participant

    @mercime

    11 years, 10 months ago

    Please change to BP Default theme and deactivate all plugins except BuddyPress and check if issues are corrected.


    fpats
    Participant

    @fpats

    11 years, 10 months ago

    Done that already, the errors only occur when Buddypress is installed.


    @mercime
    Participant

    @mercime

    11 years, 10 months ago

    Site URI?


    fpats
    Participant

    @fpats

    11 years, 10 months ago

    I’d pm it to you but there’s no option for messaging on here is there?

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘Database Error’ is closed to new replies.

Topic Info

Skip to toolbar