WordPress.org

Make WordPress Core

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

1 2 →

Slated for Next Release (4 matches)

Ticket Summary Owner Priority Severity Milestone Type Workflow Modified
#32315 $wpdb->insert fails without error msg SergeyBiryukov normal normal 5.9 defect (bug) dev-feedback 06/09/2021
#52496 Improve MySQL 8.0 support normal normal 5.9 defect (bug) 06/30/2021
#51740 Test failures using MySQL 8 normal normal 5.9 defect (bug) 06/30/2021
#49364 dbDelta() should not change display width for integer data types on MySQL 8.0.17+ normal normal 5.9 defect (bug) has-patch 06/30/2021

Tickets Awaiting Review (59 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
#52506 Add escaping method for table names in SQL queries normal normal Awaiting Review defect (bug) dev-feedback 09/22/2021
#39811 Bug maybe_unserialize() broke mysql data. normal normal Awaiting Review defect (bug) 02/20/2017
#53958 Database: wp_postmeta - meta_key index normal major Awaiting Review defect (bug) 08/25/2021
#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
#52210 File URL gets saved even when upload fails normal major Awaiting Review defect (bug) 02/09/2021
#50789 Improve WPDB logic around information_schema normal normal Awaiting Review defect (bug) 06/11/2021
#44973 Issues with $wpdb->get_col_info normal normal Awaiting Review defect (bug) has-patch 09/23/2018
#53623 MariaDB 10.6 renamed utf8 to utf8mb3 normal normal Awaiting Review defect (bug) 07/27/2021
#49482 Non-english slug can sometimes cause an error in WordPress query normal normal Awaiting Review defect (bug) 02/20/2020
#53033 Remove comments, ping, to_ping columns from posts table normal normal Awaiting Review defect (bug) 04/15/2021
#41278 SQL_CALC_FOUND_ROWS slow query normal normal Awaiting Review defect (bug) 07/19/2017
#51486 The add_option function should not be able to update existing rows in the database. normal normal Awaiting Review defect (bug) needs-unit-tests 10/09/2020
#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
#53320 Why delete_metadata and update_metadata slow performance? normal normal Awaiting Review defect (bug) 06/02/2021
#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
#49785 Wrong result / duplicates in query when using MariaDB normal normal Awaiting Review defect (bug) 04/03/2020
#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
#51350 mysql nosql feature request normal normal Awaiting Review defect (bug) 09/18/2020
#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
#51207 wpdb query returns incorrect value for update ( using mysql ) normal normal Awaiting Review defect (bug) 09/01/2020
#49363 wpdb::query() does not detect LOAD DATA as an insert statement type normal normal Awaiting Review defect (bug) has-patch 02/05/2020
#47818 $wpdb should update ->insert_id also when `LAST_INSERT_ID(...)` is found normal normal Awaiting Review enhancement 08/02/2019
#41944 Add %u support to wpdb->prepare normal normal Awaiting Review enhancement 09/21/2017
#46210 Add helpers for default/empty datetime value normal normal Awaiting Review enhancement 11/09/2020
#45354 Adding index for meta_key and post_id in postmeta normal normal Awaiting Review enhancement dev-feedback 09/28/2021
#52527 Better RAM handling in wp-db.php normal normal Awaiting Review enhancement 02/15/2021
#41956 Errno in $wpdb normal normal Awaiting Review enhancement has-patch 08/17/2018
#54042 Extending wpdb::prepare() to support table/field names, and IN() operator normal normal Awaiting Review enhancement has-patch 09/22/2021
#39748 Function to insert or update DB value normal normal Awaiting Review enhancement 10/29/2017
#43019 Hook to validate post form data before save normal major Awaiting Review enhancement has-patch 12/30/2020
#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
#47994 The additions of a new wp_posts table columns called post_level and post_patriarch normal normal Awaiting Review enhancement 09/06/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
#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 04/30/2021
#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
#49654 maybe_drop_table normal normal Awaiting Review enhancement 03/16/2020
#46576 short-circuit filter for dbDelta normal normal Awaiting Review enhancement 03/20/2019
#48285 wp-config-sample.php should default to `utf8mb4` instead of `utf8` character set normal minor Awaiting Review enhancement 10/12/2019
#46287 Add insert_ignore() method to wpdb to avoid unecessary boilerplate code normal normal Awaiting Review feature request has-patch 02/20/2019
#54070 Increase CPT "machine name" limit from its current maximum of 20 characters. normal normal Awaiting Review feature request dev-feedback 09/16/2021
#51762 Unix authentication support via unix_socket normal normal Awaiting Review feature request 11/12/2020

Candidates for Closure (16 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
#53125 Error messages should not be translateable normal normal Awaiting Review defect (bug) dev-feedback 05/02/2021
#40418 ID columns in multisite database tables should be unsigned flixos90 normal major Awaiting Review defect (bug) dev-feedback 09/11/2018
#52648 Problem with certain passwords not working to login to mysql db normal major Awaiting Review defect (bug) reporter-feedback 02/25/2021
#40088 Stop creating the `wp_links` database table normal normal Awaiting Review defect (bug) dev-feedback 08/10/2019
#43893 The maybe_create_table() function has two definitions low normal Awaiting Review defect (bug) dev-feedback 09/01/2020
#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 06/01/2021
#51097 post cannot be saved due to certain variant of Japanese Kanji normal normal Awaiting Review defect (bug) close 08/31/2020
#44163 wpdb->update() fails, showing no error message normal normal Awaiting Review defect (bug) reporter-feedback 05/21/2018
#49479 Does $wpdb->get_row() add LIMIT 1 to the query? normal normal Awaiting Review enhancement close 02/20/2020
#51769 Full-text search support normal normal Awaiting Review enhancement dev-feedback 08/24/2021
#37692 Introduce WP_Database_Table base class normal normal Awaiting Review enhancement dev-feedback 03/15/2017
#39826 LIMIT clause not required in get_options function as there's already a UNIQUE KEY on option_name normal normal Awaiting Review enhancement dev-feedback 05/07/2020
#52253 New filter on wp-db.php normal normal Awaiting Review enhancement reporter-feedback 01/08/2021
#49028 Provide functionality to suppress $wpdb query filter normal normal Awaiting Review enhancement reporter-feedback 02/08/2020

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 02/03/2020
#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 SergeyBiryukov normal normal Future Release enhancement dev-feedback 07/20/2021
#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 (13 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 05/27/2020
#42362 WordPress database error Unknown column 'wp_mywordpresssite' in 'field list' SergeyBiryukov normal normal Future Release defect (bug) has-patch 05/11/2020
#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 12/01/2019
#37508 wpdb->result instance should be checked `mysqli_num_fields` in `load_col_info()` normal normal defect (bug) needs-unit-tests 06/04/2019
#28625 Enhancement: Add constants to support SSL connections for mysqli normal normal Future Release enhancement needs-unit-tests 02/03/2021
#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
#47280 SQL_CALC_FOUND_ROWS is deprecated as of MySQL 8.0.17 normal major Future Release enhancement has-patch 09/14/2021
#10404 dbDelta creates duplicate indexes when index definition contains spaces normal normal enhancement has-patch 03/30/2020
#15332 dbDelta($query) - do not create view normal normal Future Release feature request needs-unit-tests 07/30/2018

Unpatched Bugs (1 match)

Ticket Summary Owner Priority Severity Milestone Type Workflow Modified
#35256 $wpdb->insert_id equals 0 normal normal defect (bug) 06/04/2019
1 2 →
Note: See TracReports for help on using and creating reports.