chipset Posted November 1, 2017 Share Posted November 1, 2017 Hello, i have a problem with many bots in my shop. Prestashop logging their actions in DB. I don't use any statistical data and was uninstall any stat modules. Unfortunately i have new data in search_index and search_word tables even after that. How to stop adding any data in these tables? Link to comment Share on other sites More sharing options...
selectshop.at Posted November 1, 2017 Share Posted November 1, 2017 Prestashop version is ? Some data you cannot stop for to write. You can use a free module for to empty from time to time these database tables: https://catalogo-onlinersi.net/en/modules-prestashop/217-delete-connections.html Link to comment Share on other sites More sharing options...
chipset Posted November 1, 2017 Author Share Posted November 1, 2017 Sorry, I missed the details: Prestashop 1.6.1.17 Time to time is hard for me. I have more than 15MB per day. I can delete the tables or empty with cron, but if there is more intelligent solution... Link to comment Share on other sites More sharing options...
selectshop.at Posted November 1, 2017 Share Posted November 1, 2017 Some data you cannot stop to from writing. The best way is to stop the bots from accessing your site by IP-tables or other firewall. Some bots are useless. Allow only the necessary (Google, Bing, Yahoo, MSN). Others like Facebook, Klickz, Bitly, Yandex (if you are not selling in RUS and ex RUS),Amazon, etc. are useless Link to comment Share on other sites More sharing options...
selectshop.at Posted November 1, 2017 Share Posted November 1, 2017 Try this: https://www.prestashop.com/forums/topic/245300-module-free-ban-ip-address-block-any-user-you-want/ Perhaps it helps a little bit. Link to comment Share on other sites More sharing options...
selectshop.at Posted November 1, 2017 Share Posted November 1, 2017 BTW, I took a look into my database tables. There are none statistical data. Can you please tell me which table is increasing ? Perhaps you missed to disable one statistic option. Link to comment Share on other sites More sharing options...
chipset Posted November 1, 2017 Author Share Posted November 1, 2017 24 minutes ago, selectshop.at said: BTW, I took a look into my database tables. There are none statistical data. Can you please tell me which table is increasing ? Perhaps you missed to disable one statistic option. search_index and search_word Link to comment Share on other sites More sharing options...
selectshop.at Posted November 2, 2017 Share Posted November 2, 2017 You cant stop this. Table search_index ist built by your content and not bots. It is the search index. So when some user search for xy on your site he will find xy. If you empty this table than users will find nothing on your homepage. The only table you perhaps can empty is search_words. These are the words users searched on your site. It contains also the words not found on your page.... 1 Link to comment Share on other sites More sharing options...
Daresh Posted November 2, 2017 Share Posted November 2, 2017 search_word is also for the search, not for not found, you can't empty it, it's part of the search mechanism. If you want to keep your DB in a good shape, check out the Tidy module. Link to comment Share on other sites More sharing options...
chipset Posted November 3, 2017 Author Share Posted November 3, 2017 Thanks, this help me to understand it. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now