The given value does not represent a valid number.

Hello, during the installation I have the error pasted bellow:

PowerShell

Running full reindexation... [Brick\Math\Exception\NumberFormatException] The given value does not represent a valid number. oro:migration:data:load [--fixtures-type [FIXTURES-TYPE]] [--dry-run] [--bundles [BUNDLES]] [--exclude [EXCLUDE]] [-h|--help] [-q|--quiet] [-v|vv|vvv|--verbose] [-V|--version] [--ansi] [--no-ansi] [-n|--no-interaction] [-s|--shell] [--process-isolation] [-e|--env ENV] [--no-debug] [--current-user CURRENT-USER] [--current-organization CURRENT-ORGANIZATION] [--disabled-listeners DISABLED-LISTENERS] [--] <command> [RuntimeException] The command '/usr/local/Cellar/php71/7.1.6_18/bin/php' 'app/console' 'oro:m igration:data:load' '--fixtures-type=demo' '--no-debug' terminated with an exit code: 1.

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15

Running full reindexation...                                                            [Brick\Math\Exception\NumberFormatException]           The given value does not represent a valid number.                                                            oro:migration:data:load [--fixtures-type [FIXTURES-TYPE]] [--dry-run] [--bundles [BUNDLES]] [--exclude [EXCLUDE]] [-h|--help] [-q|--quiet] [-v|vv|vvv|--verbose] [-V|--version] [--ansi] [--no-ansi] [-n|--no-interaction] [-s|--shell] [--process-isolation] [-e|--env ENV] [--no-debug] [--current-user CURRENT-USER] [--current-organization CURRENT-ORGANIZATION] [--disabled-listeners DISABLED-LISTENERS] [--] <command>                                                                                      [RuntimeException]                                                             The command '/usr/local/Cellar/php71/7.1.6_18/bin/php' 'app/console' 'oro:m     igration:data:load' '--fixtures-type=demo' '--no-debug' terminated with an     exit code: 1.

The error is caused by this code:

PHP

$this->extendExtension->addManyToOneRelation( $schema, 'inventory_supplies', // owning side table 'product', // owning side field name 'oro_product', // inverse side table 'sku', // column names are used to show a title of related entity ['extend' => ['owner' => ExtendScope::OWNER_CUSTOM]] ); $this->extendExtension->addManyToOneInverseRelation( $schema, 'inventory_supplies', // owning side table 'product', // owning side field name 'oro_product', // inverse side table 'supplies', // inverse side field name ['quantity'], // column names are used to show a title of owning side entity ['quantity'], // column names are used to show detailed info about owning side entity ['quantity'], // Column names are used to show owning side entity in a grid ['extend' => ['owner' => ExtendScope::OWNER_CUSTOM]] );

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

$this->extendExtension->addManyToOneRelation(             $schema,             'inventory_supplies', // owning side table             'product', // owning side field name             'oro_product', // inverse side table             'sku', // column names are used to show a title of related entity             ['extend' => ['owner' => ExtendScope::OWNER_CUSTOM]]         );                $this->extendExtension->addManyToOneInverseRelation(             $schema,             'inventory_supplies', // owning side table             'product', // owning side field name             'oro_product', // inverse side table             'supplies', // inverse side field name             ['quantity'], // column names are used to show a title of owning side entity             ['quantity'], // column names are used to show detailed info about owning side entity             ['quantity'], // Column names are used to show owning side entity in a grid             ['extend' => ['owner' => ExtendScope::OWNER_CUSTOM]]         );

When I remove it, installation works well.

It shows on different env like linux(nginx) or OS X(apache).

INI

"require": { "oro/commerce": "1.1.x-dev", "oro/platform": "2.1.x-dev", "oro/platform-serialised-fields": "2.1.x-dev", "oro/calendar-bundle": "2.1.x-dev", "oro/marketing": "2.1.x-dev", "oro/customer-portal": "2.1.x-dev", "oro/crm": "2.1.x-dev", "oro/crm-task-bundle": "2.1.x-dev", "oro/crm-call-bundle": "2.1.x-dev", "oro/commerce-crm": "1.1.x-dev", "oro/crm-hangouts-call-bundle": "2.1.x-dev", "oro/crm-abandoned-cart": "2.1.x-dev", "oro/crm-magento-embedded-contact-us": "2.1.x-dev", "oro/crm-mail-chimp": "2.1.x-dev", "oro/crm-dotmailer": "2.1.x-dev", "oro/crm-zendesk": "2.1.x-dev" },

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18

"require": {     "oro/commerce": "1.1.x-dev",     "oro/platform": "2.1.x-dev",     "oro/platform-serialised-fields": "2.1.x-dev",     "oro/calendar-bundle": "2.1.x-dev",     "oro/marketing": "2.1.x-dev",     "oro/customer-portal": "2.1.x-dev",     "oro/crm": "2.1.x-dev",     "oro/crm-task-bundle": "2.1.x-dev",     "oro/crm-call-bundle": "2.1.x-dev",     "oro/commerce-crm": "1.1.x-dev",     "oro/crm-hangouts-call-bundle": "2.1.x-dev",     "oro/crm-abandoned-cart": "2.1.x-dev",     "oro/crm-magento-embedded-contact-us": "2.1.x-dev",     "oro/crm-mail-chimp": "2.1.x-dev",     "oro/crm-dotmailer": "2.1.x-dev",     "oro/crm-zendesk": "2.1.x-dev"   },

Topic

[mmiasnikovParticipant]

Hi, @Krzysztof!

Please, try to use the latest version of OroCommerce (1.3 LTS) for installation (if you don’t have your reasons to use outdated ones, of course).

If you will still get the error, please, provide following information:

• the name and version of your RDBMS (mysql or postgres)?
• did you perform installation on empty DB or on the top of previously created?

Thank you.

[mmiasnikovParticipant]

An investigation revealed that the problem in the mixed system locale parameters, e.g.:

Shell

$ locale LANG=en_US.UTF-8 LANGUAGE=en_US LC_CTYPE="en_US.UTF-8" LC_NUMERIC=uk_UA.UTF-8 LC_TIME=uk_UA.UTF-8 LC_COLLATE="en_US.UTF-8" LC_MONETARY=uk_UA.UTF-8 LC_MESSAGES="en_US.UTF-8" LC_PAPER=uk_UA.UTF-8 LC_NAME=uk_UA.UTF-8 LC_ADDRESS=uk_UA.UTF-8 LC_TELEPHONE=uk_UA.UTF-8 LC_MEASUREMENT=uk_UA.UTF-8 LC_IDENTIFICATION=uk_UA.UTF-8 LC_ALL=

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17

$ locale   LANG=en_US.UTF-8 LANGUAGE=en_US LC_CTYPE="en_US.UTF-8" LC_NUMERIC=uk_UA.UTF-8 LC_TIME=uk_UA.UTF-8 LC_COLLATE="en_US.UTF-8" LC_MONETARY=uk_UA.UTF-8 LC_MESSAGES="en_US.UTF-8" LC_PAPER=uk_UA.UTF-8 LC_NAME=uk_UA.UTF-8 LC_ADDRESS=uk_UA.UTF-8 LC_TELEPHONE=uk_UA.UTF-8 LC_MEASUREMENT=uk_UA.UTF-8 LC_IDENTIFICATION=uk_UA.UTF-8 LC_ALL=

Solution: set the single locale (e.g. en_US) (for Ubuntu):

Shell

$ sudo update-locale LC_ALL=en_US.UTF-8 LANG=en_US.UTF-8

1	$ sudo update-locale LC_ALL=en_US.UTF-8 LANG=en_US.UTF-8

and re-login your user. After that the locale settings became homogeneous:

Shell

LANG=en_US.UTF-8 LANGUAGE=en_US LC_CTYPE="en_US.UTF-8" LC_NUMERIC="en_US.UTF-8" LC_TIME="en_US.UTF-8" LC_COLLATE="en_US.UTF-8" LC_MONETARY="en_US.UTF-8" LC_MESSAGES="en_US.UTF-8" LC_PAPER="en_US.UTF-8" LC_NAME="en_US.UTF-8" LC_ADDRESS="en_US.UTF-8" LC_TELEPHONE="en_US.UTF-8" LC_MEASUREMENT="en_US.UTF-8" LC_IDENTIFICATION="en_US.UTF-8" LC_ALL=en_US.UTF-8

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15

LANG=en_US.UTF-8 LANGUAGE=en_US LC_CTYPE="en_US.UTF-8" LC_NUMERIC="en_US.UTF-8" LC_TIME="en_US.UTF-8" LC_COLLATE="en_US.UTF-8" LC_MONETARY="en_US.UTF-8" LC_MESSAGES="en_US.UTF-8" LC_PAPER="en_US.UTF-8" LC_NAME="en_US.UTF-8" LC_ADDRESS="en_US.UTF-8" LC_TELEPHONE="en_US.UTF-8" LC_MEASUREMENT="en_US.UTF-8" LC_IDENTIFICATION="en_US.UTF-8" LC_ALL=en_US.UTF-8

and the error “The given value does not represent a valid number” will disappear.

[Author]

Replies