activation Problem Critical DB error

  • Resolved liam239

    (@liam239)


    6 years, 1 month ago

    Hi,

    I want to install and activate Matomo. Install trough the plugin page is no problem. But when i activate I get Critical DB “error: WordPress databasefout: [Table ‘xxxxxxxx_xxx.wpxx_matomo_option’ doesn’t exist]
    SELECT option_value, option_name FROM wpxxx_matomo_option WHERE autoload = 1

    Fatal error: Uncaught Zend_Db_Statement_Exception: WP DB Error: [1146] Table ‘xxxxxxxxx_xxxxxxx.wpxxx_matomo_option’ doesn’t exist SQL: SELECT option_value, option_name FROM ….” (Short copy & Past, where xxx is database name).

    I have seen that some other people have the same issue. I can’t get into my WP Admin because of the error. I had the in December install by .Zip (from the Matomo Website), I think the beta. We removed the site with WP_Reset because we are working on a completely a new website.

    It is always possible that there was some DB left (I don’t know for sure). I did remove Matomo completely by following the steps Manually delete all data page. Tried it again. Same issue. Now I see in the DB, that there is no new creation after the second installation. Is it possible that there is a bug or install error in creating the DB?

    No Wordfence plugin installed

    Already Thanks,
    King Regards,

    Liam

Viewing 11 replies - 1 through 11 (of 11 total)
  • Plugin Author Thomas

    (@tsteur)

    6 years, 1 month ago

    Hi Liam,

    I see you already checked out all our FAQs which is great, thanks for making the effort, very appreciated 🙂

    First of all, could you maybe check if there’s a file in wp-content/uploads/matomo/config.ini.php?

    Basically, we trigger the installation if/when this file is missing. I suppose you deleted this file during the manual deletion of all data which is great. I suppose it was now recreated? You could probably try and remove this file to see what happens when you open the WordPress admin dashboard afterwards. It might successfully re-install.

    Be also good to check if there are any Matomo tables still installed ? A SQL query like show tables like 'wp_matomo_%' would show you that (assuming your WordPress prefix is wp_).

    Could you otherwise send us your system report? Either here or to our email: wordpress at matomo dot org?

    Thread Starter liam239

    (@liam239)

    6 years, 1 month ago

    Hi,

    Thanks for the fast respons.

    I double checked the DB. I was able to find some in wp_options. But everything els was deleted. This was no difference, and I did get the same error after I tried a new installation of Matomo again.

    I then check the other thing about the config file. I checked wp-content/uploads/matomo/config.ini.php.
    And there was the problem. That file was in this directory wp-content/uploads/matomo/config/config.ini.php and not in wp-content/uploads/matomo/

    I moved the file to wp-content/uploads/matomo/ and reloaded the page. And lucky it worked.

    Is it then possible that there is a fault in the installation file? That it installs that file on the wrong place?

    Just to double check: There is also an .htaccess file in the wp-content/uploads/matomo/config/ folder. Is that file on the right place or is it also necessary in the wp-content/uploads/matomo/ folder?

    Thanks again,
    Kind Regards,

    Liam

    Plugin Author Thomas

    (@tsteur)

    6 years, 1 month ago

    Actually, with wp-content/uploads/matomo/config.ini.php I gave you the wrong path. It was supposed to be wp-content/uploads/matomo/config/config.ini.php.

    So what happened is that this file maybe still existed from the original install and therefore Matomo thought it was already installed. When you moved the file, Matomo realised it wasn’t installed yet and installed it.

    > Just to double check: There is also an .htaccess file in the wp-content/uploads/matomo/config/ folder.

    Yes this .htaccess is expected and correct. There should be also additionally one in the matomo folder directly. If it doesn’t exist just yet, it may be automatically created in the future.

    I hope this helps?

    I’m glad it works now @liam239 and apologies for the trouble you had.

    Thread Starter liam239

    (@liam239)

    6 years, 1 month ago

    Hi,

    I was to fast.

    The installation was now a succes, but Matomo doesn’t work 🙁 . When I try to do something in Matomo (visiting reports or going in settings and press in Privacy/GDPR on one of those links) everything gives a “A fatal error occurred” .

    Reinstall no solution.
    I will send the System report to you by mail.

    EDIT: I have double check and because of the reinstall (I think) it has now a file in both folders, also .htaccess .
    Kind Regards,

    Liam

    • This reply was modified 6 years, 1 month ago by liam239. Reason: Inserted more info about folders
    Plugin Author Thomas

    (@tsteur)

    6 years, 1 month ago

    Thanks Liam. I have received the system report and will investigate and try to reproduce.

    Plugin Author Thomas

    (@tsteur)

    6 years, 1 month ago

    FYI here’s an update. I was able to reproduce it by installing the same plugins. The issue is caused by ameliabooking plugin (Amelia – Events & Appointments Booking Calendar) and causes this error:

    An exception has been thrown during the rendering of a template ("ParseError: Unexpected input in anonymous-file-0.less on line 1, column 0

    The problem is they are also using in their plugin some dependency called less.php but they are using some old, unsupported version: https://github.com/oyejorge/less.php versus we are using a more recent supported version https://github.com/leafo/lessphp

    I have created an issue for us here: https://github.com/matomo-org/wp-matomo/issues/233

    Unfortunately, solving this properly – if we can – will be quite some work and we will only be able to do this as part of the Matomo 4 update as it would otherwise break other Matomo plugins potentially. I have a big interest of fixing this issue though as it will avoid a lot of similar issues.

    I’m now also logging an issue with the other plugin author and will ask them if they could maybe update the version they are using.

    Here’s a temporary workaround that might work: Disable the booking plugin, load Matomo UI (it might work), then enable the booking plugin again. The Matomo UI will likely work until you update our plugin again.

    Sorry I can’t be of better help right now about this issue.

    Plugin Author Thomas

    (@tsteur)

    6 years, 1 month ago

    Just for reference I followed up here: https://wordpress.org/support/topic/update-less-php-dependency-if-possible/

    Plugin Author Thomas

    (@tsteur)

    6 years, 1 month ago

    @liam239 The developer mentioned they will be updating their plugin in couple of weeks.

    Thread Starter liam239

    (@liam239)

    6 years, 1 month ago

    Hi,

    No problem, you where a great help/support and a fast one. Now I know what the cause is.

    I will try the workaround one of the upcoming days. And I will see the update of Amelia coming in a couple of weeks for the complete solution (thanks to you) 😀 . I will let you know that the workaround works well.

    Best regards,

    Liam

    Plugin Author Thomas

    (@tsteur)

    6 years, 1 month ago

    Thanks Liam.

    Thread Starter liam239

    (@liam239)

    6 years, 1 month ago

    I deactivated the both plugins. I first Reactivated Matomo and then Amelia and everything works fine for now.

    Thanks again

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

The topic ‘activation Problem Critical DB error’ is closed to new replies.