WordPress.org

Make WordPress Core

{31} Tickets in the Database component (104 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

Results (1 - 100 of 104)

1 2

Slated for Next Release (3 matches)

Ticket Summary Owner Priority Severity Milestone Type Workflow Modified
#47430 wp-db: Always adds a filter on every query SergeyBiryukov normal minor 5.3 defect (bug) has-patch 05/29/2019
#42151 Create a filter to add information to query data saved when SAVEQUERIES is true normal normal 5.3 enhancement has-patch 03/20/2019
#45604 Docs: Added description for global $wpdb SergeyBiryukov normal normal 5.3 enhancement dev-feedback 05/30/2019

Tickets Awaiting Review (45 matches)

Ticket Summary Owner Priority Severity Milestone Type Workflow Modified
#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 03/28/2019
#39811 Bug maybe_unserialize() broke mysql data. normal normal Awaiting Review defect (bug) 02/20/2017
#44440 Case sensitive/insensitive bug normal normal Awaiting Review defect (bug) 06/23/2018
#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
#44973 Issues with $wpdb->get_col_info normal normal Awaiting Review defect (bug) has-patch 09/23/2018
#41278 SQL_CALC_FOUND_ROWS slow query normal normal Awaiting Review defect (bug) 07/19/2017
#40446 Status: "InnoDB: Error: Trying to do i/o to a tablespace which exists without .ibd data file. i/o type 10, space id 102077, page no 0, i/o length 16384 bytes" normal critical Awaiting Review defect (bug) 04/14/2017
#45607 Table prefix makes WordPress normal normal Awaiting Review defect (bug) 02/01/2019
#40535 Tests_DB::test_locale_floats() cannot be tested on Travis normal normal Awaiting Review defect (bug) needs-unit-tests 04/23/2017
#43893 The maybe_create_table() function has two definitions low normal Awaiting Review defect (bug) 05/02/2018
#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
#43589 WPDB Update change NULL values to acceptable values normal normal Awaiting Review defect (bug) has-patch 01/17/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
#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
#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
#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 02/10/2019
#45354 Adding index for meta_key and post_id in postmeta normal normal Awaiting Review enhancement dev-feedback 03/21/2019
#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
#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
#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
#42703 WP_Query: Swap parsing date into own method normal normal Awaiting Review enhancement 01/16/2019
#41281 attachment_url_to_postid results in very slow query joemcgill* normal normal Awaiting Review enhancement 06/14/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
#46576 short-circuit filter for dbDelta normal normal Awaiting Review enhancement 03/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

Candidates for Closure (11 matches)

Ticket Summary Owner Priority Severity Milestone Type Workflow Modified
#37283 /* LOCK */ in SQL query crashes mysqli with no error message and prevents automatic updates pento normal major Awaiting Review defect (bug) close 01/03/2017
#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
#40088 Stop creating the `wp_links` database table normal normal Awaiting Review defect (bug) dev-feedback 10/07/2017
#40779 function_exists() audit in wp-db.php low minor Awaiting Review defect (bug) dev-feedback 05/16/2017
#39814 wp_usermeta uses umeta_id instead of meta_id normal normal Awaiting Review defect (bug) close 02/13/2017
#44163 wpdb->update() fails, showing no error message normal normal Awaiting Review defect (bug) reporter-feedback 05/21/2018
#40212 Changing your database port in WordPress during installation normal normal Awaiting Review enhancement close 04/01/2017
#37692 Introduce WP_Database_Table base class normal normal Awaiting Review enhancement dev-feedback 03/15/2017
#37984 Relocate either dbDelta() or wp_should_upgrade_global_tables() out of upgrade.php low minor Awaiting Review enhancement dev-feedback 04/18/2019
#44856 does remove database column(field) in each update core? normal normal Awaiting Review enhancement close 08/30/2018

Tickets Needing Feedback (7 matches)

Ticket Summary Owner Priority Severity Milestone Type Workflow Modified
#43578 Unexpected MYSQL data format normal normal Future Release defect (bug) dev-feedback 03/24/2018
#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
#15499 Add an index for get_lastpostmodified query normal normal Future Release enhancement dev-feedback 05/21/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
#20634 dbDelta is unforgiving about field declarations normal normal enhancement dev-feedback 06/04/2019

Tickets with Patches (12 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
#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
#37508 wpdb->result instance should be checked `mysqli_num_fields` in `load_col_info()` normal normal defect (bug) needs-unit-tests 06/04/2019
#32798 Add support for mysql named pipe (windows os) normal normal enhancement has-patch 06/04/2019
#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
#15332 dbDelta($query) - do not create view normal normal Future Release feature request needs-unit-tests 07/30/2018

Unpatched Bugs (10 matches)

Ticket Summary Owner Priority Severity Milestone Type Workflow Modified
#35256 $wpdb->insert_id equals 0 normal normal defect (bug) 06/04/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 (12 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
#37252 Generic driver access to database normal normal enhancement 06/04/2019
#6492 Guids No Longer Have Permalink Format normal normal Future Release enhancement 10/30/2017
#47280 SQL_CALC_FOUND_ROWS is deprecated as of MySQL 8.0.17 normal normal Future Release enhancement 05/15/2019
#42352 Support use of native MySQLi prepared queries normal normal Future Release enhancement early 12/12/2017
#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
1 2
Note: See TracReports for help on using and creating reports.