解决用户在Akeneo pim上的表错误

Question

我在集群中安装了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)"} []

Answer 1

请注意，您必须安装MySQL，而不是MariaDb

这就是我的解决方案！