Matomo database will be upgraded from version 4.4.1 to the new version 4.7.1.
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 /var/www/vhosts/hostingtastic.com/public_html/vigyananidhi.com/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.7.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 `mtek_session` CHANGE `data` `data` MEDIUMTEXT;
# These console commands will be run:
./console plugin:activate "CoreVue"
# These SQL queries will be executed:
ALTER TABLE `mtek_user` ADD COLUMN `idchange_last_viewed` INTEGER UNSIGNED NULL;
CREATE TABLE `mtek_changes` (`idchange` INT(11) NOT NULL AUTO_INCREMENT, `created_time` DATETIME NOT NULL, `plugin_name` VARCHAR(255) NOT NULL, `version` VARCHAR(20) NOT NULL, `title` VARCHAR(255) NOT NULL, `description` TEXT NOT NULL, `link_name` VARCHAR(255) NULL, `link` VARCHAR(255) NULL, PRIMARY KEY ( `idchange` )) ENGINE=InnoDB DEFAULT CHARSET=utf8;
ALTER TABLE `mtek_changes` CHANGE `plugin_name` `plugin_name` VARCHAR(60) NOT NULL;
ALTER TABLE `mtek_changes` DROP INDEX `unique_plugin_version_title`;
ALTER TABLE `mtek_changes` ADD UNIQUE KEY unique_plugin_version_title (`plugin_name`, `version`, `title` (100));
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. |
| Files were found in your Matomo, but we didn't expect them. --> Please delete these files to prevent errors. <-- File to delete: config/environment/test.php File to delete: config/environment/ui-test.php File to delete: core/Updates/2.2.0-b15.php File to delete: misc/others/uninstall-delete-piwik-directory.php File to delete: node_modules/mousetrap/mousetrap.sublime-project File to delete: node_modules/ng-dialog/yarn.lock File to delete: plugins/CoreAdminHome/angularjs/archiving/archiving.controller.js File to delete: plugins/CoreAdminHome/angularjs/branding/branding.controller.js File to delete: plugins/CoreAdminHome/angularjs/smtp/mail-smtp.controller.js File to delete: plugins/CoreAdminHome/angularjs/trackingcode/imagetrackingcode.controller.js File to delete: plugins/CoreAdminHome/angularjs/trackingcode/jstrackingcode.controller.js File to delete: plugins/CoreAdminHome/config/test.php File to delete: plugins/CoreHome/angularjs/ajax-form/ajax-form.controller.js File to delete: plugins/CoreHome/angularjs/ajax-form/ajax-form.directive.js File to delete: plugins/CoreHome/angularjs/common/directives/dropdown-button.js File to delete: plugins/CoreHome/angularjs/common/directives/select-on-focus.js File to delete: plugins/CoreHome/angularjs/common/directives/show-sensitive-data.js File to delete: plugins/CoreHome/angularjs/common/directives/side-nav.js File to delete: plugins/CoreHome/angularjs/common/services/report-metadata-model.js File to delete: plugins/CoreHome/angularjs/common/services/reporting-pages-model.js File to delete: plugins/CoreHome/angularjs/content-intro/content-intro.directive.js File to delete: plugins/CoreHome/angularjs/content-table/content-table.directive.js File to delete: plugins/CoreHome/angularjs/field-array/field-array.controller.js File to delete: plugins/CoreHome/angularjs/field-array/field-array.directive.html File to delete: plugins/CoreHome/angularjs/field-array/field-array.directive.js File to delete: plugins/CoreHome/angularjs/field-array/field-array.directive.less File to delete: plugins/CoreHome/angularjs/multipairfield/multipairfield.controller.js File to delete: plugins/CoreHome/angularjs/multipairfield/multipairfield.directive.html File to delete: plugins/CoreHome/angularjs/multipairfield/multipairfield.directive.js File to delete: plugins/CoreHome/angularjs/multipairfield/multipairfield.directive.less File to delete: plugins/CoreHome/angularjs/period-selector/period-selector.controller.js File to delete: plugins/CoreHome/angularjs/period-selector/period-selector.directive.html File to delete: plugins/CoreHome/angularjs/period-selector/period-selector.directive.js File to delete: plugins/CoreHome/angularjs/period-selector/period-selector.directive.less File to delete: plugins/CoreHome/angularjs/popover-handler/popover-handler.directive.js File to delete: plugins/CoreHome/angularjs/progressbar/progressbar.directive.html File to delete: plugins/CoreHome/angularjs/progressbar/progressbar.directive.js File to delete: plugins/CoreHome/angularjs/progressbar/progressbar.directive.less File to delete: plugins/CoreHome/angularjs/quick-access/quick-access.controller.js File to delete: plugins/CoreHome/angularjs/quick-access/quick-access.directive.html File to delete: plugins/CoreHome/angularjs/quick-access/quick-access.directive.js File to delete: plugins/CoreHome/angularjs/quick-access/quick-access.directive.less File to delete: plugins/CoreHome/angularjs/report-export/reportexport.directive.js File to delete: plugins/CoreHome/angularjs/report-export/reportexport.popover.html File to delete: plugins/CoreHome/angularjs/report-export/reportexport.popover.less File to delete: plugins/CoreHome/angularjs/reporting-menu/reportingmenu-model.js File to delete: plugins/CoreHome/angularjs/reporting-menu/reportingmenu.controller.js File to delete: plugins/CoreHome/angularjs/reporting-menu/reportingmenu.directive.html File to delete: plugins/CoreHome/angularjs/reporting-menu/reportingmenu.directive.js File to delete: plugins/CoreHome/angularjs/reporting-page/reportingpage-model.js File to delete: plugins/CoreHome/angularjs/reporting-page/reportingpage.controller.js File to delete: plugins/CoreHome/angularjs/reporting-page/reportingpage.directive.html File to delete: plugins/CoreHome/angularjs/reporting-page/reportingpage.directive.js File to delete: plugins/CoreHome/angularjs/reporting-page/reportingpage.directive.less File to delete: plugins/CoreHome/angularjs/siteselector/siteselector-model.service.js File to delete: plugins/CoreHome/angularjs/siteselector/siteselector.controller.js File to delete: plugins/CoreHome/angularjs/siteselector/siteselector.directive.html File to delete: plugins/CoreHome/angularjs/siteselector/siteselector.directive.js File to delete: plugins/CoreHome/angularjs/siteselector/siteselector.directive.less File to delete: plugins/CoreHome/angularjs/sparkline/sparkline.component.js File to delete: plugins/CoreHome/angularjs/sparkline/sparkline.component.less File to delete: plugins/CoreHome/angularjs/widget-bydimension-container/widget-bydimension-container.directive.html File to delete: plugins/CoreHome/angularjs/widget-bydimension-container/widget-bydimension-container.directive.js File to delete: plugins/CoreHome/angularjs/widget-bydimension-container/widget-bydimension-container.directive.less File to delete: plugins/CoreHome/angularjs/widget-container/widgetcontainer.directive.html File to delete: plugins/CoreHome/angularjs/widget-container/widgetcontainer.directive.js File to delete: plugins/CoreHome/angularjs/widget-loader/widgetloader.directive.html File to delete: plugins/CoreHome/angularjs/widget-loader/widgetloader.directive.js File to delete: plugins/CoreHome/config/test.php File to delete: plugins/CorePluginsAdmin/config/test.php File to delete: plugins/DBStats/config/test.php File to delete: plugins/GeoIp2/config/test.php File to delete: plugins/Login/config/test.php File to delete: plugins/Marketplace/config/test.php File to delete: plugins/Overlay/config/ui-test.php File to delete: plugins/ProfessionalServices/config/test.php File to delete: plugins/SEO/config/ui-test.php File to delete: plugins/TagManager/config/test.php File to delete: plugins/Tour/config/test.php File to delete: plugins/TwoFactorAuth/config/test.php File to delete: vendor/geoip2/geoip2/examples/benchmark.php File to delete: vendor/matomo/device-detector/phpstan.neon File to delete: vendor/maxmind-db/reader/package.xml File to delete: vendor/pear/archive_tar/package.xml File to delete: vendor/pear/console_getopt/package.xml File to delete: vendor/szymach/c-pchart/codeception.yml File to delete: vendor/szymach/c-pchart/coverage.sh File to delete: vendor/tecnickcom/tcpdf/tools/convert_fonts_examples.txt File to delete: vendor/tecnickcom/tcpdf/tools/tcpdf_addfont.php File to delete: node_modules/chroma-js/.npmignore File to delete: node_modules/iframe-resizer/.ncurc.json File to delete: node_modules/iframe-resizer/.prettierrc File to delete: node_modules/jquery.browser/.npmignore File to delete: node_modules/jquery.scrollto/.jscsrc File to delete: node_modules/jquery.scrollto/.npmignore File to delete: node_modules/ng-dialog/.npmignore File to delete: node_modules/qrcodejs2/.npmignore File to delete: vendor/matomo/device-detector/.yamllint To delete all these files at once, you can run this command: rm "/var/www/vhosts/hostingtastic.com/public_html/vigyananidhi.com/config/environment/test.php" "/var/www/vhosts/hostingtastic.com/public_html/vigyananidhi.com/config/environment/ui-test.php" "/var/www/vhosts/hostingtastic.com/public_html/vigyananidhi.com/core/Updates/2.2.0-b15.php" "/var/www/vhosts/hostingtastic.com/public_html/vigyananidhi.com/misc/others/uninstall-delete-piwik-directory.php" "/var/www/vhosts/hostingtastic.com/public_html/vigyananidhi.com/node_modules/mousetrap/mousetrap.sublime-project" "/var/www/vhosts/hostingtastic.com/public_html/vigyananidhi.com/node_modules/ng-dialog/yarn.lock" "/var/www/vhosts/hostingtastic.com/public_html/vigyananidhi.com/plugins/CoreAdminHome/angularjs/archiving/archiving.controller.js" "/var/www/vhosts/hostingtastic.com/public_html/vigyananidhi.com/plugins/CoreAdminHome/angularjs/branding/branding.controller.js" "/var/www/vhosts/hostingtastic.com/public_html/vigyananidhi.com/plugins/CoreAdminHome/angularjs/smtp/mail-smtp.controller.js" "/var/www/vhosts/hostingtastic.com/public_html/vigyananidhi.com/plugins/CoreAdminHome/angularjs/trackingcode/imagetrackingcode.controller.js" "/var/www/vhosts/hostingtastic.com/public_html/vigyananidhi.com/plugins/CoreAdminHome/angularjs/trackingcode/jstrackingcode.controller.js" "/var/www/vhosts/hostingtastic.com/public_html/vigyananidhi.com/plugins/CoreAdminHome/config/test.php" "/var/www/vhosts/hostingtastic.com/public_html/vigyananidhi.com/plugins/CoreHome/angularjs/ajax-form/ajax-form.controller.js" "/var/www/vhosts/hostingtastic.com/public_html/vigyananidhi.com/plugins/CoreHome/angularjs/ajax-form/ajax-form.directive.js" "/var/www/vhosts/hostingtastic.com/public_html/vigyananidhi.com/plugins/CoreHome/angularjs/common/directives/dropdown-button.js" "/var/www/vhosts/hostingtastic.com/public_html/vigyananidhi.com/plugins/CoreHome/angularjs/common/directives/select-on-focus.js" "/var/www/vhosts/hostingtastic.com/public_html/vigyananidhi.com/plugins/CoreHome/angularjs/common/directives/show-sensitive-data.js" "/var/www/vhosts/hostingtastic.com/public_html/vigyananidhi.com/plugins/CoreHome/angularjs/common/directives/side-nav.js" "/var/www/vhosts/hostingtastic.com/public_html/vigyananidhi.com/plugins/CoreHome/angularjs/common/services/report-metadata-model.js" "/var/www/vhosts/hostingtastic.com/public_html/vigyananidhi.com/plugins/CoreHome/angularjs/common/services/reporting-pages-model.js" "/var/www/vhosts/hostingtastic.com/public_html/vigyananidhi.com/plugins/CoreHome/angularjs/content-intro/content-intro.directive.js" "/var/www/vhosts/hostingtastic.com/public_html/vigyananidhi.com/plugins/CoreHome/angularjs/content-table/content-table.directive.js" "/var/www/vhosts/hostingtastic.com/public_html/vigyananidhi.com/plugins/CoreHome/angularjs/field-array/field-array.controller.js" "/var/www/vhosts/hostingtastic.com/public_html/vigyananidhi.com/plugins/CoreHome/angularjs/field-array/field-array.directive.html" "/var/www/vhosts/hostingtastic.com/public_html/vigyananidhi.com/plugins/CoreHome/angularjs/field-array/field-array.directive.js" "/var/www/vhosts/hostingtastic.com/public_html/vigyananidhi.com/plugins/CoreHome/angularjs/field-array/field-array.directive.less" "/var/www/vhosts/hostingtastic.com/public_html/vigyananidhi.com/plugins/CoreHome/angularjs/multipairfield/multipairfield.controller.js" "/var/www/vhosts/hostingtastic.com/public_html/vigyananidhi.com/plugins/CoreHome/angularjs/multipairfield/multipairfield.directive.html" "/var/www/vhosts/hostingtastic.com/public_html/vigyananidhi.com/plugins/CoreHome/angularjs/multipairfield/multipairfield.directive.js" "/var/www/vhosts/hostingtastic.com/public_html/vigyananidhi.com/plugins/CoreHome/angularjs/multipairfield/multipairfield.directive.less" "/var/www/vhosts/hostingtastic.com/public_html/vigyananidhi.com/plugins/CoreHome/angularjs/period-selector/period-selector.controller.js" "/var/www/vhosts/hostingtastic.com/public_html/vigyananidhi.com/plugins/CoreHome/angularjs/period-selector/period-selector.directive.html" "/var/www/vhosts/hostingtastic.com/public_html/vigyananidhi.com/plugins/CoreHome/angularjs/period-selector/period-selector.directive.js" "/var/www/vhosts/hostingtastic.com/public_html/vigyananidhi.com/plugins/CoreHome/angularjs/period-selector/period-selector.directive.less" "/var/www/vhosts/hostingtastic.com/public_html/vigyananidhi.com/plugins/CoreHome/angularjs/popover-handler/popover-handler.directive.js" "/var/www/vhosts/hostingtastic.com/public_html/vigyananidhi.com/plugins/CoreHome/angularjs/progressbar/progressbar.directive.html" "/var/www/vhosts/hostingtastic.com/public_html/vigyananidhi.com/plugins/CoreHome/angularjs/progressbar/progressbar.directive.js" "/var/www/vhosts/hostingtastic.com/public_html/vigyananidhi.com/plugins/CoreHome/angularjs/progressbar/progressbar.directive.less" "/var/www/vhosts/hostingtastic.com/public_html/vigyananidhi.com/plugins/CoreHome/angularjs/quick-access/quick-access.controller.js" "/var/www/vhosts/hostingtastic.com/public_html/vigyananidhi.com/plugins/CoreHome/angularjs/quick-access/quick-access.directive.html" "/var/www/vhosts/hostingtastic.com/public_html/vigyananidhi.com/plugins/CoreHome/angularjs/quick-access/quick-access.directive.js" "/var/www/vhosts/hostingtastic.com/public_html/vigyananidhi.com/plugins/CoreHome/angularjs/quick-access/quick-access.directive.less" "/var/www/vhosts/hostingtastic.com/public_html/vigyananidhi.com/plugins/CoreHome/angularjs/report-export/reportexport.directive.js" "/var/www/vhosts/hostingtastic.com/public_html/vigyananidhi.com/plugins/CoreHome/angularjs/report-export/reportexport.popover.html" "/var/www/vhosts/hostingtastic.com/public_html/vigyananidhi.com/plugins/CoreHome/angularjs/report-export/reportexport.popover.less" "/var/www/vhosts/hostingtastic.com/public_html/vigyananidhi.com/plugins/CoreHome/angularjs/reporting-menu/reportingmenu-model.js" "/var/www/vhosts/hostingtastic.com/public_html/vigyananidhi.com/plugins/CoreHome/angularjs/reporting-menu/reportingmenu.controller.js" "/var/www/vhosts/hostingtastic.com/public_html/vigyananidhi.com/plugins/CoreHome/angularjs/reporting-menu/reportingmenu.directive.html" "/var/www/vhosts/hostingtastic.com/public_html/vigyananidhi.com/plugins/CoreHome/angularjs/reporting-menu/reportingmenu.directive.js" "/var/www/vhosts/hostingtastic.com/public_html/vigyananidhi.com/plugins/CoreHome/angularjs/reporting-page/reportingpage-model.js" rm "/var/www/vhosts/hostingtastic.com/public_html/vigyananidhi.com/plugins/CoreHome/angularjs/reporting-page/reportingpage.controller.js" "/var/www/vhosts/hostingtastic.com/public_html/vigyananidhi.com/plugins/CoreHome/angularjs/reporting-page/reportingpage.directive.html" "/var/www/vhosts/hostingtastic.com/public_html/vigyananidhi.com/plugins/CoreHome/angularjs/reporting-page/reportingpage.directive.js" "/var/www/vhosts/hostingtastic.com/public_html/vigyananidhi.com/plugins/CoreHome/angularjs/reporting-page/reportingpage.directive.less" "/var/www/vhosts/hostingtastic.com/public_html/vigyananidhi.com/plugins/CoreHome/angularjs/siteselector/siteselector-model.service.js" "/var/www/vhosts/hostingtastic.com/public_html/vigyananidhi.com/plugins/CoreHome/angularjs/siteselector/siteselector.controller.js" "/var/www/vhosts/hostingtastic.com/public_html/vigyananidhi.com/plugins/CoreHome/angularjs/siteselector/siteselector.directive.html" "/var/www/vhosts/hostingtastic.com/public_html/vigyananidhi.com/plugins/CoreHome/angularjs/siteselector/siteselector.directive.js" "/var/www/vhosts/hostingtastic.com/public_html/vigyananidhi.com/plugins/CoreHome/angularjs/siteselector/siteselector.directive.less" "/var/www/vhosts/hostingtastic.com/public_html/vigyananidhi.com/plugins/CoreHome/angularjs/sparkline/sparkline.component.js" "/var/www/vhosts/hostingtastic.com/public_html/vigyananidhi.com/plugins/CoreHome/angularjs/sparkline/sparkline.component.less" "/var/www/vhosts/hostingtastic.com/public_html/vigyananidhi.com/plugins/CoreHome/angularjs/widget-bydimension-container/widget-bydimension-container.directive.html" "/var/www/vhosts/hostingtastic.com/public_html/vigyananidhi.com/plugins/CoreHome/angularjs/widget-bydimension-container/widget-bydimension-container.directive.js" "/var/www/vhosts/hostingtastic.com/public_html/vigyananidhi.com/plugins/CoreHome/angularjs/widget-bydimension-container/widget-bydimension-container.directive.less" "/var/www/vhosts/hostingtastic.com/public_html/vigyananidhi.com/plugins/CoreHome/angularjs/widget-container/widgetcontainer.directive.html" "/var/www/vhosts/hostingtastic.com/public_html/vigyananidhi.com/plugins/CoreHome/angularjs/widget-container/widgetcontainer.directive.js" "/var/www/vhosts/hostingtastic.com/public_html/vigyananidhi.com/plugins/CoreHome/angularjs/widget-loader/widgetloader.directive.html" "/var/www/vhosts/hostingtastic.com/public_html/vigyananidhi.com/plugins/CoreHome/angularjs/widget-loader/widgetloader.directive.js" "/var/www/vhosts/hostingtastic.com/public_html/vigyananidhi.com/plugins/CoreHome/config/test.php" "/var/www/vhosts/hostingtastic.com/public_html/vigyananidhi.com/plugins/CorePluginsAdmin/config/test.php" "/var/www/vhosts/hostingtastic.com/public_html/vigyananidhi.com/plugins/DBStats/config/test.php" "/var/www/vhosts/hostingtastic.com/public_html/vigyananidhi.com/plugins/GeoIp2/config/test.php" "/var/www/vhosts/hostingtastic.com/public_html/vigyananidhi.com/plugins/Login/config/test.php" "/var/www/vhosts/hostingtastic.com/public_html/vigyananidhi.com/plugins/Marketplace/config/test.php" "/var/www/vhosts/hostingtastic.com/public_html/vigyananidhi.com/plugins/Overlay/config/ui-test.php" "/var/www/vhosts/hostingtastic.com/public_html/vigyananidhi.com/plugins/ProfessionalServices/config/test.php" "/var/www/vhosts/hostingtastic.com/public_html/vigyananidhi.com/plugins/SEO/config/ui-test.php" "/var/www/vhosts/hostingtastic.com/public_html/vigyananidhi.com/plugins/TagManager/config/test.php" "/var/www/vhosts/hostingtastic.com/public_html/vigyananidhi.com/plugins/Tour/config/test.php" "/var/www/vhosts/hostingtastic.com/public_html/vigyananidhi.com/plugins/TwoFactorAuth/config/test.php" "/var/www/vhosts/hostingtastic.com/public_html/vigyananidhi.com/vendor/geoip2/geoip2/examples/benchmark.php" "/var/www/vhosts/hostingtastic.com/public_html/vigyananidhi.com/vendor/matomo/device-detector/phpstan.neon" "/var/www/vhosts/hostingtastic.com/public_html/vigyananidhi.com/vendor/maxmind-db/reader/package.xml" "/var/www/vhosts/hostingtastic.com/public_html/vigyananidhi.com/vendor/pear/archive_tar/package.xml" "/var/www/vhosts/hostingtastic.com/public_html/vigyananidhi.com/vendor/pear/console_getopt/package.xml" "/var/www/vhosts/hostingtastic.com/public_html/vigyananidhi.com/vendor/szymach/c-pchart/codeception.yml" "/var/www/vhosts/hostingtastic.com/public_html/vigyananidhi.com/vendor/szymach/c-pchart/coverage.sh" "/var/www/vhosts/hostingtastic.com/public_html/vigyananidhi.com/vendor/tecnickcom/tcpdf/tools/convert_fonts_examples.txt" "/var/www/vhosts/hostingtastic.com/public_html/vigyananidhi.com/vendor/tecnickcom/tcpdf/tools/tcpdf_addfont.php" "/var/www/vhosts/hostingtastic.com/public_html/vigyananidhi.com/node_modules/chroma-js/.npmignore" "/var/www/vhosts/hostingtastic.com/public_html/vigyananidhi.com/node_modules/iframe-resizer/.ncurc.json" "/var/www/vhosts/hostingtastic.com/public_html/vigyananidhi.com/node_modules/iframe-resizer/.prettierrc" "/var/www/vhosts/hostingtastic.com/public_html/vigyananidhi.com/node_modules/jquery.browser/.npmignore" "/var/www/vhosts/hostingtastic.com/public_html/vigyananidhi.com/node_modules/jquery.scrollto/.jscsrc" "/var/www/vhosts/hostingtastic.com/public_html/vigyananidhi.com/node_modules/jquery.scrollto/.npmignore" "/var/www/vhosts/hostingtastic.com/public_html/vigyananidhi.com/node_modules/ng-dialog/.npmignore" "/var/www/vhosts/hostingtastic.com/public_html/vigyananidhi.com/node_modules/qrcodejs2/.npmignore" "/var/www/vhosts/hostingtastic.com/public_html/vigyananidhi.com/vendor/matomo/device-detector/.yamllint" |
| Errors below may be due to a partial or failed upload of Matomo files. |
| --> Try to reupload all the Matomo files in BINARY mode. <-- |
| File size mismatch: /var/www/vhosts/hostingtastic.com/public_html/vigyananidhi.com/misc/others/tracker_simpleImageTracker.php (expected length: 1053, found: 0) |