#47818
|
$wpdb should update ->insert_id also when `LAST_INSERT_ID(...)` is found
|
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
|
08/02/2019
|
#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
|
#55202
|
A proper (error) message should be show when mysql setting autocommit=0
|
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
|
02/19/2022
|
#62512
|
Add "Learn WordPress" Links to the "WordPress Events and News" Dashboard Widget
|
|
normal
|
normal
|
Awaiting Review
|
feature request
|
has-patch
|
12/06/2024
|
#41944
|
Add %u support to wpdb->prepare
|
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
|
09/21/2017
|
#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
|
#46210
|
Add helpers for default/empty datetime value
|
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
has-patch
|
02/24/2023
|
#46287
|
Add insert_ignore() method to wpdb to avoid unecessary boilerplate code
|
|
normal
|
normal
|
Awaiting Review
|
feature request
|
has-patch
|
11/25/2024
|
#59106
|
Add secondary index on `wp_posts` table to improve media queries performance
|
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
|
08/15/2023
|
#61856
|
Add support for MySQL SSL connections
|
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
has-patch
|
08/13/2024
|
#59269
|
Add support for adding metadata in bulk
|
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
has-patch
|
09/01/2023
|
#54627
|
Adding More Timestamp columns to database
|
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
|
12/14/2021
|
#45354
|
Adding index for meta_key and post_id in postmeta
|
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
dev-feedback
|
06/24/2024
|
#52527
|
Better RAM handling in wp-db.php
|
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
|
02/15/2021
|
#39811
|
Bug maybe_unserialize() broke mysql data.
|
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
|
02/20/2017
|
#60077
|
Class UnexpectedValueException not found
|
|
normal
|
critical
|
Awaiting Review
|
defect (bug)
|
|
12/14/2023
|
#60505
|
Column names in wpdb->insert aren't sanitized.
|
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
|
02/12/2024
|
#56259
|
Database Repair doesn't check for missing primary keys / A.I.
|
|
normal
|
minor
|
Awaiting Review
|
enhancement
|
|
03/09/2023
|
#58559
|
Database error bug in wordpress current version
|
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
|
07/03/2023
|
#53958
|
Database: wp_postmeta - meta_key index
|
|
normal
|
major
|
Awaiting Review
|
defect (bug)
|
|
08/25/2021
|
#57385
|
Disable foreign key checks when dropping tables inside wp_uninitialize_site() function
|
johnjamesjacoby*
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
dev-feedback
|
01/12/2024
|
#60362
|
Emojis cause "Updating failed. Could not update post in the database." error
|
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
has-patch
|
02/08/2024
|
#40953
|
Empty values are handled inconsistently between wpdb->get_results() and wpdb->get_col()
|
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
dev-feedback
|
07/23/2024
|
#58694
|
Enhancement in wordpress Database API
|
|
normal
|
normal
|
Awaiting Review
|
feature request
|
|
08/30/2023
|
#41956
|
Errno in $wpdb
|
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
has-patch
|
08/17/2018
|
#55907
|
Failed to insert log entry: value too long
|
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
|
06/03/2022
|
#52210
|
File URL gets saved even when upload fails
|
|
normal
|
major
|
Awaiting Review
|
defect (bug)
|
|
02/09/2021
|
#61889
|
Function dbDelta() splits queries on semi-colon in column COMMENT and table COMMENT
|
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
has-patch
|
09/23/2024
|
#39748
|
Function to insert or update DB value
|
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
|
10/29/2017
|
#58286
|
Growing database due to unnecessary transients containing "g_url_details_response_"
|
|
normal
|
critical
|
Awaiting Review
|
defect (bug)
|
|
05/11/2023
|
#43019
|
Hook to validate post form data before save
|
|
normal
|
major
|
Awaiting Review
|
enhancement
|
has-patch
|
10/28/2021
|
#54836
|
Huge error logs filled with "WordPress database error Illegal mix of collations" errors caused by spammers
|
|
normal
|
critical
|
Awaiting Review
|
defect (bug)
|
|
08/12/2024
|
#50789
|
Improve WPDB logic around information_schema
|
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
|
06/11/2021
|
#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
|
#54070
|
Increase CPT "machine name" limit from its current maximum of 20 characters.
|
|
normal
|
normal
|
Awaiting Review
|
feature request
|
dev-feedback
|
11/08/2024
|
#44973
|
Issues with $wpdb->get_col_info
|
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
has-patch
|
09/23/2018
|
#59974
|
MAX_JOIN_SIZE wp-blog-header.php
|
|
normal
|
minor
|
Awaiting Review
|
defect (bug)
|
|
11/27/2023
|
#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
|
#62104
|
Multisite triggers UPDATE queries on _sitemeta of almost 150k character
|
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
has-patch
|
09/24/2024
|
#60503
|
MySQL VALUES function deprecated in MySQL 8
|
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
|
12/05/2024
|
#54834
|
Mysql gone away when importing DB on create wp_posts indexes
|
|
normal
|
blocker
|
Awaiting Review
|
defect (bug)
|
|
02/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
|
#49482
|
Non-english slug can sometimes cause an error in WordPress query
|
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
|
02/20/2020
|
#58826
|
Please add a default post relations table
|
|
normal
|
critical
|
Awaiting Review
|
enhancement
|
|
07/17/2023
|
#57283
|
Postmeta - Performance Improvement - Woocommerce
|
|
normal
|
critical
|
Awaiting Review
|
defect (bug)
|
|
12/06/2022
|
#62575
|
Prints SQL/DB error limit last_query too long
|
|
normal
|
normal
|
Awaiting Review
|
feature request
|
|
11/26/2024
|
#44386
|
Problem with utf8mb4_unicode_ci collation for arabic content
|
|
normal
|
major
|
Awaiting Review
|
enhancement
|
has-patch
|
06/17/2018
|
#54669
|
Remove ONLY_FULL_GROUP_BY from incompatible wpdb modes
|
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
needs-unit-tests
|
06/15/2022
|
#53033
|
Remove comments, ping, to_ping columns from posts table
|
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
|
04/15/2021
|
#54324
|
Rename Table Function - maybe_rename_table()
|
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
has-patch
|
01/09/2023
|
#54560
|
Return null from wpdb::get_results when query fails
|
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
has-patch
|
12/02/2021
|
#41278
|
SQL_CALC_FOUND_ROWS slow query
|
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
|
07/19/2017
|
#54235
|
Script for handling metadata in wp_postmeta
|
|
normal
|
normal
|
Awaiting Review
|
feature request
|
needs-docs
|
10/08/2021
|
#58180
|
Specify the REGEXP format for meta_query
|
|
normal
|
trivial
|
Awaiting Review
|
enhancement
|
needs-docs
|
08/01/2023
|
#61604
|
Split `wp_insert_post` in two
|
|
normal
|
minor
|
Awaiting Review
|
enhancement
|
|
07/09/2024
|
#59281
|
Support for Database Cursor
|
|
normal
|
normal
|
Awaiting Review
|
feature request
|
|
09/27/2023
|
#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
|
06/09/2022
|
#47994
|
The additions of a new wp_posts table columns called post_level and post_patriarch
|
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
|
09/06/2019
|
#51762
|
Unix authentication support via unix_socket
|
|
normal
|
normal
|
Awaiting Review
|
feature request
|
|
11/12/2020
|
#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
|
#41054
|
Use sargable date filtering where possible
|
|
normal
|
trivial
|
Awaiting Review
|
enhancement
|
|
12/05/2024
|
#59836
|
Using the pre_get_table_charset filter ensures wpdb->col_meta never gets populated
|
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
|
11/08/2023
|
#40150
|
VARCHAR/TEXT inefficiencies
|
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
|
03/14/2017
|
#55938
|
WP prefix on installation - instructions to be indicated
|
|
normal
|
minor
|
Awaiting Review
|
enhancement
|
|
06/07/2022
|
#43589
|
WPDB Update change NULL values to acceptable values
|
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
has-patch
|
01/17/2019
|
#42703
|
WP_Query: Swap parsing date into own method
|
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
|
01/16/2019
|
#53320
|
Why delete_metadata and update_metadata slow performance?
|
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
|
03/26/2024
|
#57072
|
WordPress 6.1 uses wrong database collation
|
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
|
11/11/2022
|
#58133
|
WordPress database error Illegal mix of collations
|
|
normal
|
major
|
Awaiting Review
|
defect (bug)
|
|
04/24/2023
|
#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
|
#41281
|
attachment_url_to_postid results in very slow query
|
joemcgill*
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
|
07/18/2024
|
#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
|
#59481
|
dbDelta do useless request when type case is not the same between query and describe result
|
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
has-patch
|
08/12/2024
|
#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
|