Jump to content
bhmstore.com

Unknown column 'id_shop' in 'where clause'

Recommended Posts

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

PrestaShopDatabaseException.jpg

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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 !!?

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More