(help
J'ai vraiment besoin d'aide là je vois pas mais pas du tout.
1 çà vient de la bdd, du fichier sql importé de mon site de prod
2 Y a un thème maison qui a donné lieu à la création d'un template
3 çà à l'air de marcher mais dés qu'on cherche à actualiser un module : on a "impossible d'insérer le template dans la base" "impossible de recompiler system_imagemanager.html" par exemple.
4 Quand je cherche à remplacer le jeu de thème par le thème par défaut j'obtiens une belle page blanche : nom-site/modules/system/admin.php?fct=preferences
5 Je peux supprimmer des templates dans le jeu de template mais pas les regénérer
Quand j'effectue la mise à jour du module system par exemple, j'ai :
INSERT INTO site_tplfile (tpl_id, tpl_module, tpl_refid, tpl_tplset, tpl_file, tpl_desc, tpl_lastmodified, tpl_lastimported, tpl_type) VALUES (0, 'system', 1, 'default', 'system_imagemanager2.html', '', 1161704769, 0, 'module')
Error number: 1062
Error message: Duplicate entry '0' for key 1
INSERT INTO site_tplfile (tpl_id, tpl_module, tpl_refid, tpl_tplset, tpl_file, tpl_desc, tpl_lastmodified, tpl_lastimported, tpl_type) VALUES (0, 'system', 1, 'default', 'system_userinfo.html', '', 1161704769, 0, 'module')
Error number: 1062
Error message: Duplicate entry '0' for key 1
INSERT INTO site_tplfile (tpl_id, tpl_module, tpl_refid, tpl_tplset, tpl_file, tpl_desc, tpl_lastmodified, tpl_lastimported, tpl_type) VALUES (0, 'system', 1, 'default', 'system_userform.html', '', 1161704769, 0, 'module')
Error number: 1062
Error message: Duplicate entry '0' for key 1
INSERT INTO site_tplfile (tpl_id, tpl_module, tpl_refid, tpl_tplset, tpl_file, tpl_desc, tpl_lastmodified, tpl_lastimported, tpl_type) VALUES (0, 'system', 1, 'default', 'system_rss.html', '', 1161704769, 0, 'module')
Error number: 1062
Error message: Duplicate entry '0' for key 1
INSERT INTO site_tplfile (tpl_id, tpl_module, tpl_refid, tpl_tplset, tpl_file, tpl_desc, tpl_lastmodified, tpl_lastimported, tpl_type) VALUES (0, 'system', 1, 'default', 'system_redirect.html', '', 1161704769, 0, 'module')
Error number: 1062
Error message: Duplicate entry '0' for key 1
INSERT INTO site_tplfile (tpl_id, tpl_module, tpl_refid, tpl_tplset, tpl_file, tpl_desc, tpl_lastmodified, tpl_lastimported, tpl_type) VALUES (0, 'system', 1, 'default', 'system_comment.html', '', 1161704769, 0, 'module')
Error number: 1062
Error message: Duplicate entry '0' for key 1
INSERT INTO site_tplfile (tpl_id, tpl_module, tpl_refid, tpl_tplset, tpl_file, tpl_desc, tpl_lastmodified, tpl_lastimported, tpl_type) VALUES (0, 'system', 1, 'default', 'system_comments_flat.html', '', 1161704769, 0, 'module')
Error number: 1062
Error message: Duplicate entry '0' for key 1
INSERT INTO site_tplfile (tpl_id, tpl_module, tpl_refid, tpl_tplset, tpl_file, tpl_desc, tpl_lastmodified, tpl_lastimported, tpl_type) VALUES (0, 'system', 1, 'default', 'system_comments_thread.html', '', 1161704769, 0, 'module')
Error number: 1062
Error message: Duplicate entry '0' for key 1
INSERT INTO site_tplfile (tpl_id, tpl_module, tpl_refid, tpl_tplset, tpl_file, tpl_desc, tpl_lastmodified, tpl_lastimported, tpl_type) VALUES (0, 'system', 1, 'default', 'system_comments_nest.html', '', 1161704769, 0, 'module')
Error number: 1062
Error message: Duplicate entry '0' for key 1
INSERT INTO site_tplfile (tpl_id, tpl_module, tpl_refid, tpl_tplset, tpl_file, tpl_desc, tpl_lastmodified, tpl_lastimported, tpl_type) VALUES (0, 'system', 1, 'default', 'system_siteclosed.html', '', 1161704769, 0, 'module')
Error number: 1062
Error message: Duplicate entry '0' for key 1
INSERT INTO site_tplfile (tpl_id, tpl_module, tpl_refid, tpl_tplset, tpl_file, tpl_desc, tpl_lastmodified, tpl_lastimported, tpl_type) VALUES (0, 'system', 1, 'default', 'system_dummy.html', 'Dummy template file for holding non-template contents. This should not be edited.', 1161704769, 0, 'module')
Error number: 1062
Error message: Duplicate entry '0' for key 1
INSERT INTO site_tplfile (tpl_id, tpl_module, tpl_refid, tpl_tplset, tpl_file, tpl_desc, tpl_lastmodified, tpl_lastimported, tpl_type) VALUES (0, 'system', 1, 'default', 'system_notification_list.html', '', 1161704769, 0, 'module')
Error number: 1062
Error message: Duplicate entry '0' for key 1
INSERT INTO site_tplfile (tpl_id, tpl_module, tpl_refid, tpl_tplset, tpl_file, tpl_desc, tpl_lastmodified, tpl_lastimported, tpl_type) VALUES (0, 'system', 1, 'default', 'system_notification_select.html', '', 1161704769, 0, 'module')
Error number: 1062
Error message: Duplicate entry '0' for key 1
INSERT INTO site_tplfile (tpl_id, tpl_module, tpl_refid, tpl_tplset, tpl_file, tpl_desc, tpl_lastmodified, tpl_lastimported, tpl_type) VALUES (0, 'system', 1, 'default', 'system_block_dummy.html', 'Dummy template for custom blocks or blocks without templates', 1161704769, 0, 'module')
Error number: 1062
Error message: Duplicate entry '0' for key 1
Sur le script d'upgrade mis à la disposition, en débug j'ai également :
INSERT INTO site_configcategory (confcat_id,confcat_name) VALUES (7,'_MD_AM_AUTHENTICATION')
Error number: 1062
Error message: Duplicate entry '7' for key 1
SELECT `conf_id` FROM `site_config` WHERE `conf_modid`=0 AND `conf_catid`=7 AND `conf_name`='auth_method'
INSERT INTO `site_config` (conf_modid,conf_catid,conf_name,conf_title,conf_value,conf_desc,conf_formtype,conf_valuetype,conf_order) VALUES ( 0,7,'auth_method','_MD_AM_AUTHMETHOD', 'xoops', '_MD_AM_AUTHMETHODDESC', 'select', 'text', 1)
Error number: 1062
Error message: Duplicate entry '0' for key 1
SELECT `conf_id` FROM `site_config` WHERE `conf_modid`=0 AND `conf_catid`=7 AND `conf_name`='ldap_port'
INSERT INTO `site_config` (conf_modid,conf_catid,conf_name,conf_title,conf_value,conf_desc,conf_formtype,conf_valuetype,conf_order) VALUES ( 0,7,'ldap_port','_MD_AM_LDAP_PORT', '389', '_MD_AM_LDAP_PORT', 'textbox', 'int', 2 )
Error number: 1062
Error message: Duplicate entry '0' for key 1
SELECT `conf_id` FROM `site_config` WHERE `conf_modid`=0 AND `conf_catid`=7 AND `conf_name`='ldap_server'
INSERT INTO `site_config` (conf_modid,conf_catid,conf_name,conf_title,conf_value,conf_desc,conf_formtype,conf_valuetype,conf_order) VALUES ( 0,7,'ldap_server','_MD_AM_LDAP_SERVER', 'your directory server', '_MD_AM_LDAP_SERVER_DESC', 'textbox', 'text', 3 )
Error number: 1062
Error message: Duplicate entry '0' for key 1
SELECT `conf_id` FROM `site_config` WHERE `conf_modid`=0 AND `conf_catid`=7 AND `conf_name`='ldap_manager_dn'
INSERT INTO `site_config` (conf_modid,conf_catid,conf_name,conf_title,conf_value,conf_desc,conf_formtype,conf_valuetype,conf_order) VALUES ( 0,7,'ldap_manager_dn','_MD_AM_LDAP_MANAGER_DN', 'manager_dn', '_MD_AM_LDAP_MANAGER_DN_DESC', 'textbox', 'text', 5)
Error number: 1062
Error message: Duplicate entry '0' for key 1
SELECT `conf_id` FROM `site_config` WHERE `conf_modid`=0 AND `conf_catid`=7 AND `conf_name`='ldap_manager_pass'
INSERT INTO `site_config` (conf_modid,conf_catid,conf_name,conf_title,conf_value,conf_desc,conf_formtype,conf_valuetype,conf_order) VALUES ( 0,7,'ldap_manager_pass','_MD_AM_LDAP_MANAGER_PASS', 'manager_pass', '_MD_AM_LDAP_MANAGER_PASS_DESC', 'textbox', 'text', 6)
Error number: 1062
Error message: Duplicate entry '0' for key 1
SELECT `conf_id` FROM `site_config` WHERE `conf_modid`=0 AND `conf_catid`=7 AND `conf_name`='ldap_version'
INSERT INTO `site_config` (conf_modid,conf_catid,conf_name,conf_title,conf_value,conf_desc,conf_formtype,conf_valuetype,conf_order) VALUES ( 0,7,'ldap_version','_MD_AM_LDAP_VERSION', '3', '_MD_AM_LDAP_VERSION_DESC', 'textbox', 'text', 7)
Error number: 1062
Error message: Duplicate entry '0' for key 1
SELECT `conf_id` FROM `site_config` WHERE `conf_modid`=0 AND `conf_catid`=7 AND `conf_name`='ldap_users_bypass'
INSERT INTO `site_config` (conf_modid,conf_catid,conf_name,conf_title,conf_value,conf_desc,conf_formtype,conf_valuetype,conf_order) VALUES ( 0,7,'ldap_users_bypass','_MD_AM_LDAP_USERS_BYPASS', 'a:1:{i:0;s:5:"admin";}', '_MD_AM_LDAP_USERS_BYPASS_DESC', 'textarea', 'array', 8)
Error number: 1062
Error message: Duplicate entry '0' for key 1
SELECT `conf_id` FROM `site_config` WHERE `conf_modid`=0 AND `conf_catid`=7 AND `conf_name`='ldap_loginname_asdn'
INSERT INTO `site_config` (conf_modid,conf_catid,conf_name,conf_title,conf_value,conf_desc,conf_formtype,conf_valuetype,conf_order) VALUES ( 0,7,'ldap_loginname_asdn','_MD_AM_LDAP_LOGINNAME_ASDN', 'uid_asdn', '_MD_AM_LDAP_LOGINNAME_ASDN_D', 'yesno', 'int', 9)
Error number: 1062
Error message: Duplicate entry '0' for key 1
SELECT `conf_id` FROM `site_config` WHERE `conf_modid`=0 AND `conf_catid`=7 AND `conf_name`='ldap_loginldap_attr'
INSERT INTO `site_config` (conf_modid,conf_catid,conf_name,conf_title,conf_value,conf_desc,conf_formtype,conf_valuetype,conf_order) VALUES ( 0,7,'ldap_loginldap_attr','_MD_AM_LDAP_LOGINLDAP_ATTR', 'uid', '_MD_AM_LDAP_LOGINLDAP_ATTR_D', 'textbox', 'text', 10)
Error number: 1062
Error message: Duplicate entry '0' for key 1
SELECT `conf_id` FROM `site_config` WHERE `conf_modid`=0 AND `conf_catid`=7 AND `conf_name`='ldap_filter_person'
INSERT INTO `site_config` (conf_modid,conf_catid,conf_name,conf_title,conf_value,conf_desc,conf_formtype,conf_valuetype,conf_order) VALUES ( 0,7,'ldap_filter_person','_MD_AM_LDAP_FILTER_PERSON', '', '_MD_AM_LDAP_FILTER_PERSON_DESC', 'textbox', 'text', 11)
Error number: 1062
Error message: Duplicate entry '0' for key 1
SELECT `conf_id` FROM `site_config` WHERE `conf_modid`=0 AND `conf_catid`=7 AND `conf_name`='ldap_domain_name'
INSERT INTO `site_config` (conf_modid,conf_catid,conf_name,conf_title,conf_value,conf_desc,conf_formtype,conf_valuetype,conf_order) VALUES ( 0,7,'ldap_domain_name','_MD_AM_LDAP_DOMAIN_NAME', 'mydomain', '_MD_AM_LDAP_DOMAIN_NAME_DESC', 'textbox', 'text', 12)
Error number: 1062
Error message: Duplicate entry '0' for key 1
SELECT `conf_id` FROM `site_config` WHERE `conf_modid`=0 AND `conf_catid`=7 AND `conf_name`='ldap_provisionning'
INSERT INTO `site_config` (conf_modid,conf_catid,conf_name,conf_title,conf_value,conf_desc,conf_formtype,conf_valuetype,conf_order) VALUES ( 0,7,'ldap_provisionning','_MD_AM_LDAP_PROVIS', '0', '_MD_AM_LDAP_PROVIS_DESC', 'yesno', 'int', 13)
Error number: 1062
Error message: Duplicate entry '0' for key 1
SELECT `conf_id` FROM `site_config` WHERE `conf_modid`=0 AND `conf_catid`=7 AND `conf_name`='ldap_provisionning_group'
INSERT INTO `site_config` (conf_modid,conf_catid,conf_name,conf_title,conf_value,conf_desc,conf_formtype,conf_valuetype,conf_order) VALUES ( 0,7,'ldap_provisionning_group','_MD_AM_LDAP_PROVIS_GROUP', 'a:1:{i:0;s:1:"2";}', '_MD_AM_LDAP_PROVIS_GROUP_DSC', 'group_multi', 'array', 14)
Error number: 1062
Error message: Duplicate entry '0' for key 1
SELECT `conf_id` FROM `site_config` WHERE `conf_modid`=0 AND `conf_catid`=7 AND `conf_name`='ldap_mail_attr'
INSERT INTO `site_config` (conf_modid,conf_catid,conf_name,conf_title,conf_value,conf_desc,conf_formtype,conf_valuetype,conf_order) VALUES ( 0,7,'ldap_mail_attr','_MD_AM_LDAP_MAIL_ATTR', 'mail', '_MD_AM_LDAP_MAIL_ATTR_DESC', 'textbox', 'text', 15)
Error number: 1062
Error message: Duplicate entry '0' for key 1
SELECT `conf_id` FROM `site_config` WHERE `conf_modid`=0 AND `conf_catid`=7 AND `conf_name`='ldap_givenname_attr'
INSERT INTO `site_config` (conf_modid,conf_catid,conf_name,conf_title,conf_value,conf_desc,conf_formtype,conf_valuetype,conf_order) VALUES ( 0,7,'ldap_givenname_attr','_MD_AM_LDAP_GIVENNAME_ATTR', 'givenname', '_MD_AM_LDAP_GIVENNAME_ATTR_DSC', 'textbox', 'text', 16)
Error number: 1062
Error message: Duplicate entry '0' for key 1
SELECT `conf_id` FROM `site_config` WHERE `conf_modid`=0 AND `conf_catid`=7 AND `conf_name`='ldap_surname_attr'
INSERT INTO `site_config` (conf_modid,conf_catid,conf_name,conf_title,conf_value,conf_desc,conf_formtype,conf_valuetype,conf_order) VALUES ( 0,7,'ldap_surname_attr','_MD_AM_LDAP_SURNAME_ATTR', 'sn', '_MD_AM_LDAP_SURNAME_ATTR_DESC', 'textbox', 'text', 17)
Error number: 1062
Error message: Duplicate entry '0' for key 1
SELECT `conf_id` FROM `site_config` WHERE `conf_modid`=0 AND `conf_catid`=7 AND `conf_name`='auth_method'
DELETE FROM `site_configoption` WHERE `conf_id`=0
INSERT INTO `site_configoption` (confop_name, confop_value, conf_id) VALUES ('_MD_AM_AUTH_CONFOPTION_XOOPS', 'xoops', 0)
INSERT INTO `site_configoption` (confop_name, confop_value, conf_id) VALUES ('_MD_AM_AUTH_CONFOPTION_LDAP', 'ldap', 0)
Error number: 1062
Error message: Duplicate entry '0' for key 1
INSERT INTO `site_configoption` (confop_name, confop_value, conf_id) VALUES ('_MD_AM_AUTH_CONFOPTION_AD', 'ad', 0)
Error number: 1062
Error message: Duplicate entry '0' for key 1
En espérant que ces précisions pourront être utiles boulet