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 5 years 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
- February 24, 2017 at 2:34 am #27571
Hi!
Unfortunately, I get the “This site can’t be reached” message when I go to fredcrmcrp.coreplighting.com.
Could you please show me your VirtualHost? Here is my configuration:
INI1234567891011121314151617<VirtualHost *:80>ServerAdmin ...@gmail.comDocumentRoot "/Library/WebServer/www/symfony/orocrm-application/web"ServerName orocrm-application.localServerAlias orocrm-application.localSetEnv ORO_PHP_PATH /opt/local/bin/php<Directory "/Library/WebServer/www/symfony/orocrm-application/web"># enable the .htaccess rewritesAllowOverride AllOrder allow,denyAllow from all</Directory>ErrorLog "logs/orocrm-application-error.log"CustomLog "logs/orocrm-application-access.log" common</VirtualHost>Please, ensure that mod_rewrite is enabled.
Also, please note that the correct URL is “/app_dev.php/user/login”, not “/app_dev/user/login” ?
Thanks!February 24, 2017 at 2:52 am #27572message after login admin
PHP12345Fatal 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 Stack trace: #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)) #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)) #2 /opt/crmcrp/app/cache/dev/classes.php(3564): Oro\Bundle\SecurityBundle\Authentication\Provider\UsernamePasswordOrganizationAuthenticationProvider->authenticate(Object(Symfony\Component\Security\Core\Authentication\Token\UsernamePasswordToken)) #3 /opt/crmcrp/vend in /opt/crmcrp/vendor/oro/platform/src/Oro/Bundle/UserBundle/Security/UserChecker.php on line 69This site is only on localhost to test before putting on the production site:
PHP1234567891011121314151617<VirtualHost *:80>Servername fredcrmcrp.coreplighting.comServerAdmin frederic.portaries@corep.comDocumentRoot /opt/crmcrp/web/DirectoryIndex app_dev.php<Directory /opt/crmcrp/web/>Options Indexes FollowSymLinks MultiViewsAllowOverride AllOrder allow,denyallow from allRequire all granted</Directory>LogLevel warnErrorLog ${APACHE_LOG_DIR}/crmcrp_error.logCustomLog ${APACHE_LOG_DIR}/crmcrp_access.log combined</VirtualHost>March 7, 2017 at 5:14 am #27573Hi
The following is what I did when I was on version 1.10.12:
Shell1234git remote updategit checkout 2.0.3composer installapp/console oro:platform:upgrade20 --env=prod --forceHere is an output of oro:platform:upgrade20 command until the moment of data fixtures execution. I think that the migrations coming from 2.0 didn’t execute. Could you please try to set your database to the 1.10.12 state and then try again?
Shell123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204// Warming up the cache for the prod environment with debug false[OK] Cache for the "prod" environment (debug=false) was successfully warmed.Process migrations...> Oro\Bundle\EntityExtendBundle\Migration\LoadEntityConfigStateMigration> Oro\Bundle\PlatformBundle\Migrations\Schema\v1_1\MigrateNoteAssociations> Oro\Bundle\PlatformBundle\Migrations\Schema\v1_1\RenameActivityAssociations> Oro\Bundle\ScopeBundle\Migrations\Schema\OroScopeBundleInstaller> Oro\Bundle\OrganizationBundle\Migrations\Schema\v1_6\AddScopeRelations> Oro\Bundle\SecurityBundle\Migrations\Schema\v1_3\UpdateAclEntryFieldNameLength> Oro\Bundle\AttachmentBundle\Migrations\Schema\v1_5\RenameAttachmentAssociation> Oro\Bundle\OroMessageQueueBundle\Migrations\Schema\OroMessageQueueBundleInstaller> Oro\Bundle\EmailBundle\Migrations\Schema\v1_30\OroEmailBundle> Oro\Bundle\CronBundle\Migrations\Schema\v2_0\RemoveJmsJob> Oro\Bundle\UserBundle\Migrations\Schema\v1_22\AddImpersonationTable> Oro\Bundle\UserBundle\Migrations\Schema\v1_23\AddDisableLogin> Oro\Bundle\UserBundle\Migrations\Schema\v1_24\AddAuthStatusColumn> Oro\Bundle\UserBundle\Migrations\Schema\v1_24\AddImpersonationIpColumn> Oro\Bundle\UserBundle\Migrations\Schema\v1_24\AddScopeRelations> Oro\Bundle\UserBundle\Migrations\Schema\v1_24\RemoveDisableLogin> Oro\Bundle\UserBundle\Migrations\Schema\v2_0\OroUserBundle> Oro\Bundle\DataGridBundle\Migrations\Schema\v1_5\UpdateAppearanceTypeIcon> Oro\Bundle\EntityBundle\Migrations\Schema\OroEntityBundleInstaller> Oro\Bundle\LocaleBundle\Migrations\Schema\v1_1\OroAccountBundleScopeRelations> Oro\Bundle\EntityConfigBundle\Migrations\Schema\v1_11\UpdateEntityConfigData> Oro\Bundle\EntityConfigBundle\Migrations\Schema\v1_12\OroEntityConfigBundle> Oro\Bundle\EntityConfigBundle\Migrations\Schema\v1_13\OroEntityConfigBundle> Oro\Bundle\EntityConfigBundle\Migrations\Schema\v1_13\UpdateAclForAttributeFamily> Oro\Bundle\EntityExtendBundle\Migrations\Schema\v1_9\OroEntityExtendBundle> Oro\Bundle\ActivityListBundle\Migrations\Schema\v1_4\OroActivityListBundle> Oro\Bundle\DataAuditBundle\Migrations\Schema\v1_8\AddCollectionTypeColumn> Oro\Bundle\DataAuditBundle\Migrations\Schema\v1_8\AddUniqueVersionIndex> Oro\Bundle\DataAuditBundle\Migrations\Schema\v1_8\MakeSomeColumnsNullable> Oro\Bundle\DataAuditBundle\Migrations\Schema\v1_8\AddTransactionIdColumn> Oro\Bundle\DataAuditBundle\Migrations\Schema\v1_8\SetTransactionIdNotNullable> Oro\Bundle\DataAuditBundle\Migrations\Schema\v1_9\AddImpersonationColumn> Oro\Bundle\NoteBundle\Migrations\Schema\v1_3\UpdateNoteActivityScopeConfiguration> Oro\Bundle\NoteBundle\Migrations\Schema\v1_3\UpdateNoteAssociationKind> Oro\Bundle\ReportBundle\Migrations\Schema\v2_0\MigrateRelations> Oro\Bundle\SearchBundle\Migrations\Schema\v1_2\RemoveUpdateEntity> Oro\Bundle\SearchBundle\Migrations\Schema\v1_3\OroSearchBundle> Oro\Bundle\SegmentBundle\Migrations\Schema\v1_6\MigrateRelations> Oro\Bundle\TagBundle\Migrations\Schema\v1_8\AddTagTaxonomy> Oro\Bundle\TranslationBundle\Migrations\Schema\v1_2\OroTranslationBundle> Oro\Bundle\TranslationBundle\Migrations\Schema\v1_3\OroTranslationBundle> Oro\Bundle\TranslationBundle\Migrations\Schema\v1_2\UpdateTranslationColumns> Oro\Bundle\TranslationBundle\Migrations\Schema\v1_4\OroTranslationBundle> Oro\Bundle\WorkflowBundle\Migrations\Schema\v1_14\OroWorkflowBundle> Oro\Bundle\WorkflowBundle\Migrations\Schema\v1_14\UpdateWorkflowItemFieldsMigration> Oro\Bundle\WorkflowBundle\Migrations\Schema\v1_15\OroWorkflowBundle> Oro\Bundle\WorkflowBundle\Migrations\Schema\v2_0\OroWorkflowBundle> Oro\Bundle\WorkflowBundle\Migrations\Schema\v2_1\UpdateWorkflowDefinitionConfiguration> Oro\Bundle\CommentBundle\Migrations\Schema\v1_2\RenameCommentAssociation> Oro\Bundle\CRMBundle\Migrations\Schema\OroCRMBundleInstaller> Oro\Bundle\CalendarBundle\Migrations\Schema\v1_15\AddCommentAssociation> Oro\Bundle\CalendarBundle\Migrations\Schema\v1_16\RemoveInvitationStatusFieldConfig> Oro\Bundle\CalendarBundle\Migrations\Schema\v1_16\UpdateAttendeeCalendarEvent> Oro\Bundle\CalendarBundle\Migrations\Schema\v1_17\OroCalendarBundle> Oro\Bundle\HangoutsCallBundle\Migrations\Schema\OroHangoutsCallBundleInstaller> Oro\Bundle\CurrencyBundle\Migrations\Schema\OroConfigBundleInstaller> Oro\Bundle\NavigationBundle\Migrations\Schema\v1_4\OroNavigationBundle> Oro\Bundle\NavigationBundle\Migrations\Schema\v1_5\OroNavigationBundle> Oro\Bundle\NavigationBundle\Migrations\Schema\v1_6\UpdateNavigationMenuUpdIcon> Oro\Bundle\NavigationBundle\Migrations\Schema\v1_6\DropOwnershipFromMenuUpdateTable> Oro\Bundle\NavigationBundle\Migrations\Schema\v1_6\AddScopeToMenuUpdateTable> Oro\Bundle\MarketingListBundle\Migrations\Schema\v1_3\MigrateRelations> Oro\Bundle\TrackingBundle\Migrations\Schema\v1_11\InstallTrackingScript> Oro\Bundle\AccountBundle\Migrations\Schema\v1_12\UpdateEntityMergeOptions> Oro\Bundle\ChannelBundle\Migrations\Schema\v1_7\MigrateRelations> Oro\Bundle\ChannelBundle\Migrations\Schema\v1_8\RemoveDataChannelFromEmbeddedForm> Oro\Bundle\ChannelBundle\Migrations\Schema\v1_9\OroChannelBundle> Oro\Bundle\MagentoContactUsBundle\Migrations\Schema\OroMagentoContactUsBundleInstaller> Oro\Bundle\TaskBundle\Migrations\Schema\v1_12\RemoveWorkflowFields> OroCRM\Bundle\SalesBundle\Migrations\Schema\v1_25_6\AddOpportunityStatus> Oro\Bundle\SalesBundle\Migrations\Schema\v1_26\RemoveWorkflowFields> Oro\Bundle\SalesBundle\Migrations\Schema\v1_27\AddMultiCurrencyFields> Oro\Bundle\SalesBundle\Migrations\Schema\v1_27\UpdateOpportunityCurrency> Oro\Bundle\SalesBundle\Migrations\Schema\v1_28\UpdateLeadConfigs> Oro\Bundle\SalesBundle\Migrations\Schema\v1_29\AddCustomersTable> OroCRM\Bundle\SalesBundle\Migrations\Schema\v1_29\OroCRMSalesBundle> Oro\Bundle\SalesBundle\Migrations\Schema\v1_30\AddBaseCurrencyFields> Oro\Bundle\SalesBundle\Migrations\Schema\v1_30\UpdateReport> Oro\Bundle\SalesBundle\Migrations\Schema\v1_31\ConvertDataChannelToExtend> Oro\Bundle\SalesBundle\Migrations\Schema\v1_31\AddCustomerAssociations> Oro\Bundle\SalesBundle\Migrations\Schema\v1_31\UpdateBusinessCustomers> Oro\Bundle\SalesBundle\Migrations\Schema\v1_31\RemoveBuisnessCustomerRelation> Oro\Bundle\SalesBundle\Migrations\Schema\v1_31\UpdateInheritanceActivityTargets> Oro\Bundle\SalesBundle\Migrations\Schema\v1_32\AddB2bCustomerIndexOnName> Oro\Bundle\SalesBundle\Migrations\Schema\v1_33\UpdateIndexes> Oro\Bundle\SalesBundle\Migrations\Schema\v1_34\RemoveOldData> Oro\Bundle\ContactUsBundle\Migrations\Schema\v1_11\RemoveWorkflowFields> Oro\Bundle\ContactUsBundle\Migrations\Schema\v1_12\UpdatePreferredContactMethod> Oro\Bundle\ContactUsBundle\Migrations\Schema\v1_13\DropChannelFieldBundle> Oro\Bundle\ContactUsBundle\Migrations\Schema\v1_14\RemoveOldData> Oro\Bundle\MagentoBundle\Migrations\Schema\v1_42\RemoveWorkflowFields> Oro\Bundle\MagentoBundle\Migrations\Schema\v1_43\AddCustomerAssociations> OroCRM\Bundle\MagentoBundle\Migrations\Schema\v1_44\UpdateCartIndexes> OroCRM\Bundle\MagentoBundle\Migrations\Schema\v1_45\OroCRMMagentoBundle> Oro\Bridge\MarketingCRM\Migrations\Schema\OroMarketingCRMBridgeBundleInstaller> Oro\Bundle\EntitySerializedFieldsBundle\Migrations\Schema\OroEntitySerializedFieldsBundleInstaller> Oro\Bridge\CalendarCRM\Migrations\Schema\OroCalendarCRMBridgeBundleInstaller> Oro\Bundle\ZendeskBundle\Migrations\Schema\OroZendeskBundleInstaller> Oro\Bundle\MailChimpBundle\Migrations\Schema\OroMailChimpBundleInstaller> Oro\Bundle\DotmailerBundle\Migrations\Schema\OroDotmailerBundleInstaller> Oro\Bundle\AbandonedCartBundle\Migrations\Schema\OroAbandonedCartBundleInstaller> Oro\Bundle\MigrationBundle\Migration\UpdateBundleVersionMigration> Oro\Bundle\NoteBundle\Migration\RemoveNoteConfigurationScopeMigration> 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> TRANSLATERemoving 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:import-tracking": setting up schedule..Processing command "oro:cron:tracking:parse": 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:force-fields-sync": setting up schedule..Processing command "oro:cron:dotmailer:mapped-fields-updates:process": setting up schedule..Loading 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_up[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" - created[info] > process definition: "create_email_campaign_for_mailchimp_campaign" - created[info] > process definition: "mailchimp_handle_member_state" - created[info] > process definition: "schedule_mailchimp_segment_synchronization" - created[info] > process definition: "dotmailer_email_campaign_creation" - created[info] > process definition: "dotmailer_contact_activity_update" - created[info] > process definition: "dotmailer_handle_contact_state" - created[info] > process definition: "schedule_dotmailer_address_book_synchronization" - created[info] > process definition: "dotmailer_handle_removed_address_book_contact" - created[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] - created[info] >> process trigger: dotmailer_contact_activity_update [create] - created[info] >> process trigger: dotmailer_contact_activity_update [update] - created[info] >> process trigger: dotmailer_email_campaign_creation [create] - created[info] >> process trigger: dotmailer_handle_contact_state [create] - created[info] >> process trigger: dotmailer_handle_contact_state [update] - created[info] >> process trigger: dotmailer_handle_removed_address_book_contact [delete] - created[info] >> process trigger: magento_analytics_customer_calculate [update] - created[info] >> process trigger: magento_analytics_customer_calculate [update] - deleted[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] - created[info] >> process trigger: schedule_dotmailer_address_book_synchronization [update] - created[info] >> process trigger: schedule_integration [update] - updated[info] >> process trigger: schedule_integration [create] - updated[info] >> process trigger: schedule_mailchimp_segment_synchronization [create] - created[info] >> process trigger: schedule_mailchimp_segment_synchronization [update] - created[info] >> process trigger: sync_email_flag_after_changed [update] - updated[info] >> process trigger: synchronize_marketing_list_item_for_mailchimp_member_activity [create] - created[info] >> process triggers modifications stored in DBLoading "main" data fixtures ..........March 7, 2017 at 5:27 am #27574I tried…
PHP123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138// 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 DBLoad "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.March 8, 2017 at 2:53 am #27575Could you show me the data of oro_migrations table? Your ‘OroTranslationBundle’ record must be equal ‘v1_1’, otherwise a newer migrations (v1_2, v1_3, v1_4) will not executed.
Shell123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657INSERT INTO <code>oro_migrations</code> (<code>id</code>, <code>bundle</code>, <code>version</code>, <code>loaded_at</code>)VALUES(1,'OroPlatformBundle','v1_0','2017-03-07 17:31:04'),(2,'OroOrganizationBundle','v1_5','2017-03-07 17:31:04'),(3,'OroSecurityBundle','v1_2','2017-03-07 17:31:04'),(4,'OroAttachmentBundle','v1_4','2017-03-07 17:31:04'),(5,'OroEmailBundle','v1_29','2017-03-07 17:31:04'),(6,'OroCronBundle','v1_3','2017-03-07 17:31:04'),(7,'OroUserBundle','v1_21_1','2017-03-07 17:31:04'),(8,'OroDataGridBundle','v1_4','2017-03-07 17:31:04'),(9,'OroSSOBundle','v1_0','2017-03-07 17:31:04'),(10,'OroEntityConfigBundle','v1_10','2017-03-07 17:31:04'),(11,'OroEntityExtendBundle','v1_8','2017-03-07 17:31:04'),(12,'OroIntegrationBundle','v1_15','2017-03-07 17:31:04'),(13,'OroActivityBundle','v1_1','2017-03-07 17:31:04'),(14,'OroActivityListBundle','v1_3','2017-03-07 17:31:04'),(15,'OroAddressBundle','v1_3','2017-03-07 17:31:04'),(16,'OroBatchBundle','v1_3','2017-03-07 17:31:04'),(17,'OroCalendarBundle','v1_14_1','2017-03-07 17:31:04'),(18,'OroConfigBundle','v1_1','2017-03-07 17:31:04'),(19,'OroDataAuditBundle','v1_7','2017-03-07 17:31:04'),(20,'OroEmbeddedFormBundle','v1_5','2017-03-07 17:31:04'),(21,'OroImapBundle','v1_5','2017-03-07 17:31:04'),(22,'OroImportExportBundle','v1_0','2017-03-07 17:31:04'),(23,'OroInstallerBundle','v1_1','2017-03-07 17:31:04'),(24,'OroLocaleBundle','v1_0','2017-03-07 17:31:04'),(25,'OroMigrationBundle','v1_1','2017-03-07 17:31:04'),(26,'OroNoteBundle','v1_2','2017-03-07 17:31:04'),(27,'OroNotificationBundle','v1_2','2017-03-07 17:31:04'),(28,'OroReportBundle','v1_6','2017-03-07 17:31:04'),(29,'OroSearchBundle','v1_1','2017-03-07 17:31:04'),(30,'OroSegmentBundle','v1_5','2017-03-07 17:31:04'),(31,'OroSidebarBundle','v1_1','2017-03-07 17:31:04'),(32,'OroTagBundle','v1_7','2017-03-07 17:31:04'),(33,'OroTranslationBundle','v1_1','2017-03-07 17:31:04'),(34,'OroWindowsBundle','v1_1','2017-03-07 17:31:04'),(35,'OroWorkflowBundle','v1_13','2017-03-07 17:31:04'),(36,'OroCRMActivityContactBundle','v1_1','2017-03-07 17:31:04'),(37,'OroCommentBundle','v1_1','2017-03-07 17:31:04'),(38,'OroDashboardBundle','v1_7','2017-03-07 17:31:04'),(39,'OroNavigationBundle','v1_3','2017-03-07 17:31:04'),(40,'OroCRMContactBundle','v1_14','2017-03-07 17:31:04'),(41,'OroCRMAccountBundle','v1_11','2017-03-07 17:31:04'),(42,'OroCRMMarketingListBundle','v1_2','2017-03-07 17:31:04'),(43,'OroTrackingBundle','v1_10','2017-03-07 17:31:04'),(44,'OroReminderBundle','v1_3','2017-03-07 17:31:04'),(45,'OroCRMCallBundle','v1_7','2017-03-07 17:31:04'),(46,'OroCRMCampaignBundle','v1_9','2017-03-07 17:31:04'),(47,'OroCRMChannelBundle','v1_6','2017-03-07 17:31:04'),(48,'OroCRMTaskBundle','v1_11_1','2017-03-07 17:31:04'),(49,'OroCRMAnalyticsBundle','v1_0','2017-03-07 17:31:04'),(50,'OroCRMSalesBundle','v1_25_8','2017-03-07 17:31:04'),(51,'OroCRMContactUsBundle','v1_10','2017-03-07 17:31:04'),(52,'OroCRMMagentoBundle','v1_41_4','2017-03-07 17:31:04'),(53,'OroCRMCaseBundle','v1_9','2017-03-07 17:31:04'),(54,'OroCRMCallBridgeBundle','v1_0','2017-03-07 17:31:04'),(55,'OroCRMTaskBridgeBundle','v1_0','2017-03-07 17:31:04');March 8, 2017 at 3:01 am #27576Select in oro_migrations_data
MySQL123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144id,class_name,loaded_at,version1,Oro\Bundle\OrganizationBundle\Migrations\Data\ORM\LoadOrganizationAndBusinessUnitData,"2017-01-24 10:33:38",NULL2,Oro\Bundle\CalendarBundle\Migrations\Data\ORM\UpdateCalendarWithOrganization,"2017-01-24 10:33:38",NULL3,Oro\Bundle\OrganizationBundle\Migrations\Data\ORM\MoveOrganizationFromConfig,"2017-01-24 10:33:38",NULL4,Oro\Bundle\MagentoBundle\Migrations\Data\ORM\UpdateCustomerLifetime,"2017-01-24 10:33:38",NULL5,Oro\Bundle\TaskBundle\Migrations\Data\ORM\LoadTaskPriority,"2017-01-24 10:33:38",NULL6,Oro\Bundle\NotificationBundle\Migrations\Data\ORM\LoadDefaultNotificationEvents,"2017-01-24 10:33:38",NULL7,Oro\Bundle\ReportBundle\Migrations\Data\ORM\LoadReportTypes,"2017-01-24 10:33:38",NULL8,Oro\Bundle\SegmentBundle\Migrations\Data\ORM\LoadSegmentTypes,"2017-01-24 10:33:38",NULL9,Oro\Bundle\WorkflowBundle\Migrations\Data\ORM\ExcludeImportExportFields,"2017-01-24 10:33:38",NULL10,Oro\Bundle\ActivityContactBundle\Migrations\Data\ORM\ActivityContactRecalculate,"2017-01-24 10:33:38",NULL11,Oro\Bundle\MagentoBundle\Migrations\Data\ORM\LoadNewsletterSubscriberStatusData,"2017-01-24 10:33:38",NULL12,Oro\Bundle\MagentoBundle\Migrations\Data\ORM\CreateSyncStatusForExistingConnectors,"2017-01-24 10:33:38",NULL13,Oro\Bundle\MagentoBundle\Migrations\Data\ORM\UpdateDefaultWorkflowItem,"2017-01-24 10:33:38",NULL14,Oro\Bundle\ContactBundle\Migrations\Data\ORM\LoadMethodData,"2017-01-24 10:33:38",NULL15,Oro\Bundle\ContactBundle\Migrations\Data\ORM\LoadGroupData,"2017-01-24 10:33:38",NULL16,Oro\Bundle\ContactBundle\Migrations\Data\ORM\LoadSourceData,"2017-01-24 10:33:38",NULL17,Oro\Bundle\MagentoBundle\Migrations\Data\ORM\UpdateCustomerAddresses,"2017-01-24 10:33:38",NULL18,Oro\Bundle\ImapBundle\Migrations\Data\ORM\ClearInactiveMailboxes,"2017-01-24 10:33:38",NULL19,Oro\Bundle\MagentoBundle\Migrations\Data\ORM\UpdateForecastWidgetOptions,"2017-01-24 10:33:38",NULL20,Oro\Bundle\MarketingListBundle\Migrations\Data\ORM\UpdateMarketingListSegmentOrganization,"2017-01-24 10:33:38",NULL21,Oro\Bundle\MarketingListBundle\Migrations\Data\ORM\LoadMarketingListTypes,"2017-01-24 10:33:38",NULL22,Oro\Bundle\MagentoBundle\Migrations\Data\ORM\UpdateBigNumbersWidgetOptions,"2017-01-24 10:33:38",NULL23,Oro\Bundle\CallBundle\Migrations\Data\ORM\LoadCallStatusData,"2017-01-24 10:33:38",NULL24,Oro\Bundle\MagentoBundle\Migrations\Data\ORM\UpdateIntegrationEntitiesData,"2017-01-24 10:33:38",NULL25,Oro\Bundle\ContactUsBundle\Migrations\Data\ORM\LoadContactReasonData,"2017-01-24 10:33:38",NULL26,Oro\Bundle\CallBundle\Migrations\Data\ORM\LoadCallDirectionData,"2017-01-24 10:33:38",NULL27,Oro\Bundle\SalesBundle\Migrations\Data\ORM\UpdateWorkflowStartStep,"2017-01-24 10:33:38",NULL28,Oro\Bundle\SalesBundle\Migrations\Data\ORM\LoadLeadStatusData,"2017-01-24 10:33:38",NULL29,Oro\Bundle\SalesBundle\Migrations\Data\ORM\LoadOpportunityStatusData,"2017-01-24 10:33:38",NULL30,Oro\Bundle\SalesBundle\Migrations\Data\ORM\DeactivateSalesWorkflows,"2017-01-24 10:33:38",NULL31,Oro\Bundle\SalesBundle\Migrations\Data\ORM\LoadLeadSourceData,"2017-01-24 10:33:38",NULL32,Oro\Bundle\LocaleBundle\Migrations\Data\ORM\LoadLocalizationData,"2017-01-24 10:33:38",NULL33,Oro\Bundle\SalesBundle\Migrations\Data\ORM\LoadOpportunityCloseReasonData,"2017-01-24 10:33:38",NULL34,Oro\Bundle\MagentoBundle\Migrations\Data\ORM\LoadShoppingCartStatusData,"2017-01-24 10:33:38",1.135,Oro\Bundle\AddressBundle\Migrations\Data\ORM\LoadCountryData,"2017-01-24 10:33:38",1.136,Oro\Bundle\EmailBundle\Migrations\Data\ORM\CollectEmailBodyAddJobFixture,"2017-01-24 10:33:38",NULL37,Oro\Bundle\MagentoBundle\Migrations\Data\ORM\LoadRegions,"2017-01-24 10:33:38",NULL38,Oro\Bundle\MagentoBundle\Migrations\Data\ORM\LoadMagentoCountryData,"2017-01-24 10:33:38",1.139,Oro\Bundle\MagentoBundle\Migrations\Data\ORM\UpdateLifetimeHistory,"2017-01-24 10:33:38",NULL40,Oro\Bundle\MagentoBundle\Migrations\Data\ORM\UpdateConnectors,"2017-01-24 10:33:38",NULL41,Oro\Bundle\DataGridBundle\Migrations\Data\ORM\LoadAppearanceTypes,"2017-01-24 10:33:38",NULL42,Oro\Bundle\CaseBundle\Migrations\Data\ORM\LoadPriorityData,"2017-01-24 10:33:38",NULL43,Oro\Bundle\MagentoBundle\Migrations\Data\ORM\UpdateWorkflowStartStep,"2017-01-24 10:33:38",NULL44,Oro\Bundle\ActivityListBundle\Migrations\Data\ORM\UpdateEmailActivityListDescription,"2017-01-24 10:33:38",NULL45,Oro\Bundle\AddressBundle\Migrations\Data\ORM\LoadAddressTypeData,"2017-01-24 10:33:38",NULL46,Oro\Bundle\CaseBundle\Migrations\Data\ORM\LoadStatusData,"2017-01-24 10:33:38",NULL47,Oro\Bundle\CalendarBundle\Migrations\Data\ORM\LoadAttendeeData,"2017-01-24 10:33:38",NULL48,Oro\Bundle\MagentoBundle\Migrations\Data\ORM\ScheduleNewsletterSubscribersResync,"2017-01-24 10:33:38",NULL49,Oro\Bundle\CaseBundle\Migrations\Data\ORM\LoadSourceData,"2017-01-24 10:33:38",NULL50,Oro\Bundle\SecurityBundle\Migrations\Data\ORM\AddSearchReindexJob,"2017-01-24 10:33:38",NULL51,Oro\Bundle\OrganizationBundle\Migrations\Data\ORM\UpdateCustomEntitiesWithOrganization,"2017-01-24 10:33:38",NULL52,Oro\Bundle\UserBundle\Migrations\Data\ORM\LoadRolesData,"2017-01-24 10:33:38",NULL53,Oro\Bundle\AttachmentBundle\Migrations\Data\Orm\UpdateAttachmentsWithOrganization,"2017-01-24 10:33:38",NULL54,Oro\Bundle\UserBundle\Migrations\Data\ORM\LoadAdminUserData,"2017-01-24 10:33:38",NULL55,Oro\Bundle\UserBundle\Migrations\Data\ORM\LoadGroupData,"2017-01-24 10:33:38",NULL56,Oro\Bundle\EmailBundle\Migrations\Data\ORM\UpdateEmailTemplateWithOrganization,"2017-01-24 10:33:38",NULL57,Oro\Bundle\UserBundle\Migrations\Data\ORM\LoadEmailTemplates,"2017-02-15 07:05:59",1.158,Oro\Bundle\UserBundle\Migrations\Data\ORM\AddProfileAndConfigUpdateCabalitiesToRoles,"2017-01-24 10:33:38",NULL59,Oro\Bundle\IntegrationBundle\Migrations\Data\ORM\UpdateIntegrationsWithOrganization,"2017-01-24 10:33:38",NULL60,Oro\Bundle\ActivityListBundle\Migrations\Data\ORM\UpdateActivityListOwner,"2017-01-24 10:33:38",NULL61,Oro\Bundle\CalendarBundle\Migrations\Data\ORM\UpdateAttendeeData,"2017-01-24 10:33:38",NULL62,Oro\Bundle\CalendarBundle\Migrations\Data\ORM\LoadEmailTemplates,"2017-01-24 10:33:38",NULL63,Oro\Bundle\CalendarBundle\Migrations\Data\ORM\AddCalendarEventActivityLists,"2017-01-24 10:33:38",NULL64,Oro\Bundle\CalendarBundle\Migrations\Data\ORM\LoadInvitationEmailTemplates,"2017-01-24 10:33:38",1.165,Oro\Bundle\DataAuditBundle\Migrations\Data\ORM\UpdateAuditDataWithOrganization,"2017-01-24 10:33:38",NULL66,Oro\Bundle\EmbeddedForm\Migrations\Data\ORM\UpdateEmbeddedFormWithOrganization,"2017-01-24 10:33:38",NULL67,Oro\Bundle\NotificationBundle\Migrations\Data\ORM\LoadEmailTemplates,"2017-01-24 10:33:38",NULL68,Oro\Bundle\ReportBundle\Migrations\Data\ORM\UpdateReportWithOrganization,"2017-01-24 10:33:38",NULL69,Oro\Bundle\SegmentBundle\Migrations\Data\ORM\UpdateSegmentWithOrganization,"2017-01-24 10:33:38",NULL70,Oro\Bundle\SidebarBundle\Migrations\Data\ORM\UpdateSidebarWidgetsWithOrganization,"2017-01-24 10:33:38",NULL71,Oro\Bundle\TagBundle\Migrations\Data\ORM\UpdateTagWithOrganization,"2017-01-24 10:33:38",NULL72,Oro\Bundle\DemoDataBundle\Migrations\Data\ORM\LoadRolesData,"2017-01-24 10:33:38",NULL73,Oro\Bundle\DemoDataBundle\Migrations\Data\ORM\UpdateEmailAccessLevels,"2017-01-24 10:33:38",NULL74,Oro\Bundle\UserBundle\Migrations\Data\ORM\UpdateNavigationWithOrganization,"2017-01-24 10:33:38",NULL75,Oro\Bundle\ContactBundle\Migrations\Data\ORM\UpdateContactEntitiesWithOrganization,"2017-01-24 10:33:38",NULL76,Oro\Bundle\AccountBundle\Migrations\Data\ORM\UpdateAccountWithOrganization,"2017-01-24 10:33:38",NULL77,Oro\Bundle\TrackingBundle\Migrations\Data\ORM\UpdateTrackingWebsiteWithOrganization,"2017-01-24 10:33:38",NULL78,Oro\Bundle\CallBundle\Migrations\Data\ORM\UpdateCallWithOrganization,"2017-01-24 10:33:38",NULL79,Oro\Bundle\CampaignBundle\Migrations\Data\ORM\UpdateCampaignWithOrganization,"2017-01-24 10:33:38",NULL80,Oro\Bundle\ChannelBundle\Migrations\Data\ORM\DefaultChannelData,"2017-01-24 10:33:38",NULL81,Oro\Bundle\TaskBundle\Migrations\Data\ORM\LoadEmailTemplates,"2017-01-24 10:33:38",NULL82,Oro\Bundle\TaskBundle\Migrations\Data\ORM\UpdateTaskWithOrganization,"2017-01-24 10:33:38",NULL83,Oro\Bundle\TaskBundle\Migrations\Data\ORM\AddTasksActivityLists,"2017-01-24 10:33:38",NULL84,Oro\Bundle\SalesBundle\Migrations\Data\ORM\LoadCampaignPerformanceReport,"2017-01-24 10:33:38",NULL85,Oro\Bundle\SalesBundle\Migrations\Data\ORM\UpdateB2bCustomerWithOrganization,"2017-01-24 10:33:38",NULL86,Oro\Bundle\SalesBundle\Migrations\Data\ORM\UpdateSalesEntitiesWithOrganization,"2017-01-24 10:33:38",NULL87,Oro\Bundle\SalesBundle\Migrations\Data\ORM\DefaultChannelData,"2017-01-24 10:33:38",1.088,Oro\Bundle\ContactUsBundle\Migrations\Data\ORM\UpdateContactRequestWithOrganization,"2017-01-24 10:33:38",NULL89,Oro\Bundle\ContactUsBundle\Migrations\Data\ORM\DefaultChannelData,"2017-01-24 10:33:38",NULL90,Oro\Bundle\MagentoBundle\Migrations\Data\ORM\UpdateCustomerLifetimeForCanceledOrders,"2017-01-24 10:33:38",NULL91,Oro\Bundle\MagentoBundle\Migrations\Data\ORM\UpdateMagentoEntitiesWithOrganization,"2017-01-24 10:33:38",NULL92,Oro\Bundle\CaseBundle\Migrations\Data\ORM\UpdateCaseEntitiesWithOrganization,"2017-01-24 10:33:38",NULL93,Oro\Bridge\CrmCall\Migrations\Data\ORM\UpdateCallAccessLevels,"2017-01-24 10:33:38",NULL94,Oro\Bundle\SecurityBundle\Migrations\Data\ORM\LoadAclRoles,"2017-01-24 10:33:38",NULL95,Oro\Bundle\UserBundle\Migrations\Data\ORM\UpdateUserEntitiesWithOrganization,"2017-01-24 10:33:38",NULL96,Oro\Bundle\EmailBundle\Migrations\Data\ORM\UpdateEmailEditAclRule,"2017-01-24 10:33:38",1.197,Oro\Bundle\EmailBundle\Migrations\Data\ORM\UpdateEmailAccessLevels,"2017-01-24 10:33:38",NULL98,Oro\Bundle\DashboardBundle\Migrations\Data\ORM\LoadDashboardData,"2017-01-24 10:33:38",NULL99,Oro\Bundle\CalendarBundle\Migrations\Data\ORM\UpdateAclRoles,"2017-01-24 10:33:38",NULL100,Oro\Bundle\CalendarBundle\Migrations\Data\ORM\LoadDashboardData,"2017-01-24 10:33:38",NULL101,Oro\Bundle\DemoDataBundle\Migrations\Data\ORM\UpdateIntegrationAccessLevels,"2017-01-24 10:33:38",NULL102,Oro\Bundle\SidebarBundle\Migrations\Data\ORM\UpdateDashboardsWithOrganization,"2017-01-24 10:33:38",NULL103,Oro\Bundle\DashboardBundle\Migrations\Data\ORM\UpdateDefaultDashboard,"2017-01-24 10:33:38",NULL104,Oro\Bundle\ContactBundle\Migrations\Data\ORM\LoadDashboardData,"2017-01-24 10:33:38",NULL105,Oro\Bundle\AccountBundle\Migrations\Data\ORM\LoadDashboardData,"2017-01-24 10:33:38",NULL106,Oro\Bundle\CallBundle\Migrations\Data\ORM\AddCallsActivityLists,"2017-01-24 10:33:38",NULL107,Oro\Bundle\CallBundle\Migrations\Data\ORM\LoadDashboardData,"2017-01-24 10:33:38",NULL108,Oro\Bundle\SalesBundle\Migrations\Data\ORM\LoadDashboardData,"2017-01-24 10:33:38",NULL109,Oro\Bundle\MagentoBundle\Migrations\Data\ORM\LoadDashboardData,"2017-01-24 10:33:38",NULL110,Oro\Bundle\EmailBundle\Migrations\Data\ORM\AddEmailActivityLists,"2017-01-24 10:33:38",NULL111,Oro\Bundle\EmailBundle\Migrations\Data\ORM\LoadDashboardData,"2017-01-24 10:33:38",NULL112,Oro\Bundle\EmailBundle\Migrations\Data\ORM\AddEmailActivityGrouping,"2017-01-24 10:33:38",NULL113,Oro\Bundle\ScopeBundle\Migrations\Data\ORM\LoadDefaultScope,"2017-02-15 07:05:59",NULL114,Oro\Bundle\MagentoBundle\Migrations\Data\ORM\CreateAccountEntities,"2017-02-15 07:05:59",NULL115,Oro\Bundle\SalesBundle\Migrations\Data\ORM\UpdateFeaturesConfigs,"2017-02-15 07:05:59",NULL116,Oro\Bundle\MagentoContactUsBundle\Migrations\Data\ORM\LoadWorkflowData,"2017-02-15 07:05:59",NULL117,Oro\Bundle\TrackingBundle\Migrations\Data\ORM\SetShareGridConfig,"2017-02-15 07:05:59",NULL118,Oro\Bundle\UIBundle\Migrations\Data\ORM\TrimApplicationUrl,"2017-02-15 07:05:59",NULL119,Oro\Bundle\WorkflowBundle\Migrations\Data\ORM\UpdateDefinitionTranslations,"2017-02-15 07:05:59",NULL120,Oro\Bundle\DotmailerBundle\Migrations\Data\ORM\LoadEnumValues,"2017-02-15 07:05:59",NULL121,Oro\Bundle\DotmailerBundle\Migrations\Data\ORM\LoadDataFieldEnumValues,"2017-02-15 07:05:59",NULL122,Oro\Bundle\ZendeskBundle\Migrations\Data\ORM\LoadTicketTypeData,"2017-02-15 07:05:59",NULL123,Oro\Bundle\ZendeskBundle\Migrations\Data\ORM\LoadStatusData,"2017-02-15 07:05:59",NULL124,Oro\Bundle\ZendeskBundle\Migrations\Data\ORM\LoadRolesData,"2017-02-15 07:05:59",NULL125,Oro\Bundle\ZendeskBundle\Migrations\Data\ORM\LoadPriorityData,"2017-02-15 07:05:59",NULL126,Oro\Bundle\DotmailerBundle\Migrations\Data\ORM\LoadExportOperationTypes,"2017-02-15 07:05:59",NULL127,Oro\Bundle\EmailBundle\Migrations\Data\ORM\EnableEmailFeature,"2017-02-15 07:05:59",NULL128,Oro\Bundle\DataGridBundle\Migrations\Data\ORM\LoadEmailTemplates,"2017-02-15 07:05:59",1.1129,Oro\Bundle\DataGridBundle\Migrations\Data\ORM\SetExportGridDefaultAcls,"2017-02-15 07:05:59",NULL130,Oro\Bundle\DemoDataBundle\Migrations\Data\ORM\LoadWorkflowAclData,"2017-02-15 07:05:59",NULL131,Oro\Bundle\ImportExport\Migrations\Data\ORM\LoadEmailTemplates,"2017-02-15 07:05:59",1.1132,Oro\Bundle\NoteBundle\Migrations\Data\ORM\UpdateNotesWithOrganization,"2017-02-15 07:05:59",NULL133,Oro\Bundle\TranslationBundle\Migrations\Data\ORM\LoadLanguageData,"2017-02-15 07:05:59",NULL134,Oro\Bundle\TranslationBundle\Migrations\Data\ORM\UpdateAclAdministratorRole,"2017-02-15 07:05:59",NULL135,Oro\Bundle\TranslationBundle\Migrations\Data\ORM\UpdateLanguageOwner,"2017-02-15 07:05:59",NULL136,Oro\Bundle\CurrencyBundle\Migrations\Data\ORM\SetDefaultCurrencyFromLocale,"2017-02-15 07:05:59",NULL137,Oro\Bundle\MagentoContactUsBundle\Migrations\Data\ORM\DefaultChannelData,"2017-02-15 07:05:59",NULL138,Oro\Bundle\MagentoContactUsBundle\Migrations\Data\ORM\LoadWorkflowAclData,"2017-02-15 07:05:59",NULL139,Oro\Bridge\MarketingCRM\Migrations\Migrations\Data\ORM\LoadCampaignPerformanceReport,"2017-02-15 07:05:59",NULL140,Oro\Bridge\MarketingCRM\Migrations\Migrations\Data\ORM\LoadTrackingRolesData,"2017-02-15 07:05:59",NULL141,Oro\Bridge\CallCRM\Migrations\Data\ORM\UpdateCallAccessLevels,"2017-02-15 07:05:59",NULL142,Oro\Bridge\TaskCRM\Migrations\Data\ORM\LoadWorkflowAclData,"2017-02-15 07:05:59",NULL143,Oro\Bundle\NoteBundle\Migrations\Data\ORM\AddNoteActivityLists,"2017-02-15 07:05:59",NULLMarch 8, 2017 at 3:35 am #27577oro_migrations_data and oro_migrations are different tables, could you show me the oro_migrations?
March 8, 2017 at 3:47 am #27578Sorry
MySQL123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107id,bundle,version,loaded_at1,OroPlatformBundle,v1_0,"2017-01-24 11:33:16"2,OroOrganizationBundle,v1_5,"2017-01-24 11:33:16"3,OroSecurityBundle,v1_2,"2017-01-24 11:33:16"4,OroAttachmentBundle,v1_4,"2017-01-24 11:33:16"5,OroEmailBundle,v1_29,"2017-01-24 11:33:16"6,OroCronBundle,v1_3,"2017-01-24 11:33:16"7,OroUserBundle,v1_21,"2017-01-24 11:33:16"8,OroDataGridBundle,v1_4,"2017-01-24 11:33:16"9,OroSSOBundle,v1_0,"2017-01-24 11:33:16"10,OroEntityConfigBundle,v1_10,"2017-01-24 11:33:16"11,OroEntityExtendBundle,v1_8,"2017-01-24 11:33:16"12,OroIntegrationBundle,v1_15,"2017-01-24 11:33:16"13,OroActivityBundle,v1_1,"2017-01-24 11:33:16"14,OroActivityListBundle,v1_3,"2017-01-24 11:33:16"15,OroAddressBundle,v1_3,"2017-01-24 11:33:16"16,OroBatchBundle,v1_3,"2017-01-24 11:33:16"17,OroCalendarBundle,v1_14_1,"2017-01-24 11:33:16"18,OroConfigBundle,v1_1,"2017-01-24 11:33:16"19,OroDataAuditBundle,v1_7,"2017-01-24 11:33:16"20,OroEmbeddedFormBundle,v1_5,"2017-01-24 11:33:16"21,OroImapBundle,v1_5,"2017-01-24 11:33:16"22,OroImportExportBundle,v1_0,"2017-01-24 11:33:16"23,OroInstallerBundle,v1_1,"2017-01-24 11:33:16"24,OroLocaleBundle,v1_0,"2017-01-24 11:33:16"25,OroMigrationBundle,v1_1,"2017-01-24 11:33:16"26,OroNoteBundle,v1_2,"2017-01-24 11:33:16"27,OroNotificationBundle,v1_2,"2017-01-24 11:33:16"28,OroReportBundle,v1_6,"2017-01-24 11:33:16"29,OroSearchBundle,v1_1,"2017-01-24 11:33:16"30,OroSegmentBundle,v1_5,"2017-01-24 11:33:16"31,OroSidebarBundle,v1_1,"2017-01-24 11:33:16"32,OroTagBundle,v1_7,"2017-01-24 11:33:16"33,OroTranslationBundle,v1_1,"2017-01-24 11:33:16"34,OroWindowsBundle,v1_1,"2017-01-24 11:33:16"35,OroWorkflowBundle,v1_13,"2017-01-24 11:33:16"36,OroActivityContactBundle,v1_1,"2017-01-24 11:33:16"37,OroCommentBundle,v1_1,"2017-01-24 11:33:16"38,OroDashboardBundle,v1_7,"2017-01-24 11:33:16"39,OroNavigationBundle,v1_3,"2017-01-24 11:33:16"40,OroContactBundle,v1_14,"2017-01-24 11:33:16"41,OroAccountBundle,v1_11,"2017-01-24 11:33:16"42,OroMarketingListBundle,v1_2,"2017-01-24 11:33:16"43,OroTrackingBundle,v1_10,"2017-01-24 11:33:16"44,OroReminderBundle,v1_3,"2017-01-24 11:33:16"45,OroCallBundle,v1_7,"2017-01-24 11:33:16"46,OroCampaignBundle,v1_9,"2017-01-24 11:33:16"47,OroChannelBundle,v1_6,"2017-01-24 11:33:16"48,OroTaskBundle,v1_11_1,"2017-01-24 11:33:16"49,OroAnalyticsBundle,v1_0,"2017-01-24 11:33:16"50,OroSalesBundle,v1_25_5,"2017-01-24 11:33:16"51,OroContactUsBundle,v1_10,"2017-01-24 11:33:16"52,OroMagentoBundle,v1_41_4,"2017-01-24 11:33:16"53,OroCaseBundle,v1_9,"2017-01-24 11:33:16"54,OroCallCRMBridgeBundle,v1_0,"2017-01-24 11:33:16"55,OroTaskCRMBridgeBundle,v1_0,"2017-01-24 11:33:16"56,OroPlatformBundle,v1_1,"2017-02-01 12:52:38"57,OroScopeBundle,v1_0,"2017-02-01 12:52:38"58,OroOrganizationBundle,v1_6,"2017-02-01 12:52:38"59,OroSecurityBundle,v1_3,"2017-02-01 12:52:38"60,OroAttachmentBundle,v1_5,"2017-02-01 12:52:38"61,OroMessageQueueBundle,v1_1,"2017-02-01 12:52:38"62,OroEmailBundle,v1_30,"2017-02-01 12:52:38"63,OroCronBundle,v2_0,"2017-02-01 12:52:38"64,OroUserBundle,v2_0,"2017-02-01 12:52:38"65,OroDataGridBundle,v1_5,"2017-02-01 12:52:38"66,OroEntityBundle,v1_0,"2017-02-01 12:52:38"67,OroLocaleBundle,v1_1,"2017-02-01 12:52:38"68,OroEntityConfigBundle,v1_13,"2017-02-01 12:52:38"69,OroEntityExtendBundle,v1_9,"2017-02-01 12:52:38"70,OroActivityListBundle,v1_4,"2017-02-01 12:52:38"71,OroDataAuditBundle,v1_9,"2017-02-01 12:52:38"72,OroNoteBundle,v1_3,"2017-02-01 12:52:38"73,OroReportBundle,v2_0,"2017-02-01 12:52:38"74,OroSearchBundle,v1_3,"2017-02-01 12:52:38"75,OroSegmentBundle,v1_6,"2017-02-01 12:52:38"76,OroTagBundle,v1_8,"2017-02-01 12:52:38"77,OroTranslationBundle,v1_3,"2017-02-01 12:52:38"78,OroTranslationBundle,v1_4,"2017-02-15 07:58:28"79,OroWorkflowBundle,v2_1,"2017-02-15 07:58:28"80,OroCommentBundle,v1_2,"2017-02-15 07:58:28"81,OroBundle,v1_2,"2017-02-15 07:58:28"82,OroCalendarBundle,v1_17,"2017-02-15 07:58:28"83,OroHangoutsCallBundle,v1_0,"2017-02-15 07:58:28"84,OroCurrencyBundle,v1_0,"2017-02-15 07:58:28"85,OroNavigationBundle,v1_6,"2017-02-15 07:58:28"86,OroMarketingListBundle,v1_3,"2017-02-15 07:58:28"87,OroTrackingBundle,v1_11,"2017-02-15 07:58:28"88,OroAccountBundle,v1_12,"2017-02-15 07:58:28"89,OroChannelBundle,v1_8,"2017-02-15 07:58:28"90,OroMagentoContactUsBundle,v1_0,"2017-02-15 07:58:28"91,OroTaskBundle,v1_12,"2017-02-15 07:58:28"92,OroSalesBundle,v1_31,"2017-02-15 07:58:28"93,OroContactUsBundle,v1_13,"2017-02-15 07:58:28"94,OroMagentoBundle,v1_45,"2017-02-15 07:58:28"95,OroMarketingCRMBridgeBundle,v1_0,"2017-02-15 07:58:28"96,OroEntitySerializedFieldsBundle,v1_1,"2017-02-15 07:58:28"97,OroCalendarCRMBridgeBundle,v1_0,"2017-02-15 07:58:28"98,OroZendeskBundle,v1_2,"2017-02-15 07:58:28"99,OroMailChimpBundle,v1_4,"2017-02-15 07:58:28"100,OroDotmailerBundle,v1_3,"2017-02-15 07:58:28"101,OroAbandonedCartBundle,v1_2,"2017-02-15 07:58:28"102,OroBundle,v1_2,"2017-02-15 08:05:45"103,OroBundle,v1_2,"2017-02-15 09:17:22"104,OroBundle,v1_2,"2017-02-15 10:44:58"105,OroBundle,v1_2,"2017-03-07 14:21:50"106,OroCRMBundle,v1_2,"2017-03-07 14:25:40"March 8, 2017 at 4:50 am #27579I looked in the source code UpdateTranslationColumns.php is not in v1_2 folder but in v1_3 folder….
March 8, 2017 at 5:52 am #27580Thank you for your answers! As i understand this is dump of oro_migrations table from 2.* version, right ? Could you please give me dump of oro_migrations from 1.10.12 version.
March 8, 2017 at 6:19 am #27581MySQL12345678910111213141516171819202122DROP TABLE IF EXISTS <code>oro_migrations</code>;/*!40101 SET @saved_cs_client = @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE <code>oro_migrations</code> (id</code> int(11) NOT NULL AUTO_INCREMENT,bundle</code> varchar(250) COLLATE utf8_unicode_ci NOT NULL,version</code> varchar(250) COLLATE utf8_unicode_ci NOT NULL,loaded_at</code> datetime NOT NULL,PRIMARY KEY (<code>id</code>),KEY <code>idx_oro_migrations</code> (<code>bundle</code>)) ENGINE=InnoDB AUTO_INCREMENT=52 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;/*!40101 SET character_set_client = @saved_cs_client */;---- Dumping data for table <code>oro_migrations--LOCK TABLES <code>oro_migrations</code> WRITE;/*!40000 ALTER TABLE <code>oro_migrations</code> DISABLE KEYS */;INSERT INTO <code>oro_migrations</code> VALUES (1,'OroPlatformBundle','v1_0','2016-04-25 10:53:40'),(2,'OroOrganizationBundle','v1_4','2016-04-25 10:53:40'),(3,'OroSecurityBundle','v1_0','2016-04-25 10:53:40'),(4,'OroAttachmentBundle','v1_3','2016-04-25 10:53:40'),(5,'OroEmailBundle','v1_20','2016-04-25 10:53:40'),(6,'OroCronBundle','v1_3','2016-04-25 10:53:40'),(7,'OroUserBundle','v1_18','2016-04-25 10:53:40'),(8,'OroSSOBundle','v1_0','2016-04-25 10:53:40'),(9,'OroEntityConfigBundle','v1_9','2016-04-25 10:53:40'),(10,'OroEntityExtendBundle','v1_5','2016-04-25 10:53:40'),(11,'OroIntegrationBundle','v1_13','2016-04-25 10:53:40'),(12,'OroActivityBundle','v1_1','2016-04-25 10:53:40'),(13,'OroActivityListBundle','v1_3','2016-04-25 10:53:40'),(14,'OroAddressBundle','v1_3','2016-04-25 10:53:40'),(15,'OroBatchBundle','v1_3','2016-04-25 10:53:40'),(16,'OroCalendarBundle','v1_9','2016-04-25 10:53:40'),(17,'OroConfigBundle','v1_1','2016-04-25 10:53:40'),(18,'OroDataAuditBundle','v1_6','2016-04-25 10:53:40'),(19,'OroDataGridBundle','v1_2','2016-04-25 10:53:40'),(20,'OroEmbeddedFormBundle','v1_4','2016-04-25 10:53:40'),(21,'OroImapBundle','v1_4','2016-04-25 10:53:40'),(22,'OroInstallerBundle','v1_1','2016-04-25 10:53:40'),(23,'OroMigrationBundle','v1_1','2016-04-25 10:53:40'),(24,'OroNoteBundle','v1_1','2016-04-25 10:53:40'),(25,'OroNotificationBundle','v1_1','2016-04-25 10:53:40'),(26,'OroReportBundle','v1_5','2016-04-25 10:53:40'),(27,'OroSearchBundle','v1_1','2016-04-25 10:53:40'),(28,'OroSegmentBundle','v1_4','2016-04-25 10:53:40'),(29,'OroSidebarBundle','v1_1','2016-04-25 10:53:40'),(30,'OroTagBundle','v1_7','2016-04-25 10:53:40'),(31,'OroTranslationBundle','v1_1','2016-04-25 10:53:40'),(32,'OroWindowsBundle','v1_1','2016-04-25 10:53:40'),(33,'OroWorkflowBundle','v1_12','2016-04-25 10:53:40'),(34,'OroCRMActivityContactBundle','v1_0','2016-04-25 10:53:40'),(35,'OroCommentBundle','v1_1','2016-04-25 10:53:40'),(36,'OroDashboardBundle','v1_7','2016-04-25 10:53:40'),(37,'OroNavigationBundle','v1_3','2016-04-25 10:53:40'),(38,'OroCRMContactBundle','v1_13','2016-04-25 10:53:40'),(39,'OroCRMAccountBundle','v1_10','2016-04-25 10:53:40'),(40,'OroCRMMarketingListBundle','v1_2','2016-04-25 10:53:40'),(41,'OroTrackingBundle','v1_8','2016-04-25 10:53:40'),(42,'OroReminderBundle','v1_2_1','2016-04-25 10:53:40'),(43,'OroCRMCallBundle','v1_5','2016-04-25 10:53:40'),(44,'OroCRMCampaignBundle','v1_9','2016-04-25 10:53:40'),(45,'OroCRMChannelBundle','v1_5','2016-04-25 10:53:40'),(46,'OroCRMTaskBundle','v1_9','2016-04-25 10:53:40'),(47,'OroCRMAnalyticsBundle','v1_0','2016-04-25 10:53:40'),(48,'OroCRMSalesBundle','v1_21','2016-04-25 10:53:40'),(49,'OroCRMContactUsBundle','v1_10','2016-04-25 10:53:40'),(50,'OroCRMMagentoBundle','v1_41','2016-04-25 10:53:40'),(51,'OroCRMCaseBundle','v1_8','2016-04-25 10:53:40');/*!40000 ALTER TABLE <code>oro_migrations</code> ENABLE KEYS */;UNLOCK TABLES;March 8, 2017 at 7:41 am #27582Maybe do you have some custom php/mysql settings? From my side i have the following extensions, can you show me, please, yours?
Shell12345678910111213141516171819202122232425262728293031323334353637383940414243bash-3.2# php -m[PHP Modules]bcmathbz2CorectypecurldatedomfileinfofiltergdgettexthashiconvintljsonldaplibxmlmbstringmcryptmysqlimysqlndopensslpcrePDOpdo_mysqlPharreadlineReflectionsessionSimpleXMLsoapSPLstandardtokenizerxmlxmlreaderxmlwriterxslzipzlibAlso i would to know php version. For example my version:
Shell12345bash-3.2# php -vPHP 7.0.14 (cli) (built: Dec 10 2016 16:55:05) ( NTS )Copyright (c) 1997-2016 The PHP GroupZend Engine v3.0.0, Copyright (c) 1998-2016 Zend TechnologiesMarch 8, 2017 at 8:00 am #27583PHP1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253[PHP Modules]calendarCorectypecurldatedomexiffileinfofilterftpgdgettexthashiconvintljsonlibxmlmbstringmcryptmysqlimysqlndopensslpcntlpcrePDOpdo_mysqlPharposixreadlineReflectionsessionshmopSimpleXMLsoapsocketsSPLstandardsysvmsgsysvsemsysvshmtokenizerwddxxmlxmlreaderxmlwriterxslZend OPcachezipzlib[Zend Modules]Zend OPcacheand
PHP1234PHP 7.0.15-0ubuntu0.16.04.2 (cli) ( NTS )Copyright (c) 1997-2017 The PHP GroupZend Engine v3.0.0, Copyright (c) 1998-2017 Zend Technologieswith Zend OPcache v7.0.15-0ubuntu0.16.04.2, Copyright (c) 1999-2017, by Zend TechnologiesMarch 9, 2017 at 7:45 am #27584Are you sure that you deleted cache (rm …) before running oro:platform:upgrade20?
Shell1234git remote updategit checkout 2.0.3composer installapp/console oro:platform:upgrade20 --env=prod --forceMarch 9, 2017 at 7:48 am #27585yes i’m sure…
I tested on another test version identical to that the but in English except the problems with my own bundles the migration went well - AuthorReplies
The forum ‘OroCRM – Installation/Technical Issues or Problems’ is closed to new topics and replies.