WCF icon indicating copy to clipboard operation
WCF copied to clipboard
verified publisher icon WoltLab

DevTools: Database exception during creation of a top level main menu item

Open Fighter456 opened this issue 3 years ago • 0 comments

Currently it is impossible to use the dev tools for the creation of a top level menu item due to a raised database exception:

Sun, 24 Apr 2022 15:20:55 +0000
Message: Could not prepare statement 'INSERT INTO wcf1_menu_item                             (identifier,packageID,originIsSystem,title,externalURL,parent,menuID,parentItemID,showOrder,pageID)                 VALUES      (?,?,?,?,?,?,?,?,?,?)'
PHP version: 7.2.34
WoltLab Suite version: 5.5.0 Alpha 2
Request URI: POST /acp/index.php?devtools-project-pip-entry-add/1/&pip=menuItem
Referrer: http://*REDACTED*.local/acp/index.php?devtools-project-pip-entry-add/1/&pip=menuItem
User Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/15.4 Safari/605.1.15
Peak Memory Usage: 8406880/134217728
======
Error Class: wcf\system\database\exception\DatabaseQueryException
Error Message: Could not prepare statement 'INSERT INTO wcf1_menu_item                             (identifier,packageID,originIsSystem,title,externalURL,parent,menuID,parentItemID,showOrder,pageID)                 VALUES      (?,?,?,?,?,?,?,?,?,?)'
Error Code: 42S22
File: /Users/dennis/Sites/localhost/*REDACTED*/lib/system/database/Database.class.php (333)
Extra Information: -
Stack Trace: [{"file":"\/Users\/dennis\/Sites\/localhost\/*REDACTED*\/lib\/data\/TFastCreate.class.php","line":43,"function":"prepareStatement","class":"wcf\\system\\database\\Database","type":"->","args":["INSERT INTO wcf1_menu_item\n                            (identifier,packageID,originIsSystem,title,externalURL,parent,menuID,parentItemID,showOrder,pageID)\n                VALUES      (?,?,?,?,?,?,?,?,?,?)"]},{"file":"\/Users\/dennis\/Sites\/localhost\/*REDACTED*\/lib\/data\/DatabaseObjectEditor.class.php","line":28,"function":"dboEditorCreateBase","class":"wcf\\data\\DatabaseObjectEditor","type":"::","args":[{"identifier":"[redacted]","packageID":"[redacted]","originIsSystem":"[redacted]","title":"[redacted]","externalURL":"[redacted]","parent":"[redacted]","menuID":"[redacted]","parentItemID":"[redacted]","showOrder":"[redacted]","pageID":"[redacted]"}]},{"file":"\/Users\/dennis\/Sites\/localhost\/*REDACTED*\/lib\/data\/menu\/item\/MenuItemEditor.class.php","line":43,"function":"create","class":"wcf\\data\\DatabaseObjectEditor","type":"::","args":[{"identifier":"[redacted]","packageID":"[redacted]","originIsSystem":"[redacted]","title":"[redacted]","externalURL":"[redacted]","parent":"[redacted]","menuID":"[redacted]","parentItemID":"[redacted]","showOrder":"[redacted]","pageID":"[redacted]"}]},{"file":"\/Users\/dennis\/Sites\/localhost\/*REDACTED*\/lib\/system\/package\/plugin\/AbstractXMLPackageInstallationPlugin.class.php","line":302,"function":"create","class":"wcf\\data\\menu\\item\\MenuItemEditor","type":"::","args":[{"identifier":"[redacted]","packageID":"[redacted]","originIsSystem":"[redacted]","title":"[redacted]","externalURL":"[redacted]","parent":"[redacted]","menuID":"[redacted]","parentItemID":"[redacted]","showOrder":"[redacted]","pageID":"[redacted]"}]},{"file":"\/Users\/dennis\/Sites\/localhost\/*REDACTED*\/lib\/system\/package\/plugin\/MenuItemPackageInstallationPlugin.class.php","line":252,"function":"import","class":"wcf\\system\\package\\plugin\\AbstractXMLPackageInstallationPlugin","type":"->","args":[[],{"identifier":"[redacted]","packageID":"[redacted]","originIsSystem":"[redacted]","title":"[redacted]","externalURL":"[redacted]","parent":"[redacted]","menuID":"[redacted]","parentItemID":"[redacted]","showOrder":"[redacted]","pageID":"[redacted]"}]},{"file":"\/Users\/dennis\/Sites\/localhost\/*REDACTED*\/lib\/system\/devtools\/pip\/TXmlGuiPackageInstallationPlugin.class.php","line":608,"function":"import","class":"wcf\\system\\package\\plugin\\MenuItemPackageInstallationPlugin","type":"->","args":[[],{"identifier":"[redacted]","packageID":"[redacted]","originIsSystem":"[redacted]","title":"[redacted]","externalURL":"[redacted]","parent":"[redacted]","menuID":"[redacted]","parentItemID":"[redacted]","showOrder":"[redacted]","pageID":"[redacted]"}]},{"file":"\/Users\/dennis\/Sites\/localhost\/*REDACTED*\/lib\/system\/devtools\/pip\/TXmlGuiPackageInstallationPlugin.class.php","line":81,"function":"saveObject","class":"wcf\\system\\package\\plugin\\MenuItemPackageInstallationPlugin","type":"->","args":["DOMElement"]},{"file":"\/Users\/dennis\/Sites\/localhost\/*REDACTED*\/lib\/acp\/form\/DevtoolsProjectPipEntryAddForm.class.php","line":153,"function":"addEntry","class":"wcf\\system\\package\\plugin\\MenuItemPackageInstallationPlugin","type":"->","args":["wcf\\system\\form\\builder\\FormDocument"]},{"file":"\/Users\/dennis\/Sites\/localhost\/*REDACTED*\/lib\/form\/AbstractForm.class.php","line":80,"function":"save","class":"wcf\\acp\\form\\DevtoolsProjectPipEntryAddForm","type":"->","args":[]},{"file":"\/Users\/dennis\/Sites\/localhost\/*REDACTED*\/lib\/form\/AbstractForm.class.php","line":152,"function":"submit","class":"wcf\\form\\AbstractForm","type":"->","args":[]},{"file":"\/Users\/dennis\/Sites\/localhost\/*REDACTED*\/lib\/form\/AbstractFormBuilderForm.class.php","line":147,"function":"readData","class":"wcf\\form\\AbstractForm","type":"->","args":[]},{"file":"\/Users\/dennis\/Sites\/localhost\/*REDACTED*\/lib\/page\/AbstractPage.class.php","line":353,"function":"readData","class":"wcf\\form\\AbstractFormBuilderForm","type":"->","args":[]},{"file":"\/Users\/dennis\/Sites\/localhost\/*REDACTED*\/lib\/page\/AbstractPage.class.php","line":135,"function":"show","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/Users\/dennis\/Sites\/localhost\/*REDACTED*\/lib\/system\/request\/Request.class.php","line":90,"function":"__run","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/Users\/dennis\/Sites\/localhost\/*REDACTED*\/lib\/system\/request\/RequestHandler.class.php","line":105,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/Users\/dennis\/Sites\/localhost\/*REDACTED*\/acp\/index.php","line":11,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["wcf",true]}]
======
Error Class: PDOException
Error Message: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'parent' in 'field list'
Error Code: 42S22
File: /Users/dennis/Sites/localhost/*REDACTED*/lib/system/database/Database.class.php (328)
Extra Information: -
Stack Trace: [{"file":"\/Users\/dennis\/Sites\/localhost\/*REDACTED*\/lib\/system\/database\/Database.class.php","line":328,"function":"prepare","class":"PDO","type":"->","args":["INSERT INTO wcf1_menu_item\n                            (identifier,packageID,originIsSystem,title,externalURL,parent,menuID,parentItemID,showOrder,pageID)\n                VALUES      (?,?,?,?,?,?,?,?,?,?) -- '\/acp\/index.php?devtools-project-pip-entry-add\/1\/&pip=menuItem'"]},{"file":"\/Users\/dennis\/Sites\/localhost\/*REDACTED*\/lib\/data\/TFastCreate.class.php","line":43,"function":"prepareStatement","class":"wcf\\system\\database\\Database","type":"->","args":["INSERT INTO wcf1_menu_item\n                            (identifier,packageID,originIsSystem,title,externalURL,parent,menuID,parentItemID,showOrder,pageID)\n                VALUES      (?,?,?,?,?,?,?,?,?,?)"]},{"file":"\/Users\/dennis\/Sites\/localhost\/*REDACTED*\/lib\/data\/DatabaseObjectEditor.class.php","line":28,"function":"dboEditorCreateBase","class":"wcf\\data\\DatabaseObjectEditor","type":"::","args":[{"identifier":"[redacted]","packageID":"[redacted]","originIsSystem":"[redacted]","title":"[redacted]","externalURL":"[redacted]","parent":"[redacted]","menuID":"[redacted]","parentItemID":"[redacted]","showOrder":"[redacted]","pageID":"[redacted]"}]},{"file":"\/Users\/dennis\/Sites\/localhost\/*REDACTED*\/lib\/data\/menu\/item\/MenuItemEditor.class.php","line":43,"function":"create","class":"wcf\\data\\DatabaseObjectEditor","type":"::","args":[{"identifier":"[redacted]","packageID":"[redacted]","originIsSystem":"[redacted]","title":"[redacted]","externalURL":"[redacted]","parent":"[redacted]","menuID":"[redacted]","parentItemID":"[redacted]","showOrder":"[redacted]","pageID":"[redacted]"}]},{"file":"\/Users\/dennis\/Sites\/localhost\/*REDACTED*\/lib\/system\/package\/plugin\/AbstractXMLPackageInstallationPlugin.class.php","line":302,"function":"create","class":"wcf\\data\\menu\\item\\MenuItemEditor","type":"::","args":[{"identifier":"[redacted]","packageID":"[redacted]","originIsSystem":"[redacted]","title":"[redacted]","externalURL":"[redacted]","parent":"[redacted]","menuID":"[redacted]","parentItemID":"[redacted]","showOrder":"[redacted]","pageID":"[redacted]"}]},{"file":"\/Users\/dennis\/Sites\/localhost\/*REDACTED*\/lib\/system\/package\/plugin\/MenuItemPackageInstallationPlugin.class.php","line":252,"function":"import","class":"wcf\\system\\package\\plugin\\AbstractXMLPackageInstallationPlugin","type":"->","args":[[],{"identifier":"[redacted]","packageID":"[redacted]","originIsSystem":"[redacted]","title":"[redacted]","externalURL":"[redacted]","parent":"[redacted]","menuID":"[redacted]","parentItemID":"[redacted]","showOrder":"[redacted]","pageID":"[redacted]"}]},{"file":"\/Users\/dennis\/Sites\/localhost\/*REDACTED*\/lib\/system\/devtools\/pip\/TXmlGuiPackageInstallationPlugin.class.php","line":608,"function":"import","class":"wcf\\system\\package\\plugin\\MenuItemPackageInstallationPlugin","type":"->","args":[[],{"identifier":"[redacted]","packageID":"[redacted]","originIsSystem":"[redacted]","title":"[redacted]","externalURL":"[redacted]","parent":"[redacted]","menuID":"[redacted]","parentItemID":"[redacted]","showOrder":"[redacted]","pageID":"[redacted]"}]},{"file":"\/Users\/dennis\/Sites\/localhost\/*REDACTED*\/lib\/system\/devtools\/pip\/TXmlGuiPackageInstallationPlugin.class.php","line":81,"function":"saveObject","class":"wcf\\system\\package\\plugin\\MenuItemPackageInstallationPlugin","type":"->","args":["DOMElement"]},{"file":"\/Users\/dennis\/Sites\/localhost\/*REDACTED*\/lib\/acp\/form\/DevtoolsProjectPipEntryAddForm.class.php","line":153,"function":"addEntry","class":"wcf\\system\\package\\plugin\\MenuItemPackageInstallationPlugin","type":"->","args":["wcf\\system\\form\\builder\\FormDocument"]},{"file":"\/Users\/dennis\/Sites\/localhost\/*REDACTED*\/lib\/form\/AbstractForm.class.php","line":80,"function":"save","class":"wcf\\acp\\form\\DevtoolsProjectPipEntryAddForm","type":"->","args":[]},{"file":"\/Users\/dennis\/Sites\/localhost\/*REDACTED*\/lib\/form\/AbstractForm.class.php","line":152,"function":"submit","class":"wcf\\form\\AbstractForm","type":"->","args":[]},{"file":"\/Users\/dennis\/Sites\/localhost\/*REDACTED*\/lib\/form\/AbstractFormBuilderForm.class.php","line":147,"function":"readData","class":"wcf\\form\\AbstractForm","type":"->","args":[]},{"file":"\/Users\/dennis\/Sites\/localhost\/*REDACTED*\/lib\/page\/AbstractPage.class.php","line":353,"function":"readData","class":"wcf\\form\\AbstractFormBuilderForm","type":"->","args":[]},{"file":"\/Users\/dennis\/Sites\/localhost\/*REDACTED*\/lib\/page\/AbstractPage.class.php","line":135,"function":"show","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/Users\/dennis\/Sites\/localhost\/*REDACTED*\/lib\/system\/request\/Request.class.php","line":90,"function":"__run","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/Users\/dennis\/Sites\/localhost\/*REDACTED*\/lib\/system\/request\/RequestHandler.class.php","line":105,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/Users\/dennis\/Sites\/localhost\/*REDACTED*\/acp\/index.php","line":11,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["wcf",true]}]

Steps to reproduce:

Create a new menu item with the following selection and values:

  • Menu Item Identifier: com.example.app.testEntry
  • Title: Test for both languages
  • Menu: com.woltlab.wcf.mainMenu
  • Parent Menu Item (optional): (No selection) (leave the default value)
  • Menu Item Link Type: Internal
  • Page: Select one of the available pages

Fighter456 avatar Apr 24 '22 15:04 Fighter456