• Resolved marcheteatro

    (@marcheteatro)


    HI,

    we had an issue after the last update (front end is running but dashboard is unaccessible),

    error details

    ====================

    Un errore di E_ERROR è stato causato nella linea 1139 del file /web/htdocs/www.marcheteatro.it/home/wp-content/plugins/matomo/app/core/Plugin/Manager.php. Messaggio di errore: Uncaught Piwik\Plugin\PluginException: There was a problem installing the plugin BotTracking:                 WP DB Error: [1067] Invalid default value for 'created_time' SQL: CREATE TABLE IF NOT EXISTS mtwp_matomo_log_bot_request (             idrequest BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,            idsite INT UNSIGNED NOT NULL,            server_time DATETIME NOT NULL,            created_time DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,            idaction_url INT UNSIGNED NULL,            bot_name VARCHAR(100) NOT NULL,            bot_type VARCHAR(50) NOT NULL,            http_status_code SMALLINT UNSIGNED NULL,            response_size_bytes INT UNSIGNED NULL,            response_time_ms INT UNSIGNED NULL,            source VARCHAR(50) NULL,            PRIMARY KEY (idrequest),            INDEX index_idsite_server_time (idsite, server_time) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Support dizzyatinnocraft

    (@dizzyatinnocraft)

    Hi @marcheteatro, can you tell me what database and database version your website is using?

    Thread Starter marcheteatro

    (@marcheteatro)

    yes of course,

    MySQL, server version 5.5.61-38.13-log, client version mysqlnd 7.4.3.

    a detail may probably be useful for you: we have a third level domain with the same database, theme, and the matomo plugin aswell, but the theme version is not the latest; in our main site the problem occurred after the matomo update and the theme was updated just a few days before.

    Plugin Support dizzyatinnocraft

    (@dizzyatinnocraft)

    It looks like the MySQL version being used is just a little too old. MySQL is erroring on the CURRENT_TIMESTAMP default value, a feature that was added in 5.6.5. Are you able to upgrade your MySQL?

    Thread Starter marcheteatro

    (@marcheteatro)

    MySQL update solved the issue.

    Many thanks for your help.

    Plugin Support dizzyatinnocraft

    (@dizzyatinnocraft)

    Glad to hear the issue is resolved, let us know if there’s anything else you need help with.

Viewing 5 replies - 1 through 5 (of 5 total)

You must be logged in to reply to this topic.