DoNotContact not showing in interface

Product Support
1

Your software
My Mautic version is: 3.2.4 (multiple instances)
My PHP version is: 7.4.14
My Database type and version is: MariaDB 10.3.27

Your problem
DoNotContact is missing from the Bulk Edit UI. It’s not available within the QuickEdit Contact popup (but should it be?). I have never edited Contacts for DNC in past. DNC table is present in db and empty.

“Add Do Not Contact” is an available option within Campaign Builder. In either instance, no Campaigns have ever been triggered.

I have not reviewed related issues on JIRA/Github so I don’t know if they apply. .

These errors are showing in the log:
[2021-01-20 11:59:10] mautic.WARNING: Commanddoctrine:schema:validateexited with status code 3 [2021-01-20 11:59:18] mautic.WARNING: Commandcache:clearexited with status code 1

Steps I have tried to fix the problem:

  • Disable plugins
  • cache:clear
  • doctrine:schema:validate
  • doctrine:schema:update --no-interaction --dump-sql --force

doctrine:schema:validate. results…

Mapping
-------

 [FAIL] The entity-class Mautic\DynamicContentBundle\Entity\DynamicContentLeadData mapping is invalid:
 * The association Mautic\DynamicContentBundle\Entity\DynamicContentLeadData#dynamicContent refers to the inverse side field Mautic\DynamicContentBundle\Entity\DynamicContent#id which is not defined as association.
 * The association Mautic\DynamicContentBundle\Entity\DynamicContentLeadData#dynamicContent refers to the inverse side field Mautic\DynamicContentBundle\Entity\DynamicContent#id which does not exist.


 [FAIL] The entity-class Bazinga\OAuthServerBundle\Model\AccessToken mapping is invalid:
 * The field 'Bazinga\OAuthServerBundle\Model\AccessToken#expiresAt' uses a non-existent type 'int'.


 [FAIL] The entity-class Bazinga\OAuthServerBundle\Model\RequestToken mapping is invalid:
 * The field 'Bazinga\OAuthServerBundle\Model\RequestToken#expiresAt' uses a non-existent type 'int'.


Database
--------

 [ERROR] The database schema is not in sync with the current mapping file.

`

2

1 of 2…
doctrine:schema:update --no-interaction --dump-sql --force results …

ALTER TABLE z5a82_oauth2_accesstokens CHANGE expires_at expires_at BIGINT DEFAULT NULL, CHANGE scope scope VARCHAR(191) DEFAULT NULL;

ALTER TABLE z5a82_oauth2_refreshtokens CHANGE expires_at expires_at BIGINT DEFAULT NULL, CHANGE scope scope VARCHAR(191) DEFAULT NULL;

ALTER TABLE z5a82_oauth1_access_tokens CHANGE expires_at expires_at BIGINT DEFAULT NULL;

ALTER TABLE z5a82_oauth1_request_tokens CHANGE user_id user_id INT UNSIGNED DEFAULT NULL;

ALTER TABLE z5a82_oauth2_authcodes CHANGE expires_at expires_at BIGINT DEFAULT NULL, CHANGE scope scope VARCHAR(191) DEFAULT NULL;

ALTER TABLE z5a82_assets CHANGE category_id category_id INT UNSIGNED DEFAULT NULL, CHANGE date_added date_added DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE created_by created_by INT DEFAULT NULL, CHANGE created_by_user created_by_user VARCHAR(191) DEFAULT NULL, CHANGE date_modified date_modified DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE modified_by modified_by INT DEFAULT NULL, CHANGE modified_by_user modified_by_user VARCHAR(191) DEFAULT NULL, CHANGE checked_out checked_out DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE checked_out_by checked_out_by INT DEFAULT NULL, CHANGE checked_out_by_user checked_out_by_user VARCHAR(191) DEFAULT NULL, CHANGE storage_location storage_location VARCHAR(191) DEFAULT NULL, CHANGE path path VARCHAR(191) DEFAULT NULL, CHANGE remote_path remote_path VARCHAR(191) DEFAULT NULL, CHANGE original_file_name original_file_name VARCHAR(191) DEFAULT NULL, CHANGE publish_up publish_up DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE publish_down publish_down DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE extension extension VARCHAR(191) DEFAULT NULL, CHANGE mime mime VARCHAR(191) DEFAULT NULL, CHANGE size size INT DEFAULT NULL, CHANGE disallow disallow TINYINT(1) DEFAULT NULL;

ALTER TABLE z5a82_asset_downloads CHANGE asset_id asset_id INT UNSIGNED DEFAULT NULL, CHANGE lead_id lead_id BIGINT UNSIGNED DEFAULT NULL, CHANGE email_id email_id INT UNSIGNED DEFAULT NULL, CHANGE source source VARCHAR(191) DEFAULT NULL, CHANGE source_id source_id INT DEFAULT NULL;

ALTER TABLE z5a82_campaigns CHANGE category_id category_id INT UNSIGNED DEFAULT NULL, CHANGE date_added date_added DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE created_by created_by INT DEFAULT NULL, CHANGE created_by_user created_by_user VARCHAR(191) DEFAULT NULL, CHANGE date_modified date_modified DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE modified_by modified_by INT DEFAULT NULL, CHANGE modified_by_user modified_by_user VARCHAR(191) DEFAULT NULL, CHANGE checked_out checked_out DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE checked_out_by checked_out_by INT DEFAULT NULL, CHANGE checked_out_by_user checked_out_by_user VARCHAR(191) DEFAULT NULL, CHANGE publish_up publish_up DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE publish_down publish_down DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE canvas_settings canvas_settings LONGTEXT DEFAULT NULL COMMENT '(DC2Type:array)';

ALTER TABLE z5a82_campaign_events CHANGE parent_id parent_id INT UNSIGNED DEFAULT NULL, CHANGE trigger_date trigger_date DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE trigger_interval trigger_interval INT DEFAULT NULL, CHANGE trigger_interval_unit trigger_interval_unit VARCHAR(1) DEFAULT NULL, CHANGE trigger_hour trigger_hour TIME DEFAULT NULL, CHANGE trigger_restricted_start_hour trigger_restricted_start_hour TIME DEFAULT NULL, CHANGE trigger_restricted_stop_hour trigger_restricted_stop_hour TIME DEFAULT NULL, CHANGE trigger_restricted_dow trigger_restricted_dow LONGTEXT DEFAULT NULL COMMENT '(DC2Type:array)', CHANGE trigger_mode trigger_mode VARCHAR(10) DEFAULT NULL, CHANGE decision_path decision_path VARCHAR(191) DEFAULT NULL, CHANGE temp_id temp_id VARCHAR(191) DEFAULT NULL, CHANGE channel channel VARCHAR(191) DEFAULT NULL, CHANGE channel_id channel_id INT DEFAULT NULL;

ALTER TABLE z5a82_campaign_leads CHANGE date_last_exited date_last_exited DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)';

ALTER TABLE z5a82_campaign_lead_event_log CHANGE campaign_id campaign_id INT UNSIGNED DEFAULT NULL, CHANGE ip_id ip_id INT UNSIGNED DEFAULT NULL, CHANGE date_triggered date_triggered DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE trigger_date trigger_date DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE metadata metadata LONGTEXT DEFAULT NULL COMMENT '(DC2Type:array)', CHANGE channel channel VARCHAR(191) DEFAULT NULL, CHANGE channel_id channel_id INT DEFAULT NULL, CHANGE non_action_path_taken non_action_path_taken TINYINT(1) DEFAULT NULL;

ALTER TABLE z5a82_categories CHANGE date_added date_added DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE created_by created_by INT DEFAULT NULL, CHANGE created_by_user created_by_user VARCHAR(191) DEFAULT NULL, CHANGE date_modified date_modified DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE modified_by modified_by INT DEFAULT NULL, CHANGE modified_by_user modified_by_user VARCHAR(191) DEFAULT NULL, CHANGE checked_out checked_out DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE checked_out_by checked_out_by INT DEFAULT NULL, CHANGE checked_out_by_user checked_out_by_user VARCHAR(191) DEFAULT NULL, CHANGE color color VARCHAR(7) DEFAULT NULL;

ALTER TABLE z5a82_message_channels CHANGE channel_id channel_id INT DEFAULT NULL;

ALTER TABLE z5a82_messages CHANGE category_id category_id INT UNSIGNED DEFAULT NULL, CHANGE date_added date_added DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE created_by created_by INT DEFAULT NULL, CHANGE created_by_user created_by_user VARCHAR(191) DEFAULT NULL, CHANGE date_modified date_modified DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE modified_by modified_by INT DEFAULT NULL, CHANGE modified_by_user modified_by_user VARCHAR(191) DEFAULT NULL, CHANGE checked_out checked_out DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE checked_out_by checked_out_by INT DEFAULT NULL, CHANGE checked_out_by_user checked_out_by_user VARCHAR(191) DEFAULT NULL, CHANGE publish_up publish_up DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE publish_down publish_down DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)';

ALTER TABLE z5a82_message_queue CHANGE event_id event_id INT UNSIGNED DEFAULT NULL, CHANGE date_published date_published DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE scheduled_date scheduled_date DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE last_attempt last_attempt DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE date_sent date_sent DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE options options LONGTEXT DEFAULT NULL COMMENT '(DC2Type:array)';

ALTER TABLE z5a82_ip_addresses CHANGE ip_details ip_details LONGTEXT DEFAULT NULL COMMENT '(DC2Type:array)';

ALTER TABLE z5a82_audit_log CHANGE details details LONGTEXT DEFAULT NULL COMMENT '(DC2Type:array)';

ALTER TABLE z5a82_cache_items CHANGE item_lifetime item_lifetime INT UNSIGNED DEFAULT NULL;

ALTER TABLE z5a82_notifications CHANGE type type VARCHAR(25) DEFAULT NULL, CHANGE header header VARCHAR(191) DEFAULT NULL, CHANGE icon_class icon_class VARCHAR(191) DEFAULT NULL;

ALTER TABLE z5a82_widgets CHANGE date_added date_added DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE created_by created_by INT DEFAULT NULL, CHANGE created_by_user created_by_user VARCHAR(191) DEFAULT NULL, CHANGE date_modified date_modified DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE modified_by modified_by INT DEFAULT NULL, CHANGE modified_by_user modified_by_user VARCHAR(191) DEFAULT NULL, CHANGE checked_out checked_out DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE checked_out_by checked_out_by INT DEFAULT NULL, CHANGE checked_out_by_user checked_out_by_user VARCHAR(191) DEFAULT NULL, CHANGE cache_timeout cache_timeout INT DEFAULT NULL, CHANGE ordering ordering INT DEFAULT NULL, CHANGE params params LONGTEXT DEFAULT NULL COMMENT '(DC2Type:array)';

ALTER TABLE z5a82_dynamic_content CHANGE category_id category_id INT UNSIGNED DEFAULT NULL, CHANGE translation_parent_id translation_parent_id INT UNSIGNED DEFAULT NULL, CHANGE variant_parent_id variant_parent_id INT UNSIGNED DEFAULT NULL, CHANGE date_added date_added DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE created_by created_by INT DEFAULT NULL, CHANGE created_by_user created_by_user VARCHAR(191) DEFAULT NULL, CHANGE date_modified date_modified DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE modified_by modified_by INT DEFAULT NULL, CHANGE modified_by_user modified_by_user VARCHAR(191) DEFAULT NULL, CHANGE checked_out checked_out DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE checked_out_by checked_out_by INT DEFAULT NULL, CHANGE checked_out_by_user checked_out_by_user VARCHAR(191) DEFAULT NULL, CHANGE publish_up publish_up DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE publish_down publish_down DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE utm_tags utm_tags JSON DEFAULT NULL COMMENT '(DC2Type:json_array)', CHANGE variant_settings variant_settings LONGTEXT DEFAULT NULL COMMENT '(DC2Type:array)', CHANGE variant_start_date variant_start_date DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE filters filters LONGTEXT DEFAULT NULL COMMENT '(DC2Type:array)', CHANGE slot_name slot_name VARCHAR(191) DEFAULT NULL;

ALTER TABLE z5a82_dynamic_content_lead_data CHANGE dynamic_content_id dynamic_content_id INT UNSIGNED DEFAULT NULL, CHANGE date_added date_added DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)';

ALTER TABLE z5a82_dynamic_content_stats CHANGE dynamic_content_id dynamic_content_id INT UNSIGNED DEFAULT NULL, CHANGE lead_id lead_id BIGINT UNSIGNED DEFAULT NULL, CHANGE source source VARCHAR(191) DEFAULT NULL, CHANGE source_id source_id INT DEFAULT NULL, CHANGE tokens tokens LONGTEXT DEFAULT NULL COMMENT '(DC2Type:array)', CHANGE sent_count sent_count INT DEFAULT NULL, CHANGE last_sent last_sent DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE sent_details sent_details LONGTEXT DEFAULT NULL COMMENT '(DC2Type:array)';

ALTER TABLE z5a82_email_stats CHANGE email_id email_id INT UNSIGNED DEFAULT NULL, CHANGE lead_id lead_id BIGINT UNSIGNED DEFAULT NULL, CHANGE list_id list_id INT UNSIGNED DEFAULT NULL, CHANGE ip_id ip_id INT UNSIGNED DEFAULT NULL, CHANGE copy_id copy_id VARCHAR(32) DEFAULT NULL, CHANGE date_read date_read DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE tracking_hash tracking_hash VARCHAR(191) DEFAULT NULL, CHANGE retry_count retry_count INT DEFAULT NULL, CHANGE source source VARCHAR(191) DEFAULT NULL, CHANGE source_id source_id INT DEFAULT NULL, CHANGE tokens tokens LONGTEXT DEFAULT NULL COMMENT '(DC2Type:array)', CHANGE open_count open_count INT DEFAULT NULL, CHANGE last_opened last_opened DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE open_details open_details LONGTEXT DEFAULT NULL COMMENT '(DC2Type:array)', CHANGE generated_sent_date generated_sent_date DATE AS (CONCAT(YEAR(date_sent), "-", LPAD(MONTH(date_sent), 2, "0"), "-", LPAD(DAY(date_sent), 2, "0"))) COMMENT '(DC2Type:generated)';

ALTER TABLE z5a82_emails CHANGE category_id category_id INT UNSIGNED DEFAULT NULL, CHANGE translation_parent_id translation_parent_id INT UNSIGNED DEFAULT NULL, CHANGE variant_parent_id variant_parent_id INT UNSIGNED DEFAULT NULL, CHANGE unsubscribeform_id unsubscribeform_id INT UNSIGNED DEFAULT NULL, CHANGE preference_center_id preference_center_id INT UNSIGNED DEFAULT NULL, CHANGE date_added date_added DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE created_by created_by INT DEFAULT NULL, CHANGE created_by_user created_by_user VARCHAR(191) DEFAULT NULL, CHANGE date_modified date_modified DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE modified_by modified_by INT DEFAULT NULL, CHANGE modified_by_user modified_by_user VARCHAR(191) DEFAULT NULL, CHANGE checked_out checked_out DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE checked_out_by checked_out_by INT DEFAULT NULL, CHANGE checked_out_by_user checked_out_by_user VARCHAR(191) DEFAULT NULL, CHANGE from_address from_address VARCHAR(191) DEFAULT NULL, CHANGE from_name from_name VARCHAR(191) DEFAULT NULL, CHANGE reply_to_address reply_to_address VARCHAR(191) DEFAULT NULL, CHANGE bcc_address bcc_address VARCHAR(191) DEFAULT NULL, CHANGE template template VARCHAR(191) DEFAULT NULL, CHANGE content content LONGTEXT DEFAULT NULL COMMENT '(DC2Type:array)', CHANGE utm_tags utm_tags LONGTEXT DEFAULT NULL COMMENT '(DC2Type:array)', CHANGE publish_up publish_up DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE publish_down publish_down DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE variant_settings variant_settings LONGTEXT DEFAULT NULL COMMENT '(DC2Type:array)', CHANGE variant_start_date variant_start_date DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE dynamic_content dynamic_content LONGTEXT DEFAULT NULL COMMENT '(DC2Type:array)', CHANGE public_preview public_preview TINYINT(1) DEFAULT NULL;

ALTER TABLE z5a82_email_stats_devices CHANGE device_id device_id BIGINT UNSIGNED DEFAULT NULL, CHANGE stat_id stat_id BIGINT UNSIGNED DEFAULT NULL, CHANGE ip_id ip_id INT UNSIGNED DEFAULT NULL;

ALTER TABLE z5a82_forms CHANGE category_id category_id INT UNSIGNED DEFAULT NULL, CHANGE date_added date_added DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE created_by created_by INT DEFAULT NULL, CHANGE created_by_user created_by_user VARCHAR(191) DEFAULT NULL, CHANGE date_modified date_modified DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE modified_by modified_by INT DEFAULT NULL, CHANGE modified_by_user modified_by_user VARCHAR(191) DEFAULT NULL, CHANGE checked_out checked_out DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE checked_out_by checked_out_by INT DEFAULT NULL, CHANGE checked_out_by_user checked_out_by_user VARCHAR(191) DEFAULT NULL, CHANGE form_attr form_attr VARCHAR(191) DEFAULT NULL, CHANGE post_action_property post_action_property VARCHAR(191) DEFAULT NULL, CHANGE publish_up publish_up DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE publish_down publish_down DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE template template VARCHAR(191) DEFAULT NULL, CHANGE in_kiosk_mode in_kiosk_mode TINYINT(1) DEFAULT NULL, CHANGE render_style render_style TINYINT(1) DEFAULT NULL, CHANGE form_type form_type VARCHAR(191) DEFAULT NULL, CHANGE no_index no_index TINYINT(1) DEFAULT NULL;

ALTER TABLE z5a82_form_fields CHANGE show_label show_label TINYINT(1) DEFAULT NULL, CHANGE custom_parameters custom_parameters LONGTEXT DEFAULT NULL COMMENT '(DC2Type:array)', CHANGE field_order field_order INT DEFAULT NULL, CHANGE properties properties LONGTEXT DEFAULT NULL COMMENT '(DC2Type:array)', CHANGE validation validation JSON DEFAULT NULL COMMENT '(DC2Type:json_array)', CHANGE label_attr label_attr VARCHAR(191) DEFAULT NULL, CHANGE input_attr input_attr VARCHAR(191) DEFAULT NULL, CHANGE container_attr container_attr VARCHAR(191) DEFAULT NULL, CHANGE lead_field lead_field VARCHAR(191) DEFAULT NULL, CHANGE save_result save_result TINYINT(1) DEFAULT NULL, CHANGE is_auto_fill is_auto_fill TINYINT(1) DEFAULT NULL, CHANGE show_when_value_exists show_when_value_exists TINYINT(1) DEFAULT NULL, CHANGE show_after_x_submissions show_after_x_submissions INT DEFAULT NULL;

ALTER TABLE z5a82_form_submissions CHANGE lead_id lead_id BIGINT UNSIGNED DEFAULT NULL, CHANGE page_id page_id INT UNSIGNED DEFAULT NULL, CHANGE tracking_id tracking_id VARCHAR(191) DEFAULT NULL;

ALTER TABLE z5a82_sync_object_mapping CHANGE integration_reference_id integration_reference_id VARCHAR(191) DEFAULT NULL;

ALTER TABLE z5a82_lead_lists CHANGE date_added date_added DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE created_by created_by INT DEFAULT NULL, CHANGE created_by_user created_by_user VARCHAR(191) DEFAULT NULL, CHANGE date_modified date_modified DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE modified_by modified_by INT DEFAULT NULL, CHANGE modified_by_user modified_by_user VARCHAR(191) DEFAULT NULL, CHANGE checked_out checked_out DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE checked_out_by checked_out_by INT DEFAULT NULL, CHANGE checked_out_by_user checked_out_by_user VARCHAR(191) DEFAULT NULL;

ALTER TABLE z5a82_leads CHANGE owner_id owner_id INT UNSIGNED DEFAULT NULL, CHANGE stage_id stage_id INT UNSIGNED DEFAULT NULL, CHANGE date_added date_added DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE created_by created_by INT DEFAULT NULL, CHANGE created_by_user created_by_user VARCHAR(191) DEFAULT NULL, CHANGE date_modified date_modified DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE modified_by modified_by INT DEFAULT NULL, CHANGE modified_by_user modified_by_user VARCHAR(191) DEFAULT NULL, CHANGE checked_out checked_out DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE checked_out_by checked_out_by INT DEFAULT NULL, CHANGE checked_out_by_user checked_out_by_user VARCHAR(191) DEFAULT NULL, CHANGE last_active last_active DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE internal internal LONGTEXT DEFAULT NULL COMMENT '(DC2Type:array)', CHANGE social_cache social_cache LONGTEXT DEFAULT NULL COMMENT '(DC2Type:array)', CHANGE date_identified date_identified DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE preferred_profile_image preferred_profile_image VARCHAR(191) DEFAULT NULL, CHANGE title title VARCHAR(191) DEFAULT NULL, CHANGE firstname firstname VARCHAR(191) DEFAULT NULL, CHANGE lastname lastname VARCHAR(191) DEFAULT NULL, CHANGE company company VARCHAR(191) DEFAULT NULL, CHANGE position position VARCHAR(191) DEFAULT NULL, CHANGE email email VARCHAR(191) DEFAULT NULL, CHANGE phone phone VARCHAR(191) DEFAULT NULL, CHANGE mobile mobile VARCHAR(191) DEFAULT NULL, CHANGE address1 address1 VARCHAR(191) DEFAULT NULL, CHANGE address2 address2 VARCHAR(191) DEFAULT NULL, CHANGE city city VARCHAR(191) DEFAULT NULL, CHANGE state state VARCHAR(191) DEFAULT NULL, CHANGE zipcode zipcode VARCHAR(191) DEFAULT NULL, CHANGE timezone timezone VARCHAR(191) DEFAULT NULL, CHANGE country country VARCHAR(191) DEFAULT NULL, CHANGE fax fax VARCHAR(255) DEFAULT NULL, CHANGE preferred_locale preferred_locale VARCHAR(255) DEFAULT NULL, CHANGE attribution_date attribution_date DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE attribution attribution DOUBLE PRECISION DEFAULT NULL, CHANGE facebook facebook VARCHAR(255) DEFAULT NULL, CHANGE foursquare foursquare VARCHAR(255) DEFAULT NULL, CHANGE instagram instagram VARCHAR(255) DEFAULT NULL, CHANGE linkedin linkedin VARCHAR(255) DEFAULT NULL, CHANGE skype skype VARCHAR(255) DEFAULT NULL, CHANGE twitter twitter VARCHAR(255) DEFAULT NULL, CHANGE mwb_last_order_stat mwb_last_order_stat VARCHAR(255) DEFAULT NULL, CHANGE mwb_last_order_ff_stat mwb_last_order_ff_stat VARCHAR(255) DEFAULT NULL, CHANGE mwb_last_order_track_num mwb_last_order_track_num DOUBLE PRECISION DEFAULT NULL, CHANGE mwb_last_order_track_url mwb_last_order_track_url VARCHAR(255) DEFAULT NULL, CHANGE mwb_last_order_ship_date mwb_last_order_ship_date DATE DEFAULT NULL, CHANGE mwb_last_order_num mwb_last_order_num DOUBLE PRECISION DEFAULT NULL, CHANGE mwb_last_pay_method mwb_last_pay_method VARCHAR(255) DEFAULT NULL, CHANGE mwb_current_orders mwb_current_orders DOUBLE PRECISION DEFAULT NULL, CHANGE mwb_total_val_of_orders mwb_total_val_of_orders DOUBLE PRECISION DEFAULT NULL, CHANGE mwb_avg_order_value mwb_avg_order_value DOUBLE PRECISION DEFAULT NULL, CHANGE mwb_total_orders mwb_total_orders DOUBLE PRECISION DEFAULT NULL, CHANGE mwb_first_order_val mwb_first_order_val DOUBLE PRECISION DEFAULT NULL, CHANGE mwb_first_order_date mwb_first_order_date DATE DEFAULT NULL, CHANGE mwb_last_order_val mwb_last_order_val DOUBLE PRECISION DEFAULT NULL, CHANGE mwb_last_order_date mwb_last_order_date DATE DEFAULT NULL, CHANGE mwb_acc_creation_date mwb_acc_creation_date DATE DEFAULT NULL, CHANGE mwb_order_monetary mwb_order_monetary VARCHAR(255) DEFAULT NULL, CHANGE mwb_order_frequency mwb_order_frequency VARCHAR(255) DEFAULT NULL, CHANGE mwb_order_recency mwb_order_recency VARCHAR(255) DEFAULT NULL, CHANGE recycle_timeframe recycle_timeframe DOUBLE PRECISION DEFAULT NULL, CHANGE recycled_reason recycled_reason VARCHAR(255) DEFAULT NULL, CHANGE self_identify_broad_perso self_identify_broad_perso VARCHAR(255) DEFAULT NULL, CHANGE optinconfirmed optinconfirmed TINYINT(1) DEFAULT NULL, CHANGE optingdprconfimed optingdprconfimed TINYINT(1) DEFAULT NULL;

ALTER TABLE z5a82_lead_donotcontact CHANGE lead_id lead_id BIGINT UNSIGNED DEFAULT NULL, CHANGE channel_id channel_id INT DEFAULT NULL;

ALTER TABLE z5a82_lead_event_log CHANGE lead_id lead_id BIGINT UNSIGNED DEFAULT NULL, CHANGE user_id user_id INT DEFAULT NULL, CHANGE user_name user_name VARCHAR(191) DEFAULT NULL, CHANGE bundle bundle VARCHAR(191) DEFAULT NULL, CHANGE object object VARCHAR(191) DEFAULT NULL, CHANGE action action VARCHAR(191) DEFAULT NULL, CHANGE object_id object_id INT DEFAULT NULL, CHANGE properties properties JSON DEFAULT NULL COMMENT '(DC2Type:json_array)';

ALTER TABLE z5a82_lead_notes CHANGE date_added date_added DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE created_by created_by INT DEFAULT NULL, CHANGE created_by_user created_by_user VARCHAR(191) DEFAULT NULL, CHANGE date_modified date_modified DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE modified_by modified_by INT DEFAULT NULL, CHANGE modified_by_user modified_by_user VARCHAR(191) DEFAULT NULL, CHANGE checked_out checked_out DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE checked_out_by checked_out_by INT DEFAULT NULL, CHANGE checked_out_by_user checked_out_by_user VARCHAR(191) DEFAULT NULL, CHANGE type type VARCHAR(50) DEFAULT NULL, CHANGE date_time date_time DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)';

ALTER TABLE z5a82_lead_stages_change_log CHANGE stage_id stage_id INT UNSIGNED DEFAULT NULL;

ALTER TABLE z5a82_lead_utmtags CHANGE query query LONGTEXT DEFAULT NULL COMMENT '(DC2Type:array)', CHANGE remote_host remote_host VARCHAR(191) DEFAULT NULL, CHANGE utm_campaign utm_campaign VARCHAR(191) DEFAULT NULL, CHANGE utm_content utm_content VARCHAR(191) DEFAULT NULL, CHANGE utm_medium utm_medium VARCHAR(191) DEFAULT NULL, CHANGE utm_source utm_source VARCHAR(191) DEFAULT NULL, CHANGE utm_term utm_term VARCHAR(191) DEFAULT NULL;

ALTER TABLE z5a82_lead_frequencyrules CHANGE frequency_number frequency_number SMALLINT DEFAULT NULL, CHANGE frequency_time frequency_time VARCHAR(25) DEFAULT NULL, CHANGE pause_from_date pause_from_date DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE pause_to_date pause_to_date DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)';

ALTER TABLE z5a82_lead_devices CHANGE client_info client_info LONGTEXT DEFAULT NULL COMMENT '(DC2Type:array)', CHANGE device device VARCHAR(191) DEFAULT NULL, CHANGE device_os_name device_os_name VARCHAR(191) DEFAULT NULL, CHANGE device_os_shortname device_os_shortname VARCHAR(191) DEFAULT NULL, CHANGE device_os_version device_os_version VARCHAR(191) DEFAULT NULL, CHANGE device_os_platform device_os_platform VARCHAR(191) DEFAULT NULL, CHANGE device_brand device_brand VARCHAR(191) DEFAULT NULL, CHANGE device_model device_model VARCHAR(191) DEFAULT NULL, CHANGE tracking_id tracking_id VARCHAR(191) DEFAULT NULL;
3

2 of 2…
doctrine:schema:update --no-interaction --dump-sql --force results …

ALTER TABLE z5a82_companies CHANGE owner_id owner_id INT UNSIGNED DEFAULT NULL, CHANGE date_added date_added DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE created_by created_by INT DEFAULT NULL, CHANGE created_by_user created_by_user VARCHAR(191) DEFAULT NULL, CHANGE date_modified date_modified DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE modified_by modified_by INT DEFAULT NULL, CHANGE modified_by_user modified_by_user VARCHAR(191) DEFAULT NULL, CHANGE checked_out checked_out DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE checked_out_by checked_out_by INT DEFAULT NULL, CHANGE checked_out_by_user checked_out_by_user VARCHAR(191) DEFAULT NULL, CHANGE social_cache social_cache LONGTEXT DEFAULT NULL COMMENT '(DC2Type:array)', CHANGE score score INT DEFAULT NULL, CHANGE companyemail companyemail VARCHAR(191) DEFAULT NULL, CHANGE companyaddress1 companyaddress1 VARCHAR(191) DEFAULT NULL, CHANGE companyaddress2 companyaddress2 VARCHAR(191) DEFAULT NULL, CHANGE companyphone companyphone VARCHAR(191) DEFAULT NULL, CHANGE companycity companycity VARCHAR(191) DEFAULT NULL, CHANGE companystate companystate VARCHAR(191) DEFAULT NULL, CHANGE companyzipcode companyzipcode VARCHAR(191) DEFAULT NULL, CHANGE companycountry companycountry VARCHAR(191) DEFAULT NULL, CHANGE companyname companyname VARCHAR(191) DEFAULT NULL, CHANGE companyindustry companyindustry VARCHAR(191) DEFAULT NULL, CHANGE companynumber_of_employees companynumber_of_employees DOUBLE PRECISION DEFAULT NULL, CHANGE companyfax companyfax VARCHAR(255) DEFAULT NULL, CHANGE companyannual_revenue companyannual_revenue DOUBLE PRECISION DEFAULT NULL;

ALTER TABLE z5a82_companies_leads CHANGE is_primary is_primary TINYINT(1) DEFAULT NULL;

ALTER TABLE z5a82_imports CHANGE date_added date_added DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE created_by created_by INT DEFAULT NULL, CHANGE created_by_user created_by_user VARCHAR(191) DEFAULT NULL, CHANGE date_modified date_modified DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE modified_by modified_by INT DEFAULT NULL, CHANGE modified_by_user modified_by_user VARCHAR(191) DEFAULT NULL, CHANGE checked_out checked_out DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE checked_out_by checked_out_by INT DEFAULT NULL, CHANGE checked_out_by_user checked_out_by_user VARCHAR(191) DEFAULT NULL, CHANGE original_file original_file VARCHAR(191) DEFAULT NULL, CHANGE date_started date_started DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE date_ended date_ended DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE properties properties JSON DEFAULT NULL COMMENT '(DC2Type:json_array)';

ALTER TABLE z5a82_lead_fields CHANGE date_added date_added DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE created_by created_by INT DEFAULT NULL, CHANGE created_by_user created_by_user VARCHAR(191) DEFAULT NULL, CHANGE date_modified date_modified DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE modified_by modified_by INT DEFAULT NULL, CHANGE modified_by_user modified_by_user VARCHAR(191) DEFAULT NULL, CHANGE checked_out checked_out DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE checked_out_by checked_out_by INT DEFAULT NULL, CHANGE checked_out_by_user checked_out_by_user VARCHAR(191) DEFAULT NULL, CHANGE field_group field_group VARCHAR(191) DEFAULT NULL, CHANGE default_value default_value VARCHAR(191) DEFAULT NULL, CHANGE is_unique_identifer is_unique_identifer TINYINT(1) DEFAULT NULL, CHANGE field_order field_order INT DEFAULT NULL, CHANGE object object VARCHAR(191) DEFAULT NULL, CHANGE properties properties LONGTEXT DEFAULT NULL COMMENT '(DC2Type:array)';

ALTER TABLE z5a82_push_ids CHANGE lead_id lead_id BIGINT UNSIGNED DEFAULT NULL;

ALTER TABLE z5a82_push_notifications CHANGE category_id category_id INT UNSIGNED DEFAULT NULL, CHANGE date_added date_added DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE created_by created_by INT DEFAULT NULL, CHANGE created_by_user created_by_user VARCHAR(191) DEFAULT NULL, CHANGE date_modified date_modified DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE modified_by modified_by INT DEFAULT NULL, CHANGE modified_by_user modified_by_user VARCHAR(191) DEFAULT NULL, CHANGE checked_out checked_out DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE checked_out_by checked_out_by INT DEFAULT NULL, CHANGE checked_out_by_user checked_out_by_user VARCHAR(191) DEFAULT NULL, CHANGE utm_tags utm_tags LONGTEXT DEFAULT NULL COMMENT '(DC2Type:array)', CHANGE publish_up publish_up DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE publish_down publish_down DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)';

ALTER TABLE z5a82_push_notification_stats CHANGE notification_id notification_id INT UNSIGNED DEFAULT NULL, CHANGE lead_id lead_id BIGINT UNSIGNED DEFAULT NULL, CHANGE list_id list_id INT UNSIGNED DEFAULT NULL, CHANGE ip_id ip_id INT UNSIGNED DEFAULT NULL, CHANGE date_read date_read DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE date_clicked date_clicked DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE tracking_hash tracking_hash VARCHAR(191) DEFAULT NULL, CHANGE retry_count retry_count INT DEFAULT NULL, CHANGE source source VARCHAR(191) DEFAULT NULL, CHANGE source_id source_id INT DEFAULT NULL, CHANGE tokens tokens LONGTEXT DEFAULT NULL COMMENT '(DC2Type:array)', CHANGE click_count click_count INT DEFAULT NULL, CHANGE last_clicked last_clicked DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE click_details click_details LONGTEXT DEFAULT NULL COMMENT '(DC2Type:array)';

ALTER TABLE z5a82_page_hits CHANGE page_id page_id INT UNSIGNED DEFAULT NULL, CHANGE redirect_id redirect_id BIGINT UNSIGNED DEFAULT NULL, CHANGE email_id email_id INT UNSIGNED DEFAULT NULL, CHANGE lead_id lead_id BIGINT UNSIGNED DEFAULT NULL, CHANGE device_id device_id BIGINT UNSIGNED DEFAULT NULL, CHANGE date_left date_left DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE country country VARCHAR(191) DEFAULT NULL, CHANGE region region VARCHAR(191) DEFAULT NULL, CHANGE city city VARCHAR(191) DEFAULT NULL, CHANGE isp isp VARCHAR(191) DEFAULT NULL, CHANGE organization organization VARCHAR(191) DEFAULT NULL, CHANGE url_title url_title VARCHAR(191) DEFAULT NULL, CHANGE remote_host remote_host VARCHAR(191) DEFAULT NULL, CHANGE page_language page_language VARCHAR(191) DEFAULT NULL, CHANGE browser_languages browser_languages LONGTEXT DEFAULT NULL COMMENT '(DC2Type:array)', CHANGE source source VARCHAR(191) DEFAULT NULL, CHANGE source_id source_id INT DEFAULT NULL, CHANGE query query LONGTEXT DEFAULT NULL COMMENT '(DC2Type:array)';

ALTER TABLE z5a82_pages CHANGE category_id category_id INT UNSIGNED DEFAULT NULL, CHANGE translation_parent_id translation_parent_id INT UNSIGNED DEFAULT NULL, CHANGE variant_parent_id variant_parent_id INT UNSIGNED DEFAULT NULL, CHANGE date_added date_added DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE created_by created_by INT DEFAULT NULL, CHANGE created_by_user created_by_user VARCHAR(191) DEFAULT NULL, CHANGE date_modified date_modified DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE modified_by modified_by INT DEFAULT NULL, CHANGE modified_by_user modified_by_user VARCHAR(191) DEFAULT NULL, CHANGE checked_out checked_out DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE checked_out_by checked_out_by INT DEFAULT NULL, CHANGE checked_out_by_user checked_out_by_user VARCHAR(191) DEFAULT NULL, CHANGE template template VARCHAR(191) DEFAULT NULL, CHANGE content content LONGTEXT DEFAULT NULL COMMENT '(DC2Type:array)', CHANGE publish_up publish_up DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE publish_down publish_down DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE meta_description meta_description VARCHAR(191) DEFAULT NULL, CHANGE redirect_type redirect_type VARCHAR(100) DEFAULT NULL, CHANGE redirect_url redirect_url VARCHAR(2048) DEFAULT NULL, CHANGE is_preference_center is_preference_center TINYINT(1) DEFAULT NULL, CHANGE no_index no_index TINYINT(1) DEFAULT NULL, CHANGE variant_settings variant_settings LONGTEXT DEFAULT NULL COMMENT '(DC2Type:array)', CHANGE variant_start_date variant_start_date DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)';

ALTER TABLE z5a82_page_redirects CHANGE date_added date_added DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE created_by created_by INT DEFAULT NULL, CHANGE created_by_user created_by_user VARCHAR(191) DEFAULT NULL, CHANGE date_modified date_modified DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE modified_by modified_by INT DEFAULT NULL, CHANGE modified_by_user modified_by_user VARCHAR(191) DEFAULT NULL, CHANGE checked_out checked_out DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE checked_out_by checked_out_by INT DEFAULT NULL, CHANGE checked_out_by_user checked_out_by_user VARCHAR(191) DEFAULT NULL;

ALTER TABLE z5a82_video_hits CHANGE lead_id lead_id BIGINT UNSIGNED DEFAULT NULL, CHANGE date_left date_left DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE country country VARCHAR(191) DEFAULT NULL, CHANGE region region VARCHAR(191) DEFAULT NULL, CHANGE city city VARCHAR(191) DEFAULT NULL, CHANGE isp isp VARCHAR(191) DEFAULT NULL, CHANGE organization organization VARCHAR(191) DEFAULT NULL, CHANGE remote_host remote_host VARCHAR(191) DEFAULT NULL, CHANGE page_language page_language VARCHAR(191) DEFAULT NULL, CHANGE browser_languages browser_languages LONGTEXT DEFAULT NULL COMMENT '(DC2Type:array)', CHANGE channel channel VARCHAR(191) DEFAULT NULL, CHANGE channel_id channel_id INT DEFAULT NULL, CHANGE time_watched time_watched INT DEFAULT NULL, CHANGE duration duration INT DEFAULT NULL, CHANGE query query LONGTEXT DEFAULT NULL COMMENT '(DC2Type:array)';

ALTER TABLE z5a82_plugin_integration_settings CHANGE plugin_id plugin_id INT UNSIGNED DEFAULT NULL, CHANGE supported_features supported_features LONGTEXT DEFAULT NULL COMMENT '(DC2Type:array)', CHANGE feature_settings feature_settings LONGTEXT DEFAULT NULL COMMENT '(DC2Type:array)';

ALTER TABLE z5a82_plugins CHANGE version version VARCHAR(191) DEFAULT NULL, CHANGE author author VARCHAR(191) DEFAULT NULL;

ALTER TABLE z5a82_integration_entity CHANGE integration integration VARCHAR(191) DEFAULT NULL, CHANGE integration_entity integration_entity VARCHAR(191) DEFAULT NULL, CHANGE integration_entity_id integration_entity_id VARCHAR(191) DEFAULT NULL, CHANGE internal_entity internal_entity VARCHAR(191) DEFAULT NULL, CHANGE internal_entity_id internal_entity_id INT DEFAULT NULL, CHANGE last_sync_date last_sync_date DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE internal internal LONGTEXT DEFAULT NULL COMMENT '(DC2Type:array)';

ALTER TABLE z5a82_point_lead_action_log CHANGE ip_id ip_id INT UNSIGNED DEFAULT NULL;

ALTER TABLE z5a82_point_lead_event_log CHANGE ip_id ip_id INT UNSIGNED DEFAULT NULL;

ALTER TABLE z5a82_points CHANGE category_id category_id INT UNSIGNED DEFAULT NULL, CHANGE date_added date_added DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE created_by created_by INT DEFAULT NULL, CHANGE created_by_user created_by_user VARCHAR(191) DEFAULT NULL, CHANGE date_modified date_modified DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE modified_by modified_by INT DEFAULT NULL, CHANGE modified_by_user modified_by_user VARCHAR(191) DEFAULT NULL, CHANGE checked_out checked_out DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE checked_out_by checked_out_by INT DEFAULT NULL, CHANGE checked_out_by_user checked_out_by_user VARCHAR(191) DEFAULT NULL, CHANGE publish_up publish_up DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE publish_down publish_down DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)';

ALTER TABLE z5a82_point_triggers CHANGE category_id category_id INT UNSIGNED DEFAULT NULL, CHANGE date_added date_added DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE created_by created_by INT DEFAULT NULL, CHANGE created_by_user created_by_user VARCHAR(191) DEFAULT NULL, CHANGE date_modified date_modified DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE modified_by modified_by INT DEFAULT NULL, CHANGE modified_by_user modified_by_user VARCHAR(191) DEFAULT NULL, CHANGE checked_out checked_out DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE checked_out_by checked_out_by INT DEFAULT NULL, CHANGE checked_out_by_user checked_out_by_user VARCHAR(191) DEFAULT NULL, CHANGE publish_up publish_up DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE publish_down publish_down DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)';

ALTER TABLE z5a82_reports CHANGE date_added date_added DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE created_by created_by INT DEFAULT NULL, CHANGE created_by_user created_by_user VARCHAR(191) DEFAULT NULL, CHANGE date_modified date_modified DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE modified_by modified_by INT DEFAULT NULL, CHANGE modified_by_user modified_by_user VARCHAR(191) DEFAULT NULL, CHANGE checked_out checked_out DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE checked_out_by checked_out_by INT DEFAULT NULL, CHANGE checked_out_by_user checked_out_by_user VARCHAR(191) DEFAULT NULL, CHANGE columns columns LONGTEXT DEFAULT NULL COMMENT '(DC2Type:array)', CHANGE filters filters LONGTEXT DEFAULT NULL COMMENT '(DC2Type:array)', CHANGE table_order table_order LONGTEXT DEFAULT NULL COMMENT '(DC2Type:array)', CHANGE graphs graphs LONGTEXT DEFAULT NULL COMMENT '(DC2Type:array)', CHANGE group_by group_by LONGTEXT DEFAULT NULL COMMENT '(DC2Type:array)', CHANGE aggregators aggregators LONGTEXT DEFAULT NULL COMMENT '(DC2Type:array)', CHANGE settings settings JSON DEFAULT NULL COMMENT '(DC2Type:json_array)', CHANGE schedule_unit schedule_unit VARCHAR(191) DEFAULT NULL, CHANGE to_address to_address VARCHAR(191) DEFAULT NULL, CHANGE schedule_day schedule_day VARCHAR(191) DEFAULT NULL, CHANGE schedule_month_frequency schedule_month_frequency VARCHAR(191) DEFAULT NULL;

ALTER TABLE z5a82_sms_messages CHANGE category_id category_id INT UNSIGNED DEFAULT NULL, CHANGE date_added date_added DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE created_by created_by INT DEFAULT NULL, CHANGE created_by_user created_by_user VARCHAR(191) DEFAULT NULL, CHANGE date_modified date_modified DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE modified_by modified_by INT DEFAULT NULL, CHANGE modified_by_user modified_by_user VARCHAR(191) DEFAULT NULL, CHANGE checked_out checked_out DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE checked_out_by checked_out_by INT DEFAULT NULL, CHANGE checked_out_by_user checked_out_by_user VARCHAR(191) DEFAULT NULL, CHANGE publish_up publish_up DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE publish_down publish_down DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)';

ALTER TABLE z5a82_sms_message_stats CHANGE sms_id sms_id INT UNSIGNED DEFAULT NULL, CHANGE lead_id lead_id BIGINT UNSIGNED DEFAULT NULL, CHANGE list_id list_id INT UNSIGNED DEFAULT NULL, CHANGE ip_id ip_id INT UNSIGNED DEFAULT NULL, CHANGE is_failed is_failed TINYINT(1) DEFAULT NULL, CHANGE tracking_hash tracking_hash VARCHAR(191) DEFAULT NULL, CHANGE source source VARCHAR(191) DEFAULT NULL, CHANGE source_id source_id INT DEFAULT NULL, CHANGE tokens tokens LONGTEXT DEFAULT NULL COMMENT '(DC2Type:array)';

ALTER TABLE z5a82_stages CHANGE category_id category_id INT UNSIGNED DEFAULT NULL, CHANGE date_added date_added DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE created_by created_by INT DEFAULT NULL, CHANGE created_by_user created_by_user VARCHAR(191) DEFAULT NULL, CHANGE date_modified date_modified DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE modified_by modified_by INT DEFAULT NULL, CHANGE modified_by_user modified_by_user VARCHAR(191) DEFAULT NULL, CHANGE checked_out checked_out DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE checked_out_by checked_out_by INT DEFAULT NULL, CHANGE checked_out_by_user checked_out_by_user VARCHAR(191) DEFAULT NULL, CHANGE publish_up publish_up DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE publish_down publish_down DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)';

ALTER TABLE z5a82_stage_lead_action_log CHANGE ip_id ip_id INT UNSIGNED DEFAULT NULL;

ALTER TABLE z5a82_users CHANGE date_added date_added DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE created_by created_by INT DEFAULT NULL, CHANGE created_by_user created_by_user VARCHAR(191) DEFAULT NULL, CHANGE date_modified date_modified DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE modified_by modified_by INT DEFAULT NULL, CHANGE modified_by_user modified_by_user VARCHAR(191) DEFAULT NULL, CHANGE checked_out checked_out DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE checked_out_by checked_out_by INT DEFAULT NULL, CHANGE checked_out_by_user checked_out_by_user VARCHAR(191) DEFAULT NULL, CHANGE position position VARCHAR(191) DEFAULT NULL, CHANGE timezone timezone VARCHAR(191) DEFAULT NULL, CHANGE locale locale VARCHAR(191) DEFAULT NULL, CHANGE last_login last_login DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE last_active last_active DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE preferences preferences LONGTEXT DEFAULT NULL COMMENT '(DC2Type:array)';

ALTER TABLE z5a82_roles CHANGE date_added date_added DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE created_by created_by INT DEFAULT NULL, CHANGE created_by_user created_by_user VARCHAR(191) DEFAULT NULL, CHANGE date_modified date_modified DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE modified_by modified_by INT DEFAULT NULL, CHANGE modified_by_user modified_by_user VARCHAR(191) DEFAULT NULL, CHANGE checked_out checked_out DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE checked_out_by checked_out_by INT DEFAULT NULL, CHANGE checked_out_by_user checked_out_by_user VARCHAR(191) DEFAULT NULL;

ALTER TABLE z5a82_user_tokens CHANGE expiration expiration DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)';

ALTER TABLE z5a82_webhook_logs CHANGE date_added date_added DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE note note VARCHAR(191) DEFAULT NULL, CHANGE runtime runtime DOUBLE PRECISION DEFAULT NULL;

ALTER TABLE z5a82_webhooks CHANGE category_id category_id INT UNSIGNED DEFAULT NULL, CHANGE date_added date_added DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE created_by created_by INT DEFAULT NULL, CHANGE created_by_user created_by_user VARCHAR(191) DEFAULT NULL, CHANGE date_modified date_modified DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE modified_by modified_by INT DEFAULT NULL, CHANGE modified_by_user modified_by_user VARCHAR(191) DEFAULT NULL, CHANGE checked_out checked_out DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE checked_out_by checked_out_by INT DEFAULT NULL, CHANGE checked_out_by_user checked_out_by_user VARCHAR(191) DEFAULT NULL, CHANGE events_orderby_dir events_orderby_dir VARCHAR(191) DEFAULT NULL;

ALTER TABLE z5a82_webhook_queue CHANGE date_added date_added DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)';

ALTER TABLE z5a82_plugin_citrix_events CHANGE event_desc event_desc VARCHAR(191) DEFAULT NULL;

ALTER TABLE z5a82_plugin_crm_pipedrive_owners CHANGE owner_id owner_id INT DEFAULT NULL;

ALTER TABLE z5a82_focus CHANGE category_id category_id INT UNSIGNED DEFAULT NULL, CHANGE date_added date_added DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE created_by created_by INT DEFAULT NULL, CHANGE created_by_user created_by_user VARCHAR(191) DEFAULT NULL, CHANGE date_modified date_modified DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE modified_by modified_by INT DEFAULT NULL, CHANGE modified_by_user modified_by_user VARCHAR(191) DEFAULT NULL, CHANGE checked_out checked_out DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE checked_out_by checked_out_by INT DEFAULT NULL, CHANGE checked_out_by_user checked_out_by_user VARCHAR(191) DEFAULT NULL, CHANGE website website VARCHAR(191) DEFAULT NULL, CHANGE publish_up publish_up DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE publish_down publish_down DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE properties properties LONGTEXT DEFAULT NULL COMMENT '(DC2Type:array)', CHANGE utm_tags utm_tags LONGTEXT DEFAULT NULL COMMENT '(DC2Type:array)', CHANGE form_id form_id INT DEFAULT NULL, CHANGE html_mode html_mode VARCHAR(191) DEFAULT NULL;

ALTER TABLE z5a82_focus_stats CHANGE lead_id lead_id BIGINT UNSIGNED DEFAULT NULL, CHANGE type_id type_id INT DEFAULT NULL;

ALTER TABLE z5a82_monitoring CHANGE category_id category_id INT UNSIGNED DEFAULT NULL, CHANGE date_added date_added DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE created_by created_by INT DEFAULT NULL, CHANGE created_by_user created_by_user VARCHAR(191) DEFAULT NULL, CHANGE date_modified date_modified DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE modified_by modified_by INT DEFAULT NULL, CHANGE modified_by_user modified_by_user VARCHAR(191) DEFAULT NULL, CHANGE checked_out checked_out DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE checked_out_by checked_out_by INT DEFAULT NULL, CHANGE checked_out_by_user checked_out_by_user VARCHAR(191) DEFAULT NULL, CHANGE lists lists LONGTEXT DEFAULT NULL COMMENT '(DC2Type:array)', CHANGE network_type network_type VARCHAR(191) DEFAULT NULL, CHANGE stats stats LONGTEXT DEFAULT NULL COMMENT '(DC2Type:array)', CHANGE properties properties LONGTEXT DEFAULT NULL COMMENT '(DC2Type:array)', CHANGE publish_up publish_up DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE publish_down publish_down DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)';

ALTER TABLE z5a82_monitor_post_count CHANGE monitor_id monitor_id INT UNSIGNED DEFAULT NULL;

ALTER TABLE z5a82_tweets CHANGE category_id category_id INT UNSIGNED DEFAULT NULL, CHANGE page_id page_id INT UNSIGNED DEFAULT NULL, CHANGE asset_id asset_id INT UNSIGNED DEFAULT NULL, CHANGE date_added date_added DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE created_by created_by INT DEFAULT NULL, CHANGE created_by_user created_by_user VARCHAR(191) DEFAULT NULL, CHANGE date_modified date_modified DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE modified_by modified_by INT DEFAULT NULL, CHANGE modified_by_user modified_by_user VARCHAR(191) DEFAULT NULL, CHANGE checked_out checked_out DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE checked_out_by checked_out_by INT DEFAULT NULL, CHANGE checked_out_by_user checked_out_by_user VARCHAR(191) DEFAULT NULL, CHANGE media_id media_id VARCHAR(191) DEFAULT NULL, CHANGE media_path media_path VARCHAR(191) DEFAULT NULL, CHANGE sent_count sent_count INT DEFAULT NULL, CHANGE favorite_count favorite_count INT DEFAULT NULL, CHANGE retweet_count retweet_count INT DEFAULT NULL, CHANGE lang lang VARCHAR(191) DEFAULT NULL;

ALTER TABLE z5a82_tweet_stats CHANGE tweet_id tweet_id INT UNSIGNED DEFAULT NULL, CHANGE lead_id lead_id BIGINT UNSIGNED DEFAULT NULL, CHANGE twitter_tweet_id twitter_tweet_id VARCHAR(191) DEFAULT NULL, CHANGE date_sent date_sent DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE is_failed is_failed TINYINT(1) DEFAULT NULL, CHANGE retry_count retry_count INT DEFAULT NULL, CHANGE source source VARCHAR(191) DEFAULT NULL, CHANGE source_id source_id INT DEFAULT NULL, CHANGE favorite_count favorite_count INT DEFAULT NULL, CHANGE retweet_count retweet_count INT DEFAULT NULL, CHANGE response_details response_details JSON DEFAULT NULL COMMENT '(DC2Type:json_array)';

ALTER TABLE z5a82_custom_navigation_links CHANGE date_added date_added DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE created_by created_by INT DEFAULT NULL, CHANGE created_by_user created_by_user VARCHAR(191) DEFAULT NULL, CHANGE date_modified date_modified DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE modified_by modified_by INT DEFAULT NULL, CHANGE modified_by_user modified_by_user VARCHAR(191) DEFAULT NULL, CHANGE checked_out checked_out DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)', CHANGE checked_out_by checked_out_by INT DEFAULT NULL, CHANGE checked_out_by_user checked_out_by_user VARCHAR(191) DEFAULT NULL, CHANGE priority priority INT DEFAULT NULL, CHANGE icon icon VARCHAR(191) DEFAULT NULL;

ALTER TABLE z5a82_bundle_grapesjsbuilder CHANGE email_id email_id INT UNSIGNED DEFAULT NULL;

 Updating database schema...

 78 queries were executed

 [OK] Database schema updated successfully!
4

Solve by restarting PHP & nginx, I don’t know which one did the trick.

The Export commands also re-appeared in the Bulk select list (though I did not look for them explicitly).