Problème sql - Duplicate entry for key 'PRIMARY'”

**tradeymag** · 07/07/2023, 12h12

la premiere chose a faire dans systeme > configuration globale :
systeme > Débogage système > On
serveur > Rapport d'erreurs > maximum

et regarder ou poster ici le fichier qui retourne cette erreur , quelle function et quelle ligne

**Groug2115** · 07/07/2023, 12h59

Merci pour votre retour!
je viens de le faire mais je ne trouve pas le rapport d’erreur

**tradeymag** · 07/07/2023, 14h25

c'est impossible , si vous avez cette erreur tout est affiche, et on ne voit que ca
essaye de vider complètement le cache dans l'admin et dans le navigateur

**Groug2115** · 07/07/2023, 15h13

Voilà ce que j ai après avoir vidé le cache
merci d avance

37 statements were executed, 5 of which were duplicates, 32 unique91.82ms190.35KB

UniquesDuplicates 1Duplicates 2

SELECT@@SESSION.sql_mode;306μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
SELECT `data` FROM`mdqc6_session` WHERE`session_id` = ?549μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
DELETE FROM `mdqc6_session`WHERE `session_id` = 'jkrs2gkis46j5ub0i4rvm3ddji'63.37ms0B/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:179Copy
SELECT@@SESSION.sql_mode;262μs856B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
SELECT `data` FROM`mdqc6_session` WHERE`session_id` = ?442μs2.23KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
DELETE FROM `mdqc6_session`WHERE `session_id` = 'glpt37b7thv00c3ia12ujufifb'301μs0B/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:179Copy
SELECT@@SESSION.sql_mode;308μs856B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
SELECT `data` FROM`mdqc6_session` WHERE`session_id` = ?399μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
SELECT `extension_id` AS`id`,`element` AS`option`,`params`,`enabled`FROM `mdqc6_extensions` WHERE`type` = 'component' AND`state` = 0 AND `enabled` = 1898μs2.98KB/libraries/src/Component/ComponentHelper.php:399Copy
SELECT `id`,`rules` FROM`mdqc6_viewlevels`334μs976B/libraries/src/Access/Access.php:955Copy
SELECT `b`.`id` FROM`mdqc6_usergroups` AS `a`LEFT JOIN `mdqc6_usergroups`AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest383μs1.64KBParams/libraries/src/Access/Access.php:868Copy
SELECT `folder` AS`type`,`element` AS`name`,`params` AS`params`,`extension_id` AS`id` FROM `mdqc6_extensions`WHERE `enabled` = 1 AND`type` = 'plugin' AND `state`IN (0,1) AND `access` IN(reparedArray1,reparedArray2) ORDER BY`ordering`1.31ms4.3KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
SELECT * FROM`mdqc6_languages` WHERE`published` = 1 ORDER BY`ordering` ASC617μs2.23KB/libraries/src/Language/LanguageHelper.php:142Copy
SELECT`element`,`name`,`client_id`,`extension_id` FROM`mdqc6_extensions` WHERE`type` = 'language' AND`state` = 0 AND `enabled` = 1672μs1.17KB/libraries/src/Language/LanguageHelper.php:213Copy
SELECT id,template FROMmdqc6_template_styles WHEREclient_id=0 ANDhome=1381μs912B/administrator/components/com_widgetkit/widgetkit.php:28Copy
SELECT`m`.`id`,`m`.`menutype`,`m`.`title`,`m`.`ali as`,`m`.`note`,`m`.`link`,`m`.`type`,`m`.`level`,` m`.`language`,`m`.`browserNav`,`m`.`access`,`m`.`p arams`,`m`.`home`,`m`.`img`,`m`.`template_style_id `,`m`.`component_id`,`m`.`parent_id`,`m`.`path` AS`route`,`e`.`element` AS`component` FROM `mdqc6_menu`AS `m` LEFT JOIN`mdqc6_extensions` AS `e` ON`m`.`component_id` = `e`.`extension_id` WHERE ( (`m`.`published` = 1 AND`m`.`parent_id` > 0 AND`m`.`client_id` = 0) AND(`m`.`publish_up` IS NULL OR`m`.`publish_up` <= :currentDate1)) AND(`m`.`publish_down` IS NULLOR `m`.`publish_down` >= :currentDate2) ORDER BY`m`.`lft`1.06ms85.05KBParams/libraries/src/Menu/SiteMenu.php:166Copy
SELECT`template`,`id`,`title`,`params`,`home` FROM`mdqc6_template_styles` WHERE`id`='12'198μs3.56KB/libraries/astroid/framework/library/astroid/Template.php:218Copy
SELECT`id`,`home`,`template`,`s`.`params`,`inherit able`,`parent`FROM `mdqc6_template_styles`AS `s` LEFT JOIN`mdqc6_extensions` AS `e` ON`e`.`element` = `s`.`template` AND `e`.`type`= 'template' AND`e`.`client_id` = `s`.`client_id` WHERE`s`.`client_id` = 0 AND`e`.`enabled` = 1597μs1.16KB/administrator/components/com_templates/src/Model/StyleModel.php:771Copy
SELECT`id`,`name`,`rules`,`parent_id` FROM `mdqc6_assets` WHERE`name` IN(reparedArray1,reparedArray2,reparedArray3,reparedArray4,reparedArray5,reparedArray6,reparedArray7,reparedArray8,reparedArray9,reparedArray10,reparedArray11,reparedArray12,reparedArray13,reparedArray14,reparedArray15,reparedArray16,reparedArray17,reparedArray18,reparedArray19,reparedArray20,reparedArray21,reparedArray22,reparedArray23,reparedArray24,reparedArray25,reparedArray26,reparedArray27,reparedArray28,reparedArray29,reparedArray30,reparedArray31,reparedArray32,reparedArray33,reparedArray34,reparedArray35,reparedArray36,reparedArray37,reparedArray38,reparedArray39,reparedArray40,reparedArray41,reparedArray42)606μs7.75KBParams/libraries/src/Access/Access.php:357Copy
SELECT`id`,`name`,`rules`,`parent_id` FROM `mdqc6_assets` WHERE`name` LIKE :asset OR `name`= :extension OR `parent_id` = 0509μs2.67KBParams/libraries/src/Access/Access.php:301Copy
SHOW FULL COLUMNS FROM`mdqc6_content`935μs2.39KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
UPDATE `mdqc6_content` SET`hits` = (`hits` + 1) WHERE`id` = '13'4.9ms48B/libraries/src/Table/Table.php:1325Copy
SELECT`a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`ali as`,`a`.`introtext`,`a`.`fulltext`,`a`.`state`,`a` .`catid`,`a`.`created`,`a`.`created_by`,`a`.`creat ed_by_alias`,`a`.`modified`,`a`.`modified_by`,`a`. `checked_out`,`a`.`checked_out_time`,`a`.`publish_ up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a` .`attribs`,`a`.`version`,`a`.`ordering`,`a`.`metak ey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`me tadata`,`a`.`featured`,`a`.`language`,`fp`.`featur ed_up`,`fp`.`featured_down`,`c`.`title` AS`category_title`,`c`.`alias`AS`category_alias`,` c`.`access`AS`category_access`,`c`.`language` AS`category_language`,`fp`.`ordering`,`u`.`name` AS`author`,`parent`.`title` AS`parent_title`,`parent`.`id`AS`parent_id`,`paren t`.`path`AS`parent_route`,`parent`.`alias` AS`parent_alias`,`parent`.`language` AS`parent_language`,ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1) AS`rating`,`v`.`rating_count`AS `rating_count` FROM`mdqc6_content` AS `a` INNERJOIN `mdqc6_categories` AS`c` ON `c`.`id` = `a`.`catid`LEFT JOIN`mdqc6_content_frontpage` AS`fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN`mdqc6_users` AS `u` ON`u`.`id` = `a`.`created_by`LEFT JOIN `mdqc6_categories`AS `parent` ON `parent`.`id`= `c`.`parent_id` LEFT JOIN`mdqc6_content_rating` AS `v`ON `a`.`id` = `v`.`content_id` WHERE ( (`a`.`id` = k AND`c`.`published` > 0 AND`a`.`language` IN(reparedArray1,reparedArray2)) AND (`a`.`publish_up`IS NULL OR `a`.`publish_up`<= ublishUp)) AND(`a`.`publish_down` IS NULLOR `a`.`publish_down` >= ublishDown) AND `a`.`state`IN(reparedArray3,reparedArray4)733μs8.69KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
SELECT`c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`al ias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`. `created_time`,`c`.`created_user_id`,`c`.`descript ion`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c` .`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,` c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`p arams`,`c`.`parent_id`,`c`.`path`,`c`.`published`, `c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.` version`, CASE WHENCHAR_LENGTH(`c`.`alias`) != 0THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id`END as `slug` FROM`mdqc6_categories` AS `s`INNER JOIN `mdqc6_categories`AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language`IN(reparedArray3,reparedArray4)) OR (`c`.`lft` <= `s`.`lft` AND `s`.`rgt` <= `c`.`rgt`) WHERE(`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN(reparedArray1,reparedArray2) AND `c`.`published` = 1AND `s`.`id` = :id ORDER BY`c`.`lft`672μs5.22KBParams/libraries/src/Categories/Categories.php:375Copy
SELECT `m`.`tag_id`,`t`.* FROM`mdqc6_contentitem_tag_map`AS `m` INNER JOIN`mdqc6_tags` AS `t` ON`m`.`tag_id` = `t`.`id` WHERE`m`.`type_alias` = :contentType AND`m`.`content_item_id` = :id AND `t`.`published` = 1 AND`t`.`access` IN(reparedArray1,reparedArray2)424μs5.22KBParams/libraries/src/Helper/TagsHelper.php:388Copy
SELECT`c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`al ias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`. `created_time`,`c`.`created_user_id`,`c`.`descript ion`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c` .`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,` c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`p arams`,`c`.`parent_id`,`c`.`path`,`c`.`published`, `c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.` version`, CASE WHENCHAR_LENGTH(`c`.`alias`) != 0THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id`END as `slug` FROM`mdqc6_categories` AS `s`INNER JOIN `mdqc6_categories`AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language`IN(reparedArray3,reparedArray4)) OR (`c`.`lft` <= `s`.`lft` AND `s`.`rgt` <= `c`.`rgt`) WHERE(`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN(reparedArray1,reparedArray2) AND `c`.`published` = 1AND `s`.`id` = :id ORDER BY`c`.`lft`508μs5.22KBParams/libraries/src/Categories/Categories.php:375Copy
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required, a.only_use_in_subform,l.title AS language_title, l.image ASlanguage_image,uc.name ASeditor,ag.title ASaccess_level,ua.name ASauthor_name,g.title ASgroup_title, g.access asgroup_access, g.state ASgroup_state, g.note asgroup_note FROM mdqc6_fields AS a LEFT JOIN`mdqc6_languages` AS l ONl.lang_code = a.language LEFTJOIN mdqc6_users AS uc ONuc.id=a.checked_out LEFT JOINmdqc6_viewlevels AS ag ONag.id = a.access LEFT JOINmdqc6_users AS ua ON ua.id = a.created_user_id LEFT JOINmdqc6_fields_groups AS g ONg.id = a.group_id LEFT JOIN`mdqc6_fields_categories` ASfc ON fc.field_id = a.idWHERE ( (`a`.`context` = :context AND(`fc`.`category_id` IS NULLOR `fc`.`category_id` IN(reparedArray1,reparedArray2)) AND `a`.`access` IN(reparedArray3,reparedArray4)) AND (`a`.`group_id` = 0OR `g`.`access` IN(reparedArray5,reparedArray6)) AND `a`.`state` = :state) AND (`a`.`group_id` = 0 OR `g`.`state` = :gstate) AND `a`.`only_use_in_subform`= nly_use_in_subform AND`a`.`language` IN(reparedArray7,reparedArray8) ORDER BY a.ordering ASC1.17ms6.06KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
SELECT * FROM mdqc6_widgetkit WHERE id = "20"589μs1KB/administrator/components/com_widgetkit/vendor/yootheme/framework/plugins/joomla/src/Database.php:35Copy
UPDATE mdqc6_widgetkit SET id = 20, name = "2023-2024 Coupes / Pokale", type = "folder", data = "{"_widget":{"name":"gallery","data":{"gr id":"default","parallax":false,"parallax_tra nslate":"","gutter":"default","filter":" none","filter_tags":[],"filter_align":"left","filter_all":true,"c olumns":"2","columns_small":"3","columns_m edium":"3","columns_large":"4","columns_xl arge":"4","animation":"none","image_width\ ":"auto","image_height":"auto","media_borde r":"none","overlay":"default","panel":"b lank","overlay_center":"icon","overlay_backg round":"hover","overlay_image":false,"hover_ overlay":true,"overlay_animation":"fade","im age_animation":"scale-up","title":false,"content":false,"title_siz e":"h3","title_element":"h3","link":false ,"link_style":"button","link_icon":"share" ,"link_text":"View","lightbox":"default",\ "lightbox_caption":"title","lightbox_nav_width ":"70","lightbox_nav_height":"70","lightbo x_nav_contrast":true,"lightbox_title_size":"h3 ","lightbox_title_element":"h3","lightbox_co ntent_size":"","lightbox_content_width":"", "lightbox_width":"auto","lightbox_height":" auto","lightbox_alt":false,"lightbox_link":fa lse,"lightbox_style":"button","lightbox_icon\ ":"search","lightbox_text":"Details","link_ target":false,"class":""}},"folder":"image s\\/Coupes-Pokale","sort_by":"filename_asc","strip_lead ing_numbers":false,"strip_trailing_numbers":fal se,"prepared":"[{\\"title\\":\\"SOMEX CATALOGUE20232024-001\\",\\"media\\":\\"images\\\\\\/Coupes-Pokale\\\\\\/SOMEX_CATALOGUE20232024-001.jpg\\"},{\\"title\\":\\"SOMEX CATALOGUE20232024-002\\",\\"media\\":\\"images\\\\\\/Coupes-Pokale\\\\\\/SOMEX_CATALOGUE20232024-002.jpg\\"},{\\"title\\":\\"SOMEX CATALOGUE20232024-003\\",\\"media\\":\\"images\\\\\\/Coupes-Pokale\\\\\\/SOMEX_CATALOGUE20232024-003.jpg\\"},{\\"title\\":\\"SOMEX CATALOGUE20232024-004\\",\\"media\\":\\"images\\\\\\/Coupes-Pokale\\\\\\/SOMEX_CATALOGUE20232024-004.jpg\\"},{\\"title\\":\\"SOMEX CATALOGUE20232024-005\\",\\"media\\":\\"images\\\\\\/Coupes-Pokale\\\\\\/SOMEX_CATALOGUE20232024-005.jpg\\"},{\\"title\\":\\"SOMEX CATALOGUE20232024-006\\",\\"media\\":\\"images\\\\\\/Coupes-Pokale\\\\\\/SOMEX_CATALOGUE20232024-006.jpg\\"},{\\"title\\":\\"SOMEX CATALOGUE20232024-007\\",\\"media\\":\\"images\\\\\\/Coupes-Pokale\\\\\\/SOMEX_CATALOGUE20232024-007.jpg\\"},{\\"title\\":\\"SOMEX CATALOGUE20232024-008\\",\\"media\\":\\"images\\\\\\/Coupes-Pokale\\\\\\/SOMEX_CATALOGUE20232024-008.jpg\\"},{\\"title\\":\\"SOMEX CATALOGUE20232024-009\\",\\"media\\":\\"images\\\\\\/Coupes-Pokale\\\\\\/SOMEX_CATALOGUE20232024-009.jpg\\"},{\\"title\\":\\"SOMEX CATALOGUE20232024-010\\",\\"media\\":\\"images\\\\\\/Coupes-Pokale\\\\\\/SOMEX_CATALOGUE20232024-010.jpg\\"},{\\"title\\":\\"SOMEX CATALOGUE20232024-011\\",\\"media\\":\\"images\\\\\\/Coupes-Pokale\\\\\\/SOMEX_CATALOGUE20232024-011.jpg\\"},{\\"title\\":\\"SOMEX CATALOGUE20232024-012\\",\\"media\\":\\"images\\\\\\/Coupes-Pokale\\\\\\/SOMEX_CATALOGUE20232024-012.jpg\\"},{\\"title\\":\\"SOMEX CATALOGUE20232024-013\\",\\"media\\":\\"images\\\\\\/Coupes-Pokale\\\\\\/SOMEX_CATALOGUE20232024-013.jpg\\"},{\\"title\\":\\"SOMEX CATALOGUE20232024-014\\",\\"media\\":\\"images\\\\\\/Coupes-Pokale\\\\\\/SOMEX_CATALOGUE20232024-014.jpg\\"},{\\"title\\":\\"SOMEX CATALOGUE20232024-015\\",\\"media\\":\\"images\\\\\\/Coupes-Pokale\\\\\\/SOMEX_CATALOGUE20232024-015.jpg\\"},{\\"title\\":\\"SOMEX CATALOGUE20232024-016\\",\\"media\\":\\"images\\\\\\/Coupes-Pokale\\\\\\/SOMEX_CATALOGUE20232024-016.jpg\\"},{\\"title\\":\\"SOMEX CATALOGUE20232024-017\\",\\"media\\":\\"images\\\\\\/Coupes-Pokale\\\\\\/SOMEX_CATALOGUE20232024-017.jpg\\"},{\\"title\\":\\"SOMEX CATALOGUE20232024-018\\",\\"media\\":\\"images\\\\\\/Coupes-Pokale\\\\\\/SOMEX_CATALOGUE20232024-018.jpg\\"},{\\"title\\":\\"SOMEX CATALOGUE20232024-019\\",\\"media\\":\\"images\\\\\\/Coupes-Pokale\\\\\\/SOMEX_CATALOGUE20232024-019.jpg\\"},{\\"title\\":\\"SOMEX CATALOGUE20232024-020\\",\\"media\\":\\"images\\\\\\/Coupes-Pokale\\\\\\/SOMEX_CATALOGUE20232024-020.jpg\\"},{\\"title\\":\\"SOMEX CATALOGUE20232024-021\\",\\"media\\":\\"images\\\\\\/Coupes-Pokale\\\\\\/SOMEX_CATALOGUE20232024-021.jpg\\"},{\\"title\\":\\"SOMEX CATALOGUE20232024-022\\",\\"media\\":\\"images\\\\\\/Coupes-Pokale\\\\\\/SOMEX_CATALOGUE20232024-022.jpg\\"},{\\"title\\":\\"SOMEX CATALOGUE20232024-023\\",\\"media\\":\\"images\\\\\\/Coupes-Pokale\\\\\\/SOMEX_CATALOGUE20232024-023.jpg\\"},{\\"title\\":\\"SOMEX CATALOGUE20232024-024\\",\\"media\\":\\"images\\\\\\/Coupes-Pokale\\\\\\/SOMEX_CATALOGUE20232024-024.jpg\\"},{\\"title\\":\\"SOMEX CATALOGUE20232024-025\\",\\"media\\":\\"images\\\\\\/Coupes-Pokale\\\\\\/SOMEX_CATALOGUE20232024-025.jpg\\"},{\\"title\\":\\"SOMEX CATALOGUE20232024-026\\",\\"media\\":\\"images\\\\\\/Coupes-Pokale\\\\\\/SOMEX_CATALOGUE20232024-026.jpg\\"},{\\"title\\":\\"SOMEX CATALOGUE20232024-027\\",\\"media\\":\\"images\\\\\\/Coupes-Pokale\\\\\\/SOMEX_CATALOGUE20232024-027.jpg\\"},{\\"title\\":\\"SOMEX CATALOGUE20232024-028\\",\\"media\\":\\"images\\\\\\/Coupes-Pokale\\\\\\/SOMEX_CATALOGUE20232024-028.jpg\\"},{\\"title\\":\\"SOMEX CATALOGUE20232024-029\\",\\"media\\":\\"images\\\\\\/Coupes-Pokale\\\\\\/SOMEX_CATALOGUE20232024-029.jpg\\"},{\\"title\\":\\"SOMEX CATALOGUE20232024-030\\",\\"media\\":\\"images\\\\\\/Coupes-Pokale\\\\\\/SOMEX_CATALOGUE20232024-030.jpg\\"},{\\"title\\":\\"SOMEX CATALOGUE20232024-031\\",\\"media\\":\\"images\\\\\\/Coupes-Pokale\\\\\\/SOMEX_CATALOGUE20232024-031.jpg\\"},{\\"title\\":\\"SOMEX CATALOGUE20232024-032\\",\\"media\\":\\"images\\\\\\/Coupes-Pokale\\\\\\/SOMEX_CATALOGUE20232024-032.jpg\\"},{\\"title\\":\\"SOMEX CATALOGUE20232024-033\\",\\"media\\":\\"images\\\\\\/Coupes-Pokale\\\\\\/SOMEX_CATALOGUE20232024-033.jpg\\"},{\\"title\\":\\"SOMEX CATALOGUE20232024-034\\",\\"media\\":\\"images\\\\\\/Coupes-Pokale\\\\\\/SOMEX_CATALOGUE20232024-034.jpg\\"},{\\"title\\":\\"SOMEX CATALOGUE20232024-035\\",\\"media\\":\\"images\\\\\\/Coupes-Pokale\\\\\\/SOMEX_CATALOGUE20232024-035.jpg\\"},{\\"title\\":\\"SOMEX CATALOGUE20232024-036\\",\\"media\\":\\"images\\\\\\/Coupes-Pokale\\\\\\/SOMEX_CATALOGUE20232024-036.jpg\\"},{\\"title\\":\\"SOMEX CATALOGUE20232024-037\\",\\"media\\":\\"images\\\\\\/Coupes-Pokale\\\\\\/SOMEX_CATALOGUE20232024-037.jpg\\"},{\\"title\\":\\"SOMEX CATALOGUE20232024-038\\",\\"media\\":\\"images\\\\\\/Coupes-Pokale\\\\\\/SOMEX_CATALOGUE20232024-038.jpg\\"},{\\"title\\":\\"SOMEX CATALOGUE20232024-039\\",\\"media\\":\\"images\\\\\\/Coupes-Pokale\\\\\\/SOMEX_CATALOGUE20232024-039.jpg\\"},{\\"title\\":\\"SOMEX CATALOGUE20232024-040\\",\\"media\\":\\"images\\\\\\/Coupes-Pokale\\\\\\/SOMEX_CATALOGUE20232024-040.jpg\\"},{\\"title\\":\\"SOMEX CATALOGUE20232024-041\\",\\"media\\":\\"images\\\\\\/Coupes-Pokale\\\\\\/SOMEX_CATALOGUE20232024-041.jpg\\"},{\\"title\\":\\"SOMEX CATALOGUE20232024-042\\",\\"media\\":\\"images\\\\\\/Coupes-Pokale\\\\\\/SOMEX_CATALOGUE20232024-042.jpg\\"},{\\"title\\":\\"SOMEX CATALOGUE20232024-043\\",\\"media\\":\\"images\\\\\\/Coupes-Pokale\\\\\\/SOMEX_CATALOGUE20232024-043.jpg\\"},{\\"title\\":\\"SOMEX CATALOGUE20232024-044\\",\\"media\\":\\"images\\\\\\/Coupes-Pokale\\\\\\/SOMEX_CATALOGUE20232024-044.jpg\\"},{\\"title\\":\\"SOMEX CATALOGUE20232024-045\\",\\"media\\":\\"images\\\\\\/Coupes-Pokale\\\\\\/SOMEX_CATALOGUE20232024-045.jpg\\"},{\\"title\\":\\"SOMEX CATALOGUE20232024-046\\",\\"media\\":\\"images\\\\\\/Coupes-Pokale\\\\\\/SOMEX_CATALOGUE20232024-046.jpg\\"},{\\"title\\":\\"SOMEX CATALOGUE20232024-047\\",\\"media\\":\\"images\\\\\\/Coupes-Pokale\\\\\\/SOMEX_CATALOGUE20232024-047.jpg\\"},{\\"title\\":\\"SOMEX CATALOGUE20232024-048\\",\\"media\\":\\"images\\\\\\/Coupes-Pokale\\\\\\/SOMEX_CATALOGUE20232024-048.jpg\\"},{\\"title\\":\\"SOMEX CATALOGUE20232024-049\\",\\"media\\":\\"images\\\\\\/Coupes-Pokale\\\\\\/SOMEX_CATALOGUE20232024-049.jpg\\"},{\\"title\\":\\"SOMEX CATALOGUE20232024-050\\",\\"media\\":\\"images\\\\\\/Coupes-Pokale\\\\\\/SOMEX_CATALOGUE20232024-050.jpg\\"},{\\"title\\":\\"SOMEX CATALOGUE20232024-051\\",\\"media\\":\\"images\\\\\\/Coupes-Pokale\\\\\\/SOMEX_CATALOGUE20232024-051.jpg\\"},{\\"title\\":\\"SOMEX CATALOGUE20232024-052\\",\\"media\\":\\"images\\\\\\/Coupes-Pokale\\\\\\/SOMEX_CATALOGUE20232024-052.jpg\\"},{\\"title\\":\\"SOMEX CATALOGUE20232024-053\\",\\"media\\":\\"images\\\\\\/Coupes-Pokale\\\\\\/SOMEX_CATALOGUE20232024-053.jpg\\"},{\\"title\\":\\"SOMEX CATALOGUE20232024-054\\",\\"media\\":\\"images\\\\\\/Coupes-Pokale\\\\\\/SOMEX_CATALOGUE20232024-054.jpg\\"},{\\"title\\":\\"SOMEX CATALOGUE20232024-055\\",\\"media\\":\\"images\\\\\\/Coupes-Pokale\\\\\\/SOMEX_CATALOGUE20232024-055.jpg\\"},{\\"title\\":\\"SOMEX CATALOGUE20232024-056\\",\\"media\\":\\"images\\\\\\/Coupes-Pokale\\\\\\/SOMEX_CATALOGUE20232024-056.jpg\\"}]","hash":"65a778aa21cdebbafb09d43d86d3db71",\ "hashed":1688738694}" WHEREid = 204.52ms48B/administrator/components/com_widgetkit/vendor/yootheme/framework/plugins/joomla/src/Database.php:51Copy
SELECT `params` FROM`mdqc6_categories` WHERE`id`=10184μs808B/libraries/astroid/framework/article.php:603Copy
SELECT `language`,`id` FROM`mdqc6_menu` WHERE `home` = '1' AND `published` = 1 AND`client_id` = 0323μs960B/libraries/src/Language/Multilanguage.php:123Copy
SELECT`c2`.`language`,`c2`.`id`FROM `mdqc6_menu` AS `c`INNER JOIN`mdqc6_associations` AS `a`ON `a`.`id` = `c`.`id` AND`a`.`context` = :context INNER JOIN`mdqc6_associations` AS `a2`ON `a`.`key` = `a2`.`key`INNER JOIN `mdqc6_menu` AS`c2` ON `a2`.`id` = `c2`.`id`WHERE `c`.`id` = :id270μs1.69KBParams/libraries/src/Language/Associations.php:145Copy
SELECT`c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS`id`,CONCAT_WS(':', `ca`.`id`, `ca`.`alias`) AS`catid` FROM `mdqc6_content`AS `c` INNER JOIN`mdqc6_associations` AS `a`ON `a`.`id` = `c`.`id` AND`a`.`context` = :context INNER JOIN`mdqc6_associations` AS `a2`ON `a`.`key` = `a2`.`key`INNER JOIN `mdqc6_content` AS`c2` ON `a2`.`id` = `c2`.`id`INNER JOIN `mdqc6_categories`AS `ca` ON `c2`.`catid` = `ca`.`id` AND`ca`.`extension` = :extension2 WHERE `c`.`id` = :id AND c2.access IN (1,5) AND c2.language != 'fr-FR'AND (c2.publish_up IS NULL ORc2.publish_up <= '2023-07-07 14:04:54') AND(c2.publish_down IS NULL ORc2.publish_down >= '2023-07-07 14:04:54') ANDc2.state = 1325μs12.78KBParams/libraries/src/Language/Associations.php:145Copy
SELECT`m`.`id`,`m`.`title`,`m`.`module`,`m`.`posit ion`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`m m`.`menuid` FROM`mdqc6_modules` AS `m` LEFTJOIN `mdqc6_modules_menu` AS`mm` ON `mm`.`moduleid` = `m`.`id` LEFT JOIN`mdqc6_extensions` AS `e` ON`e`.`element` = `m`.`module`AND `e`.`client_id` = `m`.`client_id` WHERE ( ( (`m`.`published` = 1 AND`e`.`enabled` = 1 AND`m`.`client_id` = :clientId AND `m`.`access` IN(reparedArray1,reparedArray2)) AND (`m`.`publish_up`IS NULL OR `m`.`publish_up`<= ublishUp)) AND(`m`.`publish_down` IS NULLOR `m`.`publish_down` >= ublishDown)) AND(`mm`.`menuid` = :itemId OR`mm`.`menuid` <= 0) AND`m`.`language` IN(reparedArray3,reparedArray4) ORDER BY`m`.`position`,`m`.`ordering`932μs2.31KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required, a.only_use_in_subform,l.title AS language_title, l.image ASlanguage_image,uc.name ASeditor,ag.title ASaccess_level,ua.name ASauthor_name,g.title ASgroup_title, g.access asgroup_access, g.state ASgroup_state, g.note asgroup_note FROM mdqc6_fields AS a LEFT JOIN`mdqc6_languages` AS l ONl.lang_code = a.language LEFTJOIN mdqc6_users AS uc ONuc.id=a.checked_out LEFT JOINmdqc6_viewlevels AS ag ONag.id = a.access LEFT JOINmdqc6_users AS ua ON ua.id = a.created_user_id LEFT JOINmdqc6_fields_groups AS g ONg.id = a.group_id WHERE ( (`a`.`context` = :context AND`a`.`access` IN(reparedArray1,reparedArray2)) AND (`a`.`group_id` = 0OR `g`.`access` IN(reparedArray3,reparedArray4)) AND `a`.`state` = :state) AND (`a`.`group_id` = 0 OR `g`.`state` = :gstate) AND `a`.`only_use_in_subform`= nly_use_in_subform AND`a`.`language` IN(reparedArray5,reparedArray6) ORDER BY a.ordering ASC1.19ms6KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
SELECT`a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`typ e`,`a`.`execution_rules`,`a`.`state`,`a`.`last_exi t_code`,`a`.`locked`,`a`.`last_execution`,`a`.`nex t_execution`,`a`.`times_executed`,`a`.`times_faile d`,`a`.`priority`,`a`.`ordering`,`a`.`note`,`a`.`c hecked_out`,`a`.`checked_out_time`,`uc`.`name`AS `editor` FROM`mdqc6_scheduler_tasks` AS`a` LEFT JOIN `mdqc6_users`AS `uc` ON `uc`.`id` = `a`.`checked_out` WHERE`a`.`state` = :state AND`a`.`next_execution` <= :now ORDER BY `a`.`title`asc326μs4.45KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:391Copy
SELECT`a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`typ e`,`a`.`execution_rules`,`a`.`state`,`a`.`last_exi t_code`,`a`.`locked`,`a`.`last_execution`,`a`.`nex t_execution`,`a`.`times_executed`,`a`.`times_faile d`,`a`.`priority`,`a`.`ordering`,`a`.`note`,`a`.`c hecked_out`,`a`.`checked_out_time`,`uc`.`name`AS `editor` FROM`mdqc6_scheduler_tasks` AS`a` LEFT JOIN `mdqc6_users`AS `uc` ON `uc`.`id` = `a`.`checked_out` WHERE`a`.`state` = :state AND`a`.`locked` IS NOT NULLORDER BY `a`.`title` asc304μs

**tradeymag** · 07/07/2023, 15h38

ca semble une erreur de permissions
essaye dans la configuration de changer
System > Global Configuration > System > Session > Session Handler: Database / Fichier
essaye les deux et a chaque fois vide le cache pour voir si ca règle ton problème

**RobertG** · 07/07/2023, 15h42

Bonjour,

Un "duplicate" signifie très probablement que la colonne concernée n'est pas en autoincrément, à voir donc dans la base de données.

**Groug2115** · 07/07/2023, 15h52

Malheureusement ça ne change rien!
j’avais Aesecure sur ce site, est ce que cela peut poser problème ?
merci

**tradeymag** · 07/07/2023, 16h02

essaye de virer Aesecure et voir ce que ca donne

**RobertG** · 07/07/2023, 16h27

"Duplicate entry" sur un index veut dire que la requête essaie d'insérer dans la table une ligne dont le champ de cet index a déjà la valeur qu'on tente d'insérer, ce qui est interdit. Rien à voir avec aeSecure qui ne touche en rien Joomla! et son contenu.
La colonne concernant cet index n'est probablement pas en autoincrément comme je l'ai dit, reste à trouver quelle table est concernée.

**tradeymag** · 07/07/2023, 16h35

je vois pas comment un auto increment aurait pu sauter

**RobertG** · 07/07/2023, 16h39

Et pourtant, ce n'est pas la première fois qu'on le voit ici.

**Groug2115** · 07/07/2023, 16h52

Je vais chercher dans chaque table.
c’est bien le ID qui doit être auto incrément? sur chaque structure de table?

**RobertG** · 07/07/2023, 18h00

Le ID ou un autre champ servant d'index, donc sans doublon possible.

**Groug2115** · 09/07/2023, 18h08

Bonjour,
j’ai parcouru toutes les tables et structure,
voici les noms des tables et nom de la structure de la table qui ont une clé primaire et pas d’auto incrément.
j’espère avoir cherché où il fallait
merci d’avance pour votre aide

action_logs_users	id
ackeebabackup_storage	tag
ackeeba_common	key
associations	idea
associations	context
banner_tracks	track_date
banner_tracks	track_type
banner_tracks	banner_id
content_frontpage	content_idea
content_rating	content_idea
fields_categories	field_idea
fields_categories	category_idea
finder_links_terms	link_id
finder_links_terms	term_id
finder_links_terms (0, 1, 2, 3, 4, 5, 6, 7, 8, 9, sa, sb, sc, sd, se, sf)	link_id
finder_links_terms (0, 1, 2, 3, 4, 5, 6, 7, 8, 9, sa, sb, sc, sd, se, sf)	term_id
finder_logging	md5sum
finder_taxonomy_map	link_id
finder_taxonomy_map	node_id
mail_templates	template_id
mail_templates	language
module_menu	moduleid
module_menu	menuid
schemas	extension_id
schemas	version_id
session	session_id
ucm_base	ucm_id
update_sites_extensions	update_site_id
update_sites_extensions	extension_id
user_usergroup_map	user_id
user_usergroup_map	group_id
webauthn_credentials	id
workflow_associations	item_id
workflow_associations	extension

Problème sql - Duplicate entry for key 'PRIMARY'”

Problème sql - Duplicate entry for key 'PRIMARY'”

Commentaire

Commentaire

Commentaire

Commentaire

Commentaire

Commentaire

Commentaire

Commentaire

Commentaire

Commentaire

Commentaire

Commentaire

Commentaire

Commentaire

Annonce

Partenaire de l'association