|
#39273
|
Updating to 4.7 can break serialized data because $wpdb->determine_charset now forces utf8 when DB_CHARSET is set to utf8mb4
|
|
Database
|
normal
|
normal
|
4
|
Awaiting Review
|
defect (bug)
|
dev-feedback
|
7 years ago
|
|
#38036
|
Add support for the utf8mb4_0900_ai_ci collation
|
|
Database
|
normal
|
normal
|
4
|
Future Release
|
enhancement
|
|
3 years ago
|
|
#62512
|
Add "Learn WordPress" Links to the "WordPress Events and News" Dashboard Widget
|
|
Database
|
normal
|
normal
|
4
|
Awaiting Review
|
feature request
|
has-patch
|
15 months ago
|
|
#54836
|
Huge error logs filled with "WordPress database error Illegal mix of collations" errors caused by spammers
|
|
Database
|
normal
|
critical
|
3
|
Awaiting Review
|
defect (bug)
|
|
17 months ago
|
|
#62976
|
Multiple queries executing - Bulk deletion
|
|
Database
|
normal
|
critical
|
3
|
Awaiting Review
|
defect (bug)
|
dev-feedback
|
6 months ago
|
|
#51486
|
The add_option function should not be able to update existing rows in the database.
|
|
Database
|
normal
|
normal
|
3
|
Awaiting Review
|
defect (bug)
|
has-patch
|
2 months ago
|
|
#63678
|
WordPress redirect to wp-admin/install.php when a user is rate limited in mysql
|
johnbillion
|
Database
|
normal
|
normal
|
3
|
7.2
|
defect (bug)
|
has-patch
|
5 weeks ago
|
|
#28591
|
dbDelta Non-literal DEFAULT not working (CURRENT_TIMESTAMP)
|
|
Database
|
normal
|
normal
|
3
|
|
defect (bug)
|
|
7 years ago
|
|
#31624
|
$wpdb->prepare() named placeholders
|
|
Database
|
normal
|
normal
|
3
|
|
enhancement
|
needs-unit-tests
|
3 years ago
|
|
#18315
|
Add an index to the GUID column in the posts table
|
|
Database
|
normal
|
normal
|
3
|
|
enhancement
|
dev-feedback
|
7 years ago
|
|
#54627
|
Adding More Timestamp columns to database
|
|
Database
|
normal
|
normal
|
3
|
Awaiting Review
|
enhancement
|
|
5 years ago
|
|
#58344
|
Connect to database on first query
|
|
Database
|
normal
|
normal
|
3
|
Future Release
|
enhancement
|
has-patch
|
16 months ago
|
|
#56091
|
Using %i for table/field names in wpdb::prepare()
|
craigfrancis
|
Database
|
low
|
minor
|
3
|
Future Release
|
enhancement
|
has-patch
|
2 years ago
|
|
#40150
|
VARCHAR/TEXT inefficiencies
|
|
Database
|
normal
|
normal
|
3
|
Awaiting Review
|
enhancement
|
|
9 years ago
|
|
#40357
|
dbDelta can't change primary keys, create AUTO_INCREMENT columns and doesn't make significant index changes
|
|
Database
|
normal
|
normal
|
3
|
Awaiting Review
|
enhancement
|
needs-unit-tests
|
7 months ago
|
|
#15332
|
dbDelta($query) - do not create view
|
|
Database
|
normal
|
normal
|
3
|
Future Release
|
feature request
|
needs-unit-tests
|
15 months ago
|
|
#65709
|
Both CUSTOM_USER_TABLE and CUSTOM_USER_META_TABLE are not checked for non empty string
|
|
Database
|
normal
|
normal
|
2
|
Awaiting Review
|
defect (bug)
|
has-patch
|
4 days ago
|
|
#53958
|
Database: wp_postmeta - meta_key index
|
|
Database
|
normal
|
major
|
2
|
Awaiting Review
|
defect (bug)
|
|
5 years ago
|
|
#40953
|
Empty values are handled inconsistently between wpdb->get_results() and wpdb->get_col()
|
|
Database
|
normal
|
normal
|
2
|
Awaiting Review
|
defect (bug)
|
dev-feedback
|
19 months ago
|
|
#60503
|
MySQL VALUES function deprecated in MySQL 8
|
|
Database
|
normal
|
minor
|
2
|
Awaiting Review
|
defect (bug)
|
close
|
20 months ago
|
|
#57283
|
Postmeta - Performance Improvement - Woocommerce
|
|
Database
|
normal
|
critical
|
2
|
Awaiting Review
|
defect (bug)
|
|
4 years ago
|
|
#64130
|
Type error in /wp-includes/class-wpdb.php
|
|
Database
|
normal
|
normal
|
2
|
Awaiting Review
|
defect (bug)
|
has-patch
|
2 hours ago
|
|
#43578
|
Unexpected MYSQL data format
|
|
Database
|
normal
|
normal
|
2
|
Future Release
|
defect (bug)
|
dev-feedback
|
7 years ago
|
|
#57072
|
WordPress 6.1 uses wrong database collation
|
|
Database
|
normal
|
normal
|
2
|
Awaiting Review
|
defect (bug)
|
|
4 years ago
|
|
#49785
|
Wrong result / duplicates in query when using MariaDB
|
|
Database
|
normal
|
normal
|
2
|
Awaiting Review
|
defect (bug)
|
|
6 years ago
|
|
#46146
|
dbDelta not parsing enum correctly
|
|
Database
|
normal
|
normal
|
2
|
Awaiting Review
|
defect (bug)
|
has-patch
|
2 months ago
|
|
#40694
|
dbDelta uses suppressed errors to detect table absence
|
|
Database
|
normal
|
normal
|
2
|
Future Release
|
defect (bug)
|
has-patch
|
7 years ago
|
|
#57149
|
get_table_from_query() doesn't properly handle a prepared escape_like() table name
|
|
Database
|
normal
|
normal
|
2
|
Awaiting Review
|
defect (bug)
|
|
4 years ago
|
|
#62342
|
wpdb->get_table_from_query: preg_match(): Passing null to parameter #2 ($subject) of type string is deprecated
|
|
Database
|
normal
|
normal
|
2
|
Future Release
|
defect (bug)
|
has-patch
|
10 months ago
|
|
#37508
|
wpdb->result instance should be checked `mysqli_num_fields` in `load_col_info()`
|
|
Database
|
normal
|
normal
|
2
|
|
defect (bug)
|
needs-unit-tests
|
7 years ago
|
|
#46947
|
‘❤’ in Comment Generates DB Error
|
|
Database
|
normal
|
normal
|
2
|
Future Release
|
defect (bug)
|
reporter-feedback
|
10 months ago
|
|
#41944
|
Add %u support to wpdb->prepare
|
|
Database
|
normal
|
normal
|
2
|
Awaiting Review
|
enhancement
|
|
9 years ago
|
|
#38760
|
Capture result size in bytes when SAVEQUERIES is true
|
|
Database
|
normal
|
normal
|
2
|
Future Release
|
enhancement
|
|
9 years ago
|
|
#39826
|
LIMIT clause not required in get_options function as there's already a UNIQUE KEY on option_name
|
|
Database
|
normal
|
normal
|
2
|
Awaiting Review
|
enhancement
|
dev-feedback
|
6 years ago
|
|
#49654
|
maybe_drop_table
|
|
Database
|
normal
|
normal
|
2
|
Awaiting Review
|
enhancement
|
|
3 years ago
|
|
#29938
|
mysqli_query and multiple resultsets
|
|
Database
|
normal
|
normal
|
2
|
|
enhancement
|
needs-unit-tests
|
7 years ago
|
|
#46576
|
short-circuit filter for dbDelta
|
|
Database
|
normal
|
normal
|
2
|
Awaiting Review
|
enhancement
|
|
7 years ago
|
|
#58871
|
support uca14.0.0 collation in database where available
|
|
Database
|
normal
|
normal
|
2
|
Awaiting Review
|
enhancement
|
has-patch
|
11 months ago
|
|
#36242
|
wpdb set_sql_mode add param
|
pbearne
|
Database
|
normal
|
normal
|
2
|
Awaiting Review
|
enhancement
|
dev-feedback
|
19 months ago
|
|
#58694
|
Enhancement in wordpress Database API
|
|
Database
|
normal
|
normal
|
2
|
Awaiting Review
|
feature request
|
|
3 years ago
|
|
#59281
|
Support for Database Cursor
|
|
Database
|
normal
|
normal
|
2
|
Awaiting Review
|
feature request
|
|
3 years ago
|
|
#13103
|
"Unknown character set" during install into database reports successful install.
|
|
Database
|
normal
|
normal
|
1
|
|
defect (bug)
|
has-patch
|
7 weeks ago
|
|
#43664
|
$wpdb->get_results fails in specific cases with non-latin charaters in where clause
|
|
Database
|
normal
|
normal
|
1
|
Awaiting Review
|
defect (bug)
|
|
8 years ago
|
|
#65626
|
7.0.1 9.9797 lagging at WP_Query->get_posts() on site with 16K= posts
|
|
Database
|
normal
|
normal
|
1
|
Awaiting Review
|
defect (bug)
|
reporter-feedback
|
5 weeks ago
|
|
#54801
|
Avoid WPDB errors when examining installation state of a site/network
|
|
Database
|
normal
|
normal
|
1
|
Future Release
|
defect (bug)
|
has-patch
|
4 years ago
|
|
#60077
|
Class UnexpectedValueException not found
|
|
Database
|
normal
|
critical
|
1
|
Awaiting Review
|
defect (bug)
|
|
3 years ago
|
|
#32868
|
Consider running utf8mb4 conversion on each database update
|
|
Database
|
normal
|
normal
|
1
|
|
defect (bug)
|
|
7 years ago
|
|
#38921
|
Defining filter pre_get_table_charset causes errors
|
|
Database
|
normal
|
normal
|
1
|
Future Release
|
defect (bug)
|
has-patch
|
8 months ago
|
|
#61889
|
Function dbDelta() splits queries on semi-colon in column COMMENT and table COMMENT
|
|
Database
|
normal
|
normal
|
1
|
Awaiting Review
|
defect (bug)
|
has-patch
|
16 months ago
|
|
#55610
|
HTTP response should not be 200 when returning error-page
|
|
Database
|
normal
|
major
|
1
|
Awaiting Review
|
defect (bug)
|
|
12 months ago
|
|
#50789
|
Improve WPDB logic around information_schema
|
|
Database
|
normal
|
normal
|
1
|
Awaiting Review
|
defect (bug)
|
|
5 years ago
|
|
#54834
|
Mysql gone away when importing DB on create wp_posts indexes
|
|
Database
|
normal
|
blocker
|
1
|
Awaiting Review
|
defect (bug)
|
|
4 years ago
|
|
#52648
|
Problem with certain passwords not working to login to mysql db
|
|
Database
|
normal
|
major
|
1
|
Awaiting Review
|
defect (bug)
|
reporter-feedback
|
5 years ago
|
|
#43893
|
The maybe_create_table() function has two definitions
|
|
Database
|
low
|
normal
|
1
|
Awaiting Review
|
defect (bug)
|
dev-feedback
|
6 years ago
|
|
#43589
|
WPDB Update change NULL values to acceptable values
|
|
Database
|
normal
|
normal
|
1
|
Awaiting Review
|
defect (bug)
|
has-patch
|
8 years ago
|
|
#58133
|
WordPress database error Illegal mix of collations
|
|
Database
|
normal
|
major
|
1
|
Awaiting Review
|
defect (bug)
|
|
3 years ago
|
|
#34872
|
dbDelta Missing Index Name Creates Duplicate Indexes
|
|
Database
|
normal
|
normal
|
1
|
|
defect (bug)
|
has-patch
|
7 years ago
|
|
#46932
|
dbDelta does not account for MySQL keywords being used as key names
|
|
Database
|
normal
|
minor
|
1
|
Awaiting Review
|
defect (bug)
|
|
7 years ago
|
|
#46145
|
dbDelta runs same updates on every execution
|
|
Database
|
normal
|
normal
|
1
|
Awaiting Review
|
defect (bug)
|
|
8 years ago
|
|
#55206
|
wp core api memory leaks
|
|
Database
|
normal
|
normal
|
1
|
Awaiting Review
|
defect (bug)
|
dev-feedback
|
4 years ago
|
|
#61338
|
wpdb::prepare function null value convert to empty String
|
|
Database
|
normal
|
normal
|
1
|
Awaiting Review
|
defect (bug)
|
|
23 months ago
|
|
#55202
|
A proper (error) message should be show when mysql setting autocommit=0
|
|
Database
|
normal
|
normal
|
1
|
Awaiting Review
|
enhancement
|
|
4 years ago
|
|
#54642
|
Add prepared query builder support for `$wpdb` to build prepared queries across multiple location.
|
|
Database
|
normal
|
normal
|
1
|
Future Release
|
enhancement
|
has-patch
|
4 years ago
|
|
#59106
|
Add secondary index on `wp_posts` table to improve media queries performance
|
|
Database
|
normal
|
normal
|
1
|
Awaiting Review
|
enhancement
|
|
3 years ago
|
|
#61856
|
Add support for MySQL SSL connections
|
|
Database
|
normal
|
normal
|
1
|
Awaiting Review
|
enhancement
|
has-patch
|
2 years ago
|
|
#52527
|
Better RAM handling in wp-db.php
|
|
Database
|
normal
|
normal
|
1
|
Awaiting Review
|
enhancement
|
|
6 years ago
|
|
#56259
|
Database Repair doesn't check for missing primary keys / A.I.
|
|
Database
|
normal
|
minor
|
1
|
Awaiting Review
|
enhancement
|
|
3 years ago
|
|
#39748
|
Function to insert or update DB value
|
|
Database
|
normal
|
normal
|
1
|
Awaiting Review
|
enhancement
|
|
9 years ago
|
|
#26788
|
Improve dbDelta fields match
|
|
Database
|
normal
|
normal
|
1
|
|
enhancement
|
has-patch
|
7 years ago
|
|
#44292
|
Make use of protected process_fields
|
|
Database
|
normal
|
normal
|
1
|
Awaiting Review
|
enhancement
|
|
8 years ago
|
|
#46565
|
Mixed engine in tables, could bring to major WP failure! Also there is a small fix that could avoid that.
|
|
Database
|
normal
|
normal
|
1
|
Awaiting Review
|
enhancement
|
|
7 years ago
|
|
#61071
|
Need to display appropriate error messages when the database table is empty or corrupted.
|
|
Database
|
normal
|
normal
|
1
|
Awaiting Review
|
enhancement
|
dev-feedback
|
20 months ago
|
|
#58826
|
Please add a default post relations table
|
|
Database
|
normal
|
critical
|
1
|
Awaiting Review
|
enhancement
|
|
3 years ago
|
|
#54324
|
Rename Table Function - maybe_rename_table()
|
|
Database
|
normal
|
normal
|
1
|
Awaiting Review
|
enhancement
|
has-patch
|
4 years ago
|
|
#61604
|
Split `wp_insert_post` in two
|
|
Database
|
normal
|
minor
|
1
|
Awaiting Review
|
enhancement
|
|
2 years ago
|
|
#41054
|
Use sargable date filtering where possible
|
|
Database
|
normal
|
trivial
|
1
|
Awaiting Review
|
enhancement
|
|
21 months ago
|
|
#8924
|
autoload should be boolean in add_option()
|
|
Database
|
lowest
|
normal
|
1
|
Awaiting Review
|
enhancement
|
|
7 years ago
|
|
#46287
|
Add insert_ignore() method to wpdb to avoid unecessary boilerplate code
|
|
Database
|
normal
|
normal
|
1
|
Awaiting Review
|
feature request
|
has-patch
|
15 months ago
|
|
#63966
|
Database Extensions for Federation Support and Compatibility at the WordPress Core Level
|
|
Database
|
normal
|
normal
|
1
|
Awaiting Review
|
feature request
|
close
|
11 months ago
|
|
#51762
|
Unix authentication support via unix_socket
|
|
Database
|
normal
|
normal
|
1
|
Awaiting Review
|
feature request
|
|
6 years ago
|
|
#53780
|
PHP 8.1: DateTimeZone::getTransitions() change
|
|
Date/Time
|
normal
|
normal
|
6
|
Awaiting Review
|
defect (bug)
|
close
|
19 months ago
|
|
#65281
|
Custom Time & Date Format Fields Allow Empty Save Instead of Validation
|
|
Date/Time
|
normal
|
normal
|
5
|
Awaiting Review
|
defect (bug)
|
has-patch
|
2 months ago
|
|
#43028
|
Remove numbers before month in dropdown, it makes user confused when drowdown is not opened
|
|
Date/Time
|
normal
|
normal
|
5
|
Awaiting Review
|
defect (bug)
|
has-patch
|
6 years ago
|
|
#52220
|
Weekly archives/week 53 incorrect crossing over a year change
|
Rarst*
|
Date/Time
|
normal
|
normal
|
5
|
Awaiting Review
|
defect (bug)
|
has-patch
|
4 days ago
|
|
#48936
|
Remove mysql2date() usage from core
|
pbearne
|
Date/Time
|
normal
|
normal
|
5
|
Awaiting Review
|
enhancement
|
needs-unit-tests
|
16 months ago
|
|
#44597
|
Scheduling posts adds wrong seconds as post_date
|
|
Date/Time
|
normal
|
normal
|
4
|
Awaiting Review
|
defect (bug)
|
close
|
19 months ago
|
|
#41011
|
get_calendar generates query with invalid date formats
|
pbearne
|
Date/Time
|
normal
|
normal
|
4
|
Future Release
|
defect (bug)
|
has-patch
|
10 months ago
|
|
#48740
|
Add constant for database date format
|
|
Date/Time
|
normal
|
normal
|
4
|
Awaiting Review
|
enhancement
|
dev-feedback
|
7 years ago
|
|
#32386
|
Draft's Last Modified date incorrect if it is Scheduled
|
obenland
|
Date/Time
|
normal
|
normal
|
3
|
Future Release
|
defect (bug)
|
|
6 years ago
|
|
#53755
|
WordPress 5.8 DatePicker component crashes
|
|
Date/Time
|
normal
|
blocker
|
3
|
Awaiting Review
|
defect (bug)
|
close
|
20 months ago
|
|
#26980
|
the_modified_date is lower than the_date when post is scheduled
|
|
Date/Time
|
normal
|
normal
|
3
|
Awaiting Review
|
defect (bug)
|
has-patch
|
5 years ago
|
|
#49413
|
wp_exif_date2ts should use Datetime and accept an optional offset
|
pbearne*
|
Date/Time
|
low
|
normal
|
3
|
Future Release
|
defect (bug)
|
has-patch
|
19 months ago
|
|
#48207
|
Implement new Comment Date Functions
|
pbearne
|
Date/Time
|
normal
|
normal
|
3
|
Future Release
|
enhancement
|
has-patch
|
5 weeks ago
|
|
#34435
|
Creating a post might fail during fall's DST switch due to ambiguous time
|
|
Date/Time
|
normal
|
normal
|
2
|
Future Release
|
defect (bug)
|
needs-docs
|
7 years ago
|
|
#51945
|
Dates in REST API responses are incompatible with date-time JSON schema format
|
|
Date/Time
|
normal
|
normal
|
2
|
Awaiting Review
|
defect (bug)
|
dev-feedback
|
6 years ago
|
|
#55503
|
Post Date display issue if we set empty from General Settings page
|
pbearne
|
Date/Time
|
normal
|
normal
|
2
|
Awaiting Review
|
defect (bug)
|
dev-feedback
|
20 months ago
|
|
#57409
|
Post date/time selector on a different timezone than of the server's
|
pbearne
|
Date/Time
|
normal
|
normal
|
2
|
Awaiting Review
|
defect (bug)
|
|
8 months ago
|
|
#48204
|
wp_exif_date2ts throws notice on empty date
|
pbearne*
|
Date/Time
|
normal
|
minor
|
2
|
Future Release
|
defect (bug)
|
has-patch
|
15 months ago
|
|
#56887
|
wp_exif_date2ts throws notice on slash formatted date
|
pbearne*
|
Date/Time
|
normal
|
normal
|
2
|
7.2
|
defect (bug)
|
has-patch
|
3 weeks ago
|
|
#48935
|
Need to Remove strtotime() usage from core
|
|
Date/Time
|
normal
|
normal
|
2
|
Awaiting Review
|
enhancement
|
dev-feedback
|
22 months ago
|