• Resolved imaenigma

    (@imaenigma)


    Hi,
    when i try to install the plugin in wordpress i get this error:

    Versione di WordPress 6.0.3
    Tema attivo: Pro Voice Blog (versione 1.3.1)
    Plugin corrente: Matomo Analytics - Ethical Stats. Powerful Insights. (versione 4.11.0)
    Versione PHP 7.3.33
    
    Dettagli dell'errore
    ====================
    Un errore di E_ERROR è stato causato nella linea 407 del file /membri/vincenzopisapia/wp-content/plugins/matomo/classes/WpMatomo/Db/WordPress.php. Messaggio di errore: Uncaught Zend_Db_Statement_Exception: WP DB Error: [1286] Unknown storage engine 'InnoDB' SQL: CREATE TABLE avwp_matomo_user (
                              login VARCHAR(100) NOT NULL,
                              password VARCHAR(255) NOT NULL,
                              email VARCHAR(100) NOT NULL,
                              twofactor_secret VARCHAR(40) NOT NULL DEFAULT '',
                              superuser_access TINYINT(2) unsigned NOT NULL DEFAULT '0',
                              date_registered TIMESTAMP NULL,
                              ts_password_modified TIMESTAMP NULL,
                              idchange_last_viewed TIMESTAMP NULL,
                              invited_by VARCHAR(100) NULL,
                              invite_token VARCHAR(191) NULL,
                              invite_expired_at TIMESTAMP NULL,
                              invite_accept_at TIMESTAMP NULL,
                                PRIMARY KEY(login)
                              ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
                 in /membri/vincenzopisapi

    I also point out that the installation of the plugin on the same version of the site locally does not generate errors and is successful.
    I checked the list of incompatible plugins and none of them are installed on my site.
    Thanks

    The page I need help with: [log in to see the link]

Viewing 5 replies - 1 through 5 (of 5 total)
  • Hello @imaenigma

    Sorry to hear that you encounter some issue with our plugin.

    The problem is we do not manage MyISAM installation for now. There is an open issue for that: https://github.com/matomo-org/matomo-for-wordpress/issues/558

    Are you familiar with editing files?

    Kind regards

    Mat

    Thread Starter imaenigma

    (@imaenigma)

    Ciao,
    first of all thanks for the feedback.

    I’m not an expert but I should be able to make changes to the files if you tell me what to fix.
    (hoping that the problem doesn’t recur with every plugin update)

    However, if a corrective release is planned in the next versions, patience, I can wait.

    Hi @imaenigma

    You have two options then:
    Either edit this file https://github.com/matomo-org/matomo-for-wordpress/blob/4.5.0/classes/WpMatomo/Installer.php#L340-L349 to add another line
    "type" => "MyISAM"
    but you’ll have to redo it each time you upgrade the plugin,

    or,

    you can ask your hosting provider to support InnoDB. It’s quite strange that they do not allow it, as this is a common one. Would you mind tell me who is your hosting provider? I’ll update our FAQ.

    Kind regards

    Mat

    Thread Starter imaenigma

    (@imaenigma)

    Hi,
    THANK YOU very much for your help, I managed to fix it and with the change to the “installer.php” file now the plugin is up and running on my site.

    In the meantime, I have also reported it to my hosting to see if it can be resolved or if I will have to make this small change with each update.

    My hosting is Altervista (AlterBlog wordpress version)

    Link: https://it.altervista.org/caratteristiche-hosting-wordpress-gestito.php

    If I have any new information, I will update this post again, hoping to do something useful for your FAQ

    Hi @imaenigma

    Glad to see my explanation and fixes solve your issue.

    I’ll close this support topic now. But indeed, feel free to update it, as any updates will come.

    Our hosting FAQ is not published yet, but thanks for your hosting name: Will add it in our list, until we find a solution to solve this problem.

    Happy Analytics.

    Kind regards

    Mat

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

The topic ‘Critical WP Error, installation fail’ is closed to new replies.