*

aviros

  • ***
  • 56 posts
Error in the site optimization
« on: Yesterday at 09:02:51 AM »
Good afternoon! When switching to the Osklass v8.4.0 version and running the optimization, an error appears: Large database tables (> 100,000 rows) were detected: oc_t_item_stats (205,210).

I wrote to the hosts, and they replied as follows: According to the information available online, the oc_t_item_stats table contains statistics about the website’s operation. That is, clearing it will remove the warning, but it will also delete some of your website’s statistics.

It’s better to check with the developer here to see how necessary it is to clear this table.  :(

*

MB Themes

Re: Error in the site optimization
« Reply #1 on: Yesterday at 09:15:20 AM »
I would recommend - remove data older then 1 year in this table and then retry.
Stats table can be large and osclass 8.4 adds automatic cleanup of old data (but it also redesign that table and add many columns to support various stats)
  To get fast support, we need following details: Detail description, URL to reproduce problem, Screenshots

*

aviros

  • ***
  • 56 posts
Re: Error in the site optimization
« Reply #2 on: Yesterday at 09:30:13 AM »
ok

*

aviros

  • ***
  • 56 posts
Re: Error in the site optimization
« Reply #3 on: Yesterday at 10:14:50 AM »
Delete anything older than 1 year! But it didn’t help. Can I delete all the data from the table?

*

MB Themes

Re: Error in the site optimization
« Reply #4 on: Yesterday at 10:18:51 AM »
Yes, those are just stats.
Error itself (one you've shared) is not error it's just notice that optimization might take more time and you might want to look on that table why it has many data
  To get fast support, we need following details: Detail description, URL to reproduce problem, Screenshots