search

YetiForceCompany / YetiForceCRM

Our team created for you one of the most innovative CRM systems that supports mainly business processes and allows for customization according to your needs. Be ahead of your competition and implement YetiForce!
https://yetiforce.com
Other
1.73k stars 749 forks source link

[bug] Internal Server Error at the end of Update to 5.3 #12724

Closed vovpff closed 4 years ago

vovpff commented 4 years ago

🐞 bug report

⁉️ Describe the bug

At the end of update process I get Internal Server Error page

ConfReport

Importer.log

-------------   2020-03-16 12:24:41   -------------
> start update tables (base)
  > add column: vtiger_activitytype:icon ... done    (0.2s)
  > add column: vtiger_cron_task:handler_class ... done    (0.2s)
  > create index: handler_class ... done    (0.1s)
  > add column: vtiger_blocks:icon ... done    (0.2s)
  > add column: vtiger_relatedlists:field_name ... done    (0.3s)
  > alter column: vtiger_relatedlists:presence ... done    (0s)
  > create index: ossmailview_date_idx ... done    (0.2s)
  > add table: u_#__chat_rooms_private ... done    (0.1s)
  > add table: u_#__chat_rooms_user ... done    (0.1s)
  > add table: u_#__chat_user ... done    (0.1s)
  > add table: u_#__chat_messages_private ... done    (0.1s)
  > add table: u_#__chat_messages_user ... done    (0.1s)
  > add table: u_#__chat_private ... done    (0.1s)
  > add table: u_#__chat_rooms ... done    (0.1s)
  > alter column: u_#__emailtemplates:content ... done    (0.3s)
  > alter column: vtiger_entity_stats:crmactivity ... done    (0.2s)
  > alter column: vtiger_osstimecontrol:time_start ... done    (0.2s)
  > alter column: vtiger_osstimecontrol:time_end ... done    (0.2s)
  > alter column: vtiger_osstimecontrol:deleted ... done    (0.2s)
  > alter column: vtiger_projectmilestone:projectmilestonedate ... done    (0.2s)
  > alter column: vtiger_reservations:time_start ... done    (0.2s)
  > alter column: vtiger_reservations:time_end ... done    (0.2s)
  > alter column: vtiger_reservations:deleted ... done    (0.4s)
  > alter column: vtiger_users:no_of_currency_decimals ... done    (0.2s)
  > alter column: com_vtiger_workflows:defaultworkflow ... done    (0.2s)
  > alter column: com_vtiger_workflows:filtersavedinnew ... done    (0.3s)
  > alter column: vtiger_currency:presence ... done    (0.2s)
  > alter column: vtiger_currency_info:deleted ... done    (0.2s)
  > alter column: vtiger_customview:presence ... done    (0.2s)
  > foreign key must be removed and added in postUpdate: vtiger_def_org_share:permission <> vtiger_org_share_action_mapping:share_action_id FK:fk_1_vtiger_def_org_share
  > alter column: vtiger_def_org_share:permission ... done    (0.2s)
  > alter column: vtiger_def_org_share:editstatus ... done    (0.2s)
  > create index: fk_1_def_org_share_tabid ... done    (0.1s)
  > alter column: vtiger_fieldmodulerel:fieldid ... done    (0.2s)
  > alter column: vtiger_import_maps:has_header ... done    (0.2s)
  > alter column: vtiger_import_maps:deleted ... done    (0.1s)
  > add column: vtiger_loginhistory:userid ... done    (2s)
  > add column: vtiger_loginhistory:agent ... done    (1.8s)
  > create index: userid ... done    (0.3s)
  > alter column: vtiger_modentity_num:tabid ... done    (0.6s)
  > alter column: vtiger_org_share_action_mapping:share_action_id ... done    (0.2s)
  > foreign key must be removed and added in postUpdate: vtiger_profile:profileid <> vtiger_profile2field:profileid FK:vtiger_profile2field_ibfk_1
  > foreign key must be removed and added in postUpdate: vtiger_profile:profileid <> vtiger_profile2globalpermissions:profileid FK:fk_1_vtiger_profile2globalpermissions
  > foreign key must be removed and added in postUpdate: vtiger_profile:profileid <> vtiger_profile2tab:profileid FK:vtiger_profile2tab_ibfk_1
  > foreign key must be removed and added in postUpdate: vtiger_profile:profileid <> vtiger_profile2utility:profileid FK:vtiger_profile2utility_ibfk_1
  > foreign key must be removed and added in postUpdate: vtiger_profile:profileid <> vtiger_role2profile:profileid FK:vtiger_role2profile_ibfk_2
  > alter column: vtiger_profile:profileid ... done    (0.2s)
  > alter column: vtiger_profile2globalpermissions:profileid ... done    (0.2s)
  > alter column: vtiger_profile2tab:profileid ... done    (0.2s)
  > alter column: vtiger_profile2tab:tabid ... done    (0.2s)
  > alter column: vtiger_profile2tab:permissions ... done    (0.2s)
  > create index: fk_1_profile2tab_tabid ... done    (0.1s)
  > alter column: vtiger_profile2standardpermissions:tabid ... done    (0.3s)
  > create index: fk_1_profile2field_tabid ... done    (0.2s)
  > alter column: vtiger_profile2field:profileid ... done    (1.2s)
  > alter column: vtiger_profile2field:visible ... done    (1.6s)
  > alter column: vtiger_profile2field:readonly ... done    (1.1s)
  > create index: fk_1_profile2field_fieldid ... done    (0.2s)
  > alter column: vtiger_profile2utility:profileid ... done    (1.1s)
  > alter column: vtiger_profile2utility:activityid ... done    (1.5s)
  > alter column: vtiger_profile2utility:permission ... done    (1.1s)
  > create index: fk_1_profile2utility_activityid ... done    (0.2s)
  > alter column: vtiger_relatedlists_fields:fieldid ... done    (0.2s)
  > create index: fk_1_relatedlists_fields_fieldid ... done    (0.1s)
  > alter column: vtiger_role2profile:profileid ... done    (0.2s)
  > alter column: vtiger_rss:starred ... done    (0.1s)
  > alter column: vtiger_trees_templates:access ... done    (0.2s)
  > alter column: vtiger_users_last_import:deleted ... done    (0.2s)
  > alter column: yetiforce_currencyupdate_banks:active ... done    (0.2s)
  > add table: u_#__relations_members_entity ... done    (0.1s)
  > create index: u_yf_relations_members_entity_crmid_idx ... done    (0.1s)
  > create index: u_yf_relations_members_entity_relcrmid_idx ... done    (0.1s)
  > add table: vtiger_status_rel ... done    (0.1s)
  > alter column: u_#__openstreetmap:crmid ... done    (0.2s)
  > alter column: u_#__openstreetmap:lat ... done    (0.2s)
  > alter column: u_#__openstreetmap:lon ... done    (0.2s)
  > alter column: u_#__openstreetmap_address_updater:crmid ... done    (0.2s)
# end update tables    (0.39s)
> start update tables (admin)
  > alter column: s_#__companies:companysize ... done    (0.2s)
  > alter column: s_#__mail_queue:content ... done    (0.2s)
  > alter column: a_#__pdf:header_content ... done    (0.2s)
  > alter column: a_#__pdf:body_content ... done    (0.2s)
  > alter column: a_#__pdf:footer_content ... done    (0.2s)
# end update tables    (0.02s)
> start update tables (webservice)
  > add table: w_#__manage_consents_user ... done    (0.1s)
  > create index: user_uq ... done    (0s)
  > alter column: w_#__portal_session:id ... done    (0.2s)
  > alter column: w_#__portal_session:user_id ... done    (0.1s)
  > alter column: w_#__portal_session:created ... done    (0s)
  > alter column: w_#__portal_session:changed ... done    (0s)
  > create index: user_id ... done    (0s)
  > alter column: w_#__portal_user:id ... done    (0.2s)
  > alter column: w_#__portal_user:server_id ... done    (0.2s)
  > alter column: w_#__portal_user:status ... done    (0.2s)
  > alter column: w_#__portal_user:type ... done    (0.2s)
  > alter column: w_#__portal_user:login_time ... done    (0s)
  > alter column: w_#__portal_user:logout_time ... done    (0s)
  > create index: server_id ... done    (0s)
  > alter column: w_#__servers:id ... done    (0.2s)
# end update tables    (0.02s)
> start update tables (log)
  > alter column: l_#__switch_users:agent ... done    (0s)
  > alter column: o_#__access_for_admin:agent ... done    (0s)
  > alter column: o_#__access_for_api:agent ... done    (0s)
  > alter column: o_#__access_for_user:agent ... done    (0s)
  > alter column: o_#__access_to_record:agent ... done    (0s)
  > alter column: o_#__csrf:agent ... done    (0s)
# end update tables    (0s)
> start update foreign key (base)
  > add: fk_vtiger_campaigncampaignid, vtiger_campaign ... done    (0.1s)
  > add: fk_1_def_org_share_tabid, vtiger_def_org_share ... done    (0s)
  > add: vtiger_fieldmodulerel_ibfk_1, vtiger_fieldmodulerel ... done    (0s)
  > add: fk_1_modentity_num_tabid, vtiger_modentity_num ... done    (0s)
  > add: fk_1_profile2field_fieldid, vtiger_profile2field ... done    (0s)
  > add: fk_2_profile2field_tabid, vtiger_profile2field ... done    (0s)
  > add: fk_1_profile2stand_profileid, vtiger_profile2standardpermissions ... done    (0s)
  > add: fk_1_profile2stand_tabid, vtiger_profile2standardpermissions ... done    (0s)
  > add: fk_1_profile2tab_tabid, vtiger_profile2tab ... done    (0s)
  > add: fk_1_profile2utility_activityid, vtiger_profile2utility ... done    (0s)
  > add: fk_1_profile2utility_tabid, vtiger_profile2utility ... done    (0s)
  > add: fk_1_relatedlists_fields_fieldid, vtiger_relatedlists_fields ... done    (0s)
  > add: u_yf_openstreetmap_ibfk_1, u_yf_openstreetmap ... done    (0s)
  > add: u_yf_openstreetmap_record_updater_ibfk_1, u_yf_openstreetmap_record_updater ... done    (0s)
  > add: u_yf_relations_members_entity_crmid_fk, u_yf_relations_members_entity ... done    (0s)
  > add: u_yf_relations_members_entity_relcrmid_fk, u_yf_relations_members_entity ... done    (0s)
  > add: vtiger_crmentityrel_crmid_fk, vtiger_crmentityrel ... done    (0s)
  > add: vtiger_crmentityrel_relcrmid_fk, vtiger_crmentityrel ... done    (0s)
  > add: fk_1_vtiger_def_org_share, vtiger_def_org_share ... done    (0s)
  > add: vtiger_profile2field_ibfk_1, vtiger_profile2field ... done    (0s)
  > add: fk_1_vtiger_profile2globalpermissions, vtiger_profile2globalpermissions ... done    (0s)
  > add: vtiger_profile2tab_ibfk_1, vtiger_profile2tab ... done    (0s)
  > add: vtiger_profile2utility_ibfk_1, vtiger_profile2utility ... done    (0s)
  > add: vtiger_role2profile_ibfk_2, vtiger_role2profile ... done    (0s)
# end update foreign key    (0.01s)
> start update foreign key (webservice)
  > add: w_yf_manage_consents_user_fk1, w_yf_manage_consents_user ... done    (0s)
  > add: w_yf_portal_session_ibfk_1, w_yf_portal_session ... done    (0s)
  > add: w_yf_portal_user_ibfk_1, w_yf_portal_user ... done    (0s)
# end update foreign key    (0s)
> start drop columns
  > drop column: vtiger_cron_task:handler_file ... done    (0.3s)
  > drop column: vtiger_leaddetails:assignleadchk ... done    (0.2s)
  > drop column: vtiger_leadsubdetails:callornot ... done    (0.1s)
  > drop column: vtiger_leadsubdetails:readornot ... done    (0.1s)
  > drop column: vtiger_leadsubdetails:empct ... done    (0.1s)
  > drop column: w_#__portal_user:password_h ... done    (0.1s)
# end drop columns (0.01 min)
> start drop indexes
  > drop index, vtiger_relatedlists:tabid ... done    (0s)
  > drop index, vtiger_relatedlists:tabid_2 ... done    (0s)
  > drop index, vtiger_campaign:campaign_campaignid_idx ... done    (0s)
# end drop indexes (0 min)
> start update foreign key (base)
# end update foreign key    (0s)
> start update foreign key (webservice)
# end update foreign key    (0s)
> start drop tables
  > drop table, vtiger_durationhrs ... done    (0s)
  > drop table, vtiger_durationmins ... done    (0.1s)
  > drop table, vtiger_leadstage ... done    (0s)
  > drop table, vtiger_mail_accounts ... done    (0s)
  > drop table, vtiger_opportunitystage ... done    (0.1s)
  > drop table, vtiger_priority ... done    (0s)
# end drop tables (0 min)
-------------  2020-03-16 12:26:14 (1.54 min)   -------------

updateLogsTrace.log

YetiForceUpdate::update | 2020-03-16 12:24:41
preUpdateScheme |   12:24:41 -> 12:24:42    |   0 min.
createdUserId   |   12:25:08 -> 12:25:09    |   0.02 min. [u: 28|i: 45]
addModules  |   12:25:09 -> 12:25:21    |   0.21 min.
updateWidgets   |   12:25:21 -> 12:25:22    |   0.01 min.
dropColumns |   12:25:22 -> 12:25:22    |   0.01 min.
indexes |   12:25:22 -> 12:25:23    |   0 min.
changePresence  |   12:25:23 -> 12:25:51    |   0.48 min. [updated: 160]
changeColumnType    |   12:25:51 -> 12:25:54    |   0.05 min.
updateCountry   |   12:25:54 -> 12:25:54    |   0 min.
links   |   12:25:56 -> 12:25:56    |   0 min.
blocks  |   12:25:56
updateBlocks    |   12:25:56 -> 12:25:56    |   0 min. -> 12:25:56  |   0 min.
addFields   |   12:25:56 -> 12:25:57    |   0.01 min.
addModules  |   12:25:57 -> 12:26:10    |   0.23 min.
updateRelationField |   12:26:10 -> 12:26:12    |   0.02 min.
menu    |   12:26:12 -> 12:26:12    |   0 min.
data    |   12:26:12 -> 12:26:13    |   0.02 min.
updateUsersFields   |   12:26:13
updateBlocks    |   12:26:13 -> 12:26:13    |   0 min. -> 12:26:13  |   0.01 min.
updateWorkflowTaskSumFieldFromDependent |   12:26:13 -> 12:26:13    |   0 min. u:2
createdUserId   |   12:26:13 -> 12:26:13    |   0 min. [u: 0|i: 2]
deleteFilesAfterUpgrade |   12:26:13 -> 12:26:13    |   0 min.
YetiForceUpdate::createConfigFiles      |   12:26:14 -> 12:26:14    |   0 min.
YetiForceUpdate::update - 2020-03-16 12:26:15 | 1.55 min
YetiForceUpdate::postupdate     |   12:26:17
YetiForceUpdate::baseModuleTools        |   12:26:17
vovpff commented 4 years ago

Cron message:

PHP Notice:  Undefined variable: typeDb in /home/etwhd/etwh/app/Db.php on line 174

Cron output

---------------  2020-03-17 14:21:32 | Start CRON  ----------
2020-03-17 14:21:32 | LBL_WORKFLOW - Not ready to run as the time to run again is not completed
2020-03-17 14:21:32 | LBL_SEND_REMINDER - Not ready to run as the time to run again is not completed
2020-03-17 14:21:32 | LBL_CURRENCY_UPDATE - Not ready to run as the time to run again is not completed
2020-03-17 14:21:32 | LBL_SCHEDULED_IMPORT - Not ready to run as the time to run again is not completed
2020-03-17 14:21:32 | LBL_MAIL_SCANNER_ACTION - Not ready to run as the time to run again is not completed
2020-03-17 14:21:32 | LBL_MAIL_SCANNER_VERIFICATION - Not ready to run as the time to run again is not completed
2020-03-17 14:21:32 | LBL_MAIL_SCANNER_BIND - Not ready to run as the time to run again is not completed
2020-03-17 14:21:32 | LBL_CARD_DAV - Not ready to run as the time to run again is not completed
2020-03-17 14:21:32 | LBL_CAL_DAV - Not ready to run as the time to run again is not completed
2020-03-17 14:21:32 | LBL_ACTIVITY_STATE - Not ready to run as the time to run again is not completed
2020-03-17 14:21:32 | LBL_MULTI_REFERENCE_VALUE - Not ready to run as the time to run again is not completed
2020-03-17 14:21:32 | LBL_CRMACTIVITY_DAYS - Not ready to run as the time to run again is not completed
2020-03-17 14:21:32 | LBL_ASSETS_RENEWAL - Not ready to run as the time to run again is not completed
2020-03-17 14:21:32 | LBL_SOLD_SERVICES_RENEWAL - Not ready to run as the time to run again is not completed
2020-03-17 14:21:32 | LBL_SEND_NOTIFICATIONS - Not ready to run as the time to run again is not completed
2020-03-17 14:21:32 | LBL_RECORD_LABEL_UPDATER - Not ready to run as the time to run again is not completed
2020-03-17 14:21:32 | LBL_PRIVILEGES_UPDATER - Start task
2020-03-17 14:21:32 | LBL_PRIVILEGES_UPDATER - End task (0.01 s)
2020-03-17 14:21:32 | LBL_UPDATER_COORDINATES - Start task
2020-03-17 14:21:32 | LBL_UPDATER_COORDINATES - End task (0.02 s)
2020-03-17 14:21:32 | LBL_UPDATER_RECORDS_COORDINATES - Not ready to run as the time to run again is not completed
2020-03-17 14:21:32 | LBL_ADDRESS_BOOK - Not ready to run as the time to run again is not completed
2020-03-17 14:21:32 | LBL_MARK_RECORDS_AS_REVIEWED - Not ready to run as the time to run again is not completed
2020-03-17 14:21:32 | LBL_MAILER - Start task
2020-03-17 14:21:32 | LBL_MAILER - End task (0.02 s)
2020-03-17 14:21:32 | LBL_CACHE - Not ready to run as the time to run again is not completed
2020-03-17 14:21:32 | LBL_NEVER_ENDING_RECURRING_EVENTS - Not ready to run as the time to run again is not completed
2020-03-17 14:21:32 | LBL_BROWSING_HISTORY - Not ready to run as the time to run again is not completed
2020-03-17 14:21:32 | LBL_BATCH_PROCESSES - Not ready to run as the time to run again is not completed
2020-03-17 14:21:32 | LBL_SMSNOTIFIER - Not ready to run as the time to run again is not completed
2020-03-17 14:21:32 | LBL_CLEAR_FILE_UPLOAD_TEMP - Not ready to run as the time to run again is not completed
2020-03-17 14:21:32 | LBL_BATCH_METHODS - Not ready to run as the time to run again is not completed
2020-03-17 14:21:32 | LBL_SESSION_CLEANER - Start task
2020-03-17 14:21:32 | LBL_SESSION_CLEANER - End task (0.01 s)
===============  2020-03-17 14:21:32 (0.1) | End CRON  ==========
mariuszkrzaczkowski commented 4 years ago

You must correct the server configuration before upgrading. Set error_log there you will probably see an error

vovpff commented 4 years ago

@mariuszkrzaczkowski

Another one update

YetiForceUpdate::update | 2020-03-17 15:29:35
preUpdateScheme |       15:29:35 -> 15:29:35    |       0 min.
createdUserId   |       15:29:58 -> 15:29:59    |       0.02 min. [u: 28|i: 45]
addModules      |       15:29:59 -> 15:30:14    |       0.23 min.
updateWidgets   |       15:30:14 -> 15:30:14    |       0 min.
dropColumns     |       15:30:14 -> 15:30:15    |       0.02 min.
indexes |       15:30:15 -> 15:30:15    |       0 min.
changePresence  |       15:30:15 -> 15:30:43    |       0.47 min. [updated: 160]
changeColumnType        |       15:30:43 -> 15:30:46    |       0.05 min.
updateCountry   |       15:30:46 -> 15:30:46    |       0 min.
links   |       15:30:48 -> 15:30:48    |       0 min.
blocks  |       15:30:48
updateBlocks    |       15:30:48 -> 15:30:48    |       0 min. -> 15:30:48      |       0 min.
addFields       |       15:30:48 -> 15:30:49    |       0.01 min.
addModules      |       15:30:49 -> 15:31:03    |       0.24 min.
updateRelationField     |       15:31:03 -> 15:31:04    |       0.02 min.
menu    |       15:31:04 -> 15:31:04    |       0 min.
data    |       15:31:04 -> 15:31:05    |       0.02 min.
updateUsersFields       |       15:31:05
updateBlocks    |       15:31:06 -> 15:31:06    |       0 min. -> 15:31:06      |       0.01 min.
updateWorkflowTaskSumFieldFromDependent |       15:31:06 -> 15:31:06    |       0 min. u:2
createdUserId   |       15:31:06 -> 15:31:06    |       0 min. [u: 0|i: 2]
deleteFilesAfterUpgrade |       15:31:06 -> 15:31:06    |       0 min.
YetiForceUpdate::createConfigFiles              |       15:31:07 -> 15:31:07    |       0 min.
YetiForceUpdate::update - 2020-03-17 15:31:07 | 1.53 min
YetiForceUpdate::postupdate             |       15:31:09
YetiForceUpdate::baseModuleTools                |       15:31:09 -> 15:33:43    |       2.58 min.
Fixer::baseModuleTools: 18138
Fixer::baseModuleActions: 1950
Fixer::profileField: 253
YetiForceUpdate::maximumFieldsLength            |       15:34:02
[Warning] Type not allowed: vtiger_products.vqtyqty |uitype: 7 |maximumlength:  |type:bigint|bigint|bigint(15)

[Warning] Type not allowed: vtiger_products.vqtygdn |uitype: 7 |maximumlength:  |type:bigint|bigint|bigint(15)

[Warning] Type not allowed: vtiger_products.vqtygrn |uitype: 7 |maximumlength:  |type:bigint|bigint|bigint(15)

[Warning] Type not allowed: vtiger_products.vqtypre |uitype: 7 |maximumlength:  |type:bigint|bigint|bigint(15)

[Warning] Type not allowed: vtiger_products.vqtyarr |uitype: 7 |maximumlength:  |type:bigint|bigint|bigint(15)
 -> 15:34:03    |       0.01 min.
Fixer::maximumFieldsLength: Array
(
    [NotSupported] => 271
    [TypeNotFound] => 0
    [RequiresVerification] => 0
    [Updated] => 79
)
 -> 15:34:04    |       2.92 min.
-------------   2020-03-17 15:29:35   -------------
> start update tables (base)
  > add column: vtiger_activitytype:icon ... done    (0.2s)
  > add column: vtiger_cron_task:handler_class ... done    (0.2s)
  > create index: handler_class ... done    (0.1s)
  > add column: vtiger_blocks:icon ... done    (0.2s)
  > add column: vtiger_relatedlists:field_name ... done    (0.3s)
  > alter column: vtiger_relatedlists:presence ... done    (0s)
  > create index: ossmailview_date_idx ... done    (0s)
  > add table: u_#__chat_rooms_private ... done    (0.1s)
  > add table: u_#__chat_rooms_user ... done    (0.1s)
  > add table: u_#__chat_user ... done    (0.1s)
  > add table: u_#__chat_messages_private ... done    (0.1s)
  > add table: u_#__chat_messages_user ... done    (0.1s)
  > add table: u_#__chat_private ... done    (0.1s)
  > add table: u_#__chat_rooms ... done    (0.1s)
  > alter column: u_#__emailtemplates:content ... done    (0.2s)
  > alter column: vtiger_entity_stats:crmactivity ... done    (0.2s)
  > alter column: vtiger_osstimecontrol:time_start ... done    (0.2s)
  > alter column: vtiger_osstimecontrol:time_end ... done    (0.2s)
  > alter column: vtiger_osstimecontrol:deleted ... done    (0.2s)
  > alter column: vtiger_projectmilestone:projectmilestonedate ... done    (0.2s)
  > alter column: vtiger_reservations:time_start ... done    (0.2s)
  > alter column: vtiger_reservations:time_end ... done    (0.2s)
  > alter column: vtiger_reservations:deleted ... done    (0.2s)
  > alter column: vtiger_users:no_of_currency_decimals ... done    (0.2s)
  > alter column: com_vtiger_workflows:defaultworkflow ... done    (0.2s)
  > alter column: com_vtiger_workflows:filtersavedinnew ... done    (0.5s)
  > alter column: vtiger_currency:presence ... done    (0.2s)
  > alter column: vtiger_currency_info:deleted ... done    (0.2s)
  > alter column: vtiger_customview:presence ... done    (0.2s)
  > foreign key must be removed and added in postUpdate: vtiger_def_org_share:permission <> vtiger_org_share_action_mapping:share_action_id FK:fk_1_vtiger_def_org_share
  > alter column: vtiger_def_org_share:permission ... done    (0.2s)
  > alter column: vtiger_def_org_share:editstatus ... done    (0.2s)
  > create index: fk_1_def_org_share_tabid ... done    (0.1s)
  > alter column: vtiger_fieldmodulerel:fieldid ... done    (0.2s)
  > alter column: vtiger_import_maps:has_header ... done    (0.1s)
  > alter column: vtiger_import_maps:deleted ... done    (0.1s)
  > add column: vtiger_loginhistory:userid ... done    (1.6s)
  > add column: vtiger_loginhistory:agent ... done    (1.6s)
  > create index: userid ... done    (0.2s)
  > alter column: vtiger_modentity_num:tabid ... done    (0.2s)
  > alter column: vtiger_org_share_action_mapping:share_action_id ... done    (0.1s)
  > foreign key must be removed and added in postUpdate: vtiger_profile:profileid <> vtiger_profile2field:profileid FK:vtiger_profile2field_ibfk_1
  > foreign key must be removed and added in postUpdate: vtiger_profile:profileid <> vtiger_profile2globalpermissions:profileid FK:fk_1_vtiger_profile2globalpermissions
  > foreign key must be removed and added in postUpdate: vtiger_profile:profileid <> vtiger_profile2tab:profileid FK:vtiger_profile2tab_ibfk_1
  > foreign key must be removed and added in postUpdate: vtiger_profile:profileid <> vtiger_profile2utility:profileid FK:vtiger_profile2utility_ibfk_1
  > foreign key must be removed and added in postUpdate: vtiger_profile:profileid <> vtiger_role2profile:profileid FK:vtiger_role2profile_ibfk_2
  > alter column: vtiger_profile:profileid ... done    (0.2s)
  > alter column: vtiger_profile2globalpermissions:profileid ... done    (0.2s)
  > alter column: vtiger_profile2tab:profileid ... done    (0.2s)
  > alter column: vtiger_profile2tab:tabid ... done    (0.2s)
  > alter column: vtiger_profile2tab:permissions ... done    (0.2s)
  > create index: fk_1_profile2tab_tabid ... done    (0.1s)
  > alter column: vtiger_profile2standardpermissions:tabid ... done    (0.3s)
  > create index: fk_1_profile2field_tabid ... done    (0.1s)
  > alter column: vtiger_profile2field:profileid ... done    (1.1s)
  > alter column: vtiger_profile2field:visible ... done    (1.1s)
  > alter column: vtiger_profile2field:readonly ... done    (1.1s)
  > create index: fk_1_profile2field_fieldid ... done    (0.2s)
  > alter column: vtiger_profile2utility:profileid ... done    (1s)
  > alter column: vtiger_profile2utility:activityid ... done    (1s)
  > alter column: vtiger_profile2utility:permission ... done    (1s)
  > create index: fk_1_profile2utility_activityid ... done    (0.2s)
  > alter column: vtiger_relatedlists_fields:fieldid ... done    (0.2s)
  > create index: fk_1_relatedlists_fields_fieldid ... done    (0.1s)
  > alter column: vtiger_role2profile:profileid ... done    (0.2s)
  > alter column: vtiger_rss:starred ... done    (0.1s)
  > alter column: vtiger_trees_templates:access ... done    (0.2s)
  > alter column: vtiger_users_last_import:deleted ... done    (0.1s)
  > alter column: yetiforce_currencyupdate_banks:active ... done    (0.2s)
  > add table: u_#__relations_members_entity ... done    (0.1s)
  > create index: u_yf_relations_members_entity_crmid_idx ... done    (0s)
  > create index: u_yf_relations_members_entity_relcrmid_idx ... done    (0.1s)
  > add table: vtiger_status_rel ... done    (0.1s)
  > alter column: u_#__openstreetmap:crmid ... done    (0.2s)
  > alter column: u_#__openstreetmap:lat ... done    (0.2s)
  > alter column: u_#__openstreetmap:lon ... done    (0.2s)
  > alter column: u_#__openstreetmap_address_updater:crmid ... done    (0.1s)
# end update tables    (0.34s)
> start update tables (admin)
  > alter column: s_#__companies:companysize ... done    (0.1s)
  > alter column: s_#__mail_queue:content ... done    (0.2s)
  > alter column: a_#__pdf:header_content ... done    (0.2s)
  > alter column: a_#__pdf:body_content ... done    (0.2s)
  > alter column: a_#__pdf:footer_content ... done    (0.2s)
# end update tables    (0.02s)
> start update tables (webservice)
  > add table: w_#__manage_consents_user ... done    (0.1s)
  > create index: user_uq ... done    (0s)
  > alter column: w_#__portal_session:id ... done    (0.1s)
  > alter column: w_#__portal_session:user_id ... done    (0.1s)
  > alter column: w_#__portal_session:created ... done    (0s)
  > alter column: w_#__portal_session:changed ... done    (0s)
  > create index: user_id ... done    (0s)
  > alter column: w_#__portal_user:id ... done    (0.2s)
  > alter column: w_#__portal_user:server_id ... done    (0.2s)
  > alter column: w_#__portal_user:status ... done    (0.2s)
  > alter column: w_#__portal_user:type ... done    (0.2s)
  > alter column: w_#__portal_user:login_time ... done    (0s)
  > alter column: w_#__portal_user:logout_time ... done    (0s)
  > create index: server_id ... done    (0s)
  > alter column: w_#__servers:id ... done    (0.1s)
# end update tables    (0.02s)
> start update tables (log)
  > alter column: l_#__switch_users:agent ... done    (0s)
  > alter column: o_#__access_for_admin:agent ... done    (0s)
  > alter column: o_#__access_for_api:agent ... done    (0s)
  > alter column: o_#__access_for_user:agent ... done    (0s)
  > alter column: o_#__access_to_record:agent ... done    (0s)
  > alter column: o_#__csrf:agent ... done    (0s)
# end update tables    (0s)
> start update foreign key (base)
  > add: fk_vtiger_campaigncampaignid, vtiger_campaign ... done    (0s)
  > add: fk_1_def_org_share_tabid, vtiger_def_org_share ... done    (0s)
  > add: vtiger_fieldmodulerel_ibfk_1, vtiger_fieldmodulerel ... done    (0s)
  > add: fk_1_modentity_num_tabid, vtiger_modentity_num ... done    (0s)
  > add: fk_1_profile2field_fieldid, vtiger_profile2field ... done    (0s)
  > add: fk_2_profile2field_tabid, vtiger_profile2field ... done    (0s)
  > add: fk_1_profile2stand_profileid, vtiger_profile2standardpermissions ... done    (0s)
  > add: fk_1_profile2stand_tabid, vtiger_profile2standardpermissions ... done    (0s)
  > add: fk_1_profile2tab_tabid, vtiger_profile2tab ... done    (0s)
  > add: fk_1_profile2utility_activityid, vtiger_profile2utility ... done    (0s)
  > add: fk_1_profile2utility_tabid, vtiger_profile2utility ... done    (0s)
  > add: fk_1_relatedlists_fields_fieldid, vtiger_relatedlists_fields ... done    (0s)
  > add: u_yf_openstreetmap_ibfk_1, u_yf_openstreetmap ... done    (0s)
  > add: u_yf_openstreetmap_record_updater_ibfk_1, u_yf_openstreetmap_record_updater ... done    (0s)
  > add: u_yf_relations_members_entity_crmid_fk, u_yf_relations_members_entity ... done    (0s)
  > add: u_yf_relations_members_entity_relcrmid_fk, u_yf_relations_members_entity ... done    (0s)
  > add: vtiger_crmentityrel_crmid_fk, vtiger_crmentityrel ... done    (0s)
  > add: vtiger_crmentityrel_relcrmid_fk, vtiger_crmentityrel ... done    (0s)
  > add: fk_1_vtiger_def_org_share, vtiger_def_org_share ... done    (0s)
  > add: vtiger_profile2field_ibfk_1, vtiger_profile2field ... done    (0s)
  > add: fk_1_vtiger_profile2globalpermissions, vtiger_profile2globalpermissions ... done    (0s)
  > add: vtiger_profile2tab_ibfk_1, vtiger_profile2tab ... done    (0s)
  > add: vtiger_profile2utility_ibfk_1, vtiger_profile2utility ... done    (0s)
  > add: vtiger_role2profile_ibfk_2, vtiger_role2profile ... done    (0s)
# end update foreign key    (0.01s)
> start update foreign key (webservice)
  > add: w_yf_manage_consents_user_fk1, w_yf_manage_consents_user ... done    (0s)
  > add: w_yf_portal_session_ibfk_1, w_yf_portal_session ... done    (0s)
  > add: w_yf_portal_user_ibfk_1, w_yf_portal_user ... done    (0s)
# end update foreign key    (0s)
> start drop columns
  > drop column: vtiger_cron_task:handler_file ... done    (0.2s)
  > drop column: vtiger_leaddetails:assignleadchk ... done    (0.1s)
  > drop column: vtiger_leadsubdetails:callornot ... done    (0.1s)
  > drop column: vtiger_leadsubdetails:readornot ... done    (0.2s)
  > drop column: vtiger_leadsubdetails:empct ... done    (0.2s)
  > drop column: w_#__portal_user:password_h ... done    (0.1s)
# end drop columns (0.02 min)
> start drop indexes
  > drop index, vtiger_relatedlists:tabid ... done    (0.2s)
  > drop index, vtiger_relatedlists:tabid_2 ... done    (0s)
  > drop index, vtiger_campaign:campaign_campaignid_idx ... done    (0s)
# end drop indexes (0 min)
> start update foreign key (base)
# end update foreign key    (0s)
> start update foreign key (webservice)
# end update foreign key    (0s)
> start drop tables
  > drop table, vtiger_durationhrs ... done    (0s)
  > drop table, vtiger_durationmins ... done    (0s)
  > drop table, vtiger_leadstage ... done    (0s)
  > drop table, vtiger_mail_accounts ... done    (0s)
  > drop table, vtiger_opportunitystage ... done    (0s)
  > drop table, vtiger_priority ... done    (0s)
# end drop tables (0 min)
-------------  2020-03-17 15:31:07 (1.52 min)   -------------
vovpff commented 4 years ago

@mariuszkrzaczkowski 

Fixer::maximumFieldsLength: Array
(
    [NotSupported] => 271
    [TypeNotFound] => 0
    [RequiresVerification] => 0
    [Updated] => 79
)

What does it mean? This is selfmade tables what not used inside system. Just for collect some data. Is it ok?

mariuszkrzaczkowski commented 4 years ago

@mariuszkrzaczkowski

Fixer::maximumFieldsLength: Array
(
    [NotSupported] => 271
    [TypeNotFound] => 0
    [RequiresVerification] => 0
    [Updated] => 79
)

What does it mean? This is selfmade tables what not used inside system. Just for collect some data. Is it ok?

is ok

mariuszkrzaczkowski commented 4 years ago

did you correct the server configuration? show logs CRM, PHP, Apache

vovpff commented 4 years ago

@mariuszkrzaczkowski Apache error logs contains only

[Tue Mar 17 16:08:29.921178 2020] [fcgid:warn] [pid 10015] [client 192.168.1.1:61790] mod_fcgid: stderr: PHP Warning:  Zend OPcache can't be temporary enabled (it may be only disabled till the end of request) in Unknown on line 0

If you mean for CRM logs this option $LOG_TO_FILE = true; This log don't contain any errors. What part of this log you need?

vovpff commented 4 years ago

Config not fully corrected. php.ini for cli temporary wrong. ConfReport_1

mariuszkrzaczkowski commented 4 years ago

Set error_log in php.ini

vovpff commented 4 years ago 
[17-Mar-2020 16:30:07 Europe/Moscow] PHP Warning:  Zend OPcache can't be temporary enabled (it may be only disabled till the end of request) in Unknown on line 0
[17-Mar-2020 16:30:12 Europe/Moscow] PHP Warning:  Zend OPcache can't be temporary enabled (it may be only disabled till the end of request) in Unknown on line 0
[17-Mar-2020 16:30:17 Europe/Moscow] PHP Warning:  Zend OPcache can't be temporary enabled (it may be only disabled till the end of request) in Unknown on line 0
[17-Mar-2020 16:30:22 Europe/Moscow] PHP Warning:  Zend OPcache can't be temporary enabled (it may be only disabled till the end of request) in Unknown on line 0
mariuszkrzaczkowski commented 4 years ago

delete the .user.ini file

vovpff commented 4 years ago

@mariuszkrzaczkowski 

[17-Mar-2020 16:52:22 Europe/Moscow] PHP Notice:  Undefined variable: typeDb in /home/etwhdd/etwh/app/Db.php on line 174
[17-Mar-2020 16:52:22 Europe/Moscow] PHP Notice:  Undefined index:  in /home/etwhdd/etwh/app/Utils/ConfReport.php on line 712
vovpff commented 4 years ago

@mariuszkrzaczkowski update ConfReport_200317_2

In php error logs only one error appears periodically and I don't know how to avoid it

[17-Mar-2020 16:30:07 Europe/Moscow] PHP Warning:  Zend OPcache can't be temporary enabled (it may be only disabled till the end of request) in Unknown on line 0
mariuszkrzaczkowski commented 4 years ago

In php error logs only one error appears periodically and I don't know how to avoid it

[17-Mar-2020 16:30:07 Europe/Moscow] PHP Warning:  Zend OPcache can't be temporary enabled (it may be only disabled till the end of request) in Unknown on line 0

remove the lines 

opcache.enable = "On"
opcache.enable_cli = "On"

from the .user.ini and public_html/.user.ini files

here is the current file https://github.com/YetiForceCompany/YetiForceCRM/blob/5.3.0/.user.ini

vovpff commented 4 years ago

@mariuszkrzaczkowski if lines removed configuration became faulty

image

mariuszkrzaczkowski commented 4 years ago

this must be set in the main php.ini files