1
|
#54801
|
Avoid WPDB errors when examining installation state of a site/network
|
|
Database
|
normal
|
normal
|
Future Release
|
defect (bug)
|
has-patch
|
09/27/2022
|
|
#39811
|
Bug maybe_unserialize() broke mysql data.
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
|
02/20/2017
|
1
|
#60077
|
Class UnexpectedValueException not found
|
|
Database
|
normal
|
critical
|
Awaiting Review
|
defect (bug)
|
|
12/14/2023
|
|
#60505
|
Column names in wpdb->insert aren't sanitized.
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
|
02/12/2024
|
7
|
#26858
|
Comment duplicate check has a slow query
|
pbearne
|
Database
|
normal
|
normal
|
Future Release
|
defect (bug)
|
has-patch
|
05/24/2024
|
|
#58559
|
Database error bug in wordpress current version
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
|
07/03/2023
|
2
|
#53958
|
Database: wp_postmeta - meta_key index
|
|
Database
|
normal
|
major
|
Awaiting Review
|
defect (bug)
|
|
08/25/2021
|
1
|
#38921
|
Defining filter pre_get_table_charset causes errors
|
|
Database
|
normal
|
normal
|
Future Release
|
defect (bug)
|
has-patch
|
05/27/2020
|
4
|
#60037
|
Differentiate between minimum required MySQL and MariaDB versions
|
|
Database
|
normal
|
normal
|
Future Release
|
defect (bug)
|
|
02/16/2024
|
|
#57385
|
Disable foreign key checks when dropping tables inside wp_uninitialize_site() function
|
johnjamesjacoby*
|
Database
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
dev-feedback
|
01/12/2024
|
2
|
#60362
|
Emojis cause "Updating failed. Could not update post in the database." error
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
has-patch
|
02/08/2024
|
2
|
#40953
|
Empty values are handled inconsistently between wpdb->get_results() and wpdb->get_col()
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
dev-feedback
|
07/23/2024
|
|
#55907
|
Failed to insert log entry: value too long
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
|
06/03/2022
|
|
#52210
|
File URL gets saved even when upload fails
|
|
Database
|
normal
|
major
|
Awaiting Review
|
defect (bug)
|
|
02/09/2021
|
|
#61889
|
Function dbDelta() splits queries on semi-colon in column COMMENT and table COMMENT
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
has-patch
|
09/23/2024
|
|
#58286
|
Growing database due to unnecessary transients containing "g_url_details_response_"
|
|
Database
|
normal
|
critical
|
Awaiting Review
|
defect (bug)
|
|
05/11/2023
|
3
|
#54836
|
Huge error logs filled with "WordPress database error Illegal mix of collations" errors caused by spammers
|
|
Database
|
normal
|
critical
|
Awaiting Review
|
defect (bug)
|
|
08/12/2024
|
6
|
#40418
|
ID columns in multisite database tables should be unsigned
|
flixos90
|
Database
|
normal
|
major
|
Awaiting Review
|
defect (bug)
|
dev-feedback
|
09/11/2018
|
7
|
#52496
|
Improve MySQL 8.0 support
|
|
Database
|
normal
|
normal
|
Future Release
|
defect (bug)
|
|
02/05/2024
|
1
|
#50789
|
Improve WPDB logic around information_schema
|
|
Database
|
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.
|
|
Database
|
normal
|
minor
|
Awaiting Review
|
defect (bug)
|
|
10/26/2022
|
|
#44973
|
Issues with $wpdb->get_col_info
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
has-patch
|
09/23/2018
|
|
#59974
|
MAX_JOIN_SIZE wp-blog-header.php
|
|
Database
|
normal
|
minor
|
Awaiting Review
|
defect (bug)
|
|
11/27/2023
|
|
#62104
|
Multisite triggers UPDATE queries on _sitemeta of almost 150k character
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
has-patch
|
09/24/2024
|
1
|
#60503
|
MySQL VALUES function deprecated in MySQL 8
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
|
02/12/2024
|
1
|
#54834
|
Mysql gone away when importing DB on create wp_posts indexes
|
|
Database
|
normal
|
blocker
|
Awaiting Review
|
defect (bug)
|
|
02/17/2023
|
|
#58965
|
No luck running WP when running PHP 8.2.8 + mysql Ver 15.1
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
|
08/02/2023
|
|
#49482
|
Non-english slug can sometimes cause an error in WordPress query
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
|
02/20/2020
|
2
|
#57283
|
Postmeta - Performance Improvement - Woocommerce
|
|
Database
|
normal
|
critical
|
Awaiting Review
|
defect (bug)
|
|
12/06/2022
|
1
|
#52648
|
Problem with certain passwords not working to login to mysql db
|
|
Database
|
normal
|
major
|
Awaiting Review
|
defect (bug)
|
reporter-feedback
|
02/25/2021
|
|
#53033
|
Remove comments, ping, to_ping columns from posts table
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
|
04/15/2021
|
|
#41278
|
SQL_CALC_FOUND_ROWS slow query
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
|
07/19/2017
|
5
|
#40088
|
Stop creating the `wp_links` database table
|
|
Database
|
normal
|
normal
|
Future Release
|
defect (bug)
|
close
|
08/10/2022
|
2
|
#51486
|
The add_option function should not be able to update existing rows in the database.
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
needs-unit-tests
|
06/09/2022
|
1
|
#43893
|
The maybe_create_table() function has two definitions
|
|
Database
|
low
|
normal
|
Awaiting Review
|
defect (bug)
|
dev-feedback
|
09/01/2020
|
2
|
#43578
|
Unexpected MYSQL data format
|
|
Database
|
normal
|
normal
|
Future Release
|
defect (bug)
|
dev-feedback
|
02/03/2020
|
4
|
#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
|
Awaiting Review
|
defect (bug)
|
dev-feedback
|
03/15/2019
|
|
#30795
|
Upgrade bug affecting indexing
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
|
03/22/2019
|
|
#59836
|
Using the pre_get_table_charset filter ensures wpdb->col_meta never gets populated
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
|
11/08/2023
|
1
|
#43589
|
WPDB Update change NULL values to acceptable values
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
has-patch
|
01/17/2019
|
|
#53320
|
Why delete_metadata and update_metadata slow performance?
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
|
03/26/2024
|
2
|
#57072
|
WordPress 6.1 uses wrong database collation
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
|
11/11/2022
|
1
|
#58133
|
WordPress database error Illegal mix of collations
|
|
Database
|
normal
|
major
|
Awaiting Review
|
defect (bug)
|
|
04/24/2023
|
2
|
#41302
|
WordPress not stopping queries which have reached limit and preventing users to load WordPress until query times out
|
|
Database
|
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
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
dev-feedback
|
11/11/2017
|
2
|
#49785
|
Wrong result / duplicates in query when using MariaDB
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
|
04/03/2020
|
|
#40695
|
`install_blog` suppresses database errors
|
|
Database
|
normal
|
normal
|
Future Release
|
defect (bug)
|
has-patch
|
06/01/2017
|
|
#59481
|
dbDelta do useless request when type case is not the same between query and describe result
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
has-patch
|
08/12/2024
|
1
|
#46932
|
dbDelta does not account for MySQL keywords being used as key names
|
|
Database
|
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
|
|
Database
|
normal
|
trivial
|
Awaiting Review
|
defect (bug)
|
|
03/09/2019
|
2
|
#46146
|
dbDelta not parsing enum correctly
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
|
11/17/2022
|
1
|
#46145
|
dbDelta runs same updates on every execution
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
|
01/30/2019
|
2
|
#40694
|
dbDelta uses suppressed errors to detect table absence
|
|
Database
|
normal
|
normal
|
Future Release
|
defect (bug)
|
has-patch
|
12/01/2019
|
|
#56533
|
dbDelta() ignores changes to column nullability (NULL/NOT NULL)
|
|
Database
|
normal
|
major
|
Awaiting Review
|
defect (bug)
|
reporter-feedback
|
09/08/2022
|
|
#36924
|
dbDelta(): Support more than one whitespace between field name and its type definition
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
|
08/10/2018
|
|
#40779
|
function_exists() audit in wp-db.php
|
|
Database
|
low
|
minor
|
Awaiting Review
|
defect (bug)
|
dev-feedback
|
06/01/2021
|
2
|
#57149
|
get_table_from_query() doesn't properly handle a prepared escape_like() table name
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
|
01/04/2023
|
2
|
#51350
|
mysql nosql feature request
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
|
04/20/2023
|
|
#46739
|
post attributes order not working correctly
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
|
03/30/2019
|
|
#51097
|
post cannot be saved due to certain variant of Japanese Kanji
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
close
|
08/31/2020
|
|
#41469
|
test_charset_switched_to_utf8() is not tested on Travis CI
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
|
07/28/2017
|
|
#46625
|
username and password automatically change to dexter
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
|
03/24/2019
|
1
|
#55206
|
wp core api memory leaks
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
dev-feedback
|
04/29/2022
|
|
#60983
|
wp update 6.5 and 6.5.2 rewrite multisite bdd entries wp_options.siteurl and wp_options.home
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
|
04/10/2024
|
|
#59172
|
wp_query meta_query NOT EXISTS not creating correct sql query
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
reporter-feedback
|
09/05/2023
|
|
#57000
|
wp_usermeta table is emptied because of a wrong query being executed
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
|
11/04/2022
|
|
#61338
|
wpdb::prepare function null value convert to empty String
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
|
10/02/2024
|
|
#49363
|
wpdb::query() does not detect LOAD DATA as an insert statement type
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
has-patch
|
02/05/2020
|
1
|
#46947
|
‘❤’ in Comment Generates DB Error
|
|
Database
|
normal
|
normal
|
Future Release
|
defect (bug)
|
reporter-feedback
|
04/17/2019
|
2
|
#34435
|
Creating a post might fail during fall's DST switch due to ambiguous time
|
|
Date/Time
|
normal
|
normal
|
Future Release
|
defect (bug)
|
needs-docs
|
05/30/2019
|
1
|
#61223
|
Date Time and UTC / GTM Timezone is not synchronizing
|
|
Date/Time
|
normal
|
major
|
Awaiting Review
|
defect (bug)
|
|
06/12/2024
|
1
|
#55339
|
Date changes to ordered list (and default 1. 1.) when at beginning of line
|
|
Date/Time
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
|
03/08/2022
|
1
|
#49012
|
Date format output incorrect in Finnish
|
|
Date/Time
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
|
05/27/2024
|
|
#51625
|
Date/Time test failures during DST transition
|
|
Date/Time
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
|
10/25/2020
|
2
|
#51945
|
Dates in REST API responses are incompatible with date-time JSON schema format
|
|
Date/Time
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
dev-feedback
|
12/07/2020
|
1
|
#51289
|
Documentation issue: get_post_time is getting the time when published not when created
|
SergeyBiryukov
|
Date/Time
|
normal
|
normal
|
Future Release
|
defect (bug)
|
has-patch
|
02/13/2022
|
3
|
#32386
|
Draft's Last Modified date incorrect if it is Scheduled
|
obenland
|
Date/Time
|
normal
|
normal
|
Future Release
|
defect (bug)
|
|
10/07/2020
|
2
|
#48207
|
Implement new Comment Date Functions
|
|
Date/Time
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
needs-unit-tests
|
11/08/2019
|
1
|
#46609
|
Incorrect posts date on saving scheduled posts draft
|
|
Date/Time
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
|
12/05/2022
|
2
|
#53236
|
Nonce lifespans are inaccurate and unintuitively affected by timezones
|
|
Date/Time
|
normal
|
minor
|
Awaiting Review
|
defect (bug)
|
needs-unit-tests
|
06/02/2021
|
5
|
#53780
|
PHP 8.1: DateTimeZone::getTransitions() change
|
|
Date/Time
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
close
|
08/03/2022
|
|
#59941
|
PHPUnit test for wp_timezone_choice
|
pbearne
|
Date/Time
|
normal
|
normal
|
Future Release
|
defect (bug)
|
has-patch
|
10/09/2024
|
2
|
#55503
|
Post Date display issue if we set empty from General Settings page
|
|
Date/Time
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
|
03/31/2022
|
1
|
#57409
|
Post date/time selector on a different timezone than of the server's
|
|
Date/Time
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
|
04/05/2024
|
5
|
#43028
|
Remove numbers before month in dropdown, it makes user confused when drowdown is not opened
|
|
Date/Time
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
has-patch
|
06/22/2020
|
3
|
#44597
|
Scheduling posts adds wrong seconds as post_date
|
|
Date/Time
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
|
08/25/2020
|
1
|
#55242
|
Time options in Settings have changed to uppercase AM and PM instead of lowercase
|
|
Date/Time
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
|
03/08/2022
|
3
|
#52220
|
Weekly archives/week 53 incorrect crossing over a year change
|
Rarst*
|
Date/Time
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
needs-unit-tests
|
01/05/2021
|
1
|
#26798
|
While inserting a post some values for 'post_date' throw a PHP exception
|
|
Date/Time
|
normal
|
normal
|
Future Release
|
defect (bug)
|
changes-requested
|
07/14/2022
|
3
|
#53755
|
WordPress 5.8 DatePicker component crashes
|
|
Date/Time
|
normal
|
blocker
|
Awaiting Review
|
defect (bug)
|
|
07/30/2021
|
3
|
#41011
|
get_calendar generates query with invalid date formats
|
|
Date/Time
|
normal
|
normal
|
Future Release
|
defect (bug)
|
|
09/22/2020
|
|
#61732
|
get_calendar() will use invalid dates in SQL queries
|
|
Date/Time
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
needs-unit-tests
|
10/03/2024
|
3
|
#26980
|
the_modified_date is lower than the_date when post is scheduled
|
|
Date/Time
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
has-patch
|
05/05/2021
|
|
#45047
|
user_registered returned as UTC Time instead of Local Time
|
|
Date/Time
|
normal
|
normal
|
Future Release
|
defect (bug)
|
has-patch
|
04/22/2020
|
3
|
#49413
|
wp_exif_date2ts should use Datetime and accept an optional offset
|
Rarst
|
Date/Time
|
low
|
normal
|
Future Release
|
defect (bug)
|
needs-unit-tests
|
01/19/2022
|
2
|
#48204
|
wp_exif_date2ts throws notice on empty date
|
|
Date/Time
|
normal
|
minor
|
Future Release
|
defect (bug)
|
has-patch
|
06/29/2023
|
|
#56887
|
wp_exif_date2ts throws notice on slash formatted date
|
|
Date/Time
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
|
10/22/2022
|
1
|
#57955
|
wp_localize_jquery_ui_datepicker parsing general settings date_format wrong
|
|
Date/Time
|
normal
|
minor
|
Awaiting Review
|
defect (bug)
|
changes-requested
|
03/20/2023
|
1
|
#49414
|
wp_read_image_metadata should look for timezone offset
|
|
Date/Time
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
|
02/15/2020
|
|
#57365
|
"Attempt Block Recovery" functionality broken for buttons "Convert to.." click
|
|
Editor
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
|
12/30/2022
|