Pierre Chifflier a écrit : > Salut, > > > Pourriez-vous regarder si les scripts SQL sont corrects ? Je soupçonne > que le problème pourrait être lié à l'ordre des commandes ... > Effectivement il y a un problème dans l'ordre des commandes. Cette partie de mise à jour doit être fait rigoureusement dans l'ordre.
L'enchaînement dans l'ordre : UPDATE `glpi_display` SET num=34 WHERE num=3 AND type=11; UPDATE `glpi_display` SET num=3 WHERE num=6 AND type=11; UPDATE `glpi_display` SET num=34 WHERE num=3 AND type=17; UPDATE `glpi_display` SET num=3 WHERE num=6 AND type=17; UPDATE `glpi_display` SET num=34 WHERE num=3 AND type=15; UPDATE `glpi_display` SET num=3 WHERE num=7 AND type=15; UPDATE `glpi_display` SET num=46 WHERE num=40 AND type=1; UPDATE `glpi_display` SET num=40 WHERE num=5 AND type=1; UPDATE `glpi_display` SET num=5 WHERE num=8 AND type=1; UPDATE `glpi_display` SET num=45 WHERE num=6 AND type=1; UPDATE `glpi_display` SET num=6 WHERE num=9 AND type=1; UPDATE `glpi_display` SET num=6 WHERE num=9 AND type=22; UPDATE `glpi_display` SET num=5 WHERE num=8 AND type=22; UPDATE `glpi_display` SET num=23 WHERE num=5 AND type=17; UPDATE `glpi_display` SET num=23 WHERE num=5 AND type=11; UPDATE `glpi_display` SET num=24 WHERE num=7 AND type=17; UPDATE `glpi_display` SET num=24 WHERE num=7 AND type=11; UPDATE `glpi_display` SET num=19 WHERE num=9 AND type=2; UPDATE `glpi_display` SET num=19 WHERE num=9 AND type=3; UPDATE `glpi_display` SET num=19 WHERE num=9 AND type=4; UPDATE `glpi_display` SET num=19 WHERE num=9 AND type=5; UPDATE `glpi_display` SET num=19 WHERE num=9 AND type=6; UPDATE `glpi_display` SET num=19 WHERE num=9 AND type=23; UPDATE `glpi_display` SET num=16 WHERE num=10 AND type=2; UPDATE `glpi_display` SET num=16 WHERE num=10 AND type=3; UPDATE `glpi_display` SET num=16 WHERE num=10 AND type=4; UPDATE `glpi_display` SET num=16 WHERE num=10 AND type=5; UPDATE `glpi_display` SET num=16 WHERE num=6 AND type=6; UPDATE `glpi_display` SET num=16 WHERE num=7 AND type=7; UPDATE `glpi_display` SET num=16 WHERE num=7 AND type=8; UPDATE `glpi_display` SET num=16 WHERE num=10 AND type=11; UPDATE `glpi_display` SET num=16 WHERE num=6 AND type=13; UPDATE `glpi_display` SET num=16 WHERE num=12 AND type=15; UPDATE `glpi_display` SET num=16 WHERE num=10 AND type=23; ++ Julien _______________________________________________ Glpi-dev mailing list Glpi-dev@gna.org https://mail.gna.org/listinfo/glpi-dev
