NO ORDER PAGE. Unknown column 'id_shop' in 'where clause'

[cljcorkern]

  This is the error I am having.

 

 

[PrestaShopDatabaseException]

Unknown column 'id_shop' in 'where clause'

 

SELECT * FROM `iw6_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 712 - 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 2733 - classes/controller/AdminController.php] - [2 Arguments]
• AdminControllerCore->init - [line 170 - classes/controller/Controller.php]
• ControllerCore->run - [line 367 - classes/Dispatcher.php]
• DispatcherCore->dispatch - [line 59 - admin/index.php]

[tuk66]

The Google Analytics module wasn't properly updated (its database table).