id summary reporter owner description type status priority milestone component version severity resolution keywords cc focuses 38856 Backward compat consideration for wp_blogs.archived stephdau jeremyfelt "The `archived` column in `wp_blogs` used to be of the `enum` data type, but was switched to `tinyint` 3 years ago, in r25448. Some older instances might not have migrated to the newer data type (`ALTER`s on large tables isn't fun). In `class-wp-site-query.php`, we use `$wpdb->prepare( ""archived = %d "", $archived );`, which translates to `archived = 0|1`. Tis works great with `tinyint`, but fails with the older `enum` type, as it expects the value to be single quoted. Since `archived = '0|1'` works with both data types, @jeremyfelt suggested we move the `prepare()` statement to using `%s` and `absint()` instead: https://wordpress.slack.com/archives/core-multisite/p1479504691000517 " enhancement closed normal 4.9 Networks and Sites 4.7 normal fixed has-patch multisite