Jump to content
saad elalfy

error in id_lang` = 2 AND `id_shop

By saad elalfy , in Configuring and using PrestaShop

Recommended Posts

saad elalfy    1

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

Share this post

Link to post
Share on other sites

shacker    990

shacker
Posted

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

ionut71    0

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

Share this post

Link to post
Share on other sites

saad elalfy    1

saad elalfy
Posted

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

MR M    0

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

Share this post

Link to post
Share on other sites

shana0780    5

shana0780
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)

Share this post

Link to post
Share on other sites

shana0780    5

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

×
Go To Topic Listing
×
×
  • Create New...

Important Information

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

  I accept