WordPress.org

Make WordPress Core

{31} Tickets in the Database component (96 matches)

Arguments
Create a new ticket
  • Active tickets in the Database component
  • Grouped by workflow and sorted by type, summary
  • Accepted tickets have an '*' appended to their owner's name

Candidates for Closure (7 matches)

Ticket Summary Owner Priority Severity Milestone Type Workflow Modified
#37678 Add an action hook for plugins to do database upgrades on normal normal Awaiting Review defect (bug) dev-feedback 04/18/2019
#40418 ID columns in multisite database tables should be unsigned flixos90 normal major Awaiting Review defect (bug) dev-feedback 09/11/2018
#37692 Introduce WP_Database_Table base class normal normal Awaiting Review enhancement dev-feedback 03/15/2017
#40088 Stop creating the `wp_links` database table normal normal Awaiting Review defect (bug) dev-feedback 08/10/2019
#47934 Undefined property: wpdb::$blogmeta normal normal Awaiting Review defect (bug) reporter-feedback 08/27/2019
#40779 function_exists() audit in wp-db.php low minor Awaiting Review defect (bug) dev-feedback 05/16/2017
#44163 wpdb->update() fails, showing no error message normal normal Awaiting Review defect (bug) reporter-feedback 05/21/2018

Tickets Awaiting Review (45 matches)

Ticket Summary Owner Priority Severity Milestone Type Workflow Modified
#47818 $wpdb should update ->insert_id also when `LAST_INSERT_ID(...)` is found normal normal Awaiting Review enhancement 08/02/2019
#43664 $wpdb->get_results fails in specific cases with non-latin charaters in where clause normal normal Awaiting Review defect (bug) 04/08/2018
#46923 $wpdb->get_var() — empty sting becomes a NULL normal normal Awaiting Review defect (bug) 04/15/2019
#32315 $wpdb->insert fails without error msg normal normal Awaiting Review defect (bug) dev-feedback 10/10/2019
#41944 Add %u support to wpdb->prepare normal normal Awaiting Review enhancement 09/21/2017
#40037 Add ability to ask wpdb for full db server info normal normal Awaiting Review enhancement has-patch 12/09/2018
#46210 Add helpers for default/empty datetime value normal normal Awaiting Review enhancement 08/20/2019
#46287 Add insert_ignore() method to wpdb to avoid unecessary boilerplate code normal normal Awaiting Review feature request has-patch 02/20/2019
#45354 Adding index for meta_key and post_id in postmeta normal normal Awaiting Review enhancement dev-feedback 03/21/2019
#39811 Bug maybe_unserialize() broke mysql data. normal normal Awaiting Review defect (bug) 02/20/2017
#37956 DB_COLLATE doesn't override $collate when defining utf8mb4_unicode_ci in wp-config normal normal Awaiting Review defect (bug) 01/05/2017
#40953 Empty values are handled inconsistently between wpdb->get_results() and wpdb->get_col() normal normal Awaiting Review defect (bug) dev-feedback 06/08/2017
#41956 Errno in $wpdb normal normal Awaiting Review enhancement has-patch 08/17/2018
#39748 Function to insert or update DB value normal normal Awaiting Review enhancement 10/29/2017
#44973 Issues with $wpdb->get_col_info normal normal Awaiting Review defect (bug) has-patch 09/23/2018
#46179 Make fetch_array accessible in $wpdb normal normal Awaiting Review enhancement 02/04/2019
#44292 Make use of protected process_fields normal normal Awaiting Review enhancement 06/01/2018
#46565 Mixed engine in tables, could bring to major WP failure! Also there is a small fix that could avoid that. normal normal Awaiting Review enhancement 03/20/2019
#44386 Problem with utf8mb4_unicode_ci collation for arabic content normal major Awaiting Review enhancement has-patch 06/17/2018
#41278 SQL_CALC_FOUND_ROWS slow query normal normal Awaiting Review defect (bug) 07/19/2017
#40535 Tests_DB::test_locale_floats() cannot be tested on Travis normal normal Awaiting Review defect (bug) needs-unit-tests 04/23/2017
#47994 The additions of a new wp_posts table columns called post_level and post_patriarch normal normal Awaiting Review enhancement 09/06/2019
#43893 The maybe_create_table() function has two definitions low normal Awaiting Review defect (bug) 09/17/2019
#18210 Update_post_meta is case insensitive on meta_key, but get_post_meta is NOT normal normal Awaiting Review defect (bug) needs-unit-tests 05/15/2017
#39273 Updating to 4.7 can break serialized data because $wpdb->determine_charset now forces utf8 when DB_CHARSET is set to utf8mb4 normal normal Awaiting Review defect (bug) dev-feedback 03/15/2019
#30795 Upgrade bug affecting indexing normal normal Awaiting Review defect (bug) 03/22/2019
#41054 Use sargable date filtering where possible normal normal Awaiting Review enhancement 06/15/2017
#40150 VARCHAR/TEXT inefficiencies normal normal Awaiting Review enhancement 03/14/2017
#43589 WPDB Update change NULL values to acceptable values normal normal Awaiting Review defect (bug) has-patch 01/17/2019
#42703 WP_Query: Swap parsing date into own method normal normal Awaiting Review enhancement 01/16/2019
#41302 WordPress not stopping queries which have reached limit and preventing users to load WordPress until query times out normal normal Awaiting Review defect (bug) 07/14/2017
#42381 Wordpress update does not check if database structure/scheme on existing site is equal to how it would be on a new install normal normal Awaiting Review defect (bug) dev-feedback 11/11/2017
#41281 attachment_url_to_postid results in very slow query joemcgill* normal normal Awaiting Review enhancement 09/11/2019
#8924 autoload should be boolean in add_option() lowest normal Awaiting Review enhancement 03/15/2019
#40357 dbDelta can't change primary keys, create AUTO_INCREMENT columns and doesn't make significant index changes normal normal Awaiting Review enhancement needs-unit-tests 04/04/2017
#46932 dbDelta does not account for MySQL keywords being used as key names normal minor Awaiting Review defect (bug) 04/16/2019
#46452 dbDelta given the same PRIMARY KEY and normal KEY produces no error, reports table created successfully, but the table is not created normal trivial Awaiting Review defect (bug) 03/09/2019
#46146 dbDelta not parsing enum correctly normal normal Awaiting Review defect (bug) 01/30/2019
#46145 dbDelta runs same updates on every execution normal normal Awaiting Review defect (bug) 01/30/2019
#36924 dbDelta(): Support more than one whitespace between field name and its type definition normal normal Awaiting Review defect (bug) 08/10/2018
#46739 post attributes order not working correctly normal normal Awaiting Review defect (bug) 03/30/2019
#46576 short-circuit filter for dbDelta normal normal Awaiting Review enhancement 03/20/2019
#41469 test_charset_switched_to_utf8() is not tested on Travis CI normal normal Awaiting Review defect (bug) 07/28/2017
#46625 username and password automatically change to dexter normal normal Awaiting Review defect (bug) 03/24/2019
#48285 wp-config-sample.php should default to `utf8mb4` instead of `utf8` character set normal minor Awaiting Review enhancement 10/12/2019

Tickets Needing Feedback (7 matches)

Ticket Summary Owner Priority Severity Milestone Type Workflow Modified
#15499 Add an index for get_lastpostmodified query normal normal Future Release enhancement dev-feedback 09/19/2019
#18315 Add an index to the GUID column in the posts table normal normal enhancement dev-feedback 06/04/2019
#25559 Enhance prepare method to better support SQL IN operator normal normal enhancement dev-feedback 06/04/2019
#43578 Unexpected MYSQL data format normal normal Future Release defect (bug) dev-feedback 03/24/2018
#20634 dbDelta is unforgiving about field declarations normal normal enhancement dev-feedback 06/04/2019
#12257 wpdb Scales Badly Due to Unnecessary Copies of All Query Results normal critical defect (bug) dev-feedback 06/04/2019
#46947 ‘❤’ in Comment Generates DB Error normal normal Future Release defect (bug) reporter-feedback 04/17/2019

Tickets with Patches (11 matches)

Ticket Summary Owner Priority Severity Milestone Type Workflow Modified
#13103 "Unknown character set" during install into database reports successful install. barrykooij normal normal defect (bug) has-patch 06/04/2019
#38921 Defining filter pre_get_table_charset causes errors normal normal Future Release defect (bug) has-patch 03/18/2018
#28625 Enhancement: Add constants to support SSL connections for mysqli pento normal normal Future Release enhancement needs-unit-tests 10/25/2017
#26788 Improve dbDelta fields match normal normal enhancement has-patch 06/04/2019
#31018 Persistent database connections with mysqli normal normal enhancement needs-unit-tests 06/04/2019
#42362 WordPress database error Unknown column 'wp_mywordpresssite' in 'field list' SergeyBiryukov normal normal Future Release defect (bug) has-patch 06/11/2019
#40695 `install_blog` suppresses database errors normal normal Future Release defect (bug) has-patch 06/01/2017
#34872 dbDelta Missing Index Name Creates Duplicate Indexes normal normal defect (bug) has-patch 06/04/2019
#40694 dbDelta uses suppressed errors to detect table absence normal normal Future Release defect (bug) has-patch 06/01/2017
#15332 dbDelta($query) - do not create view normal normal Future Release feature request needs-unit-tests 07/30/2018
#37508 wpdb->result instance should be checked `mysqli_num_fields` in `load_col_info()` normal normal defect (bug) needs-unit-tests 06/04/2019

Unpatched Bugs (11 matches)

Ticket Summary Owner Priority Severity Milestone Type Workflow Modified
#35256 $wpdb->insert_id equals 0 normal normal defect (bug) 06/04/2019
#44440 Case sensitive/insensitive bug normal normal defect (bug) 10/09/2019
#26858 Comment duplicate check has a slow query normal normal defect (bug) 06/04/2019
#29096 Confusing errors when mysqli fails but mysql works normal normal defect (bug) 06/04/2019
#32868 Consider running utf8mb4 conversion on each database update normal normal defect (bug) 06/04/2019
#14711 Indexes for comment_author_email and user_id normal normal defect (bug) 06/04/2019
#44384 InnoDB doesn't support SPATIAL indexes for query CREATE TEMPORARY TABLE normal normal Future Release defect (bug) 08/29/2018
#44586 SQL mode test results broken in MySQL 8.0.11 normal normal Future Release defect (bug) 07/15/2018
#21762 Storing a multidimensional array using register_setting double-serializes subarrays identified with a string sekatsim normal normal defect (bug) 06/04/2019
#28139 WP MU legacy problems: missing database tables normal normal defect (bug) 06/04/2019
#28591 dbDelta Non-literal DEFAULT not working (CURRENT_TIMESTAMP) normal normal defect (bug) 06/04/2019

Unpatched Enhancements (15 matches)

Ticket Summary Owner Priority Severity Milestone Type Workflow Modified
#31624 $wpdb->prepare() named placeholders normal normal enhancement needs-unit-tests 06/04/2019
#35109 Add Online DDL support to dbDelta normal normal enhancement needs-unit-tests 06/04/2019
#38036 Add support for the utf8mb4_0900_ai_ci collation normal normal Future Release enhancement 03/08/2018
#31759 Allow to set $allow_bail when creating new wpdb object to handle connection error silently normal normal enhancement 06/04/2019
#38760 Capture result size in bytes when SAVEQUERIES is true normal normal Future Release enhancement 10/03/2017
#45697 Database: Upgrading field collations normal normal Future Release enhancement 12/20/2018
#6492 Guids No Longer Have Permalink Format normal normal Future Release enhancement 08/30/2019
#34330 Locks API for atomic data manipulation normal normal feature request 06/04/2019
#47280 SQL_CALC_FOUND_ROWS is deprecated as of MySQL 8.0.17 normal normal Future Release enhancement 10/10/2019
#42352 Support use of native MySQLi prepared queries normal normal Future Release enhancement early 09/24/2019
#41424 Use a better error message than "Error establishing a database connection" when site isn't found normal normal Future Release enhancement needs-unit-tests 11/22/2017
#31042 WPDB field_types Variable Too Broad? normal normal enhancement 06/04/2019
#10883 db-error.php not used for all DB failures normal normal enhancement 07/24/2019
#29938 mysqli_query and multiple resultsets normal normal enhancement needs-unit-tests 06/04/2019
#36242 wpdb set_sql_mode add param normal normal enhancement 06/04/2019
Note: See TracReports for help on using and creating reports.