Erreur sql 'visiteurs en ligne'

[ColonelMoutarde]

Salut,

Lorsque je clique sur le bouton "visiteurs en ligne" sur le dashboard j'ai cette erreur sql. Peut-on m'aider ?

[PrestaShopDatabaseException]

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1380131364) GROUP BY u.id_customer ORDER BY u.firstname, u.lastname' at line 11

SELECT u.id_customer, u.firstname, u.lastname, pt.name as page
					FROM `connections` c
					LEFT JOIN `connections_page` cp ON c.id_connections = cp.id_connections
					LEFT JOIN `page` p ON p.id_page = cp.id_page
					LEFT JOIN `page_type` pt ON p.id_page_type = pt.id_page_type
					INNER JOIN `guest` g ON c.id_guest = g.id_guest
					INNER JOIN `customer` u ON u.id_customer = g.id_customer
					WHERE cp.`time_end` IS NULL
						 AND c.id_shop IN (1) 
						AND TIME_TO_SEC(TIMEDIFF('2017-05-29 09:15:00', cp.`time_start`)) < 900
					AND c.ip_address NOT IN (,1380131364)
					GROUP BY u.id_customer
					ORDER BY u.firstname, u.lastname


at line 791 in file classes/db/Db.php

786.         if ($webservice_call && $errno) {
787.             $dbg = debug_backtrace();
788.             WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);
789.         } elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) {
790.             if ($sql) {
791.                 throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');
792.             }
793. 
794.             throw new PrestaShopDatabaseException($this->getMsgError());
795.         }
796.     }

    DbCore->displayError - [line 425 - classes/db/Db.php] - [1 Arguments]
    DbCore->query - [line 643 - classes/db/Db.php] - [1 Arguments]
    DbCore->executeS - [line 92 - modules/statslive/statslive.php] - [1 Arguments]
    StatsLive->getCustomersOnline - [line 142 - modules/statslive/statslive.php]
    StatsLive->hookAdminStatsModules - [line 587 - classes/Hook.php] - [1 Arguments]
    HookCore::coreCallHook - [line 544 - classes/Hook.php] - [3 Arguments]
    HookCore::exec - [line 210 - controllers/admin/AdminStatsTabController.php] - [3 Arguments]
    AdminStatsTabControllerCore->displayStats - [line 57 - controllers/admin/AdminStatsTabController.php]
    AdminStatsTabControllerCore->initContent - [line 189 - classes/controller/Controller.php]
    ControllerCore->run - [line 367 - classes/Dispatcher.php]
    DispatcherCore->dispatch - [line 58 - admin/index.php]

[doekia]

Va dans Preferences > Maintenance, efface le champ des ip de maintenance, il contient des caractères parasites.

[ColonelMoutarde]

Ok c'est bon merci