The following plugins will be updated: BotTracker.
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/schulverwalter.de/analytics.schulverwalter.de/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 5.0.2
› 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 `bot_db` ADD COLUMN `botType` TINYINT(0) UNSIGNED NULL DEFAULT 0;
ALTER TABLE `bot_db` CHANGE `botName` `botName` VARCHAR(256);
ALTER TABLE `bot_db` CHANGE `botKeyword` `botKeyword` VARCHAR(256);
ALTER TABLE `bot_db_stat` CHANGE `page` `page` VARCHAR(256);
ALTER TABLE `bot_db_stat` CHANGE `useragent` `useragent` VARCHAR(256);
CREATE TABLE `bot_visits` (`id` bigint unsigned NOT NULL AUTO_INCREMENT, `botId` INT UNSIGNED, `idsite` INT UNSIGNED, `date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY ( `id` )) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
CREATE TABLE `bot_type` (`id` INT(11) NOT NULL AUTO_INCREMENT, `name` VARCHAR(256) NOT NULL, `date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY ( `id` )) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
INSERT INTO `bot_type` (`name`) VALUES ('Monitoring & Analytics');
INSERT INTO `bot_type` (`name`) VALUES ('Search Engine Optimization');
INSERT INTO `bot_type` (`name`) VALUES ('Advertising & Marketing');
INSERT INTO `bot_type` (`name`) VALUES ('Page Preview');
INSERT INTO `bot_type` (`name`) VALUES ('Webhook');
INSERT INTO `bot_type` (`name`) VALUES ('Social network');
INSERT INTO `bot_type` (`name`) VALUES ('Scraper');
INSERT INTO `bot_type` (`name`) VALUES ('Copyright');
INSERT INTO `bot_type` (`name`) VALUES ('Search Engine Crawler');
INSERT INTO `bot_type` (`name`) VALUES ('AI Search Crawler');
INSERT INTO `bot_type` (`name`) VALUES ('AI Data Scraper');
INSERT INTO `bot_type` (`name`) VALUES ('AI Assistant');
INSERT INTO `bot_type` (`name`) VALUES ('Other');
CREATE TABLE `bot_device_detector_bots` (`id` INT(11) NOT NULL AUTO_INCREMENT, `idsite` INT UNSIGNED, `useragent` VARCHAR(256) NOT NULL, `date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY ( `id` )) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
ALTER TABLE `bot_type` CHANGE `name` `name` VARCHAR(256);
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.
Details
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: logs File to delete: piwik.min.js File to delete: .php-ini File to delete: .php-version
To delete all these files at once, you can run this command: rm "/var/www/vhosts/schulverwalter.de/analytics.schulverwalter.de/config/environment/test.php" "/var/www/vhosts/schulverwalter.de/analytics.schulverwalter.de/config/environment/ui-test.php" "/var/www/vhosts/schulverwalter.de/analytics.schulverwalter.de/logs" "/var/www/vhosts/schulverwalter.de/analytics.schulverwalter.de/piwik.min.js" "/var/www/vhosts/schulverwalter.de/analytics.schulverwalter.de/.php-ini" "/var/www/vhosts/schulverwalter.de/analytics.schulverwalter.de/.php-version"
|