@Harfeur opened this Issue on January 8th 2023

Expected Behavior

I should see the dashboard

Current Behavior

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'matomo_db.matomo_log_link_visit_action' doesn't exist

Possible Solution

Recreate the table, but I can't find the script and the one in core/Db/Schema/Mysql.php is incomplete

Steps to Reproduce (for Bugs)

I don't know

Context

I tried to add a new website to my instance

Your Environment

  • Matomo Version: 4.13.0
  • PHP Version: 8.0.26
  • Server Operating System: Debian GNU/Linux 11
  • Additionally installed plugins: Nope
@bx80 commented on January 9th 2023 Contributor

Hi @Harfeur, thanks for reaching out.

It would be good to first check the database config settings you have in config.ini.php and if possible manually connect to confirm that the database exists, is accessible and what tables are present.

If one or more tables is missing from your database then I'd recommend restoring from a database backup as the remaining tables may now reference data that is no longer present and this will likely cause unpredictable errors.

@Harfeur commented on January 9th 2023

Hi, thanks for your quick reply.

manually connect to confirm that the database exists, is accessible and what tables are present.

I connected to the database but this specific wasn't in the database.

restoring from a database backup

Unfortunately I didn't have a database backup, so I created a new matomo instance and I followed the install guide that created the missing table. Then I got the table data and I recreated the table in the original database.

Now the problem is solved, thanks !

@bx80 commented on January 9th 2023 Contributor

Glad you got it sorted :+1:

This Issue was closed on January 9th 2023
Powered by GitHub Issue Mirror