Forums › Forums › OroCRM › OroCRM – Installation/Technical Issues or Problems › error upgrade orocrm 1.10.12 to 2.0
This topic contains 47 replies, has 5 voices, and was last updated by dynamicssquareau 4 years, 11 months ago.
Starting from March 1, 2020 the forum has been switched to the read-only mode. Please head to StackOverflow for support.
- CreatorTopic
- January 23, 2017 at 7:07 am #27555
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 messagePHP123456789101112131415161718192021222324252627282930313233343536Clearing the routing cache for the dev environmentCreating queue: oro.defaultAvailable 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 valueoro: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' terminatedwith an exit code: 1.My ui is in french
thanks
- CreatorTopic
- AuthorReplies
- January 31, 2017 at 7:59 am #27556
Hi
Did you delete app/cache/[dev&prod] directories before upgrade ?
January 31, 2017 at 8:21 am #27557Hi,
yes i did it allJanuary 31, 2017 at 9:03 am #27558Hi
I think that for some reason UpdateTranslationColumns migration didn’t execute. This may be occurred if you had errors earlier. Can you show me full upgrade log ? Not only:
Shell1234Clearing the routing cache for the dev environmentCreating queue: oro.defaultAvailable locales: en, fr_FR. Should be processed: en, fr_FR.................February 1, 2017 at 4:40 am #27559this is my prod.log
1232017-02-01 12:52:39] console.ERROR: An error occurred while running command "'oro:migration:load' --force --timeout=300 --env=prod". Failed migrations: Oro\Bundle\TranslationBundle\Migrations\Schema\v1_2\UpdateTranslationColumns. {"exit_code":0,"arguments":{"command":"oro:migration:load"},"options":{"force":true,"timeout":"300","env":"prod"}} [][2017-02-01 12:52:39] console.ERROR: An error occurred while running command "'oro:platform:update' --force --timeout=300 --env=prod". The command '/usr/bin/php7.0' 'app/console' 'oro:migration:load' '--force' '--timeout=300' '--env=prod' terminated with an exit code: 1. {"exit_code":0,"arguments":{"command":"oro:platform:update"},"options":{"force":true,"timeout":"300","env":"prod"}} [][2017-02-01 12:52:39] console.ERROR: An error occurred while running command "'oro:platform:upgrade20' --env=prod --force". The command '/usr/bin/php7.0' 'app/console' 'oro:platform:update' '--force' '--timeout=300' '--env=prod' terminated with an exit code: 1. {"exit_code":0,"arguments":{"command":"oro:platform:upgrade20"},"options":{"env":"prod","force":true}} []and for dev.log
February 1, 2017 at 7:13 am #27560The message in the console is :
PHP12[RuntimeException]Failed migrations: Oro\Bundle\TranslationBundle\Migrations\Schema\v1_2\UpdateTranslationColumnsI looked in the source code UpdateTranslationColumns.php is not in v1_2 folder but in v1_3 folder….
February 1, 2017 at 8:20 am #27561If I change from 1.2 to 1.3 I have the following message
PHP123456Process migrations...> Oro\Bundle\EntityExtendBundle\Migration\LoadEntityConfigStateMigration> Oro\Bundle\TranslationBundle\Migrations\Schema\v1_4\OroTranslationBundleERROR: An exception occurred while executing 'UPDATE oro_translation_key SET <code>key</code> = CONCAT('oro', SUBSTR(<code>key</code>, 7)) WHERE <code>key</code> LIKE 'orocrm.%' OR <code>key</code> LIKE 'oropro.%'':SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'oro.account.menu.customers_tab.label-messages' for key 'key_domain_uniq'February 3, 2017 at 2:31 am #27562Please upgrade your application again and show me console output, i think when we repair this migration upgrade will work correctly.
Unfortunately this is not enough, i don’t see real error.
Shell12[RuntimeException]Failed migrations: Oro\Bundle\TranslationBundle\Migrations\Schema\v1_2\UpdateTranslationColumnsFebruary 3, 2017 at 2:49 am #27563Ok
PHP12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394// Warming up the cache for the prod environment with debug false[OK] Cache for the "prod" environment (debug=false) was successfully warmed.We recommend at least 1Gb to be available for PHP CLIProcess migrations...> Oro\Bundle\EntityExtendBundle\Migration\LoadEntityConfigStateMigration> Oro\Bundle\TranslationBundle\Migrations\Schema\v1_4\OroTranslationBundleERROR: An exception occurred while executing 'UPDATE oro_translation_key SET <code>key</code> = CONCAT('oro', SUBSTR(<code>key</code>, 7)) WHERE <code>key</code> LIKE 'orocrm.%' OR <code>key</code> LIKE 'oropro.%'':SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'oro.account.menu.customers_tab.label-messages' for key 'key_domain_uniq'> Oro\Bundle\WorkflowBundle\Migrations\Schema\v1_14\OroWorkflowBundle - skipped> Oro\Bundle\WorkflowBundle\Migrations\Schema\v1_14\UpdateWorkflowItemFieldsMigration - skipped> Oro\Bundle\WorkflowBundle\Migrations\Schema\v1_15\OroWorkflowBundle - skipped> Oro\Bundle\WorkflowBundle\Migrations\Schema\v2_0\OroWorkflowBundle - skipped> Oro\Bundle\WorkflowBundle\Migrations\Schema\v2_1\UpdateWorkflowDefinitionConfiguration - skipped> Oro\Bundle\CommentBundle\Migrations\Schema\v1_2\RenameCommentAssociation - skipped> Oro\Bundle\CRMBundle\Migrations\Schema\OroCRMBundleInstaller - skipped> Oro\Bundle\CalendarBundle\Migrations\Schema\v1_15\AddCommentAssociation - skipped> Oro\Bundle\CalendarBundle\Migrations\Schema\v1_16\RemoveInvitationStatusFieldConfig - skipped> Oro\Bundle\CalendarBundle\Migrations\Schema\v1_16\UpdateAttendeeCalendarEvent - skipped> Oro\Bundle\CalendarBundle\Migrations\Schema\v1_17\OroCalendarBundle - skipped> Oro\Bundle\HangoutsCallBundle\Migrations\Schema\OroHangoutsCallBundleInstaller - skipped> Oro\Bundle\CurrencyBundle\Migrations\Schema\OroConfigBundleInstaller - skipped> Oro\Bundle\NavigationBundle\Migrations\Schema\v1_4\OroNavigationBundle - skipped> Oro\Bundle\NavigationBundle\Migrations\Schema\v1_5\OroNavigationBundle - skipped> Oro\Bundle\NavigationBundle\Migrations\Schema\v1_6\UpdateNavigationMenuUpdIcon - skipped> Oro\Bundle\NavigationBundle\Migrations\Schema\v1_6\DropOwnershipFromMenuUpdateTable - skipped> Oro\Bundle\NavigationBundle\Migrations\Schema\v1_6\AddScopeToMenuUpdateTable - skipped> Oro\Bundle\MarketingListBundle\Migrations\Schema\v1_3\MigrateRelations - skipped> Oro\Bundle\TrackingBundle\Migrations\Schema\v1_11\InstallTrackingScript - skipped> Oro\Bundle\AccountBundle\Migrations\Schema\v1_12\UpdateEntityMergeOptions - skipped> Oro\Bundle\ChannelBundle\Migrations\Schema\v1_7\MigrateRelations - skipped> Oro\Bundle\ChannelBundle\Migrations\Schema\v1_8\RemoveDataChannelFromEmbeddedForm - skipped> Oro\Bundle\MagentoContactUsBundle\Migrations\Schema\OroMagentoContactUsBundleInstaller - skipped> Oro\Bundle\TaskBundle\Migrations\Schema\v1_12\RemoveWorkflowFields - skipped> OroCRM\Bundle\SalesBundle\Migrations\Schema\v1_25_6\AddOpportunityStatus - skipped> Oro\Bundle\SalesBundle\Migrations\Schema\v1_26\RemoveWorkflowFields - skipped> Oro\Bundle\SalesBundle\Migrations\Schema\v1_27\AddMultiCurrencyFields - skipped> Oro\Bundle\SalesBundle\Migrations\Schema\v1_27\UpdateOpportunityCurrency - skipped> Oro\Bundle\SalesBundle\Migrations\Schema\v1_28\UpdateLeadConfigs - skipped> Oro\Bundle\SalesBundle\Migrations\Schema\v1_29\AddCustomersTable - skipped> OroCRM\Bundle\SalesBundle\Migrations\Schema\v1_29\OroCRMSalesBundle - skipped> Oro\Bundle\SalesBundle\Migrations\Schema\v1_30\AddBaseCurrencyFields - skipped> Oro\Bundle\SalesBundle\Migrations\Schema\v1_30\UpdateReport - skipped> Oro\Bundle\SalesBundle\Migrations\Schema\v1_31\ConvertDataChannelToExtend - skipped> Oro\Bundle\SalesBundle\Migrations\Schema\v1_31\AddCustomerAssociations - skipped> Oro\Bundle\SalesBundle\Migrations\Schema\v1_31\UpdateBusinessCustomers - skipped> Oro\Bundle\SalesBundle\Migrations\Schema\v1_31\RemoveBuisnessCustomerRelation - skipped> Oro\Bundle\SalesBundle\Migrations\Schema\v1_31\UpdateInheritanceActivityTargets - skipped> Oro\Bundle\ContactUsBundle\Migrations\Schema\v1_11\RemoveWorkflowFields - skipped> Oro\Bundle\ContactUsBundle\Migrations\Schema\v1_12\UpdatePreferredContactMethod - skipped> Oro\Bundle\ContactUsBundle\Migrations\Schema\v1_13\DropChannelFieldBundle - skipped> Oro\Bundle\MagentoBundle\Migrations\Schema\v1_42\RemoveWorkflowFields - skipped> Oro\Bundle\MagentoBundle\Migrations\Schema\v1_43\AddCustomerAssociations - skipped> OroCRM\Bundle\MagentoBundle\Migrations\Schema\v1_44\UpdateCartIndexes - skipped> OroCRM\Bundle\MagentoBundle\Migrations\Schema\v1_45\OroCRMMagentoBundle - skipped> Oro\Bridge\MarketingCRM\Migrations\Schema\OroMarketingCRMBridgeBundleInstaller - skipped> Oro\Bundle\EntitySerializedFieldsBundle\Migrations\Schema\OroEntitySerializedFieldsBundleInstaller - skipped> Oro\Bridge\CalendarCRM\Migrations\Schema\OroCalendarCRMBridgeBundleInstaller - skipped> Oro\Bundle\ZendeskBundle\Migrations\Schema\OroZendeskBundleInstaller - skipped> Oro\Bundle\MailChimpBundle\Migrations\Schema\OroMailChimpBundleInstaller - skipped> Oro\Bundle\DotmailerBundle\Migrations\Schema\OroDotmailerBundleInstaller - skipped> Oro\Bundle\AbandonedCartBundle\Migrations\Schema\OroAbandonedCartBundleInstaller - skipped> Oro\Bundle\MigrationBundle\Migration\UpdateBundleVersionMigration> Oro\Bundle\EntityExtendBundle\Migration\RefreshExtendCacheMigration - skipped> Oro\Bundle\EntityConfigBundle\Migration\UpdateEntityConfigMigration - skipped> Oro\Bundle\EntitySerializedFieldsBundle\Migration\SerializedDataMigration - skipped> Oro\Bundle\EntityExtendBundle\Migration\UpdateExtendConfigMigration - skipped> Oro\Bundle\ActivityContactBundle\Migration\ActivityContactMigration - skipped> Oro\Bundle\ActivityListBundle\Migration\ActivityListMigration - skipped> Oro\Bundle\EntityExtendBundle\Migration\UpdateExtendIndicesMigration - skipped> Oro\Bundle\EntityConfigBundle\Migration\WarmUpEntityConfigCacheMigration - skipped[RuntimeException]Failed migrations: Oro\Bundle\TranslationBundle\Migrations\Schema\v1_4\OroTranslationBundle.oro:migration:load [--force] [--dry-run] [--show-queries] [--bundles [BUNDLES]] [--exclude [EXCLUDE]] [--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:migration:load' '--force' '--timeout=300' '--env=prod' 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=prod' terminated with an exitcode: 1.February 13, 2017 at 5:34 am #27564Hi
This migration is trying to rename your translation keys starting from ‘orocrm.’ to ‘oro.’ and oro_translation_key table already has ‘oro.account.menu.customers_tab.label-messages’ unique key for some reason. Please delete oro.account.menu.customers_tab.label-messages row from oro_translation_key table and try execute your migration again.
February 14, 2017 at 6:43 am #27565Hi,
I tried this and next execute migration again…
problem with oro.activity_contact.ac_last_contact_date_in.label-messages, delete this key try again..
problem with oro.activity_contact.ac_last_contact_date_out.description-messages, delete this key try again…
problem with oro.activity_contact.ac_last_contact_date_out.label-messages, delete this key try again…
problem with oro.analytics.best-jsmessage, delete this key try again…
problem with oro.analytics.less-jsmessage, etc…etc….i stopped after twelve attempt
February 14, 2017 at 11:10 pm #27566I continued the operation to finally arrive at this
PHP123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174sudo -u www-data php app/console oro:platform:upgrade20 --env=prod --force// Warming up the cache for the prod environment with debug false[OK] Cache for the "prod" environment (debug=false) was successfully warmed.We recommend at least 1Gb to be available for PHP CLIProcess migrations...> Oro\Bundle\EntityExtendBundle\Migration\LoadEntityConfigStateMigration> Oro\Bundle\CRMBundle\Migrations\Schema\OroCRMBundleInstaller> Oro\Bundle\MigrationBundle\Migration\UpdateBundleVersionMigration> Oro\Bundle\EntityExtendBundle\Migration\RefreshExtendCacheMigration> Oro\Bundle\EntityConfigBundle\Migration\UpdateEntityConfigMigration> Oro\Bundle\EntitySerializedFieldsBundle\Migration\SerializedDataMigration> Oro\Bundle\EntityExtendBundle\Migration\UpdateExtendConfigMigration> Oro\Bundle\ActivityContactBundle\Migration\ActivityContactMigration> Oro\Bundle\ActivityListBundle\Migration\ActivityListMigration> Oro\Bundle\EntityExtendBundle\Migration\UpdateExtendIndicesMigration> Oro\Bundle\EntityConfigBundle\Migration\WarmUpEntityConfigCacheMigrationLoading permissions...> VIEW> CREATE> EDIT> DELETE> ASSIGN> CONFIGURE> MANAGE_API_KEY> TRANSLATELoading workflow definitions...> orocrm_contact_us_contact_request> task_flow> b2b_flow_lead> b2b_flow_sales_funnel> opportunity_flow> b2c_flow_abandoned_shopping_cart> b2c_flow_order_follow_upRemoving all previously loaded commands...Processing command "oro:cron:email-body-sync": setting up schedule..Processing command "oro:cron:definitions:load": Skipping, the command does not implement CronCommandInterfaceProcessing command "oro:cron:integration:cleanup": setting up schedule..Processing command "oro:cron:integration:sync": setting up schedule..Processing command "oro:cron:batch:cleanup": setting up schedule..Processing command "oro:cron:imap-sync": setting up schedule..Processing command "oro:cron:tracking:parse": setting up schedule..Processing command "oro:cron:import-tracking": setting up schedule..Processing command "oro:cron:calculate-tracking-event-summary": setting up schedule..Processing command "oro:cron:send-email-campaigns": setting up schedule..Processing command "oro:cron:lifetime-average:aggregate": setting up schedule..Processing command "oro:cron:send-reminders": setting up schedule..Processing command "oro:cron:analytic:calculate": setting up schedule..Processing command "oro:cron:magento:cart:expiration": setting up schedule..Processing command "oro:cron:mailchimp:export": setting up schedule..Processing command "oro:cron:dotmailer:export-status:update": setting up schedule..Processing command "oro:cron:dotmailer:mapped-fields-updates:process": setting up schedule..[info] > process definition: "sync_email_flag_after_changed" - updated[info] > process definition: "schedule_integration" - updated[info] > process definition: "clear_user_email_origin_on_deactivation" - updated[info] > process definition: "clear_imap_email_folder_on_sync_enabled_change" - updated[info] > process definition: "analytics_channel_calculate_rfm" - updated[info] > process definition: "convert_mailbox_email_to_lead" - updated[info] > process definition: "magento_customer_creation" - updated[info] > process definition: "magento_customer_export" - updated[info] > process definition: "magento_customer_address_export" - updated[info] > process definition: "magento_analytics_customer_calculate" - updated[info] > process definition: "magento_analytics_customer_calculate_imported" - updated[info] > process definition: "magento_schedule_integration" - updated[info] > process definition: "convert_mailbox_email_to_case" - updated[info] > process definition: "synchronize_marketing_list_item_for_mailchimp_member_activity" - updated[info] > process definition: "create_email_campaign_for_mailchimp_campaign" - updated[info] > process definition: "mailchimp_handle_member_state" - updated[info] > process definition: "schedule_mailchimp_segment_synchronization" - updated[info] > process definition: "dotmailer_email_campaign_creation" - updated[info] > process definition: "dotmailer_contact_activity_update" - updated[info] > process definition: "dotmailer_handle_contact_state" - updated[info] > process definition: "schedule_dotmailer_address_book_synchronization" - updated[info] > process definition: "dotmailer_handle_removed_address_book_contact" - updated[info] Process definitions configuration updates are stored into database[info] >> process trigger: analytics_channel_calculate_rfm [update] - updated[info] >> process trigger: clear_imap_email_folder_on_sync_enabled_change [update] - updated[info] >> process trigger: clear_user_email_origin_on_deactivation [update] - updated[info] >> process trigger: create_email_campaign_for_mailchimp_campaign [create] - updated[info] >> process trigger: dotmailer_contact_activity_update [create] - updated[info] >> process trigger: dotmailer_contact_activity_update [update] - updated[info] >> process trigger: dotmailer_email_campaign_creation [create] - updated[info] >> process trigger: dotmailer_handle_contact_state [create] - updated[info] >> process trigger: dotmailer_handle_contact_state [update] - updated[info] >> process trigger: dotmailer_handle_removed_address_book_contact [delete] - updated[info] >> process trigger: magento_analytics_customer_calculate [update] - updated[info] >> process trigger: magento_analytics_customer_calculate_imported [create] - updated[info] >> process trigger: magento_customer_address_export [update] - updated[info] >> process trigger: magento_customer_creation [create] - updated[info] >> process trigger: magento_customer_export [update] - updated[info] >> process trigger: magento_schedule_integration [update] - updated[info] >> process trigger: mailchimp_handle_member_state [update] - updated[info] >> process trigger: schedule_dotmailer_address_book_synchronization [update] - updated[info] >> process trigger: schedule_integration [update] - updated[info] >> process trigger: schedule_integration [create] - updated[info] >> process trigger: schedule_mailchimp_segment_synchronization [create] - updated[info] >> process trigger: schedule_mailchimp_segment_synchronization [update] - updated[info] >> process trigger: sync_email_flag_after_changed [update] - updated[info] >> process trigger: synchronize_marketing_list_item_for_mailchimp_member_activity [create] - updated[info] >> process triggers modifications stored in DBLoading "main" data fixtures ...> loading Oro\Bundle\ScopeBundle\Migrations\Data\ORM\LoadDefaultScope> loading Oro\Bundle\MagentoBundle\Migrations\Data\ORM\CreateAccountEntities> loading Oro\Bundle\SalesBundle\Migrations\Data\ORM\UpdateFeaturesConfigs> loading Oro\Bundle\MagentoContactUsBundle\Migrations\Data\ORM\LoadWorkflowData> loading Oro\Bundle\TrackingBundle\Migrations\Data\ORM\SetShareGridConfig> loading Oro\Bundle\UIBundle\Migrations\Data\ORM\TrimApplicationUrl> loading Oro\Bundle\WorkflowBundle\Migrations\Data\ORM\UpdateDefinitionTranslations> loading Oro\Bundle\DotmailerBundle\Migrations\Data\ORM\LoadEnumValues> loading Oro\Bundle\DotmailerBundle\Migrations\Data\ORM\LoadDataFieldEnumValues> loading Oro\Bundle\ZendeskBundle\Migrations\Data\ORM\LoadTicketTypeData> loading Oro\Bundle\ZendeskBundle\Migrations\Data\ORM\LoadStatusData> loading Oro\Bundle\ZendeskBundle\Migrations\Data\ORM\LoadRolesData> loading Oro\Bundle\ZendeskBundle\Migrations\Data\ORM\LoadPriorityData> loading Oro\Bundle\DotmailerBundle\Migrations\Data\ORM\LoadExportOperationTypes> loading Oro\Bundle\EmailBundle\Migrations\Data\ORM\EnableEmailFeature> loading Oro\Bundle\UserBundle\Migrations\Data\ORM\LoadEmailTemplates> loading Oro\Bundle\DataGridBundle\Migrations\Data\ORM\LoadEmailTemplates> loading Oro\Bundle\DataGridBundle\Migrations\Data\ORM\SetExportGridDefaultAcls> loading Oro\Bundle\DemoDataBundle\Migrations\Data\ORM\LoadWorkflowAclData> loading Oro\Bundle\ImportExport\Migrations\Data\ORM\LoadEmailTemplates> loading Oro\Bundle\NoteBundle\Migrations\Data\ORM\UpdateNotesWithOrganization> loading Oro\Bundle\TranslationBundle\Migrations\Data\ORM\LoadLanguageData> loading Oro\Bundle\TranslationBundle\Migrations\Data\ORM\UpdateAclAdministratorRole> loading Oro\Bundle\TranslationBundle\Migrations\Data\ORM\UpdateLanguageOwner> loading Oro\Bundle\CurrencyBundle\Migrations\Data\ORM\SetDefaultCurrencyFromLocale> loading Oro\Bundle\MagentoContactUsBundle\Migrations\Data\ORM\DefaultChannelData> loading Oro\Bundle\MagentoContactUsBundle\Migrations\Data\ORM\LoadWorkflowAclData> loading Oro\Bridge\MarketingCRM\Migrations\Migrations\Data\ORM\LoadCampaignPerformanceReport> loading Oro\Bridge\MarketingCRM\Migrations\Migrations\Data\ORM\LoadTrackingRolesData> loading Oro\Bridge\CallCRM\Migrations\Data\ORM\UpdateCallAccessLevels> loading Oro\Bridge\TaskCRM\Migrations\Data\ORM\LoadWorkflowAclData> loading Oro\Bundle\NoteBundle\Migrations\Data\ORM\AddNoteActivityLists> loading Oro\Bundle\MigrationBundle\Migration\UpdateDataFixturesFixtureLoad "Title Templates" from annotations and config files to dbCompletedClearing the routing cache for the prod environmentCreating queue: oro.defaultAvailable locales: de_DE, en, fr_FR. Should be processed: de_DE, en, fr_FR.Loading translations [de_DE] (0) ...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, 11799, 3]: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 valueoro: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' '--env=prod' 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=prod' terminated with an exit code: 1.February 15, 2017 at 12:23 am #27567it works with
PHP1sudo -u www-data php app/console oro:platform:upgrade20 --env=prod --force --skip-translationsFebruary 23, 2017 at 1:48 am #27568The problem is not resolved in any way. CRM don’t work after that. I arrive on the login page but then I have a HTTP error 500
February 23, 2017 at 9:56 am #27569Hi
Please, go to the login page in the dev mode /app_dev.php/user/login. Can you see any php/symfony errors there? It would also be a good idea to check /app/logs/[env].log
February 23, 2017 at 10:47 pm #27570dev.log :
PHP123456789101112131415[2017-02-24 07:46:01] console.INFO: Launched command "oro:cron" {"arguments":{"command":"oro:cron"},"options":{"env":"dev"}} [][2017-02-24 07:46:01] event.DEBUG: Notified event "console.command" to listener "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure". [] [][2017-02-24 07:46:01] event.DEBUG: Notified event "console.command" to listener "Oro\Bundle\SecurityBundle\EventListener\ConsoleContextListener::onConsoleCommand". [] [][2017-02-24 07:46:01] event.DEBUG: Notified event "console.command" to listener "Oro\Bundle\ApiBundle\EventListener\DumpApiDocConsoleCommandListener::onConsoleCommand". [] [][2017-02-24 07:46:01] event.DEBUG: Notified event "console.command" to listener "Oro\Bundle\PlatformBundle\EventListener\Console\OptionalListenersListener::onConsoleCommand". [] [][2017-02-24 07:46:01] event.DEBUG: Notified event "console.command" to listener "Oro\Bundle\MigrationBundle\EventListener\ConsoleCommandListener::onConsoleCommand". [] [][2017-02-24 07:46:01] event.DEBUG: Notified event "console.command" to listener "Oro\Bundle\NavigationBundle\Event\JsRoutingDumpListener::onConsoleCommand". [] [][2017-02-24 07:46:01] event.DEBUG: Notified event "console.command" to listener "Oro\Bundle\LocaleBundle\EventListener\LocaleListener::onConsoleCommand". [] [][2017-02-24 07:46:01] event.DEBUG: Notified event "console.command" to listener "Oro\Bundle\LoggerBundle\EventSubscriber\ConsoleCommandSubscriber::onConsoleCommand". [] [][2017-02-24 07:46:01] doctrine.DEBUG: SELECT t0.id AS id_1, t0.command AS command_2, t0.args AS args_3, t0.args_hash AS args_hash_4, t0.definition AS definition_5 FROM oro_cron_schedule t0 [] [][2017-02-24 07:46:01] doctrine.DEBUG: INSERT INTO oro_message_queue (body, headers, properties, priority, queue) VALUES (?, ?, ?, ?, ?) ["{\"command\":\"oro:cron:imap- [...]","{\"content_type\":\"applicati [...]","{\"oro.message_queue.client [...]",2,"oro.default"] [][2017-02-24 07:46:01] doctrine.DEBUG: SELECT COUNT(o0_.id) AS sclr_0 FROM orocrm_campaign_email o0_ WHERE o0_.is_sent = ? AND o0_.schedule = ? AND o0_.scheduled_for IS NOT NULL AND o0_.scheduled_for <= ? [false,"deferred","2017-02-24 06:46:01"] [][2017-02-24 07:46:01] doctrine.DEBUG: SELECT COUNT(o0_.id) AS sclr_0 FROM oro_reminder o0_ WHERE o0_.state = ? AND o0_.start_at <= ? AND o0_.expire_at >= ? ["not_sent","2017-02-24 07:46:01","2017-02-24 07:46:01"] [][2017-02-24 07:46:01] event.DEBUG: Notified event "console.terminate" to listener "Oro\Bundle\PlatformBundle\EventListener\Console\DriverLockCommandListener::afterExecute". [] [][2017-02-24 07:46:01] event.DEBUG: Notified event "console.terminate" to listener "Symfony\Bundle\SwiftmailerBundle\EventListener\EmailSenderListener::onTerminate". [] []login page :
Not FoundThe requested URL /app_dev/user/login was not found on this server.
Apache/2.4.18 (Ubuntu) Server at fredcrmcrp.coreplighting.com Port 80
- AuthorReplies
The forum ‘OroCRM – Installation/Technical Issues or Problems’ is closed to new topics and replies.