Forum GLPI-Project

fkgueye

Member

Registered: 2010-05-27

Posts: 19

Passage de 0.74 vers 0.78

Bonjour

je rencontre un problème pour migrer ma version actuelle vers la 0.78.
Blocage dans la mise à jour de la Base de données.

Message :
glpi_softwarecategories table already exists. A backup have been done to backup_glpi_softwarecategories.

glpi_softwarelicensetypes table already exists. A backup have been done to backup_glpi_softwarelicensetypes.

glpi_states table already exists. A backup have been done to backup_glpi_states.

glpi_suppliers table already exists. A backup have been done to backup_glpi_suppliers.

glpi_suppliertypes table already exists. A backup have been done to backup_glpi_suppliertypes.

glpi_tickets table already exists. A backup have been done to backup_glpi_tickets.

glpi_ticketcategories table already exists. A backup have been done to backup_glpi_ticketcategories.

glpi_ticketfollowups table already exists. A backup have been done to backup_glpi_ticketfollowups.

glpi_ticketplannings table already exists. A backup have been done to backup_glpi_ticketplannings.

glpi_usertitles table already exists. A backup have been done to backup_glpi_usertitles.

glpi_usercategories table already exists. A backup have been done to backup_glpi_usercategories.

glpi_vlans table already exists. A backup have been done to backup_glpi_vlans.

You can delete backup tables if you have no need of them.

TheHinou

Member

Registered: 2008-07-03

Posts: 434

Re: Passage de 0.74 vers 0.78

Euh là il vous dit simplement que les tables existes déjà et qu'il les a renomé en backup _* et que vous pouvez les supprimer si elles ne vous servent plus

---

Server : Windows 2003 - Apache 2.2.23 - Php 5.4.11  - Mysql 5.5.30 - Glpi 0.83.7

Auric

Member

From: Chaville (92)

Registered: 2010-07-16

Posts: 19

Re: Passage de 0.74 vers 0.78

Salut,

J'avoue que la réponse m'intéresse aussi fortement, vu que j'ai les mêmes soucis. Une fois cette page affichée, plus rien ne se passe. Je me reconnecte sur l'interface GLPI et la GLPI m'annonce que ej dois faire une MAJ de ma base de données qui n'est pas compatible avec la version actuelle. Je le fais et là j'ai quelques commandes qui passe et tout à coups cela frise sur glpi_logs -1 et là plus rien.

Je pense que notre prob est le même, donc si qq'un peut venir à notre secours :-))

Merci d'avance

MoYo

GLPI - Lead

From: Poitiers

Registered: 2004-09-13

Posts: 14,513

Website

Re: Passage de 0.74 vers 0.78

Si il vous indique ce genre de message c'est qu'une première mise à jour semble avoir échoué.
Il faut restaurer proprement votre ancienne sauvegarde (supprimer toutes les tables et reinjecter le dump).

Il faut vraiment qu'une seule mise àjour soit effectué en même temps. Attention donc si vous laisser les accès à tous les utilisateurs pendant la mise à jour.

---

MoYo - Julien Dombre - Association INDEPNET
Contribute to GLPI :    Support     Contribute     References     Freshmeat

Auric

Member

From: Chaville (92)

Registered: 2010-07-16

Posts: 19

Re: Passage de 0.74 vers 0.78

En fait le soucis, c'est que j'ai fait un dump de ma base 0.72. Après cela, j'ai tout nettoyé dans mon phpmyadmin (suppression de toutes les bases GLPI existantes).

J'ai installé la version 0.78, en créant une nouvelle base (nom différent de la base d'origine).

Je suis retourné dans mon phpmyadmin, j'ai supprimé la base que je venais de créer, j'en ai refaite une à la main avec le même nom que celle que je vennais de supprimer (donc je me retrouve avec le même nom, mais contenu complétement vide) A partir de là, j'ai réinjecté mon fichier de sauvegarde, tout a fonctionné.

Je suis retourné sur mon interface GLPI, version 0.78 et là, j'ai eu le message comme quoi ma base n'était pas compatible, nécessitant une maj, que j'effectue et la j'ai une belle erreur : modification schema glpi_logs -1

MoYo

GLPI - Lead

From: Poitiers

Registered: 2004-09-13

Posts: 14,513

Website

Re: Passage de 0.74 vers 0.78

et pourquoi ne pas avoir suivi la procédure de mise à jour standard ?

---

MoYo - Julien Dombre - Association INDEPNET
Contribute to GLPI :    Support     Contribute     References     Freshmeat

Auric

Member

From: Chaville (92)

Registered: 2010-07-16

Posts: 19

Re: Passage de 0.74 vers 0.78

J'ai suivi la procédure de ce lien :

http://www.glpi-project.org/spip.php?article171

mais cela n'a pas fonctionné, j'obtiens la même erreur au final. Après me suis je trompé de procédure ? Si c'est le cas, je suis preneur pour la dernière version et m'excuse pour le dérangement.

Sinon, ayant l'erreur ci-dessus, j'ai essayé de bidouiller pour migrer vers la nouvelle version de GLPI (0.72 vers 0.78), mais n'ai pas réussi. Ce que j'expliquai avant était les toutes dernières manip réalisées pour montrer mon raisonnement. Maintenant j'ai tout remis à plat, avec la version 0.72, fonctionnelle.

En espérant que vous puissiez m'aider pour une migration propre

Merci d'avance

metastase

Member

From: La valette du var

Registered: 2009-08-04

Posts: 31

Re: Passage de 0.74 vers 0.78

Bonjour j'ai également le problème .
Je suis en 0.72.4 avec OCS .
xampp 1.5.5
Apache 2.2.3
php 5.0.27
j'ai suivi la procédure comme pour la dernière mise a jour .
a savoir désactivation de tous les plugins ,recopie de la nouvelle mouture 0.78 a la place de l'ancienne .Je me connecte sur GLPI qui m'affiche une fenêtre avec plein de test notifiés par un point vert .Donc je suppose que c'est ok ! Et en bas de page il m'invite a faire la mise a jour pour problème de compatibilité .
La mise a jour se bloque avec un message : "skip table glpi_1050s" puis reprend . Il m'affiche terminée et me déconnecte du site. Et plus rien ! impossible de se connecter .
Je suis obligé de tous restaurer.
Quelqu'un a une idée ?

---

Cordialement,

fkgueye

Member

Registered: 2010-05-27

Posts: 19

Re: Passage de 0.74 vers 0.78

après plusieurs tentative, j'en suis toujours à ça

GLPI SETUP

Mise à jour
Connexion à la base de données réussie
Mise à jour -> 0.78
Modification du schéma - glpi_logs - 2 (1 Min(s))

glpi_authldaps table already exists. A backup have been done to backup_glpi_authldaps.

glpi_authldapreplicates table already exists. A backup have been done to backup_glpi_authldapreplicates.

glpi_authmails table already exists. A backup have been done to backup_glpi_authmails.

glpi_autoupdatesystems table already exists. A backup have been done to backup_glpi_autoupdatesystems.

glpi_bookmarks table already exists. A backup have been done to backup_glpi_bookmarks.

glpi_bookmarks_users table already exists. A backup have been done to backup_glpi_bookmarks
...
...
You can delete backup tables if you have no need of them.

Last edited by fkgueye (2010-10-13 16:57:58)

Auric

Member

From: Chaville (92)

Registered: 2010-07-16

Posts: 19

Re: Passage de 0.74 vers 0.78

Bon après avoir cherché d'où provenait l'erreur, ayant eu le même message que fkgueye, voilà ce que j'ai fait. Je suis allé sur mon php myadmin ou j'ai reinjecté le dump de ma base saine. Avant de lancer la migration vers la version 0.78, j'ai effacé l'entrée "glpi_logs" de ma base et j'ai recommencé la procédure d'installation qui s'est parfaitement déroulée (apparition du bouton "utilisation de glpi" apparu en bas de la page).

Je sais que cela peut paraitre un poil brutal, mais apparemment c'est efficace. Si j'ai des effets de bords, je vous tiendrai au courant (peut-être recréer l'entrée glpi_logs à la main après avoir terminé l'installation, à tester)

@+

metastase

Member

From: La valette du var

Registered: 2009-08-04

Posts: 31

Re: Passage de 0.74 vers 0.78

Bien je vais essayer ta méthode ce soir Auric .

Last edited by metastase (2010-10-14 11:50:52)

---

Cordialement,

yllen

GLPI-DEV

From: Sillery (51)

Registered: 2008-01-14

Posts: 15,278

Re: Passage de 0.74 vers 0.78

La mise a jour se bloque avec un message : "skip table glpi_1050s" puis reprend .

Ce n'est pas un message d'erreur mais uniquement d'information.
Cela correspond à la table d'un plugin (GLPI ne migre pas les plugins)
Par contre, lors de la mise à jour de votre plugin avec la version comptabile 0.78, la migration de la table sera effectuée

---

CentOS 6.5 - CentOS 7.x
PHP 5.6 - PHP 7.x - MySQL 5.6  - MariaDB 10.2 + APC + oOPcache
GLPI from 0.72 to dev version
Certifiée ITIL (ITV2F, ITILF, ITILOSA)

fkgueye

Member

Registered: 2010-05-27

Posts: 19

Re: Passage de 0.74 vers 0.78

Que faut il faire dans tel situation ?

yllen

GLPI-DEV

From: Sillery (51)

Registered: 2008-01-14

Posts: 15,278

Re: Passage de 0.74 vers 0.78

Avant de lancer la migration vers la version 0.78, j'ai effacé l'entrée "glpi_logs" de ma base

Mauvaise idée, car la procédure de migration modifie les champs de la table glpi_logs.
Si vous ne vouliez plus des historiques, vous auriez pu vider la table, mais pas la supprimer

---

CentOS 6.5 - CentOS 7.x
PHP 5.6 - PHP 7.x - MySQL 5.6  - MariaDB 10.2 + APC + oOPcache
GLPI from 0.72 to dev version
Certifiée ITIL (ITV2F, ITILF, ITILOSA)

Auric

Member

From: Chaville (92)

Registered: 2010-07-16

Posts: 19

Re: Passage de 0.74 vers 0.78

J'ai essayé de vider la table dans mes différentes manip, avant d'en arriver là, mais à chaque fois j'ai eu le même message

fkgueye

Member

Registered: 2010-05-27

Posts: 19

Re: Passage de 0.74 vers 0.78

1 - J'ai repris la procédure en allant d'une base Saine. 

Résultats : J'ai toujours la même erreur qui revient

2 - J'ai repris en essayant la méthode de Auric

Résulltats : Blocage avec comme message :
" Modification du schéma - Clean DB : post actions after renaming (58 Sec(s))"

Merci de votre aide

metastase

Member

From: La valette du var

Registered: 2009-08-04

Posts: 31

Re: Passage de 0.74 vers 0.78

Merci Yllen pour l'information .

---

Cordialement,

metastase

Member

From: La valette du var

Registered: 2009-08-04

Posts: 31

Re: Passage de 0.74 vers 0.78

Bonjour
J'ai refais 2 tentatives hier soir :
1er tentative :  mise a jour qui me donne le même résultat : plus d'accès au serveur ! Peut etre un pb au niveau d'apache ? mais quel rapport avec la mise a jour ?
2 eme tentative : J'ai supprimé toute la base , recopié le dossier glpi . Il me propose l'installation .J'installe donc ! il m'indique la fin du traitement sans message d'erreur puis me jette de la page web . Plus d'accès au serveur . je redemarre avec des messages d'erreur concernant apache !
Par rapport a la version 0.72.4 y a t il besoin d'avoir une version d'apache supérieure ?
Est ce un problème Apache ? un problème avec OCS reporting installé sur le même serveur ?
Je suis perdu ..

---

Cordialement,

fkgueye

Member

Registered: 2010-05-27

Posts: 19

Re: Passage de 0.74 vers 0.78

Voir le Max_ExecuteTime du php.ini.
Cela a résolu mon problème.

Merci à toutes la communauté GLPI

Manolita

Member

Registered: 2010-10-20

Posts: 12

Re: Passage de 0.74 vers 0.78

Je recontre également un problème lors de la mise à jour de la version 0.72.4 vers la 0.78.
Ma base GLPI est installé sous Windows 2000 PRO. Ma version de WAMPP est en 2.3.
J'ai effectué une sauvegarde de ma base, puis une sauvegarde du répertoire GLPI.
J'ai décompressé le fichier 0.78 dans C:\Program Files\OCS Inventory NG\xampp\htdocs. Tout c'est bien déroulé. Ensuite je clique sur le bouton "mise à jour", et j'obtiens ce résultat:

GLPI SETUP

Mise à jour
Connexion à la base de données réussie
Mise à jour -> 0.78
Modification du schéma - glpi_logs - 1 (24 Sec(s))

Error : glpi_tickets.assign does not exist.

Error : glpi_tickets.assign_group does not exist.

Error : glpi_tickets.assign_ent does not exist.

Error : glpi_users.auth_method does not exist.

Error : glpi_ticketfollowups.author does not exist.

Error : glpi_knowbaseitems.author does not exist.

Error : glpi_tickets.author does not exist.

Error : glpi_computers.auto_update does not exist.

Error : glpi_infocoms.budget does not exist.

Error : glpi_softwarelicenses.buy_version does not exist.

Error : glpi_tickets.category does not exist.

Error : glpi_softwares.category does not exist.

Error : glpi_knowbaseitems.categoryID does not exist.

Error : glpi_configs.category_on_software_delete does not exist.

Error : glpi_computers_softwareversions.cID does not exist.

Error : glpi_tickets.computer does not exist.

Error : glpi_registrykeys.computer_id does not exist.

Error : glpi_contracts.contract_type does not exist.

Error : glpi_configs.default_rubdoc_tracking does not exist.

Error : glpi_ocsservers.default_state does not exist.

Error : glpi_alerts.device_type does not exist.

Error : glpi_contracts_items.device_type does not exist.

Error : glpi_documents_items.device_type does not exist.

Error : glpi_infocoms.device_type does not exist.

Error : glpi_bookmarks.device_type does not exist.

Error : glpi_bookmarks_users.device_type does not exist.

Error : glpi_links_itemtypes.device_type does not exist.

Error : glpi_networkports.device_type does not exist.

Error : glpi_reservationitems.device_type does not exist.

Error : glpi_tickets.device_type does not exist.

Error : glpi_computers.domain does not exist.

Error : glpi_networkequipments.domain does not exist.

Error : glpi_printers.domain does not exist.

Error : glpi_computers_items.end1 does not exist.

Error : glpi_networkports_networkports.end1 does not exist.

Error : glpi_computers_items.end2 does not exist.

Error : glpi_networkports_networkports.end2 does not exist.

Error : glpi_configs.extra_ldap_server does not exist.

Error : glpi_networkequipments.firmware does not exist.

Error : glpi_bookmarks_users.FK_bookmark does not exist.

Error : glpi_computerdisks.FK_computers does not exist.

Error : glpi_softwarelicenses.FK_computers does not exist.

Error : glpi_contacts_suppliers.FK_contact does not exist.

Error : glpi_contracts_suppliers.FK_contract does not exist.

Error : glpi_contracts_items.FK_contract does not exist.

Error : glpi_alerts.FK_device does not exist.

Error : glpi_contracts_items.FK_device does not exist.

Error : glpi_documents_items.FK_device does not exist.

Error : glpi_infocoms.FK_device does not exist.

Error : glpi_documents_items.FK_doc does not exist.

Error : glpi_contacts_suppliers.FK_enterprise does not exist.

Error : glpi_contracts_suppliers.FK_enterprise does not exist.

Error : glpi_infocoms.FK_enterprise does not exist.

Error : glpi_bookmarks.FK_entities does not exist.

Error : glpi_cartridgeitems.FK_entities does not exist.

Error : glpi_computers.FK_entities does not exist.

Error : glpi_consumableitems.FK_entities does not exist.

Error : glpi_contacts.FK_entities does not exist.

Error : glpi_contracts.FK_entities does not exist.

Error : glpi_documents.FK_entities does not exist.

Error : glpi_locations.FK_entities does not exist.

Error : glpi_netpoints.FK_entities does not exist.

Error : glpi_suppliers.FK_entities does not exist.

Error : glpi_entitydatas.FK_entities does not exist.

Error : glpi_groups.FK_entities does not exist.

Error : glpi_knowbaseitems.FK_entities does not exist.

Error : glpi_links.FK_entities does not exist.

Error : glpi_mailcollectors.FK_entities does not exist.

Error : glpi_monitors.FK_entities does not exist.

Error : glpi_networkequipments.FK_entities does not exist.

Error : glpi_peripherals.FK_entities does not exist.

Error : glpi_phones.FK_entities does not exist.

Error : glpi_printers.FK_entities does not exist.

Error : glpi_reminders.FK_entities does not exist.

Error : glpi_rules.FK_entities does not exist.

Error : glpi_softwares.FK_entities does not exist.

Error : glpi_softwarelicenses.FK_entities does not exist.

Error : glpi_tickets.FK_entities does not exist.

Error : glpi_users.FK_entities does not exist.

Error : glpi_profiles_users.FK_entities does not exist.

Error : glpi_computerdisks.FK_filesystems does not exist.

Error : glpi_cartridges.FK_glpi_cartridges_type does not exist.

Error : glpi_cartridges_printermodels.FK_glpi_cartridges_type does not exist.

Error : glpi_consumables.FK_glpi_consumables_type does not exist.

Error : glpi_cartridges_printermodels.FK_glpi_dropdown_model_printers does not exist.

Error : glpi_cartridgeitems.FK_glpi_enterprise does not exist.

Error : glpi_computers.FK_glpi_enterprise does not exist.

Error : glpi_consumableitems.FK_glpi_enterprise does not exist.

Error : glpi_devicecases.FK_glpi_enterprise does not exist.

Error : glpi_devicecontrols.FK_glpi_enterprise does not exist.

Error : glpi_devicedrives.FK_glpi_enterprise does not exist.

Error : glpi_devicegraphiccards.FK_glpi_enterprise does not exist.

Error : glpi_deviceharddrives.FK_glpi_enterprise does not exist.

Error : glpi_devicenetworkcards.FK_glpi_enterprise does not exist.

Error : glpi_devicemotherboards.FK_glpi_enterprise does not exist.

Error : glpi_devicepcis.FK_glpi_enterprise does not exist.

Error : glpi_devicepowersupplies.FK_glpi_enterprise does not exist.

Error : glpi_deviceprocessors.FK_glpi_enterprise does not exist.

Error : glpi_devicememories.FK_glpi_enterprise does not exist.

Error : glpi_devicesoundcards.FK_glpi_enterprise does not exist.

Error : glpi_monitors.FK_glpi_enterprise does not exist.

Error : glpi_networkequipments.FK_glpi_enterprise does not exist.

Error : glpi_peripherals.FK_glpi_enterprise does not exist.

Error : glpi_phones.FK_glpi_enterprise does not exist.

Error : glpi_printers.FK_glpi_enterprise does not exist.

Error : glpi_softwares.FK_glpi_enterprise does not exist.

Error : glpi_cartridges.FK_glpi_printers does not exist.

Error : glpi_tickets.FK_group does not exist.

Error : glpi_computers.FK_groups does not exist.

Error : glpi_monitors.FK_groups does not exist.

Error : glpi_networkequipments.FK_groups does not exist.

Error : glpi_peripherals.FK_groups does not exist.

Error : glpi_phones.FK_groups does not exist.

Error : glpi_printers.FK_groups does not exist.

Error : glpi_softwares.FK_groups does not exist.

Error : glpi_groups_users.FK_groups does not exist.

Error : glpi_devicegraphiccards.FK_interface does not exist.

Error : glpi_mailingsettings.FK_item does not exist.

Error : glpi_links_itemtypes.FK_links does not exist.

Error : glpi_networkports_vlans.FK_port does not exist.

Error : glpi_profiles_users.FK_profiles does not exist.

Error : glpi_users.FK_profiles does not exist.

Error : glpi_rulecriterias.FK_rules does not exist.

Error : glpi_ruleactions.FK_rules does not exist.

Error : glpi_documents.FK_tracking does not exist.

Error : glpi_bookmarks.FK_users does not exist.

Error : glpi_displaypreferences.FK_users does not exist.

Error : glpi_documents.FK_users does not exist.

Error : glpi_groups.FK_users does not exist.

Error : glpi_reminders.FK_users does not exist.

Error : glpi_bookmarks_users.FK_users does not exist.

Error : glpi_groups_users.FK_users does not exist.

Error : glpi_profiles_users.FK_users does not exist.

Error : glpi_computers.FK_users does not exist.

Error : glpi_monitors.FK_users does not exist.

Error : glpi_networkequipments.FK_users does not exist.

Error : glpi_peripherals.FK_users does not exist.

Error : glpi_phones.FK_users does not exist.

Error : glpi_printers.FK_users does not exist.

Error : glpi_softwares.FK_users does not exist.

Error : glpi_networkports_vlans.FK_vlan does not exist.

Error : glpi_ocslinks.glpi_id does not exist.

Error : glpi_ticketplannings.id_assign does not exist.

Error : glpi_users.id_auth does not exist.

Error : glpi_reservationitems.id_device does not exist.

Error : glpi_ticketplannings.id_followup does not exist.

Error : glpi_reservations.id_item does not exist.

Error : glpi_consumables.id_user does not exist.

Error : glpi_reservations.id_user does not exist.

Error : glpi_networkports.iface does not exist.

Error : glpi_devicecontrols.interface does not exist.

Error : glpi_deviceharddrives.interface does not exist.

Error : glpi_devicedrives.interface does not exist.

Error : glpi_events.item does not exist.

Error : glpi_ocsservers.link_if_status does not exist.

Error : glpi_cartridgeitems.location does not exist.

Error : glpi_computers.location does not exist.

Error : glpi_consumableitems.location does not exist.

Error : glpi_netpoints.location does not exist.

Error : glpi_monitors.location does not exist.

Error : glpi_networkequipments.location does not exist.

Error : glpi_peripherals.location does not exist.

Error : glpi_phones.location does not exist.

Error : glpi_printers.location does not exist.

Error : glpi_users.location does not exist.

Error : glpi_softwares.location does not exist.

Error : glpi_computers.model does not exist.

Error : glpi_monitors.model does not exist.

Error : glpi_networkequipments.model does not exist.

Error : glpi_peripherals.model does not exist.

Error : glpi_phones.model does not exist.

Error : glpi_printers.model does not exist.

Error : glpi_networkports.netpoint does not exist.

Error : glpi_computers.network does not exist.

Error : glpi_networkequipments.network does not exist.

Error : glpi_printers.network does not exist.

Error : glpi_ocslinks.ocs_id does not exist.

Error : glpi_ocsadmininfoslinks.ocs_server_id does not exist.

Error : glpi_ocslinks.ocs_server_id does not exist.

Error : glpi_networkports.on_device does not exist.

Error : glpi_computers.os does not exist.

Error : glpi_computers.os_sp does not exist.

Error : glpi_computers.os_version does not exist.

Error : glpi_knowbaseitemcategories.parentID does not exist.

Error : glpi_locations.parentID does not exist.

Error : glpi_ticketcategories.parentID does not exist.

Error : glpi_entities.parentID does not exist.

Error : glpi_softwares.platform does not exist.

Error : glpi_phones.power does not exist.

Error : glpi_tickets.recipient does not exist.

Error : glpi_documents.rubrique does not exist.

Error : glpi_rulecachemanufacturers.rule_id does not exist.

Error : glpi_rulecachecomputermodels.rule_id does not exist.

Error : glpi_rulecachemonitormodels.rule_id does not exist.

Error : glpi_rulecachenetworkequipmentmodels.rule_id does not exist.

Error : glpi_rulecacheperipheralmodels.rule_id does not exist.

Error : glpi_rulecachephonemodels.rule_id does not exist.

Error : glpi_rulecacheprintermodels.rule_id does not exist.

Error : glpi_rulecacheoperatingsystems.rule_id does not exist.

Error : glpi_rulecacheoperatingsystemservicepacks.rule_id does not exist.

Error : glpi_rulecacheoperatingsystemversions.rule_id does not exist.

Error : glpi_rulecachesoftwares.rule_id does not exist.

Error : glpi_rulecachecomputertypes.rule_id does not exist.

Error : glpi_rulecachemonitortypes.rule_id does not exist.

Error : glpi_rulecachenetworkequipmenttypes.rule_id does not exist.

Error : glpi_rulecacheperipheraltypes.rule_id does not exist.

Error : glpi_rulecachephonetypes.rule_id does not exist.

Error : glpi_rulecacheprintertypes.rule_id does not exist.

Error : glpi_authldapreplicates.server_id does not exist.

Error : glpi_softwarelicenses.sID does not exist.

Error : glpi_softwareversions.sID does not exist.

Error : glpi_computers.state does not exist.

Error : glpi_monitors.state does not exist.

Error : glpi_networkequipments.state does not exist.

Error : glpi_peripherals.state does not exist.

Error : glpi_phones.state does not exist.

Error : glpi_printers.state does not exist.

Error : glpi_softwareversions.state does not exist.

Error : glpi_cartridgeitems.tech_num does not exist.

Error : glpi_computers.tech_num does not exist.

Error : glpi_consumableitems.tech_num does not exist.

Error : glpi_monitors.tech_num does not exist.

Error : glpi_networkequipments.tech_num does not exist.

Error : glpi_peripherals.tech_num does not exist.

Error : glpi_phones.tech_num does not exist.

Error : glpi_printers.tech_num does not exist.

Error : glpi_softwares.tech_num does not exist.

Error : glpi_users.title does not exist.

Error : glpi_ticketfollowups.tracking does not exist.

Error : glpi_cartridgeitems.type does not exist.

Error : glpi_computers.type does not exist.

Error : glpi_consumableitems.type does not exist.

Error : glpi_contacts.type does not exist.

Error : glpi_devicecases.type does not exist.

Error : glpi_devicememories.type does not exist.

Error : glpi_suppliers.type does not exist.

Error : glpi_monitors.type does not exist.

Error : glpi_networkequipments.type does not exist.

Error : glpi_peripherals.type does not exist.

Error : glpi_phones.type does not exist.

Error : glpi_printers.type does not exist.

Error : glpi_softwarelicenses.type does not exist.

Error : glpi_users.type does not exist.

Error : glpi_computers_items.type does not exist.

Error : glpi_displaypreferences.type does not exist.

Error : glpi_softwares.update_software does not exist.

Error : glpi_softwarelicenses.use_version does not exist.

Error : glpi_computers_softwareversions.vID does not exist.

Error : glpi_authldaps.ldap_use_tls does not exist.

Error : glpi_bookmarks.private does not exist.

Error : glpi_bookmarks.recursive does not exist.

Error : glpi_cartridgeitems.deleted does not exist.

Error : glpi_computers.deleted does not exist.

Error : glpi_computers.ocs_import does not exist.

Error : glpi_configs.jobs_at_login does not exist.

Error : glpi_configs.mailing does not exist.

Error : glpi_configs.permit_helpdesk does not exist.

Error : glpi_configs.auto_assign does not exist.

Error : glpi_configs.public_faq does not exist.

Error : glpi_configs.url_in_mail does not exist.

Error : glpi_configs.ajax_autocompletion does not exist.

Error : glpi_configs.auto_add_users does not exist.

Error : glpi_configs.view_ID does not exist.

Error : glpi_configs.ocs_mode does not exist.

Error : glpi_configs.followup_on_update_ticket does not exist.

Error : glpi_configs.licenses_alert does not exist.

Error : glpi_configs.keep_tracking_on_delete does not exist.

Error : glpi_configs.use_errorlog does not exist.

Error : glpi_configs.autoupdate_link_contact does not exist.

Error : glpi_configs.autoupdate_link_user does not exist.

Error : glpi_configs.autoupdate_link_group does not exist.

Error : glpi_configs.autoupdate_link_location does not exist.

Error : glpi_configs.autoclean_link_contact does not exist.

Error : glpi_configs.autoclean_link_user does not exist.

Error : glpi_configs.autoclean_link_group does not exist.

Error : glpi_configs.autoclean_link_location does not exist.

Error : glpi_configs.flat_dropdowntree does not exist.

Error : glpi_configs.autoname_entity does not exist.

Error : glpi_configs.expand_soft_categorized does not exist.

Error : glpi_configs.expand_soft_not_categorized does not exist.

Error : glpi_configs.ticket_title_mandatory does not exist.

Error : glpi_configs.ticket_content_mandatory does not exist.

Error : glpi_configs.ticket_category_mandatory does not exist.

Error : glpi_configs.software_helpdesk_visible does not exist.

Error : glpi_consumableitems.deleted does not exist.

Error : glpi_contacts.recursive does not exist.

Error : glpi_contacts.deleted does not exist.

Error : glpi_contracts.recursive does not exist.

Error : glpi_contracts.deleted does not exist.

Error : glpi_contracts.monday does not exist.

Error : glpi_contracts.saturday does not exist.

Error : glpi_devicecontrols.raid does not exist.

Error : glpi_devicepowersupplies.atx does not exist.

Error : glpi_documents.recursive does not exist.

Error : glpi_documents.deleted does not exist.

Error : glpi_documenttypes.upload does not exist.

Error : glpi_groups.recursive does not exist.

Error : glpi_knowbaseitems.recursive does not exist.

Error : glpi_knowbaseitems.faq does not exist.

Error : glpi_links.recursive does not exist.

Error : glpi_monitors.deleted does not exist.

Error : glpi_monitors.flags_micro does not exist.

Error : glpi_monitors.flags_speaker does not exist.

Error : glpi_monitors.flags_subd does not exist.

Error : glpi_monitors.flags_bnc does not exist.

Error : glpi_monitors.flags_dvi does not exist.

Error : glpi_monitors.flags_pivot does not exist.

Error : glpi_networkequipments.recursive does not exist.

Error : glpi_networkequipments.deleted does not exist.

Error : glpi_ocslinks.auto_update does not exist.

Error : glpi_ocsservers.import_general_enterprise does not exist.

Error : glpi_ocsservers.import_general_comments does not exist.

Error : glpi_ocsservers.import_device_drives does not exist.

Error : glpi_ocsservers.import_device_ports does not exist.

Error : glpi_ocsservers.import_device_modems does not exist.

Error : glpi_ocsservers.import_monitor_comments does not exist.

Error : glpi_ocsservers.glpi_link_enabled does not exist.

Error : glpi_ocsservers.link_ip does not exist.

Error : glpi_ocsservers.link_name does not exist.

Error : glpi_ocsservers.link_mac_address does not exist.

Error : glpi_ocsservers.link_serial does not exist.

Error : glpi_peripherals.deleted does not exist.

Error : glpi_phones.deleted does not exist.

Error : glpi_phones.flags_hp does not exist.

Error : glpi_phones.flags_casque does not exist.

Error : glpi_printers.recursive does not exist.

Error : glpi_printers.deleted does not exist.

Error : glpi_printers.flags_usb does not exist.

Error : glpi_printers.flags_par does not exist.

Error : glpi_printers.flags_serial does not exist.

Error : glpi_profiles_users.recursive does not exist.

Error : glpi_profiles_users.dynamic does not exist.

Error : glpi_reminders.private does not exist.

Error : glpi_reminders.recursive does not exist.

Error : glpi_reminders.rv does not exist.

Error : glpi_reservationitems.active does not exist.

Error : glpi_rules.active does not exist.

Error : glpi_suppliers.recursive does not exist.

Error : glpi_suppliers.deleted does not exist.

Error : glpi_softwares.recursive does not exist.

Error : glpi_softwares.deleted does not exist.

Error : glpi_softwares.helpdesk_visible does not exist.

Error : glpi_softwarelicenses.recursive does not exist.

Error : glpi_tickets.emailupdates does not exist.

Error : glpi_ticketfollowups.private does not exist.

Error : glpi_users.deleted does not exist.

Error : glpi_users.active does not exist.

Error : glpi_users.jobs_at_login does not exist.

Error : glpi_users.expand_soft_categorized does not exist.

Error : glpi_users.expand_soft_not_categorized does not exist.

Error : glpi_users.flat_dropdowntree does not exist.

Error : glpi_users.view_ID does not exist.

Error : glpi_cartridgeitems.comments does not exist.

Error : glpi_computers.comments does not exist.

Error : glpi_consumableitems.comments does not exist.

Error : glpi_contacts.comments does not exist.

Error : glpi_contracts.comments does not exist.

Error : glpi_documents.comments does not exist.

Error : glpi_autoupdatesystems.comments does not exist.

Error : glpi_budgets.comments does not exist.

Error : glpi_cartridgeitemtypes.comments does not exist.

Error : glpi_devicecasetypes.comments does not exist.

Error : glpi_consumableitemtypes.comments does not exist.

Error : glpi_contacttypes.comments does not exist.

Error : glpi_contracttypes.comments does not exist.

Error : glpi_domains.comments does not exist.

Error : glpi_suppliertypes.comments does not exist.

Error : glpi_filesystems.comments does not exist.

Error : glpi_networkequipmentfirmwares.comments does not exist.

Error : glpi_networkinterfaces.comments does not exist.

Error : glpi_interfacetypes.comments does not exist.

Error : glpi_knowbaseitemcategories.comments does not exist.

Error : glpi_softwarelicensetypes.comments does not exist.

Error : glpi_locations.comments does not exist.

Error : glpi_manufacturers.comments does not exist.

Error : glpi_computermodels.comments does not exist.

Error : glpi_monitormodels.comments does not exist.

Error : glpi_networkequipmentmodels.comments does not exist.

Error : glpi_peripheralmodels.comments does not exist.

Error : glpi_phonemodels.comments does not exist.

Error : glpi_printermodels.comments does not exist.

Error : glpi_netpoints.comments does not exist.

Error : glpi_networks.comments does not exist.

Error : glpi_operatingsystems.comments does not exist.

Error : glpi_operatingsystemservicepacks.comments does not exist.

Error : glpi_operatingsystemversions.comments does not exist.

Error : glpi_phonepowersupplies.comments does not exist.

Error : glpi_devicememorytypes.comments does not exist.

Error : glpi_documentcategories.comments does not exist.

Error : glpi_softwarecategories.comments does not exist.

Error : glpi_states.comments does not exist.

Error : glpi_ticketcategories.comments does not exist.

Error : glpi_usertitles.comments does not exist.

Error : glpi_usercategories.comments does not exist.

Error : glpi_vlans.comments does not exist.

Error : glpi_suppliers.comments does not exist.

Error : glpi_entities.comments does not exist.

Error : glpi_groups.comments does not exist.

Error : glpi_infocoms.comments does not exist.

Error : glpi_monitors.comments does not exist.

Error : glpi_phones.comments does not exist.

Error : glpi_printers.comments does not exist.

Error : glpi_peripherals.comments does not exist.

Error : glpi_networkequipments.comments does not exist.

Error : glpi_reservationitems.comments does not exist.

Error : glpi_rules.comments does not exist.

Error : glpi_softwares.comments does not exist.

Error : glpi_softwarelicenses.comments does not exist.

Error : glpi_softwareversions.comments does not exist.

Error : glpi_computertypes.comments does not exist.

Error : glpi_monitortypes.comments does not exist.

Error : glpi_networkequipmenttypes.comments does not exist.

Error : glpi_peripheraltypes.comments does not exist.

Error : glpi_phonetypes.comments does not exist.

Error : glpi_printertypes.comments does not exist.

Error : glpi_users.comments does not exist.

Error : glpi_cartridgeitems.notes does not exist.

Error : glpi_computers.notes does not exist.

Error : glpi_consumableitems.notes does not exist.

Error : glpi_contacts.notes does not exist.

Error : glpi_contracts.notes does not exist.

Error : glpi_documents.notes does not exist.

Error : glpi_suppliers.notes does not exist.

Error : glpi_entitydatas.notes does not exist.

Error : glpi_printers.notes does not exist.

Error : glpi_monitors.notes does not exist.

Error : glpi_phones.notes does not exist.

Error : glpi_peripherals.notes does not exist.

Error : glpi_networkequipments.notes does not exist.

Error : glpi_softwares.notes does not exist.

Error : glpi_authldaps.ldap_condition does not exist.

Error : glpi_ocslinks.import_printers does not exist.

Error : glpi_tickets.contents does not exist.

Error : glpi_ticketfollowups.contents does not exist.

Error : glpi_authldaps.ldap_host does not exist.

Error : glpi_authldaps.ldap_basedn does not exist.

Error : glpi_authldaps.ldap_rootdn does not exist.

Error : glpi_authldaps.ldap_pass does not exist.

Error : glpi_authldaps.ldap_login does not exist.

Error : glpi_authldaps.ldap_field_group does not exist.

Error : glpi_authldaps.ldap_group_condition does not exist.

Error : glpi_authldaps.ldap_field_group_member does not exist.

Error : glpi_authldaps.ldap_field_email does not exist.

Error : glpi_authldaps.ldap_field_realname does not exist.

Error : glpi_authldaps.ldap_field_firstname does not exist.

Error : glpi_authldaps.ldap_field_phone does not exist.

Error : glpi_authldaps.ldap_field_phone2 does not exist.

Error : glpi_authldaps.ldap_field_mobile does not exist.

Error : glpi_authldaps.ldap_field_comments does not exist.

Error : glpi_authldaps.ldap_field_title does not exist.

Error : glpi_authldaps.ldap_field_type does not exist.

Error : glpi_authldaps.ldap_field_language does not exist.

Error : glpi_authldapreplicates.ldap_host does not exist.

Error : glpi_authmails.imap_auth_server does not exist.

Error : glpi_authmails.imap_host does not exist.

Error : glpi_computers.os_license_id does not exist.

Error : glpi_computers.tplname does not exist.

Error : glpi_configs.helpdeskhelp_url does not exist.

Error : glpi_configs.centralhelp_url does not exist.

Error : glpi_contracts.compta_num does not exist.

Error : glpi_events.itemtype does not exist.

Error : glpi_infocoms.num_commande does not exist.

Error : glpi_infocoms.bon_livraison does not exist.

Error : glpi_infocoms.num_immo does not exist.

Error : glpi_infocoms.facture does not exist.

Error : glpi_monitors.tplname does not exist.

Error : glpi_networkequipments.tplname does not exist.

Error : glpi_networkequipments.ifmac does not exist.

Error : glpi_networkequipments.ifaddr does not exist.

Error : glpi_networkports.ifmac does not exist.

Error : glpi_networkports.ifaddr does not exist.

Error : glpi_peripherals.tplname does not exist.

Error : glpi_phones.tplname does not exist.

Error : glpi_printers.tplname does not exist.

Error : glpi_printers.ramSize does not exist.

Error : glpi_registrykeys.registry_hive does not exist.

Error : glpi_registrykeys.registry_path does not exist.

Error : glpi_registrykeys.registry_value does not exist.

Error : glpi_registrykeys.registry_ocs_name does not exist.

Error : glpi_softwares.tplname does not exist.

Error : glpi_tickets.uemail does not exist.

Error : glpi_profiles.user_auth_method does not exist.

Error : glpi_profiles.rule_tracking does not exist.

Error : glpi_authldaps.ldap_port does not exist.

Error : glpi_authldaps.ldap_search_for_groups does not exist.

Error : glpi_authldaps.ldap_opt_deref does not exist.

Error : glpi_authldaps.timezone does not exist.

Error : glpi_authldapreplicates.ldap_port does not exist.

Error : glpi_cartridgeitems.alarm does not exist.

Error : glpi_configs.glpi_timezone does not exist.

Error : glpi_configs.cartridges_alarm does not exist.

Error : glpi_configs.dateformat does not exist.

Error : glpi_configs.numberformat does not exist.

Error : glpi_configs.contract_alerts does not exist.

Error : glpi_configs.infocom_alerts does not exist.

Error : glpi_configs.cartridges_alert does not exist.

Error : glpi_configs.consumables_alert does not exist.

Error : glpi_configs.autoupdate_link_state does not exist.

Error : glpi_configs.autoclean_link_state does not exist.

Error : glpi_configs.name_display_order does not exist.

Error : glpi_configs.dropdown_limit does not exist.

Error : glpi_configs.mailgate_filesize_max does not exist.

Error : glpi_consumableitems.alarm does not exist.

Error : glpi_contracts.facturation does not exist.

Error : glpi_contracts.device_countmax does not exist.

Error : glpi_infocoms.amort_time does not exist.

Error : glpi_infocoms.amort_type does not exist.

Error : glpi_mailingsettings.item_type does not exist.

Error : glpi_printers.initial_pages does not exist.

Error : glpi_transfers.keep_tickets does not exist.

Error : glpi_transfers.keep_networklinks does not exist.

Error : glpi_transfers.keep_reservations does not exist.

Error : glpi_transfers.keep_devices does not exist.

Error : glpi_transfers.keep_infocoms does not exist.

Error : glpi_transfers.keep_enterprises does not exist.

Error : glpi_transfers.clean_enterprises does not exist.

Error : glpi_transfers.keep_contacts does not exist.

Error : glpi_transfers.clean_contacts does not exist.

Error : glpi_transfers.keep_contracts does not exist.

Error : glpi_transfers.clean_contracts does not exist.

Error : glpi_transfers.keep_softwares does not exist.

Error : glpi_transfers.clean_softwares does not exist.

Error : glpi_transfers.keep_documents does not exist.

Error : glpi_transfers.clean_documents does not exist.

Error : glpi_transfers.keep_cartridges_type does not exist.

Error : glpi_transfers.clean_cartridges_type does not exist.

Error : glpi_transfers.keep_cartridges does not exist.

Error : glpi_transfers.keep_consumables does not exist.

Error : glpi_users.dateformat does not exist.

Error : glpi_users.numberformat does not exist.

Error : glpi_users.dropdown_limit does not exist.

0.78 add item* fields to table glpi_logs Erreur durant la mise à jour de la base de donnéesDuplicate column name 'itemtype'

J'ai modifié le fichier php.ini : memory_limit = 128 et timeout = -1 (j'avais lu ça dans le forum).
Je ne peux plus restaurer ma version précédente. Quand je restaure le répertoire GLPI de la version précédente, il m'indique ceci : Error accessing config table

Comment puis-je procéder au bon déroulemeent de la mise à jour ? Faut-il que je mette à jour xamp ? est-ce que la version 0.78 est compatible Windows 2000 PRO ?
Merci pour vos réponses

cruzzy99

Member

Registered: 2010-10-20

Posts: 5

Re: Passage de 0.74 vers 0.78

Bonjour,

Je rencontre exactement le même problème que Manolita

Problème lors de la mise à jour de la version 0.72.4 vers la 0.78.
Ma base GLPI est installé sous Windows 2300 avec IIS

J'ai bien effectué une sauvegarde de ma base, puis une sauvegarde du répertoire GLPI.
J'ai décompressé le fichier 0.78 au même endroit que pour les autres mises à jour.
Ensuite quand je clique sur le bouton "mise à jour" j'obtiens le même résultat que Manolita.
(pas la peine de remettre tout le log d'erreur )

J'ai aussi essayé de modifier le max_timeout à -1, mais ça ne change rien du tout.

Une idée ?

Merci d'avance.

Last edited by cruzzy99 (2010-10-20 18:39:05)

yllen

GLPI-DEV

From: Sillery (51)

Registered: 2008-01-14

Posts: 15,278

Re: Passage de 0.74 vers 0.78

Error accessing config table

Avez-vous bien mis apache comme propriétaire du répertoire config ?

---

CentOS 6.5 - CentOS 7.x
PHP 5.6 - PHP 7.x - MySQL 5.6  - MariaDB 10.2 + APC + oOPcache
GLPI from 0.72 to dev version
Certifiée ITIL (ITV2F, ITILF, ITILOSA)

Manolita

Member

Registered: 2010-10-20

Posts: 12

Re: Passage de 0.74 vers 0.78

Bonjour,

Comment mettre apache en propriétaire du répertoire "config" sous Windows 2000 PRO ? le compte administrateur local est en control total sur l'ensemble des répertoires.

cruzzy99

Member

Registered: 2010-10-20

Posts: 5

Re: Passage de 0.74 vers 0.78

Pour mon cas :
- les droits sur Files et config ont été modifiés (comme à chaque fois)
- j'ai tous les indicateurs en vert au début de la migration
- quand j'appuis sur Mise à jour" ça ne fonctionne pas --> les mêmes lignes que sur le post de Manolita

Juste une ligne tout en bas différente :
......./...........
Error : glpi_transfers.keep_consumables does not exist.
Error : glpi_users.dateformat does not exist.
Error : glpi_users.numberformat does not exist.
Error : glpi_users.dropdown_limit does not exist.

0.78 multiple alter in glpi_rules Erreur durant la mise à jour de la base de donnéesIncorrect integer value: 'RuleOcs' for column 'sub_type' at row 1

Une idée ?

Merci d'avance.

cruzzy99

Member

Registered: 2010-10-20

Posts: 5

Re: Passage de 0.74 vers 0.78

En essayant de remettre mon ancienne version de GLPI (la 0.72.4) j'ai un message d'erreur : Error accessing config table

J'ai vérifié, les droits sont bons sur le répertoire Config et Files.

En fouillant, et en faisant des essais, dans le code PHP de la page config.php j'arrive à trouver l'endroit qui bloque :
if($config_object->getFromDB(1)){
            $CFG_GLPI=array_merge($CFG_GLPI,$config_object->fields);

            if ( !isset($_SERVER['REQUEST_URI']) ) {
                $_SERVER['REQUEST_URI'] = $_SERVER['PHP_SELF'];
            }
            $currentdir=getcwd();
            chdir(GLPI_ROOT);
            $glpidir=str_replace(str_replace('\\', '/',getcwd()),"",str_replace('\\', '/',$currentdir));
            chdir($currentdir);
           
            $globaldir=preg_replace("/\/[0-9a-zA-Z\.\-\_]+\.php.*/","",$_SERVER['REQUEST_URI']);
         $globaldir=preg_replace("/\?.*/","",$globaldir);
            $CFG_GLPI["root_doc"]=str_replace($glpidir,"",$globaldir);
            $CFG_GLPI["root_doc"]=preg_replace("/\/$/","",$CFG_GLPI["root_doc"]);
            // urldecode for space redirect to encoded URL : change entity
            $CFG_GLPI["root_doc"]=urldecode($CFG_GLPI["root_doc"]);
   
            // Path for icon of document type
            $CFG_GLPI["typedoc_icon_dir"] = GLPI_ROOT."/pics/icones";

        } else {
            echo "Error accessing config table";
            exit();
        }

Apparemment le test "if($config_object->getFromDB(1))" n'est plus bon !
une idée ?

Merci.