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

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.


×
×
  • Create New...

Important Information

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