Forum GLPI-Project

zdv

Member

Registered: 2021-08-05

Posts: 2

Unknown column 'glpi_slas.calendars_id' while updating to v10

Hi all,

I have the following error message while updating from v9.5.6 to v10.0.0

SQL Error "1054": Unknown column 'glpi_slas.calendars_id' in 'field list' in query "UPDATE `glpi_slas` INNER JOIN `glpi_slms` ON (`glpi_slas`.`slms_id` = `glpi_slms`.`id`) SET `glpi_slas`.`use_ticket_calendar` = `glpi_slms`.`use_ticket_calendar`, `glpi_slas`.`calendars_id` = `glpi_slms`.`calendars_id` WHERE (1)"

And indeed, the table is empty:

select * from glpi_slas;
Empty set (0.001 sec)

I'm blocked with the update, do you have an idea ?

Thanks

francois-teclib

Expert GLPI

From: TECLIB

Registered: 2006-11-05

Posts: 76

Website

Re: Unknown column 'glpi_slas.calendars_id' while updating to v10

Hello,

This is a known bug comming from old incorrect migration, fixed by:
https://github.com/glpi-project/glpi/pull/11333

++

---

Besoin d'un support professionnel pour GLPI ? Pensez à GLPI Network ! https://glpi-project.org/fr/tarifs/

Connaissez-vous l'offre Cloud maintenue et supportée par l'équipe qui édite GLPI ?
Vous pouvez tester gratuitement pendant 45 jours ! https://glpi-network.cloud (ou plus si besoin)

MDM-SI

Member

Registered: 2017-04-27

Posts: 28

Re: Unknown column 'glpi_slas.calendars_id' while updating to v10

Hi,
Got the same error, how am I suppose to solve it with this PR ? I don't get it.

Thanks for your help.

MDM-SI

Member

Registered: 2017-04-27

Posts: 28

Re: Unknown column 'glpi_slas.calendars_id' while updating to v10

Solved my problem by droping the table and recreating it with the glpi-empty.sql file
It works now.

Thanks