SQL Error "1054": Unknown column 'profiles_id' in 'where clause' in query "SELECT * FROM glpi_plugin_vip_profiles WHERE profiles_id='1'"

[sebma]

Hi,

I get 15 SQL errors when installing the VIP v1.8.2 plugin from CLI :

$ sudo php bin/console glpi:plugin:install --username=glpi vip -vvv
Traitement du plugin « vip »...
SQL Error "1054": Unknown column 'profiles_id' in 'where clause' in query "SELECT * FROM `glpi_plugin_vip_profiles` WHERE `profiles_id`='1'"
SQL Error "1054": Unknown column 'profiles_id' in 'where clause' in query "SELECT * FROM `glpi_plugin_vip_profiles` WHERE `profiles_id`='2'"
SQL Error "1054": Unknown column 'profiles_id' in 'where clause' in query "SELECT * FROM `glpi_plugin_vip_profiles` WHERE `profiles_id`='3'"
SQL Error "1054": Unknown column 'profiles_id' in 'where clause' in query "SELECT * FROM `glpi_plugin_vip_profiles` WHERE `profiles_id`='4'"
SQL Error "1054": Unknown column 'profiles_id' in 'where clause' in query "SELECT * FROM `glpi_plugin_vip_profiles` WHERE `profiles_id`='5'"
SQL Error "1054": Unknown column 'profiles_id' in 'where clause' in query "SELECT * FROM `glpi_plugin_vip_profiles` WHERE `profiles_id`='6'"
SQL Error "1054": Unknown column 'profiles_id' in 'where clause' in query "SELECT * FROM `glpi_plugin_vip_profiles` WHERE `profiles_id`='7'"
SQL Error "1054": Unknown column 'profiles_id' in 'where clause' in query "SELECT * FROM `glpi_plugin_vip_profiles` WHERE `profiles_id`='12'"
SQL Error "1054": Unknown column 'profiles_id' in 'where clause' in query "SELECT * FROM `glpi_plugin_vip_profiles` WHERE `profiles_id`='13'"
SQL Error "1054": Unknown column 'profiles_id' in 'where clause' in query "SELECT * FROM `glpi_plugin_vip_profiles` WHERE `profiles_id`='14'"
SQL Error "1054": Unknown column 'profiles_id' in 'where clause' in query "SELECT * FROM `glpi_plugin_vip_profiles` WHERE `profiles_id`='15'"
Le plugin « vip » a été installé et peut être activé.
Temps écoulé : < 1 sec.
Utilisation de la mémoire : 24.0 MiB.

Is this normal ?

Can this column be safely removed before migrating to from GLPI v9.5.7+VIP v1.7.2 to GLPI v10.0.5+VIP v1.8.2 ?