0

in my database I saw tables which start on m2_cl. I deleted them, but my project stopped working, so I brought them back to life.

if i delete table m2_cl_log_visitor i have this error

Base table or view not found: 1146 Table 'dd.m2_cl_log_visitor' doesn't exist, query was: INSERT INTO `log_visitor` (`session_id`, `first_visit_at`, `last_visit_at`, `last_url_id`, `store_id`) VALUES (?, ?, ?, ?, ?)

How do I delete these tables correctly? They are not needed, but take up a lot of space

and why, after removing them, the site does not work?

0

Magento expects these tables to be present, thus they can not be removed. You can clean them, however, truncating all contents.

If you have cronjobs running this can be done via System > Configuration > Advanced > System > Log Cleaning. Choose a number of days to keep the logs, turn on "Enable Log Cleaning" and set the frequency to daily.

  • but what is the use of these tables? – Denys Maksiura Jan 14 at 15:27
  • @DenysMaksiura they are used for reports mostly. Keeping track of a users views pages. – Sander Mangel 2 days ago

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.