Jump to content
saad elalfy

error in id_lang` = 2 AND `id_shop

Recommended Posts

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

Share this post


Link to post
Share on other sites

try to change

 

WHERE `id_lang` = 2 AND  `id_shop` = 1 LIMIT 1

 

to

 

 

WHERE rl.`id_lang` = 2 AND  r.`id_shop` = 1 LIMIT 1

 

but before check if in the table ps_info the id_shop field exists

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

save all text you modifie it and , reset custum text module from module list and you will back to the default with out errors 

  • Like 1

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites
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)

Share this post


Link to post
Share on other sites
4 hours ago, shana0780 said:

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

Resolved for me, I have only downloaded another version of Paypal.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...

Important Information

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