Registrierung defekt durch News System

Shalin

Hallo,

bei uns kann man sich nicht mehr registrieren durch das News System, woran liegt es genau?

Code

Fri, 01 Jul 2022 20:17:39 +0000
Message: Could not execute statement 'INSERT INTO wcf1_user                             (disclaimerAcceptedAt,minAgeConfirmedAt,userString,languageID,registrationIpAddress,activationCode,emailConfirmed,username,email,password,blacklistMatches,signatureEnableHtml,accessToken,registrationDate)                 VALUES      (?,?,?,?,?,?,?,?,?,?,?,?,?,?)'
PHP version: 7.4.28
WoltLab Suite version: 5.4.19
Request URI: POST /register/
Referrer: https://borderline-forum.eu/register/
User Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/103.0.0.0 Safari/537.36
Peak Memory Usage: 11743064/1073741824
======
Error Class: wcf\system\database\exception\DatabaseQueryExecutionException
Error Message: Could not execute statement 'INSERT INTO wcf1_user                             (disclaimerAcceptedAt,minAgeConfirmedAt,userString,languageID,registrationIpAddress,activationCode,emailConfirmed,username,email,password,blacklistMatches,signatureEnableHtml,accessToken,registrationDate)                 VALUES      (?,?,?,?,?,?,?,?,?,?,?,?,?,?)'
Error Code: HY000
File: /home/www/borderline-forum.eu/lib/system/database/statement/PreparedStatement.class.php (144)
Extra Information: YToxNDp7aTowO2E6Mjp7aTowO3M6MTc6IlF1ZXJ5IFBhcmFtZXRlciAxIjtpOjE7aToxNjU2NzA2NjU5O31pOjE7YToyOntpOjA7czoxNzoiUXVlcnkgUGFyYW1ldGVyIDIiO2k6MTtpOjE2NTY3MDY2NTk7fWk6MjthOjI6e2k6MDtzOjE3OiJRdWVyeSBQYXJhbWV0ZXIgMyI7aToxO3M6NjY6IiczMzIwLjU4MDU4MzAwIDE2NTY3MDY2NTl0OTJXVjE2MG56eEFiZFQ3Q21pT3dyYVJvTlhlMzVHbHEyMTU1MDc5JyI7fWk6MzthOjI6e2k6MDtzOjE3OiJRdWVyeSBQYXJhbWV0ZXIgNCI7aToxO2k6MTt9aTo0O2E6Mjp7aTowO3M6MTc6IlF1ZXJ5IFBhcmFtZXRlciA1IjtpOjE7czoxODoiJzo6ZmZmZjo1YjMyOmE5MzUnIjt9aTo1O2E6Mjp7aTowO3M6MTc6IlF1ZXJ5IFBhcmFtZXRlciA2IjtpOjE7aTo3NzkxNzE1NzQ7fWk6NjthOjI6e2k6MDtzOjE3OiJRdWVyeSBQYXJhbWV0ZXIgNyI7aToxO3M6NDI6Iic0YTUyOTgwMDk0NjY4MzU2MGM2MGZlOTdiY2Y0ODNkY2UyYjQ5ZDkwJyI7fWk6NzthOjI6e2k6MDtzOjE3OiJRdWVyeSBQYXJhbWV0ZXIgOCI7aToxO3M6MTI6IidTaGFsaW5UZXN0JyI7fWk6ODthOjI6e2k6MDtzOjE3OiJRdWVyeSBQYXJhbWV0ZXIgOSI7aToxO3M6Mjg6IidzaGFsaW5AYm9yZGVybGluZS1mb3J1bS5ldSciO31pOjk7YToyOntpOjA7czoxODoiUXVlcnkgUGFyYW1ldGVyIDEwIjtpOjE7czo2OToiJ0JjcnlwdDokMnkkMTIkMkREVnB6L3pPSG5OclNOMUVueVhvZVBEVHY4SThUbVBPLnNyLk5IaHlKUmRxVDJPTFJ0UXEnIjt9aToxMDthOjI6e2k6MDtzOjE4OiJRdWVyeSBQYXJhbWV0ZXIgMTEiO2k6MTtzOjI6IicnIjt9aToxMTthOjI6e2k6MDtzOjE4OiJRdWVyeSBQYXJhbWV0ZXIgMTIiO2k6MTtpOjE7fWk6MTI7YToyOntpOjA7czoxODoiUXVlcnkgUGFyYW1ldGVyIDEzIjtpOjE7czo0MjoiJzg3Njg2MDI3YWRhZGMyNDVkNzU2ZjM3NDgwYzJhNDU0ZDY4NTg1ZDcnIjt9aToxMzthOjI6e2k6MDtzOjE4OiJRdWVyeSBQYXJhbWV0ZXIgMTQiO2k6MTtpOjE2NTY3MDY2NTk7fX0=
Stack Trace: [{"file":"\/home\/www\/borderline-forum.eu\/lib\/data\/TFastCreate.class.php","line":44,"function":"execute","class":"wcf\\system\\database\\statement\\PreparedStatement","type":"->","args":[["[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]"]]},{"file":"\/home\/www\/borderline-forum.eu\/lib\/data\/DatabaseObjectEditor.class.php","line":28,"function":"dboEditorCreateBase","class":"wcf\\data\\DatabaseObjectEditor","type":"::","args":[{"disclaimerAcceptedAt":"[redacted]","minAgeConfirmedAt":"[redacted]","userString":"[redacted]","languageID":"[redacted]","registrationIpAddress":"[redacted]","activationCode":"[redacted]","emailConfirmed":"[redacted]","username":"[redacted]","email":"[redacted]","password":"[redacted]","blacklistMatches":"[redacted]","signatureEnableHtml":"[redacted]","accessToken":"[redacted]","registrationDate":"[redacted]"}]},{"file":"\/home\/www\/borderline-forum.eu\/lib\/data\/user\/UserEditor.class.php","line":80,"function":"create","class":"wcf\\data\\DatabaseObjectEditor","type":"::","args":[{"disclaimerAcceptedAt":"[redacted]","minAgeConfirmedAt":"[redacted]","userString":"[redacted]","languageID":"[redacted]","registrationIpAddress":"[redacted]","activationCode":"[redacted]","emailConfirmed":"[redacted]","username":"[redacted]","email":"[redacted]","password":"[redacted]","blacklistMatches":"[redacted]","signatureEnableHtml":"[redacted]","accessToken":"[redacted]","registrationDate":"[redacted]"}]},{"file":"\/home\/www\/borderline-forum.eu\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":355,"function":"create","class":"wcf\\data\\user\\UserEditor","type":"::","args":[{"disclaimerAcceptedAt":"[redacted]","minAgeConfirmedAt":"[redacted]","userString":"[redacted]","languageID":"[redacted]","registrationIpAddress":"[redacted]","activationCode":"[redacted]","emailConfirmed":"[redacted]","username":"[redacted]","email":"[redacted]","password":"[redacted]","blacklistMatches":"[redacted]","signatureEnableHtml":"[redacted]","accessToken":"[redacted]","registrationDate":"[redacted]"}]},{"file":"\/home\/www\/borderline-forum.eu\/lib\/data\/user\/UserAction.class.php","line":284,"function":"create","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/home\/www\/borderline-forum.eu\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":216,"function":"create","class":"wcf\\data\\user\\UserAction","type":"->","args":[]},{"file":"\/home\/www\/borderline-forum.eu\/lib\/form\/RegisterForm.class.php","line":453,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/home\/www\/borderline-forum.eu\/lib\/form\/AbstractForm.class.php","line":66,"function":"save","class":"wcf\\form\\RegisterForm","type":"->","args":[]},{"file":"\/home\/www\/borderline-forum.eu\/lib\/form\/AbstractForm.class.php","line":134,"function":"submit","class":"wcf\\form\\AbstractForm","type":"->","args":[]},{"file":"\/home\/www\/borderline-forum.eu\/lib\/acp\/form\/AbstractOptionListForm.class.php","line":111,"function":"readData","class":"wcf\\form\\AbstractForm","type":"->","args":[]},{"file":"\/home\/www\/borderline-forum.eu\/lib\/acp\/form\/UserAddForm.class.php","line":402,"function":"readData","class":"wcf\\acp\\form\\AbstractOptionListForm","type":"->","args":[]},{"file":"\/home\/www\/borderline-forum.eu\/lib\/form\/RegisterForm.class.php","line":246,"function":"readData","class":"wcf\\acp\\form\\UserAddForm","type":"->","args":[]},{"file":"\/home\/www\/borderline-forum.eu\/lib\/page\/AbstractPage.class.php","line":339,"function":"readData","class":"wcf\\form\\RegisterForm","type":"->","args":[]},{"file":"\/home\/www\/borderline-forum.eu\/lib\/form\/RegisterForm.class.php","line":301,"function":"show","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/home\/www\/borderline-forum.eu\/lib\/page\/AbstractPage.class.php","line":122,"function":"show","class":"wcf\\form\\RegisterForm","type":"->","args":[]},{"file":"\/home\/www\/borderline-forum.eu\/lib\/system\/request\/Request.class.php","line":89,"function":"__run","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/home\/www\/borderline-forum.eu\/lib\/system\/request\/RequestHandler.class.php","line":121,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/home\/www\/borderline-forum.eu\/index.php","line":11,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["wcf"]}]

Alles anzeigen

Shalin

Code

======
Error Class: PDOException
Error Message: SQLSTATE[HY000]: General error: 1364 Field 'newsNews' doesn't have a default value
Error Code: HY000
File: /home/www/borderline-forum.eu/lib/system/database/statement/PreparedStatement.class.php (126)
Extra Information: -
Stack Trace: [{"file":"\/home\/www\/borderline-forum.eu\/lib\/system\/database\/statement\/PreparedStatement.class.php","line":126,"function":"execute","class":"PDOStatement","type":"->","args":[["[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]"]]},{"file":"\/home\/www\/borderline-forum.eu\/lib\/data\/TFastCreate.class.php","line":44,"function":"execute","class":"wcf\\system\\database\\statement\\PreparedStatement","type":"->","args":[["[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]"]]},{"file":"\/home\/www\/borderline-forum.eu\/lib\/data\/DatabaseObjectEditor.class.php","line":28,"function":"dboEditorCreateBase","class":"wcf\\data\\DatabaseObjectEditor","type":"::","args":[{"disclaimerAcceptedAt":"[redacted]","minAgeConfirmedAt":"[redacted]","userString":"[redacted]","languageID":"[redacted]","registrationIpAddress":"[redacted]","activationCode":"[redacted]","emailConfirmed":"[redacted]","username":"[redacted]","email":"[redacted]","password":"[redacted]","blacklistMatches":"[redacted]","signatureEnableHtml":"[redacted]","accessToken":"[redacted]","registrationDate":"[redacted]"}]},{"file":"\/home\/www\/borderline-forum.eu\/lib\/data\/user\/UserEditor.class.php","line":80,"function":"create","class":"wcf\\data\\DatabaseObjectEditor","type":"::","args":[{"disclaimerAcceptedAt":"[redacted]","minAgeConfirmedAt":"[redacted]","userString":"[redacted]","languageID":"[redacted]","registrationIpAddress":"[redacted]","activationCode":"[redacted]","emailConfirmed":"[redacted]","username":"[redacted]","email":"[redacted]","password":"[redacted]","blacklistMatches":"[redacted]","signatureEnableHtml":"[redacted]","accessToken":"[redacted]","registrationDate":"[redacted]"}]},{"file":"\/home\/www\/borderline-forum.eu\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":355,"function":"create","class":"wcf\\data\\user\\UserEditor","type":"::","args":[{"disclaimerAcceptedAt":"[redacted]","minAgeConfirmedAt":"[redacted]","userString":"[redacted]","languageID":"[redacted]","registrationIpAddress":"[redacted]","activationCode":"[redacted]","emailConfirmed":"[redacted]","username":"[redacted]","email":"[redacted]","password":"[redacted]","blacklistMatches":"[redacted]","signatureEnableHtml":"[redacted]","accessToken":"[redacted]","registrationDate":"[redacted]"}]},{"file":"\/home\/www\/borderline-forum.eu\/lib\/data\/user\/UserAction.class.php","line":284,"function":"create","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/home\/www\/borderline-forum.eu\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":216,"function":"create","class":"wcf\\data\\user\\UserAction","type":"->","args":[]},{"file":"\/home\/www\/borderline-forum.eu\/lib\/form\/RegisterForm.class.php","line":453,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/home\/www\/borderline-forum.eu\/lib\/form\/AbstractForm.class.php","line":66,"function":"save","class":"wcf\\form\\RegisterForm","type":"->","args":[]},{"file":"\/home\/www\/borderline-forum.eu\/lib\/form\/AbstractForm.class.php","line":134,"function":"submit","class":"wcf\\form\\AbstractForm","type":"->","args":[]},{"file":"\/home\/www\/borderline-forum.eu\/lib\/acp\/form\/AbstractOptionListForm.class.php","line":111,"function":"readData","class":"wcf\\form\\AbstractForm","type":"->","args":[]},{"file":"\/home\/www\/borderline-forum.eu\/lib\/acp\/form\/UserAddForm.class.php","line":402,"function":"readData","class":"wcf\\acp\\form\\AbstractOptionListForm","type":"->","args":[]},{"file":"\/home\/www\/borderline-forum.eu\/lib\/form\/RegisterForm.class.php","line":246,"function":"readData","class":"wcf\\acp\\form\\UserAddForm","type":"->","args":[]},{"file":"\/home\/www\/borderline-forum.eu\/lib\/page\/AbstractPage.class.php","line":339,"function":"readData","class":"wcf\\form\\RegisterForm","type":"->","args":[]},{"file":"\/home\/www\/borderline-forum.eu\/lib\/form\/RegisterForm.class.php","line":301,"function":"show","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/home\/www\/borderline-forum.eu\/lib\/page\/AbstractPage.class.php","line":122,"function":"show","class":"wcf\\form\\RegisterForm","type":"->","args":[]},{"file":"\/home\/www\/borderline-forum.eu\/lib\/system\/request\/Request.class.php","line":89,"function":"__run","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/home\/www\/borderline-forum.eu\/lib\/system\/request\/RequestHandler.class.php","line":121,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/home\/www\/borderline-forum.eu\/index.php","line":11,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["wcf"]}]

Cyperghost

[jira='NEWS-106'][/jira]

Update ist soweit fast fertig. Werde ich morgen nochmal endgültig überprüfen und dann hochladen

Solltest du dies für dich aber vorerst ändern wollen, das es schon vorher geht.

Führ einfach folgende SQL Query per PHPMyAdmin/Datenbank aus

Code

ALTER TABLE wcf1_user MODIFY newsNews INT(10) NOT NULL DEFAULT 0;

Shalin

Hallo Cyperghost,

danke für den schnellen Fix, die Abfrage hat den Fehler behoben.

Jetzt kann man die Registrierung wieder abschließen.

Liebe Grüße,

Shalin

Registrierung defekt durch News System

Cyperghost 2. Juli 2022 um 01:15

Dragosius 23. Mai 2023 um 00:30

Dragosius 23. Mai 2023 um 00:30

Informationen

Über uns