The MU forums have moved to WordPress.org

How to update plugins by SQL ? (6 posts)

  1. reboltutorial
    Member
    Posted 14 years ago #

    I see this is wp_meta update_plugins

    O:8:"stdClass":3:{s:12:"last_checked";i:1257629905;s:7:"checked";a:3:{s:52:"one-click-plugin-updater/oneclick-plugin-updater.php";s:6:"2.4.14";s:43:"wordpress-admin-bar/wordpress-admin-bar.php";s:5:"3.1.6";s:29:"wp-dbmanager/wp-dbmanager.php";s:4:"2.50";}s:8:"response";a:0:{}}

    Is this field that stores the state of a plugin ?
    What's above mean, where is the documentation ?

    Thanks.

  2. andrea_r
    Moderator
    Posted 14 years ago #

    Yeah, it stores the state of if it was checked, when it was last checked and the response.

    It does not actually change the plugin. If you change values in the db to mark it as updated it does absolutely nothing to the plugin files themselves.

    If the backend plugin updater is not working, update them manually. Via ftp.

  3. reboltutorial
    Member
    Posted 14 years ago #

    Oops I made a mistake in my question: I meant how to make a plugin ACTIVE rather than update it :)

  4. andrea_r
    Moderator
    Posted 14 years ago #

    If you want it active on new blogs, either use the "Activate sitewide" button or the Plugin Manager plugin.

  5. DeannaS
    Member
    Posted 14 years ago #

    The activated plugins are stored in the options tables of each blog. The meta_key is called, strangely enough, "active_plugins". The data looks something like this:

    a:2:{i:0;s:35:"cets_fyi_banner/cets_fyi_banner.php";i:1;s:19:"cets_fyi_footer.php";}

    In this case, it means - here is an array, with 2 items in it. Item 0 is a string, 35 characters long, and the plugin file is "cets_fyi_banner/cets_fyi_banner.php..etc..

  6. reboltutorial
    Member
    Posted 14 years ago #

    @DeannaS hi thanks, that's what I wanted.

About this Topic

  • Started 14 years ago by reboltutorial
  • Latest reply from reboltutorial