Вот уже голову сломал, но найти ошибку не могу
public function accept(Player $player) {
$playerName = strtolower($player->getName());
$stmt = self::getDB()->prepare('UPDATE clan_players SET status = :status
WHERE player = :player AND clan_id = :id AND status = :invite LIMIT 1');
$stmt->bindValue(':id', $this->getId(), SQLITE3_INTEGER);
$stmt->bindValue(':status', self::STATUS_OK, SQLITE3_INTEGER);
$stmt->bindValue(':invite', self::STATUS_INVITE, SQLITE3_INTEGER);
$stmt->bindValue(':player', $playerName, SQLITE3_TEXT);
return $stmt->execute();
}
Текст ошибки
[WARNING] RuntimeException: "SQLite3::prepare(): Unable to prepare statement: 1, near "LIMIT": syntax error" (E_WARNING) in "src/Clan.php" at line 74
