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.

Sign up for GitHub

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

Jump to bottom

errors in php & sql logs #18067

Closed
2 tasks done
adilbouazzaoui opened this issue Oct 15, 2024 · 2 comments
Closed
2 tasks done

errors in php & sql logs #18067

adilbouazzaoui opened this issue Oct 15, 2024 · 2 comments
Labels
Need feedback

Comments

@adilbouazzaoui
Copy link

adilbouazzaoui commented Oct 15, 2024 •
edited
Loading

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

Version

10.0.15

Bug description

i'm getting following errors in php_errors.log
image

and also these errors in sql-errors.log
image

Relevant log output

GLPI 10.0.15 (/glpi => /var/www/html/glpi)
Installation mode: TARBALL
Current language:en_US

Page URL

No response

Steps To reproduce

no steps, i'm just getting these errors

Your GLPI setup information

php_errors.log:

[2024-10-15 11:43:01] glpiphplog.CRITICAL: *** Uncaught Exception Error: Call to undefined function mysqli_report() in /var/www/html/glpi/src/DBmysql.php at line 226
Backtrace :
src/DBmysql.php:209 DBmysql->connect()
src/DBConnection.php:416 DBmysql->__construct()
src/DBConnection.php:510 DBConnection::switchToMaster()
inc/config.php:129 DBConnection::establishDBConnection()
inc/includes.php:58 include_once()
front/cron.php:44 include()

[2024-10-15 11:44:01] glpiphplog.CRITICAL: *** Uncaught Exception Error: Call to undefined function mysqli_report() in /var/www/html/glpi/src/DBmysql.php at line 226
Backtrace :
src/DBmysql.php:209 DBmysql->connect()
src/DBConnection.php:416 DBmysql->__construct()
src/DBConnection.php:510 DBConnection::switchToMaster()
inc/config.php:129 DBConnection::establishDBConnection()
inc/includes.php:58 include_once()
front/cron.php:44 include()

[2024-10-15 11:45:01] glpiphplog.CRITICAL: *** Uncaught Exception Error: Call to undefined function mysqli_report() in /var/www/html/glpi/src/DBmysql.php at line 226
Backtrace :
src/DBmysql.php:209 DBmysql->connect()
src/DBConnection.php:416 DBmysql->__construct()
src/DBConnection.php:510 DBConnection::switchToMaster()
inc/config.php:129 DBConnection::establishDBConnection()
inc/includes.php:58 include_once()
front/cron.php:44 include()

[2024-10-15 11:46:01] glpiphplog.CRITICAL: *** Uncaught Exception Error: Call to undefined function mysqli_report() in /var/www/html/glpi/src/DBmysql.php at line 226
Backtrace :
src/DBmysql.php:209 DBmysql->connect()
src/DBConnection.php:416 DBmysql->__construct()
src/DBConnection.php:510 DBConnection::switchToMaster()
inc/config.php:129 DBConnection::establishDBConnection()
inc/includes.php:58 include_once()
front/cron.php:44 include()

[2024-10-15 11:47:01] glpiphplog.CRITICAL: *** Uncaught Exception Error: Call to undefined function mysqli_report() in /var/www/html/glpi/src/DBmysql.php at line 226
Backtrace :
src/DBmysql.php:209 DBmysql->connect()
src/DBConnection.php:416 DBmysql->__construct()
src/DBConnection.php:510 DBConnection::switchToMaster()
inc/config.php:129 DBConnection::establishDBConnection()
inc/includes.php:58 include_once()
front/cron.php:44 include()

[2024-10-15 11:48:01] glpiphplog.CRITICAL: *** Uncaught Exception Error: Call to undefined function mysqli_report() in /var/www/html/glpi/src/DBmysql.php at line 226
Backtrace :
src/DBmysql.php:209 DBmysql->connect()
src/DBConnection.php:416 DBmysql->__construct()
src/DBConnection.php:510 DBConnection::switchToMaster()
inc/config.php:129 DBConnection::establishDBConnection()
inc/includes.php:58 include_once()
front/cron.php:44 include()

[2024-10-15 11:49:01] glpiphplog.CRITICAL: *** Uncaught Exception Error: Call to undefined function mysqli_report() in /var/www/html/glpi/src/DBmysql.php at line 226
Backtrace :
src/DBmysql.php:209 DBmysql->connect()
src/DBConnection.php:416 DBmysql->__construct()
src/DBConnection.php:510 DBConnection::switchToMaster()
inc/config.php:129 DBConnection::establishDBConnection()
inc/includes.php:58 include_once()
front/cron.php:44 include()

[2024-10-15 11:50:01] glpiphplog.CRITICAL: *** Uncaught Exception Error: Call to undefined function mysqli_report() in /var/www/html/glpi/src/DBmysql.php at line 226
Backtrace :
src/DBmysql.php:209 DBmysql->connect()
src/DBConnection.php:416 DBmysql->__construct()
src/DBConnection.php:510 DBConnection::switchToMaster()
inc/config.php:129 DBConnection::establishDBConnection()
inc/includes.php:58 include_once()
front/cron.php:44 include()

[2024-10-15 11:51:01] glpiphplog.CRITICAL: *** Uncaught Exception Error: Call to undefined function mysqli_report() in /var/www/html/glpi/src/DBmysql.php at line 226
Backtrace :
src/DBmysql.php:209 DBmysql->connect()
src/DBConnection.php:416 DBmysql->__construct()
src/DBConnection.php:510 DBConnection::switchToMaster()
inc/config.php:129 DBConnection::establishDBConnection()
inc/includes.php:58 include_once()
front/cron.php:44 include()

[2024-10-15 11:52:01] glpiphplog.CRITICAL: *** Uncaught Exception Error: Call to undefined function mysqli_report() in /var/www/html/glpi/src/DBmysql.php at line 226
Backtrace :
src/DBmysql.php:209 DBmysql->connect()
src/DBConnection.php:416 DBmysql->__construct()
src/DBConnection.php:510 DBConnection::switchToMaster()
inc/config.php:129 DBConnection::establishDBConnection()
inc/includes.php:58 include_once()
front/cron.php:44 include()

[2024-10-15 11:53:01] glpiphplog.CRITICAL: *** Uncaught Exception Error: Call to undefined function mysqli_report() in /var/www/html/glpi/src/DBmysql.php at line 226
Backtrace :
src/DBmysql.php:209 DBmysql->connect()
src/DBConnection.php:416 DBmysql->__construct()
src/DBConnection.php:510 DBConnection::switchToMaster()
inc/config.php:129 DBConnection::establishDBConnection()
inc/includes.php:58 include_once()
front/cron.php:44 include()

[2024-10-15 11:54:01] glpiphplog.CRITICAL: *** Uncaught Exception Error: Call to undefined function mysqli_report() in /var/www/html/glpi/src/DBmysql.php at line 226
Backtrace :
src/DBmysql.php:209 DBmysql->connect()
src/DBConnection.php:416 DBmysql->__construct()
src/DBConnection.php:510 DBConnection::switchToMaster()
inc/config.php:129 DBConnection::establishDBConnection()
inc/includes.php:58 include_once()
front/cron.php:44 include()

[2024-10-15 11:55:01] glpiphplog.CRITICAL: *** Uncaught Exception Error: Call to undefined function mysqli_report() in /var/www/html/glpi/src/DBmysql.php at line 226
Backtrace :
src/DBmysql.php:209 DBmysql->connect()
src/DBConnection.php:416 DBmysql->__construct()
src/DBConnection.php:510 DBConnection::switchToMaster()
inc/config.php:129 DBConnection::establishDBConnection()
inc/includes.php:58 include_once()
front/cron.php:44 include()

[2024-10-15 11:56:01] glpiphplog.CRITICAL: *** Uncaught Exception Error: Call to undefined function mysqli_report() in /var/www/html/glpi/src/DBmysql.php at line 226
Backtrace :
src/DBmysql.php:209 DBmysql->connect()
src/DBConnection.php:416 DBmysql->__construct()
src/DBConnection.php:510 DBConnection::switchToMaster()
inc/config.php:129 DBConnection::establishDBConnection()
inc/includes.php:58 include_once()
front/cron.php:44 include()

[2024-10-15 11:57:01] glpiphplog.CRITICAL: *** Uncaught Exception Error: Call to undefined function mysqli_report() in /var/www/html/glpi/src/DBmysql.php at line 226
Backtrace :
src/DBmysql.php:209 DBmysql->connect()
src/DBConnection.php:416 DBmysql->__construct()
src/DBConnection.php:510 DBConnection::switchToMaster()
inc/config.php:129 DBConnection::establishDBConnection()
inc/includes.php:58 include_once()
front/cron.php:44 include()

[2024-10-15 11:58:01] glpiphplog.CRITICAL: *** Uncaught Exception Error: Call to undefined function mysqli_report() in /var/www/html/glpi/src/DBmysql.php at line 226
Backtrace :
src/DBmysql.php:209 DBmysql->connect()
src/DBConnection.php:416 DBmysql->__construct()
src/DBConnection.php:510 DBConnection::switchToMaster()
inc/config.php:129 DBConnection::establishDBConnection()
inc/includes.php:58 include_once()
front/cron.php:44 include()

[2024-10-15 11:59:01] glpiphplog.CRITICAL: *** Uncaught Exception Error: Call to undefined function mysqli_report() in /var/www/html/glpi/src/DBmysql.php at line 226
Backtrace :
src/DBmysql.php:209 DBmysql->connect()
src/DBConnection.php:416 DBmysql->__construct()
src/DBConnection.php:510 DBConnection::switchToMaster()
inc/config.php:129 DBConnection::establishDBConnection()
inc/includes.php:58 include_once()
front/cron.php:44 include()

[2024-10-15 12:00:01] glpiphplog.CRITICAL: *** Uncaught Exception Error: Call to undefined function mysqli_report() in /var/www/html/glpi/src/DBmysql.php at line 226
Backtrace :
src/DBmysql.php:209 DBmysql->connect()
src/DBConnection.php:416 DBmysql->__construct()
src/DBConnection.php:510 DBConnection::switchToMaster()
inc/config.php:129 DBConnection::establishDBConnection()
inc/includes.php:58 include_once()
front/cron.php:44 include()

[2024-10-15 12:01:01] glpiphplog.CRITICAL: *** Uncaught Exception Error: Call to undefined function mysqli_report() in /var/www/html/glpi/src/DBmysql.php at line 226
Backtrace :
src/DBmysql.php:209 DBmysql->connect()
src/DBConnection.php:416 DBmysql->__construct()
src/DBConnection.php:510 DBConnection::switchToMaster()
inc/config.php:129 DBConnection::establishDBConnection()
inc/includes.php:58 include_once()
front/cron.php:44 include()

[2024-10-15 12:02:01] glpiphplog.CRITICAL: *** Uncaught Exception Error: Call to undefined function mysqli_report() in /var/www/html/glpi/src/DBmysql.php at line 226
Backtrace :
src/DBmysql.php:209 DBmysql->connect()
src/DBConnection.php:416 DBmysql->__construct()
src/DBConnection.php:510 DBConnection::switchToMaster()
inc/config.php:129 DBConnection::establishDBConnection()
inc/includes.php:58 include_once()
front/cron.php:44 include()

[2024-10-15 12:03:01] glpiphplog.CRITICAL: *** Uncaught Exception Error: Call to undefined function mysqli_report() in /var/www/html/glpi/src/DBmysql.php at line 226
Backtrace :
src/DBmysql.php:209 DBmysql->connect()
src/DBConnection.php:416 DBmysql->__construct()
src/DBConnection.php:510 DBConnection::switchToMaster()
inc/config.php:129 DBConnection::establishDBConnection()
inc/includes.php:58 include_once()
front/cron.php:44 include()

[2024-10-15 12:04:01] glpiphplog.CRITICAL: *** Uncaught Exception Error: Call to undefined function mysqli_report() in /var/www/html/glpi/src/DBmysql.php at line 226
Backtrace :
src/DBmysql.php:209 DBmysql->connect()
src/DBConnection.php:416 DBmysql->__construct()
src/DBConnection.php:510 DBConnection::switchToMaster()
inc/config.php:129 DBConnection::establishDBConnection()
inc/includes.php:58 include_once()
front/cron.php:44 include()

[2024-10-15 12:05:01] glpiphplog.CRITICAL: *** Uncaught Exception Error: Call to undefined function mysqli_report() in /var/www/html/glpi/src/DBmysql.php at line 226
Backtrace :
src/DBmysql.php:209 DBmysql->connect()
src/DBConnection.php:416 DBmysql->__construct()
src/DBConnection.php:510 DBConnection::switchToMaster()
inc/config.php:129 DBConnection::establishDBConnection()
inc/includes.php:58 include_once()
front/cron.php:44 include()

[2024-10-15 12:06:01] glpiphplog.CRITICAL: *** Uncaught Exception Error: Call to undefined function mysqli_report() in /var/www/html/glpi/src/DBmysql.php at line 226
Backtrace :
src/DBmysql.php:209 DBmysql->connect()
src/DBConnection.php:416 DBmysql->__construct()
src/DBConnection.php:510 DBConnection::switchToMaster()
inc/config.php:129 DBConnection::establishDBConnection()
inc/includes.php:58 include_once()
front/cron.php:44 include()

[2024-10-15 12:07:01] glpiphplog.CRITICAL: *** Uncaught Exception Error: Call to undefined function mysqli_report() in /var/www/html/glpi/src/DBmysql.php at line 226
Backtrace :
src/DBmysql.php:209 DBmysql->connect()
src/DBConnection.php:416 DBmysql->__construct()
src/DBConnection.php:510 DBConnection::switchToMaster()
inc/config.php:129 DBConnection::establishDBConnection()
inc/includes.php:58 include_once()
front/cron.php:44 include()

[2024-10-15 12:08:01] glpiphplog.CRITICAL: *** Uncaught Exception Error: Call to undefined function mysqli_report() in /var/www/html/glpi/src/DBmysql.php at line 226
Backtrace :
src/DBmysql.php:209 DBmysql->connect()
src/DBConnection.php:416 DBmysql->__construct()
src/DBConnection.php:510 DBConnection::switchToMaster()
inc/config.php:129 DBConnection::establishDBConnection()
inc/includes.php:58 include_once()
front/cron.php:44 include()

[2024-10-15 12:09:01] glpiphplog.CRITICAL: *** Uncaught Exception Error: Call to undefined function mysqli_report() in /var/www/html/glpi/src/DBmysql.php at line 226
Backtrace :
src/DBmysql.php:209 DBmysql->connect()
src/DBConnection.php:416 DBmysql->__construct()
src/DBConnection.php:510 DBConnection::switchToMaster()
inc/config.php:129 DBConnection::establishDBConnection()
inc/includes.php:58 include_once()
front/cron.php:44 include()

[2024-10-15 12:10:01] glpiphplog.CRITICAL: *** Uncaught Exception Error: Call to undefined function mysqli_report() in /var/www/html/glpi/src/DBmysql.php at line 226
Backtrace :
src/DBmysql.php:209 DBmysql->connect()
src/DBConnection.php:416 DBmysql->__construct()
src/DBConnection.php:510 DBConnection::switchToMaster()
inc/config.php:129 DBConnection::establishDBConnection()
inc/includes.php:58 include_once()
front/cron.php:44 include()

[2024-10-15 12:11:01] glpiphplog.CRITICAL: *** Uncaught Exception Error: Call to undefined function mysqli_report() in /var/www/html/glpi/src/DBmysql.php at line 226
Backtrace :
src/DBmysql.php:209 DBmysql->connect()
src/DBConnection.php:416 DBmysql->__construct()
src/DBConnection.php:510 DBConnection::switchToMaster()
inc/config.php:129 DBConnection::establishDBConnection()
inc/includes.php:58 include_once()
front/cron.php:44 include()

[2024-10-15 12:12:01] glpiphplog.CRITICAL: *** Uncaught Exception Error: Call to undefined function mysqli_report() in /var/www/html/glpi/src/DBmysql.php at line 226
Backtrace :
src/DBmysql.php:209 DBmysql->connect()
src/DBConnection.php:416 DBmysql->__construct()
src/DBConnection.php:510 DBConnection::switchToMaster()
inc/config.php:129 DBConnection::establishDBConnection()
inc/includes.php:58 include_once()
front/cron.php:44 include()

[2024-10-15 12:13:01] glpiphplog.CRITICAL: *** Uncaught Exception Error: Call to undefined function mysqli_report() in /var/www/html/glpi/src/DBmysql.php at line 226
Backtrace :
src/DBmysql.php:209 DBmysql->connect()
src/DBConnection.php:416 DBmysql->__construct()
src/DBConnection.php:510 DBConnection::switchToMaster()
inc/config.php:129 DBConnection::establishDBConnection()
inc/includes.php:58 include_once()
front/cron.php:44 include()

[2024-10-15 12:14:01] glpiphplog.CRITICAL: *** Uncaught Exception Error: Call to undefined function mysqli_report() in /var/www/html/glpi/src/DBmysql.php at line 226
Backtrace :
src/DBmysql.php:209 DBmysql->connect()
src/DBConnection.php:416 DBmysql->__construct()
src/DBConnection.php:510 DBConnection::switchToMaster()
inc/config.php:129 DBConnection::establishDBConnection()
inc/includes.php:58 include_once()
front/cron.php:44 include()

[2024-10-15 12:15:01] glpiphplog.CRITICAL: *** Uncaught Exception Error: Call to undefined function mysqli_report() in /var/www/html/glpi/src/DBmysql.php at line 226
Backtrace :
src/DBmysql.php:209 DBmysql->connect()
src/DBConnection.php:416 DBmysql->__construct()
src/DBConnection.php:510 DBConnection::switchToMaster()
inc/config.php:129 DBConnection::establishDBConnection()
inc/includes.php:58 include_once()
front/cron.php:44 include()

[2024-10-15 12:16:01] glpiphplog.CRITICAL: *** Uncaught Exception Error: Call to undefined function mysqli_report() in /var/www/html/glpi/src/DBmysql.php at line 226
Backtrace :
src/DBmysql.php:209 DBmysql->connect()
src/DBConnection.php:416 DBmysql->__construct()
src/DBConnection.php:510 DBConnection::switchToMaster()
inc/config.php:129 DBConnection::establishDBConnection()
inc/includes.php:58 include_once()
front/cron.php:44 include()

[2024-10-15 12:17:01] glpiphplog.CRITICAL: *** Uncaught Exception Error: Call to undefined function mysqli_report() in /var/www/html/glpi/src/DBmysql.php at line 226
Backtrace :
src/DBmysql.php:209 DBmysql->connect()
src/DBConnection.php:416 DBmysql->__construct()
src/DBConnection.php:510 DBConnection::switchToMaster()
inc/config.php:129 DBConnection::establishDBConnection()
inc/includes.php:58 include_once()
front/cron.php:44 include()

[2024-10-15 12:18:01] glpiphplog.CRITICAL: *** Uncaught Exception Error: Call to undefined function mysqli_report() in /var/www/html/glpi/src/DBmysql.php at line 226
Backtrace :
src/DBmysql.php:209 DBmysql->connect()
src/DBConnection.php:416 DBmysql->__construct()
src/DBConnection.php:510 DBConnection::switchToMaster()
inc/config.php:129 DBConnection::establishDBConnection()
inc/includes.php:58 include_once()
front/cron.php:44 include()

[2024-10-15 12:19:01] glpiphplog.CRITICAL: *** Uncaught Exception Error: Call to undefined function mysqli_report() in /var/www/html/glpi/src/DBmysql.php at line 226
Backtrace :
src/DBmysql.php:209 DBmysql->connect()
src/DBConnection.php:416 DBmysql->__construct()
src/DBConnection.php:510 DBConnection::switchToMaster()
inc/config.php:129 DBConnection::establishDBConnection()
inc/includes.php:58 include_once()
front/cron.php:44 include()

[2024-10-15 10:19:17] glpiphplog.CRITICAL: *** Uncaught Exception Error: Class "PluginFusioninventoryDBMysqlLock" not found in /var/www/html/glpi/plugins/fusioninventory/front/communication.php at line 71
Backtrace :
plugins/fusioninventory/index.php:59 include_once()

[2024-10-15 12:20:01] glpiphplog.CRITICAL: *** Uncaught Exception Error: Call to undefined function mysqli_report() in /var/www/html/glpi/src/DBmysql.php at line 226
Backtrace :
src/DBmysql.php:209 DBmysql->connect()
src/DBConnection.php:416 DBmysql->__construct()
src/DBConnection.php:510 DBConnection::switchToMaster()
inc/config.php:129 DBConnection::establishDBConnection()
inc/includes.php:58 include_once()
front/cron.php:44 include()

[2024-10-15 12:21:01] glpiphplog.CRITICAL: *** Uncaught Exception Error: Call to undefined function mysqli_report() in /var/www/html/glpi/src/DBmysql.php at line 226
Backtrace :
src/DBmysql.php:209 DBmysql->connect()
src/DBConnection.php:416 DBmysql->__construct()
src/DBConnection.php:510 DBConnection::switchToMaster()
inc/config.php:129 DBConnection::establishDBConnection()
inc/includes.php:58 include_once()
front/cron.php:44 include()

[2024-10-15 12:22:01] glpiphplog.CRITICAL: *** Uncaught Exception Error: Call to undefined function mysqli_report() in /var/www/html/glpi/src/DBmysql.php at line 226
Backtrace :
src/DBmysql.php:209 DBmysql->connect()
src/DBConnection.php:416 DBmysql->__construct()
src/DBConnection.php:510 DBConnection::switchToMaster()
inc/config.php:129 DBConnection::establishDBConnection()
inc/includes.php:58 include_once()
front/cron.php:44 include()

[2024-10-15 12:23:01] glpiphplog.CRITICAL: *** Uncaught Exception Error: Call to undefined function mysqli_report() in /var/www/html/glpi/src/DBmysql.php at line 226
Backtrace :
src/DBmysql.php:209 DBmysql->connect()
src/DBConnection.php:416 DBmysql->__construct()
src/DBConnection.php:510 DBConnection::switchToMaster()
inc/config.php:129 DBConnection::establishDBConnection()
inc/includes.php:58 include_once()
front/cron.php:44 include()

[2024-10-15 12:24:01] glpiphplog.CRITICAL: *** Uncaught Exception Error: Call to undefined function mysqli_report() in /var/www/html/glpi/src/DBmysql.php at line 226
Backtrace :
src/DBmysql.php:209 DBmysql->connect()
src/DBConnection.php:416 DBmysql->__construct()
src/DBConnection.php:510 DBConnection::switchToMaster()
inc/config.php:129 DBConnection::establishDBConnection()
inc/includes.php:58 include_once()
front/cron.php:44 include()

[2024-10-15 12:25:01] glpiphplog.CRITICAL: *** Uncaught Exception Error: Call to undefined function mysqli_report() in /var/www/html/glpi/src/DBmysql.php at line 226
Backtrace :
src/DBmysql.php:209 DBmysql->connect()
src/DBConnection.php:416 DBmysql->__construct()
src/DBConnection.php:510 DBConnection::switchToMaster()
inc/config.php:129 DBConnection::establishDBConnection()
inc/includes.php:58 include_once()
front/cron.php:44 include()

[2024-10-15 12:26:01] glpiphplog.CRITICAL: *** Uncaught Exception Error: Call to undefined function mysqli_report() in /var/www/html/glpi/src/DBmysql.php at line 226
Backtrace :
src/DBmysql.php:209 DBmysql->connect()
src/DBConnection.php:416 DBmysql->__construct()
src/DBConnection.php:510 DBConnection::switchToMaster()
inc/config.php:129 DBConnection::establishDBConnection()
inc/includes.php:58 include_once()
front/cron.php:44 include()

mysql-error.log

{"user":"inventory@XXX"}
[2024-10-10 10:45:26] glpisqllog.WARNING: DBmysql::query() in /var/www/html/glpi/src/DBmysql.php line 419
*** MySQL query warnings:
SQL: SELECT * FROM glpi_lockedfields WHERE itemtype = 'Item_DeviceProcessor' AND ((items_id = '' OR is_global = '1'))
Warnings:
1292: Truncated incorrect DECIMAL value: ''
Backtrace :
src/DBmysqlIterator.php:112
src/DBmysql.php:1078 DBmysqlIterator->execute()
src/Lockedfield.php:185 DBmysql->request()
src/Lockedfield.php:158 Lockedfield->getLocks()
src/Inventory/Asset/InventoryAsset.php:433 Lockedfield->getLockedNames()
src/Inventory/Asset/Device.php:175 Glpi\Inventory\Asset\InventoryAsset->handleInput()
src/Inventory/Asset/MainAsset.php:937 Glpi\Inventory\Asset\Device->handle()
src/Inventory/Asset/MainAsset.php:852 Glpi\Inventory\Asset\MainAsset->handleAssets()
src/RuleImportAsset.php:969 Glpi\Inventory\Asset\MainAsset->rulepassed()
src/Rule.php:1533 RuleImportAsset->executeActions()
src/RuleCollection.php:1640 Rule->process()
src/Inventory/Asset/MainAsset.php:574 RuleCollection->processAllRules()
src/Inventory/Inventory.php:722 Glpi\Inventory\Asset\MainAsset->handle()
src/Inventory/Inventory.php:353 Glpi\Inventory\Inventory->handleItem()
src/Inventory/Request.php:360 Glpi\Inventory\Inventory->doInventory()
src/Inventory/Request.php:90 Glpi\Inventory\Request->inventory()
src/Agent/Communication/AbstractRequest.php:359 Glpi\Inventory\Request->handleAction()
src/Agent/Communication/AbstractRequest.php:271 Glpi\Agent\Communication\AbstractRequest->handleJSONRequest()
front/inventory.php:94 Glpi\Agent\Communication\AbstractRequest->handleRequest()
index.php:93 include_once()
{"user":"inventory@XXX"}
[2024-10-10 11:03:58] glpisqllog.WARNING: DBmysql::query() in /var/www/html/glpi/src/DBmysql.php line 419
*** MySQL query warnings:
SQL: SELECT * FROM glpi_lockedfields WHERE itemtype = 'Item_DeviceNetworkCard' AND ((items_id = '' OR is_global = '1'))
Warnings:
1292: Truncated incorrect DECIMAL value: ''
Backtrace :
src/DBmysqlIterator.php:112
src/DBmysql.php:1078 DBmysqlIterator->execute()
src/Lockedfield.php:185 DBmysql->request()
src/Lockedfield.php:158 Lockedfield->getLocks()
src/Inventory/Asset/InventoryAsset.php:433 Lockedfield->getLockedNames()
src/Inventory/Asset/Device.php:175 Glpi\Inventory\Asset\InventoryAsset->handleInput()
src/Inventory/Asset/InventoryNetworkPort.php:62 Glpi\Inventory\Asset\Device->handle()
src/Inventory/Asset/MainAsset.php:937 Glpi\Inventory\Asset\NetworkCard->handle()
src/Inventory/Asset/MainAsset.php:852 Glpi\Inventory\Asset\MainAsset->handleAssets()
src/RuleImportAsset.php:969 Glpi\Inventory\Asset\MainAsset->rulepassed()
src/Rule.php:1533 RuleImportAsset->executeActions()
src/RuleCollection.php:1640 Rule->process()
src/Inventory/Asset/MainAsset.php:574 RuleCollection->processAllRules()
src/Inventory/Inventory.php:722 Glpi\Inventory\Asset\MainAsset->handle()
src/Inventory/Inventory.php:353 Glpi\Inventory\Inventory->handleItem()
src/Inventory/Request.php:360 Glpi\Inventory\Inventory->doInventory()
src/Inventory/Request.php:90 Glpi\Inventory\Request->inventory()
src/Agent/Communication/AbstractRequest.php:359 Glpi\Inventory\Request->handleAction()
src/Agent/Communication/AbstractRequest.php:271 Glpi\Agent\Communication\AbstractRequest->handleJSONRequest()
front/inventory.php:94 Glpi\Agent\Communication\AbstractRequest->handleRequest()
index.php:93 include_once()
{"user":"inventory@XXX"}
[2024-10-10 11:33:00] glpisqllog.WARNING: DBmysql::query() in /var/www/html/glpi/src/DBmysql.php line 419
*** MySQL query warnings:
SQL: SELECT * FROM glpi_lockedfields WHERE itemtype = 'Item_DeviceGraphicCard' AND ((items_id = '' OR is_global = '1'))
Warnings:
1292: Truncated incorrect DECIMAL value: ''
Backtrace :
src/DBmysqlIterator.php:112
src/DBmysql.php:1078 DBmysqlIterator->execute()
src/Lockedfield.php:185 DBmysql->request()
src/Lockedfield.php:158 Lockedfield->getLocks()
src/Inventory/Asset/InventoryAsset.php:433 Lockedfield->getLockedNames()
src/Inventory/Asset/Device.php:175 Glpi\Inventory\Asset\InventoryAsset->handleInput()
src/Inventory/Asset/MainAsset.php:937 Glpi\Inventory\Asset\Device->handle()
src/Inventory/Asset/MainAsset.php:852 Glpi\Inventory\Asset\MainAsset->handleAssets()
src/RuleImportAsset.php:988 Glpi\Inventory\Asset\MainAsset->rulepassed()
src/Rule.php:1533 RuleImportAsset->executeActions()
src/RuleCollection.php:1640 Rule->process()
src/Inventory/Asset/MainAsset.php:574 RuleCollection->processAllRules()
src/Inventory/Inventory.php:722 Glpi\Inventory\Asset\MainAsset->handle()
src/Inventory/Inventory.php:353 Glpi\Inventory\Inventory->handleItem()
src/Inventory/Request.php:360 Glpi\Inventory\Inventory->doInventory()
src/Inventory/Request.php:90 Glpi\Inventory\Request->inventory()
src/Agent/Communication/AbstractRequest.php:359 Glpi\Inventory\Request->handleAction()
src/Agent/Communication/AbstractRequest.php:271 Glpi\Agent\Communication\AbstractRequest->handleJSONRequest()
front/inventory.php:94 Glpi\Agent\Communication\AbstractRequest->handleRequest()
index.php:93 include_once()
{"user":"inventory@XXX"}
[2024-10-10 11:33:00] glpisqllog.WARNING: DBmysql::query() in /var/www/html/glpi/src/DBmysql.php line 419
*** MySQL query warnings:
SQL: SELECT * FROM glpi_lockedfields WHERE itemtype = 'Item_DeviceGraphicCard' AND ((items_id = '' OR is_global = '1'))
Warnings:
1292: Truncated incorrect DECIMAL value: ''
Backtrace :
src/DBmysqlIterator.php:112
src/DBmysql.php:1078 DBmysqlIterator->execute()
src/Lockedfield.php:185 DBmysql->request()
src/Lockedfield.php:158 Lockedfield->getLocks()
src/Inventory/Asset/InventoryAsset.php:433 Lockedfield->getLockedNames()
src/Inventory/Asset/Device.php:175 Glpi\Inventory\Asset\InventoryAsset->handleInput()
src/Inventory/Asset/MainAsset.php:937 Glpi\Inventory\Asset\Device->handle()
src/Inventory/Asset/MainAsset.php:852 Glpi\Inventory\Asset\MainAsset->handleAssets()
src/RuleImportAsset.php:988 Glpi\Inventory\Asset\MainAsset->rulepassed()
src/Rule.php:1533 RuleImportAsset->executeActions()
src/RuleCollection.php:1640 Rule->process()
src/Inventory/Asset/MainAsset.php:574 RuleCollection->processAllRules()
src/Inventory/Inventory.php:722 Glpi\Inventory\Asset\MainAsset->handle()
src/Inventory/Inventory.php:353 Glpi\Inventory\Inventory->handleItem()
src/Inventory/Request.php:360 Glpi\Inventory\Inventory->doInventory()
src/Inventory/Request.php:90 Glpi\Inventory\Request->inventory()
src/Agent/Communication/AbstractRequest.php:359 Glpi\Inventory\Request->handleAction()
src/Agent/Communication/AbstractRequest.php:271 Glpi\Agent\Communication\AbstractRequest->handleJSONRequest()
front/inventory.php:94 Glpi\Agent\Communication\AbstractRequest->handleRequest()
index.php:93 include_once()
{"user":"inventory@XXX","mem_usage":"0.002", 3.71Mio)"}

LDAP directories:
Server: 'X.X.X.X', Port: '389', BaseDN: 'OU=XXX,DC=XXX,DC=LOCAL', Connection filter:
'(&(objectClass=user)(objectCategory=person)(!(userAccountControl:1.2.840.113556.1.4.803:=2)))', RootDN:
'[email protected]', Use TLS: none
Server: 'X.X.X.X', Port: '389', BaseDN: 'OU=XXX,DC=XXX-XXX,DC=LOCAL', Connection filter:
'(&(objectClass=user)(objectCategory=person)(mail=@XXX.com)(userprincipalname=)(!(userAccountControl:1.2.840.113556.1.4.803:=2)))',
RootDN: '[email protected]', Use TLS: none
Server: 'X.X.X.X', Port: '389', BaseDN: 'OU=XXX,DC=XXX,DC=local', Connection filter:
'(&(objectClass=user)(objectCategory=person)(mail=@XXX.ma)(userprincipalname=@XXX.local)(!(userAccountControl:1.2.840.113556.1.4.803:=2)))',
RootDN: '[email protected]', Use TLS: none
Server: 'X.X.X.X', Port: '389', BaseDN: 'OU=Users,OU=XXX,DC=XXX,DC=local', Connection filter:
'(&(objectClass=user)(objectCategory=person)(mail=@XXX.fr)(userprincipalname=@XXX.fr)(!(userAccountControl:1.2.840.113556.1.4.803:=2)))',
RootDN: '[email protected]', Use TLS: none
Server: 'X.X.X.X', Port: '389', BaseDN: 'OU=Users,OU=XXX,DC=XXX,DC=local', Connection filter:
'(&(objectClass=user)(objectCategory=person)(mail=@XXX.fr)(userprincipalname=@XXX.fr)(!(userAccountControl:1.2.840.113556.1.4.803:=2)))',
RootDN: '[email protected]', Use TLS: none
Server: 'X.X.X.X', Port: '389', BaseDN: 'OU=Users,OU=XXX,DC=XXX,DC=LOCAL', Connection filter:
'(&(objectClass=user)(objectCategory=person)(mail=@XXX.ma)(userprincipalname=@XXX.ma)(!(userAccountControl:1.2.840.113556.1.4.803:=2)))',
RootDN: '[email protected]', Use TLS: none

SQL replicas
Not active

Anything else?

N/A
@cconard96
Copy link
Contributor

Please update to the latest GLPI version and see if the issues persist.

Also, make sure your system default version of PHP matches the one used by your web server to resolve the mysql_report issues from front/cron.php. see: #16153 (comment)

@adilbouazzaoui
Copy link
Author

Hi,
i updated GLPI to the latest version and PHP versions are matching.
no i don't receive these errors.

Thank you for the support.

@trasher trasher closed this as not planned Won't fix, can't repro, duplicate, stale Oct 15, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
Need feedback
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@trasher @cconard96 @adilbouazzaoui