php - Mysql 在尝试运行更新请求后显示错误

Question

当我尝试在 mysql 上运行更新请求以更新文章时，mysql 显示请求超出最大长度的错误，错误是“此查询禁用 linting，因为它超过了最大长度”

标签： phpmysqlphpmyadminsql-updatesyntax-error

Answer 1

phpMyAdmin 的源代码揭示了消息文本的来源......

https://github.com/phpmyadmin/phpmyadmin/blob/master/libraries/classes/Linter.php

/**
 * Runs the linting process.
 *
 * @param string $query The query to be checked.
 *
 * @return array
 */
public static function lint($query)
{
    // Disabling lint for huge queries to save some resources.
    if (/*overload*/mb_strlen($query) > 10000) {
        return array(
            array(
                'message' => __(
                    'Linting is disabled for this query because it exceeds the '
                    . 'maximum length.'
                ),
                'fromLine' => 0,
                'fromColumn' => 0,
                'toLine' => 0,
                'toColumn' => 0,
                'severity' => 'warning',
            )
        );
    }