Jump to content

Erreur [PrestaShopDatabaseException]


Recommended Posts

Posted (edited)

Bonjour,

j'ai cette erreur alors que j’étais en train de créer des fiches produits...

 

[PrestaShopDatabaseException]

Column 'active' in field list is ambiguous<br /><br /><pre> SELECT h.id_hook, h.name as h_name, title, description, h.position, hm.position as hm_position, m.id_module, m.name, active FROM `ps_hook_module` hm STRAIGHT_JOIN `ps_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1) STRAIGHT_JOIN `ps_module` as m ON (m.id_module = hm.id_module) ORDER BY hm.position</pre>
at line 769 in file classes/db/Db.php

 

764.         if ($webservice_call && $errno) {
765.             $dbg = debug_backtrace();
766.             WebserviceRequest::getInstance()->setError(500, '[SQL Error] ' . $this->getMsgError() . '. From ' . (isset($dbg[3]['class']) ? $dbg[3]['class'] : '') . '->' . $dbg[3]['function'] . '() Query was : ' . $sql, 97);
767.         } elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) {
768.             if ($sql) {
769.                 throw new PrestaShopDatabaseException($this->getMsgError() . '<br /><br /><pre>' . $sql . '</pre>');
770.             }
771. 
772.             throw new PrestaShopDatabaseException($this->getMsgError());
773.         }
774.     }

Si je met "true" dans le PS_DEV_MOD, j'ai accès à l'admin mais pas au front office et inversement si je met sur "false"

 

Quelqu'un aurai une idée ?

Merci d'avance !

Prestashop 1.7.6.8

 

Edited by pamgui (see edit history)

Share this post


Link to post
Share on other sites

  • pamgui changed the title to Erreur [PrestaShopDatabaseException]

Bonsoir,

Effectivement, je n'avais pas essayé et ça fonctionne.

J'ai vidé le cache sur le ftp et tout est revenu !

Un grand merci

Share this post


Link to post
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

×
×
  • Create New...

Important Information

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