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
12 13 1
6.1 4 3 0
Awaiting Review 43 37 4
Future Release 10 10 1

138 open tickets. Last 7 days: +1 ticketticket Created for both bug reports and feature development on the bug tracker.

44 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
  • #46146  dbDelta not parsing enum correctly
  • #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
  • #51207  wpdb query returns incorrect value for update ( using mysql )
  • #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
  • #54841  wpdb::has_cap utf8mb4_520 detection does not work properly
  • #55202  A proper (error) message should be show when mysql setting autocommit=0
  • #55402  Check for and retain custom indexes on version upgrades
  • #55907  Failed to insert log entry: value too long
  • #55938  WP prefix on installation – instructions to be indicated
  • #56091  Use %i for table/field names in wpdb::prepare()

7 tickets slated for 6.1

View list in Trac

  • #49364  dbDelta() should not change display width for integer data types on MySQL 8.0.17+
  • #52496  Improve MySQL 8.0 support
  • #54642  Add prepared query builder support for `$wpdb` to build prepared queries across multiple location. coding-standards
  • #54801  Avoid WPDB errors when examining installation state of a site/networknetwork (versus site, blog)
  • #54877  Occasional PHPPHP The web scripting language in which WordPress is primarily architected. WordPress requires PHP 5.6.20 or higher exception being thrown on WPDB/MySQLi connections
  • #55942  Add a "type" field to the metaMeta Meta is a term that refers to the inside workings of a group. For us, this is the team that works on internal WordPress sites like WordCamp Central and Make WordPress. and options tables
  • #56091  Use %i for table/field names in wpdb::prepare()

138 open tickets

Open enhancements: 63 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 ticket.

Contributors following this component: