WordPress.org

Ready to get started?Download WordPress

Forums

SharDB
dbDelta - will it work? (6 posts)

  1. meglio
    Member
    Posted 12 months ago #

    I have noticed there is a problem with dbDelta() mentioned in HyperDB support.

    It was raised one year ago and not solved yet:
    http://wordpress.org/support/topic/dbdelta-issues-w-hyperdb?replies=2

    Will I face the same problem with SharDB?

    Regards,
    Anton

    http://wordpress.org/extend/plugins/shardb/

  2. Ron Rennick
    MultiSite Guru
    Plugin Author

    Posted 12 months ago #

    dbDelta relies on SHOW TABLES; so it will not work with any sharded DB structures. For situations where dbDElta is used you need to write your own scripts to perform the SQL commands on the appropriate databases.

  3. meglio
    Member
    Posted 12 months ago #

    So it means that dbDelta will work well only in situations when additional plugin tables do not depend on blog id - because it will always run on the main database. Right?

  4. Ron Rennick
    MultiSite Guru
    Plugin Author

    Posted 12 months ago #

    because it will always run on the main database. Right?

    You can't rely on the last selected database being the global one.

  5. meglio
    Member
    Posted 12 months ago #

    Do you happen to have any solution that you can share?

  6. Ron Rennick
    MultiSite Guru
    Plugin Author

    Posted 12 months ago #

    Do you happen to have any solution that you can share?

    I did above:

    For situations where dbDelta is used you need to write your own scripts to perform the SQL commands on the appropriate databases.

    For example: http://wpmututorials.com/news/mu-2-9-beta/

Reply

You must log in to post.

About this Plugin

About this Topic

Tags