btsconsult Posted November 19, 2013 Share Posted November 19, 2013 Bonjour, Peut-on utiliser cet outil en toute confiance ? Et plus particulièrement la fonction Contraintes d'intégrité fonctionnelle : Vérifier et réparer Vérifie et répare les problèmes d'intégrité fonctionnelle Link to comment Share on other sites More sharing options...
btsconsult Posted November 19, 2013 Author Share Posted November 19, 2013 Bonjour, Je viens de faire une vérification et voici le résultat : Les requêtes suivantes ont permis de réparer certaines données: DELETE FROM `ps_access` WHERE `id_tab` NOT IN (SELECT `id_tab` FROM `ps_tab`)4 ligne(s) DELETE FROM `ps_compare` WHERE `id_customer` NOT IN (SELECT `id_customer` FROM `ps_customer`)1 ligne(s) DELETE FROM `ps_compare_product` WHERE `id_compare` NOT IN (SELECT `id_compare` FROM `ps_compare`)3 ligne(s) DELETE FROM `ps_image` WHERE `id_product` NOT IN (SELECT `id_product` FROM `ps_product`)6 ligne(s) DELETE FROM `ps_search_index` WHERE `id_product` NOT IN (SELECT `id_product` FROM `ps_product`)211 ligne(s) DELETE FROM `ps_specific_price_priority` WHERE `id_product` NOT IN (SELECT `id_product` FROM `ps_product`)23 ligne(s) Je viens de m’apercevoir que je suis resté dans la partie du forum "Mise à jour de Prestashop" Si un modérateur pouvait transférer le post dans "Configuration et utilisation de PrestaShop" Merci d'avance, Michel Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now