ticket Milestone type summary workflow component version severity priority modified _description 40538 Future accepted task (blessed) Fix or remove useless PHPUnit tests has-patch Build/Test Tools normal normal 2022-09-01T22:54:20Z "There are 29 tests in the test suite which don't perform an assertion. They should be fixed or removed. PHPUnit 6 has switched to being strict about useless tests by default, so that gives us an additional reason to address them. In addition, there's no reason for core's default PHPUnit configuration to not be strict about useless tests so the same behaviour is seen when running older versions of PHPUnit. Previously: #36016" 9257 Awaiting Review assigned enhancement EXIF GPS data dev-feedback Media 2.7 normal normal 2024-03-06T16:33:55Z "Attached patch adds GPS longitude and latitude to image meta data. Changed: wp_read_image_metadata function (file: wp-admin/includes/image.php). It complies with exif standard: [http://www.exif.org/Exif2-2.PDF] (page 46) Commented on wp-hackers list: [http://comox.textdrive.com/pipermail/wp-hackers/2009-March/025093.html]" 45359 Awaiting Review new enhancement Add checkbox to enable or disable sending out emails on password changes from backend 2nd-opinion Users 4.9.8 normal normal 2023-01-21T13:14:12Z "Could we please add a checkbox on the user backend, that will toggle the sending of emails when something is changed in the backend, eg. and most important, the password? It is a huge mistake trigger when developing sites or debugging staging/live sites with users or customers. A little checkbox below the password field to stop WP from sending out a notification would be so great!" 42883 Future new enhancement Use sargable queries for date-based lookups for posts dev-feedback Query 3.7 normal normal 2022-06-14T11:57:10Z "Related to #41054 but a very specific and actionable, high-impact instance is the fact that the WordPress lookup for permalinks involving dates is not sargable. For a bog-standard permalink structure %year%/%slug%/, WP generates the following query: {{{ SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND ( YEAR( wp_posts.post_date ) = 2017 ) AND wp_posts.post_name = 'tahoma-vs-verdana' AND wp_posts.post_type = 'post' ORDER BY wp_posts.post_date DESC }}} This runs (as a cold query) in ~0.075 seconds on a dedicated (and overpowered) MariaDB 10 instance on a pretty small WordPress DB. While indexes exist for all the fields matched against in the query, the use of {{{AND ( YEAR( wp_posts.post_date ) = 2017 )}}} cannot be matched against the database because MySQL/MariaDB is not intelligent enough to optimize that constraint. The ""same"" query adjusted to make the match against {{{post_date}}} sargable does the same in ~0.034 seconds (half the time): {{{ SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_date >= DATE(""2017-01-01"") AND wp_posts.post_date < DATE(""2018-01-01"") AND wp_posts.post_name = 'tahoma-vs-verdana' AND wp_posts.post_type = 'post' ORDER BY wp_posts.post_date DESC }}} The same would apply for permalinks that reference the month and day, of course." 12955 Future new feature request Add get_post filter dev-feedback Posts, Post Types normal normal 2018-08-28T13:43:50Z This patch filters the return value of the get_post() function. I would find this very helpful for a plugin I'm developing. 47733 Future reviewing defect (bug) Undefined index HTTP_HOST in wp-includes/ms-settings.php on line 57 dev-feedback Bootstrap/Load 5.2.2 minor normal 2024-02-21T14:31:47Z "We get requests on our server of the form {{{ 175.143.12.??? - - [30/Jun/2019:10:22:45 +0200] ""GET / HTTP/1.0"" 500 73873 ""-"" ""-"" (dinse.eu) }}} This request uses HTTP/1.0 and results in a status code 500. The related entry in the PHP error log is {{{ [30-Jun-2019 08:22:45 UTC] PHP Notice: Undefined index: HTTP_HOST in /usr/www/xxxx/wp-includes/ms-settings.php on line 57 }}} 1. In ms-settings.php on line 57 it is not checked if {{{ $_SERVER['HTTP_HOST'] }}} is set. 2. Also I've found that in the case of this specific request {{{ $_SERVER['SERVER_NAME'] }}} is defined and not empty and can be used as a replacement. My suggestion is to first check if {{{ $_SERVER['HTTP_HOST'] }}} is set else check if {{{ $_SERVER['SERVER_NAME'] }}} is set and if both are not set to implement a graceful error handling. This may be related to #34353. WP 5.2.2 PHP 5.6.40 Server: Apache/2.4.25 (Debian) WP_DEBUG = true " 17019 Future reviewing enhancement add hooks for Media Library attachment counts needs-testing Query 2.5 normal normal 2022-03-03T11:07:24Z "The Media Library attachments listing and edit links can be filtered via existing WP_Query and has_cap hooks. However, corresponding attachment counts are not cleanly filterable. The submitted ticket adds the following filters: * function wp_count_attachments() - result filter 'count_attachments' * WP_Media_List_Table::get_views() - query filter 'attachment_orphans_query' * function update_gallery_tab() - query filter 'gallery_attachment_count_query'"