Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Recreate table log_link_visit_action #20172

Closed
Harfeur opened this issue Jan 8, 2023 · 3 comments
Closed

Recreate table log_link_visit_action #20172

Harfeur opened this issue Jan 8, 2023 · 3 comments
Labels
answered For when a question was asked and we referred to forum or answered it.

Comments

@Harfeur
Copy link

Harfeur commented Jan 8, 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
@Harfeur Harfeur added Potential Bug Something that might be a bug, but needs validation and confirmation it can be reproduced. To Triage An issue awaiting triage by a Matomo core team member labels Jan 8, 2023
@bx80
Copy link
Contributor

bx80 commented Jan 9, 2023

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.

@bx80 bx80 added the Waiting for user feedback Indicates the Matomo team is waiting for feedback from the author or other users. label Jan 9, 2023
@Harfeur
Copy link
Author

Harfeur commented Jan 9, 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 !

@Harfeur Harfeur closed this as completed Jan 9, 2023
@bx80
Copy link
Contributor

bx80 commented Jan 9, 2023

Glad you got it sorted 👍

@bx80 bx80 added answered For when a question was asked and we referred to forum or answered it. and removed Waiting for user feedback Indicates the Matomo team is waiting for feedback from the author or other users. Potential Bug Something that might be a bug, but needs validation and confirmation it can be reproduced. To Triage An issue awaiting triage by a Matomo core team member labels Jan 9, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
answered For when a question was asked and we referred to forum or answered it.
Projects
None yet
Development

No branches or pull requests

2 participants