Hallo Marcel Beckers
Ich möchte das Thema nochmal aufgreifen. Für uns ist es eher eine kleine störende Sache, da die Funktionalität trotzdem gewährleistet wird, jedoch für die Anwender nervig wenn sie Fehlermeldungen sehen.
Wir haben ebenfalls eine Kategorie (Name: Zuordnung) mit Radio Buttons erstellt. Wird das Formular abgesendet und kein Radio Button ist angeklickt (weil es kein Pflichtfeld z.B. ist), dann kommt eine entsprechende Fehlermeldung: Die sagt ja, dass der Kategoriewert nicht (null) sein darf, obwohl dies kein Pflichtfeld ist.
https://gyazo.com/7dcbdb82da34fa7252ecc5ec61e19967
Fehlermeldung bei uns:
Code
Wed, 27 Jan 2021 07:59:18 +0000
Message: Could not execute statement 'INSERT INTO workplace1_task_option_value (taskID, optionID, optionValue) VALUES (?, ?, ?)'
PHP version: 7.3.26
WoltLab Suite version: 5.3.2
Request URI: POST /roadmap/task-add/
Referrer: https://forum.e-monkeys.com/roadmap/task-add/
User Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87.0.4280.141 Safari/537.36
Peak Memory Usage: 6126272/536870912
======
Error Class: wcf\system\database\exception\DatabaseQueryExecutionException
Error Message: Could not execute statement 'INSERT INTO workplace1_task_option_value (taskID, optionID, optionValue) VALUES (?, ?, ?)'
Error Code: 23000
File: /var/www/vhosts/forum.e-monkeys.com/httpdocs/lib/system/database/statement/PreparedStatement.class.php (105)
Extra Information: YTozOntpOjA7YToyOntpOjA7czoxNzoiUXVlcnkgUGFyYW1ldGVyIDEiO2k6MTtpOjExO31pOjE7YToyOntpOjA7czoxNzoiUXVlcnkgUGFyYW1ldGVyIDIiO2k6MTtpOjI7fWk6MjthOjI6e2k6MDtzOjE3OiJRdWVyeSBQYXJhbWV0ZXIgMyI7aToxO3M6NDoibnVsbCI7fX0=
Stack Trace: [{"file":"\/var\/www\/vhosts\/forum.e-monkeys.com\/httpdocs\/roadmap\/lib\/data\/task\/TaskAction.class.php","line":234,"function":"execute","class":"wcf\\system\\database\\statement\\PreparedStatement","type":"->","args":[["[redacted]","[redacted]","[redacted]"]]},{"file":"\/var\/www\/vhosts\/forum.e-monkeys.com\/httpdocs\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":204,"function":"create","class":"workplace\\data\\task\\TaskAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/forum.e-monkeys.com\/httpdocs\/roadmap\/lib\/form\/TaskAddForm.class.php","line":611,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/forum.e-monkeys.com\/httpdocs\/lib\/form\/AbstractForm.class.php","line":62,"function":"save","class":"workplace\\form\\TaskAddForm","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/forum.e-monkeys.com\/httpdocs\/lib\/form\/AbstractForm.class.php","line":123,"function":"submit","class":"wcf\\form\\AbstractForm","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/forum.e-monkeys.com\/httpdocs\/lib\/form\/AbstractCaptchaForm.class.php","line":67,"function":"readData","class":"wcf\\form\\AbstractForm","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/forum.e-monkeys.com\/httpdocs\/lib\/form\/MessageForm.class.php","line":281,"function":"readData","class":"wcf\\form\\AbstractCaptchaForm","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/forum.e-monkeys.com\/httpdocs\/roadmap\/lib\/form\/TaskAddForm.class.php","line":200,"function":"readData","class":"wcf\\form\\MessageForm","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/forum.e-monkeys.com\/httpdocs\/lib\/page\/AbstractPage.class.php","line":291,"function":"readData","class":"workplace\\form\\TaskAddForm","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/forum.e-monkeys.com\/httpdocs\/lib\/page\/AbstractPage.class.php","line":114,"function":"show","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/forum.e-monkeys.com\/httpdocs\/lib\/system\/request\/Request.class.php","line":83,"function":"__run","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/forum.e-monkeys.com\/httpdocs\/lib\/system\/request\/RequestHandler.class.php","line":107,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/forum.e-monkeys.com\/httpdocs\/roadmap\/index.php","line":8,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["workplace"]}]
======
Error Class: PDOException
Error Message: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'optionValue' cannot be null
Error Code: 23000
File: /var/www/vhosts/forum.e-monkeys.com/httpdocs/lib/system/database/statement/PreparedStatement.class.php (93)
Extra Information: -
Stack Trace: [{"file":"\/var\/www\/vhosts\/forum.e-monkeys.com\/httpdocs\/lib\/system\/database\/statement\/PreparedStatement.class.php","line":93,"function":"execute","class":"PDOStatement","type":"->","args":[["[redacted]","[redacted]","[redacted]"]]},{"file":"\/var\/www\/vhosts\/forum.e-monkeys.com\/httpdocs\/roadmap\/lib\/data\/task\/TaskAction.class.php","line":234,"function":"execute","class":"wcf\\system\\database\\statement\\PreparedStatement","type":"->","args":[["[redacted]","[redacted]","[redacted]"]]},{"file":"\/var\/www\/vhosts\/forum.e-monkeys.com\/httpdocs\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":204,"function":"create","class":"workplace\\data\\task\\TaskAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/forum.e-monkeys.com\/httpdocs\/roadmap\/lib\/form\/TaskAddForm.class.php","line":611,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/forum.e-monkeys.com\/httpdocs\/lib\/form\/AbstractForm.class.php","line":62,"function":"save","class":"workplace\\form\\TaskAddForm","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/forum.e-monkeys.com\/httpdocs\/lib\/form\/AbstractForm.class.php","line":123,"function":"submit","class":"wcf\\form\\AbstractForm","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/forum.e-monkeys.com\/httpdocs\/lib\/form\/AbstractCaptchaForm.class.php","line":67,"function":"readData","class":"wcf\\form\\AbstractForm","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/forum.e-monkeys.com\/httpdocs\/lib\/form\/MessageForm.class.php","line":281,"function":"readData","class":"wcf\\form\\AbstractCaptchaForm","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/forum.e-monkeys.com\/httpdocs\/roadmap\/lib\/form\/TaskAddForm.class.php","line":200,"function":"readData","class":"wcf\\form\\MessageForm","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/forum.e-monkeys.com\/httpdocs\/lib\/page\/AbstractPage.class.php","line":291,"function":"readData","class":"workplace\\form\\TaskAddForm","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/forum.e-monkeys.com\/httpdocs\/lib\/page\/AbstractPage.class.php","line":114,"function":"show","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/forum.e-monkeys.com\/httpdocs\/lib\/system\/request\/Request.class.php","line":83,"function":"__run","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/forum.e-monkeys.com\/httpdocs\/lib\/system\/request\/RequestHandler.class.php","line":107,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/forum.e-monkeys.com\/httpdocs\/roadmap\/index.php","line":8,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["workplace"]}]
Alles anzeigen