J'ai un message d'erreur [PrestaShopDatabaseException] Aidez-moi, s'il vous plaît..

[rbeu]

bonjour, alors j'ai un message d'erreur quand je clique sur

statistiques > Visiteur en ligne

la boom une page avec des erreur voila le message

 

[PrestaShopDatabaseException]

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '1549744249,1123635480,1123631628,1123638533,1123638535,2637637594,2919005261,291' at line 7

 

SELECT u.id_customer, u.firstname, u.lastname, "-" as page

                    FROM `P16_connections` c
                    INNER JOIN `P16_guest` g ON c.id_guest = g.id_guest
                    INNER JOIN `P16_customer` u ON u.id_customer = g.id_customer
                    WHERE TIME_TO_SEC(TIMEDIFF('2017-09-04 15:46:00', c.`date_add`)) < 900
                         AND c.id_shop IN (1)
                    AND c.ip_address NOT IN (,1549744249,1123635480,1123631628,1123638533,1123638535,2637637594,2919005261,2919005252,1121754291,2919005261,2919005252,1549744249,1123635482,1123636108,2965029173,1549744249,875578721,1123632665,520974662,520974670,520974657,520974686,1123638531,1123635484,1549744249,3002003231,1123638284)
                    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, '

 '.$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 591 - classes/Hook.php] - [1 Arguments]
• HookCore::coreCallHook - [line 548 - classes/Hook.php] - [3 Arguments]
• HookCore::exec - [line 314 - override/classes/Hook.php] - [7 Arguments]
• Hook::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]

 

Voila moi je ne comprend rien Aidez-moi, s'il vous plaît.. merci d'avance

[selectshop.at]

Votre syntaxe SQL c'est mal

                     AND c.ip_address NOT IN (, 1549744249,1123635480,1123631628,.....

La première virgule après le agrafe (,
Le virgule n'est pas autorisée dans cette position. Il manque un nombre avant?