MySQL query error

[FelipeBasilio1991]

Code of Conduct

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

Is there an existing issue for this?

• [X] 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 -> https://github.com/pluginsGLPI/datainjection/pull/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

[github-actions[bot]]

There has been no activity on this issue for some time and therefore it is considered stale and will be closed automatically in 10 days.

If this issue is related to a bug, please try to reproduce on latest release. If the problem persist, feel free to add a comment to revive this issue. If it is related to a new feature, please open a topic to discuss with community about this enhancement on suggestion website.

You may also consider taking a subscription to get professionnal support or contact GLPI editor team directly.