Fehler bei Profilfeld "boolean" + Optionen

  • 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.

    • Official Post

    Fehlermeldungen werden üblicherweise im Protokoll erfasst, bitte sieh im ACP nach und suche die Fehlermeldung raus.

    Alexander Ebert
    Senior Developer WoltLab® GmbH

  • 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

    Added the Label 5.2.0 Beta 1