Support » Plugin: Code Snippets » Multisite install broken

  • Resolved Jacob Peattie

    (@jakept)


    The latest update has broken the ability to create snippets in a multisite install. In the error log the following error appears:

    [04-Feb-2020 05:04:19 UTC] WordPress database error Unknown column 'modified' in 'field list' for query INSERT INTOwp_ms_snippets(name,description,code,tags,scope,priority,active,modified) VALUES ('REDACTED', '', 'REDACTED', '', 'global', '10', '0', '2020-02-04 05:04:19') made by require_once('wp-admin/admin.php'), do_action('load-snippets_page_add-snippet'), WP_Hook->do_action, WP_Hook->apply_filters, Code_Snippets_Edit_Menu->load, Code_Snippets_Edit_Menu->process_actions, Code_Snippets_Edit_Menu->save_posted_snippet, save_snippet
    

    The upgrade routine did not appear to add the new modified column to the multisite table. The site-specific tables appear to have the column.

Viewing 3 replies - 1 through 3 (of 3 total)
  • Thread Starter Jacob Peattie

    (@jakept)

    For now I’ve gotten around the issue by manually creating the column.

    Guessing I’m running in to the same problem. I get the error “An error occurred when saving the snippet.” Only happens if I try to activate the snippet for the network in multisite install. The same snippet will save and work just fine if I activate it for an individual site within the multisite.

    Thread Starter Jacob Peattie

    (@jakept)

    Yeah, that’s exactly the error I was receiving. I fixed it using this query in PHPMyAdmin:

    ALTER TABLE wp_ms_snippets ADD modified DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00'
    

    Just replace wp_ with whatever your database prefix is, if it’s something different.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Multisite install broken’ is closed to new replies.