I experienced the same issue, and have resolved it.
So I thought I would post to help others.
I tracked the issue to the same place.
The troublesome file is:
/wp-content/mu-plugins/wp-db-abstraction/translations/sqlsrv/translations.php
The problematic code is inside the function called “translate_limit”
The issue seems to be the result of “count($limit_matches).”
Querys against the user table seem to match five times, and queries against the post table seem to match six times.
Bottom line:
Below is my present solution.
Simply replace the CONTENTS (not the outmost braces) of the “translate_limit” function with the code below.
Hope this works for others.
if ( (stripos($query,'SELECT') !== 0 && stripos($query,'SELECT') !== FALSE)
&& (stripos($query,'UPDATE') !== 0 && stripos($query,'UPDATE') !== FALSE) ) {
return $query;
}
$pattern = '/LIMIT\s*(\d+)((\s*,?\s*)(\d+)*)(;{0,1})$/is';
$matched = preg_match($pattern, $query, $limit_matches);
if ( $matched == 0 ) {
return $query;
}
// Remove the LIMIT statement
$true_offset = false;
$query = preg_replace($pattern, '', $query);
if ( $this->delete_query ) {
return $query;
}
// Check for true offset
// needed to add new code here:
// The pages showing posts need count($limit_matches) == 6
// The pages showing users need count($limit_matches) == 5
// so I will check if the query includes the name of the user table, and then respond accordingly
// check for user table
$userTablePos = strpos($query,"ASPPR_users");
if ($userTablePos == true)
{
// the query is addressing the user table
if ( count($limit_matches) == 5 && $limit_matches[1] != '0' ) {
$true_offset = true;
} elseif ( count($limit_matches) == 5 && $limit_matches[1] == '0' ) {
$limit_matches[1] = $limit_matches[4];
}
}
else
{
// the query is not addressing the user table
if ( count($limit_matches) == 6 && $limit_matches[1] != '0' ) {
$true_offset = true;
} elseif ( count($limit_matches) == 6 && $limit_matches[1] == '0' ) {
$limit_matches[1] = $limit_matches[4];
}
}
// Rewrite the query.
if ( $true_offset === false ) {
if ( stripos($query, 'DISTINCT') > 0 ) {
$query = str_ireplace('DISTINCT', 'DISTINCT TOP ' . $limit_matches[1] . ' ', $query);
} else {
$query = str_ireplace('DELETE ', 'DELETE TOP ' . $limit_matches[1] . ' ', $query);
$query = str_ireplace('SELECT ', 'SELECT TOP ' . $limit_matches[1] . ' ', $query);
}
} else {
$limit_matches[1] = (int) $limit_matches[1];
$limit_matches[4] = (int) $limit_matches[4];
$this->limit = array(
'from' => $limit_matches[1],
'to' => $limit_matches[4]
);
}
return $query;
