ideegeniali Posted January 26, 2011 Share Posted January 26, 2011 I truncated (=emptied) connections, connections_page and connections_source tables to save space in DB.Now they keep being empty even if I navigate site.Why do they not grow up as before?How to reenable filling it by prestashop? Link to comment Share on other sites More sharing options...
shokinro Posted January 27, 2011 Share Posted January 27, 2011 try to uninstall the module and re-install again to see if it fixes the issue. Link to comment Share on other sites More sharing options...
ideegeniali Posted January 27, 2011 Author Share Posted January 27, 2011 Thank for suggestion, shokinro.Do you know wich module? There are many!I tried: visit and visitors and visitors origin but no luck.I tried resetting tables auto_increment to 1 in the DB, but no luck.Wich part of prestashop code updates connections tables?I see it's class/connections that deals with DB but cannot find from elsewhere it gets called.Did not find in core. Maybe a module, but wich one? Link to comment Share on other sites More sharing options...
shokinro Posted January 28, 2011 Share Posted January 28, 2011 I just made a test to truncate the 3 tables use following script. truncate table ps_connections; truncate table ps_connections_page ;truncate table ps_connections_source ;After run the script, I checked all tables are empty and then I started to browse my site again. Everything seems work fine. Both table ps_connections_page and ps_connections_source are growing immediately as I started browsing pages.But for ps_connections, it did not grow at beginning. But after I log out and close my browser, and restart my browser and then browse the site, one record is also added ps_connections.ps_connections table is recorded connetions, if you already connected, no record will be added.Please try to log out (if you have logged in), and clear your browser cache and close your browser then try again. Link to comment Share on other sites More sharing options...
ideegeniali Posted January 28, 2011 Author Share Posted January 28, 2011 Thanks for your tests and help.I tried your procedure (logout, close browser, login). No luck. Still empy tables.Site is online & in productions, I get 80 visitors per day, google analytics reports.Someone even did order something, but still empty tables.It worked like a charm before: tables kept growing.I Just did truncate the three tables, now they get no new entries...Not that I'm over-worried, site works.But would like to know what happened and what get broken and how to repair.I see class/connection.php updates these tables, but cannot find any code calling connection class in the core or modules.Where is it! I'm going crazy over this! Link to comment Share on other sites More sharing options...
shokinro Posted January 28, 2011 Share Posted January 28, 2011 Check following files and locations/tools/swift/Swift/Connection/Multi.php( line 53)/tools/swift/Swift/Connection/Rotator.php(line 57)/tools/swift/Swift/Events/ConnectEvent.php(line 28) Link to comment Share on other sites More sharing options...
codegrunt Posted April 17, 2011 Share Posted April 17, 2011 I was running into a similar issue recently where no visitor data was being tracked and in case it is what was responsible for your issue I thought I would mention it.The "Data mining for statistics" module must be enabled for you to track statistics at all. I could not find any documentation on this but a recursive find for ConnectionsSource found it. If that module is disabled then that is likely your problem. Cheers Link to comment Share on other sites More sharing options...
Recommended Posts