cconard96
commented
2 years ago Do you have any entries in files/_log/sql-errors.log around that time too?
Closed ghost closed 2 years ago
cconard96
commented
2 years ago Do you have any entries in files/_log/sql-errors.log around that time too?
ghost
commented
2 years ago @cconard96 This is the closest time wise. previous error was hours earlier
[2022-02-23 22:40:23] glpisqllog.WARNING: DBmysql::query() in E:\xampp\htdocs\glpi\src\DBmysql.php line 401
** MySQL query warnings:
SQL: SELECT FROM glpi_computers WHERE is_deleted = '0' AND is_template = '0' AND ((name LIKE '%b%' OR id = 'b' OR contact LIKE '%b%' OR serial LIKE '%b%' OR otherserial LIKE '%b%')) AND (glpi_computers.entities_id = '0') ORDER BY name LIMIT 100
Warnings:
1292: Truncated incorrect DOUBLE value: 'b'
Backtrace :
src\DBmysqlIterator.php:108
src\DBmysql.php:1039 DBmysqlIterator->execute()
src\Dropdown.php:3608 DBmysql->request()
ajax\getDropdownFindNum.php:45 Dropdown::getDropdownFindNum()
{"user":"7@TSLGLPI"}
cconard96
commented
2 years ago I think i fixed this. Can you test the changes made in the linked pull request?
ghost
commented
2 years ago Test changes. Issue has been fixed. Thanks @cconard96
faisalds
commented
5 months ago I think I'm having a similar issue to the one described in this thread. I'm running GLPI 10.0.10, and I'm finding that the search box in tickets is not working. I've searched the forum but haven't found a solution. Does anyone have any ideas on how to fix this? Is there anything I missed out? Thanks
cedric-anne
commented
5 months ago I think I'm having a similar issue to the one described in this thread. I'm running GLPI 10.0.10, and I'm finding that the search box in tickets is not working. I've searched the forum but haven't found a solution. Does anyone have any ideas on how to fix this? Is there anything I missed out? Thanks
@faisalds Please open a new issue and give all requested details. Also, please try to reproduce on latest GLPI version first. Maybe your issue has been resolved.
Code of Conduct
Is there an existing issue for this?
Version
10.0.0-rc1
Bug description
When adding items to tickets the lists of software, computers, etc are not searchable. The box for searching is there but nothing comes up
Relevant log output
Page URL
https://localhost/glpi/front/user.php
Steps To reproduce
Your GLPI setup information
Information about system installation & configuration
Server
Operating system: Windows NT TSLGLPI 10.0 build 17763 (Windows Server 2019) AMD64 PHP 8.1.2 apache2handler (Core, PDO, Phar, Reflection, SPL, SimpleXML, apache2handler, bcmath, bz2, calendar, ctype, curl, date, dom, exif, fileinfo, filter, ftp, gd, gettext, hash, iconv, intl, json, libxml, mbstring, mysqli, mysqlnd, openssl, pcre, pdo_mysql, pdo_sqlite, readline, session, standard, tokenizer, xml, xmlreader, xmlwriter, zip, zlib) Setup: max_execution_time="120" memory_limit="512M" post_max_size="40M" safe_mode="" session.save_handler="files" upload_max_filesize="40M" Software: Apache/2.4.52 (Win64) OpenSSL/1.1.1m PHP/8.1.2 (Apache/2.4.52 (Win64) OpenSSL/1.1.1m PHP/8.1.2 Server at tslglpi Port 443 ) Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:97.0) Gecko/20100101 Firefox/97.0 Server Software: mariadb.org binary distribution Server Version: 10.4.22-MariaDB Server SQL Mode: NO_ZERO_IN_DATE,NO_ZERO_DATE,NO_ENGINE_SUBSTITUTION Parameters: root@127.0.0.1/glpi Host info: 127.0.0.1 via TCP/IP PHP version (8.1.2) is supported. Sessions configuration is OK. Allocated memory is sufficient. mysqli extension is installed. Following extensions are installed: dom, fileinfo, json, simplexml. curl extension is installed. gd extension is installed. intl extension is installed. libxml extension is installed. zlib extension is installed. Database engine version (10.4.22) is supported. The log file has been created successfully. Write access to E:\xampp\htdocs\glpi/files/_cache has been validated. Write access to E:\xampp\htdocs\glpi/config has been validated. Write access to E:\xampp\htdocs\glpi/files/_cron has been validated. Write access to E:\xampp\htdocs\glpi/files has been validated. Write access to E:\xampp\htdocs\glpi/files/_dumps has been validated. Write access to E:\xampp\htdocs\glpi/files/_graphs has been validated. Write access to E:\xampp\htdocs\glpi/files/_lock has been validated. Write access to E:\xampp\htdocs\glpi/files/_pictures has been validated. Write access to E:\xampp\htdocs\glpi/files/_plugins has been validated. Write access to E:\xampp\htdocs\glpi/files/_rss has been validated. Write access to E:\xampp\htdocs\glpi/files/_sessions has been validated. Write access to E:\xampp\htdocs\glpi/files/_tmp has been validated. Write access to E:\xampp\htdocs\glpi/files/_uploads has been validated. Web access to the files directory should not be allowed but this cannot be checked automatically on this instance. Make sure access to error log file (/glpi/files/_log/php-errors.log) is forbidden; otherwise review .htaccess file and web server configuration. exif extension is installed. ldap extension is not present. openssl extension is installed. zip extension is installed. bz2 extension is installed. Zend OPcache extension is not present. Following extensions are installed: ctype, iconv, mbstring. Following extensions are not present: sodium. Write access to E:\xampp\htdocs\glpi/marketplace has been validated. Timezones seems not loaded, see https://glpi-install.readthedocs.io/en/latest/timezones.html.GLPI constants
Libraries
SQL replicas
Notifications
Plugins list
accounts Name: Accounts Version: 3.0.0-rc2 State: Enabled resources Name: Human Resources Version: 3.0.0-rc2 State: Not installed screenshot Name: Screenshot Version: 2.0.0-beta1 State: EnabledAnything else?
No response