Jump to content

error in id_lang` = 2 AND `id_shop

saad elalfy
 Share

Recommended Posts

saad elalfy Newbie

saad elalfy

Posted
Posted

please i get there error how can i fix it :) 

Unknown column 'r.id_shop' in 'field list'
  

SELECT r.`id_info`, r.`id_shop`, rl.`text`
            FROM `ps_info` r
            LEFT JOIN `ps_info_lang` rl ON (r.`id_info` = rl.`id_info`)
            WHERE `id_lang` = 2 AND  `id_shop` = 1 LIMIT 1


at line 746 in file classes/db/Db.php

  

741.         if ($webservice_call && $errno) {
742.             $dbg = debug_backtrace();
743.             WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);
744.         } elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) {
745.             if ($sql) {
746.                 throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');
747.             }
748. 
749.             throw new PrestaShopDatabaseException($this->getMsgError());
750.         }
751.     }
Link to comment
Share on other sites
  • 2 weeks later...
ionut71 Newbie

ionut71

Posted
Posted

Hi, I have the same problem / error, but I don't understand how you solve it... Please explain.

 

[PrestaShopDatabaseException]

Unknown column 'r.id_shop' in 'field list'
  

SELECT r.`id_info`, r.`id_shop`, rl.`text`
            FROM `prstshp_info` r
            LEFT JOIN `prstshp_info_lang` rl ON (r.`id_info` = rl.`id_info`)
            WHERE rl.`id_lang` = 1 AND  `id_shop` = 1 LIMIT 1


at line 746 in file classes/db/Db.php

  

741.         if ($webservice_call && $errno) {
742.             $dbg = debug_backtrace();
743.             WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);
744.         } elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) {
745.             if ($sql) {
746.                 throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');
747.             }
748. 
749.             throw new PrestaShopDatabaseException($this->getMsgError());
750.         }
751.     }
Link to comment
Share on other sites
  • 1 month later...
  • 10 months later...
MR M Newbie

MR M

Posted
Posted

Hello all, I got the some as above problem but its bit different 

please anyone can help me to solve it 

if possible explain step by step so i can do it 

thanks and regards 

 [PrestaShopDatabaseException]

Unknown column 'id_paypal_order' in 'field list'
  

SELECT id_paypal_order
FROM `ps_paypal_order`
WHERE (id_order = 9) LIMIT 1


at line 746 in file classes/db/Db.php

  

741.         if ($webservice_call && $errno) {
742.             $dbg = debug_backtrace();
743.             WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);
744.         } elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) {
745.             if ($sql) {
746.                 throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');
747.             }
748. 
749.             throw new PrestaShopDatabaseException($this->getMsgError());
750.         }
751.     }
Link to comment
Share on other sites
  • 7 months later...
shana0780 Newbie

shana0780

Posted
Posted (edited)
On 5/23/2019 at 10:24 PM, MR M said:

Hello all, I got the some as above problem but its bit different 

please anyone can help me to solve it 

if possible explain step by step so i can do it 

thanks and regards 

 [PrestaShopDatabaseException]

Unknown column 'id_paypal_order' in 'field list'
  


SELECT id_paypal_order
FROM `ps_paypal_order`
WHERE (id_order = 9) LIMIT 1


at line 746 in file classes/db/Db.php

  


741.         if ($webservice_call && $errno) {
742.             $dbg = debug_backtrace();
743.             WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);
744.         } elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) {
745.             if ($sql) {
746.                 throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');
747.             }
748. 
749.             throw new PrestaShopDatabaseException($this->getMsgError());
750.         }
751.     }

Hello,

I have the same error after an upgrade from 1.6.1.8 to 1.7.6.2., can you solve it and how ?

For information, the table exist and the ID order also.

Thanks

71443954-565a3800-270e-11ea-8117-44f8973f3cfe.png

Edited by shana0780 (see edit history)
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
 Share
Go to topic listing
×
×
  • Create New...