HyperDB

HyperDB copied to clipboard

Fixes #136 The [MariaDB SELECT format is](https://mariadb.com/kb/en/select/)... ``` SELECT [ALL | DISTINCT | DISTINCTROW] [HIGH_PRIORITY] [STRAIGHT_JOIN] [SQL_SMALL_RESULT] [SQL_BIG_RESULT] [SQL_BUFFER_RESULT] [SQL_CACHE | SQL_NO_CACHE] [SQL_CALC_FOUND_ROWS] select_expr [, select_expr ...] [ FROM [table_references](https://mariadb.com/kb/en/join-syntax/)...

dd32

Correctly identify whether the server supports `utf8mb4_520`

2

In older versions of PHP `$db_version` will be `5.5.5` for MariaDB, which prevents the use of the `utf8mb4_unicode_520_ci` collation. See https://core.trac.wordpress.org/changeset/54384 This merges https://github.com/WordPress/wordpress-develop/commit/fed98bd9ef9a232d102c41e74944d3c21cd6183e & https://github.com/WordPress/wordpress-develop/commit/11df92738b07de35ae42fa6ee14c5ed506432241 to HyperDB.

dd32

'FOR UPDATE' check in `is_write_query()`

6

When using Wordfence's 2FA implementation together with HyperDB, the `SELECT ... FOR UPDATE` queries are currently getting interpreted as "not a write query", which causes user authentication to fail on...

justinmaurerdotdev

We are using HyperDB for long time and it has been mostly smooth experience so far. However, after upgrading to WordPress 6.4.2 we are expriencing database issues when running WP...

lubo-makky

Will this HyberDB plugin continue to receive updates here?

2

Hello, this question is actually very sincere and is not intended to bring any complaints or anything similar. In fact, I'm very grateful that the 1.9 update continues to support...

fisarmonicadev

When we call hyperdb's `get_table_from_query()` function with a long SQL string (more than 1500 chars), the query fails to return the table name and returns `false` instead. This is inconsistent...

hesahesa

PHP Notice: Undefined index: global__r

1

PHP Notice: Undefined index: global__r in /wp-content/db.php on line 507 PHP Notice: Trying to access array offset on value of type null in /wp-content/db.php on line 507 PHP Notice: Undefined...

sanchit-hwd

Running a query such as the following, followed by a `SELECT FOUND_ROWS()` will result in an error, and the found rows not being returned. ``` SELECT DISTINCT SQL_CALC_FOUND_ROWS wp_users.ID FROM...

dd32

fix: resolve warnings in php 8

6

Resolves the following warnings when upgrading to PHP 8: - compact(): Undefined variable $server in db.php on line 722 - Undefined variable $server in db.php on line 726

heyjones

Fatal error: Uncaught Error: Attempt to assign property "post_content"

3

Hello, I have a WP network site. I am getting the below error when trying to create a new post. I am using the latest HyperDB from this repo. `Fatal...

hj-collab