BlackbitDigitalCommerce / pimcore-data-director

Import Bundle for Pimcore
16 stars 3 forks source link

Grid dynamic export #62

Open betterapp opened 1 year ago

betterapp commented 1 year ago

When I want to use one of those functions: image

I got error:

[2022-11-14 13:51:12] request.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception: "An exception occurred while executing 'UPDATE users SET apiKey=? WHERE id = ?' with params [{"type":"user","password":"***","firstname":"","lastname":"","email":"","language":"en","admin":true,"active":true,"roles":[],"welcomescreen":false,"closeWarning":true,"memorizeTabs":true,"allowDirtyClose":false,"apiKey":"**","contentLanguages":"en,nb","activePerspective":"default","lastLogin":1668425575,"keyBindings":"[{\"action\":\"save\",\"key\":83,\"ctrl\":true},{\"action\":\"publish\",\"key\":80,\"ctrl\":true,\"shift\":true},{\"action\":\"unpublish\",\"key\":85,\"ctrl\":true,\"shift\":true},{\"action\":\"rename\",\"key\":82,\"alt\":true,\"shift\":true},{\"action\":\"refresh\",\"key\":116},{\"action\":\"openDocument\",\"key\":68,\"ctrl\":true,\"shift\":true},{\"action\":\"openAsset\",\"key\":65,\"ctrl\":true,\"shift\":true},{\"action\":\"openObject\",\"key\":79,\"ctrl\":true,\"shift\":true},{\"action\":\"openClassEditor\",\"key\":67,\"ctrl\":true,\"shift\":true},{\"action\":\"openInTree\",\"key\":76,\"ctrl\":true,\"shift\":true},{\"action\":\"showMetaInfo\",\"key\":73,\"alt\":true},{\"action\":\"searchDocument\",\"key\":87,\"alt\":true},{\"action\":\"searchAsset\",\"key\":65,\"alt\":true},{\"action\":\"searchObject\",\"key\":79,\"alt\":true},{\"action\":\"showElementHistory\",\"key\":72,\"alt\":true},{\"action\":\"closeAllTabs\",\"key\":84,\"alt\":true},{\"action\":\"searchAndReplaceAssignments\",\"key\":83,\"alt\":true},{\"action\":\"glossary\",\"key\":71,\"shift\":true,\"alt\":true},{\"action\":\"redirects\",\"key\":82,\"ctrl\":false,\"alt\":true},{\"action\":\"sharedTranslations\",\"key\":84,\"ctrl\":true,\"alt\":true},{\"action\":\"recycleBin\",\"key\":82,\"ctrl\":true,\"alt\":true},{\"action\":\"notesEvents\",\"key\":78,\"ctrl\":true,\"alt\":true},{\"action\":\"applicationLogger\",\"key\":76,\"ctrl\":true,\"alt\":true},{\"action\":\"reports\",\"key\":77,\"ctrl\":true,\"alt\":true},{\"action\":\"tagManager\",\"key\":72,\"ctrl\":true,\"alt\":true},{\"action\":\"seoDocumentEditor\",\"key\":83,\"ctrl\":true,\"alt\":true},{\"action\":\"robots\",\"key\":74,\"ctrl\":true,\"alt\":true},{\"action\":\"httpErrorLog\",\"key\":79,\"ctrl\":true,\"alt\":true},{\"action\":\"customReports\",\"key\":67,\"ctrl\":true,\"alt\":true},{\"action\":\"tagConfiguration\",\"key\":78,\"ctrl\":true,\"alt\":true},{\"action\":\"users\",\"key\":85,\"ctrl\":true,\"alt\":true},{\"action\":\"roles\",\"key\":80,\"ctrl\":true,\"alt\":true},{\"action\":\"clearAllCaches\",\"key\":81,\"ctrl\":false,\"alt\":true},{\"action\":\"clearDataCache\",\"key\":67,\"ctrl\":false,\"alt\":true},{\"action\":\"quickSearch\",\"key\":70,\"ctrl\":true,\"shift\":true}]","twoFactorAuthentication":{"required":false,"enabled":false,"secret":"","type":""},"permissions":["admin_translations","application_logging","asset_metadata","assets","bundle_adminstyles_manage","bundle_advancedsearch_search","bundle_completeness_rules","bundle_configurator","bundle_dynamic_layouts","bundle_fields_observer","bundle_imagerelations","classes","clear_cache","clear_fullpage_cache","clear_temp_files","colorpicker_palettes","dashboards","Dataport 11 Configuration","Dataport 11 Execution","Dataport 13 Configuration","Dataport 13 Execution","Dataport 14 Configuration","Dataport 14 Execution","Dataport 15 Configuration","Dataport 15 Execution","Dataport 22 Configuration","Dataport 22 Execution","Dataport 24 Configuration","Dataport 24 Execution","Dataport 25 Configuration","Dataport 25 Execution","Dataport 26 Configuration","Dataport 26 Execution","Dataport 27 Configuration","Dataport 27 Execution","Dataport 28 Configuration","Dataport 28 Execution","Dataport 29 Configuration","Dataport 29 Execution","Dataport 30 Configuration","Dataport 30 Execution","Dataport 31 Configuration","Dataport 31 Execution","Dataport 32 Configuration","Dataport 32 Execution","Dataport 33 Configuration","Dataport 33 Execution","Dataport 34 Configuration","Dataport 34 Execution","Dataport 35 Configuration","Dataport 35 Execution","Dataport 36 Configuration","Dataport 36 Execution","Dataport 37 Configuration","Dataport 37 Execution","Dataport 38 Configuration","Dataport 38 Execution","Dataport 40 Configuration","Dataport 40 Execution","Dataport 41 Configuration","Dataport 41 Execution","Dataport 42 Configuration","Dataport 42 Execution","Dataport 43 Configuration","Dataport 43 Execution","Dataport 44 Configuration","Dataport 44 Execution","Dataport 45 Configuration","Dataport 45 Execution","Dataport 46 Configuration","Dataport 46 Execution","Dataport 48 Configuration","Dataport 48 Execution","Dataport 49 Configuration","Dataport 49 Execution","Dataport 5 Configuration","Dataport 5 Execution","Dataport 50 Configuration","Dataport 50 Execution","Dataport 52 Configuration","Dataport 52 Execution","Dataport 53 Configuration","Dataport 53 Execution","Dataport 7 Configuration","Dataport 7 Execution","Dataport 8 Configuration","Dataport 8 Execution","document_types","documents","emails","gdpr_data_extractor","glossary","http_errors","notes_events","notifications","notifications_send","objects","perspective_editor","piwik_reports","piwik_settings","plugin_bb_pim","plugin_datahub_config","plugin_pm_permission_configure","plugin_pm_permission_delete_monitoring_item","plugin_pm_permission_execute","plugin_pm_permission_view","plugins","predefined_properties","qr_codes","recyclebin","redirects","reports","reports_config","robots.txt","routes","seemode","seo_document_editor","share_configurations","system_settings","tag_snippet_management","tags_assignment","tags_configuration","tags_search","targeting","thumbnails","translations","users","web2print_settings","website_settings","workflow_details","workflow_gui","Dataport 56 Configuration","Dataport 56 Execution","Dataport 57 Configuration","Dataport 57 Execution","Dataport 58 Configuration","Dataport 58 Execution","Dataport 59 Configuration","Dataport 59 Execution","Dataport 62 Configuration","Dataport 62 Execution","Dataport 63 Configuration","Dataport 63 Execution","Dataport 64 Configuration","Dataport 64 Execution","Dataport 65 Configuration","Dataport 65 Execution","Dataport 66 Configuration","Dataport 66 Execution","Dataport 67 Configuration","Dataport 67 Execution","Dataport 68 Configuration","Dataport 68 Execution","Dataport 69 Configuration","Dataport 69 Execution","Dataport 70 Configuration","Dataport 70 Execution","Dataport 71 Configuration","Dataport 71 Execution","Dataport 72 Configuration","Dataport 72 Execution","Dataport 73 Configuration","Dataport 73 Execution","Dataport 74 Configuration","Dataport 74 Execution","Dataport 78 Configuration","Dataport 78 Execution","Dataport 79 Configuration","Dataport 79 Execution","Dataport 80 Configuration","Dataport 80 Execution","Dataport 81 Configuration","Dataport 81 Execution","Dataport 82 Configuration","Dataport 82 Execution","Dataport 83 Configuration","Dataport 83 Execution","Dataport 84 Configuration","Dataport 84 Execution","Dataport 85 Configuration","Dataport 85 Execution","Dataport 86 Configuration","Dataport 86 Execution","Dataport 87 Configuration","Dataport 87 Execution"],"workspacesAsset":[],"workspacesObject":[],"workspacesDocument":[],"classes":[],"docTypes":[],"perspectives":[],"websiteTranslationLanguagesView":[],"websiteTranslationLanguagesEdit":[],"id":2,"parentId":0,"name":"admin"}, 2]: Object of class Pimcore\Model\User could not be converted to string" at /mnt/**/www/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 185 {"exception":"[object] (Doctrine\DBAL\Exception(code: 0): An exception occurred while executing 'UPDATE users SET apiKey=? WHERE id = ?' with params [{\"type\":\"user\",\"password\":\"*",\"firstname\":\"\",\"lastname\":\"\",\"email\":\"\",\"language\":\"en\",\"admin\":true,\"active\":true,\"roles\":[],\"welcomescreen\":false,\"closeWarning\":true,\"memorizeTabs\":true,\"allowDirtyClose\":false,\"apiKey\":\"**\",\"contentLanguages\":\"en,nb\",\"activePerspective\":\"default\",\"lastLogin\":1668425575,\"keyBindings\":\"[{\\"action\\":\\"save\\",\\"key\\":83,\\"ctrl\\":true},{\\"action\\":\\"publish\\",\\"key\\":80,\\"ctrl\\":true,\\"shift\\":true},{\\"action\\":\\"unpublish\\",\\"key\\":85,\\"ctrl\\":true,\\"shift\\":true},{\\"action\\":\\"rename\\",\\"key\\":82,\\"alt\\":true,\\"shift\\":true},{\\"action\\":\\"refresh\\",\\"key\\":116},{\\"action\\":\\"openDocument\\",\\"key\\":68,\\"ctrl\\":true,\\"shift\\":true},{\\"action\\":\\"openAsset\\",\\"key\\":65,\\"ctrl\\":true,\\"shift\\":true},{\\"action\\":\\"openObject\\",\\"key\\":79,\\"ctrl\\":true,\\"shift\\":true},{\\"action\\":\\"openClassEditor\\",\\"key\\":67,\\"ctrl\\":true,\\"shift\\":true},{\\"action\\":\\"openInTree\\",\\"key\\":76,\\"ctrl\\":true,\\"shift\\":true},{\\"action\\":\\"showMetaInfo\\",\\"key\\":73,\\"alt\\":true},{\\"action\\":\\"searchDocument\\",\\"key\\":87,\\"alt\\":true},{\\"action\\":\\"searchAsset\\",\\"key\\":65,\\"alt\\":true},{\\"action\\":\\"searchObject\\",\\"key\\":79,\\"alt\\":true},{\\"action\\":\\"showElementHistory\\",\\"key\\":72,\\"alt\\":true},{\\"action\\":\\"closeAllTabs\\",\\"key\\":84,\\"alt\\":true},{\\"action\\":\\"searchAndReplaceAssignments\\",\\"key\\":83,\\"alt\\":true},{\\"action\\":\\"glossary\\",\\"key\\":71,\\"shift\\":true,\\"alt\\":true},{\\"action\\":\\"redirects\\",\\"key\\":82,\\"ctrl\\":false,\\"alt\\":true},{\\"action\\":\\"sharedTranslations\\",\\"key\\":84,\\"ctrl\\":true,\\"alt\\":true},{\\"action\\":\\"recycleBin\\",\\"key\\":82,\\"ctrl\\":true,\\"alt\\":true},{\\"action\\":\\"notesEvents\\",\\"key\\":78,\\"ctrl\\":true,\\"alt\\":true},{\\"action\\":\\"applicationLogger\\",\\"key\\":76,\\"ctrl\\":true,\\"alt\\":true},{\\"action\\":\\"reports\\",\\"key\\":77,\\"ctrl\\":true,\\"alt\\":true},{\\"action\\":\\"tagManager\\",\\"key\\":72,\\"ctrl\\":true,\\"alt\\":true},{\\"action\\":\\"seoDocumentEditor\\",\\"key\\":83,\\"ctrl\\":true,\\"alt\\":true},{\\"action\\":\\"robots\\",\\"key\\":74,\\"ctrl\\":true,\\"alt\\":true},{\\"action\\":\\"httpErrorLog\\",\\"key\\":79,\\"ctrl\\":true,\\"alt\\":true},{\\"action\\":\\"customReports\\",\\"key\\":67,\\"ctrl\\":true,\\"alt\\":true},{\\"action\\":\\"tagConfiguration\\",\\"key\\":78,\\"ctrl\\":true,\\"alt\\":true},{\\"action\\":\\"users\\",\\"key\\":85,\\"ctrl\\":true,\\"alt\\":true},{\\"action\\":\\"roles\\",\\"key\\":80,\\"ctrl\\":true,\\"alt\\":true},{\\"action\\":\\"clearAllCaches\\",\\"key\\":81,\\"ctrl\\":false,\\"alt\\":true},{\\"action\\":\\"clearDataCache\\",\\"key\\":67,\\"ctrl\\":false,\\"alt\\":true},{\\"action\\":\\"quickSearch\\",\\"key\\":70,\\"ctrl\\":true,\\"shift\\":true}]\",\"twoFactorAuthentication\":{\"required\":false,\"enabled\":false,\"secret\":\"\",\"type\":\"\"},\"permissions\":[\"admin_translations\",\"application_logging\",\"asset_metadata\",\"assets\",\"bundle_adminstyles_manage\",\"bundle_advancedsearch_search\",\"bundle_completeness_rules\",\"bundle_configurator\",\"bundle_dynamic_layouts\",\"bundle_fields_observer\",\"bundle_imagerelations\",\"classes\",\"clear_cache\",\"clear_fullpage_cache\",\"clear_temp_files\",\"colorpicker_palettes\",\"dashboards\",\"Dataport 11 Configuration\",\"Dataport 11 Execution\",\"Dataport 13 Configuration\",\"Dataport 13 Execution\",\"Dataport 14 Configuration\",\"Dataport 14 Execution\",\"Dataport 15 Configuration\",\"Dataport 15 Execution\",\"Dataport 22 Configuration\",\"Dataport 22 Execution\",\"Dataport 24 Configuration\",\"Dataport 24 Execution\",\"Dataport 25 Configuration\",\"Dataport 25 Execution\",\"Dataport 26 Configuration\",\"Dataport 26 Execution\",\"Dataport 27 Configuration\",\"Dataport 27 Execution\",\"Dataport 28 Configuration\",\"Dataport 28 Execution\",\"Dataport 29 Configuration\",\"Dataport 29 Execution\",\"Dataport 30 Configuration\",\"Dataport 30 Execution\",\"Dataport 31 Configuration\",\"Dataport 31 Execution\",\"Dataport 32 Configuration\",\"Dataport 32 Execution\",\"Dataport 33 Configuration\",\"Dataport 33 Execution\",\"Dataport 34 Configuration\",\"Dataport 34 Execution\",\"Dataport 35 Configuration\",\"Dataport 35 Execution\",\"Dataport 36 Configuration\",\"Dataport 36 Execution\",\"Dataport 37 Configuration\",\"Dataport 37 Execution\",\"Dataport 38 Configuration\",\"Dataport 38 Execution\",\"Dataport 40 Configuration\",\"Dataport 40 Execution\",\"Dataport 41 Configuration\",\"Dataport 41 Execution\",\"Dataport 42 Configuration\",\"Dataport 42 Execution\",\"Dataport 43 Configuration\",\"Dataport 43 Execution\",\"Dataport 44 Configuration\",\"Dataport 44 Execution\",\"Dataport 45 Configuration\",\"Dataport 45 Execution\",\"Dataport 46 Configuration\",\"Dataport 46 Execution\",\"Dataport 48 Configuration\",\"Dataport 48 Execution\",\"Dataport 49 Configuration\",\"Dataport 49 Execution\",\"Dataport 5 Configuration\",\"Dataport 5 Execution\",\"Dataport 50 Configuration\",\"Dataport 50 Execution\",\"Dataport 52 Configuration\",\"Dataport 52 Execution\",\"Dataport 53 Configuration\",\"Dataport 53 Execution\",\"Dataport 7 Configuration\",\"Dataport 7 Execution\",\"Dataport 8 Configuration\",\"Dataport 8 Execution\",\"document_types\",\"documents\",\"emails\",\"gdpr_data_extractor\",\"glossary\",\"http_errors\",\"notes_events\",\"notifications\",\"notifications_send\",\"objects\",\"perspective_editor\",\"piwik_reports\",\"piwik_settings\",\"plugin_bb_pim\",\"plugin_datahub_config\",\"plugin_pm_permission_configure\",\"plugin_pm_permission_delete_monitoring_item\",\"plugin_pm_permission_execute\",\"plugin_pm_permission_view\",\"plugins\",\"predefined_properties\",\"qr_codes\",\"recyclebin\",\"redirects\",\"reports\",\"reports_config\",\"robots.txt\",\"routes\",\"seemode\",\"seo_document_editor\",\"share_configurations\",\"system_settings\",\"tag_snippet_management\",\"tags_assignment\",\"tags_configuration\",\"tags_search\",\"targeting\",\"thumbnails\",\"translations\",\"users\",\"web2print_settings\",\"website_settings\",\"workflow_details\",\"workflow_gui\",\"Dataport 56 Configuration\",\"Dataport 56 Execution\",\"Dataport 57 Configuration\",\"Dataport 57 Execution\",\"Dataport 58 Configuration\",\"Dataport 58 Execution\",\"Dataport 59 Configuration\",\"Dataport 59 Execution\",\"Dataport 62 Configuration\",\"Dataport 62 Execution\",\"Dataport 63 Configuration\",\"Dataport 63 Execution\",\"Dataport 64 Configuration\",\"Dataport 64 Execution\",\"Dataport 65 Configuration\",\"Dataport 65 Execution\",\"Dataport 66 Configuration\",\"Dataport 66 Execution\",\"Dataport 67 Configuration\",\"Dataport 67 Execution\",\"Dataport 68 Configuration\",\"Dataport 68 Execution\",\"Dataport 69 Configuration\",\"Dataport 69 Execution\",\"Dataport 70 Configuration\",\"Dataport 70 Execution\",\"Dataport 71 Configuration\",\"Dataport 71 Execution\",\"Dataport 72 Configuration\",\"Dataport 72 Execution\",\"Dataport 73 Configuration\",\"Dataport 73 Execution\",\"Dataport 74 Configuration\",\"Dataport 74 Execution\",\"Dataport 78 Configuration\",\"Dataport 78 Execution\",\"Dataport 79 Configuration\",\"Dataport 79 Execution\",\"Dataport 80 Configuration\",\"Dataport 80 Execution\",\"Dataport 81 Configuration\",\"Dataport 81 Execution\",\"Dataport 82 Configuration\",\"Dataport 82 Execution\",\"Dataport 83 Configuration\",\"Dataport 83 Execution\",\"Dataport 84 Configuration\",\"Dataport 84 Execution\",\"Dataport 85 Configuration\",\"Dataport 85 Execution\",\"Dataport 86 Configuration\",\"Dataport 86 Execution\",\"Dataport 87 Configuration\",\"Dataport 87 Execution\"],\"workspacesAsset\":[],\"workspacesObject\":[],\"workspacesDocument\":[],\"classes\":[],\"docTypes\":[],\"perspectives\":[],\"websiteTranslationLanguagesView\":[],\"websiteTranslationLanguagesEdit\":[],\"id\":2,\"parentId\":0,\"name\":\"admin\"}, 2]:\n\nObject of class Pimcore\Model\User could not be converted to string at /mnt/***/www/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:185, Error(code: 0): Object of class Pimcore\Model\User could not be converted to string at /mnt/**/www/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:67)"} []

BlackbitDevs commented 1 year ago

Should have been fixed in 3.2.17.

Just tested in Pimcore 10.5 with DD 3.2.22, there it works.