Pb Mise à jour 0.68.3-> 0.7 PB alter mailing signature

pcrampette · 2008-01-02 12:40:37

Bonjour

lors de la mise à jour de la base, j'ai le message suivant

0.7 alter mailing signature in glpi_configErreur durant la mise à jour de la base de donnéesBLOB/TEXT column 'mailing_signature' used in key specification without a key length.

J'utilise un hébergement OVH en Mysql5.0.44.

MoYo · 2008-01-02 13:30:56

bizarre c'est cette requete qui pose probleme :
ALTER TABLE `glpi_config` CHANGE `mailing_signature` `mailing_signature` TEXT NULL

et ce champ n'est pas dans une cle normalement.
Est-ce bien le cas dans votre DB ?

pcrampette · 2008-01-02 13:48:48

Je ne connais pas la config de la base car hébergé chez ovh.

J'ai essayé de passer la commande manuellement par phpmyadmin, meme resultat.

J'ai supprimé les lignes correspondantes dans le fichiers update_0681_07.php et la mise à jour s'est bien passée.

Reste à voir quel sera l'impact de cette Non mise à jour de la table.

MoYo · 2008-01-02 14:09:17

quelle est la config exacte de glpi_config depusi phpmadmin ?
si vous faites un export de la table (juste la structure)

pcrampette · 2008-01-02 15:09:35

Voici la structure du Fichier

--
-- Structure de la table `glpi_config`
--

CREATE TABLE `glpi_config` (
`ID` int(11) NOT NULL auto_increment,
`ldap_port` varchar(255) collate utf8_unicode_ci default '389',
`num_of_events` varchar(255) collate utf8_unicode_ci default NULL,
`jobs_at_login` varchar(255) collate utf8_unicode_ci default NULL,
`sendexpire` varchar(255) collate utf8_unicode_ci default NULL,
`cut` varchar(255) collate utf8_unicode_ci default NULL,
`expire_events` varchar(255) collate utf8_unicode_ci default NULL,
`list_limit` int(11) default '20',
`list_limit_max` int(11) NOT NULL default '50',
`version` varchar(255) collate utf8_unicode_ci default NULL,
`logotxt` varchar(255) collate utf8_unicode_ci default NULL,
`event_loglevel` varchar(255) collate utf8_unicode_ci default NULL,
`mailing` varchar(255) collate utf8_unicode_ci default NULL,
`imap_auth_server` varchar(255) collate utf8_unicode_ci default NULL,
`imap_host` varchar(255) collate utf8_unicode_ci default NULL,
`ldap_host` varchar(255) collate utf8_unicode_ci default NULL,
`ldap_basedn` varchar(255) collate utf8_unicode_ci default NULL,
`ldap_rootdn` varchar(255) collate utf8_unicode_ci default NULL,
`ldap_pass` varchar(255) collate utf8_unicode_ci default NULL,
`admin_email` varchar(255) collate utf8_unicode_ci default NULL,
`mailing_signature` varchar(255) collate utf8_unicode_ci default '--',
`ldap_field_email` varchar(255) collate utf8_unicode_ci default NULL,
`ldap_field_location` varchar(255) collate utf8_unicode_ci default NULL,
`ldap_field_realname` varchar(255) collate utf8_unicode_ci default NULL,
`ldap_field_firstname` varchar(255) collate utf8_unicode_ci default NULL,
`ldap_field_phone` varchar(255) collate utf8_unicode_ci default NULL,
`ldap_field_phone2` varchar(255) collate utf8_unicode_ci default NULL,
`ldap_field_mobile` varchar(255) collate utf8_unicode_ci default NULL,
`ldap_condition` varchar(255) collate utf8_unicode_ci default NULL,
`ldap_login` varchar(255) collate utf8_unicode_ci default 'uid',
`ldap_use_tls` varchar(255) collate utf8_unicode_ci default NULL,
`permit_helpdesk` varchar(255) collate utf8_unicode_ci default NULL,
`default_language` varchar(255) collate utf8_unicode_ci default 'french',
`priority_1` varchar(255) collate utf8_unicode_ci default '#fff2f2',
`priority_2` varchar(255) collate utf8_unicode_ci default '#ffe0e0',
`priority_3` varchar(255) collate utf8_unicode_ci default '#ffcece',
`priority_4` varchar(255) collate utf8_unicode_ci default '#ffbfbf',
`priority_5` varchar(255) collate utf8_unicode_ci default '#ffadad',
`date_fiscale` date NOT NULL default '2005-12-31',
`cartridges_alarm` int(11) NOT NULL default '10',
`cas_host` varchar(255) collate utf8_unicode_ci default NULL,
`cas_port` varchar(255) collate utf8_unicode_ci default NULL,
`cas_uri` varchar(255) collate utf8_unicode_ci default NULL,
`cas_logout` varchar(255) collate utf8_unicode_ci default NULL,
`planning_begin` time NOT NULL default '08:00:00',
`planning_end` time NOT NULL default '20:00:00',
`utf8_conv` int(11) NOT NULL default '0',
`auto_assign` smallint(6) NOT NULL default '0',
`public_faq` smallint(6) NOT NULL default '0',
`url_base` varchar(255) collate utf8_unicode_ci default NULL,
`url_in_mail` smallint(6) NOT NULL default '0',
`text_login` text collate utf8_unicode_ci,
`auto_update_check` smallint(6) NOT NULL default '0',
`founded_new_version` varchar(255) collate utf8_unicode_ci default NULL,
`dropdown_max` int(11) NOT NULL default '100',
`ajax_wildcard` char(1) collate utf8_unicode_ci default '*',
`use_ajax` smallint(6) NOT NULL default '0',
`ajax_limit_count` int(11) NOT NULL default '50',
`ajax_autocompletion` smallint(6) NOT NULL default '1',
`auto_add_users` smallint(6) NOT NULL default '1',
`dateformat` smallint(6) NOT NULL default '0',
`nextprev_item` varchar(255) collate utf8_unicode_ci default 'name',
`view_ID` smallint(6) NOT NULL default '0',
`dropdown_limit` int(11) NOT NULL default '50',
`ocs_mode` smallint(6) NOT NULL default '0',
`debug` int(2) NOT NULL default '0',
`use_cache` smallint(6) NOT NULL default '1',
`smtp_mode` smallint(6) NOT NULL default '0',
`smtp_host` varchar(255) collate utf8_unicode_ci default NULL,
`smtp_port` int(11) NOT NULL default '25',
`smtp_username` varchar(255) collate utf8_unicode_ci default NULL,
`smtp_password` varchar(255) collate utf8_unicode_ci default NULL,
`proxy_name` varchar(255) collate utf8_unicode_ci default NULL,
`proxy_port` varchar(255) collate utf8_unicode_ci default '8080',
`proxy_user` varchar(255) collate utf8_unicode_ci default NULL,
`proxy_password` varchar(255) collate utf8_unicode_ci default NULL,
`followup_on_update_ticket` smallint(6) NOT NULL default '1',
`ldap_field_group` varchar(255) collate utf8_unicode_ci default NULL,
`contract_alerts` smallint(6) NOT NULL default '0',
`infocom_alerts` smallint(6) NOT NULL default '0',
`cartridges_alert` int(11) NOT NULL default '0',
`consumables_alert` int(11) NOT NULL default '0',
`keep_tracking_on_delete` int(11) default '1',
`show_admin_doc` int(11) default '0',
`time_step` int(11) default '5',
`ldap_group_condition` varchar(255) collate utf8_unicode_ci default NULL,
`ldap_search_for_groups` smallint(6) NOT NULL default '0',
`ldap_field_group_member` varchar(255) collate utf8_unicode_ci default NULL,
`decimal_number` int(11) default '2',
`helpdeskhelp_url` varchar(255) collate utf8_unicode_ci default NULL,
`centralhelp_url` varchar(255) collate utf8_unicode_ci default NULL,
`default_rubdoc_tracking` int(11) default '0',
`monitors_management_restrict` int(1) NOT NULL default '2',
`phones_management_restrict` int(1) NOT NULL default '2',
`peripherals_management_restrict` int(1) NOT NULL default '2',
`printers_management_restrict` int(1) NOT NULL default '2',
`licenses_management_restrict` int(1) NOT NULL default '2',
`license_deglobalisation` int(1) NOT NULL default '1',
`use_errorlog` int(1) NOT NULL default '0',
`glpi_timezone` varchar(255) collate utf8_unicode_ci default NULL,
`autoupdate_link_contact` smallint(6) NOT NULL default '1',
`autoupdate_link_user` smallint(6) NOT NULL default '1',
`autoupdate_link_group` smallint(6) NOT NULL default '1',
`autoupdate_link_location` smallint(6) NOT NULL default '1',
`flat_dropdowntree` smallint(6) NOT NULL default '0',
`autoname_entity` smallint(6) NOT NULL default '1',
`expand_soft_categorized` int(1) NOT NULL default '1',
`expand_soft_not_categorized` int(1) NOT NULL default '1',
PRIMARY KEY (`ID`),
KEY `ID` (`ID`),
KEY `admin_email` (`admin_email`),
KEY `ajax_autocompletion` (`ajax_autocompletion`),
KEY `ajax_limit_count` (`ajax_limit_count`),
KEY `ajax_wildcard` (`ajax_wildcard`),
KEY `auto_add_users` (`auto_add_users`),
KEY `auto_update_check` (`auto_update_check`),
KEY `cartridges_alarm` (`cartridges_alarm`),
KEY `cartridges_alert` (`cartridges_alert`),
KEY `cas_host` (`cas_host`),
KEY `cas_port` (`cas_port`),
KEY `cas_uri` (`cas_uri`),
KEY `consumables_alert` (`consumables_alert`),
KEY `contract_alerts` (`contract_alerts`),
KEY `cut` (`cut`),
KEY `date_fiscale` (`date_fiscale`),
KEY `dateformat` (`dateformat`),
KEY `debug` (`debug`),
KEY `default_language` (`default_language`),
KEY `dropdown_limit` (`dropdown_limit`),
KEY `dropdown_max` (`dropdown_max`),
KEY `event_loglevel` (`event_loglevel`),
KEY `expire_events` (`expire_events`),
KEY `followup_on_update_ticket` (`followup_on_update_ticket`),
KEY `founded_new_version` (`founded_new_version`),
KEY `imap_auth_server` (`imap_auth_server`),
KEY `imap_host` (`imap_host`),
KEY `infocom_alerts` (`infocom_alerts`),
KEY `jobs_at_login` (`jobs_at_login`),
KEY `keep_tracking_on_delete` (`keep_tracking_on_delete`),
KEY `ldap_basedn` (`ldap_basedn`),
KEY `ldap_condition` (`ldap_condition`),
KEY `ldap_field_email` (`ldap_field_email`),
KEY `ldap_field_firstname` (`ldap_field_firstname`),
KEY `ldap_field_group` (`ldap_field_group`),
KEY `ldap_field_group_member` (`ldap_field_group_member`),
KEY `ldap_field_location` (`ldap_field_location`),
KEY `ldap_field_mobile` (`ldap_field_mobile`),
KEY `ldap_field_phone` (`ldap_field_phone`),
KEY `ldap_field_phone2` (`ldap_field_phone2`),
KEY `ldap_field_realname` (`ldap_field_realname`),
KEY `ldap_group_condition` (`ldap_group_condition`),
KEY `ldap_host` (`ldap_host`),
KEY `ldap_login` (`ldap_login`),
KEY `ldap_pass` (`ldap_pass`),
KEY `ldap_port` (`ldap_port`),
KEY `ldap_rootdn` (`ldap_rootdn`),
KEY `ldap_search_for_groups` (`ldap_search_for_groups`),
KEY `ldap_use_tls` (`ldap_use_tls`),
KEY `list_limit` (`list_limit`),
KEY `logotxt` (`logotxt`),
KEY `mailing` (`mailing`),
KEY `mailing_signature` (`mailing_signature`),
KEY `nextprev_item` (`nextprev_item`),
KEY `num_of_events` (`num_of_events`),
KEY `ocs_mode` (`ocs_mode`),
KEY `permit_helpdesk` (`permit_helpdesk`),
KEY `planning_begin` (`planning_begin`),
KEY `planning_end` (`planning_end`),
KEY `priority_1` (`priority_1`),
KEY `priority_2` (`priority_2`),
KEY `priority_3` (`priority_3`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;

-- --------------------------------------------------------

MoYo · 2008-01-02 15:20:54

dans cette table vous ne devriez avoir qu'une seule clé :
PRIMARY KEY (`ID`),
toutes les autres n'ont pas a existé. Je ne sais pas trop comment elles sont apparues. Ce n'est pas GLPI qui les a créées

MoYo · 2008-01-09 00:26:17

des nouvelles ?

pcrampette · 2008-01-09 09:51:00

J'ai supprimé les clef en trop puis tout s'est bien passé.

Merci pour tout

MoYo · 2008-01-09 12:38:50

tres bien je ferme

JMD · 2008-01-09 13:00:04

Je clos donc.

Forum GLPI-Project

Announcement

#1 2008-01-02 12:40:37

Pb Mise à jour 0.68.3-> 0.7 PB alter mailing signature

#2 2008-01-02 13:30:56

Re: Pb Mise à jour 0.68.3-> 0.7 PB alter mailing signature

#3 2008-01-02 13:48:48

Re: Pb Mise à jour 0.68.3-> 0.7 PB alter mailing signature

#4 2008-01-02 14:09:17

Re: Pb Mise à jour 0.68.3-> 0.7 PB alter mailing signature

#5 2008-01-02 15:09:35

Re: Pb Mise à jour 0.68.3-> 0.7 PB alter mailing signature

#6 2008-01-02 15:20:54

Re: Pb Mise à jour 0.68.3-> 0.7 PB alter mailing signature

#7 2008-01-09 00:26:17

Re: Pb Mise à jour 0.68.3-> 0.7 PB alter mailing signature

#8 2008-01-09 09:51:00

Re: Pb Mise à jour 0.68.3-> 0.7 PB alter mailing signature

#9 2008-01-09 12:38:50

Re: Pb Mise à jour 0.68.3-> 0.7 PB alter mailing signature

#10 2008-01-09 13:00:04

Re: Pb Mise à jour 0.68.3-> 0.7 PB alter mailing signature

Board footer