[wp-trac] [WordPress Trac] #43162: Deleting a site from a multisite network leaves orphaned database tables and files

[WordPress Trac]

#43162: Deleting a site from a multisite network leaves orphaned database tables
and files
-------------------------------------------------+-------------------------
 Reporter:  bluep92877                           |       Owner:  (none)
     Type:  enhancement                          |      Status:  new
 Priority:  normal                               |   Milestone:  Future
                                                 |  Release
Component:  Networks and Sites                   |     Version:  3.0
 Severity:  normal                               |  Resolution:
 Keywords:  has-patch changes-requested needs-   |     Focuses:  multisite
  refresh                                        |
-------------------------------------------------+-------------------------
Changes (by johnjamesjacoby):

 * keywords:  has-patch changes-requested => has-patch changes-requested
     needs-refresh


Comment:

 > Could you please make the table selection query filterable? There is no
 information_scheme table in sqlite. So the hard coded MySQL based query
 would break WP on any db where the information_scheme table does not exist
 for whatever reasons.

 This is an excellent point, and a filter does seem appropriate.

 WordPress core already uses `information_schema` in
 `WP_Site_Health::should_suggest_persistent_object_cache()`. The query
 there isn't filterable, but the method can be short-circuited via the
 `site_status_should_suggest_persistent_object_cache` filter.

-- 
Ticket URL: <https://core.trac.wordpress.org/ticket/43162#comment:35>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform