|
#6492
|
Guids No Longer Have Permalink Format
|
|
|
normal
|
normal
|
Future Release
|
enhancement
|
7 years ago
|
|
#47280
|
SQL_CALC_FOUND_ROWS is deprecated as of MySQL 8.0.17
|
johnbillion
|
has-patch
|
normal
|
normal
|
Future Release
|
enhancement
|
9 months ago
|
|
#15499
|
Add an index for get_lastpostmodified query
|
OllieJones
|
dev-feedback
|
normal
|
normal
|
Future Release
|
enhancement
|
11 months ago
|
|
#54042
|
Extending wpdb::prepare() to support IN() operator
|
|
dev-feedback
|
normal
|
normal
|
Future Release
|
enhancement
|
3 years ago
|
|
#12257
|
wpdb Scales Badly Due to Unnecessary Copies of All Query Results
|
|
dev-feedback
|
normal
|
critical
|
|
defect (bug)
|
7 years ago
|
|
#52496
|
Improve MySQL 8.0 support
|
|
|
normal
|
normal
|
Future Release
|
defect (bug)
|
2 years ago
|
|
#45354
|
Adding index for meta_key and post_id in postmeta
|
|
dev-feedback
|
normal
|
normal
|
Future Release
|
enhancement
|
26 hours ago
|
|
#54346
|
Slow SQL queries fetching posts from specific categories
|
craigfrancis*
|
has-patch
|
normal
|
normal
|
Future Release
|
enhancement
|
4 months ago
|
|
#8857
|
Make WP MySQL strict mode compliant
|
|
|
lowest
|
normal
|
|
enhancement
|
15 months ago
|
|
#63678
|
WordPress redirect to wp-admin/install.php when a user is rate limited in mysql
|
johnbillion
|
has-patch
|
normal
|
normal
|
7.1
|
defect (bug)
|
4 months ago
|
|
#10404
|
dbDelta creates duplicate indexes when index definition contains spaces
|
|
has-patch
|
normal
|
normal
|
|
enhancement
|
3 years ago
|
|
#57793
|
Add native support for SQLite
|
|
has-patch
|
normal
|
normal
|
Future Release
|
feature request
|
20 months ago
|
|
#62512
|
Add "Learn WordPress" Links to the "WordPress Events and News" Dashboard Widget
|
|
has-patch
|
normal
|
normal
|
Awaiting Review
|
feature request
|
14 months ago
|
|
#59269
|
Add support for adding metadata in bulk
|
johnbillion
|
has-patch
|
normal
|
normal
|
Future Release
|
enhancement
|
21 hours ago
|
|
#28625
|
Enhancement: Add constants to support SSL connections for mysqli
|
|
needs-unit-tests
|
normal
|
normal
|
Future Release
|
enhancement
|
3 years ago
|
|
#15332
|
dbDelta($query) - do not create view
|
|
needs-unit-tests
|
normal
|
normal
|
Future Release
|
feature request
|
14 months ago
|
|
#58871
|
support uca14.0.0 collation in database where available
|
|
has-patch
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
9 months ago
|
|
#13103
|
"Unknown character set" during install into database reports successful install.
|
|
has-patch
|
normal
|
normal
|
|
defect (bug)
|
12 days ago
|
|
#41956
|
Errno in $wpdb
|
|
has-patch
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
8 years ago
|
|
#31018
|
Persistent database connections with mysqli
|
|
needs-unit-tests
|
normal
|
normal
|
|
enhancement
|
4 years ago
|
|
#54070
|
Increase CPT "machine name" limit from its current maximum of 20 characters.
|
|
dev-feedback
|
normal
|
normal
|
Awaiting Review
|
feature request
|
20 months ago
|
|
#54801
|
Avoid WPDB errors when examining installation state of a site/network
|
|
has-patch
|
normal
|
normal
|
Future Release
|
defect (bug)
|
4 years ago
|
|
#56091
|
Using %i for table/field names in wpdb::prepare()
|
craigfrancis
|
has-patch
|
low
|
minor
|
Future Release
|
enhancement
|
2 years ago
|
|
#41281
|
attachment_url_to_postid results in very slow query
|
joemcgill*
|
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
2 years ago
|
|
#43019
|
Hook to validate post form data before save
|
|
has-patch
|
normal
|
major
|
Awaiting Review
|
enhancement
|
5 years ago
|
|
#62790
|
"autoload" index is not used
|
|
early
|
normal
|
minor
|
Future Release
|
defect (bug)
|
6 months ago
|
|
#18315
|
Add an index to the GUID column in the posts table
|
|
dev-feedback
|
normal
|
normal
|
|
enhancement
|
7 years ago
|
|
#26858
|
Comment duplicate check has a slow query
|
pbearne
|
has-patch
|
normal
|
normal
|
Future Release
|
defect (bug)
|
4 weeks ago
|
|
#54836
|
Huge error logs filled with "WordPress database error Illegal mix of collations" errors caused by spammers
|
|
|
normal
|
critical
|
Awaiting Review
|
defect (bug)
|
16 months ago
|
|
#62342
|
wpdb->get_table_from_query: preg_match(): Passing null to parameter #2 ($subject) of type string is deprecated
|
|
has-patch
|
normal
|
normal
|
Future Release
|
defect (bug)
|
8 months ago
|
|
#64553
|
Add parameter to delete_expired_transients() for custom transients
|
|
needs-unit-tests
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
5 months ago
|
|
#58344
|
Connect to database on first query
|
|
has-patch
|
normal
|
normal
|
Future Release
|
enhancement
|
14 months ago
|
|
#42352
|
Support use of native MySQLi prepared queries
|
|
early
|
normal
|
normal
|
Future Release
|
enhancement
|
22 months ago
|
|
#20634
|
dbDelta is unforgiving about field declarations
|
|
dev-feedback
|
normal
|
normal
|
|
enhancement
|
7 years ago
|
|
#55610
|
HTTP response should not be 200 when returning error-page
|
|
|
normal
|
major
|
Awaiting Review
|
defect (bug)
|
11 months ago
|
|
#40088
|
Stop creating the `wp_links` database table
|
|
close
|
normal
|
normal
|
Future Release
|
defect (bug)
|
4 years ago
|
|
#41944
|
Add %u support to wpdb->prepare
|
|
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
9 years ago
|
|
#8924
|
autoload should be boolean in add_option()
|
|
|
lowest
|
normal
|
Awaiting Review
|
enhancement
|
7 years ago
|
|
#38921
|
Defining filter pre_get_table_charset causes errors
|
|
has-patch
|
normal
|
normal
|
Future Release
|
defect (bug)
|
7 months ago
|
|
#30795
|
Upgrade bug affecting indexing
|
|
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
7 years ago
|
|
#54642
|
Add prepared query builder support for `$wpdb` to build prepared queries across multiple location.
|
|
has-patch
|
normal
|
normal
|
Future Release
|
enhancement
|
4 years ago
|
|
#45697
|
Database: Upgrading field collations
|
|
|
normal
|
normal
|
Future Release
|
enhancement
|
4 years ago
|
|
#10883
|
db-error.php not used for all DB failures
|
|
|
normal
|
normal
|
|
enhancement
|
15 months ago
|
|
#36242
|
wpdb set_sql_mode add param
|
pbearne
|
dev-feedback
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
18 months ago
|
|
#63825
|
Creating a post containing UTF-8, then changing WP_CHARSET to "latin1", makes posts un-editable.
|
|
close
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
10 months ago
|
|
#57385
|
Disable foreign key checks when dropping tables inside wp_uninitialize_site() function
|
johnjamesjacoby*
|
dev-feedback
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
2 years ago
|
|
#40953
|
Empty values are handled inconsistently between wpdb->get_results() and wpdb->get_col()
|
|
dev-feedback
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
18 months ago
|
|
#50789
|
Improve WPDB logic around information_schema
|
|
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
5 years ago
|
|
#41278
|
SQL_CALC_FOUND_ROWS slow query
|
|
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
9 years ago
|
|
#43893
|
The maybe_create_table() function has two definitions
|
|
dev-feedback
|
low
|
normal
|
Awaiting Review
|
defect (bug)
|
6 years ago
|
|
#46947
|
‘❤’ in Comment Generates DB Error
|
|
reporter-feedback
|
normal
|
normal
|
Future Release
|
defect (bug)
|
8 months ago
|
|
#46210
|
Add helpers for default/empty datetime value
|
|
has-patch
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
3 years ago
|
|
#38036
|
Add support for the utf8mb4_0900_ai_ci collation
|
|
|
normal
|
normal
|
Future Release
|
enhancement
|
3 years ago
|
|
#39811
|
Bug maybe_unserialize() broke mysql data.
|
|
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
9 years ago
|
|
#53958
|
Database: wp_postmeta - meta_key index
|
|
|
normal
|
major
|
Awaiting Review
|
defect (bug)
|
5 years ago
|
|
#60037
|
Differentiate between minimum required MySQL and MariaDB versions
|
|
has-patch
|
normal
|
normal
|
Future Release
|
defect (bug)
|
11 days ago
|
|
#61889
|
Function dbDelta() splits queries on semi-colon in column COMMENT and table COMMENT
|
|
has-patch
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
15 months ago
|
|
#60503
|
MySQL VALUES function deprecated in MySQL 8
|
|
close
|
normal
|
minor
|
Awaiting Review
|
defect (bug)
|
19 months ago
|
|
#51486
|
The add_option function should not be able to update existing rows in the database.
|
|
has-patch
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
5 weeks ago
|
|
#43578
|
Unexpected MYSQL data format
|
|
dev-feedback
|
normal
|
normal
|
Future Release
|
defect (bug)
|
6 years ago
|
|
#43589
|
WPDB Update change NULL values to acceptable values
|
|
has-patch
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
7 years ago
|
|
#40695
|
`install_blog` suppresses database errors
|
|
has-patch
|
normal
|
normal
|
Future Release
|
defect (bug)
|
9 years ago
|
|
#46625
|
username and password automatically change to dexter
|
|
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
7 years ago
|
|
#44386
|
Problem with utf8mb4_unicode_ci collation for arabic content
|
|
dev-feedback
|
normal
|
major
|
Awaiting Review
|
enhancement
|
5 months ago
|
|
#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
|
9 years ago
|
|
#63734
|
wpdb::prepare() should reject invalid schema object names
|
|
has-patch
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
12 months ago
|
|
#57283
|
Postmeta - Performance Improvement - Woocommerce
|
|
|
normal
|
critical
|
Awaiting Review
|
defect (bug)
|
4 years ago
|
|
#21762
|
Storing a multidimensional array using register_setting double-serializes subarrays identified with a string
|
sekatsim
|
|
normal
|
normal
|
|
defect (bug)
|
7 years ago
|
|
#59836
|
Using the pre_get_table_charset filter ensures wpdb->col_meta never gets populated
|
|
has-patch
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
7 months ago
|
|
#49785
|
Wrong result / duplicates in query when using MariaDB
|
|
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
6 years ago
|
|
#34872
|
dbDelta Missing Index Name Creates Duplicate Indexes
|
|
has-patch
|
normal
|
normal
|
|
defect (bug)
|
7 years ago
|
|
#46146
|
dbDelta not parsing enum correctly
|
|
has-patch
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
4 weeks ago
|
|
#40694
|
dbDelta uses suppressed errors to detect table absence
|
|
has-patch
|
normal
|
normal
|
Future Release
|
defect (bug)
|
7 years ago
|
|
#36924
|
dbDelta(): Support more than one whitespace between field name and its type definition
|
|
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
8 years ago
|
|
#57149
|
get_table_from_query() doesn't properly handle a prepared escape_like() table name
|
|
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
4 years ago
|
|
#51097
|
post cannot be saved due to certain variant of Japanese Kanji
|
|
close
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
6 years ago
|
|
#55206
|
wp core api memory leaks
|
|
dev-feedback
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
4 years ago
|
|
#31624
|
$wpdb->prepare() named placeholders
|
|
needs-unit-tests
|
normal
|
normal
|
|
enhancement
|
3 years ago
|
|
#55115
|
Change deprecated wpdb::escape() method
|
|
close
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
4 years ago
|
|
#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
|
6 years ago
|
|
#61071
|
Need to display appropriate error messages when the database table is empty or corrupted.
|
|
dev-feedback
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
18 months ago
|
|
#52253
|
New filter on wp-db.php
|
|
reporter-feedback
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
6 years ago
|
|
#58180
|
Specify the REGEXP format for meta_query
|
|
needs-docs
|
normal
|
trivial
|
Awaiting Review
|
enhancement
|
5 weeks ago
|
|
#54180
|
tests fot _wp_mysql_week()
|
|
has-patch
|
normal
|
normal
|
Future Release
|
enhancement
|
2 months ago
|
|
#43664
|
$wpdb->get_results fails in specific cases with non-latin charaters in where clause
|
|
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
8 years ago
|
|
#37678
|
Add an action hook for plugins to do database upgrades on
|
|
dev-feedback
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
13 months ago
|
|
#58559
|
Database error bug in wordpress current version
|
|
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
3 months ago
|
|
#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)
|
4 years ago
|
|
#58965
|
No luck running WP when running PHP 8.2.8 + mysql Ver 15.1
|
|
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
3 years ago
|
|
#52648
|
Problem with certain passwords not working to login to mysql db
|
|
reporter-feedback
|
normal
|
major
|
Awaiting Review
|
defect (bug)
|
5 years ago
|
|
#58133
|
WordPress database error Illegal mix of collations
|
|
|
normal
|
major
|
Awaiting Review
|
defect (bug)
|
3 years ago
|
|
#56533
|
dbDelta() ignores changes to column nullability (NULL/NOT NULL)
|
|
reporter-feedback
|
normal
|
major
|
Awaiting Review
|
defect (bug)
|
4 years ago
|
|
#59172
|
wp_query meta_query NOT EXISTS not creating correct sql query
|
|
reporter-feedback
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
14 months ago
|
|
#37508
|
wpdb->result instance should be checked `mysqli_num_fields` in `load_col_info()`
|
|
needs-unit-tests
|
normal
|
normal
|
|
defect (bug)
|
7 years ago
|
|
#63751
|
wpdb->set_prefix() throws deprecation notice for preg_match() when setup-config.php is loaded
|
|
|
normal
|
minor
|
Awaiting Review
|
defect (bug)
|
11 months ago
|
|
#61856
|
Add support for MySQL SSL connections
|
|
has-patch
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
2 years ago
|
|
#56259
|
Database Repair doesn't check for missing primary keys / A.I.
|
|
|
normal
|
minor
|
Awaiting Review
|
enhancement
|
3 years ago
|
|
#60102
|
PHPunit tests for dead_db
|
|
has-patch
|
normal
|
normal
|
Future Release
|
enhancement
|
17 months ago
|
![(please configure the [header_logo] section in trac.ini)](/chrome/site/your_project_logo.png){kind=logo}
