{"id":701,"date":"2024-09-23T16:46:18","date_gmt":"2024-09-23T14:46:18","guid":{"rendered":"https:\/\/weblog.uncasapart.fr\/?p=701"},"modified":"2025-03-27T10:51:07","modified_gmt":"2025-03-27T09:51:07","slug":"coppermine-gallery-erreur-critique-table-cpgxxxx_hit_stats","status":"publish","type":"post","link":"https:\/\/weblog.uncasapart.fr\/index.php\/2024\/09\/23\/coppermine-gallery-erreur-critique-table-cpgxxxx_hit_stats\/","title":{"rendered":"Coppermine Gallery &#8211; Erreur critique table cpgxxxx_hit_stats"},"content":{"rendered":"\n<p>Cette erreur apparait lors de la visite de la galerie sans \u00eatre identifi\u00e9. Il s&rsquo;agit de la requ\u00eate qui enregistre les donn\u00e9es pour le compteur de visites.<\/p>\n\n\n\n<p>La valeur \u00e0 ins\u00e9rer dans le champ <code>cpg1410_hit_stats.IP<\/code> , adresse ip (ici en ipv6) est trop longue par rapport \u00e0 la structure de la table qui n&rsquo;autorise que 20 caract\u00e8res pour les adresses ipv4 uniquement. <\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"569\" height=\"279\" src=\"https:\/\/weblog.uncasapart.fr\/wp-content\/uploads\/2024\/09\/image.png\" alt=\"\" class=\"wp-image-703\" srcset=\"https:\/\/weblog.uncasapart.fr\/wp-content\/uploads\/2024\/09\/image.png 569w, https:\/\/weblog.uncasapart.fr\/wp-content\/uploads\/2024\/09\/image-300x147.png 300w\" sizes=\"auto, (max-width: 569px) 100vw, 569px\" \/><\/figure>\n\n\n\n<p>La longueur d&rsquo;une adresse IPv6 est de 8*4 blocs + 7 s\u00e9parateurs, soit 39 caract\u00e8res. J&rsquo;ai choisi de modifier la longueur du champ de 20 \u00e0 40 caract\u00e8res via PhpMyAdmin.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1008\" height=\"397\" src=\"https:\/\/weblog.uncasapart.fr\/wp-content\/uploads\/2024\/09\/image-1.png\" alt=\"\" class=\"wp-image-704\" srcset=\"https:\/\/weblog.uncasapart.fr\/wp-content\/uploads\/2024\/09\/image-1.png 1008w, https:\/\/weblog.uncasapart.fr\/wp-content\/uploads\/2024\/09\/image-1-300x118.png 300w, https:\/\/weblog.uncasapart.fr\/wp-content\/uploads\/2024\/09\/image-1-768x302.png 768w\" sizes=\"auto, (max-width: 1008px) 100vw, 1008px\" \/><\/figure>\n\n\n\n<p>C&rsquo;est tout.<\/p>\n\n\n\n<p>Un rafraichissement de la page qui ne chargerait pas et \u00e7a fonctionne. nb: je n&rsquo;ai pas fait de test de non-r\u00e9gression pour le reste des pages\/fonctionnalit\u00e9s.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"550\" src=\"https:\/\/weblog.uncasapart.fr\/wp-content\/uploads\/2024\/09\/image-2-1024x550.png\" alt=\"\" class=\"wp-image-705\" srcset=\"https:\/\/weblog.uncasapart.fr\/wp-content\/uploads\/2024\/09\/image-2-1024x550.png 1024w, https:\/\/weblog.uncasapart.fr\/wp-content\/uploads\/2024\/09\/image-2-300x161.png 300w, https:\/\/weblog.uncasapart.fr\/wp-content\/uploads\/2024\/09\/image-2-768x413.png 768w, https:\/\/weblog.uncasapart.fr\/wp-content\/uploads\/2024\/09\/image-2.png 1409w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Cette erreur apparait lors de la visite de la galerie sans \u00eatre identifi\u00e9. Il s&rsquo;agit de la requ\u00eate qui enregistre les donn\u00e9es pour le compteur&#8230;<\/p>\n","protected":false},"author":1,"featured_media":702,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17,15,27],"tags":[39,40,42,43,44,41,45],"class_list":["post-701","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-blabla","category-informatique","category-photo","tag-coppermine","tag-galerie","tag-lamp","tag-mariadb","tag-mysql","tag-php","tag-phpmyadmin"],"_links":{"self":[{"href":"https:\/\/weblog.uncasapart.fr\/index.php\/wp-json\/wp\/v2\/posts\/701","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/weblog.uncasapart.fr\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/weblog.uncasapart.fr\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/weblog.uncasapart.fr\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/weblog.uncasapart.fr\/index.php\/wp-json\/wp\/v2\/comments?post=701"}],"version-history":[{"count":2,"href":"https:\/\/weblog.uncasapart.fr\/index.php\/wp-json\/wp\/v2\/posts\/701\/revisions"}],"predecessor-version":[{"id":707,"href":"https:\/\/weblog.uncasapart.fr\/index.php\/wp-json\/wp\/v2\/posts\/701\/revisions\/707"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/weblog.uncasapart.fr\/index.php\/wp-json\/wp\/v2\/media\/702"}],"wp:attachment":[{"href":"https:\/\/weblog.uncasapart.fr\/index.php\/wp-json\/wp\/v2\/media?parent=701"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/weblog.uncasapart.fr\/index.php\/wp-json\/wp\/v2\/categories?post=701"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/weblog.uncasapart.fr\/index.php\/wp-json\/wp\/v2\/tags?post=701"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}