Jump to content
Read more about the maintenance the forum on Monday 9th of September 2019 ×
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    988

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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

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