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.

131 open tickets in the Database component

131 open tickets defect (bug) enhancement feature request
12 13 1
6.0 5 1 0
Awaiting Review 43 33 4
Future Release 8 10 1

131 open tickets. Last 7 days: +3 tickets

42 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
  • #51486  The add_option function should not be able to update existing rows in the database.
  • #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
  • #54324  Rename Table Function – maybe_rename_table()
  • #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
  • #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

6 tickets slated for 6.0

View list in Trac

  • #42362  WordPress database error Unknown column 'wp_mywordpresssite' in 'field list'
  • #49364  dbDelta() should not change display width for integer data types on MySQL 8.0.17+
  • #51740  Test failures using MySQL 8
  • #52496  Improve MySQL 8.0 support
  • #54801  Avoid WPDB errors when examining installation state of a site/networknetwork (versus site, blog)
  • #54877  Occasional PHP exception being thrown on WPDB/MySQLi connections

131 open tickets

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

Help maintain this component

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: