|
#21762
|
Storing a multidimensional array using register_setting double-serializes subarrays identified with a string
|
sekatsim
|
|
normal
|
normal
|
|
defect (bug)
|
06/04/2019
|
|
#26788
|
Improve dbDelta fields match
|
|
has-patch
|
normal
|
normal
|
|
enhancement
|
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
|
|
#29938
|
mysqli_query and multiple resultsets
|
|
needs-unit-tests
|
normal
|
normal
|
|
enhancement
|
06/04/2019
|
|
#31042
|
WPDB field_types Variable Too Broad?
|
|
|
normal
|
normal
|
|
enhancement
|
06/04/2019
|
|
#31759
|
Allow to set $allow_bail when creating new wpdb object to handle connection error silently
|
|
|
normal
|
normal
|
|
enhancement
|
06/04/2019
|
|
#32868
|
Consider running utf8mb4 conversion on each database update
|
|
|
normal
|
normal
|
|
defect (bug)
|
06/04/2019
|
|
#34872
|
dbDelta Missing Index Name Creates Duplicate Indexes
|
|
has-patch
|
normal
|
normal
|
|
defect (bug)
|
06/04/2019
|
|
#35256
|
$wpdb->insert_id equals 0
|
|
|
normal
|
normal
|
|
defect (bug)
|
06/04/2019
|
|
#37508
|
wpdb->result instance should be checked `mysqli_num_fields` in `load_col_info()`
|
|
needs-unit-tests
|
normal
|
normal
|
|
defect (bug)
|
06/04/2019
|
|
#47818
|
$wpdb should update ->insert_id also when `LAST_INSERT_ID(...)` is found
|
|
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
08/02/2019
|
|
#6492
|
Guids No Longer Have Permalink Format
|
|
|
normal
|
normal
|
Future Release
|
enhancement
|
08/30/2019
|
|
#47994
|
The additions of a new wp_posts table columns called post_level and post_patriarch
|
|
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
09/06/2019
|
|
#40694
|
dbDelta uses suppressed errors to detect table absence
|
|
has-patch
|
normal
|
normal
|
Future Release
|
defect (bug)
|
12/01/2019
|
|
#43578
|
Unexpected MYSQL data format
|
|
dev-feedback
|
normal
|
normal
|
Future Release
|
defect (bug)
|
02/03/2020
|
|
#49363
|
wpdb::query() does not detect LOAD DATA as an insert statement type
|
|
has-patch
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
02/05/2020
|
|
#49482
|
Non-english slug can sometimes cause an error in WordPress query
|
|
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
02/20/2020
|
|
#49785
|
Wrong result / duplicates in query when using MariaDB
|
|
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
04/03/2020
|
|
#39826
|
LIMIT clause not required in get_options function as there's already a UNIQUE KEY on option_name
|
|
dev-feedback
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
05/07/2020
|
|
#51097
|
post cannot be saved due to certain variant of Japanese Kanji
|
|
close
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
08/31/2020
|
|
#43893
|
The maybe_create_table() function has two definitions
|
|
dev-feedback
|
low
|
normal
|
Awaiting Review
|
defect (bug)
|
09/01/2020
|
|
#51762
|
Unix authentication support via unix_socket
|
|
|
normal
|
normal
|
Awaiting Review
|
feature request
|
11/12/2020
|
|
#52253
|
New filter on wp-db.php
|
|
reporter-feedback
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
01/08/2021
|
|
#52210
|
File URL gets saved even when upload fails
|
|
|
normal
|
major
|
Awaiting Review
|
defect (bug)
|
02/09/2021
|
|
#52527
|
Better RAM handling in wp-db.php
|
|
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
02/15/2021
|
|
#52648
|
Problem with certain passwords not working to login to mysql db
|
|
reporter-feedback
|
normal
|
major
|
Awaiting Review
|
defect (bug)
|
02/25/2021
|
|
#53033
|
Remove comments, ping, to_ping columns from posts table
|
|
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
04/15/2021
|
|
#40779
|
function_exists() audit in wp-db.php
|
|
dev-feedback
|
low
|
minor
|
Awaiting Review
|
defect (bug)
|
06/01/2021
|
|
#50789
|
Improve WPDB logic around information_schema
|
|
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
06/11/2021
|
|
#53958
|
Database: wp_postmeta - meta_key index
|
|
|
normal
|
major
|
Awaiting Review
|
defect (bug)
|
08/25/2021
|
|
#54235
|
Script for handling metadata in wp_postmeta
|
|
needs-docs
|
normal
|
normal
|
Awaiting Review
|
feature request
|
10/08/2021
|
|
#43019
|
Hook to validate post form data before save
|
|
has-patch
|
normal
|
major
|
Awaiting Review
|
enhancement
|
10/28/2021
|
|
#54560
|
Return null from wpdb::get_results when query fails
|
|
has-patch
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
12/02/2021
|
|
#54627
|
Adding More Timestamp columns to database
|
|
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
12/14/2021
|
|
#55115
|
Change deprecated wpdb::escape() method
|
|
close
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
02/12/2022
|
|
#55202
|
A proper (error) message should be show when mysql setting autocommit=0
|
|
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
02/19/2022
|
|
#55206
|
wp core api memory leaks
|
|
dev-feedback
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
04/29/2022
|
|
#55907
|
Failed to insert log entry: value too long
|
|
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
06/03/2022
|
|
#55938
|
WP prefix on installation - instructions to be indicated
|
|
|
normal
|
minor
|
Awaiting Review
|
enhancement
|
06/07/2022
|
|
#51486
|
The add_option function should not be able to update existing rows in the database.
|
|
needs-unit-tests
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
06/09/2022
|
|
#31018
|
Persistent database connections with mysqli
|
|
needs-unit-tests
|
normal
|
normal
|
|
enhancement
|
08/01/2022
|
|
#40088
|
Stop creating the `wp_links` database table
|
|
close
|
normal
|
normal
|
Future Release
|
defect (bug)
|
08/10/2022
|
|
#45697
|
Database: Upgrading field collations
|
|
|
normal
|
normal
|
Future Release
|
enhancement
|
08/22/2022
|
|
#56533
|
dbDelta() ignores changes to column nullability (NULL/NOT NULL)
|
|
reporter-feedback
|
normal
|
major
|
Awaiting Review
|
defect (bug)
|
09/08/2022
|
|
#54642
|
Add prepared query builder support for `$wpdb` to build prepared queries across multiple location.
|
|
has-patch
|
normal
|
normal
|
Future Release
|
enhancement
|
09/19/2022
|
|
#54801
|
Avoid WPDB errors when examining installation state of a site/network
|
|
has-patch
|
normal
|
normal
|
Future Release
|
defect (bug)
|
09/27/2022
|
|
#56260
|
In case of missing primary key on wp_posts, Media uploader gives false feedback indicating folder permissions are missing, where in fact database structure is malformed.
|
|
|
normal
|
minor
|
Awaiting Review
|
defect (bug)
|
10/26/2022
|
|
#57000
|
wp_usermeta table is emptied because of a wrong query being executed
|
|
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
11/04/2022
|
|
#57072
|
WordPress 6.1 uses wrong database collation
|
|
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
11/11/2022
|
|
#46146
|
dbDelta not parsing enum correctly
|
|
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
11/17/2022
|
|
#57283
|
Postmeta - Performance Improvement - Woocommerce
|
|
|
normal
|
critical
|
Awaiting Review
|
defect (bug)
|
12/06/2022
|
|
#57149
|
get_table_from_query() doesn't properly handle a prepared escape_like() table name
|
|
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
01/04/2023
|
|
#54324
|
Rename Table Function - maybe_rename_table()
|
|
has-patch
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
01/09/2023
|
|
#10404
|
dbDelta creates duplicate indexes when index definition contains spaces
|
|
has-patch
|
normal
|
normal
|
|
enhancement
|
01/21/2023
|
|
#54834
|
Mysql gone away when importing DB on create wp_posts indexes
|
|
|
normal
|
blocker
|
Awaiting Review
|
defect (bug)
|
02/17/2023
|
|
#46210
|
Add helpers for default/empty datetime value
|
|
has-patch
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
02/24/2023
|
|
#56259
|
Database Repair doesn't check for missing primary keys / A.I.
|
|
|
normal
|
minor
|
Awaiting Review
|
enhancement
|
03/09/2023
|
|
#38036
|
Add support for the utf8mb4_0900_ai_ci collation
|
|
|
normal
|
normal
|
Future Release
|
enhancement
|
04/05/2023
|
|
#49654
|
maybe_drop_table
|
|
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
04/07/2023
|
|
#58133
|
WordPress database error Illegal mix of collations
|
|
|
normal
|
major
|
Awaiting Review
|
defect (bug)
|
04/24/2023
|
|
#58286
|
Growing database due to unnecessary transients containing "g_url_details_response_"
|
|
|
normal
|
critical
|
Awaiting Review
|
defect (bug)
|
05/11/2023
|
|
#31624
|
$wpdb->prepare() named placeholders
|
|
needs-unit-tests
|
normal
|
normal
|
|
enhancement
|
06/22/2023
|
|
#28625
|
Enhancement: Add constants to support SSL connections for mysqli
|
|
needs-unit-tests
|
normal
|
normal
|
Future Release
|
enhancement
|
06/24/2023
|
|
#58826
|
Please add a default post relations table
|
|
|
normal
|
critical
|
Awaiting Review
|
enhancement
|
07/17/2023
|
|
#58965
|
No luck running WP when running PHP 8.2.8 + mysql Ver 15.1
|
|
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
08/02/2023
|
|
#59106
|
Add secondary index on `wp_posts` table to improve media queries performance
|
|
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
08/15/2023
|
|
#58694
|
Enhancement in wordpress Database API
|
|
|
normal
|
normal
|
Awaiting Review
|
feature request
|
08/30/2023
|
|
#54042
|
Extending wpdb::prepare() to support IN() operator
|
|
dev-feedback
|
normal
|
normal
|
Future Release
|
enhancement
|
09/17/2023
|
|
#59281
|
Support for Database Cursor
|
|
|
normal
|
normal
|
Awaiting Review
|
feature request
|
09/27/2023
|
|
#59639
|
Dedicated tables for media libary
|
|
dev-feedback
|
normal
|
major
|
Awaiting Review
|
feature request
|
10/16/2023
|
|
#59974
|
MAX_JOIN_SIZE wp-blog-header.php
|
|
|
normal
|
minor
|
Awaiting Review
|
defect (bug)
|
11/27/2023
|
|
#60077
|
Class UnexpectedValueException not found
|
|
|
normal
|
critical
|
Awaiting Review
|
defect (bug)
|
12/14/2023
|
|
#57385
|
Disable foreign key checks when dropping tables inside wp_uninitialize_site() function
|
johnjamesjacoby*
|
dev-feedback
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
01/12/2024
|
|
#60254
|
Add filter to class-wpdb.php#query that allows to return data from filter return value
|
|
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
01/15/2024
|
|
#52496
|
Improve MySQL 8.0 support
|
|
|
normal
|
normal
|
Future Release
|
defect (bug)
|
02/05/2024
|
|
#60505
|
Column names in wpdb->insert aren't sanitized.
|
|
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
02/12/2024
|
|
#53320
|
Why delete_metadata and update_metadata slow performance?
|
|
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
03/26/2024
|
|
#56091
|
Using %i for table/field names in wpdb::prepare()
|
craigfrancis
|
has-patch
|
low
|
minor
|
Future Release
|
enhancement
|
04/02/2024
|
|
#61604
|
Split `wp_insert_post` in two
|
|
|
normal
|
minor
|
Awaiting Review
|
enhancement
|
07/09/2024
|
|
#41281
|
attachment_url_to_postid results in very slow query
|
joemcgill*
|
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
07/18/2024
|
|
#61856
|
Add support for MySQL SSL connections
|
|
has-patch
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
08/13/2024
|
|
#42352
|
Support use of native MySQLi prepared queries
|
|
early
|
normal
|
normal
|
Future Release
|
enhancement
|
09/26/2024
|
|
#61338
|
wpdb::prepare function null value convert to empty String
|
|
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
10/02/2024
|
|
#60037
|
Differentiate between minimum required MySQL and MariaDB versions
|
|
|
normal
|
normal
|
Future Release
|
defect (bug)
|
11/02/2024
|
|
#57793
|
Add native support for SQLite
|
|
has-patch
|
normal
|
normal
|
Future Release
|
feature request
|
11/04/2024
|
|
#54070
|
Increase CPT "machine name" limit from its current maximum of 20 characters.
|
|
dev-feedback
|
normal
|
normal
|
Awaiting Review
|
feature request
|
11/08/2024
|
|
#62575
|
Prints SQL/DB error limit last_query too long
|
|
|
normal
|
normal
|
Awaiting Review
|
feature request
|
11/26/2024
|
|
#41054
|
Use sargable date filtering where possible
|
|
|
normal
|
trivial
|
Awaiting Review
|
enhancement
|
12/05/2024
|
|
#60503
|
MySQL VALUES function deprecated in MySQL 8
|
|
close
|
normal
|
minor
|
Awaiting Review
|
defect (bug)
|
12/10/2024
|
|
#61071
|
Need to display appropriate error messages when the database table is empty or corrupted.
|
|
dev-feedback
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
01/06/2025
|
|
#40953
|
Empty values are handled inconsistently between wpdb->get_results() and wpdb->get_col()
|
|
dev-feedback
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
01/17/2025
|
|
#36242
|
wpdb set_sql_mode add param
|
pbearne
|
dev-feedback
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
01/18/2025
|
|
#60102
|
PHPunit tests for dead_db
|
|
has-patch
|
normal
|
normal
|
Future Release
|
enhancement
|
02/12/2025
|
|
#54836
|
Huge error logs filled with "WordPress database error Illegal mix of collations" errors caused by spammers
|
|
|
normal
|
critical
|
Awaiting Review
|
defect (bug)
|
03/19/2025
|
|
#8857
|
Make WP MySQL strict mode compliant
|
|
|
lowest
|
normal
|
|
enhancement
|
04/08/2025
|
|
#61889
|
Function dbDelta() splits queries on semi-colon in column COMMENT and table COMMENT
|
|
has-patch
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
04/28/2025
|
|
#10883
|
db-error.php not used for all DB failures
|
|
|
normal
|
normal
|
|
enhancement
|
04/30/2025
|
|
#58344
|
Connect to database on first query
|
|
has-patch
|
normal
|
normal
|
Future Release
|
enhancement
|
05/08/2025
|
|
#59172
|
wp_query meta_query NOT EXISTS not creating correct sql query
|
|
reporter-feedback
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
05/12/2025
|