search

claudehohl / Stikked

An advanced and beautiful pastebin written in PHP
992 stars 220 forks source link

Database error #558

Closed TehPeGaSuS closed 2 years ago

TehPeGaSuS commented 2 years ago

After searching for a bit, I don't seem to find any issue related or I probably overlooked:

A PHP Error was encountered
Severity: Warning

Message: pg_query(): Query failed: ERROR: null value in column "title" violates not-null constraint DETAIL: Failing row contains (5, 3c9217ec, null, Diminutive Sheep, text, 1, test 1, 1641661457, 1641661757, 1, false, 0, 77.128.36.44, 0, 0).

Filename: postgre/postgre_driver.php

Line Number: 242

Backtrace:

File: /var/www/html/Stikked/htdocs/application/models/Pastes.php
Line: 101
Function: insert

File: /var/www/html/Stikked/htdocs/application/controllers/Main.php
Line: 443
Function: createPaste

File: /var/www/html/Stikked/htdocs/index.php
Line: 284
Function: require_once
A PHP Error was encountered
Severity: Warning

Message: Cannot modify header information - headers already sent by (output started at /var/www/html/Stikked/htdocs/system/core/Exceptions.php:271)

Filename: core/Common.php

Line Number: 570

Backtrace:

File: /var/www/html/Stikked/htdocs/application/models/Pastes.php
Line: 101
Function: insert

File: /var/www/html/Stikked/htdocs/application/controllers/Main.php
Line: 443
Function: createPaste

File: /var/www/html/Stikked/htdocs/index.php
Line: 284
Function: require_once
A Database Error Occurred
Error Number:

ERROR: null value in column "title" violates not-null constraint DETAIL: Failing row contains (5, 3c9217ec, null, Diminutive Sheep, text, 1, test 1, 1641661457, 1641661757, 1, false, 0, 77.128.36.44, 0, 0).

INSERT INTO "pastes" ("created", "raw", "lang", "replyto", "name", "title", "private", "pid", "toexpire", "expire", "snipurl", "ip_address") VALUES (1641661457, 'test 1', 'text', '0', 'Diminutive Sheep', NULL, '1', '3c9217ec', 1, 1641661757, FALSE, '77.128.36.44')

Filename: models/Pastes.php

Line Number: 101

Ubuntu 20.04, PHP v7.4.3, PostgreSQL 12.9

TehPeGaSuS commented 2 years ago

Disregard. I had a brain fart and commented the wrong line. All works like a charm.