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_visit.config_browser_name, log_visit.config_client_type, log_visit.location_region, log_visit.referer_name, log_visit.referer_url, log_visit.visit_total_interactions, log_visit.visitor_count_visits.
Important notes for large Matomo installations
If you have a large Matomo database, updates might take too long to run in the browser. In this situation, you can execute the updates from your command line:
php /home/carolina/public_html/analytics/console core:update
If you manage a high traffic Matomo server, we recommend to momentarily disable visitor Tracking and put the Matomo User Interface in maintenance mode.
FYI: these are the SQL queries and console commands that will be executed to upgrade your database to Matomo 4.4.1
› Click here to view and copy the list of SQL queries and console commands that will get executed
# These SQL queries will be executed:
ALTER TABLE `piwi_log_visit` 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, MODIFY COLUMN `location_region` char(3) DEFAULT NULL, MODIFY COLUMN `location_region` char(3) DEFAULT NULL;
ALTER TABLE `piwi_log_conversion` 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, MODIFY COLUMN `location_region` char(3) DEFAULT NULL;
ALTER TABLE `piwi_log_link_visit_action` 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;
Need help upgrading Matomo?
If you need support to upgrade your Matomo, the creators of Matomo are here to help you make the Matomo upgrade a success and provide all instructions, best practises and ongoing support. Contact the Matomo experts to get started upgrading your Matomo safely.
Ready to go?
The database upgrade process may take a while, so please be patient.
File integrity check failed and reported some errors. You should fix this issue and then refresh this page until it shows no error. |
Directories were found in your Matomo, but we didn't expect them. --> Please delete these directories to prevent errors. <-- Directory to delete: libs/Zend/Mail Directory to delete: libs/Zend/Validate Directory to delete: libs/bower_components Directory to delete: libs/jquery Directory to delete: vendor/container-interop Directory to delete: vendor/doctrine Directory to delete: vendor/leafo Directory to delete: vendor/matomo-org Directory to delete: vendor/php-di/php-di/src/DI Directory to delete: vendor/piwik Directory to delete: vendor/twig/twig/ext Directory to delete: vendor/twig/twig/lib To delete all these directories at once, you can run this command: rm -Rf /home/carolina/public_html/analytics/libs/Zend/Mail /home/carolina/public_html/analytics/libs/Zend/Validate /home/carolina/public_html/analytics/libs/bower_components /home/carolina/public_html/analytics/libs/jquery /home/carolina/public_html/analytics/vendor/container-interop /home/carolina/public_html/analytics/vendor/doctrine /home/carolina/public_html/analytics/vendor/leafo /home/carolina/public_html/analytics/vendor/matomo-org /home/carolina/public_html/analytics/vendor/php-di/php-di/src/DI /home/carolina/public_html/analytics/vendor/piwik /home/carolina/public_html/analytics/vendor/twig/twig/ext /home/carolina/public_html/analytics/vendor/twig/twig/lib |
Files were found in your Matomo, but we didn't expect them. --> Please delete these files to prevent errors. <-- File to delete: core/CronArchive/SegmentArchivingRequestUrlProvider.php File to delete: core/CronArchive/SitesToReprocessDistributedList.php File to delete: core/DataFiles/cacert.pem File to delete: core/DataTable/Renderer/Php.php File to delete: core/DeviceDetectorFactory.php File to delete: core/MetricsFormatter.php File to delete: core/Registry.php File to delete: core/ScheduledTask.php File to delete: core/TaskScheduler.php File to delete: core/Translate.php File to delete: libs/MaxMindGeoIP/geoip.inc File to delete: libs/MaxMindGeoIP/geoipcity.inc File to delete: libs/Zend/Mime.php File to delete: libs/Zend/Mime/Decode.php File to delete: libs/Zend/Mime/Exception.php File to delete: libs/Zend/Mime/Message.php File to delete: libs/Zend/Mime/Part.php File to delete: misc/others/ExamplePiwikTracker.php File to delete: misc/others/uninstall-delete-piwik-directory.php File to delete: plugins/API/Renderer/Json2.php File to delete: plugins/API/Renderer/Php.php File to delete: plugins/Actions/Columns/InteractionPosition.php File to delete: plugins/CoreHome/LoginWhitelist.php File to delete: plugins/CoreHome/angularjs/dialogtoggler/dialogtoggler-urllistener.service.js File to delete: plugins/CoreHome/angularjs/dialogtoggler/dialogtoggler.controller.js File to delete: plugins/CoreHome/angularjs/dialogtoggler/dialogtoggler.directive.js File to delete: plugins/CoreHome/angularjs/dialogtoggler/ngdialog.less File to delete: plugins/CoreHome/javascripts/donate.js File to delete: plugins/CoreHome/javascripts/iframeResizer.contentWindow.min.js File to delete: plugins/CoreHome/javascripts/iframeResizer.min.js File to delete: plugins/CoreUpdater/ReleaseChannel/Latest3XBeta.php File to delete: plugins/CoreUpdater/ReleaseChannel/Latest3XStable.php File to delete: plugins/CustomVariables/Columns/SearchCategory.php File to delete: plugins/DevicePlugins/Columns/PluginDirector.php File to delete: plugins/DevicePlugins/Columns/PluginGears.php File to delete: plugins/Diagnostics/Diagnostic/LoadDataInfileCheck.php File to delete: plugins/GeoIp2/Columns/Region.php File to delete: plugins/Morpheus/fonts/piwik.svg File to delete: plugins/Morpheus/fonts/piwik.ttf File to delete: plugins/Morpheus/fonts/piwik.woff File to delete: plugins/Morpheus/fonts/piwik.woff2 File to delete: plugins/Morpheus/images/paypal_subscribe.png File to delete: plugins/Morpheus/images/smileyprog_0.png File to delete: plugins/Morpheus/images/smileyprog_1.png File to delete: plugins/Morpheus/images/smileyprog_2.png File to delete: plugins/Morpheus/images/smileyprog_3.png File to delete: plugins/Morpheus/images/smileyprog_4.png File to delete: plugins/SegmentEditor/SegmentList.php File to delete: plugins/TagManager/Template/Variable/PreConfigured/FormDestionationVariable.php File to delete: plugins/UserCountry/Columns/Provider.php File to delete: plugins/UserCountry/GeoIPAutoUpdater.php File to delete: plugins/UserCountry/LocationProvider/GeoIp.php File to delete: plugins/UserCountry/LocationProvider/GeoIp/Pecl.php File to delete: plugins/UserCountry/LocationProvider/GeoIp/Php.php File to delete: plugins/UserCountry/LocationProvider/GeoIp/ServerBased.php File to delete: plugins/UserCountry/Tasks.php File to delete: plugins/UserCountry/angularjs/location-provider-updater/location-provider-updater.controller.js File to delete: plugins/UserCountry/angularjs/location-provider-updater/location-provider-updater.directive.js File to delete: plugins/UserCountry/templates/_updaterManage.twig File to delete: plugins/UserCountry/templates/_updaterNextRunTime.twig File to delete: plugins/VisitorInterest/Columns/VisitsByDaysSinceLastVisit.php File to delete: vendor/bin/lessc File to delete: vendor/matomo/referrer-spam-blacklist/CONTRIBUTING.md File to delete: vendor/matomo/referrer-spam-blacklist/README.md File to delete: vendor/matomo/referrer-spam-blacklist/spammers.txt File to delete: vendor/pear/archive_tar/docs/Archive_Tar.txt File to delete: vendor/php-di/invoker/doc/parameter-resolvers.md File to delete: vendor/php-di/php-di/phpbench.json File to delete: vendor/szymach/c-pchart/doc/2d_pie.md File to delete: vendor/szymach/c-pchart/doc/2d_ring.md File to delete: vendor/szymach/c-pchart/doc/3d_pie.md File to delete: vendor/szymach/c-pchart/doc/3d_ring.md File to delete: vendor/szymach/c-pchart/doc/area.md File to delete: vendor/szymach/c-pchart/doc/bar.md File to delete: vendor/szymach/c-pchart/doc/barcode_128.md File to delete: vendor/szymach/c-pchart/doc/barcode_39.md File to delete: vendor/szymach/c-pchart/doc/best_fit.md File to delete: vendor/szymach/c-pchart/doc/bubble.md File to delete: vendor/szymach/c-pchart/doc/cache.md File to delete: vendor/szymach/c-pchart/doc/contour.md File to delete: vendor/szymach/c-pchart/doc/filled_spline.md File to delete: vendor/szymach/c-pchart/doc/filled_step.md File to delete: vendor/szymach/c-pchart/doc/line.md File to delete: vendor/szymach/c-pchart/doc/plot.md File to delete: vendor/szymach/c-pchart/doc/polar.md File to delete: vendor/szymach/c-pchart/doc/progress.md File to delete: vendor/szymach/c-pchart/doc/radar.md File to delete: vendor/szymach/c-pchart/doc/scatter_best_fit.md File to delete: vendor/szymach/c-pchart/doc/scatter_line.md File to delete: vendor/szymach/c-pchart/doc/scatter_plot.md File to delete: vendor/szymach/c-pchart/doc/scatter_spline.md File to delete: vendor/szymach/c-pchart/doc/scatter_threshold.md File to delete: vendor/szymach/c-pchart/doc/scatter_threshold_area.md File to delete: vendor/szymach/c-pchart/doc/spline.md File to delete: vendor/szymach/c-pchart/doc/split_path.md File to delete: vendor/szymach/c-pchart/doc/spring.md File to delete: vendor/szymach/c-pchart/doc/stacked_area.md File to delete: vendor/szymach/c-pchart/doc/stacked_bar.md File to delete: vendor/szymach/c-pchart/doc/step.md File to delete: vendor/szymach/c-pchart/doc/stock.md File to delete: vendor/szymach/c-pchart/doc/surface.md File to delete: vendor/szymach/c-pchart/doc/zone.md File to delete: vendor/twig/twig/src/Extension/InitRuntimeInterface.php File to delete: vendor/twig/twig/src/Loader/ExistsLoaderInterface.php File to delete: vendor/twig/twig/src/Loader/SourceContextLoaderInterface.php File to delete: vendor/twig/twig/src/Node/SandboxedPrintNode.php File to delete: vendor/twig/twig/src/Node/SetTempNode.php File to delete: vendor/twig/twig/src/Node/SpacelessNode.php File to delete: vendor/twig/twig/src/TokenParser/FilterTokenParser.php File to delete: vendor/twig/twig/src/TokenParser/SpacelessTokenParser.php To delete all these files at once, you can run this command: rm "/home/carolina/public_html/analytics/core/CronArchive/SegmentArchivingRequestUrlProvider.php" "/home/carolina/public_html/analytics/core/CronArchive/SitesToReprocessDistributedList.php" "/home/carolina/public_html/analytics/core/DataFiles/cacert.pem" "/home/carolina/public_html/analytics/core/DataTable/Renderer/Php.php" "/home/carolina/public_html/analytics/core/DeviceDetectorFactory.php" "/home/carolina/public_html/analytics/core/MetricsFormatter.php" "/home/carolina/public_html/analytics/core/Registry.php" "/home/carolina/public_html/analytics/core/ScheduledTask.php" "/home/carolina/public_html/analytics/core/TaskScheduler.php" "/home/carolina/public_html/analytics/core/Translate.php" "/home/carolina/public_html/analytics/libs/MaxMindGeoIP/geoip.inc" "/home/carolina/public_html/analytics/libs/MaxMindGeoIP/geoipcity.inc" "/home/carolina/public_html/analytics/libs/Zend/Mime.php" "/home/carolina/public_html/analytics/libs/Zend/Mime/Decode.php" "/home/carolina/public_html/analytics/libs/Zend/Mime/Exception.php" "/home/carolina/public_html/analytics/libs/Zend/Mime/Message.php" "/home/carolina/public_html/analytics/libs/Zend/Mime/Part.php" "/home/carolina/public_html/analytics/misc/others/ExamplePiwikTracker.php" "/home/carolina/public_html/analytics/misc/others/uninstall-delete-piwik-directory.php" "/home/carolina/public_html/analytics/plugins/API/Renderer/Json2.php" "/home/carolina/public_html/analytics/plugins/API/Renderer/Php.php" "/home/carolina/public_html/analytics/plugins/Actions/Columns/InteractionPosition.php" "/home/carolina/public_html/analytics/plugins/CoreHome/LoginWhitelist.php" "/home/carolina/public_html/analytics/plugins/CoreHome/angularjs/dialogtoggler/dialogtoggler-urllistener.service.js" "/home/carolina/public_html/analytics/plugins/CoreHome/angularjs/dialogtoggler/dialogtoggler.controller.js" "/home/carolina/public_html/analytics/plugins/CoreHome/angularjs/dialogtoggler/dialogtoggler.directive.js" "/home/carolina/public_html/analytics/plugins/CoreHome/angularjs/dialogtoggler/ngdialog.less" "/home/carolina/public_html/analytics/plugins/CoreHome/javascripts/donate.js" "/home/carolina/public_html/analytics/plugins/CoreHome/javascripts/iframeResizer.contentWindow.min.js" "/home/carolina/public_html/analytics/plugins/CoreHome/javascripts/iframeResizer.min.js" "/home/carolina/public_html/analytics/plugins/CoreUpdater/ReleaseChannel/Latest3XBeta.php" "/home/carolina/public_html/analytics/plugins/CoreUpdater/ReleaseChannel/Latest3XStable.php" "/home/carolina/public_html/analytics/plugins/CustomVariables/Columns/SearchCategory.php" "/home/carolina/public_html/analytics/plugins/DevicePlugins/Columns/PluginDirector.php" "/home/carolina/public_html/analytics/plugins/DevicePlugins/Columns/PluginGears.php" "/home/carolina/public_html/analytics/plugins/Diagnostics/Diagnostic/LoadDataInfileCheck.php" "/home/carolina/public_html/analytics/plugins/GeoIp2/Columns/Region.php" "/home/carolina/public_html/analytics/plugins/Morpheus/fonts/piwik.svg" "/home/carolina/public_html/analytics/plugins/Morpheus/fonts/piwik.ttf" "/home/carolina/public_html/analytics/plugins/Morpheus/fonts/piwik.woff" "/home/carolina/public_html/analytics/plugins/Morpheus/fonts/piwik.woff2" "/home/carolina/public_html/analytics/plugins/Morpheus/images/paypal_subscribe.png" "/home/carolina/public_html/analytics/plugins/Morpheus/images/smileyprog_0.png" "/home/carolina/public_html/analytics/plugins/Morpheus/images/smileyprog_1.png" "/home/carolina/public_html/analytics/plugins/Morpheus/images/smileyprog_2.png" "/home/carolina/public_html/analytics/plugins/Morpheus/images/smileyprog_3.png" "/home/carolina/public_html/analytics/plugins/Morpheus/images/smileyprog_4.png" "/home/carolina/public_html/analytics/plugins/SegmentEditor/SegmentList.php" "/home/carolina/public_html/analytics/plugins/TagManager/Template/Variable/PreConfigured/FormDestionationVariable.php" "/home/carolina/public_html/analytics/plugins/UserCountry/Columns/Provider.php" rm "/home/carolina/public_html/analytics/plugins/UserCountry/GeoIPAutoUpdater.php" "/home/carolina/public_html/analytics/plugins/UserCountry/LocationProvider/GeoIp.php" "/home/carolina/public_html/analytics/plugins/UserCountry/LocationProvider/GeoIp/Pecl.php" "/home/carolina/public_html/analytics/plugins/UserCountry/LocationProvider/GeoIp/Php.php" "/home/carolina/public_html/analytics/plugins/UserCountry/LocationProvider/GeoIp/ServerBased.php" "/home/carolina/public_html/analytics/plugins/UserCountry/Tasks.php" "/home/carolina/public_html/analytics/plugins/UserCountry/angularjs/location-provider-updater/location-provider-updater.controller.js" "/home/carolina/public_html/analytics/plugins/UserCountry/angularjs/location-provider-updater/location-provider-updater.directive.js" "/home/carolina/public_html/analytics/plugins/UserCountry/templates/_updaterManage.twig" "/home/carolina/public_html/analytics/plugins/UserCountry/templates/_updaterNextRunTime.twig" "/home/carolina/public_html/analytics/plugins/VisitorInterest/Columns/VisitsByDaysSinceLastVisit.php" "/home/carolina/public_html/analytics/vendor/wikimedia/less.php/bin/lessc" "/home/carolina/public_html/analytics/vendor/matomo/referrer-spam-blacklist/CONTRIBUTING.md" "/home/carolina/public_html/analytics/vendor/matomo/referrer-spam-blacklist/README.md" "/home/carolina/public_html/analytics/vendor/matomo/referrer-spam-blacklist/spammers.txt" "/home/carolina/public_html/analytics/vendor/pear/archive_tar/docs/Archive_Tar.txt" "/home/carolina/public_html/analytics/vendor/php-di/invoker/doc/parameter-resolvers.md" "/home/carolina/public_html/analytics/vendor/php-di/php-di/phpbench.json" "/home/carolina/public_html/analytics/vendor/szymach/c-pchart/doc/2d_pie.md" "/home/carolina/public_html/analytics/vendor/szymach/c-pchart/doc/2d_ring.md" "/home/carolina/public_html/analytics/vendor/szymach/c-pchart/doc/3d_pie.md" "/home/carolina/public_html/analytics/vendor/szymach/c-pchart/doc/3d_ring.md" "/home/carolina/public_html/analytics/vendor/szymach/c-pchart/doc/area.md" "/home/carolina/public_html/analytics/vendor/szymach/c-pchart/doc/bar.md" "/home/carolina/public_html/analytics/vendor/szymach/c-pchart/doc/barcode_128.md" "/home/carolina/public_html/analytics/vendor/szymach/c-pchart/doc/barcode_39.md" "/home/carolina/public_html/analytics/vendor/szymach/c-pchart/doc/best_fit.md" "/home/carolina/public_html/analytics/vendor/szymach/c-pchart/doc/bubble.md" "/home/carolina/public_html/analytics/vendor/szymach/c-pchart/doc/cache.md" "/home/carolina/public_html/analytics/vendor/szymach/c-pchart/doc/contour.md" "/home/carolina/public_html/analytics/vendor/szymach/c-pchart/doc/filled_spline.md" "/home/carolina/public_html/analytics/vendor/szymach/c-pchart/doc/filled_step.md" "/home/carolina/public_html/analytics/vendor/szymach/c-pchart/doc/line.md" "/home/carolina/public_html/analytics/vendor/szymach/c-pchart/doc/plot.md" "/home/carolina/public_html/analytics/vendor/szymach/c-pchart/doc/polar.md" "/home/carolina/public_html/analytics/vendor/szymach/c-pchart/doc/progress.md" "/home/carolina/public_html/analytics/vendor/szymach/c-pchart/doc/radar.md" "/home/carolina/public_html/analytics/vendor/szymach/c-pchart/doc/scatter_best_fit.md" "/home/carolina/public_html/analytics/vendor/szymach/c-pchart/doc/scatter_line.md" "/home/carolina/public_html/analytics/vendor/szymach/c-pchart/doc/scatter_plot.md" "/home/carolina/public_html/analytics/vendor/szymach/c-pchart/doc/scatter_spline.md" "/home/carolina/public_html/analytics/vendor/szymach/c-pchart/doc/scatter_threshold.md" "/home/carolina/public_html/analytics/vendor/szymach/c-pchart/doc/scatter_threshold_area.md" "/home/carolina/public_html/analytics/vendor/szymach/c-pchart/doc/spline.md" "/home/carolina/public_html/analytics/vendor/szymach/c-pchart/doc/split_path.md" "/home/carolina/public_html/analytics/vendor/szymach/c-pchart/doc/spring.md" "/home/carolina/public_html/analytics/vendor/szymach/c-pchart/doc/stacked_area.md" "/home/carolina/public_html/analytics/vendor/szymach/c-pchart/doc/stacked_bar.md" "/home/carolina/public_html/analytics/vendor/szymach/c-pchart/doc/step.md" "/home/carolina/public_html/analytics/vendor/szymach/c-pchart/doc/stock.md" rm "/home/carolina/public_html/analytics/vendor/szymach/c-pchart/doc/surface.md" "/home/carolina/public_html/analytics/vendor/szymach/c-pchart/doc/zone.md" "/home/carolina/public_html/analytics/vendor/twig/twig/src/Extension/InitRuntimeInterface.php" "/home/carolina/public_html/analytics/vendor/twig/twig/src/Loader/ExistsLoaderInterface.php" "/home/carolina/public_html/analytics/vendor/twig/twig/src/Loader/SourceContextLoaderInterface.php" "/home/carolina/public_html/analytics/vendor/twig/twig/src/Node/SandboxedPrintNode.php" "/home/carolina/public_html/analytics/vendor/twig/twig/src/Node/SetTempNode.php" "/home/carolina/public_html/analytics/vendor/twig/twig/src/Node/SpacelessNode.php" "/home/carolina/public_html/analytics/vendor/twig/twig/src/TokenParser/FilterTokenParser.php" "/home/carolina/public_html/analytics/vendor/twig/twig/src/TokenParser/SpacelessTokenParser.php" |