Database component

WordPress database abstraction is implemented at wp-db.php.

Recent posts on the make/coreCore Core is the set of software required to run WordPress. The Core Development Team builds WordPress. blogblog (versus network, site)

View all posts tagged database.

138 open tickets in the Database component

138 open tickets defect (bug) enhancement feature request
11 13 0
6.2 2 2 0
Awaiting Review 45 38 4
Future Release 10 11 2

138 open tickets. Last 7 days: -2 tickets

43 tickets that have no replies

View list on Trac

  • #28139  WP MU legacy problems: missing database tables administration multisitemultisite Used to describe a WordPress installation with a network of multiple blogs, grouped by sites. This installation type has shared users tables, and creates separate database tables for each blog (wp_posts becomes wp_0_posts). See also network, blog, site
  • #28591  dbDelta Non-literal DEFAULT not working (CURRENT_TIMESTAMP)
  • #31624  $wpdb->prepare() named placeholders
  • #31759  Allow to set $allow_bail when creating new wpdb object to handle connection error silently
  • #32868  Consider running utf8mb4 conversion on each database update
  • #35256  $wpdb->insert_id equals 0
  • #36242  wpdb set_sql_mode add param performance
  • #39273  Updating to 4.7 can break serialized data because $wpdb->determine_charset now forces utf8 when DB_CHARSET is set to utf8mb4
  • #39748  Function to insert or update DB value
  • #40150  VARCHAR/TEXT inefficiencies
  • #42703  WP_Query: Swap parsing date into own method
  • #44292  Make use of protected process_fields
  • #44386  Problem with utf8mb4_unicode_ci collation for arabic content
  • #44973  Issues with $wpdb->get_col_info
  • #46145  dbDelta runs same updates on every execution
  • #46179  Make fetch_array accessible in $wpdb performance
  • #46287  Add insert_ignore() method to wpdb to avoid unecessary boilerplate code
  • #46452  dbDelta given the same PRIMARY KEY and normal KEY produces no error, reports table created successfully, but the table is not created
  • #46565  Mixed engine in tables, could bring to major WP failure! Also there is a small fix that could avoid that.
  • #46576  short-circuit filterFilter Filters are one of the two types of Hooks https://codex.wordpress.org/Plugin_API/Hooks. They provide a way for functions to modify data of other functions. They are the counterpart to Actions. Unlike Actions, filters are meant to work in an isolated manner, and should never have side effects such as affecting global variables and output. for dbDelta
  • #46739  post attributes order not working correctly
  • #46923  $wpdb->get_var() — empty sting becomes a NULL
  • #46932  dbDelta does not account for MySQLMySQL MySQL is a relational database management system. A database is a structured collection of data where content, configuration and other options are stored. https://www.mysql.com/. keywords being used as key names administration
  • #47818  $wpdb should update ->insert_id also when `LAST_INSERT_ID(…)` is found
  • #47994  The additions of a new wp_posts table columns called post_level and post_patriarch
  • #49363  wpdb::query() does not detect LOAD DATA as an insert statement type
  • #49482  Non-english slug can sometimes cause an error in WordPress query
  • #49654  maybe_drop_table
  • #51350  mysql nosql feature requestfeature request A feature request should generally begin the process in the ideas forum, on a mailing list, as a plugin, or brought to the attention of the core team, such as through scope meetings held for each major release. Unsolicited tickets of this variety are typically, therefore, discouraged. performance
  • #51762  Unix authentication support via unix_socket
  • #52527  Better RAM handling in wp-db.php
  • #53033  Remove comments, pingPing The act of sending a very small amount of data to an end point. Ping is used in computer science to illicit a response from a target server to test it’s connection. Ping is also a term used by Slack users to @ someone or send them a direct message (DM). Users might say something along the lines of “Ping me when the meeting starts.”, to_ping columns from posts table
  • #53320  Why delete_metadata and update_metadata slow performance? performance
  • #54235  Script for handling metadata in wp_postmeta
  • #54560  Return null from wpdb::get_results when query fails
  • #54627  Adding More Timestamp columns to database
  • #55202  A proper (error) message should be show when mysql setting autocommit=0
  • #55907  Failed to insert log entry: value too long
  • #55938  WP prefix on installation – instructions to be indicated
  • #56259  Database Repair doesn't check for missing primary keys / A.I.
  • #56294  WordPress search finds blockBlock Block is the abstract term used to describe units of markup that, composed together, form the content or layout of a webpage using the WordPress editor. The idea combines concepts of what in the past may have achieved with shortcodes, custom HTML, and embed discovery into a single consistent API and user experience. name in comment performance
  • #57000  wp_usermeta table is emptied because of a wrong query being executed
  • #57072  WordPress 6.1 uses wrong database collation

4 tickets slated for 6.2

View list in Trac

  • #15499  Add an index for get_lastpostmodified query performance
  • #52496  Improve MySQL 8.0 support
  • #52506  Add escaping method for table names in SQL queries performance
  • #56091  Using %i for table/field names in wpdb::prepare()

138 open tickets

Open enhancements: 64 View list on Trac
Open tasks: 0 View list on Trac
Open feature requests: 6 View list on Trac

Help maintain this component

Component maintainers:

Many contributors help maintain one or more components. These maintainers are vital to keeping WordPress development running as smoothly as possible. They triagetriage The act of evaluating and sorting bug reports, in order to decide priority, severity, and other factors. new tickets, look after existing ones, spearhead or mentor tasks, pitch new ideas, curate roadmaps, and provide feedback to other contributors. Longtime maintainers with a deep understanding of particular areas of Core are always seeking to mentor others to impart their knowledge.

Want to help? Start following this component! Adjust your notifications here. Feel free to dig into any ticketticket Created for both bug reports and feature development on the bug tracker..

Contributors following this component: