Unknown column 'id_shop' in 'where clause'

[bhmstore.com]

Hello everyone

I get this error when I wanna go to orders tab in back office:

[PrestaShopDatabaseException]

Unknown column 'id_shop' in 'where clause'
 

SELECT * FROM `ps_ganalytics` WHERE sent = 0 AND id_shop = '1' AND DATE_ADD(date_add, INTERVAL 30 minute) < NOW()

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 716 - modules/ganalytics/ganalytics.php] - [1 Arguments]

Ganalytics->hookBackOfficeHeader - [line 587 - classes/Hook.php] - [1 Arguments]

HookCore::coreCallHook - [line 544 - classes/Hook.php] - [3 Arguments]

HookCore::exec - [line 2721 - classes/controller/AdminController.php] - [2 Arguments]

AdminControllerCore->init - [line 170 - classes/controller/Controller.php]

ControllerCore->run - [line 367 - classes/Dispatcher.php]

DispatcherCore->dispatch - [line 58 - admin/index.php]

 

Thank u in advance for helping me

[NemoPS]

add a new column to that ps_ganalytics table in the database, name it id_shop and make it an INT

[bhmstore.com]

thank u 4 ur rply 

I checked all database such as u mentioned ... no missing or any fault

but I just disable " google analytics module " then resolved !!?