cconard96
commented
1 year ago I confirm there are some issues with the regex patterns used by this command when using MySQL. MariaDB does not seem affected.
Open NazarovRoman opened 1 year ago
cconard96
commented
1 year ago I confirm there are some issues with the regex patterns used by this command when using MySQL. MariaDB does not seem affected.
Code of Conduct
Is there an existing issue for this?
Version
10.0.9
Bug description
php /glpi/bin/console diagnostic:check_html_encoding
SQL Error "1139": Got error 'repetition-operator operand invalid' from regexp in query "SELECT[^@]?@[a-zA-Z0-9\-.]?)(>)'))"
SQL Error "1139": Got error 'repetition-operator operand invalid' from regexp in query "SELECT [^@]?@[a-zA-Z0-9\-.]?)(>)'))"
idFROMglpi_itilfollowupsWHERE ((contentLIKE '%"(?!;)/%') OR (contentREGEXP '(<)(?idFROMglpi_ticketsWHERE ((contentLIKE '%"(?!;)/%') OR (contentREGEXP '(<)(?Информация о системе, установке и конфигурации
Server
Operating system: Linux help.bpmg.kz 3.10.0-1160.95.1.el7.x86_64 #1 SMP Mon Jul 24 13:59:37 UTC 2023 x86_64 PHP 8.1.22 fpm-fcgi (Core, PDO, PDO_ODBC, Phar, Reflection, SPL, SimpleXML, Zend OPcache, apcu, bcmath, bz2, calendar, cgi-fcgi, ctype, curl, date, dom, exif, fileinfo, filter, ftp, gd, gettext, hash, iconv, imagick, imap, intl, json, ldap, libxml, mbstring, mcrypt, memcache, mysqli, mysqlnd, odbc, openssl, pcre, pdo_mysql, pdo_sqlite, posix, pspell, recode, session, shmop, soap, sockets, sodium, sqlite3, standard, sysvmsg, sysvsem, sysvshm, tidy, tokenizer, xml, xmlreader, xmlrpc, xmlwriter, xsl, zip, zlib) Setup: max_execution_time="600" memory_limit="64M" post_max_size="20M" safe_mode="" session.save_handler="files" upload_max_filesize="20M" Software: nginx/1.24.0 Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/115.0.0.0 Safari/537.36 Server Software: Percona Server (GPL), Release 46, Revision e1995a8bb71 Server Version: 5.7.42-46 Server SQL Mode: STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION Parameters: glpiuser@localhost/glpidb Host info: Localhost via UNIX socket PHP version (8.1.22) is supported. Sessions configuration is OK. Allocated memory is sufficient. mysqli extension is installed. Following extensions are installed: dom, fileinfo, filter, libxml, json, simplexml, xmlreader, xmlwriter. curl extension is installed. gd extension is installed. intl extension is installed. zlib extension is installed. The constant SODIUM_CRYPTO_AEAD_XCHACHA20POLY1305_IETF_NPUBBYTES is present. Database engine version (5.7.42) is supported. No files from previous GLPI version detected. The log file has been created successfully. Write access to /var/lib/glpi/_cache has been validated. Write access to /etc/glpi/ has been validated. Write access to /var/lib/glpi/_cron has been validated. Write access to /var/lib/glpi has been validated. Write access to /var/lib/glpi/_dumps has been validated. Write access to /var/lib/glpi/_graphs has been validated. Write access to /var/lib/glpi/_lock has been validated. Write access to /var/lib/glpi/_pictures has been validated. Write access to /var/lib/glpi/_plugins has been validated. Write access to /var/lib/glpi/_rss has been validated. Write access to /var/lib/glpi/_sessions has been validated. Write access to /var/lib/glpi/_tmp has been validated. Write access to /var/lib/glpi/_uploads has been validated. For security reasons, SELinux mode should be Enforcing. Web server root directory configuration seems safe. Sessions configuration is secured. OS and PHP are relying on 64 bits integers. exif extension is installed. ldap extension is installed. openssl extension is installed. Following extensions are installed: bz2, Phar, zip. Zend OPcache extension is installed. Following extensions are installed: ctype, iconv, mbstring, sodium. Write access to /opt/glpi/marketplace has been validated. Timezones seems loaded in database.GLPI constants
Libraries
SQL replicas
Notifications
Plugins list
activity Name: Activities Version: 3.1.2 State: Installed / not activated Install Method: Marketplace actualtime Name: ActualTime Version: 2.1.0 State: Installed / not activated Install Method: Marketplace advancedplanning Name: advancedplanning Version: 1.1.0 State: Installed / not activated Install Method: Marketplace archisw Name: Apps structures Version: 3.0.10 State: Installed / not activated Install Method: Marketplace badges Name: Badges Version: 3.0.0 State: Installed / not activated Install Method: Marketplace barcode Name: Barcode Version: 2.7.1 State: Installed / not activated Install Method: Marketplace archibp Name: Business Processes Version: 2.0.5 State: Installed / not activated Install Method: Marketplace camerainput Name: Camera Input Version: 2.1.0 State: Installed / not activated Install Method: Marketplace connections Name: Connections Version: 10.0.0 State: Installed / not activated Install Method: Marketplace costs Name: Costs Version: 3.0.1 State: Installed / not activated Install Method: Marketplace credit Name: Credit vouchers Version: 1.12.0 State: Installed / not activated Install Method: Marketplace archidata Name: Data structures Version: 1.0.14 State: Installed / not activated Install Method: Marketplace archimap Name: Diagrams Version: 3.3.0 State: Installed / not activated Install Method: Marketplace manageentities Name: Entities portal Version: 4.0.3 State: Installed / not activated Install Method: Marketplace formcreator Name: Form Creator Version: 2.13.6 State: Installed / not activated Install Method: Marketplace gantt Name: gantt Version: 1.0.4 State: Installed / not activated Install Method: Marketplace glpiinventory Name: GLPI Inventory Version: 1.2.1 State: Not installed Install Method: Marketplace geninventorynumber Name: Inventory number generation Version: 2.8.3 State: Not installed Install Method: Marketplace addressing Name: IP Adressing Version: 3.0.1 State: Installed / not activated Install Method: Marketplace uninstall Name: Item's Lifecycle (uninstall) Version: 2.9.0 State: Installed / not activated Install Method: Marketplace metademands Name: Meta-Demands Version: 3.3.2 State: Installed / not activated Install Method: Marketplace purchaserequest Name: Purchase request Version: 3.0.1 State: Not installed Install Method: Marketplace releases Name: Releases Version: 2.0.3 State: Installed / not activated Install Method: Marketplace stab Name: Split Timeline Action Buttons Version: 1.1.2 State: Installed / not activated Install Method: Marketplace statecheck Name: Statecheck Rules Version: 2.3.9 State: Installed / not activated Install Method: Marketplace taskdrop Name: TaskDrop Version: 2.0.0 State: Installed / not activated Install Method: Marketplace telegrambot Name: TelegramBot Version: 3.0 State: Enabled Install Method: Manual useditemsexport Name: Used items export Version: 2.5.1 State: Installed / not activated Install Method: Marketplace vip Name: VIP Version: 1.8.2 State: Not installed Install Method: Marketplace webresources Name: Web Resources Version: 2.0.3 State: Installed / not activated Install Method: Marketplace webhook Name: Webhooks Version: 1.0.14 State: Installed / not activated Install Method: Marketplace accounts Name: Аккаунты Version: 3.0.3 State: Installed / not activated Install Method: Marketplace satisfaction Name: Больше вопросов для оценки удо Version: 1.6.2 State: Not installed Install Method: Marketplace webapplications Name: Веб-приложений Version: 4.0.1 State: Installed / not activated Install Method: Marketplace itilcategorygroups Name: Группы ITIL Категории Version: 2.5.1 State: Not installed Install Method: Marketplace fields Name: Дополнительные поля Version: 1.21.0 State: Installed / not activated Install Method: Marketplace additionalalerts Name: Другие уведомления Version: 2.4.0 State: Installed / not activated Install Method: Marketplace moreticket Name: Еще заявка Version: 1.7.3 State: Installed / not activated Install Method: Marketplace consumables Name: Заказ расходных материалов Version: 2.0.0 State: Enabled Install Method: Marketplace manufacturersimports Name: Импорт поставщиков Version: 3.0.5 State: Installed / not activated Install Method: Marketplace positions Name: Картография Version: 6.0.2 State: Installed / not activated Install Method: Marketplace news Name: Оповещения Version: 1.12.1 State: Installed / not activated Install Method: Marketplace dashboard Name: Панель отчетов Version: 1.0.3 State: Enabled Install Method: Manual escalade Name: Переназначение Version: 2.9.2 State: Installed / not activated Install Method: Marketplace mreporting Name: Подробные отчеты Version: 1.8.2 State: Installed / not activated Install Method: Marketplace screenshot Name: Сделать и приложить снимок экр Version: 2.0.2 State: Enabled Install Method: Marketplace shellcommands Name: Служебные команды Version: 4.0.1 State: Installed / not activated Install Method: Marketplace financialreports Name: Состояния оборудования Version: 3.0.0 State: Installed / not activated Install Method: Marketplace tasklists Name: Список задач Version: 2.0.3 State: Installed / not activated Install Method: Marketplace timelineticket Name: Сроки заявок Version: 10.0+1.1 State: Installed / not activated Install Method: Marketplace order Name: Управление заказами Version: 2.10.4 State: Enabled Install Method: Marketplace genericobject Name: Управление объектами Version: 2.14.4 State: Installed / not activated Install Method: Marketplace resources Name: Человеческие Ресурсы Version: 3.0.4 State: Installed / not activated Install Method: Marketplace