error upgrade orocrm 1.10.12 to 2.0

I try to upgrade my version 1.10.12 in version 2.0, I use the procedure
https://github.com/orocrm/crm/blob/master/UPGRADE-2.0.md and but when i upgrade I have the following message

PHP

Clearing the routing cache for the dev environment Creating queue: oro.default Available locales: en, fr_FR. Should be processed: en, fr_FR. Loading translations [en] (10) ... > loading [validators] (210) ... [Doctrine\DBAL\Exception\DriverException] An exception occurred while executing 'INSERT INTO oro_translation (value, scope, translation_key_id, language_id) VALUES (?, ?, ?, ?)' with params ["This value should be false.", 0, 17039, 2]: SQLSTATE[HY000]: General error: 1364 Field 'key' doesn't have a default value [Doctrine\DBAL\Driver\PDOException] SQLSTATE[HY000]: General error: 1364 Field 'key' doesn't have a default value [PDOException] SQLSTATE[HY000]: General error: 1364 Field 'key' doesn't have a default value oro:translation:load [-l|--languages [LANGUAGES]] [-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] [--disabled-listeners DISABLED-LISTENERS] [--] <command> [RuntimeException] The command '/usr/bin/php7.0' 'app/console' 'oro:translation:load' '--no-debug' terminated with an exit code: 1. oro:platform:update [--force] [--skip-assets] [--symlink] [--skip-translations] [--force-debug] [--timeout [TIMEOUT]] [-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] [--disabled-listeners DISABLED-LISTENERS] [--] <command> [RuntimeException] The command '/usr/bin/php7.0' 'app/console' 'oro:platform:update' '--force' '--timeout=300' '--env=dev' '--no-debug' terminated with an exit code: 1.

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36

Clearing the routing cache for the dev environment Creating queue: oro.default Available locales: en, fr_FR. Should be processed: en, fr_FR. Loading translations [en] (10) ...   > loading [validators] (210) ...                                                                                                                                                                                                        [Doctrine\DBAL\Exception\DriverException]                                                                                                                                                             An exception occurred while executing 'INSERT INTO oro_translation (value, scope, translation_key_id, language_id) VALUES (?, ?, ?, ?)' with params ["This value should be false.", 0, 17039, 2]:     SQLSTATE[HY000]: General error: 1364 Field 'key' doesn't have a default value                                                                                                                                                                                                                                                                                                                                                                                                                 [Doctrine\DBAL\Driver\PDOException]                                               SQLSTATE[HY000]: General error: 1364 Field 'key' doesn't have a default value                                                                                                                                                                         [PDOException]                                                                   SQLSTATE[HY000]: General error: 1364 Field 'key' doesn't have a default value                                                                                      oro:translation:load [-l|--languages [LANGUAGES]] [-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] [--disabled-listeners DISABLED-LISTENERS] [--] <command>                                                                                                                            [RuntimeException]                                                                                                   The command '/usr/bin/php7.0' 'app/console' 'oro:translation:load' '--no-debug' terminated with an exit code: 1.                                                                                                                          oro:platform:update [--force] [--skip-assets] [--symlink] [--skip-translations] [--force-debug] [--timeout [TIMEOUT]] [-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] [--disabled-listeners DISABLED-LISTENERS] [--] <command>                                                                                                                                            [RuntimeException]                                                                                                                   The command '/usr/bin/php7.0' 'app/console' 'oro:platform:update' '--force' '--timeout=300' '--env=dev' '--no-debug' terminated     with an exit code: 1.

My ui is in french

thanks

Topic

[Mike KudelyaParticipant]

but in English

Are we talking about language in System -> Configuration? If yes, could you please tell me which Language/Locale you use ? Did you try to remove your custom bundles on non-working version?

[fred33Participant]

i’m using all french parameters in Localization and French Language. I am obliged to remove my bundles for migration as they extend bundles like account or contact

[fred33Participant]

this my error.log in apache2

PHP

[Fri Mar 10 11:49:21.916516 2017] [:error] [pid 5580] [client 127.0.0.1:44054] PHP Fatal error: Uncaught Error: Call to undefined method Oro\\Bundle\\UserBundle\\Entity\\User::getAuthStatus() in /opt/crmcrp/vendor/oro/platform/src/Oro/Bundle/UserBundle/Security/UserChecker.php:69\nStack trace:\n#0 /opt/crmcrp/vendor/symfony/symfony/src/Symfony/Component/Security/Core/Authentication/Provider/UserAuthenticationProvider.php(85): Oro\\Bundle\\UserBundle\\Security\\UserChecker->checkPreAuth(Object(Oro\\Bundle\\UserBundle\\Entity\\User))\n#1 /opt/crmcrp/vendor/oro/platform/src/Oro/Bundle/SecurityBundle/Authentication/Provider/UsernamePasswordOrganizationAuthenticationProvider.php(42): Symfony\\Component\\Security\\Core\\Authentication\\Provider\\UserAuthenticationProvider->authenticate(Object(Symfony\\Component\\Security\\Core\\Authentication\\Token\\UsernamePasswordToken))\n#2 /opt/crmcrp/app/cache/prod/classes.php(3564): Oro\\Bundle\\SecurityBundle\\Authentication\\Provider\\UsernamePasswordOrganizationAuthenticationProvider->authenticate(Object(Symfony\\Component\\Security\\Core\\Authentication\\Token\\UsernamePasswordToken))\n#3 /opt/crmcrp/ven in /opt/crmcrp/vendor/oro/platform/src/Oro/Bundle/UserBundle/Security/UserChecker.php on line 69, referer: http://fredcrmcrp.coreplighting.com/user/login

1

[Fri Mar 10 11:49:21.916516 2017] [:error] [pid 5580] [client 127.0.0.1:44054] PHP Fatal error:  Uncaught Error: Call to undefined method Oro\\Bundle\\UserBundle\\Entity\\User::getAuthStatus() in /opt/crmcrp/vendor/oro/platform/src/Oro/Bundle/UserBundle/Security/UserChecker.php:69\nStack trace:\n#0 /opt/crmcrp/vendor/symfony/symfony/src/Symfony/Component/Security/Core/Authentication/Provider/UserAuthenticationProvider.php(85): Oro\\Bundle\\UserBundle\\Security\\UserChecker->checkPreAuth(Object(Oro\\Bundle\\UserBundle\\Entity\\User))\n#1 /opt/crmcrp/vendor/oro/platform/src/Oro/Bundle/SecurityBundle/Authentication/Provider/UsernamePasswordOrganizationAuthenticationProvider.php(42): Symfony\\Component\\Security\\Core\\Authentication\\Provider\\UserAuthenticationProvider->authenticate(Object(Symfony\\Component\\Security\\Core\\Authentication\\Token\\UsernamePasswordToken))\n#2 /opt/crmcrp/app/cache/prod/classes.php(3564): Oro\\Bundle\\SecurityBundle\\Authentication\\Provider\\UsernamePasswordOrganizationAuthenticationProvider->authenticate(Object(Symfony\\Component\\Security\\Core\\Authentication\\Token\\UsernamePasswordToken))\n#3 /opt/crmcrp/ven in /opt/crmcrp/vendor/oro/platform/src/Oro/Bundle/UserBundle/Security/UserChecker.php on line 69, referer: http://fredcrmcrp.coreplighting.com/user/login

[Mike KudelyaParticipant]

Hi

You said that you had two OroCRM instances (English and French). Could you tell me if these instances use the same environment? (php/mysql/apache, etc…) Are these instances identical in terms of code/database,and you just copied the first instance and then changed the language from english to french? These are normal apache errors that happen because migration did not execute

[fred33Participant]

All orocrm instances are on my pc so i use the same environment, php7 mysql apache2…I only change language

[Dima MakarukParticipant]

Hi

i’ve had the same issue like fred33 and got the error SQLSTATE[HY000]: General error: 1364 Field ‘key’ doesn’t have a default value.

Some how the migration Oro\Bundle\TranslationBundle\Migrations\Schema\v1_3\UpdateTranslationColumns wasn’t executed. The columns locale, domain, key in the table oro_translation should be dropped,but they exist also after successful update.
Also the unique key for columns language_id, translation_key_id is not created. So i suppose the migration wasn’t executed at all.

[Dima MakarukParticipant]

My problem was , that i didn’t run php app/console oro:platform:update before php app/console oro:platform:upgrade20

[fred33Participant]

Hi,
if i run php app/console oro:platform:update before upgrade i have the same issue that Dima

PHP

[PDOException] SQLSTATE[HY000]: General error: 1364 Field 'key' doesn't have a default value

1 2	[PDOException]                                                                   SQLSTATE[HY000]: General error: 1364 Field 'key' doesn't have a default value

[msulimaModerator]

If you’d like to upgrade from 1.10 to 2.0 version you do not need to execute “oro:platform:update” because “oro:platform:upgrade20” already contain sub call of this command, please see here: https://github.com/orocrm/platform/blob/2.0/src/Oro/Bundle/InstallerBundle/Command/UpgradeCommand.php#L66

To successfully upgrade you just need to run “oro:platform:upgrade20” as it was described here:

https://github.com/orocrm/crm/blob/master/UPGRADE-2.0.md

---

Check our free technical guide ”How to Build a Reliable and Secure Infrastructure for OroCommerce”.

[fred33Participant]

This is exactly the procedure that I have followed since the beginning, I only made this command to test. My starting topic is well following an error when executing the procedure you give

[Dima MakarukParticipant]

@msulima thank you for correction.

@fred33 before you update try to find out if you have duplicates in oro_translation table. This would look like this :

select group_concat(id),count(*) as cnt from oro_translation t group by key,locale having cnt > 1

1 2 3

select group_concat(id),count(*) as cnt from oro_translation t group by key,locale having cnt > 1

Before running the upgrade ,try to clean up the duplicates in the table, if they exist. I’ve also done it , when the DB was in 1.10 state.

[fred33Participant]

@Dima I’m trying to execute your request, error message

PHP

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'key, locale having cnt>1' at line 2

1 2	ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'key, locale having cnt>1' at line 2

[fred33Participant]

I reply to myself i forgot the quotes key….

[fred33Participant]

Another question, is that the domain field is important because I have duplicates with key and value equal but with a different domain

[Dima MakarukParticipant]

try to add domain field to group by

[Author]

Replies