Skip to:
Content
Pages
Categories
Search
Top
Bottom

How to fix database


  • 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


    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.

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

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


    Geordee
    Participant

    @geordee

    I had problems before. My earlier post was on one such problem https://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.

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


    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


    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.
Skip to toolbar