Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Error after update plugins 1.18.2 to 1.21.8 #769

Closed
CMPITS opened this issue Feb 29, 2024 · 1 comment
Closed

Error after update plugins 1.18.2 to 1.21.8 #769

CMPITS opened this issue Feb 29, 2024 · 1 comment

Comments

@CMPITS
Copy link

CMPITS commented Feb 29, 2024

Hello, following an attempt to update the plugin to version 1.18.2, I get an "Undefined array key "plugin_fields_catgoriepostefielddropdowns_id" message. I managed to go all the way to version 1.19.0 and the error appears from 1.20.0 and does not disappear despite testing until the latest version 1.21.8. I also have this message "SQL Error "1052": Field: 'itemtype' in where clause is ambiguous in query "SELECT COUNT(*) AS cpt FROM 'glpi_items_tickets' INNER JOIN 'glpi_tickets'"

I would like to point out that I am not an expert in databases or PHP. Thank you for your help

Regards

@CMPITS CMPITS changed the title Error after update Error after update plugins 1.18.2 to 1.20.8 Mar 6, 2024
@CMPITS CMPITS changed the title Error after update plugins 1.18.2 to 1.20.8 Error after update plugins 1.18.2 to 1.21.8 Mar 6, 2024
@CMPITS CMPITS closed this as completed Mar 6, 2024
@CMPITS CMPITS reopened this Mar 6, 2024
@CMPITS
Copy link
Author

CMPITS commented Mar 7, 2024

Hello, I finally found it. A table was renamed with a wrong name during migration.
The base field is named "POSITION FUNCTION", except that the renaming took the name of the block, unfortunately an "é" was put in the name. The block is called "Item Category" and when the table was migrated to "glpi_plugin_fields_catgoriepostefielddropdowns" instead of "glpi_plugin_fields_fonctionpostefielddropdowns".
So I created a field with the name "Function Position", deleted the table, then moved to "glpi_plugin_fields_catgoriepostefielddropdowns" to "glpi_plugin_fields_fonctionpostefielddropdowns" and finally recovered my data without errors.
Regard

@CMPITS CMPITS closed this as completed Mar 7, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant