Title: Multisite install broken
Last modified: February 4, 2020

---

# Multisite install broken

 *  Resolved [Jacob Peattie](https://wordpress.org/support/users/jakept/)
 * (@jakept)
 * [6 years, 4 months ago](https://wordpress.org/support/topic/multisite-install-broken/)
 * 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.
    -  This topic was modified 6 years, 4 months ago by [Jacob Peattie](https://wordpress.org/support/users/jakept/).
    -  This topic was modified 6 years, 4 months ago by [Jacob Peattie](https://wordpress.org/support/users/jakept/).

Viewing 3 replies - 1 through 3 (of 3 total)

 *  Thread Starter [Jacob Peattie](https://wordpress.org/support/users/jakept/)
 * (@jakept)
 * [6 years, 4 months ago](https://wordpress.org/support/topic/multisite-install-broken/#post-12396055)
 * For now I’ve gotten around the issue by manually creating the column.
 *  [klishb](https://wordpress.org/support/users/klishb/)
 * (@klishb)
 * [6 years, 4 months ago](https://wordpress.org/support/topic/multisite-install-broken/#post-12400063)
 * 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](https://wordpress.org/support/users/jakept/)
 * (@jakept)
 * [6 years, 4 months ago](https://wordpress.org/support/topic/multisite-install-broken/#post-12400084)
 * 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.

 * ![](https://ps.w.org/code-snippets/assets/icon.svg?rev=2148878)
 * [Code Snippets](https://wordpress.org/plugins/code-snippets/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/code-snippets/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/code-snippets/)
 * [Active Topics](https://wordpress.org/support/plugin/code-snippets/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/code-snippets/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/code-snippets/reviews/)

 * 3 replies
 * 2 participants
 * Last reply from: [Jacob Peattie](https://wordpress.org/support/users/jakept/)
 * Last activity: [6 years, 4 months ago](https://wordpress.org/support/topic/multisite-install-broken/#post-12400084)
 * Status: resolved