Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

DB Update from 3.14.1 to 4.0.3 does not work #16863

Closed
Bjoernsen opened this issue Dec 2, 2020 · 4 comments
Closed

DB Update from 3.14.1 to 4.0.3 does not work #16863

Bjoernsen opened this issue Dec 2, 2020 · 4 comments
Labels
answered For when a question was asked and we referred to forum or answered it.

Comments

@Bjoernsen
Copy link

I tried to update my Matomo instance running in a docker container.

After pulling the newest image and restarting the container, I tried to run php /var/www/html/console core:update within the container.

Unfortunately, I get the error message: The error was: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'visitor_days_since_first' in 'field list'.
Where was my mistake and what can I do to fix it?

...
Executing DELETE FROM `piwik_option` WHERE option_name IN ("geoip.updater_period", "geoip.loc_db_url", "geoip.isp_db_url", "geoip.org_db_url");... Done. [403 / 418]
  Executing UPDATE piwik_log_visit SET visitor_seconds_since_first = visitor_days_since_first * 86400, 
                    visitor_seconds_since_order = visitor_days_since_order * 86400,
                    visitor_seconds_since_last = visitor_days_since_last * 86400;... 
    [X] Critical Error during the update process:

    * /var/www/html/core/Updates/4.0.0-b1.php:
    Error trying to execute the migration 'UPDATE piwik_log_visit SET visitor_seconds_since_first = visitor_days_since_first * 86400, 
                        visitor_seconds_since_order = visitor_days_since_order * 86400,
                        visitor_seconds_since_last = visitor_days_since_last * 86400;'.
    The error was: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'visitor_days_since_first' in 'field list'

    The above is the core error message. It should help explain the cause, but if you require further help please:

    * Check the [ Matomo FAQ ] which explains most common errors during update. 
    * Ask your system administrator - they may be able to help you with the error which is most likely related to your server or MySQL setup.

    If you are an advanced user and encounter an error in the database upgrade:

    * identify and correct the source of the problem (e.g., memory_limit or max_execution_time)
    * execute the remaining queries in the update that failed
    * manually update the `option` table in your Matomo database, setting the value of version_core to the version of the failed update
    * re-run the updater (through the browser or command-line) to continue with the remaining updates
    * report the problem (and solution) so that Matomo can be improved
ERROR [2020-12-02 11:49:43] 32  Uncaught exception: /var/www/html/plugins/CoreUpdater/Commands/Update.php(255): Matomo could not be updated! See above for more information.
Matomo could not be updated! See above for more information.


                                                                
  [RuntimeException]                                            
  Matomo could not be updated! See above for more information.  
                                                                


core:update [--yes]
@sgiehl
Copy link
Member

sgiehl commented Dec 2, 2020

@Bjoernsen Sorry to hear you have problems updating your Matomo.
That column is dropped later in the update progress normally. Do you have the full console output of the update run?

The update that failed for you, should only be executed if the column exists, so seems that was the case before.
You could try to simply execute the update again, as it should skip that step then.

@Bjoernsen
Copy link
Author

@sgiehl I will try to rerun the update

Here is the complete log

    *** Update ***

    Database Upgrade Required

    Your Matomo database is out-of-date, and must be upgraded before you can continue.

    Matomo database will be upgraded from version 3.14.1 to the new version 4.0.3.

    The following dimensions will be updated: log_link_visit_action.idaction_product_cat, log_link_visit_action.idaction_product_cat2, log_link_visit_action.idaction_product_cat3, log_link_visit_action.idaction_product_cat4, log_link_visit_action.idaction_product_cat5, log_link_visit_action.idaction_product_name, log_link_visit_action.idaction_product_sku, log_link_visit_action.product_price, log_link_visit_action.search_cat, log_link_visit_action.search_count, log_visit.config_browser_name, log_visit.config_client_type, log_visit.location_region, log_visit.profilable, log_visit.referer_name, log_visit.referer_url, log_visit.visit_total_interactions, log_visit.visitor_count_visits, log_visit.visitor_seconds_since_first, log_visit.visitor_seconds_since_last, log_visit.visitor_seconds_since_order.

    *** Note: this is a Dry Run ***

    ./console core:matomo4-migrate-token-auths
    CREATE TABLE `piwik_archive_invalidations` (`idinvalidation` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, `idarchive` INTEGER UNSIGNED NULL, `name` VARCHAR(255) NOT NULL, `idsite` INTEGER NOT NULL, `date1` DATE NOT NULL, `date2` DATE NOT NULL, `period` TINYINT UNSIGNED NOT NULL, `ts_invalidated` DATETIME NOT NULL, `status` TINYINT(1) UNSIGNED DEFAULT 0, `report` VARCHAR(255) NULL, PRIMARY KEY ( `idinvalidation` )) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    ALTER TABLE `piwik_archive_invalidations` ADD INDEX index_idsite_dates_period_name (`idsite`, `date1`, `period`);
    ALTER TABLE `piwik_user` DROP COLUMN `alias`;
    DELETE FROM `piwik_session` WHERE length(id) > 190;
    ALTER TABLE `piwik_session` CHANGE `id` `id` VARCHAR(191);
    ALTER TABLE `piwik_site_url` CHANGE `url` `url` VARCHAR(190);
    ALTER TABLE `piwik_option` CHANGE `option_name` `option_name` VARCHAR(191);
    ALTER TABLE `piwik_log_action` CHANGE `name` `name` VARCHAR(4096);
    ALTER TABLE `piwik_log_conversion` CHANGE `url` `url` VARCHAR(4096);
    ALTER TABLE `piwik_log_link_visit_action` CHANGE `interaction_position` `pageview_position` MEDIUMINT UNSIGNED DEFAULT NULL;
    ./console plugin:activate "BulkTracking"
    ./console plugin:deactivate "CustomPiwikJs"
    ./console plugin:uninstall "CustomPiwikJs"
    ./console plugin:activate "CustomJsTracker"
    ALTER TABLE `piwik_archive_invalidations` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2005_01` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2005_10` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2005_11` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2005_12` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2006_01` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2006_02` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2006_03` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2006_04` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2006_05` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2006_06` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2006_07` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2006_08` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2006_09` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2006_10` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2006_11` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2006_12` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2007_01` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2007_02` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2007_03` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2007_04` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2007_05` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2007_06` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2007_07` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2007_08` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2007_09` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2007_10` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2007_11` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2007_12` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2008_01` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2008_02` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2008_03` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2008_04` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2008_05` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2008_06` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2008_07` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2008_08` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2008_09` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2008_10` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2008_11` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2008_12` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2009_01` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2009_02` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2009_03` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2009_04` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2009_05` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2009_06` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2009_07` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2009_08` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2009_09` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2009_10` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2009_11` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2009_12` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2010_01` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2010_02` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2010_03` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2010_04` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2010_05` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2010_06` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2010_07` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2010_08` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2010_09` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2010_10` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2010_11` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2010_12` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2011_01` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2011_02` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2011_03` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2011_04` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2011_05` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2011_06` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2011_07` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2011_08` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2011_09` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2011_10` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2011_11` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2011_12` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2012_01` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2012_02` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2012_03` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2012_04` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2012_05` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2012_06` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2012_07` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2012_08` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2012_09` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2012_10` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2012_11` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2012_12` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2013_01` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2013_02` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2013_03` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2013_04` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2013_05` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2013_06` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2013_07` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2013_08` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2013_09` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2013_10` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2013_11` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2013_12` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2014_01` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2014_02` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2014_03` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2014_04` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2014_05` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2014_06` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2014_07` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2014_08` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2014_09` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2014_10` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2014_11` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2014_12` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2015_01` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2015_02` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2015_03` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2015_04` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2015_05` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2015_06` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2015_07` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2015_08` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2015_09` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2015_10` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2015_11` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2015_12` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2016_01` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2016_02` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2016_03` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2016_04` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2016_05` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2016_06` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2016_07` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2016_08` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2016_09` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2016_10` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2016_11` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2016_12` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2017_01` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2017_02` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2017_03` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2017_04` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2017_05` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2017_06` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2017_07` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2017_08` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2017_09` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2017_10` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2017_11` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2017_12` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2018_01` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2018_02` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2018_03` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2018_04` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2018_05` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2018_06` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2018_07` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2018_08` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2018_09` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2018_10` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2018_11` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2018_12` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2019_01` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2019_02` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2019_03` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2019_04` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2019_05` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2019_06` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2019_07` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2019_08` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2019_09` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2019_10` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2019_11` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2019_12` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2020_01` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2020_02` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2020_03` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2020_04` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2020_05` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2020_06` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2020_07` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2020_08` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2020_09` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2020_10` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2020_11` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_numeric_2020_12` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2005_01` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2005_10` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2005_11` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2005_12` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2006_01` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2006_02` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2006_03` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2006_04` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2006_05` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2006_06` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2006_07` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2006_08` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2006_09` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2006_10` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2006_11` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2006_12` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2007_01` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2007_02` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2007_03` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2007_04` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2007_05` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2007_06` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2007_07` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2007_08` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2007_09` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2007_10` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2007_11` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2007_12` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2008_01` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2008_02` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2008_03` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2008_04` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2008_05` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2008_06` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2008_07` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2008_08` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2008_09` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2008_10` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2008_11` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2008_12` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2009_01` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2009_02` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2009_03` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2009_04` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2009_05` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2009_06` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2009_07` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2009_08` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2009_09` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2009_10` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2009_11` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2009_12` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2010_01` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2010_02` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2010_03` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2010_04` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2010_05` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2010_06` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2010_07` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2010_08` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2010_09` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2010_10` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2010_11` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2010_12` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2011_01` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2011_02` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2011_03` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2011_04` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2011_05` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2011_06` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2011_07` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2011_08` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2011_09` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2011_10` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2011_11` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2011_12` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2012_01` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2012_02` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2012_03` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2012_04` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2012_05` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2012_06` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2012_07` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2012_08` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2012_09` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2012_10` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2012_11` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2012_12` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2013_01` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2013_02` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2013_03` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2013_04` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2013_05` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2013_06` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2013_07` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2013_08` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2013_09` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2013_10` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2013_11` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2013_12` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2014_01` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2014_02` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2014_03` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2014_04` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2014_05` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2014_06` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2014_07` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2014_08` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2014_09` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2014_10` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2014_11` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2014_12` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2015_01` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2015_02` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2015_03` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2015_04` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2015_05` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2015_06` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2015_07` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2015_08` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2015_09` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2015_10` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2015_11` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2015_12` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2016_01` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2016_02` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2016_03` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2016_04` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2016_05` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2016_06` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2016_07` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2016_08` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2016_09` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2016_10` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2016_11` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2016_12` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2017_01` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2017_02` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2017_03` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2017_04` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2017_05` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2017_06` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2017_07` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2017_08` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2017_09` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2017_10` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2017_11` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2017_12` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2018_01` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2018_02` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2018_03` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2018_04` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2018_05` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2018_06` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2018_07` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2018_08` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2018_09` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2018_10` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2018_11` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2018_12` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2019_01` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2019_02` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2019_03` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2019_04` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2019_05` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2019_06` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2019_07` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2019_08` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2019_09` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2019_10` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2019_11` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2019_12` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2020_01` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2020_02` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2020_03` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2020_04` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2020_05` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2020_06` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2020_07` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2020_08` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2020_09` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2020_10` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2020_11` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_archive_blob_2020_12` CHANGE `name` `name` VARCHAR(190);
    ALTER TABLE `piwik_log_link_visit_action` ADD COLUMN `search_cat` VARCHAR(200) NULL, ADD COLUMN `search_count` INTEGER(10) UNSIGNED NULL, ADD COLUMN `time_dom_completion` MEDIUMINT(10) UNSIGNED NULL, ADD COLUMN `time_dom_processing` MEDIUMINT(10) UNSIGNED NULL, ADD COLUMN `time_network` MEDIUMINT(10) UNSIGNED NULL, ADD COLUMN `time_on_load` MEDIUMINT(10) UNSIGNED NULL, ADD COLUMN `time_server` MEDIUMINT(10) UNSIGNED NULL, ADD COLUMN `time_transfer` MEDIUMINT(10) UNSIGNED NULL;
    INSERT IGNORE INTO `piwik_option` (option_name, option_value) VALUES ('version_log_link_visit_action.search_cat', 'VARCHAR(200) NULL');
    INSERT IGNORE INTO `piwik_option` (option_name, option_value) VALUES ('version_log_link_visit_action.search_count', 'INTEGER(10) UNSIGNED NULL');
    INSERT IGNORE INTO `piwik_option` (option_name, option_value) VALUES ('version_log_link_visit_action.time_dom_completion', 'MEDIUMINT(10) UNSIGNED NULL');
    INSERT IGNORE INTO `piwik_option` (option_name, option_value) VALUES ('version_log_link_visit_action.time_dom_processing', 'MEDIUMINT(10) UNSIGNED NULL');
    INSERT IGNORE INTO `piwik_option` (option_name, option_value) VALUES ('version_log_link_visit_action.time_network', 'MEDIUMINT(10) UNSIGNED NULL');
    INSERT IGNORE INTO `piwik_option` (option_name, option_value) VALUES ('version_log_link_visit_action.time_on_load', 'MEDIUMINT(10) UNSIGNED NULL');
    INSERT IGNORE INTO `piwik_option` (option_name, option_value) VALUES ('version_log_link_visit_action.time_server', 'MEDIUMINT(10) UNSIGNED NULL');
    INSERT IGNORE INTO `piwik_option` (option_name, option_value) VALUES ('version_log_link_visit_action.time_transfer', 'MEDIUMINT(10) UNSIGNED NULL');
    ALTER TABLE `piwik_log_visit` ADD COLUMN `visitor_seconds_since_first` INT(11) UNSIGNED NULL, ADD COLUMN `visitor_seconds_since_order` INT(11) UNSIGNED NULL, ADD COLUMN `visitor_seconds_since_last` INT(11) UNSIGNED NULL, ADD COLUMN `profilable` TINYINT(1) NULL;
    INSERT IGNORE INTO `piwik_option` (option_name, option_value) VALUES ('version_log_visit.visitor_seconds_since_first', 'INT(11) UNSIGNED NULL1');
    INSERT IGNORE INTO `piwik_option` (option_name, option_value) VALUES ('version_log_visit.visitor_seconds_since_order', 'INT(11) UNSIGNED NULL1');
    INSERT IGNORE INTO `piwik_option` (option_name, option_value) VALUES ('version_log_visit.visitor_seconds_since_last', 'INT(11) UNSIGNED NULL');
    INSERT IGNORE INTO `piwik_option` (option_name, option_value) VALUES ('version_log_visit.profilable', 'TINYINT(1) NULL');
    ALTER TABLE `piwik_log_conversion` ADD COLUMN `visitor_seconds_since_first` INT(11) UNSIGNED NULL, ADD COLUMN `visitor_seconds_since_order` INT(11) UNSIGNED NULL;
    INSERT IGNORE INTO `piwik_option` (option_name, option_value) VALUES ('version_log_conversion.visitor_seconds_since_first', 'INT(11) UNSIGNED NULL');
    INSERT IGNORE INTO `piwik_option` (option_name, option_value) VALUES ('version_log_conversion.visitor_seconds_since_order', 'INT(11) UNSIGNED NULL');
    UPDATE piwik_log_link_visit_action SET search_cat = if(custom_var_k4 = '_pk_scat', custom_var_v4, search_cat), search_count = if(custom_var_k5 = '_pk_scount', custom_var_v5, search_count) WHERE custom_var_k4 = '_pk_scat' or custom_var_k5 = '_pk_scount';
    DELETE FROM `piwik_option` WHERE option_name IN ("geoip.updater_period", "geoip.loc_db_url", "geoip.isp_db_url", "geoip.org_db_url");
    UPDATE piwik_log_visit SET visitor_seconds_since_first = visitor_days_since_first * 86400, 
                    visitor_seconds_since_order = visitor_days_since_order * 86400,
                    visitor_seconds_since_last = visitor_days_since_last * 86400;
    UPDATE piwik_log_conversion SET visitor_seconds_since_first = visitor_days_since_first * 86400, 
                    visitor_seconds_since_order = visitor_days_since_order * 86400;
    ALTER TABLE `piwik_log_visit` DROP COLUMN `config_gears`, DROP COLUMN `config_director`, DROP COLUMN `visitor_days_since_first`, DROP COLUMN `visitor_days_since_order`, DROP COLUMN `visitor_days_since_last`;
    ALTER TABLE `piwik_log_conversion` DROP COLUMN `visitor_days_since_first`, DROP COLUMN `visitor_days_since_order`;
    ./console config:set --section="Tracker" --key="ignore_visits_cookie_name" --value="piwik_ignore"
    ./console plugin:activate "PagePerformance"
    ./console plugin:activate "CustomDimensions"
    ./console config:set --section="General" --key="login_allowlist_apply_to_reporting_api_requests" --value="0"
    ALTER TABLE `piwik_archive_invalidations` ADD COLUMN `ts_started` DATETIME NULL;
    ./console plugin:deactivate "ExampleTheme"
    UPDATE piwik_user_token_auth SET hash_algo = "sha512" where hash_algo is null or hash_algo = "" ;
    ./console plugin:uninstall "ExampleTheme"
    ALTER TABLE `piwik_log_visit` ADD COLUMN `profilable` TINYINT(1) NULL, ADD COLUMN `visitor_seconds_since_first` INT(11) UNSIGNED NULL, ADD COLUMN `visitor_seconds_since_order` INT(11) UNSIGNED NULL, MODIFY COLUMN `visitor_count_visits` INT(11) UNSIGNED NOT NULL DEFAULT 0, MODIFY COLUMN `visit_total_interactions` MEDIUMINT UNSIGNED DEFAULT 0, MODIFY COLUMN `referer_name` VARCHAR(255) NULL, MODIFY COLUMN `referer_url` VARCHAR(1500) NULL, MODIFY COLUMN `config_browser_name` VARCHAR(40) NULL, ADD COLUMN `config_client_type` TINYINT( 1 ) NULL DEFAULT NULL, ADD COLUMN `visitor_seconds_since_last` INT(11) UNSIGNED NULL, MODIFY COLUMN `location_region` char(3) DEFAULT NULL;
    ALTER TABLE `piwik_log_conversion` ADD COLUMN `visitor_seconds_since_first` INT(11) UNSIGNED NULL, ADD COLUMN `visitor_seconds_since_order` INT(11) UNSIGNED NULL, MODIFY COLUMN `visitor_count_visits` INT(11) UNSIGNED NOT NULL DEFAULT 0, MODIFY COLUMN `referer_name` VARCHAR(255) NULL, ADD COLUMN `config_browser_name` VARCHAR(40) NULL, ADD COLUMN `config_client_type` TINYINT( 1 ) NULL DEFAULT NULL, MODIFY COLUMN `location_region` char(3) DEFAULT NULL;
    ALTER TABLE `piwik_log_link_visit_action` ADD COLUMN `search_cat` VARCHAR(200) NULL, ADD COLUMN `search_count` INTEGER(10) UNSIGNED NULL, ADD COLUMN `idaction_product_cat` INT(10) UNSIGNED NULL, ADD COLUMN `idaction_product_cat2` INT(10) UNSIGNED NULL, ADD COLUMN `idaction_product_cat3` INT(10) UNSIGNED NULL, ADD COLUMN `idaction_product_cat4` INT(10) UNSIGNED NULL, ADD COLUMN `idaction_product_cat5` INT(10) UNSIGNED NULL, ADD COLUMN `idaction_product_name` INT(10) UNSIGNED NULL, ADD COLUMN `product_price` DOUBLE NULL, ADD COLUMN `idaction_product_sku` INT(10) UNSIGNED NULL;

    *** End of Dry Run ***

A database upgrade is required. Execute update? (y/N) y

Starting the database upgrade process now. This may take a while, so please be patient.

    *** Update ***

    Database Upgrade Required

    Your Matomo database is out-of-date, and must be upgraded before you can continue.

    Matomo database will be upgraded from version 3.14.1 to the new version 4.0.3.

    The following dimensions will be updated: log_link_visit_action.idaction_product_cat, log_link_visit_action.idaction_product_cat2, log_link_visit_action.idaction_product_cat3, log_link_visit_action.idaction_product_cat4, log_link_visit_action.idaction_product_cat5, log_link_visit_action.idaction_product_name, log_link_visit_action.idaction_product_sku, log_link_visit_action.product_price, log_link_visit_action.search_cat, log_link_visit_action.search_count, log_visit.config_browser_name, log_visit.config_client_type, log_visit.location_region, log_visit.profilable, log_visit.referer_name, log_visit.referer_url, log_visit.visit_total_interactions, log_visit.visitor_count_visits, log_visit.visitor_seconds_since_first, log_visit.visitor_seconds_since_last, log_visit.visitor_seconds_since_order.

    The database upgrade process may take a while, so please be patient.

  Executing ./console core:matomo4-migrate-token-auths... Done. [1 / 418]
  Executing CREATE TABLE `piwik_archive_invalidations` (`idinvalidation` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, `idarchive` INTEGER UNSIGNED NULL, `name` VARCHAR(255) NOT NULL, `idsite` INTEGER NOT NULL, `date1` DATE NOT NULL, `date2` DATE NOT NULL, `period` TINYINT UNSIGNED NOT NULL, `ts_invalidated` DATETIME NOT NULL, `status` TINYINT(1) UNSIGNED DEFAULT 0, `report` VARCHAR(255) NULL, PRIMARY KEY ( `idinvalidation` )) ENGINE=InnoDB DEFAULT CHARSET=utf8;... Done. [2 / 418]
  Executing ALTER TABLE `piwik_archive_invalidations` ADD INDEX index_idsite_dates_period_name (`idsite`, `date1`, `period`);... Done. [3 / 418]
  Executing ALTER TABLE `piwik_user` DROP COLUMN `alias`;... Done. [4 / 418]
  Executing DELETE FROM `piwik_session` WHERE length(id) > 190;... Done. [5 / 418]
  Executing ALTER TABLE `piwik_session` CHANGE `id` `id` VARCHAR(191);... Done. [6 / 418]
  Executing ALTER TABLE `piwik_site_url` CHANGE `url` `url` VARCHAR(190);... Done. [7 / 418]
  Executing ALTER TABLE `piwik_option` CHANGE `option_name` `option_name` VARCHAR(191);... Done. [8 / 418]
  Executing ALTER TABLE `piwik_log_action` CHANGE `name` `name` VARCHAR(4096);... Done. [9 / 418]
  Executing ALTER TABLE `piwik_log_conversion` CHANGE `url` `url` VARCHAR(4096);... Done. [10 / 418]
  Executing ALTER TABLE `piwik_log_link_visit_action` CHANGE `interaction_position` `pageview_position` MEDIUMINT UNSIGNED DEFAULT NULL;... Done. [11 / 418]
  Executing ./console plugin:activate "BulkTracking"... Done. [12 / 418]
  Executing ./console plugin:deactivate "CustomPiwikJs"... Done. [13 / 418]
  Executing ./console plugin:uninstall "CustomPiwikJs"... Done. [14 / 418]
  Executing ./console plugin:activate "CustomJsTracker"... Done. [15 / 418]
  Executing ALTER TABLE `piwik_archive_invalidations` CHANGE `name` `name` VARCHAR(190);... Done. [16 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2005_01` CHANGE `name` `name` VARCHAR(190);... Done. [17 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2005_10` CHANGE `name` `name` VARCHAR(190);... Done. [18 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2005_11` CHANGE `name` `name` VARCHAR(190);... Done. [19 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2005_12` CHANGE `name` `name` VARCHAR(190);... Done. [20 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2006_01` CHANGE `name` `name` VARCHAR(190);... Done. [21 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2006_02` CHANGE `name` `name` VARCHAR(190);... Done. [22 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2006_03` CHANGE `name` `name` VARCHAR(190);... Done. [23 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2006_04` CHANGE `name` `name` VARCHAR(190);... Done. [24 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2006_05` CHANGE `name` `name` VARCHAR(190);... Done. [25 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2006_06` CHANGE `name` `name` VARCHAR(190);... Done. [26 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2006_07` CHANGE `name` `name` VARCHAR(190);... Done. [27 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2006_08` CHANGE `name` `name` VARCHAR(190);... Done. [28 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2006_09` CHANGE `name` `name` VARCHAR(190);... Done. [29 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2006_10` CHANGE `name` `name` VARCHAR(190);... Done. [30 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2006_11` CHANGE `name` `name` VARCHAR(190);... Done. [31 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2006_12` CHANGE `name` `name` VARCHAR(190);... Done. [32 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2007_01` CHANGE `name` `name` VARCHAR(190);... Done. [33 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2007_02` CHANGE `name` `name` VARCHAR(190);... Done. [34 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2007_03` CHANGE `name` `name` VARCHAR(190);... Done. [35 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2007_04` CHANGE `name` `name` VARCHAR(190);... Done. [36 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2007_05` CHANGE `name` `name` VARCHAR(190);... Done. [37 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2007_06` CHANGE `name` `name` VARCHAR(190);... Done. [38 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2007_07` CHANGE `name` `name` VARCHAR(190);... Done. [39 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2007_08` CHANGE `name` `name` VARCHAR(190);... Done. [40 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2007_09` CHANGE `name` `name` VARCHAR(190);... Done. [41 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2007_10` CHANGE `name` `name` VARCHAR(190);... Done. [42 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2007_11` CHANGE `name` `name` VARCHAR(190);... Done. [43 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2007_12` CHANGE `name` `name` VARCHAR(190);... Done. [44 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2008_01` CHANGE `name` `name` VARCHAR(190);... Done. [45 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2008_02` CHANGE `name` `name` VARCHAR(190);... Done. [46 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2008_03` CHANGE `name` `name` VARCHAR(190);... Done. [47 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2008_04` CHANGE `name` `name` VARCHAR(190);... Done. [48 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2008_05` CHANGE `name` `name` VARCHAR(190);... Done. [49 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2008_06` CHANGE `name` `name` VARCHAR(190);... Done. [50 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2008_07` CHANGE `name` `name` VARCHAR(190);... Done. [51 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2008_08` CHANGE `name` `name` VARCHAR(190);... Done. [52 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2008_09` CHANGE `name` `name` VARCHAR(190);... Done. [53 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2008_10` CHANGE `name` `name` VARCHAR(190);... Done. [54 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2008_11` CHANGE `name` `name` VARCHAR(190);... Done. [55 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2008_12` CHANGE `name` `name` VARCHAR(190);... Done. [56 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2009_01` CHANGE `name` `name` VARCHAR(190);... Done. [57 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2009_02` CHANGE `name` `name` VARCHAR(190);... Done. [58 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2009_03` CHANGE `name` `name` VARCHAR(190);... Done. [59 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2009_04` CHANGE `name` `name` VARCHAR(190);... Done. [60 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2009_05` CHANGE `name` `name` VARCHAR(190);... Done. [61 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2009_06` CHANGE `name` `name` VARCHAR(190);... Done. [62 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2009_07` CHANGE `name` `name` VARCHAR(190);... Done. [63 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2009_08` CHANGE `name` `name` VARCHAR(190);... Done. [64 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2009_09` CHANGE `name` `name` VARCHAR(190);... Done. [65 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2009_10` CHANGE `name` `name` VARCHAR(190);... Done. [66 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2009_11` CHANGE `name` `name` VARCHAR(190);... Done. [67 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2009_12` CHANGE `name` `name` VARCHAR(190);... Done. [68 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2010_01` CHANGE `name` `name` VARCHAR(190);... Done. [69 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2010_02` CHANGE `name` `name` VARCHAR(190);... Done. [70 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2010_03` CHANGE `name` `name` VARCHAR(190);... Done. [71 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2010_04` CHANGE `name` `name` VARCHAR(190);... Done. [72 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2010_05` CHANGE `name` `name` VARCHAR(190);... Done. [73 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2010_06` CHANGE `name` `name` VARCHAR(190);... Done. [74 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2010_07` CHANGE `name` `name` VARCHAR(190);... Done. [75 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2010_08` CHANGE `name` `name` VARCHAR(190);... Done. [76 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2010_09` CHANGE `name` `name` VARCHAR(190);... Done. [77 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2010_10` CHANGE `name` `name` VARCHAR(190);... Done. [78 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2010_11` CHANGE `name` `name` VARCHAR(190);... Done. [79 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2010_12` CHANGE `name` `name` VARCHAR(190);... Done. [80 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2011_01` CHANGE `name` `name` VARCHAR(190);... Done. [81 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2011_02` CHANGE `name` `name` VARCHAR(190);... Done. [82 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2011_03` CHANGE `name` `name` VARCHAR(190);... Done. [83 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2011_04` CHANGE `name` `name` VARCHAR(190);... Done. [84 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2011_05` CHANGE `name` `name` VARCHAR(190);... Done. [85 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2011_06` CHANGE `name` `name` VARCHAR(190);... Done. [86 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2011_07` CHANGE `name` `name` VARCHAR(190);... Done. [87 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2011_08` CHANGE `name` `name` VARCHAR(190);... Done. [88 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2011_09` CHANGE `name` `name` VARCHAR(190);... Done. [89 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2011_10` CHANGE `name` `name` VARCHAR(190);... Done. [90 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2011_11` CHANGE `name` `name` VARCHAR(190);... Done. [91 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2011_12` CHANGE `name` `name` VARCHAR(190);... Done. [92 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2012_01` CHANGE `name` `name` VARCHAR(190);... Done. [93 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2012_02` CHANGE `name` `name` VARCHAR(190);... Done. [94 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2012_03` CHANGE `name` `name` VARCHAR(190);... Done. [95 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2012_04` CHANGE `name` `name` VARCHAR(190);... Done. [96 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2012_05` CHANGE `name` `name` VARCHAR(190);... Done. [97 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2012_06` CHANGE `name` `name` VARCHAR(190);... Done. [98 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2012_07` CHANGE `name` `name` VARCHAR(190);... Done. [99 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2012_08` CHANGE `name` `name` VARCHAR(190);... Done. [100 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2012_09` CHANGE `name` `name` VARCHAR(190);... Done. [101 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2012_10` CHANGE `name` `name` VARCHAR(190);... Done. [102 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2012_11` CHANGE `name` `name` VARCHAR(190);... Done. [103 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2012_12` CHANGE `name` `name` VARCHAR(190);... Done. [104 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2013_01` CHANGE `name` `name` VARCHAR(190);... Done. [105 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2013_02` CHANGE `name` `name` VARCHAR(190);... Done. [106 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2013_03` CHANGE `name` `name` VARCHAR(190);... Done. [107 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2013_04` CHANGE `name` `name` VARCHAR(190);... Done. [108 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2013_05` CHANGE `name` `name` VARCHAR(190);... Done. [109 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2013_06` CHANGE `name` `name` VARCHAR(190);... Done. [110 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2013_07` CHANGE `name` `name` VARCHAR(190);... Done. [111 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2013_08` CHANGE `name` `name` VARCHAR(190);... Done. [112 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2013_09` CHANGE `name` `name` VARCHAR(190);... Done. [113 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2013_10` CHANGE `name` `name` VARCHAR(190);... Done. [114 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2013_11` CHANGE `name` `name` VARCHAR(190);... Done. [115 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2013_12` CHANGE `name` `name` VARCHAR(190);... Done. [116 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2014_01` CHANGE `name` `name` VARCHAR(190);... Done. [117 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2014_02` CHANGE `name` `name` VARCHAR(190);... Done. [118 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2014_03` CHANGE `name` `name` VARCHAR(190);... Done. [119 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2014_04` CHANGE `name` `name` VARCHAR(190);... Done. [120 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2014_05` CHANGE `name` `name` VARCHAR(190);... Done. [121 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2014_06` CHANGE `name` `name` VARCHAR(190);... Done. [122 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2014_07` CHANGE `name` `name` VARCHAR(190);... Done. [123 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2014_08` CHANGE `name` `name` VARCHAR(190);... Done. [124 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2014_09` CHANGE `name` `name` VARCHAR(190);... Done. [125 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2014_10` CHANGE `name` `name` VARCHAR(190);... Done. [126 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2014_11` CHANGE `name` `name` VARCHAR(190);... Done. [127 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2014_12` CHANGE `name` `name` VARCHAR(190);... Done. [128 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2015_01` CHANGE `name` `name` VARCHAR(190);... Done. [129 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2015_02` CHANGE `name` `name` VARCHAR(190);... Done. [130 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2015_03` CHANGE `name` `name` VARCHAR(190);... Done. [131 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2015_04` CHANGE `name` `name` VARCHAR(190);... Done. [132 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2015_05` CHANGE `name` `name` VARCHAR(190);... Done. [133 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2015_06` CHANGE `name` `name` VARCHAR(190);... Done. [134 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2015_07` CHANGE `name` `name` VARCHAR(190);... Done. [135 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2015_08` CHANGE `name` `name` VARCHAR(190);... Done. [136 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2015_09` CHANGE `name` `name` VARCHAR(190);... Done. [137 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2015_10` CHANGE `name` `name` VARCHAR(190);... Done. [138 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2015_11` CHANGE `name` `name` VARCHAR(190);... Done. [139 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2015_12` CHANGE `name` `name` VARCHAR(190);... Done. [140 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2016_01` CHANGE `name` `name` VARCHAR(190);... Done. [141 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2016_02` CHANGE `name` `name` VARCHAR(190);... Done. [142 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2016_03` CHANGE `name` `name` VARCHAR(190);... Done. [143 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2016_04` CHANGE `name` `name` VARCHAR(190);... Done. [144 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2016_05` CHANGE `name` `name` VARCHAR(190);... Done. [145 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2016_06` CHANGE `name` `name` VARCHAR(190);... Done. [146 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2016_07` CHANGE `name` `name` VARCHAR(190);... Done. [147 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2016_08` CHANGE `name` `name` VARCHAR(190);... Done. [148 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2016_09` CHANGE `name` `name` VARCHAR(190);... Done. [149 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2016_10` CHANGE `name` `name` VARCHAR(190);... Done. [150 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2016_11` CHANGE `name` `name` VARCHAR(190);... Done. [151 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2016_12` CHANGE `name` `name` VARCHAR(190);... Done. [152 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2017_01` CHANGE `name` `name` VARCHAR(190);... Done. [153 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2017_02` CHANGE `name` `name` VARCHAR(190);... Done. [154 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2017_03` CHANGE `name` `name` VARCHAR(190);... Done. [155 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2017_04` CHANGE `name` `name` VARCHAR(190);... Done. [156 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2017_05` CHANGE `name` `name` VARCHAR(190);... Done. [157 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2017_06` CHANGE `name` `name` VARCHAR(190);... Done. [158 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2017_07` CHANGE `name` `name` VARCHAR(190);... Done. [159 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2017_08` CHANGE `name` `name` VARCHAR(190);... Done. [160 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2017_09` CHANGE `name` `name` VARCHAR(190);... Done. [161 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2017_10` CHANGE `name` `name` VARCHAR(190);... Done. [162 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2017_11` CHANGE `name` `name` VARCHAR(190);... Done. [163 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2017_12` CHANGE `name` `name` VARCHAR(190);... Done. [164 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2018_01` CHANGE `name` `name` VARCHAR(190);... Done. [165 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2018_02` CHANGE `name` `name` VARCHAR(190);... Done. [166 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2018_03` CHANGE `name` `name` VARCHAR(190);... Done. [167 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2018_04` CHANGE `name` `name` VARCHAR(190);... Done. [168 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2018_05` CHANGE `name` `name` VARCHAR(190);... Done. [169 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2018_06` CHANGE `name` `name` VARCHAR(190);... Done. [170 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2018_07` CHANGE `name` `name` VARCHAR(190);... Done. [171 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2018_08` CHANGE `name` `name` VARCHAR(190);... Done. [172 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2018_09` CHANGE `name` `name` VARCHAR(190);... Done. [173 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2018_10` CHANGE `name` `name` VARCHAR(190);... Done. [174 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2018_11` CHANGE `name` `name` VARCHAR(190);... Done. [175 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2018_12` CHANGE `name` `name` VARCHAR(190);... Done. [176 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2019_01` CHANGE `name` `name` VARCHAR(190);... Done. [177 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2019_02` CHANGE `name` `name` VARCHAR(190);... Done. [178 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2019_03` CHANGE `name` `name` VARCHAR(190);... Done. [179 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2019_04` CHANGE `name` `name` VARCHAR(190);... Done. [180 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2019_05` CHANGE `name` `name` VARCHAR(190);... Done. [181 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2019_06` CHANGE `name` `name` VARCHAR(190);... Done. [182 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2019_07` CHANGE `name` `name` VARCHAR(190);... Done. [183 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2019_08` CHANGE `name` `name` VARCHAR(190);... Done. [184 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2019_09` CHANGE `name` `name` VARCHAR(190);... Done. [185 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2019_10` CHANGE `name` `name` VARCHAR(190);... Done. [186 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2019_11` CHANGE `name` `name` VARCHAR(190);... Done. [187 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2019_12` CHANGE `name` `name` VARCHAR(190);... Done. [188 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2020_01` CHANGE `name` `name` VARCHAR(190);... Done. [189 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2020_02` CHANGE `name` `name` VARCHAR(190);... Done. [190 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2020_03` CHANGE `name` `name` VARCHAR(190);... Done. [191 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2020_04` CHANGE `name` `name` VARCHAR(190);... Done. [192 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2020_05` CHANGE `name` `name` VARCHAR(190);... Done. [193 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2020_06` CHANGE `name` `name` VARCHAR(190);... Done. [194 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2020_07` CHANGE `name` `name` VARCHAR(190);... Done. [195 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2020_08` CHANGE `name` `name` VARCHAR(190);... Done. [196 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2020_09` CHANGE `name` `name` VARCHAR(190);... Done. [197 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2020_10` CHANGE `name` `name` VARCHAR(190);... Done. [198 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2020_11` CHANGE `name` `name` VARCHAR(190);... Done. [199 / 418]
  Executing ALTER TABLE `piwik_archive_numeric_2020_12` CHANGE `name` `name` VARCHAR(190);... Done. [200 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2005_01` CHANGE `name` `name` VARCHAR(190);... Done. [201 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2005_10` CHANGE `name` `name` VARCHAR(190);... Done. [202 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2005_11` CHANGE `name` `name` VARCHAR(190);... Done. [203 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2005_12` CHANGE `name` `name` VARCHAR(190);... Done. [204 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2006_01` CHANGE `name` `name` VARCHAR(190);... Done. [205 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2006_02` CHANGE `name` `name` VARCHAR(190);... Done. [206 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2006_03` CHANGE `name` `name` VARCHAR(190);... Done. [207 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2006_04` CHANGE `name` `name` VARCHAR(190);... Done. [208 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2006_05` CHANGE `name` `name` VARCHAR(190);... Done. [209 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2006_06` CHANGE `name` `name` VARCHAR(190);... Done. [210 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2006_07` CHANGE `name` `name` VARCHAR(190);... Done. [211 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2006_08` CHANGE `name` `name` VARCHAR(190);... Done. [212 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2006_09` CHANGE `name` `name` VARCHAR(190);... Done. [213 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2006_10` CHANGE `name` `name` VARCHAR(190);... Done. [214 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2006_11` CHANGE `name` `name` VARCHAR(190);... Done. [215 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2006_12` CHANGE `name` `name` VARCHAR(190);... Done. [216 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2007_01` CHANGE `name` `name` VARCHAR(190);... Done. [217 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2007_02` CHANGE `name` `name` VARCHAR(190);... Done. [218 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2007_03` CHANGE `name` `name` VARCHAR(190);... Done. [219 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2007_04` CHANGE `name` `name` VARCHAR(190);... Done. [220 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2007_05` CHANGE `name` `name` VARCHAR(190);... Done. [221 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2007_06` CHANGE `name` `name` VARCHAR(190);... Done. [222 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2007_07` CHANGE `name` `name` VARCHAR(190);... Done. [223 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2007_08` CHANGE `name` `name` VARCHAR(190);... Done. [224 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2007_09` CHANGE `name` `name` VARCHAR(190);... Done. [225 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2007_10` CHANGE `name` `name` VARCHAR(190);... Done. [226 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2007_11` CHANGE `name` `name` VARCHAR(190);... Done. [227 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2007_12` CHANGE `name` `name` VARCHAR(190);... Done. [228 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2008_01` CHANGE `name` `name` VARCHAR(190);... Done. [229 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2008_02` CHANGE `name` `name` VARCHAR(190);... Done. [230 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2008_03` CHANGE `name` `name` VARCHAR(190);... Done. [231 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2008_04` CHANGE `name` `name` VARCHAR(190);... Done. [232 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2008_05` CHANGE `name` `name` VARCHAR(190);... Done. [233 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2008_06` CHANGE `name` `name` VARCHAR(190);... Done. [234 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2008_07` CHANGE `name` `name` VARCHAR(190);... Done. [235 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2008_08` CHANGE `name` `name` VARCHAR(190);... Done. [236 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2008_09` CHANGE `name` `name` VARCHAR(190);... Done. [237 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2008_10` CHANGE `name` `name` VARCHAR(190);... Done. [238 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2008_11` CHANGE `name` `name` VARCHAR(190);... Done. [239 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2008_12` CHANGE `name` `name` VARCHAR(190);... Done. [240 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2009_01` CHANGE `name` `name` VARCHAR(190);... Done. [241 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2009_02` CHANGE `name` `name` VARCHAR(190);... Done. [242 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2009_03` CHANGE `name` `name` VARCHAR(190);... Done. [243 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2009_04` CHANGE `name` `name` VARCHAR(190);... Done. [244 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2009_05` CHANGE `name` `name` VARCHAR(190);... Done. [245 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2009_06` CHANGE `name` `name` VARCHAR(190);... Done. [246 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2009_07` CHANGE `name` `name` VARCHAR(190);... Done. [247 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2009_08` CHANGE `name` `name` VARCHAR(190);... Done. [248 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2009_09` CHANGE `name` `name` VARCHAR(190);... Done. [249 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2009_10` CHANGE `name` `name` VARCHAR(190);... Done. [250 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2009_11` CHANGE `name` `name` VARCHAR(190);... Done. [251 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2009_12` CHANGE `name` `name` VARCHAR(190);... Done. [252 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2010_01` CHANGE `name` `name` VARCHAR(190);... Done. [253 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2010_02` CHANGE `name` `name` VARCHAR(190);... Done. [254 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2010_03` CHANGE `name` `name` VARCHAR(190);... Done. [255 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2010_04` CHANGE `name` `name` VARCHAR(190);... Done. [256 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2010_05` CHANGE `name` `name` VARCHAR(190);... Done. [257 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2010_06` CHANGE `name` `name` VARCHAR(190);... Done. [258 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2010_07` CHANGE `name` `name` VARCHAR(190);... Done. [259 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2010_08` CHANGE `name` `name` VARCHAR(190);... Done. [260 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2010_09` CHANGE `name` `name` VARCHAR(190);... Done. [261 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2010_10` CHANGE `name` `name` VARCHAR(190);... Done. [262 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2010_11` CHANGE `name` `name` VARCHAR(190);... Done. [263 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2010_12` CHANGE `name` `name` VARCHAR(190);... Done. [264 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2011_01` CHANGE `name` `name` VARCHAR(190);... Done. [265 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2011_02` CHANGE `name` `name` VARCHAR(190);... Done. [266 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2011_03` CHANGE `name` `name` VARCHAR(190);... Done. [267 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2011_04` CHANGE `name` `name` VARCHAR(190);... Done. [268 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2011_05` CHANGE `name` `name` VARCHAR(190);... Done. [269 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2011_06` CHANGE `name` `name` VARCHAR(190);... Done. [270 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2011_07` CHANGE `name` `name` VARCHAR(190);... Done. [271 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2011_08` CHANGE `name` `name` VARCHAR(190);... Done. [272 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2011_09` CHANGE `name` `name` VARCHAR(190);... Done. [273 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2011_10` CHANGE `name` `name` VARCHAR(190);... Done. [274 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2011_11` CHANGE `name` `name` VARCHAR(190);... Done. [275 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2011_12` CHANGE `name` `name` VARCHAR(190);... Done. [276 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2012_01` CHANGE `name` `name` VARCHAR(190);... Done. [277 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2012_02` CHANGE `name` `name` VARCHAR(190);... Done. [278 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2012_03` CHANGE `name` `name` VARCHAR(190);... Done. [279 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2012_04` CHANGE `name` `name` VARCHAR(190);... Done. [280 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2012_05` CHANGE `name` `name` VARCHAR(190);... Done. [281 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2012_06` CHANGE `name` `name` VARCHAR(190);... Done. [282 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2012_07` CHANGE `name` `name` VARCHAR(190);... Done. [283 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2012_08` CHANGE `name` `name` VARCHAR(190);... Done. [284 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2012_09` CHANGE `name` `name` VARCHAR(190);... Done. [285 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2012_10` CHANGE `name` `name` VARCHAR(190);... Done. [286 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2012_11` CHANGE `name` `name` VARCHAR(190);... Done. [287 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2012_12` CHANGE `name` `name` VARCHAR(190);... Done. [288 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2013_01` CHANGE `name` `name` VARCHAR(190);... Done. [289 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2013_02` CHANGE `name` `name` VARCHAR(190);... Done. [290 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2013_03` CHANGE `name` `name` VARCHAR(190);... Done. [291 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2013_04` CHANGE `name` `name` VARCHAR(190);... Done. [292 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2013_05` CHANGE `name` `name` VARCHAR(190);... Done. [293 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2013_06` CHANGE `name` `name` VARCHAR(190);... Done. [294 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2013_07` CHANGE `name` `name` VARCHAR(190);... Done. [295 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2013_08` CHANGE `name` `name` VARCHAR(190);... Done. [296 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2013_09` CHANGE `name` `name` VARCHAR(190);... Done. [297 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2013_10` CHANGE `name` `name` VARCHAR(190);... Done. [298 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2013_11` CHANGE `name` `name` VARCHAR(190);... Done. [299 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2013_12` CHANGE `name` `name` VARCHAR(190);... Done. [300 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2014_01` CHANGE `name` `name` VARCHAR(190);... Done. [301 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2014_02` CHANGE `name` `name` VARCHAR(190);... Done. [302 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2014_03` CHANGE `name` `name` VARCHAR(190);... Done. [303 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2014_04` CHANGE `name` `name` VARCHAR(190);... Done. [304 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2014_05` CHANGE `name` `name` VARCHAR(190);... Done. [305 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2014_06` CHANGE `name` `name` VARCHAR(190);... Done. [306 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2014_07` CHANGE `name` `name` VARCHAR(190);... Done. [307 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2014_08` CHANGE `name` `name` VARCHAR(190);... Done. [308 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2014_09` CHANGE `name` `name` VARCHAR(190);... Done. [309 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2014_10` CHANGE `name` `name` VARCHAR(190);... Done. [310 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2014_11` CHANGE `name` `name` VARCHAR(190);... Done. [311 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2014_12` CHANGE `name` `name` VARCHAR(190);... Done. [312 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2015_01` CHANGE `name` `name` VARCHAR(190);... Done. [313 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2015_02` CHANGE `name` `name` VARCHAR(190);... Done. [314 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2015_03` CHANGE `name` `name` VARCHAR(190);... Done. [315 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2015_04` CHANGE `name` `name` VARCHAR(190);... Done. [316 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2015_05` CHANGE `name` `name` VARCHAR(190);... Done. [317 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2015_06` CHANGE `name` `name` VARCHAR(190);... Done. [318 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2015_07` CHANGE `name` `name` VARCHAR(190);... Done. [319 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2015_08` CHANGE `name` `name` VARCHAR(190);... Done. [320 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2015_09` CHANGE `name` `name` VARCHAR(190);... Done. [321 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2015_10` CHANGE `name` `name` VARCHAR(190);... Done. [322 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2015_11` CHANGE `name` `name` VARCHAR(190);... Done. [323 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2015_12` CHANGE `name` `name` VARCHAR(190);... Done. [324 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2016_01` CHANGE `name` `name` VARCHAR(190);... Done. [325 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2016_02` CHANGE `name` `name` VARCHAR(190);... Done. [326 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2016_03` CHANGE `name` `name` VARCHAR(190);... Done. [327 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2016_04` CHANGE `name` `name` VARCHAR(190);... Done. [328 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2016_05` CHANGE `name` `name` VARCHAR(190);... Done. [329 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2016_06` CHANGE `name` `name` VARCHAR(190);... Done. [330 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2016_07` CHANGE `name` `name` VARCHAR(190);... Done. [331 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2016_08` CHANGE `name` `name` VARCHAR(190);... Done. [332 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2016_09` CHANGE `name` `name` VARCHAR(190);... Done. [333 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2016_10` CHANGE `name` `name` VARCHAR(190);... Done. [334 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2016_11` CHANGE `name` `name` VARCHAR(190);... Done. [335 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2016_12` CHANGE `name` `name` VARCHAR(190);... Done. [336 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2017_01` CHANGE `name` `name` VARCHAR(190);... Done. [337 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2017_02` CHANGE `name` `name` VARCHAR(190);... Done. [338 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2017_03` CHANGE `name` `name` VARCHAR(190);... Done. [339 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2017_04` CHANGE `name` `name` VARCHAR(190);... Done. [340 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2017_05` CHANGE `name` `name` VARCHAR(190);... Done. [341 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2017_06` CHANGE `name` `name` VARCHAR(190);... Done. [342 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2017_07` CHANGE `name` `name` VARCHAR(190);... Done. [343 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2017_08` CHANGE `name` `name` VARCHAR(190);... Done. [344 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2017_09` CHANGE `name` `name` VARCHAR(190);... Done. [345 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2017_10` CHANGE `name` `name` VARCHAR(190);... Done. [346 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2017_11` CHANGE `name` `name` VARCHAR(190);... Done. [347 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2017_12` CHANGE `name` `name` VARCHAR(190);... Done. [348 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2018_01` CHANGE `name` `name` VARCHAR(190);... Done. [349 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2018_02` CHANGE `name` `name` VARCHAR(190);... Done. [350 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2018_03` CHANGE `name` `name` VARCHAR(190);... Done. [351 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2018_04` CHANGE `name` `name` VARCHAR(190);... Done. [352 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2018_05` CHANGE `name` `name` VARCHAR(190);... Done. [353 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2018_06` CHANGE `name` `name` VARCHAR(190);... Done. [354 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2018_07` CHANGE `name` `name` VARCHAR(190);... Done. [355 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2018_08` CHANGE `name` `name` VARCHAR(190);... Done. [356 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2018_09` CHANGE `name` `name` VARCHAR(190);... Done. [357 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2018_10` CHANGE `name` `name` VARCHAR(190);... Done. [358 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2018_11` CHANGE `name` `name` VARCHAR(190);... Done. [359 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2018_12` CHANGE `name` `name` VARCHAR(190);... Done. [360 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2019_01` CHANGE `name` `name` VARCHAR(190);... Done. [361 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2019_02` CHANGE `name` `name` VARCHAR(190);... Done. [362 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2019_03` CHANGE `name` `name` VARCHAR(190);... Done. [363 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2019_04` CHANGE `name` `name` VARCHAR(190);... Done. [364 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2019_05` CHANGE `name` `name` VARCHAR(190);... Done. [365 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2019_06` CHANGE `name` `name` VARCHAR(190);... Done. [366 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2019_07` CHANGE `name` `name` VARCHAR(190);... Done. [367 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2019_08` CHANGE `name` `name` VARCHAR(190);... Done. [368 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2019_09` CHANGE `name` `name` VARCHAR(190);... Done. [369 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2019_10` CHANGE `name` `name` VARCHAR(190);... Done. [370 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2019_11` CHANGE `name` `name` VARCHAR(190);... Done. [371 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2019_12` CHANGE `name` `name` VARCHAR(190);... Done. [372 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2020_01` CHANGE `name` `name` VARCHAR(190);... Done. [373 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2020_02` CHANGE `name` `name` VARCHAR(190);... Done. [374 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2020_03` CHANGE `name` `name` VARCHAR(190);... Done. [375 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2020_04` CHANGE `name` `name` VARCHAR(190);... Done. [376 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2020_05` CHANGE `name` `name` VARCHAR(190);... Done. [377 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2020_06` CHANGE `name` `name` VARCHAR(190);... Done. [378 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2020_07` CHANGE `name` `name` VARCHAR(190);... Done. [379 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2020_08` CHANGE `name` `name` VARCHAR(190);... Done. [380 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2020_09` CHANGE `name` `name` VARCHAR(190);... Done. [381 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2020_10` CHANGE `name` `name` VARCHAR(190);... Done. [382 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2020_11` CHANGE `name` `name` VARCHAR(190);... Done. [383 / 418]
  Executing ALTER TABLE `piwik_archive_blob_2020_12` CHANGE `name` `name` VARCHAR(190);... Done. [384 / 418]
  Executing ALTER TABLE `piwik_log_link_visit_action` ADD COLUMN `search_cat` VARCHAR(200) NULL, ADD COLUMN `search_count` INTEGER(10) UNSIGNED NULL, ADD COLUMN `time_dom_completion` MEDIUMINT(10) UNSIGNED NULL, ADD COLUMN `time_dom_processing` MEDIUMINT(10) UNSIGNED NULL, ADD COLUMN `time_network` MEDIUMINT(10) UNSIGNED NULL, ADD COLUMN `time_on_load` MEDIUMINT(10) UNSIGNED NULL, ADD COLUMN `time_server` MEDIUMINT(10) UNSIGNED NULL, ADD COLUMN `time_transfer` MEDIUMINT(10) UNSIGNED NULL;... Done. [385 / 418]
  Executing INSERT IGNORE INTO `piwik_option` (option_name, option_value) VALUES ('version_log_link_visit_action.search_cat', 'VARCHAR(200) NULL');... Done. [386 / 418]
  Executing INSERT IGNORE INTO `piwik_option` (option_name, option_value) VALUES ('version_log_link_visit_action.search_count', 'INTEGER(10) UNSIGNED NULL');... Done. [387 / 418]
  Executing INSERT IGNORE INTO `piwik_option` (option_name, option_value) VALUES ('version_log_link_visit_action.time_dom_completion', 'MEDIUMINT(10) UNSIGNED NULL');... Done. [388 / 418]
  Executing INSERT IGNORE INTO `piwik_option` (option_name, option_value) VALUES ('version_log_link_visit_action.time_dom_processing', 'MEDIUMINT(10) UNSIGNED NULL');... Done. [389 / 418]
  Executing INSERT IGNORE INTO `piwik_option` (option_name, option_value) VALUES ('version_log_link_visit_action.time_network', 'MEDIUMINT(10) UNSIGNED NULL');... Done. [390 / 418]
  Executing INSERT IGNORE INTO `piwik_option` (option_name, option_value) VALUES ('version_log_link_visit_action.time_on_load', 'MEDIUMINT(10) UNSIGNED NULL');... Done. [391 / 418]
  Executing INSERT IGNORE INTO `piwik_option` (option_name, option_value) VALUES ('version_log_link_visit_action.time_server', 'MEDIUMINT(10) UNSIGNED NULL');... Done. [392 / 418]
  Executing INSERT IGNORE INTO `piwik_option` (option_name, option_value) VALUES ('version_log_link_visit_action.time_transfer', 'MEDIUMINT(10) UNSIGNED NULL');... Done. [393 / 418]
  Executing ALTER TABLE `piwik_log_visit` ADD COLUMN `visitor_seconds_since_first` INT(11) UNSIGNED NULL, ADD COLUMN `visitor_seconds_since_order` INT(11) UNSIGNED NULL, ADD COLUMN `visitor_seconds_since_last` INT(11) UNSIGNED NULL, ADD COLUMN `profilable` TINYINT(1) NULL;... Done. [394 / 418]
  Executing INSERT IGNORE INTO `piwik_option` (option_name, option_value) VALUES ('version_log_visit.visitor_seconds_since_first', 'INT(11) UNSIGNED NULL1');... Done. [395 / 418]
  Executing INSERT IGNORE INTO `piwik_option` (option_name, option_value) VALUES ('version_log_visit.visitor_seconds_since_order', 'INT(11) UNSIGNED NULL1');... Done. [396 / 418]
  Executing INSERT IGNORE INTO `piwik_option` (option_name, option_value) VALUES ('version_log_visit.visitor_seconds_since_last', 'INT(11) UNSIGNED NULL');... Done. [397 / 418]
  Executing INSERT IGNORE INTO `piwik_option` (option_name, option_value) VALUES ('version_log_visit.profilable', 'TINYINT(1) NULL');... Done. [398 / 418]
  Executing ALTER TABLE `piwik_log_conversion` ADD COLUMN `visitor_seconds_since_first` INT(11) UNSIGNED NULL, ADD COLUMN `visitor_seconds_since_order` INT(11) UNSIGNED NULL;... Done. [399 / 418]
  Executing INSERT IGNORE INTO `piwik_option` (option_name, option_value) VALUES ('version_log_conversion.visitor_seconds_since_first', 'INT(11) UNSIGNED NULL');... Done. [400 / 418]
  Executing INSERT IGNORE INTO `piwik_option` (option_name, option_value) VALUES ('version_log_conversion.visitor_seconds_since_order', 'INT(11) UNSIGNED NULL');... Done. [401 / 418]
  Executing UPDATE piwik_log_link_visit_action SET search_cat = if(custom_var_k4 = '_pk_scat', custom_var_v4, search_cat), search_count = if(custom_var_k5 = '_pk_scount', custom_var_v5, search_count) WHERE custom_var_k4 = '_pk_scat' or custom_var_k5 = '_pk_scount';... Done. [402 / 418]
  Executing DELETE FROM `piwik_option` WHERE option_name IN ("geoip.updater_period", "geoip.loc_db_url", "geoip.isp_db_url", "geoip.org_db_url");... Done. [403 / 418]
  Executing UPDATE piwik_log_visit SET visitor_seconds_since_first = visitor_days_since_first * 86400, 
                    visitor_seconds_since_order = visitor_days_since_order * 86400,
                    visitor_seconds_since_last = visitor_days_since_last * 86400;... 
    [X] Critical Error during the update process:

    * /var/www/html/core/Updates/4.0.0-b1.php:
    Error trying to execute the migration 'UPDATE piwik_log_visit SET visitor_seconds_since_first = visitor_days_since_first * 86400, 
                        visitor_seconds_since_order = visitor_days_since_order * 86400,
                        visitor_seconds_since_last = visitor_days_since_last * 86400;'.
    The error was: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'visitor_days_since_first' in 'field list'

    The above is the core error message. It should help explain the cause, but if you require further help please:

    * Check the [ Matomo FAQ ] which explains most common errors during update. 
    * Ask your system administrator - they may be able to help you with the error which is most likely related to your server or MySQL setup.

    If you are an advanced user and encounter an error in the database upgrade:

    * identify and correct the source of the problem (e.g., memory_limit or max_execution_time)
    * execute the remaining queries in the update that failed
    * manually update the `option` table in your Matomo database, setting the value of version_core to the version of the failed update
    * re-run the updater (through the browser or command-line) to continue with the remaining updates
    * report the problem (and solution) so that Matomo can be improved
ERROR [2020-12-02 11:49:43] 32  Uncaught exception: /var/www/html/plugins/CoreUpdater/Commands/Update.php(255): Matomo could not be updated! See above for more information.
Matomo could not be updated! See above for more information.


                                                                
  [RuntimeException]                                            
  Matomo could not be updated! See above for more information.  
                                                                


core:update [--yes]

@Bjoernsen
Copy link
Author

@sgiehl The second update worked. Matomo is running again. Thank you! 🎆

@tsteur tsteur added the answered For when a question was asked and we referred to forum or answered it. label Dec 2, 2020
@angristan
Copy link

I had the same issue, running the migration again (console core:update) fixed it.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
answered For when a question was asked and we referred to forum or answered it.
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
4 participants
@tsteur @sgiehl @Bjoernsen @angristan