首页 > 解决方案 > 解决 Akeneo pim 上的用户表错误

问题描述

我在集群中安装了 Akeneo 一个 pim(基于 Symfony 和 react 的产品界面管理器)。一切都按我的意愿进行,除了阻止某些操作的错误,尤其是产品创建。

每次选择视图时,都会出现这种错误,与数据库有关。文档非常糟糕,我希望有人遇到过同样的情况。

\"CREATE_TIME\" not available for table \"oro_user\"

这是整个错误跟踪

[2021-05-27 14:36:55] request.INFO: Matched route "pim_analytics_data_collect". {"route":"pim_analytics_data_collect","route_parameters":{"_route":"pim_analytics_data_collect","_controller":"pim_analytics.controller.data:collectAction","_format":"json"},"request_uri":/analytics/collect_data","method":"GET"} []
[2021-05-27 14:36:55] request.CRITICAL: Uncaught PHP Exception Akeneo\Platform\Bundle\InstallerBundle\Exception\UnavailableCreationTimeException: ""CREATE_TIME" not available for table "oro_user"" at /srv/pim/vendor/akeneo/pim-community-dev/src/Akeneo/Platform/Bundle/InstallerBundle/InstallStatusManager/InstallStatusManager.php line 67 {"exception":"[object] (Akeneo\\Platform\\Bundle\\InstallerBundle\\Exception\\UnavailableCreationTimeException(code: 0): \"CREATE_TIME\" not available for table \"oro_user\" at /srv/pim/vendor/akeneo/pim-community-dev/src/Akeneo/Platform/Bundle/InstallerBundle/InstallStatusManager/InstallStatusManager.php:67)"} []
[2021-05-27 14:36:55] request.INFO: Matched route "pim_analytics_data_collect". {"route":"pim_analytics_data_collect","route_parameters":{"_route":"pim_analytics_data_collect","_controller":"pim_analytics.controller.data:collectAction","_format":"json"},"request_uri":"/analytics/collect_data","method":"GET"} []
[2021-05-27 14:36:55] request.CRITICAL: Uncaught PHP Exception Akeneo\Platform\Bundle\InstallerBundle\Exception\UnavailableCreationTimeException: ""CREATE_TIME" not available for table "oro_user"" at /srv/pim/vendor/akeneo/pim-community-dev/src/Akeneo/Platform/Bundle/InstallerBundle/InstallStatusManager/InstallStatusManager.php line 67 {"exception":"[object] (Akeneo\\Platform\\Bundle\\InstallerBundle\\Exception\\UnavailableCreationTimeException(code: 0): \"CREATE_TIME\" not available for table \"oro_user\" at /srv/pim/vendor/akeneo/pim-community-dev/src/Akeneo/Platform/Bundle/InstallerBundle/InstallStatusManager/InstallStatusManager.php:67)"} []

标签: phpsymfonyakeneo

解决方案


Pay attention You MUST install MySQL and NOT MariaDb

That was the solution for me !


推荐阅读