Akeneo Ubuntu 18.04 request.CRITICAL: Uncaught PHP Exception #1621

alexpebody · 2021-04-27T01:20:42Z

Hello for all.

Could anybody help please? Installed Akeneo by this listing: https://websiteforstudents.com/install-akeneo-pim-on-ubuntu-16-04-17-10-18-04-with-apache2-mariadb-and-php-7-1-support/

Was not worked DB connection, i solved it, need correct config in: /var/www/html/akeneo/pim-community-standard/app/config/parameters.yml

I installed elasticsearch and set for localhost and port 9200

But i still get this critical error, i can't found any solution in google all advices not working. Need help please?

All right is 755 and chown www-data, mysql DB working, elasticsearch too.

[2021-04-26 19:47:43] request.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Driver\PDOException: "SQLSTATE[42S02]: Base table or view not found: 1146 Table 'akeneo_pim.pim_session' doesn't exist" at /var/www/html/akeneo/pim-community-standard/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php line 107 {"exception":"[object] (Doctrine\\DBAL\\Driver\\PDOException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'akeneo_pim.pim_session' doesn't exist at /var/www/html/akeneo/pim-community-standard/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:107, PDOException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'akeneo_pim.pim_session' doesn't exist at /var/www/html/akeneo/pim-community-standard/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:105)"} []
[2021-04-26 19:47:43] request.CRITICAL: Exception thrown when handling an exception (Doctrine\DBAL\Driver\PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'akeneo_pim.pim_session' doesn't exist at /var/www/html/akeneo/pim-community-standard/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php line 107) {"exception":"[object] (Doctrine\\DBAL\\Driver\\PDOException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'akeneo_pim.pim_session' doesn't exist at /var/www/html/akeneo/pim-community-standard/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:107, PDOException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'akeneo_pim.pim_session' doesn't exist at /var/www/html/akeneo/pim-community-standard/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:105)"} []
[2021-04-26 19:47:43] request.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Driver\PDOException: "SQLSTATE[42S02]: Base table or view not found: 1146 Table 'akeneo_pim.pim_session' doesn't exist" at /var/www/html/akeneo/pim-community-standard/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php line 107 {"exception":"[object] (Doctrine\\DBAL\\Driver\\PDOException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'akeneo_pim.pim_session' doesn't exist at /var/www/html/akeneo/pim-community-standard/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:107, PDOException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'akeneo_pim.pim_session' doesn't exist at /var/www/html/akeneo/pim-community-standard/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:105, Doctrine\\DBAL\\Driver\\PDOException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'akeneo_pim.pim_session' doesn't exist at /var/www/html/akeneo/pim-community-standard/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:107, PDOException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'akeneo_pim.pim_session' doesn't exist at /var/www/html/akeneo/pim-community-standard/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:105)"} []

The text was updated successfully, but these errors were encountered:

alexpebody · 2021-04-27T01:42:28Z

i searched for akeneo_pim.pim_session - all solves not working from google. like this:

akeneo/pim-community-dev#7196
and
akeneo/pim-community-dev#9314

all advices was do and nothink.

chown -R www-data:www-data /var/lib/php/sessions and chmod -R 777 /var/lib/php/sessions and chown -R nobody:nogroup /var/lib/php/sessions/

not result too

Doodoune · 2021-04-27T07:05:17Z

Hi @alexpebody!

The documentation that you follow will not work for the last version of the PIM.
For example, in our last version (5.0), your environment has to follow the system requirements (so PHP 7.4, MySQL 8.0.22 etc.)
https://docs.akeneo.com/latest/install_pim/manual/system_requirements/system_requirements.html

Your error says that the table "akeneo_pim.pim_session" doesn't exist in your database.
Did you try to just install the database?
Depending on your PIM version, the command is not the same, but you could search it with this command:
bin/console | grep db

Hope it will help you.
Best regards,
Elodie

alexpebody · 2021-04-27T07:17:10Z

Thank you for reply, yes sure DB was added:

CREATE DATABASE akeneo_pim;
Create a database user called akeneo_pim with new password
CREATE USER 'akeneo_pim'@'localhost' IDENTIFIED BY 'akeneo_pim';
Then grant the user full access to the database.
GRANT ALL ON akeneo.* TO 'akeneo_pim'@'localhost' IDENTIFIED BY 'akeneo_pim' WITH GRANT OPTION;
Finally, save your changes and exit
FLUSH PRIVILEGES;
EXIT;

and file /var/www/html/akeneo/pim-community-standard/app/config/parameters.yml has:

parameters:
    database_driver: pdo_mysql
    database_host: localhost
    database_port: 3306
    database_name: akeneo_pim
    database_user: akeneo_pim
    database_password: akeneo_pim
    locale: en
    secret: ThisTokenIsNotSoSecretChangeIt
    product_index_name: akeneo_pim_product
    product_model_index_name: akeneo_pim_product_model
    product_and_product_model_index_name: akeneo_pim_product_and_product_model
    index_hosts: 'localhost: 9200'

and result bin/console | grep db:

root@akeneo:~# cd /var/www/html/akeneo/pim-community-standard
root@akeneo:/var/www/html/akeneo/pim-community-standard# bin/console | grep db
  pim:installer:db                                     Prepare database and load fixtures

Doodoune · 2021-04-27T07:20:50Z

The DB was "created" but not "populated".
Try to execute the command bin/console pim:installer:db, it will populate your database.

alexpebody · 2021-04-27T07:29:10Z

Ok here is, so thx for help! 8-)

bin/console pim:installer:db (many errors):

root@akeneo:/var/www/html/akeneo/pim-community-standard# bin/console pim:installer:db
Prepare database schema
Dropped database for connection named `akeneo_pim`
Created database `akeneo_pim` for connection named default
ATTENTION: This operation should not be executed in a production environment.

Creating database schema...
07:25:21 ERROR     [console] Error thrown while running command "doctrine:schema:create --no-debug=1 --env=dev". Message: "Schema-Tool failed with Error 'An exception occurred while executing 'CREATE TABLE pim_catalog_product_model (id INT AUTO_INCREMENT NOT NULL, parent_id INT DEFAULT NULL, family_variant_id INT DEFAULT NULL, code VARCHAR(255) NOT NULL, raw_values json NOT NULL COMMENT '(DC2Type:native_json)', created DATETIME NOT NULL COMMENT '(DC2Type:datetime)', updated DATETIME NOT NULL COMMENT '(DC2Type:datetime)', root INT NOT NULL, lvl INT NOT NULL, lft 

many errors... ((

Maybe need del DB and create new?

I was clean my db - all tables and trying command again: bin/console pim:installer:db result: the same errors... why?

root@akeneo:/var/www/html/akeneo/pim-community-standard# bin/console pim:installer:db
Prepare database schema
Dropped database for connection named `akeneo_pim`
Created database `akeneo_pim` for connection named default
ATTENTION: This operation should not be executed in a production environment.

Creating database schema...
07:39:30 ERROR     [console] Error thrown while running command "doctrine:schema:create --no-debug=1 --env=dev". Message: "Schema-Tool failed with Error 'An exception occurred while executing 'CREATE TABLE pim_catalog_product_model (id INT AUTO_INCREMENT NOT NULL, parent_id INT DEFAULT NULL, family_variant_id INT DEFAULT NULL, code VARCHAR(255) NOT NULL, raw_values json NOT NULL COMMENT '(DC2Type:native_json)', created DATETIME NOT NULL COMMENT '(DC2Type:datetime)', updated DATETIME NOT NULL COMMENT '(DC2Type:datetime)', root INT NOT NULL, lvl INT NOT NULL, lft INT NOT NULL, rgt INT NOT NULL, UNIQUE INDEX UNIQ_5943911E77153098 (code), INDEX IDX_5943911E727ACA70 (parent_id), INDEX IDX_5943911E8A37AD0 (family_variant_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB':

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json NOT NULL COMMENT '(DC2Type:native_json)', created DATETIME NOT NULL COMMENT' at line 1' while executing DDL: CREATE TABLE pim_catalog_product_model (id INT AUTO_INCREMENT NOT NULL, parent_id INT DEFAULT NULL, family_variant_id INT DEFAULT NULL, code VARCHAR(255) NOT NULL, raw_values json NOT NULL COMMENT '(DC2Type:native_json)', created DATETIME NOT NULL COMMENT '(DC2Type:datetime)', updated DATETIME NOT NULL COMMENT '(DC2Type:datetime)', root INT NOT NULL, lvl INT NOT NULL, lft INT NOT NULL, rgt INT NOT NULL, UNIQUE INDEX UNIQ_5943911E77153098 (code), INDEX IDX_5943911E727ACA70 (parent_id), INDEX IDX_5943911E8A37AD0 (family_variant_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB" ["error" => Doctrine\ORM\Tools\ToolsException { …},"command" => "doctrine:schema:create --no-debug=1 --env=dev","message" => """  Schema-Tool failed with Error 'An exception occurred while executing 'CREATE TABLE pim_catalog_product_model (id INT AUTO_INCREMENT NOT NULL, parent_id INT DEFAULT NULL, family_variant_id INT DEFAULT NULL, code VARCHAR(255) NOT NULL, raw_values json NOT NULL COMMENT '(DC2Type:native_json)', created DATETIME NOT NULL COMMENT '(DC2Type:datetime)', updated DATETIME NOT NULL COMMENT '(DC2Type:datetime)', root INT NOT NULL, lvl INT NOT NULL, lft INT NOT NULL, rgt INT NOT NULL, UNIQUE INDEX UNIQ_5943911E77153098 (code), INDEX IDX_5943911E727ACA70 (parent_id), INDEX IDX_5943911E8A37AD0 (family_variant_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB':\n  \n  SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json NOT NULL COMMENT '(DC2Type:native_json)', created DATETIME NOT NULL COMMENT' at line 1' while executing DDL: CREATE TABLE pim_catalog_product_model (id INT AUTO_INCREMENT NOT NULL, parent_id INT DEFAULT NULL, family_variant_id INT DEFAULT NULL, code VARCHAR(255) NOT NULL, raw_values json NOT NULL COMMENT '(DC2Type:native_json)', created DATETIME NOT NULL COMMENT '(DC2Type:datetime)', updated DATETIME NOT NULL COMMENT '(DC2Type:datetime)', root INT NOT NULL, lvl INT NOT NULL, lft INT NOT NULL, rgt INT NOT NULL, UNIQUE INDEX UNIQ_5943911E77153098 (code), INDEX IDX_5943911E727ACA70 (parent_id), INDEX IDX_5943911E8A37AD0 (family_variant_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB  """] []

In ToolsException.php line 39:

  Schema-Tool failed with Error 'An exception occurred while executing
   'CREATE TABLE pim_catalog_product_model (id INT AUTO_INCREMENT NOT
  NULL, parent_id INT DEFAULT NULL, family_variant_id INT DEFAULT NULL
  , code VARCHAR(255) NOT NULL, raw_values json NOT NULL COMMENT '(DC2
  Type:native_json)', created DATETIME NOT NULL COMMENT '(DC2Type:date
  time)', updated DATETIME NOT NULL COMMENT '(DC2Type:datetime)', root
   INT NOT NULL, lvl INT NOT NULL, lft INT NOT NULL, rgt INT NOT NULL,
   UNIQUE INDEX UNIQ_5943911E77153098 (code), INDEX IDX_5943911E727ACA
  70 (parent_id), INDEX IDX_5943911E8A37AD0 (family_variant_id), PRIMA
  RY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGIN
  E = InnoDB':

  SQLSTATE[42000]: Syntax error or access violation: 1064 You have an
  error in your SQL syntax; check the manual that corresponds to your
  MariaDB server version for the right syntax to use near 'json NOT NU
  LL COMMENT '(DC2Type:native_json)', created DATETIME NOT NULL COMMEN
  T' at line 1' while executing DDL: CREATE TABLE pim_catalog_product_
  model (id INT AUTO_INCREMENT NOT NULL, parent_id INT DEFAULT NULL, f
  amily_variant_id INT DEFAULT NULL, code VARCHAR(255) NOT NULL, raw_v
  alues json NOT NULL COMMENT '(DC2Type:native_json)', created DATETIM
  E NOT NULL COMMENT '(DC2Type:datetime)', updated DATETIME NOT NULL C
  OMMENT '(DC2Type:datetime)', root INT NOT NULL, lvl INT NOT NULL, lf
  t INT NOT NULL, rgt INT NOT NULL, UNIQUE INDEX UNIQ_5943911E77153098
   (code), INDEX IDX_5943911E727ACA70 (parent_id), INDEX IDX_5943911E8
  A37AD0 (family_variant_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET u
  tf8 COLLATE utf8_unicode_ci ENGINE = InnoDB


In AbstractMySQLDriver.php line 90:

  An exception occurred while executing 'CREATE TABLE pim_catalog_prod
  uct_model (id INT AUTO_INCREMENT NOT NULL, parent_id INT DEFAULT NUL
  L, family_variant_id INT DEFAULT NULL, code VARCHAR(255) NOT NULL, r
  aw_values json NOT NULL COMMENT '(DC2Type:native_json)', created DAT
  ETIME NOT NULL COMMENT '(DC2Type:datetime)', updated DATETIME NOT NU
  LL COMMENT '(DC2Type:datetime)', root INT NOT NULL, lvl INT NOT NULL
  , lft INT NOT NULL, rgt INT NOT NULL, UNIQUE INDEX UNIQ_5943911E7715
  3098 (code), INDEX IDX_5943911E727ACA70 (parent_id), INDEX IDX_59439
  11E8A37AD0 (family_variant_id), PRIMARY KEY(id)) DEFAULT CHARACTER S
  ET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB':

  SQLSTATE[42000]: Syntax error or access violation: 1064 You have an
  error in your SQL syntax; check the manual that corresponds to your
  MariaDB server version for the right syntax to use near 'json NOT NU
  LL COMMENT '(DC2Type:native_json)', created DATETIME NOT NULL COMMEN
  T' at line 1


In PDOConnection.php line 106:

  SQLSTATE[42000]: Syntax error or access violation: 1064 You have an
  error in your SQL syntax; check the manual that corresponds to your
  MariaDB server version for the right syntax to use near 'json NOT NU
  LL COMMENT '(DC2Type:native_json)', created DATETIME NOT NULL COMMEN
  T' at line 1


In PDOConnection.php line 104:

  SQLSTATE[42000]: Syntax error or access violation: 1064 You have an
  error in your SQL syntax; check the manual that corresponds to your
  MariaDB server version for the right syntax to use near 'json NOT NU
  LL COMMENT '(DC2Type:native_json)', created DATETIME NOT NULL COMMEN
  T' at line 1


doctrine:schema:create [--dump-sql] [--em [EM]] [-h|--help] [-q|--quiet] [-v|vv|vvv|--verbose] [-V|--version] [--ansi] [--no-ansi] [-n|--no-interaction] [-e|--env ENV] [--no-debug] [--] <command>

The command terminated with an error code: 1.

In CommandExecutor.php line 66:

  The command terminated with an error code: 1.

Screenshot DB - https://yadi.sk/i/nHd_MTLSa-5HnQ

And i found this: https://stackoverflow.com/questions/56320875/database-error-when-installing-akeneo-pim

alexpebody · 2021-04-27T07:56:01Z

/var/www/html/akeneo/pim-community-standard/app/config/parameters.yml.dist is:

parameters:
    database_driver:                      pdo_mysql
    database_host:                        localhost
    database_port:                        3306
    database_name:                        akeneo_pim
    database_user:                        akeneo_pim
    database_password:                    akeneo_pim
    locale:                               en
    secret:                               ThisTokenIsNotSoSecretChangeIt
    product_index_name:                   akeneo_pim_product
    product_model_index_name:             akeneo_pim_product_model
    product_and_product_model_index_name: akeneo_pim_product_and_product_model
    index_hosts:                          'localhost: 9200'

alexpebody · 2021-04-27T08:03:14Z

Sad but i tried dell BD and create new and set root rights and check access and nothing! 8-( The same issues, can't crreate some tables...

Doodoune · 2021-04-27T08:11:05Z

It's because you use MariaDB. We don't support it and it's normal to have this kind of issue.

We only support MySQL (cf system requirements of 5.0 - https://docs.akeneo.com/latest/install_pim/manual/system_requirements/system_requirements.html)

I strongly encourage you to follow our official documentation to install the PIM: https://docs.akeneo.com/latest/install_pim/manual/system_requirements/system_install_ubuntu_1804.html

Best regards,
Elodie

alexpebody · 2021-04-27T08:14:27Z

So thx! Ive try using MySQL DB and reinstall it. Send result here, thx again! 8-)

alexpebody · 2021-04-27T12:38:35Z

Could you tell me please what's mean? Don’t forget to add the web directory of your Symfony application? Where i need set and what? Thank you.

Doodoune · 2021-04-27T12:41:25Z

Could you send a screenshot of your issue? Without context it's complicated. :)

alexpebody · 2021-04-27T12:43:59Z

Sure ) https://yadi.sk/i/qmMQEyjzjZaQMg

alexpebody · 2021-04-27T12:47:59Z

End of document https://docs.akeneo.com/latest/install_pim/manual/system_requirements/system_install_ubuntu_1804.html? But how install Akeneo? Just unpack archive? How version need take on Ubuntu 18.04? End of doc and no any about install?

Doodoune · 2021-04-27T12:51:54Z

I don't see any picture on your URL.

See this documentation for the Community Edition: https://docs.akeneo.com/latest/install_pim/manual/installation_ce.html

alexpebody · 2021-04-28T04:26:07Z

Good day. Elodie Doodoune pelase help a little... I am thinking right?

a step: After install: https://docs.akeneo.com/latest/install_pim/manual/system_requirements/system_install_ubuntu_2004.html
b step: I must going that: https://docs.akeneo.com/latest/install_pim/manual/installation_ce.html

c step: composer create-project akeneo/pim-community-standard /srv/pim "5.0.*@stable" - i need install docker? Or this install without docker? Because back step (a step) i was install all component for Akeneo right, i can't understand what must i do after a step? exactly?

thank you!

alexpebody · 2021-04-28T06:52:00Z

About trying install with Docker (command run as root why perm denied?):

root@akeneo:~# docker run -u www-data -v $(pwd):/srv/pim -w /srv/pim --rm akeneo/pim-php-dev:4.0 \
>     php -d memory_limit=4G /usr/local/bin/composer create-project --prefer-dist \
>     akeneo/pim-community-standard /srv/pim "4.0.*@stable"
Unable to find image 'akeneo/pim-php-dev:4.0' locally
4.0: Pulling from akeneo/pim-php-dev
f7ec5a41d630: Pull complete
2aa8a277c591: Pull complete
b936e17abd5e: Pull complete
5380cd2ac9cc: Pull complete
98ebdab1e627: Pull complete
f7b7b2d9fecf: Pull complete
f707f2523a57: Pull complete
ae6b33d089e4: Pull complete
5f574dab1016: Pull complete
dc140871fbd1: Pull complete
8c4927ce3d39: Pull complete
Digest: sha256:3fefb65aa516b63120feffdbbc1aca05bd03c79841a23b37f9cba861e87994f5
Status: Downloaded newer image for akeneo/pim-php-dev:4.0
docker: Error response from daemon: OCI runtime create failed: container_linux.go:367: starting container process caused: chdir to cwd ("/srv/pim") set in config.json failed: permission denied: unknown.

alexpebody · 2021-04-28T07:55:51Z

I had tried install this way, how solved this issue? I can't install Akeneo!

Got error:

PHP Fatal error: Uncaught Symfony\\Component\\Debug\\Exception\\FatalThrowableError: Parse error: syntax error, unexpected token "match" in /var/www/akeneo/pim-community-standard/vendor/willdurand/negotiation/src/Negotiation/Negotiator.php:41\nStack trace:\n#0 /var/www/akeneo/pim-community-standard/vendor/composer/ClassLoader.php(322): Composer\\Autoload\\includeFile()\n#1 /var/www/akeneo/pim-community-standard/vendor/friendsofsymfony/rest-bundle/Negotiation/FormatNegotiator.php(24): Composer\\Autoload\\ClassLoader->loadClass()\n#2 /var/www/akeneo/pim-community-standard/vendor/composer/ClassLoader.php(444): include('...')\n#3 /var/www/akeneo/pim-community-standard/vendor/composer/ClassLoader.php(322): Composer\\Autoload\\includeFile()\n#4 /var/www/akeneo/pim-community-standard/var/cache/prod/Container0xobmfa/appProdProjectContainer.php(5184): Composer\\Autoload\\ClassLoader->loadClass()\n#5 /var/www/akeneo/pim-community-standard/var/cache/prod/Container0xobmfa/appProdProjectContainer.php(5174): Container0xobmfa\\appProdProjectContainer->getFosRest_FormatNegotiatorService()\n#6 /var/www/akeneo/pim-community-standard/var/cache/prod/Container0xobmfa/appProdProjectContainer.php(4350): Container0xobmfa\\appProdProjectContainer->getFosRest_FormatListenerService()\n#7 /var/www/akeneo/pim-community-standard/vendor/symfony/symfony/src/Symfony/Component/EventDispatcher/EventDispatcher.php(229): Container0xobmfa\\appProdProjectContainer->Container0xobmfa\\{closure}()\n#8 /var/www/akeneo/pim-community-standard/vendor/symfony/symfony/src/Symfony/Component/EventDispatcher/EventDispatcher.php(61): Symfony\\Component\\EventDispatcher\\EventDispatcher->sortListeners()\n#9 /var/www/akeneo/pim-community-standard/vendor/symfony/symfony/src/Symfony/Component/EventDispatcher/ContainerAwareEventDispatcher.php(128): Symfony\\Component\\EventDispatcher\\EventDispatcher->getListeners()\n#10 /var/www/akeneo/pim-community-standard/vendor/symfony/symfony/src/Symfony/Component/EventDispatcher/EventDispatcher.php(43): Symfony\\Component\\EventDispatcher\\ContainerAwareEventDispatcher->getListeners()\n#11 /var/www/akeneo/pim-community-standard/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php(127): Symfony\\Component\\EventDispatcher\\EventDispatcher->dispatch()\n#12 /var/www/akeneo/pim-community-standard/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php(68): Symfony\\Component\\HttpKernel\\HttpKernel->handleRaw()\n#13 /var/www/akeneo/pim-community-standard/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/Kernel.php(202): Symfony\\Component\\HttpKernel\\HttpKernel->handle()\n#14 /var/www/akeneo/pim-community-standard/web/app.php(30): Symfony\\Component\\HttpKernel\\Kernel->handle()\n#15 {main}\n thrown in /var/www/akeneo/pim-community-standard/vendor/willdurand/negotiation/src/Negotiation/Negotiator.php on line 41

root@akeneo:/var/www/akeneo/pim-community-standard# bin/console pim:install --force --symlink --clean --env=prod
PHP Warning:  "continue" targeting switch is equivalent to "break". Did you mean to use "continue 2"? in /var/www/akeneo/pim-community-standard/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php on line 2636
PHP Warning:  "continue" targeting switch is equivalent to "break". Did you mean to use "continue 2"? in /var/www/akeneo/pim-community-standard/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php on line 2665

In ApcuCache.php line 44:

  Call to undefined function Doctrine\Common\Cache\apcu_exists()


pim:install [--force] [--symlink] [--clean] [-h|--help] [-q|--quiet] [-v|vv|vvv|--verbose] [-V|--version] [--ansi] [--no-ansi] [-n|--no-interaction] [-e|--env ENV] [--no-debug] [--] <command>

Doodoune · 2021-04-28T08:44:47Z

If you use docker, please follow this documentation: https://docs.akeneo.com/latest/install_pim/docker/installation_docker.html
If you don't use docker, first be sure that you have an environment that follows the system requirements (in your error it says that you don't enable APCU locally - it's required in our system requirements) - https://docs.akeneo.com/latest/install_pim/manual/system_requirements/system_requirements.html
THEN follow this documentation - https://docs.akeneo.com/latest/install_pim/manual/installation_ce.html it doesn't use docker to install it.
Normally you should not have an error during the launch of the command NO_DOCKER=true make dev, if you have one, please put the full error message here.

alexpebody · 2021-04-28T17:47:19Z

but still on web access is: HTTP ERROR 500

PHP Fatal error: Uncaught Symfony\\Component\\Debug\\Exception\\FatalThrowableError: Parse error: syntax error, unexpected 'const' (T_CONST), expecting variable (T_VARIABLE) in /var/www/akeneo/pim-community-standard/vendor/akeneo/pim-community-dev/src/Pim/Bundle/CatalogBundle/Doctrine/ORM/Query/ConvertProductToVariantProduct.php:22\nStack trace:\n#0 /var/www/akeneo/pim-community-standard/vendor/composer/ClassLoader.php(322): Composer\\Autoload\\includeFile('/var/www/akeneo...')\n#1 [internal function]: Composer\\Autoload\\ClassLoader->loadClass('Pim\\\\Bundle\\\\Cata...')\n#2 /var/www/akeneo/pim-community-standard/var/cache/prod/ContainerTcbsszt/appProdProjectContainer.php(5662): spl_autoload_call('Pim\\\\Bundle\\\\Cata...')\n#3 /var/www/akeneo/pim-community-standard/var/cache/prod/ContainerTcbsszt/appProdProjectContainer.php(5672): ContainerTcbsszt\\appProdProjectContainer->getPimCatalog_Doctrine_Query_ConvertProductToVariantProductService()\n#4 /var/www/akeneo/pim-community-standard/var/cache/prod/ContainerTcbsszt/appProdProjectContainer.php(4984 in /var/www/akeneo/pim-community-standard/vendor/akeneo/pim-community-dev/src/Pim/Bundle/CatalogBundle/Doctrine/ORM/Query/ConvertProductToVariantProduct.php on line 22

But all DB was created and populated well, and yarn run webpack is ok. look below:

root@akeneo:/var/www/akeneo/pim-community-standard# yarn run webpack
yarn run v1.22.5
warning package.json: No license field
$ yarn run sync && NODE_PATH=node_modules webpack --config $npm_package_config_source/webpack.config.js --env=prod
warning package.json: No license field
$ NODE_PATH=node_modules node $npm_package_config_check --source=$npm_package_config_source
Starting webpack from /var/www/akeneo/pim-community-standard in prod mode

WebpackCleanupPlugin: 0 file(s) deleted.
Version: webpack 3.5.5
Time: 25224ms
              Asset     Size  Chunks                    Chunk Names
        main.min.js  2.03 MB       0  [emitted]  [big]  main
         lib.min.js     1 MB       1  [emitted]  [big]  lib
      vendor.min.js  1.07 kB       2  [emitted]         vendor
    manifest.min.js  5.88 kB       3  [emitted]         manifest
    main.min.js.map  2.49 MB       0  [emitted]         main
     lib.min.js.map  1.18 MB       1  [emitted]         lib
  vendor.min.js.map  1.37 kB       2  [emitted]         vendor
manifest.min.js.map  5.98 kB       3  [emitted]         manifest

Prepare database schema
Dropped database for connection named `akeneo_pim`
Created database `akeneo_pim` for connection named default
ATTENTION: This operation should not be executed in a production environment.

Creating database schema...
Database schema created successfully!
Nothing to update - your database is already in sync with the current entity metadata.
Reset elasticsearch indexes
Create session table
Load jobs for fixtures. (data set: PimInstallerBundle:icecat_demo_dev)
Fixtures fixtures_currency_csv has been successfully executed.
Fixtures fixtures_locale_csv has been successfully executed.
Fixtures fixtures_user_group_csv has been successfully executed.
Fixtures fixtures_category_csv has been successfully executed.
Fixtures fixtures_attribute_group_csv has been successfully executed.
Fixtures fixtures_group_type_csv has been successfully executed.
Fixtures fixtures_attribute_csv has been successfully executed.
Fixtures fixtures_channel_csv has been successfully executed.
Fixtures fixtures_association_type_csv has been successfully executed.
Fixtures fixtures_attribute_options_csv has been successfully executed.
Fixtures fixtures_family_csv has been successfully executed.
Fixtures fixtures_job_yml has been successfully executed.
Fixtures fixtures_family_variant_csv has been successfully executed.
Fixtures fixtures_group_csv has been successfully executed.
Fixtures fixtures_user_role_csv has been successfully executed.
Fixtures fixtures_user_csv has been successfully executed.
Fixtures fixtures_product_model_csv has been successfully executed.
Fixtures fixtures_product_csv has been successfully executed.

Delete jobs for fixtures.
Versioning is already up to date.
Akeneo PIM assets
Dumping exposed routes.

[file+] /var/www/akeneo/pim-community-standard/app/../web/js/routes.js

 Installing assets as hard copies.

 --- ------------------------------------------------------------------------ ---------------- 
      Bundle                                                                   Method / Error  
 --- ------------------------------------------------------------------------ ---------------- 
  ✔   FOSJsRoutingBundle                                                       copy            
      -> /var/www/akeneo/pim-community-standard/web/bundles/fosjsrouting                       
  ✔   OroAsseticBundle                                                         copy            
      -> /var/www/akeneo/pim-community-standard/web/bundles/oroassetic                         
  ✔   OroConfigBundle                                                          copy            
      -> /var/www/akeneo/pim-community-standard/web/bundles/oroconfig                          
  ✔   PimNavigationBundle                                                      copy            
      -> /var/www/akeneo/pim-community-standard/web/bundles/pimnavigation                      
  ✔   PimUserBundle                                                            copy            
      -> /var/www/akeneo/pim-community-standard/web/bundles/pimuser                            
  ✔   PimAnalyticsBundle                                                       copy            
      -> /var/www/akeneo/pim-community-standard/web/bundles/pimanalytics                       
  ✔   PimDashboardBundle                                                       copy            
      -> /var/www/akeneo/pim-community-standard/web/bundles/pimdashboard                       
  ✔   PimDataGridBundle                                                        copy            
      -> /var/www/akeneo/pim-community-standard/web/bundles/pimdatagrid                        
  ✔   PimEnrichBundle                                                          copy            
      -> /var/www/akeneo/pim-community-standard/web/bundles/pimenrich                          
  ✔   PimImportExportBundle                                                    copy            
      -> /var/www/akeneo/pim-community-standard/web/bundles/pimimportexport                    
  ✔   PimNotificationBundle                                                    copy            
      -> /var/www/akeneo/pim-community-standard/web/bundles/pimnotification                    
  ✔   PimReferenceDataBundle                                                   copy            
      -> /var/www/akeneo/pim-community-standard/web/bundles/pimreferencedata                   
  ✔   PimUIBundle                                                              copy            
      -> /var/www/akeneo/pim-community-standard/web/bundles/pimui                              
 --- ------------------------------------------------------------------------ ---------------- 

 ! [NOTE] Some assets were installed via copy. If you make changes to these assets you have to run this command again.  

                                                                                                                        
 [OK] All assets were successfully installed.                                                                           
                                                                                                                        

Dumping all prod assets.
Debug mode is off.

Dumping all prod assets.
Debug mode is off.

17:37:46 [file+] /var/www/akeneo/pim-community-standard/app/../web/css/pim.css
Generating require.js main config
17:37:47 [file+] en.js
17:37:47 [file+] fr.js
17:37:47 [file+] nl.js
17:37:47 [file+] de.js
17:37:47 [file+] ru.js
17:37:47 [file+] ja.js
17:37:47 [file+] pt.js
17:37:47 [file+] it.js

 Trying to install assets as relative symbolic links.

 --- ------------------------------------------------------------------------ ------------------ 
      Bundle                                                                   Method / Error    
 --- ------------------------------------------------------------------------ ------------------ 
  ✔   FOSJsRoutingBundle                                                       relative symlink  
      -> /var/www/akeneo/pim-community-standard/web/bundles/fosjsrouting                         
  ✔   OroAsseticBundle                                                         relative symlink  
      -> /var/www/akeneo/pim-community-standard/web/bundles/oroassetic                           
  ✔   OroConfigBundle                                                          relative symlink  
      -> /var/www/akeneo/pim-community-standard/web/bundles/oroconfig                            
  ✔   PimNavigationBundle                                                      relative symlink  
      -> /var/www/akeneo/pim-community-standard/web/bundles/pimnavigation                        
  ✔   PimUserBundle                                                            relative symlink  
      -> /var/www/akeneo/pim-community-standard/web/bundles/pimuser                              
  ✔   PimAnalyticsBundle                                                       relative symlink  
      -> /var/www/akeneo/pim-community-standard/web/bundles/pimanalytics                         
  ✔   PimDashboardBundle                                                       relative symlink  
      -> /var/www/akeneo/pim-community-standard/web/bundles/pimdashboard                         
  ✔   PimDataGridBundle                                                        relative symlink  
      -> /var/www/akeneo/pim-community-standard/web/bundles/pimdatagrid                          
  ✔   PimEnrichBundle                                                          relative symlink  
      -> /var/www/akeneo/pim-community-standard/web/bundles/pimenrich                            
  ✔   PimImportExportBundle                                                    relative symlink  
      -> /var/www/akeneo/pim-community-standard/web/bundles/pimimportexport                      
  ✔   PimNotificationBundle                                                    relative symlink  
      -> /var/www/akeneo/pim-community-standard/web/bundles/pimnotification                      
  ✔   PimReferenceDataBundle                                                   relative symlink  
      -> /var/www/akeneo/pim-community-standard/web/bundles/pimreferencedata                     
  ✔   PimUIBundle                                                              relative symlink  
      -> /var/www/akeneo/pim-community-standard/web/bundles/pimui                                
 --- ------------------------------------------------------------------------ ------------------ 

                                                                                                                        
 [OK] All assets were successfully installed.                                                                           
                                                                                                                        


Akeneo PIM Application has been successfully installed.

VivekShingala · 2021-05-21T09:15:19Z

If you use docker, please follow this documentation: https://docs.akeneo.com/latest/install_pim/docker/installation_docker.html

If you don't use docker, first be sure that you have an environment that follows the system requirements (in your error it says that you don't enable APCU locally - it's required in our system requirements) - https://docs.akeneo.com/latest/install_pim/manual/system_requirements/system_requirements.html
THEN follow this documentation - https://docs.akeneo.com/latest/install_pim/manual/installation_ce.html it doesn't use docker to install it.
Normally you should not have an error during the launch of the command NO_DOCKER=true make dev, if you have one, please put the full error message here.

Hello, I don't have any error in NO_DOCKER command but still can't access the PIM. What should be the document root?

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Akeneo Ubuntu 18.04 request.CRITICAL: Uncaught PHP Exception #1621

Akeneo Ubuntu 18.04 request.CRITICAL: Uncaught PHP Exception #1621

alexpebody commented Apr 27, 2021 •

edited

Loading

alexpebody commented Apr 27, 2021

Doodoune commented Apr 27, 2021

alexpebody commented Apr 27, 2021

Doodoune commented Apr 27, 2021

alexpebody commented Apr 27, 2021 •

edited

Loading

alexpebody commented Apr 27, 2021

alexpebody commented Apr 27, 2021

Doodoune commented Apr 27, 2021

alexpebody commented Apr 27, 2021

alexpebody commented Apr 27, 2021

Doodoune commented Apr 27, 2021 •

edited

Loading

alexpebody commented Apr 27, 2021

alexpebody commented Apr 27, 2021

Doodoune commented Apr 27, 2021

alexpebody commented Apr 28, 2021 •

edited

Loading

alexpebody commented Apr 28, 2021

alexpebody commented Apr 28, 2021 •

edited

Loading

Doodoune commented Apr 28, 2021

alexpebody commented Apr 28, 2021

VivekShingala commented May 21, 2021

Akeneo Ubuntu 18.04 request.CRITICAL: Uncaught PHP Exception #1621

Akeneo Ubuntu 18.04 request.CRITICAL: Uncaught PHP Exception #1621

Comments

alexpebody commented Apr 27, 2021 • edited Loading

alexpebody commented Apr 27, 2021

Doodoune commented Apr 27, 2021

alexpebody commented Apr 27, 2021

Doodoune commented Apr 27, 2021

alexpebody commented Apr 27, 2021 • edited Loading

alexpebody commented Apr 27, 2021

alexpebody commented Apr 27, 2021

Doodoune commented Apr 27, 2021

alexpebody commented Apr 27, 2021

alexpebody commented Apr 27, 2021

Doodoune commented Apr 27, 2021 • edited Loading

alexpebody commented Apr 27, 2021

alexpebody commented Apr 27, 2021

Doodoune commented Apr 27, 2021

alexpebody commented Apr 28, 2021 • edited Loading

alexpebody commented Apr 28, 2021

alexpebody commented Apr 28, 2021 • edited Loading

Doodoune commented Apr 28, 2021

alexpebody commented Apr 28, 2021

VivekShingala commented May 21, 2021

alexpebody commented Apr 27, 2021 •

edited

Loading

alexpebody commented Apr 27, 2021 •

edited

Loading

Doodoune commented Apr 27, 2021 •

edited

Loading

alexpebody commented Apr 28, 2021 •

edited

Loading

alexpebody commented Apr 28, 2021 •

edited

Loading