NellielProject / Nelliel

A lightweight and expandable imageboard.
BSD 3-Clause "New" or "Revised" License
11 stars 1 forks source link

Cannot create new thread #9

Closed crazy4cars69 closed 1 year ago

crazy4cars69 commented 1 year ago

Using latest version of nelliel, php7.3(fpm,gd,xml,pdo,pgsql,dom), using postgresql

2022/12/22 10:20:19 [error] 9778#9778: *97 FastCGI sent in stderr: "PHP message: PHP Fatal error:  Uncaught PDOException: SQLSTATE[23503]: Foreign key violation: 7 ERROR:  insert or update on table "_b_posts" violates foreign key constraint "fk__b_posts__threads"
DETAIL:  Key (parent_thread)=(3) is not present in table "_b_threads". in /var/www/html/core/include/Database/NellielPDO.php:220
Stack trace:
#0 /var/www/html/core/include/Database/NellielPDO.php(220): PDOStatement->execute()
#1 /var/www/html/core/include/Content/Post.php(105): Nelliel\Database\NellielPDO->executePrepared(Object(PDOStatement))
#2 /var/www/html/core/include/Content/Thread.php(621): Nelliel\Content\Post->writeToDatabase()
#3 /var/www/html/core/include/NewPost/NewPost.php(127): Nelliel\Content\Thread->addPost(Object(Nelliel\Content\Post))
#4 /var/www/html/core/include/Dispatch/Functions/DispatchNewPost.php(40): Nelliel\NewPost\NewPost->processPost()
#5 /var/www/html/core/include/Dispatch/Router.php(362): Nelliel\Dispatch\Functions\DispatchNewPost->dispatch(Array)
#6 /var/www/html/cor" while reading response header from upstream, client: 127.0.0.1, server: , request: "POST /imgboard.php?route=/b/new-post HTTP/1.1", upstream: "fastcgi://unix:/run/php/php7.3-fpm.sock:", host: "127.0.0.1:8080", referrer: "http://127.0.0.1:8080/b/"
OtakuMegane commented 1 year ago

This should be fixed now.

crazy4cars69 commented 1 year ago

Works, thanks.