leeburridge Posted November 2, 2011 Share Posted November 2, 2011 Just noticed that in the backed it is not showin any stats since the 31st October. 1st and 2nd are now showing as empty. Anyone else seen this? Link to comment Share on other sites More sharing options...
Mike Kranzler Posted November 2, 2011 Share Posted November 2, 2011 Hi leeburridge, What version of PrestaShop are you using? -Mike Link to comment Share on other sites More sharing options...
leeburridge Posted November 4, 2011 Author Share Posted November 4, 2011 Hi Mike, I'm using 1.4.3. I've attached a screenie so you can see what I mean. Cheers, Lee Link to comment Share on other sites More sharing options...
Mike Kranzler Posted November 4, 2011 Share Posted November 4, 2011 Hi Lee, Please try the solution posted here and let me know if that resolves your issue. -Mike Link to comment Share on other sites More sharing options...
leeburridge Posted November 7, 2011 Author Share Posted November 7, 2011 Hi Mike, I've tried that solution and it makes no difference. The problem I am getting is a bit different anyway as it's showing zero values for all columns since (and including) 1st November. Link to comment Share on other sites More sharing options...
Mike Kranzler Posted November 7, 2011 Share Posted November 7, 2011 Hi Lee, Can you please check out this report on the Bug Tracker and let me know if it helps you resolve your issue? -Mike Link to comment Share on other sites More sharing options...
leeburridge Posted November 8, 2011 Author Share Posted November 8, 2011 Done a bit more digging. It appears that it is the Visitor column that is not working. Orders and Registrations are showing correctly but it's the Visitors figure that is remaining at zero. I've checked out the above link but I don't believe this will fix the problem as it appears to only be affecting visitors. Link to comment Share on other sites More sharing options...
leeburridge Posted November 8, 2011 Author Share Posted November 8, 2011 As an added note I have just realised that if I go to the Visitors Online option in the Stats Dashboard it never shows anyone online. I have tried "Reset"ing the module and have changed the three Configure settings to something different and setting them back to the originals but it hasn't made any different. Link to comment Share on other sites More sharing options...
Mike Kranzler Posted November 8, 2011 Share Posted November 8, 2011 Hi Lee, I'm looking into this for you, but If you would like, you can try calling our support team at 888 947 6543 to try to get more advanced assistance on this issue. -Mike Link to comment Share on other sites More sharing options...
Mike Kranzler Posted November 8, 2011 Share Posted November 8, 2011 Hi Lee, We've actually had a few issues with the statslive module, which is likely what is causing you these issues. Can you please try downloading the SVN version of it from the source tab of the bug report here? -Mike Link to comment Share on other sites More sharing options...
leeburridge Posted November 9, 2011 Author Share Posted November 9, 2011 Tried that. Still no joy. I tried downloading all files from the SVN for the statslive module and uninstalled/deleted the current one then installed the SVN version and I still get 0 visitors. Link to comment Share on other sites More sharing options...
Mike Kranzler Posted November 9, 2011 Share Posted November 9, 2011 Hi Lee, Our development team just pushed out a fix which should take care of this for you. Can you please go back to the SVN version and download our updated statsforecast module as well and let me know if that works for you? -Mike Link to comment Share on other sites More sharing options...
cbelea Posted November 28, 2011 Share Posted November 28, 2011 The issue was resolved using the SVN version. But now, after the updating to PrestaShop 1.4.6.2 it reappeard... Stats are not showing correct anymore in "day"-mode. Link to comment Share on other sites More sharing options...
Mike Kranzler Posted November 29, 2011 Share Posted November 29, 2011 The issue was resolved using the SVN version. But now, after the updating to PrestaShop 1.4.6.2 it reappeard... Stats are not showing correct anymore in "day"-mode. Hi cbelea, Thanks for letting me know about this, I'm going to look into this for you. -Mike Link to comment Share on other sites More sharing options...
cbelea Posted December 4, 2011 Share Posted December 4, 2011 Hello, any news about this issue? Best regards. Link to comment Share on other sites More sharing options...
Mike Kranzler Posted December 5, 2011 Share Posted December 5, 2011 Hi cbelea, I spoke with the developer who fixed this originally, and there is not anything that has changed since the update which should be causing you any issues. Can you please try re-downloading the SVN version of the statsforecast module and let me know if the issue persists? -Mike Link to comment Share on other sites More sharing options...
lav3pa Posted January 27, 2012 Share Posted January 27, 2012 I have the same issue. I build a site using presta 1.4.5.1, it's live since 19 december 2011, but since the the visitor online page show 0. These days I want to use those stats but nothing I try is working. moduel is enable , I replace with the latest SVN version but nothing. From stats only this is not working, i need it now Link to comment Share on other sites More sharing options...
Mike Kranzler Posted January 27, 2012 Share Posted January 27, 2012 Hi lav3pa, If you're still having this issue after implementing the suggestions above, can you please add a comment to the bug report so that our developers can look into this for you? -Mike Link to comment Share on other sites More sharing options...
zoveress Posted February 16, 2012 Share Posted February 16, 2012 Hi Guys, I am having similar issues. I have changed the timezone on my shop recently and the visitors online module is not working since, the stats is OK showing visits but that one module will not report anything. Any ideas? I am on 1.4.3 Link to comment Share on other sites More sharing options...
Mallee Boy Posted April 13, 2012 Share Posted April 13, 2012 I am having the same issue since upgrading to 1473. Link to comment Share on other sites More sharing options...
cpatullo Posted April 26, 2012 Share Posted April 26, 2012 I am having the same issue as well under 1.4.7.2. Link to comment Share on other sites More sharing options...
cbelea Posted June 25, 2012 Share Posted June 25, 2012 (edited) Hello. Since upgrading to 1.4.7.3, I think, I have again the same issue, dates are not ordered properly. I'm running now 1.4.8.2. The workarounds posted previous arent up to date anymore, code has changed since then. Here's a screenshot from the current month selection. Edited June 25, 2012 by cbelea (see edit history) Link to comment Share on other sites More sharing options...
cbelea Posted July 5, 2012 Share Posted July 5, 2012 Well, I think it's a bug in statsforecast.php. Unfortunatelly my programming skills aren't that advanced to repair it myself. I've extracted the following query (line 115). My database holds data from November 2011. SELECT LEFT(invoice_date, 10) AS fix_date, COUNT(DISTINCT o.id_order) AS countOrders, SUM(od.product_quantity) AS countProducts, SUM(od.product_price * od.product_quantity / o.conversion_rate) AS totalProducts FROM ps_orders o LEFT JOIN ps_order_detail od ON o.id_order = od.id_order LEFT JOIN ps_product p ON od.product_id = p.id_product WHERE o.valid = 1 AND o.invoice_date BETWEEN '2011-11-01 00:00:00' AND '2012-06-30 23:59:59' GROUP BY LEFT(invoice_date, 10) ORDER BY fix_date It's displays correctly. So the problem has to be in the way the data is displayed in the php. Putting a print_r($dataTable); in row 129, right after while ($row = $db->nextRow($result)) $dataTable[$row['fix_date']] = $row; outputs: Array ( [2012-06-29] => Array ( [fix_date] => 2012-06-29 [countOrders] => 14 [countProducts] => 168 [totalProducts] => 5449.9999720000 ) [2012-06-30] => Array ( [fix_date] => 2012-06-30 [countOrders] => 0 [countProducts] => 0 [totalProducts] => 0 ) [2011-11-02] => Array ( [fix_date] => 2011-11-02 [countOrders] => 1 [countProducts] => 6 [totalProducts] => 117.0000000000 ) [2011-11-08] => Array ( [fix_date] => 2011-11-08 [countOrders] => 1 [countProducts] => 5 [totalProducts] => 98.0000000000 ) [2011-11-15] => Array ( [fix_date] => 2011-11-15 [countOrders] => 1 [countProducts] => [totalProducts] => ) etc So the array is messed up. Starts with June data and continues with November. Moving on. I've set a print_r($dataTable); on line 105, right after $dataTable = array(); if ($cookie->stats_granularity == 10) for ($i = $from; $i <= $to2; $i = strtotime('+1 day', $i)) $dataTable[date('Y-m-d', $i)] = array('fix_date' => date('Y-m-d', $i), 'countOrders' => 0, 'countProducts' => 0, 'totalProducts' => 0); All output is: Array ( [2012-06-29] => Array ( [fix_date] => 2012-06-29 [countOrders] => 0 [countProducts] => 0 [totalProducts] => 0 ) [2012-06-30] => Array ( [fix_date] => 2012-06-30 [countOrders] => 0 [countProducts] => 0 [totalProducts] => 0 ) ) Should not the whole array be initialized? Link to comment Share on other sites More sharing options...
Recommended Posts