You are not logged in.

Announcement

 Téléchargez la dernière version stable de GLPI      -     Et vous, que pouvez vous faire pour le projet GLPI ? :  Contribuer
 Download last stable version of GLPI                      -     What can you do for GLPI ? :  Contribute

#1 2022-12-08 10:39:23

Florian35
Member
Registered: 2020-11-02
Posts: 45

Migration GLPI 10.0.3 erreur tables

Hello,

I go to the folder "/var/www/html/glpi" then I do the command "php bin/console glpi:migration:unsigned_keys".

Then I have 4 errors:

The migration of the column "glpi_plugin_mydashboard_profileauthorizedwidgets.widgets_id" cannot be done because its default value is negative.
The migration of the column "glpi_plugin_mydashboard_stocktickets.groups_id" cannot be done because its default value is negative.
The migration of the column "glpi_plugin_mydashboard_userwidgets.users_id" cannot be done because it is referenced in the CONSTRAINT "glpi_plugin_mydashboard_userwidgets_ibfk_1" of the table "glpi_plugin_mydashboard_userwidgets.users_id".
The migration of the column "glpi_users.id" cannot be done because it is referenced in the CONSTRAINT "glpi_plugin_mydashboard_userwidgets_ibfk_1" of the table "glpi_plugin_mydashboard_userwidgets.users_id".



How do I do this because I deleted all my plugins voluntarily and I have nothing left as plugins but I have the errors there how to solve?


Debian 11
GLPI 10.0.3

Offline

#2 2022-12-09 13:06:06

Kaya84
Member
Registered: 2019-06-13
Posts: 217

Re: Migration GLPI 10.0.3 erreur tables

I think you removed the plugin without uninstallation.
Drop those tables and u will be ok (do a backup before!)

DROP TABLE glpi_plugin_mydashboard_profileauthorizedwidgets;
DROP TABLE glpi_plugin_mydashboard_stocktickets;
DROP TABLE glpi_plugin_mydashboard_userwidgets;

Offline

#3 2022-12-09 16:59:10

Florian35
Member
Registered: 2020-11-02
Posts: 45

Re: Migration GLPI 10.0.3 erreur tables

Hi,

-bash: DROP : order not found

The controls do not work


Debian 11
GLPI 10.0.3

Offline

#4 2022-12-12 11:47:00

Kaya84
Member
Registered: 2019-06-13
Posts: 217

Re: Migration GLPI 10.0.3 erreur tables

DROP is a sql command.
I forgot to say that (obvious?) the command has to be used inside sql ...

To be more clear.
- connect to mysql console
- select the right database
- execute the commands.

Last edited by Kaya84 (2022-12-12 11:47:08)

Offline

#5 2022-12-12 11:59:47

Florian35
Member
Registered: 2020-11-02
Posts: 45

Re: Migration GLPI 10.0.3 erreur tables

Oh yes, right,

No, no, it's clear that I wasn't awake.

But how does it work perfectly, what are the controls?


Debian 11
GLPI 10.0.3

Offline

#6 2022-12-12 12:57:28

Kaya84
Member
Registered: 2019-06-13
Posts: 217

Re: Migration GLPI 10.0.3 erreur tables

Florian35 wrote:

But how does it work perfectly, what are the controls?

I can't undestand..

Offline

Board footer

Powered by FluxBB