Fehler bei Profilfeld "boolean" + Optionen

  • Betroffene App
    WoltLab Suite Core

    Hallo,

    Natürlich macht die Auswahl des Profilfeldtyps boolean und die Angabe von Optionen keinen Sinn.

    Dennoch: Wenn man boolean als Feldtyp auswählt und Auswahloptionen ausgibt, einmalig eine Fehlermeldung.

    Ich konnte den Fehler allerdings nicht erneut reproduzieren, denn danach wurden beliebig viele Auswahlmöglichkeiten ohne Fehler akzeptiert.

    Natürlich finden sie dann im Frontend keine Anwendung.

  • Mon, 03 Sep 2018 06:36:38 +0000

    Message: Could not execute statement 'ALTER TABLE `wcf1_user_option_value` CHANGE COLUMN `userOption56` `userOption56` tinyint(1) NOT NULL DEFAULT 0'

    PHP version: 7.0.30-nmm1

    WoltLab Suite version: 3.1.5 pl 1

    Request URI: /acp/index.php?user-option-edit/56/

    Referrer: http://XYZ.de/acp/index.php?user-option-edit/56/

    User Agent: Mozilla/5.0 (Windows NT 6.1; Win64; x64; Trident/7.0; rv:11.0) like Gecko

    Peak Memory Usage: 7973688/268435456

    ======

    Error Class: wcf\system\database\exception\DatabaseQueryExecutionException

    Error Message: Could not execute statement 'ALTER TABLE `wcf1_user_option_value` CHANGE COLUMN `userOption56` `userOption56` tinyint(1) NOT NULL DEFAULT 0'

    Error Code: 0

    File: /www/htdocs/.../XYZ.de/lib/system/database/statement/PreparedStatement.class.php (105)

    Extra Information: YTowOnt9

    Stack Trace: [{"file":"\/www\/htdocs\/...\/XYZ.de\/lib\/system\/database\/editor\/MySQLDatabaseEditor.class.php","line":124,"function":"execute","class":"wcf\\system\\database\\statement\\PreparedStatement","type":"->","args":[]},{"file":"\/www\/htdocs\/...\/XYZ.de\/lib\/data\/user\/option\/UserOptionEditor.class.php","line":59,"function":"alterColumn","class":"wcf\\system\\database\\editor\\MySQLDatabaseEditor","type":"->","args":["wcf1_user_option_value","userOption56","userOption56",{"autoIncrement":"[redacted]","key":"[redacted]","notNull":"[redacted]","type":"[redacted]","default":"[redacted]","length":"[redacted]"}]},{"file":"\/www\/htdocs\/...\/XYZ.de\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":367,"function":"update","class":"wcf\\data\\user\\option\\UserOptionEditor","type":"->","args":[{"categoryName":"[redacted]","optionType":"[redacted]","defaultValue":"[redacted]","showOrder":"[redacted]","outputClass":"[redacted]","validationPattern":"[redacted]","selectOptions":"[redacted]","required":"[redacted]","askDuringRegistration":"[redacted]","searchable":"[redacted]","editable":"[redacted]","visible":"[redacted]","additionalData":"[redacted]"}]},{"function":"update","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[],"file":"[internal function]","line":"?"},{"file":"\/www\/htdocs\/...\/XYZ.de\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":204,"function":"call_user_func","args":[["[redacted]","[redacted]"]],"class":"","type":""},{"file":"\/www\/htdocs\/...\/XYZ.de\/lib\/acp\/form\/UserOptionEditForm.class.php","line":96,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/www\/htdocs\/...\/XYZ.de\/lib\/form\/AbstractForm.class.php","line":62,"function":"save","class":"wcf\\acp\\form\\UserOptionEditForm","type":"->","args":[]},{"file":"\/www\/htdocs\/...\/XYZ.de\/lib\/form\/AbstractForm.class.php","line":113,"function":"submit","class":"wcf\\form\\AbstractForm","type":"->","args":[]},{"file":"\/www\/htdocs\/...\/XYZ.de\/lib\/acp\/form\/UserOptionEditForm.class.php","line":106,"function":"readData","class":"wcf\\form\\AbstractForm","type":"->","args":[]},{"file":"\/www\/htdocs\/...\/XYZ.de\/lib\/page\/AbstractPage.class.php","line":291,"function":"readData","class":"wcf\\acp\\form\\UserOptionEditForm","type":"->","args":[]},{"file":"\/www\/htdocs\/...\/XYZ.de\/lib\/page\/AbstractPage.class.php","line":114,"function":"show","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/www\/htdocs\/...\/XYZ.de\/lib\/system\/request\/Request.class.php","line":83,"function":"__run","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/www\/htdocs\/...\/XYZ.de\/lib\/system\/request\/RequestHandler.class.php","line":96,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/www\/htdocs\/...\/XYZ.de\/acp\/index.php","line":9,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["wcf",true]}]

    ======

    Error Class: PDOException

    Error Message: SQLSTATE[HY000]: General error: 1366 Incorrect integer value: 'Ja' for column 'userOption56' at row 1

    Error Code: 0

    File: /www/htdocs/.../XYZ.de/lib/system/database/statement/PreparedStatement.class.php (93)

    Extra Information: -

    Stack Trace: [{"file":"\/www\/htdocs\/...\/XYZ.de\/lib\/system\/database\/statement\/PreparedStatement.class.php","line":93,"function":"execute","class":"PDOStatement","type":"->","args":[[]]},{"file":"\/www\/htdocs\/...\/XYZ.de\/lib\/system\/database\/editor\/MySQLDatabaseEditor.class.php","line":124,"function":"execute","class":"wcf\\system\\database\\statement\\PreparedStatement","type":"->","args":[]},{"file":"\/www\/htdocs\/...\/XYZ.de\/lib\/data\/user\/option\/UserOptionEditor.class.php","line":59,"function":"alterColumn","class":"wcf\\system\\database\\editor\\MySQLDatabaseEditor","type":"->","args":["wcf1_user_option_value","userOption56","userOption56",{"autoIncrement":"[redacted]","key":"[redacted]","notNull":"[redacted]","type":"[redacted]","default":"[redacted]","length":"[redacted]"}]},{"file":"\/www\/htdocs\/...\/XYZ.de\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":367,"function":"update","class":"wcf\\data\\user\\option\\UserOptionEditor","type":"->","args":[{"categoryName":"[redacted]","optionType":"[redacted]","defaultValue":"[redacted]","showOrder":"[redacted]","outputClass":"[redacted]","validationPattern":"[redacted]","selectOptions":"[redacted]","required":"[redacted]","askDuringRegistration":"[redacted]","searchable":"[redacted]","editable":"[redacted]","visible":"[redacted]","additionalData":"[redacted]"}]},{"function":"update","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[],"file":"[internal function]","line":"?"},{"file":"\/www\/htdocs\/...\/XYZ.de\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":204,"function":"call_user_func","args":[["[redacted]","[redacted]"]],"class":"","type":""},{"file":"\/www\/htdocs\/...\/XYZ.de\/lib\/acp\/form\/UserOptionEditForm.class.php","line":96,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/www\/htdocs\/...\/XYZ.de\/lib\/form\/AbstractForm.class.php","line":62,"function":"save","class":"wcf\\acp\\form\\UserOptionEditForm","type":"->","args":[]},{"file":"\/www\/htdocs\/...\/XYZ.de\/lib\/form\/AbstractForm.class.php","line":113,"function":"submit","class":"wcf\\form\\AbstractForm","type":"->","args":[]},{"file":"\/www\/htdocs\/...\/XYZ.de\/lib\/acp\/form\/UserOptionEditForm.class.php","line":106,"function":"readData","class":"wcf\\form\\AbstractForm","type":"->","args":[]},{"file":"\/www\/htdocs\/...\/XYZ.de\/lib\/page\/AbstractPage.class.php","line":291,"function":"readData","class":"wcf\\acp\\form\\UserOptionEditForm","type":"->","args":[]},{"file":"\/www\/htdocs\/...\/XYZ.de\/lib\/page\/AbstractPage.class.php","line":114,"function":"show","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/www\/htdocs\/...\/XYZ.de\/lib\/system\/request\/Request.class.php","line":83,"function":"__run","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/www\/htdocs\/...\/XYZ.de\/lib\/system\/request\/RequestHandler.class.php","line":96,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/www\/htdocs\/...\/XYZ.de\/acp\/index.php","line":9,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["wcf",true]}]

  • Marcel Werk 30. Januar 2019 um 17:00

    Hat das Label 5.2.0 Beta 1 hinzugefügt.
  • Marcel Werk 24. Februar 2019 um 16:24

    Hat das Label Behoben hinzugefügt.

Jetzt mitmachen!

Sie haben noch kein Benutzerkonto auf unserer Seite? Registrieren Sie sich kostenlos und nehmen Sie an unserer Community teil!