HAIRWEBSHOP Posted May 13, 2016 Share Posted May 13, 2016 We're suddenly received this messageCan someone please help me figure this out?Thank you! Unknown column 'su.phxsical_uri' in 'field list' SELECT su.phxsical_uri, su.virtual_uri, su.domain, su.domain_ssl, t.id_theme, t.name, t.directory FROM hw_shop s LEFT JOIN hw_shop_url su ON (s.id_shop = su.id_shop) LEFT JOIN hw_theme t ON (t.id_theme = s.id_theme) WHERE s.id_shop = 1 AND s.active = 1 AND s.deleted = 0 AND su.main = 1 LIMIT 1 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()); DbCore->displayError - [line 425 - classes/db/Db.php] - [1 Arguments]DbCore->query - [line 690 - classes/db/Db.php] - [1 Arguments]DbCore->getRow - [line 203 - classes/shop/Shop.php] - [1 Arguments]ShopCore->setUrl - [line 133 - classes/shop/Shop.php]ShopCore->__construct - [line 397 - classes/shop/Shop.php] - [1 Arguments]ShopCore::initialize - [line 114 - config/config.inc.php]require - [line 27 - index.php] - [1 Arguments] Link to comment Share on other sites More sharing options...
HAIRWEBSHOP Posted May 13, 2016 Author Share Posted May 13, 2016 (edited) 'su.phxsical_uri' should probably be 'su.physical_uri' But there was also another error caused be 'su.phwsical_uri' as well. Could it be that someone was trying to break into our webshop? Edited May 13, 2016 by HAIRWEBSHOP (see edit history) Link to comment Share on other sites More sharing options...
HAIRWEBSHOP Posted May 16, 2016 Author Share Posted May 16, 2016 Can someone please help me figure this out?I restored a backup, but who knows when it might occur again. After all, it came out of the blue. Link to comment Share on other sites More sharing options...
bellini13 Posted May 16, 2016 Share Posted May 16, 2016 if i had to guess, you installed a new theme or module recently, which has a bad SQL query. search for phxsical_uri in all of your modules folder and you will likely find the culprit Link to comment Share on other sites More sharing options...
HAIRWEBSHOP Posted May 16, 2016 Author Share Posted May 16, 2016 Hello bellini13, and thank you kindly for your reply, Although I did not install any new module or theme, I deep searched all of my files.There was not a single file containing either 'phxsical_uri' or 'su.phwsical_uri' This rather looks like a human error that was made on the fly, but no one has access to our Prestashop, but me. Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now