Skip to content

SQL Warnings: #512

@khaegebaert

Description

@khaegebaert

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

GLPI 11.0.2

Plugin version

2.12.3

Bug description

I get following errors filling my logs:
glpi.WARNING: *** User Warning: MySQL query warnings:
SQL: SELECT glpi_plugin_order_orders.* FROM glpi_plugin_order_orders, glpi_plugin_order_orders_items WHERE glpi_plugin_order_orders.id = 'glpi_plugin_order_orders_items.plugin_order_orders_id' AND glpi_plugin_order_orders_items.itemtype = 'Computer' AND glpi_plugin_order_orders_items.items_id = '2305'
Warnings:
1292: Truncated incorrect DOUBLE value: 'glpi_plugin_order_orders_items.plugin_order_orders_id' at DBmysql.php line 399
glpi.WARNING: *** User Warning: Invalid relations declared between "glpi_plugin_order_accountsections" and "glpi_plugin_order_accountsections" table. Target field "plugin_order_accountsections_id" is not a foreign key field of "PluginOrderAccountsection". at DbUtils.php line 2232

Relevant log output

Page URL

No response

Steps To reproduce

No response

Your GLPI setup information

No response

Anything else?

No response

Metadata

Metadata

Assignees

Labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions