Jump to content

PrestaShopDatabaseException


HAIRWEBSHOP

Recommended Posts

We're suddenly received this message
Can 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

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

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...