WordPress.org

Ready to get started?Download WordPress

Forums

SharDB
dbDelta - will it work? (6 posts)

  1. meglio
    Member
    Posted 1 year 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 1 year 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 1 year 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 1 year 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 1 year ago #

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

  6. Ron Rennick
    MultiSite Guru
    Plugin Author

    Posted 1 year 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/

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic

Tags