Bug #2901

1.6.0 multiple errors in update-1.6.0.sql

Added by elacour over 8 years ago. Updated over 5 years ago.

Status:NewStart date:06/21/2011
Priority:NormalDue date:
Assignee:-% Done:

0%

Category:-
Target version:-

Description

Unless some columns/tables are created on the fly during plugn usage, I found the following problems:

- At the begining, connectiond is used instead of connections in table renames.
- In glpi_plugin_connections_connections, FK_users, FK_groups, FK_enterprise, others, helpdesk_visible are altered but were not present in empty-1.5.0.sql
- In glpi_plugin_connections_connections, INDEX are added to non existent columns: plugin_connections_connectionrates and plugin_connections_connectionratesguaranteedd
- Tables glpi_plugin_connections_connections_items and glpi_plugin_connections_connectiontypes are altered but were not present in empty-1.5.0.sql
- In glpi_plugin_connections_profiles, column open_ticket is altered but was not in empty-1.5.0.sql

History

#1 Updated by CDuv over 5 years ago

I don't know the database migration system well enough but since GLPI 0.80 a new class is available to deal with migration process: Migration (See En_Plugin078to080).
It could be a good thing to fix and flatten out everything by switching to this?

Also available in: Atom PDF