MySQL query error

[FelipeBasilio1991]

Code of Conduct

• I agree to follow this project's Code of Conduct

Is there an existing issue for this?

• I have searched the existing issues

GLPI Version

11

Plugin version

Last version

Bug description

When I try to upload the csv file it returns the following error in the sql logs

Relevant log output

glpisqllog.ERROR: DBmysql::doQuery() in /var/www/html/glpi/src/DBmysql.php line 399
  *** MySQL query error:
  SQL: SELECT * FROM `(SELECT `itemtype`
                 FROM `glpi_plugin_datainjection_models`
                 WHERE `id` = '1')
                UNION (SELECT DISTINCT `itemtype`
                       FROM `glpi_plugin_datainjection_mappings`
                       WHERE `models_id` = '1')
                UNION (SELECT DISTINCT `itemtype`
                       FROM `glpi_plugin_datainjection_infos`
                       WHERE `models_id` = '1')`
  Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`
                 FROM `glpi_plugin_datainjection_models`
                 WHER' at line 1

Page URL

No response

Steps To reproduce

No response

Your GLPI setup information

No response

Anything else?

No response

[stonebuzz]

Hi @FelipeBasilio1991
can you try this -> #445

[FelipeBasilio1991]

I made the change as suggested but it still displays the same error

[stonebuzz]

Which version of glpi are you using?
Which databases (name, version) do you use? (MariaDB / MySql)

[FelipeBasilio1991]

GLPI Version 11.0 dev
Mysql

[trasher]

Currently, most of the plugins are not compatible with GLPI 11.

[stonebuzz]

Please retry with latest offcial release GLPI 10.0.17