akeneo / pim-docs

[Community Documentation Repository] The open source Product Information Management (PIM)
http://docs.akeneo.com/latest/index.html
58 stars 149 forks source link

Akeneo Pim 5.0 installation database table not found error #1625

Open ulaganathan11 opened 3 years ago

ulaganathan11 commented 3 years ago

I am trying to install akeneo pim5.0 in ubuntu 18.08 and mysql 8.0. bin/console pim:installer:db commnad to generate tables. 74 tables are created. But pim_session table is not created.

_[2021-04-28 20:47:00] request.CRITICAL: Uncaught PHP Exception PDOException: "SQLSTATE[42S02]: Base table or view not found: 1146 Table 'akeneo_pim.pim_session' doesn't exist" at /var/www/akeneo-pim/vendor/symfony/http-foundation/Session/Storage/Handler/PdoSessionHandler.php line 625 {"exception":"[object] (PDOException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'akeneo_pim.pim_session' doesn't exist at /var/www/akeneo-pim/vendor/symfony/http-foundation/Session/Storage/Handler/PdoSessionHandler.php:625, PDOException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'akeneo_pim.pim_session' doesn't exist at /var/www/akeneo-pim/vendor/symfony/http-foundation/Session/Storage/Handler/PdoSessionHandler.php:625)"} []_

jmleroux commented 3 years ago

Hello @ulaganathan11 ,

This is weird because the table should be created by this function call: https://github.com/akeneo/pim-community-dev/blob/5.0/src/Akeneo/Platform/Bundle/InstallerBundle/Command/DatabaseCommand.php#L184

unless you used the doNotDropDatabase flag.