-- Correction manuelle de la publication #75
-- Exécutez cette requête dans phpMyAdmin ou votre client SQL

-- 1. Voir le contenu actuel
SELECT pub_ID, pub_title, pub_description 
FROM t_publications 
WHERE pub_ID = 75;

-- 2. Ajouter les balises </div> manquantes
UPDATE t_publications 
SET pub_description = CONCAT(pub_description, '</div>')
WHERE pub_ID = 75;

-- 3. Vérifier la correction
SELECT pub_ID, pub_title, 
       (LENGTH(pub_description) - LENGTH(REPLACE(pub_description, '<div', ''))) / 4 as open_divs,
       (LENGTH(pub_description) - LENGTH(REPLACE(pub_description, '</div>', ''))) / 6 as close_divs
FROM t_publications 
WHERE pub_ID = 75;
