babyewok Posted February 13, 2013 Share Posted February 13, 2013 My client has Prestashop v. 1.3.1.1. I recently set the stats to automatically clean after 1 year since this hasn't been done since she opened her shop and ps_connections_page has nearly 3million rows! When will this take effect however as I can still see all those rows in the ps_connections_page table? Link to comment Share on other sites More sharing options...
vekia Posted February 14, 2013 Share Posted February 14, 2013 it's a table for statistics, this table stores informations about page views, what you exactly want to do with this? Auto Clean? What do you mean by that Link to comment Share on other sites More sharing options...
babyewok Posted February 14, 2013 Author Share Posted February 14, 2013 In the stats setttings (version 1.3) I can set the stats to be cleaned autonatically every year, month or day - this is supposed to clean out the ps_connections_page table. However, I do not understand when it is supposed to do this as there are still entries form 2012 in there. I would have thought that form the moment I changed the setting it woudl start clearing our entries older than 1 year. I have manually emptied this table before - but if the automatic clean is supposed to do this, why should I need to? Link to comment Share on other sites More sharing options...
babyewok Posted February 14, 2013 Author Share Posted February 14, 2013 How can I truncate the table so that I keep the data from the last year only? I am just concerned that if I do it manually now, then if the automatic clean isn't working correctly I will end up with a huge table again. Link to comment Share on other sites More sharing options...
babyewok Posted February 14, 2013 Author Share Posted February 14, 2013 Can no one help me on this? Why is the automatic clean facility not working? Link to comment Share on other sites More sharing options...
.png.022b5452a8f28f552bc9430097a16da2.png)
Recommended Posts