Skip to:
Content
Pages
Categories
Search
Top
Bottom

How to fix database

  • Avatar of Geordee
    Geordee
    Participant

    @geordee

    I started with beta 1 and now with beta 2. I feel due to various bugs, the database is not very consistent. I’m running a network now and there is no way I can restart the whole thing. I wonder how to ensure consistency between different entities/tables. I have a feeling that the problems are with wp_bp_ tables, so it should not be a huge effort though. If I develop some scripts I will let you know. Right now I am fixing things on a case-to-case basis.

Viewing 9 replies - 1 through 9 (of 9 total)
  • If you visit the main WPMU blog dashboard as site-admin, it will run the upgrade check on your buddypress plugins. It should update them that way (at least it is supposed to).

    Trent

    Avatar of Geordee
    Geordee
    Participant

    @geordee

    That’s for the blogs. I face with problems such as Buddypress says there are notifications or messages for a user, and when I click on links such as Notifications or My Account > Messages > Inbox there is nothing out there. Then I need to go to PHPMyAdmin, find out which entry is causing the problem and delete it. This does not happen with every users. Just some users, and fixing it on a case-to-case basis is tough. There should be some way to figure out and entry in this table means an entry in another table, which will then ensure consistency across tables.

    Avatar of Andy Peatling
    Andy Peatling
    Keymaster

    @apeatling

    There have not been any major DB changes since beta 1. Your DB should have no problem upgrading unless you had problems before?

    Avatar of Andy Peatling
    Andy Peatling
    Keymaster

    @apeatling

    The unread message count is stored for each recipient of a thread for quick access. I seem to remember that you ran into the truncation bug in the previous beta that would be causing this.

    The quickest way is to zero out the “unread_count” field in “wp_bp_messages_recipients”.

    Avatar of Geordee
    Geordee
    Participant

    @geordee

    I had problems before. My earlier post was on one such problem http://buddypress.org/forums/topic.php?id=1019, which I worked around by fixing the db.

    My concern is that there could be many more such db issues (which I did not expect when I rolled out Buddypress), and these need to be fixed. I should not wait until the users come back and tell me they’ve got problems.

    Avatar of Andy Peatling
    Andy Peatling
    Keymaster

    @apeatling

    Remember, this is still in beta. It is not recommended for use on a production installation.

    Avatar of Famous
    Famous
    Participant

    @famous

    I had a question is there a way to check if I am missing a table, because the member search will not work? The blog search and the group search work just fine, however I cannot find members? My limited guess is that the table is missing. What is the name of the table and what can I do? Thanks

    @famous are you using hyperdb or multi-database from incsub? That seemed to screw up the member search for me. You should have a bunch of errors in your apache log about not finding the correct database when you attempt to search if you are using that.

    Trent

    Avatar of Geordee
    Geordee
    Participant

    @geordee

    In my opinion, in the brave new collaborative world, the traditional definition of beta is a little blurred. Where the users are actually developers and developers are users, betas will get to “near-production” environment. By the way, the social network I mentioned itself is in beta!

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

The topic ‘How to fix database’ is closed to new replies.