SQLSTATE[23000]: Integrity constraint violation: 1048

<?php

use App\Validators\CommentValidator;
use App\Table\PostTable;
use App\Table\CommentTable;
use App\ObjectHelper;
use App\Model\Comment;
use App\HTML\Form;
use App\Connection;

$slug = $params['slug'];
$pdo = Connection::getPDO();
$id = (int)$params['id'];
$post = (new PostTable($pdo))->find($id);

$errors = [];
$comment = new Comment();
$pdo = Connection::getPDO();
$comments = (new CommentTable($pdo))->findByPostID($id);
$comment->setCreatedAt(date('Y-m-d H:i:s'));
dd($comment);
if (!empty($_POST)) {
    $commentTable = new CommentTable($pdo);
    $_POST['post_id'] = (int)$params['id'];
    $v = new CommentValidator($_POST, $commentTable, $comment->getID());
    ObjectHelper::hydrate($comment, $_POST, ['author', 'content', 'post_id',]);

    if ($v->validate()) {
        $commentId = $commentTable->createComment($comment);

        $url = $router->url('post', ['slug' => $slug, 'id' => $id]);
        http_response_code(301);
        header('Location: ' . $url);
        exit();
    } else {
        $errors = $v->errors();
    }
}
$form = new Form($comment, $errors);
require_once('../views/post/show.php');

<?php

namespace App\Model;

use \DateTime;

class Comment
{
    private $id;

    private $content;

    private $created_at;

    private $author;

    private $post_id;

    private $is_valid;

    private $is_no_valid;


    public function getID(): ?int
    {
        return $this->id;
    }

    public function setID($id): self
    {
        $this->id = $id;

        return $this;
    }

    public function getContent(): ?string
    {
        return $this->content;
    }


    public function setContent($content): self
    {
        $this->content = $content;

        return $this;
    }
    public function getComment(): ?string
    {
        return $this->comment;
    }


    public function setComment($comment): self
    {
        $this->comment = $comment;

        return $this;
    }



    public function getCreatedAt(): DateTime
    {
        return new DateTime($this->created_at);
    }

    public function setCreatedAt(string $date): self
    {
        $this->created_at = $date;

        return $this;
    }

    public function getAuthor(): ?string
    {
        return $this->author;
    }


    public function setAuthor(string $author): self
    {
        $this->author = $author;

        return $this;
    }

    public function setPostId(int $post_id): self
    {
        $this->post_id = $post_id;

        return $this;
    }
    public function findByPostID(): int
    {
        return $this->post_id;
    }

    public function addComment(comment $comment): void
    {
        $this->comment[] = $comment;
    }

    public function setPost(Post $post)
    {
        $this->post = $post;
    }

    public function getPostId()
    {
        return $this->post_id;
    }

    public function getIsValid()
    {
        return $this->is_valid;
    }

    public function getIsNoValid()
    {
        return $this->is_no_valid;
    }
}

<?php

namespace App\Model;

use \DateTime;

class Comment
{
    private $id;

    private $content;

    private $created_at;

    private $author;

    private $post_id;

    private $is_valid;

    private $is_no_valid;


    public function getID(): ?int
    {
        return $this->id;
    }

    public function setID($id): self
    {
        $this->id = $id;

        return $this;
    }

    public function getContent(): ?string
    {
        return $this->content;
    }


    public function setContent($content): self
    {
        $this->content = $content;

        return $this;
    }
    public function getComment(): ?string
    {
        return $this->comment;
    }


    public function setComment($comment): self
    {
        $this->comment = $comment;

        return $this;
    }



    public function getCreatedAt(): DateTime
    {
        return new DateTime($this->created_at);
    }

    public function setCreatedAt(string $date): self
    {
        $this->created_at = $date;

        return $this;
    }

    public function getAuthor(): ?string
    {
        return $this->author;
    }


    public function setAuthor(string $author): self
    {
        $this->author = $author;

        return $this;
    }

    public function setPostId(int $post_id): self
    {
        $this->post_id = $post_id;

        return $this;
    }
    public function findByPostID(): int
    {
        return $this->post_id;
    }

    public function addComment(comment $comment): void
    {
        $this->comment[] = $comment;
    }

    public function setPost(Post $post)
    {
        $this->post = $post;
    }

    public function getPostId()
    {
        return $this->post_id;
    }

    public function getIsValid()
    {
        return $this->is_valid;
    }

    public function getIsNoValid()
    {
        return $this->is_no_valid;
    }
}

^ array:4 [▼
  "content" => "test"
  "created_at" => "2021-02-14 14:07:47"
  "author" => null
  "post_id" => null
]

<?php

namespace App\Table;

use App\Model\Comment;
use App\PaginatedQuery;
use \PDO;

final class CommentTable extends Table
{
    protected $table = "comment";
    protected $class = Comment::class;

    public function createComment(Comment $comment): void
    {
        $id = $this->create([
      'content' => $comment->getContent(),
      'created_at' => $comment->getCreatedAt()->format('Y-m-d H:i:s'),
      'author' => $comment->getAuthor(),
      'post_id' => $comment->getPostId()
    ]);
        $comment->setID($id);
    }

    public function updateComment(Comment $comment): void
    {
        $this->update([
      'content' => $comment->getContent(),
      'created_at' => $comment->getCreatedAt()->format('Y-m-d H:i:s'),
      'author' => $comment->getAuthor(),
    ], $comment->getID());
    }

    public function addComment(int $id, array $comments)
    {
        $query = $this->pdo->prepare("INSERT INTO comment SET 'author', 'content', 'post_id' VALUES");
        $query->execute(['author', 'content', 'post_id']);
        $result = $query->fetchAll();


        if ($result === true) {
            echo 'Vos données ont bien eté enregistrees';
        } else {
            echo 'merci de recommencer';
        }

        return $result;
    }


    public function hydrateComments(array $comments)
    {
        foreach ($comments as $comment) {
            $comment->setComment([]);
        }
        $comments = $this->pdo
      ->query('SELECT content, post_id FROM comment WHERE post_id = ' . $comment->getPostId())
      ->fetchAll(PDO::FETCH_CLASS, $this->class);
    }

    public function findPaginated()
    {
        $paginatedQuery = new PaginatedQuery(
            "SELECT * FROM {$this->table} ORDER BY created_at DESC",
            "SELECT COUNT(id) FROM {$this->table}",
      $this->pdo
        );
        $comments = $paginatedQuery->getItems(Comment::class);

        (new CommentTable($this->pdo))->hydrateComments($comments);
        return [$comments, $paginatedQuery];
    }

    public function findByPostID($post_id, $is_valid = true)
    {
        $query = $this->pdo->prepare('SELECT * FROM ' . $this->table  .  ' WHERE post_id = :post_id and is_valid= :is_valid');
        $query->execute(['post_id' => $post_id, 'is_valid' => $is_valid]);
        $query->setFetchMode(PDO::FETCH_CLASS, $this->class);
        $result = $query->fetchAll();


        return $result;
    }

    public function approve(Comment $comment): void
    {
        $this->update(['is_valid' => 1], $comment->getID());
    }


    public function findByID($comment_id)
    {
        $query = $this->pdo->prepare('SELECT * FROM ' . $this->table  .  ' WHERE id= :id');
        $query->execute(['id' => $comment_id]);
        $query->setFetchMode(PDO::FETCH_CLASS, $this->class);
        $result = $query->fetch();

        return $result;
    }
}

<?php

namespace App\Table;

use  App\Table\Exception\NotFoundException;
use \PDO;

abstract class Table
{
    protected $pdo;
    protected $table = null;
    protected $class = null;


    public function __construct(PDO $pdo)
    {
        if ($this->table === null) {
            throw new \Exception("La class " . get_class($this) . "n'a pas de propriété \$table");
        }
        if ($this->class === null) {
            throw new \Exception("La class " . get_class($this) . "n'a pas de propriété \$class");
        }
        $this->pdo = $pdo;
    }

    public function find(int $id)
    {
        $query = $this->pdo->prepare('SELECT * FROM ' . $this->table . ' WHERE id = :id');
        $query->execute(['id' => $id]);
        $query->setFetchMode(PDO::FETCH_CLASS, $this->class);
        $result = $query->fetch();

        if ($result === false) {
            throw new NotFoundException($this->table, $id);
        }
        return $result;
    }

    /** verifie valeur si existe bdd
     * @params string $field champs à chercher
     */

    public function exists(string $field, $value, ?int $except = null): bool
    {
        $sql = "SELECT COUNT(id) FROM {$this->table} WHERE $field = ?";
        $params = [$value];
        if ($except !== null) {
            $sql .= "AND id != ?";
            $params[] = $except;
        }
        $query = $this->pdo->prepare($sql);
        $query->execute($params);
        return (int)$query->fetch(PDO::FETCH_NUM)[0]  > 0;
    }

    public function all(): array
    {
        $sql = "SELECT * FROM {$this->table}";
        return $this->pdo->query($sql, PDO::FETCH_CLASS, $this->class)->fetchAll();
    }

    public function delete(int $id)
    {
        $query = $this->pdo->prepare("DELETE FROM {$this->table} WHERE id = ?");
        $ok = $query->execute([$id]);
        if ($ok === false) {
            throw new \Exception("Impossible de supprimer l'enregistrement $id dans la table {$this->table}");
        }
    }

    public function create(array $data): int
    {
   
        $sqlFields = [];
        foreach ($data as $key => $value) {
            $sqlFields[] = "$key = :$key";
        }
        $query = $this->pdo->prepare("INSERT INTO {$this->table} SET " . implode(', ', $sqlFields));
        $ok = $query->execute($data);

        if ($ok === false) {
            throw new \Exception("Impossible de CREER l'enregistrement  dans la table {$this->table}");
        }
        return (int)$this->pdo->lastInsertId();
    }

    public function update(array $data, int $id)
    {
        $sqlFields = [];
        foreach ($data as $key => $value) {
            $sqlFields[] = "$key = :$key";
        }
        $query = $this->pdo->prepare("UPDATE {$this->table} SET " . implode(', ', $sqlFields) . " WHERE id = :id");
        $ok = $query->execute(array_merge($data, ['id' => $id]));
        if ($ok === false) {
            throw new \Exception("Impossible de modifier l'enregistrement  dans la table {$this->table}");
        }
    }

    public function queryAndFetchAll(string $sql): array
    {
        return $this->pdo->query($sql, PDO::FETCH_CLASS, $this->class)->fetchAll();
    }
}

^ array:4 [▼
  "content" => "test"
  "created_at" => "2021-02-14 14:07:47"
  "author" => null
  "post_id" => null
]