php - 我的命令 UPDATE 在框架 FaaPz/Slim-PDO 上不起作用

Question

我的mysql命令UPDATE不起作用，如何修复它？

这是代码

$mysql_query = $db->update(array('`status`' => $cache['b']['status']))
                          ->set(array('`cache`' => $packed_cache))
                          ->set(array('`cache_time`' => $packed_times))
                          ->table('`'.$lgsl_config['db']['table'].'`')
                          ->where('`id`', '=', $mysql_row['id'])
                          ->limit(1);

错误是

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'OFFSET 0' at line 1' in /nfsmnt/hosting2_1/c/3/c33777c4-d67a-498e-a243-d730693c74c1/pallax.systems/sub/serverlist/vendor/slim/pdo/src/PDO/Statement/StatementContainer.php:535 Stack trace: #0 /nfsmnt/hosting2_1/c/3/c33777c4-d67a-498e-a243-d730693c74c1/pallax.systems/sub/serverlist/vendor/slim/pdo/src/PDO/Statement/StatementContainer.php(535): PDO->prepare('UPDATE lgsl S...') #1 /nfsmnt/hosting2_1/c/3/c33777c4-d67a-498e-a243-d730693c74c1/pallax.systems/sub/serverlist/vendor/slim/pdo/src/PDO/Statement/StatementContainer.php(428): Slim\PDO\Statement\StatementContainer->getStatement() #2 /nfsmnt/hosting2_1/c/3/c33777c4-d67a-498e-a243-d730693c74c1/pallax.systems/sub/serverlist/vendor/slim/pdo/src/PDO/Statement/UpdateStatement.php(86): Slim\PDO\Statement\StatementContainer->exe in /nfsmnt/hosting2_1/c/3/c33777c4-d67a-498e-a243-d730693c74c1/pallax.systems/sub/serverlist/vendor/slim/pdo/src/PDO/Statement/StatementContainer.php on line 535

!!!我发现了错误..

UPDATE `lgsl` SET `status` = ? , `cache` = ? , `cache_time` = ? WHERE `id` = ? LIMIT 1 OFFSET 0

最后是OFFSET 0，但我不知道如何删除它

Answer 1

删除 ->limit(1)，因为它对于 UPDATE 语句来说并不是真正必要的。

虽然它应该可以工作，但我相信该方法有一个错误。