|
#46210
|
Add helpers for default/empty datetime value
|
|
has-patch
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
02/24/2023
|
|
#46146
|
dbDelta not parsing enum correctly
|
|
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
11/17/2022
|
|
#46145
|
dbDelta runs same updates on every execution
|
|
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
01/30/2019
|
|
#45697
|
Database: Upgrading field collations
|
|
|
normal
|
normal
|
Future Release
|
enhancement
|
08/22/2022
|
|
#45354
|
Adding index for meta_key and post_id in postmeta
|
|
dev-feedback
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
06/24/2024
|
|
#44973
|
Issues with $wpdb->get_col_info
|
|
has-patch
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
09/23/2018
|
|
#44386
|
Problem with utf8mb4_unicode_ci collation for arabic content
|
|
has-patch
|
normal
|
major
|
Awaiting Review
|
enhancement
|
06/17/2018
|
|
#44292
|
Make use of protected process_fields
|
|
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
06/01/2018
|
|
#43893
|
The maybe_create_table() function has two definitions
|
|
dev-feedback
|
low
|
normal
|
Awaiting Review
|
defect (bug)
|
09/01/2020
|
|
#43664
|
$wpdb->get_results fails in specific cases with non-latin charaters in where clause
|
|
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
04/08/2018
|
|
#43589
|
WPDB Update change NULL values to acceptable values
|
|
has-patch
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
01/17/2019
|
|
#43578
|
Unexpected MYSQL data format
|
|
dev-feedback
|
normal
|
normal
|
Future Release
|
defect (bug)
|
02/03/2020
|
|
#43019
|
Hook to validate post form data before save
|
|
has-patch
|
normal
|
major
|
Awaiting Review
|
enhancement
|
10/28/2021
|
|
#42703
|
WP_Query: Swap parsing date into own method
|
|
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
01/16/2019
|
|
#42352
|
Support use of native MySQLi prepared queries
|
|
early
|
normal
|
normal
|
Future Release
|
enhancement
|
09/26/2024
|
|
#41956
|
Errno in $wpdb
|
|
has-patch
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
08/17/2018
|
|
#41944
|
Add %u support to wpdb->prepare
|
|
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
09/21/2017
|
|
#41424
|
Use a better error message than "Error establishing a database connection" when site isn't found
|
|
needs-unit-tests
|
normal
|
normal
|
Future Release
|
enhancement
|
11/22/2017
|
|
#41281
|
attachment_url_to_postid results in very slow query
|
joemcgill*
|
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
07/18/2024
|
|
#41278
|
SQL_CALC_FOUND_ROWS slow query
|
|
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
07/19/2017
|
|
#41054
|
Use sargable date filtering where possible
|
|
|
normal
|
trivial
|
Awaiting Review
|
enhancement
|
12/05/2024
|
|
#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
|
|
#40779
|
function_exists() audit in wp-db.php
|
|
dev-feedback
|
low
|
minor
|
Awaiting Review
|
defect (bug)
|
06/01/2021
|
|
#40695
|
`install_blog` suppresses database errors
|
|
has-patch
|
normal
|
normal
|
Future Release
|
defect (bug)
|
06/01/2017
|
|
#40694
|
dbDelta uses suppressed errors to detect table absence
|
|
has-patch
|
normal
|
normal
|
Future Release
|
defect (bug)
|
12/01/2019
|
|
#40357
|
dbDelta can't change primary keys, create AUTO_INCREMENT columns and doesn't make significant index changes
|
|
needs-unit-tests
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
04/04/2017
|
|
#40150
|
VARCHAR/TEXT inefficiencies
|
|
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
03/14/2017
|
|
#40088
|
Stop creating the `wp_links` database table
|
|
close
|
normal
|
normal
|
Future Release
|
defect (bug)
|
08/10/2022
|
|
#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
|
|
#39811
|
Bug maybe_unserialize() broke mysql data.
|
|
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
02/20/2017
|
|
#39748
|
Function to insert or update DB value
|
|
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
10/29/2017
|
|
#39273
|
Updating to 4.7 can break serialized data because $wpdb->determine_charset now forces utf8 when DB_CHARSET is set to utf8mb4
|
|
dev-feedback
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
03/15/2019
|
|
#38921
|
Defining filter pre_get_table_charset causes errors
|
|
has-patch
|
normal
|
normal
|
Future Release
|
defect (bug)
|
05/27/2020
|
|
#38760
|
Capture result size in bytes when SAVEQUERIES is true
|
|
|
normal
|
normal
|
Future Release
|
enhancement
|
10/03/2017
|
|
#38036
|
Add support for the utf8mb4_0900_ai_ci collation
|
|
|
normal
|
normal
|
Future Release
|
enhancement
|
04/05/2023
|
|
#37678
|
Add an action hook for plugins to do database upgrades on
|
|
dev-feedback
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
06/24/2025
|
|
#37508
|
wpdb->result instance should be checked `mysqli_num_fields` in `load_col_info()`
|
|
needs-unit-tests
|
normal
|
normal
|
|
defect (bug)
|
06/04/2019
|
|
#36924
|
dbDelta(): Support more than one whitespace between field name and its type definition
|
|
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
08/10/2018
|
|
#36242
|
wpdb set_sql_mode add param
|
pbearne
|
dev-feedback
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
01/18/2025
|
|
#35256
|
$wpdb->insert_id equals 0
|
|
|
normal
|
normal
|
|
defect (bug)
|
06/04/2019
|
|
#34872
|
dbDelta Missing Index Name Creates Duplicate Indexes
|
|
has-patch
|
normal
|
normal
|
|
defect (bug)
|
06/04/2019
|
|
#32868
|
Consider running utf8mb4 conversion on each database update
|
|
|
normal
|
normal
|
|
defect (bug)
|
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
|
|
#31624
|
$wpdb->prepare() named placeholders
|
|
needs-unit-tests
|
normal
|
normal
|
|
enhancement
|
06/22/2023
|
|
#31042
|
WPDB field_types Variable Too Broad?
|
|
|
normal
|
normal
|
|
enhancement
|
06/04/2019
|
|
#31018
|
Persistent database connections with mysqli
|
|
needs-unit-tests
|
normal
|
normal
|
|
enhancement
|
08/01/2022
|
|
#30795
|
Upgrade bug affecting indexing
|
|
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
03/22/2019
|
|
#29938
|
mysqli_query and multiple resultsets
|
|
needs-unit-tests
|
normal
|
normal
|
|
enhancement
|
06/04/2019
|
|
#28625
|
Enhancement: Add constants to support SSL connections for mysqli
|
|
needs-unit-tests
|
normal
|
normal
|
Future Release
|
enhancement
|
06/24/2023
|
|
#28591
|
dbDelta Non-literal DEFAULT not working (CURRENT_TIMESTAMP)
|
|
|
normal
|
normal
|
|
defect (bug)
|
06/04/2019
|
|
#28139
|
WP MU legacy problems: missing database tables
|
|
|
normal
|
normal
|
|
defect (bug)
|
06/04/2019
|
|
#26858
|
Comment duplicate check has a slow query
|
pbearne
|
|
normal
|
normal
|
Future Release
|
defect (bug)
|
05/25/2025
|
|
#26788
|
Improve dbDelta fields match
|
|
has-patch
|
normal
|
normal
|
|
enhancement
|
06/04/2019
|
|
#21762
|
Storing a multidimensional array using register_setting double-serializes subarrays identified with a string
|
sekatsim
|
|
normal
|
normal
|
|
defect (bug)
|
06/04/2019
|
|
#20634
|
dbDelta is unforgiving about field declarations
|
|
dev-feedback
|
normal
|
normal
|
|
enhancement
|
06/04/2019
|
|
#18315
|
Add an index to the GUID column in the posts table
|
|
dev-feedback
|
normal
|
normal
|
|
enhancement
|
06/04/2019
|
|
#15499
|
Add an index for get_lastpostmodified query
|
OllieJones
|
dev-feedback
|
normal
|
normal
|
Future Release
|
enhancement
|
08/28/2025
|
|
#15332
|
dbDelta($query) - do not create view
|
|
needs-unit-tests
|
normal
|
normal
|
Future Release
|
feature request
|
05/25/2025
|
|
#13103
|
"Unknown character set" during install into database reports successful install.
|
barrykooij
|
has-patch
|
normal
|
normal
|
|
defect (bug)
|
06/04/2019
|
|
#12257
|
wpdb Scales Badly Due to Unnecessary Copies of All Query Results
|
|
dev-feedback
|
normal
|
critical
|
|
defect (bug)
|
06/04/2019
|
|
#10883
|
db-error.php not used for all DB failures
|
|
|
normal
|
normal
|
|
enhancement
|
04/30/2025
|
|
#10404
|
dbDelta creates duplicate indexes when index definition contains spaces
|
|
has-patch
|
normal
|
normal
|
|
enhancement
|
01/21/2023
|
|
#8924
|
autoload should be boolean in add_option()
|
|
|
lowest
|
normal
|
Awaiting Review
|
enhancement
|
03/15/2019
|
|
#8857
|
Make WP MySQL strict mode compliant
|
|
|
lowest
|
normal
|
|
enhancement
|
04/08/2025
|
|
#6492
|
Guids No Longer Have Permalink Format
|
|
|
normal
|
normal
|
Future Release
|
enhancement
|
08/30/2019
|
|
#64102
|
add label to date/time to show which string is the language default
|
SergeyBiryukov
|
|
normal
|
normal
|
7.0
|
enhancement
|
11/10/2025
|
|
#63772
|
get_calendar() shows incorrect month-end due to current_time() timezone issue
|
|
dev-feedback
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
08/02/2025
|
|
#63348
|
Missing “Create Date” on Draft Products
|
|
|
normal
|
critical
|
Awaiting Review
|
defect (bug)
|
04/25/2025
|
|
#61732
|
get_calendar() will use invalid dates in SQL queries
|
pbearne
|
has-patch
|
normal
|
normal
|
Future Release
|
defect (bug)
|
03/17/2025
|
|
#61223
|
Date Time and UTC / GTM Timezone is not synchronizing
|
|
close
|
normal
|
minor
|
Awaiting Review
|
defect (bug)
|
01/14/2025
|
|
#59941
|
PHPUnit test for wp_timezone_choice
|
|
commit
|
normal
|
normal
|
Future Release
|
defect (bug)
|
11/10/2025
|
|
#58774
|
Sorting Posts after Published Date OR Last Update should be a standard function
|
pbearne
|
reporter-feedback
|
normal
|
normal
|
Awaiting Review
|
feature request
|
11/04/2024
|
|
#57955
|
wp_localize_jquery_ui_datepicker parsing general settings date_format wrong
|
|
|
normal
|
minor
|
Awaiting Review
|
defect (bug)
|
03/20/2023
|
|
#57409
|
Post date/time selector on a different timezone than of the server's
|
pbearne
|
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
11/03/2025
|
|
#56887
|
wp_exif_date2ts throws notice on slash formatted date
|
pbearne*
|
has-patch
|
normal
|
normal
|
7.0
|
defect (bug)
|
11/07/2025
|
|
#55503
|
Post Date display issue if we set empty from General Settings page
|
pbearne
|
dev-feedback
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
12/13/2024
|
|
#55242
|
Time options in Settings have changed to uppercase AM and PM instead of lowercase
|
|
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
09/10/2025
|
|
#53780
|
PHP 8.1: DateTimeZone::getTransitions() change
|
|
close
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
02/07/2025
|
|
#53755
|
WordPress 5.8 DatePicker component crashes
|
|
close
|
normal
|
blocker
|
Awaiting Review
|
defect (bug)
|
12/13/2024
|
|
#52220
|
Weekly archives/week 53 incorrect crossing over a year change
|
Rarst*
|
needs-unit-tests
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
01/05/2021
|
|
#51945
|
Dates in REST API responses are incompatible with date-time JSON schema format
|
|
dev-feedback
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
12/07/2020
|
|
#51625
|
Date/Time test failures during DST transition
|
|
reporter-feedback
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
12/13/2024
|
|
#49414
|
wp_read_image_metadata should look for timezone offset
|
|
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
02/15/2020
|
|
#49413
|
wp_exif_date2ts should use Datetime and accept an optional offset
|
pbearne*
|
has-patch
|
low
|
normal
|
Future Release
|
defect (bug)
|
01/21/2025
|
|
#49396
|
Inconsistent Time format
|
|
|
normal
|
normal
|
|
feature request
|
11/05/2024
|
|
#49012
|
Date format output incorrect in Finnish
|
|
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
05/27/2024
|
|
#48936
|
Remove mysql2date() usage from core
|
pbearne
|
needs-unit-tests
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
05/06/2025
|
|
#48935
|
Need to Remove strtotime() usage from core
|
|
dev-feedback
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
11/05/2024
|
|
#48740
|
Add constant for database date format
|
|
dev-feedback
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
11/20/2019
|
|
#48207
|
Implement new Comment Date Functions
|
pbearne
|
has-patch
|
normal
|
normal
|
7.0
|
enhancement
|
10/20/2025
|
|
#48204
|
wp_exif_date2ts throws notice on empty date
|
pbearne*
|
has-patch
|
normal
|
minor
|
Future Release
|
defect (bug)
|
06/03/2025
|
|
#46609
|
Incorrect posts date on saving scheduled posts draft
|
|
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
12/05/2022
|
|
#46366
|
Posted Date - Field Arrangement - Reflect Locale Format OR Combine Fields
|
|
close
|
normal
|
trivial
|
|
enhancement
|
01/22/2025
|
|
#45047
|
user_registered returned as UTC Time instead of Local Time
|
|
has-patch
|
normal
|
normal
|
Future Release
|
defect (bug)
|
04/22/2020
|
|
#44597
|
Scheduling posts adds wrong seconds as post_date
|
|
close
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
01/15/2025
|
|
#43028
|
Remove numbers before month in dropdown, it makes user confused when drowdown is not opened
|
|
has-patch
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
06/22/2020
|
|
#41011
|
get_calendar generates query with invalid date formats
|
pbearne
|
has-patch
|
normal
|
normal
|
Future Release
|
defect (bug)
|
11/03/2025
|
|
#34435
|
Creating a post might fail during fall's DST switch due to ambiguous time
|
|
needs-docs
|
normal
|
normal
|
Future Release
|
defect (bug)
|
05/30/2019
|
|
#32386
|
Draft's Last Modified date incorrect if it is Scheduled
|
obenland
|
|
normal
|
normal
|
Future Release
|
defect (bug)
|
10/07/2020
|
|
#29849
|
Better human_time_diff()
|
audrasjb
|
has-patch
|
normal
|
normal
|
Future Release
|
enhancement
|
10/20/2025
|