| 1
|
#43589
|
WPDB Update change NULL values to acceptable values
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
has-patch
|
7 years ago
|
|
|
#53320
|
Why delete_metadata and update_metadata slow performance?
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
|
2 years ago
|
| 2
|
#57072
|
WordPress 6.1 uses wrong database collation
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
|
4 years ago
|
| 1
|
#58133
|
WordPress database error Illegal mix of collations
|
|
Database
|
normal
|
major
|
Awaiting Review
|
defect (bug)
|
|
3 years ago
|
| 3
|
#63678
|
WordPress redirect to wp-admin/install.php when a user is rate limited in mysql
|
johnbillion
|
Database
|
normal
|
normal
|
7.2
|
defect (bug)
|
has-patch
|
35 hours ago
|
| 2
|
#49785
|
Wrong result / duplicates in query when using MariaDB
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
|
6 years ago
|
|
|
#40695
|
`install_blog` suppresses database errors
|
|
Database
|
normal
|
normal
|
Future Release
|
defect (bug)
|
has-patch
|
9 years ago
|
| 1
|
#46932
|
dbDelta does not account for MySQL keywords being used as key names
|
|
Database
|
normal
|
minor
|
Awaiting Review
|
defect (bug)
|
|
7 years ago
|
|
|
#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)
|
|
7 years ago
|
| 2
|
#46146
|
dbDelta not parsing enum correctly
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
has-patch
|
5 weeks ago
|
| 1
|
#46145
|
dbDelta runs same updates on every execution
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
|
7 years ago
|
| 2
|
#40694
|
dbDelta uses suppressed errors to detect table absence
|
|
Database
|
normal
|
normal
|
Future Release
|
defect (bug)
|
has-patch
|
7 years ago
|
|
|
#56533
|
dbDelta() ignores changes to column nullability (NULL/NOT NULL)
|
|
Database
|
normal
|
major
|
Awaiting Review
|
defect (bug)
|
reporter-feedback
|
4 years ago
|
|
|
#36924
|
dbDelta(): Support more than one whitespace between field name and its type definition
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
|
8 years ago
|
| 2
|
#57149
|
get_table_from_query() doesn't properly handle a prepared escape_like() table name
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
|
4 years ago
|
|
|
#46739
|
post attributes order not working correctly
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
|
7 years ago
|
|
|
#51097
|
post cannot be saved due to certain variant of Japanese Kanji
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
close
|
6 years ago
|
|
|
#46625
|
username and password automatically change to dexter
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
|
7 years ago
|
| 1
|
#55206
|
wp core api memory leaks
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
dev-feedback
|
4 years ago
|
|
|
#59172
|
wp_query meta_query NOT EXISTS not creating correct sql query
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
reporter-feedback
|
14 months ago
|
|
|
#57000
|
wp_usermeta table is emptied because of a wrong query being executed
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
|
4 years ago
|
| 2
|
#62342
|
wpdb->get_table_from_query: preg_match(): Passing null to parameter #2 ($subject) of type string is deprecated
|
|
Database
|
normal
|
normal
|
Future Release
|
defect (bug)
|
has-patch
|
8 months ago
|
| 5
|
#63751
|
wpdb->set_prefix() throws deprecation notice for preg_match() when setup-config.php is loaded
|
|
Database
|
normal
|
minor
|
Awaiting Review
|
defect (bug)
|
|
11 months ago
|
| 1
|
#61338
|
wpdb::prepare function null value convert to empty String
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
|
22 months ago
|
|
|
#49363
|
wpdb::query() does not detect LOAD DATA as an insert statement type
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
has-patch
|
6 years ago
|
| 2
|
#46947
|
‘❤’ in Comment Generates DB Error
|
|
Database
|
normal
|
normal
|
Future Release
|
defect (bug)
|
reporter-feedback
|
9 months ago
|
|
|
#47818
|
$wpdb should update ->insert_id also when `LAST_INSERT_ID(...)` is found
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
|
7 years ago
|
| 1
|
#55202
|
A proper (error) message should be show when mysql setting autocommit=0
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
|
4 years ago
|
| 2
|
#41944
|
Add %u support to wpdb->prepare
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
|
9 years ago
|
| 24
|
#15499
|
Add an index for get_lastpostmodified query
|
OllieJones
|
Database
|
normal
|
normal
|
Future Release
|
enhancement
|
dev-feedback
|
11 months ago
|
|
|
#60254
|
Add filter to class-wpdb.php#query that allows to return data from filter return value
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
|
2 years ago
|
|
|
#46210
|
Add helpers for default/empty datetime value
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
has-patch
|
3 years ago
|
|
|
#64553
|
Add parameter to delete_expired_transients() for custom transients
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
needs-unit-tests
|
5 months ago
|
| 1
|
#54642
|
Add prepared query builder support for `$wpdb` to build prepared queries across multiple location.
|
|
Database
|
normal
|
normal
|
Future Release
|
enhancement
|
has-patch
|
4 years ago
|
| 1
|
#59106
|
Add secondary index on `wp_posts` table to improve media queries performance
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
|
3 years ago
|
| 1
|
#61856
|
Add support for MySQL SSL connections
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
has-patch
|
2 years ago
|
| 5
|
#59269
|
Add support for adding metadata in bulk
|
johnbillion
|
Database
|
normal
|
normal
|
Future Release
|
enhancement
|
changes-requested
|
5 days ago
|
| 4
|
#38036
|
Add support for the utf8mb4_0900_ai_ci collation
|
|
Database
|
normal
|
normal
|
Future Release
|
enhancement
|
|
3 years ago
|
| 3
|
#54627
|
Adding More Timestamp columns to database
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
|
5 years ago
|
| 14
|
#45354
|
Adding index for meta_key and post_id in postmeta
|
|
Database
|
normal
|
normal
|
Future Release
|
enhancement
|
dev-feedback
|
5 days ago
|
| 1
|
#52527
|
Better RAM handling in wp-db.php
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
|
5 years ago
|
| 2
|
#38760
|
Capture result size in bytes when SAVEQUERIES is true
|
|
Database
|
normal
|
normal
|
Future Release
|
enhancement
|
|
9 years ago
|
|
|
#55115
|
Change deprecated wpdb::escape() method
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
close
|
4 years ago
|
| 3
|
#58344
|
Connect to database on first query
|
|
Database
|
normal
|
normal
|
Future Release
|
enhancement
|
has-patch
|
14 months ago
|
| 1
|
#56259
|
Database Repair doesn't check for missing primary keys / A.I.
|
|
Database
|
normal
|
minor
|
Awaiting Review
|
enhancement
|
|
3 years ago
|
| 5
|
#45697
|
Database: Upgrading field collations
|
|
Database
|
normal
|
normal
|
Future Release
|
enhancement
|
|
4 years ago
|
| 17
|
#28625
|
Enhancement: Add constants to support SSL connections for mysqli
|
|
Database
|
normal
|
normal
|
Future Release
|
enhancement
|
needs-unit-tests
|
3 years ago
|
|
|
#41956
|
Errno in $wpdb
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
has-patch
|
8 years ago
|
| 17
|
#54042
|
Extending wpdb::prepare() to support IN() operator
|
|
Database
|
normal
|
normal
|
Future Release
|
enhancement
|
dev-feedback
|
3 years ago
|
| 1
|
#39748
|
Function to insert or update DB value
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
|
9 years ago
|
| 10
|
#6492
|
Guids No Longer Have Permalink Format
|
|
Database
|
normal
|
normal
|
Future Release
|
enhancement
|
|
7 years ago
|
| 7
|
#43019
|
Hook to validate post form data before save
|
|
Database
|
normal
|
major
|
Awaiting Review
|
enhancement
|
has-patch
|
5 years ago
|
| 2
|
#39826
|
LIMIT clause not required in get_options function as there's already a UNIQUE KEY on option_name
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
dev-feedback
|
6 years ago
|
| 1
|
#44292
|
Make use of protected process_fields
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
|
8 years ago
|
| 1
|
#46565
|
Mixed engine in tables, could bring to major WP failure! Also there is a small fix that could avoid that.
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
|
7 years ago
|
| 1
|
#61071
|
Need to display appropriate error messages when the database table is empty or corrupted.
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
dev-feedback
|
18 months ago
|
|
|
#52253
|
New filter on wp-db.php
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
reporter-feedback
|
6 years ago
|
|
|
#60102
|
PHPunit tests for dead_db
|
|
Database
|
normal
|
normal
|
Future Release
|
enhancement
|
has-patch
|
17 months ago
|
| 1
|
#58826
|
Please add a default post relations table
|
|
Database
|
normal
|
critical
|
Awaiting Review
|
enhancement
|
|
3 years ago
|
|
|
#44386
|
Problem with utf8mb4_unicode_ci collation for arabic content
|
|
Database
|
normal
|
major
|
Awaiting Review
|
enhancement
|
dev-feedback
|
5 months ago
|
| 1
|
#54324
|
Rename Table Function - maybe_rename_table()
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
has-patch
|
4 years ago
|
|
|
#54560
|
Return null from wpdb::get_results when query fails
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
has-patch
|
5 years ago
|
| 40
|
#47280
|
SQL_CALC_FOUND_ROWS is deprecated as of MySQL 8.0.17
|
johnbillion
|
Database
|
normal
|
normal
|
Future Release
|
enhancement
|
changes-requested
|
9 months ago
|
| 9
|
#54346
|
Slow SQL queries fetching posts from specific categories
|
craigfrancis*
|
Database
|
normal
|
normal
|
Future Release
|
enhancement
|
has-patch
|
4 months ago
|
|
|
#58180
|
Specify the REGEXP format for meta_query
|
|
Database
|
normal
|
trivial
|
Awaiting Review
|
enhancement
|
needs-docs
|
6 weeks ago
|
| 1
|
#61604
|
Split `wp_insert_post` in two
|
|
Database
|
normal
|
minor
|
Awaiting Review
|
enhancement
|
|
2 years ago
|
| 10
|
#42352
|
Support use of native MySQLi prepared queries
|
|
Database
|
normal
|
normal
|
Future Release
|
enhancement
|
early
|
22 months ago
|
|
|
#47994
|
The additions of a new wp_posts table columns called post_level and post_patriarch
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
|
7 years ago
|
| 6
|
#41424
|
Use a better error message than "Error establishing a database connection" when site isn't found
|
|
Database
|
normal
|
normal
|
Future Release
|
enhancement
|
needs-unit-tests
|
9 years ago
|
| 1
|
#41054
|
Use sargable date filtering where possible
|
|
Database
|
normal
|
trivial
|
Awaiting Review
|
enhancement
|
|
20 months ago
|
| 3
|
#40150
|
VARCHAR/TEXT inefficiencies
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
|
9 years ago
|
|
|
#55938
|
WP prefix on installation - instructions to be indicated
|
|
Database
|
normal
|
minor
|
Awaiting Review
|
enhancement
|
|
4 years ago
|
|
|
#42703
|
WP_Query: Swap parsing date into own method
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
|
7 years ago
|
| 15
|
#41281
|
attachment_url_to_postid results in very slow query
|
joemcgill*
|
Database
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
|
2 years ago
|
| 3
|
#40357
|
dbDelta can't change primary keys, create AUTO_INCREMENT columns and doesn't make significant index changes
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
needs-unit-tests
|
6 months ago
|
| 2
|
#49654
|
maybe_drop_table
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
|
3 years ago
|
| 2
|
#46576
|
short-circuit filter for dbDelta
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
|
7 years ago
|
| 2
|
#58871
|
support uca14.0.0 collation in database where available
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
has-patch
|
10 months ago
|
|
|
#54180
|
tests fot _wp_mysql_week()
|
|
Database
|
normal
|
normal
|
Future Release
|
enhancement
|
has-patch
|
2 months ago
|
| 2
|
#36242
|
wpdb set_sql_mode add param
|
pbearne
|
Database
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
dev-feedback
|
18 months ago
|
|
|
#63734
|
wpdb::prepare() should reject invalid schema object names
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
has-patch
|
12 months ago
|
| 4
|
#62512
|
Add "Learn WordPress" Links to the "WordPress Events and News" Dashboard Widget
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
feature request
|
has-patch
|
14 months ago
|
| 1
|
#46287
|
Add insert_ignore() method to wpdb to avoid unecessary boilerplate code
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
feature request
|
has-patch
|
14 months ago
|
| 15
|
#57793
|
Add native support for SQLite
|
|
Database
|
normal
|
normal
|
Future Release
|
feature request
|
has-patch
|
21 months ago
|
| 1
|
#63966
|
Database Extensions for Federation Support and Compatibility at the WordPress Core Level
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
feature request
|
close
|
10 months ago
|
|
|
#59639
|
Dedicated tables for media libary
|
|
Database
|
normal
|
major
|
Awaiting Review
|
feature request
|
dev-feedback
|
3 years ago
|
| 2
|
#58694
|
Enhancement in wordpress Database API
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
feature request
|
|
3 years ago
|
| 6
|
#54070
|
Increase CPT "machine name" limit from its current maximum of 20 characters.
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
feature request
|
dev-feedback
|
20 months ago
|
|
|
#62575
|
Prints SQL/DB error limit last_query too long
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
feature request
|
|
20 months ago
|
|
|
#54235
|
Script for handling metadata in wp_postmeta
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
feature request
|
needs-docs
|
5 years ago
|
| 1
|
#59281
|
Support for Database Cursor
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
feature request
|
|
3 years ago
|
| 1
|
#51762
|
Unix authentication support via unix_socket
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
feature request
|
|
6 years ago
|
| 3
|
#15332
|
dbDelta($query) - do not create view
|
|
Database
|
normal
|
normal
|
Future Release
|
feature request
|
needs-unit-tests
|
14 months ago
|
| 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
|
7 years ago
|
| 5
|
#65281
|
Custom Time & Date Format Fields Allow Empty Save Instead of Validation
|
|
Date/Time
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
has-patch
|
4 weeks ago
|
| 1
|
#61223
|
Date Time and UTC / GTM Timezone is not synchronizing
|
|
Date/Time
|
normal
|
minor
|
Awaiting Review
|
defect (bug)
|
close
|
18 months ago
|
| 1
|
#49012
|
Date format output incorrect in Finnish
|
|
Date/Time
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
|
2 years ago
|
|
|
#51625
|
Date/Time test failures during DST transition
|
|
Date/Time
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
reporter-feedback
|
19 months ago
|
| 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
|
6 years ago
|
| 3
|
#32386
|
Draft's Last Modified date incorrect if it is Scheduled
|
obenland
|
Date/Time
|
normal
|
normal
|
Future Release
|
defect (bug)
|
|
6 years ago
|
![(please configure the [header_logo] section in trac.ini)](/chrome/site/your_project_logo.png){kind=logo}
