Upgraded to PS 1.5.4 Stats still not working

[yourplaything]

Hey guys !

 

After having many issues with PS 1.5.3 i was grateful to find that 1.5.4 has now been released hoping it would solve all my issues. It has solved most apart from the one i rely upon most to keep track of vistitors etc.

 

The Online Visitor stats, and daily, monthly and yearly stats still not displaying any visitors?

 

I thought this would of been fixed in this release ?

 

 

Thanks for your help.

[yourplaything]

Guess no one has any ideas where to go from here then??

[shoulders]

i am not a proffessional programmer but i would suspect that your database has become damaged/corrupt on the tables that stats rely on.

 

my solution/fixing method:

• make a local copy of your website on an xampp server
  
• install another 'virgin' copy of the same prestashop version on xampp (subfolder is fine)
  
• use a program called Navicat and compare the table structure between the 2 versions of prestashop
  
• make the table structures of the live website (local on xampp) match that of the new version of the virgin copy of prestashop (navicat has this feature built in)
  
• try your stats, they probably will work now
  
• when happy, backup your live site
  
• compare the local version of the virgin prestashop with your live/online shop and apply the changes
  
• fixed
  

I hope this helps. you will just need to mess with the software and setup. If you are using cPanel you will need to enable remote MySQL access.

 

shoulders

Edited April 2, 2013 by shoulders (see edit history)

[hackia]

is there a sql command i can put in my mysql database command line to fix it?

[fong hong]

SOLVED ps1.5.6.1
 
/public_html/modules/statslive/statslive.php
 
Start
 
<?php
/*
* 2007-2014 PrestaShop
*
* NOTICE OF LICENSE
*
* This source file is subject to the Academic Free License (AFL 3.0)
* that is bundled with this package in the file LICENSE.txt.
* It is also available through the world-wide-web at this URL:
* http://opensource.org/licenses/afl-3.0.php
* If you did not receive a copy of the license and are unable to
* obtain it through the world-wide-web, please send an email
* to [email protected] so we can send you a copy immediately.
*
* DISCLAIMER
*
* Do not edit or add to this file if you wish to upgrade PrestaShop to newer
* versions in the future. If you wish to customize PrestaShop for your
* needs please refer to http://www.prestashop.com for more information.
*
* @author PrestaShop SA <[email protected]>
* @copyright 2007-2014 PrestaShop SA
* @license http://opensource.org/licenses/afl-3.0.php Academic Free License (AFL 3.0)
* International Registered Trademark & Property of PrestaShop SA
*/
if (!defined('_PS_VERSION_'))
exit;
class StatsLive extends Module
{
private $html = '';
public function __construct()
{
$this->name = 'statslive';
$this->tab = 'analytics_stats';
$this->version = '1.2.2';
$this->author = 'PrestaShop';
$this->need_instance = 0;
parent::__construct();
$this->displayName = $this->l('Visitors online');
$this->description = $this->l('Adds a list of customers and visitors who are currently online to the Stats dashboard.');
$this->ps_versions_compliancy = array('min' => '1.6', 'max' => _PS_VERSION_);
}
public function install()
{
return parent::install() && $this->registerHook('AdminStatsModules');
}
/**
* Get the number of online customers
*
* @return array(array, int) array of online customers entries, number of online customers
*/
private function getCustomersOnline()
{
if ($maintenance_ips = Configuration::get('PS_MAINTENANCE_IP'))
$maintenance_ips = implode(',', array_map('ip2long', array_map('trim', explode(',', $maintenance_ips))));
if (Configuration::get('PS_STATSDATA_CUSTOMER_PAGESVIEWS'))
{
$sql = 'SELECT u.id_customer, u.firstname, u.lastname, pt.name as page
FROM `'._DB_PREFIX_.'connections` c
LEFT JOIN `'._DB_PREFIX_.'connections_page` cp ON c.id_connections = cp.id_connections
LEFT JOIN `'._DB_PREFIX_.'page` p ON p.id_page = cp.id_page
LEFT JOIN `'._DB_PREFIX_.'page_type` pt ON p.id_page_type = pt.id_page_type
INNER JOIN `'._DB_PREFIX_.'guest` g ON c.id_guest = g.id_guest
INNER JOIN `'._DB_PREFIX_.'customer` u ON u.id_customer = g.id_customer
WHERE cp.`time_end` IS NULL
'.Shop::addSqlRestriction(false, 'c').'
AND TIME_TO_SEC(TIMEDIFF(\''.pSQL(date('Y-m-d H:i:00', time())).'\', cp.`time_start`)) < 900
'.($maintenance_ips ? 'AND c.ip_address NOT IN ('.preg_replace('/[^,0-9]/', '', $maintenance_ips).')' : '').'
GROUP BY u.id_customer
ORDER BY u.firstname, u.lastname';
}
else
{
$sql = 'SELECT u.id_customer, u.firstname, u.lastname, "-" as page
FROM `'._DB_PREFIX_.'connections` c
INNER JOIN `'._DB_PREFIX_.'guest` g ON c.id_guest = g.id_guest
INNER JOIN `'._DB_PREFIX_.'customer` u ON u.id_customer = g.id_customer
WHERE TIME_TO_SEC(TIMEDIFF(\''.pSQL(date('Y-m-d H:i:00', time())).'\', c.`date_add`)) < 900
'.Shop::addSqlRestriction(false, 'c').'
'.($maintenance_ips ? 'AND c.ip_address NOT IN ('.preg_replace('/[^,0-9]/', '', $maintenance_ips).')' : '').'
GROUP BY u.id_customer
ORDER BY u.firstname, u.lastname';
}
$results = Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS($sql);
return array($results, Db::getInstance()->NumRows());
}
/**
* Get the number of online visitors
*
* @return array(array, int) array of online visitors entries, number of online visitors
*/
private function getVisitorsOnline()
{
if ($maintenance_ips = Configuration::get('PS_MAINTENANCE_IP'))
$maintenance_ips = implode(',', array_map('ip2long', array_filter(array_map('trim', explode(',', $maintenance_ips)))));
if (Configuration::get('PS_STATSDATA_CUSTOMER_PAGESVIEWS'))
{
$sql = 'SELECT c.id_guest, c.ip_address, c.date_add, c.http_referer, pt.name as page
FROM `'._DB_PREFIX_.'connections` c
LEFT JOIN `'._DB_PREFIX_.'connections_page` cp ON c.id_connections = cp.id_connections
LEFT JOIN `'._DB_PREFIX_.'page` p ON p.id_page = cp.id_page
LEFT JOIN `'._DB_PREFIX_.'page_type` pt ON p.id_page_type = pt.id_page_type
INNER JOIN `'._DB_PREFIX_.'guest` g ON c.id_guest = g.id_guest
WHERE (g.id_customer IS NULL OR g.id_customer = 0)
'.Shop::addSqlRestriction(false, 'c').'
AND cp.`time_end` IS NULL
AND TIME_TO_SEC(TIMEDIFF(\''.pSQL(date('Y-m-d H:i:00', time())).'\', cp.`time_start`)) < 900
'.($maintenance_ips ? 'AND c.ip_address NOT IN ('.preg_replace('/[^,0-9]/', '', $maintenance_ips).')' : '').'
GROUP BY c.id_connections
ORDER BY c.date_add DESC';
}
else
{
$sql = 'SELECT c.id_guest, c.ip_address, c.date_add, c.http_referer, "-" as page
FROM `'._DB_PREFIX_.'connections` c
INNER JOIN `'._DB_PREFIX_.'guest` g ON c.id_guest = g.id_guest
WHERE (g.id_customer IS NULL OR g.id_customer = 0)
'.Shop::addSqlRestriction(false, 'c').'
AND TIME_TO_SEC(TIMEDIFF(\''.pSQL(date('Y-m-d H:i:00', time())).'\', c.`date_add`)) < 900
'.($maintenance_ips ? 'AND c.ip_address NOT IN ('.preg_replace('/[^,0-9]/', '', $maintenance_ips).')' : '').'
ORDER BY c.date_add DESC';
}
$results = Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS($sql);
return array($results, Db::getInstance()->NumRows());
}
public function hookAdminStatsModules($params)
{
list($customers, $total_customers) = $this->getCustomersOnline();
list($visitors, $total_visitors) = $this->getVisitorsOnline();
$irow = 0;
$this->html .= '<script type="text/javascript">
$("#calendar").remove();
</script>';
if (!Configuration::get('PS_STATSDATA_CUSTOMER_PAGESVIEWS'))
$this->html .= '
<div class="alert alert-info">'.
$this->l('You must activate the "Save page views for each customer" option in the "Data mining for statistics" (StatsData) module in order to see the pages that your visitors are currently viewing.').'
</div>';
$this->html .= '
<h4> '.$this->l('Current online customers').'</h4>';
if ($total_customers)
{
$this->html .= $this->l('Total:').' '.(int)$total_customers.'
<table class="table">
<thead>
<tr>
<th class="center"><span class="title_box active">'.$this->l('Customer ID').'</span></th>
<th class="center"><span class="title_box active">'.$this->l('Name').'</span></th>
<th class="center"><span class="title_box active">'.$this->l('Current page').'</span></th>
<th class="center"><span class="title_box active">'.$this->l('View customer profile').'</span></th>
</tr>
</thead>
<tbody>';
foreach ($customers as $customer)
$this->html .= '
<tr'.($irow++ % 2 ? ' class="alt_row"' : '').'>
<td class="center">'.$customer['id_customer'].'</td>
<td class="center">'.$customer['firstname'].' '.$customer['lastname'].'</td>
<td class="center">'.$customer['page'].'</td>
<td class="center">
<a href="'.Tools::safeOutput('index.php?tab=AdminCustomers&id_customer='.$customer['id_customer'].'&viewcustomer&token='.Tools::getAdminToken('AdminCustomers'.(int)Tab::getIdFromClassName('AdminCustomers').(int)$this->context->employee->id)).'"
target="_blank">
<img src="../modules/'.$this->name.'/logo.gif" />
</a>
</td>
</tr>';
$this->html .= '
</tbody>
</table>';
}
else
$this->html .= '<p class="alert alert-warning">'.$this->l('There are no active customers online right now.').'</p>';
$this->html .= '
<h4> '.$this->l('Current online visitors').'</h4>';
if ($total_visitors)
{
$this->html .= $this->l('Total:').' '.(int)$total_visitors.'
<div>
<table class="table">
<thead>
<tr>
<th class="center"><span class="title_box active">'.$this->l('Guest ID').'</span></th>
<th class="center"><span class="title_box active">'.$this->l('IP').'</span></th>
<th class="center"><span class="title_box active">'.$this->l('Last activity').'</span></th>
<th class="center"><span class="title_box active">'.$this->l('Current page').'</span></th>
<th class="center"><span class="title_box active">'.$this->l('Referrer').'</span></th>
</tr>
</thead>
<tbody>';
foreach ($visitors as $visitor)
$this->html .= '<tr'.($irow++ % 2 ? ' class="alt_row"' : '').'>
<td class="center">'.$visitor['id_guest'].'</td>
<td class="center">'.long2ip($visitor['ip_address']).'</td>
<td class="center">'.Tools::substr($visitor['date_add'], 11).'</td>
<td class="center">'.(isset($visitor['page']) ? $visitor['page'] : $this->l('Undefined')).'</td>
<td class="center">'.(empty($visitor['http_referer']) ? $this->l('None') : parse_url($visitor['http_referer'], PHP_URL_HOST)).'</td>
</tr>';
$this->html .= '
</tbody>
</table>
</div>';
}
else
$this->html .= '<p class="alert alert-warning">'.$this->l('There are no visitors online.').'</p>';
$this->html .= '
<h4>'.$this->l('Notice').'</h4>
<p class="alert alert-info">'.$this->l('Maintenance IPs are excluded from the online visitors.').'</p>
<a class="btn btn-default" href="'.Tools::safeOutput('index.php?controller=AdminMaintenance&token='.Tools::getAdminTokenLite('AdminMaintenance')).'">
<i class="icon-share-alt"></i> '.$this->l('Add or remove an IP address.').'
</a>
';
return $this->html;
}
}
 
End
 
SOLVED
 
Pls visit www.7zhop.com
 

Link  https://github.com/PrestaShop/statslive/blob/master/statslive.php

Edited January 5, 2015 by fong hong (see edit history)