Skip to:
Content
Pages
Categories
Search
Top
Bottom

How to fix database

  • @geordee

    Participant

    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)
  • @trent

    Participant

    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

    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.

    @apeatling

    Keymaster

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

    @apeatling

    Keymaster

    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

    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.

    @apeatling

    Keymaster

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

    @famous

    Participant

    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

    @trent

    Participant

    @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

    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