cconard96
commented
2 months ago I cannot recreate the issue. Please provide the full error message from your GLPI logs and the exact search criteria being used.
Closed SilvaFernando closed 1 month ago
cconard96
commented
2 months ago I cannot recreate the issue. Please provide the full error message from your GLPI logs and the exact search criteria being used.
SilvaFernando
commented
2 months ago Folow the filter:
And URL: /front/report.dynamic.php?item_type=Plugin&sort%5B0%5D=1&order%5B0%5D=ASC&start=0&criteria%5B0%5D%5Bfield%5D=view&criteria%5B0%5D%5Blink%5D=contains&criteria%5B0%5D%5Bvalue%5D=&display_type=2
In SQL-ERRORS:
[2024-07-23 16:35:18] glpisqllog.WARNING: DBmysql::doQuery() in /usr/share/glpi/src/DBmysql.php line 443
* MySQL query warnings:
SQL: SELECT glpi_tickets., '' AS transname, '' AS transcomment FROM glpi_tickets WHERE glpi_tickets.id = 'notold'
Warnings:
1292: Truncated incorrect DOUBLE value: 'notold'
Backtrace :
src/DBmysqlIterator.php:112 DBmysql->doQuery()
src/DBmysql.php:1109 DBmysqlIterator->execute()
src/Dropdown.php:552 DBmysql->request()
src/Search.php:2116 Dropdown::getDropdownName()
src/Search.php:2028 Search::computeTitle()
src/Search.php:208 Search::outputData()
front/report.dynamic.php:136 Search::showList()
public/index.php:82 require()
{"user":"8401@SESSRVPRAPP98"}
[2024-07-23 16:41:04] glpisqllog.WARNING: DBmysql::doQuery() in /usr/share/glpi/src/DBmysql.php line 443
MySQL query warnings:
SQL: SELECT glpi_tickets.*, '' AS transname, '' AS transcomment FROM glpi_tickets WHERE glpi_tickets.id = 'notold'
Warnings:
1292: Truncated incorrect DOUBLE value: 'notold'
Backtrace :
src/DBmysqlIterator.php:112 DBmysql->doQuery()
src/DBmysql.php:1109 DBmysqlIterator->execute()
src/Dropdown.php:552 DBmysql->request()
src/Search.php:2116 Dropdown::getDropdownName()
src/Search.php:2028 Search::computeTitle()
src/Search.php:208 Search::outputData()
front/report.dynamic.php:136 Search::showList()
public/index.php:82 require()
{"user":"7408@SESSRVPRAPP98"}
[2024-07-23 16:41:20] glpisqllog.WARNING: DBmysql::doQuery() in /usr/share/glpi/src/DBmysql.php line 443
** MySQL query warnings:
SQL: SELECT glpi_tickets., '' AS transname, '' AS transcomment FROM glpi_tickets WHERE glpi_tickets.id = 'notold'
Warnings:
1292: Truncated incorrect DOUBLE value: 'notold'
Backtrace :
src/DBmysqlIterator.php:112 DBmysql->doQuery()
src/DBmysql.php:1109 DBmysqlIterator->execute()
src/Dropdown.php:552 DBmysql->request()
src/Search.php:2116 Dropdown::getDropdownName()
src/Search.php:2028 Search::computeTitle()
src/Search.php:208 Search::outputData()
front/report.dynamic.php:136 Search::showList()
public/index.php:82 require()
{"user":"7408@SESSRVPRAPP98"}
PHP-errors: [2024-07-23 20:35:01] glpiphplog.WARNING: *** PHP Warning (2): session_save_path(): Session save path cannot be changed after headers have already been sent in /usr/share/glpi/src/Session.php at line 217 Backtrace : src/Session.php:217 session_save_path() src/Console/Application.php:389 Session::setPath() src/Console/Application.php:116 Glpi\Console\Application->initSession() bin/console:121 Glpi\Console\Application->__construct()
[2024-07-23 20:35:01] glpiphplog.WARNING: *** PHP Warning (2): ini_set(): Session ini settings cannot be changed after headers have already been sent in /usr/share/glpi/src/Session.php at line 230 Backtrace : src/Session.php:230 ini_set() src/Console/Application.php:390 Session::start() src/Console/Application.php:116 Glpi\Console\Application->initSession() bin/console:121 Glpi\Console\Application->__construct()
[2024-07-23 20:35:01] glpiphplog.WARNING: *** PHP Warning (2): session_name(): Session name cannot be changed after headers have already been sent in /usr/share/glpi/src/Session.php at line 231 Backtrace : src/Session.php:231 session_name() src/Console/Application.php:390 Session::start() src/Console/Application.php:116 Glpi\Console\Application->initSession() bin/console:121 Glpi\Console\Application->__construct()
[2024-07-23 20:35:01] glpiphplog.WARNING: Test logger
cconard96
commented
2 months ago Please test again without plugins enabled.
Also, the URL for the export you provided doesn't match your search. Decoded: item_type=Plugin&sort[0]=1&order[0]=ASC&start=0&criteria[0][field]=view&criteria[0][link]=contains&criteria[0][value]=&display_type=2
This seems like an export of Plugin results with the default Items Seen criteria.
trasher
commented
1 month ago No feedback, closing
Code of Conduct
Is there an existing issue for this?
Version
10.0.16
Bug description
HI team, when i try export a ticket page as PDF:
And i Have this error:
Relevant log output
No response
Page URL
/front/ticket.php
Steps To reproduce
Export a PDF on a ticket page
Your GLPI setup information
Instruções de instalação e configuração
Server
Operating system: Linux SESSRVPRAPP98 5.15.0-113-generic #123-Ubuntu SMP Mon Jun 10 08:16:17 UTC 2024 x86_64 PHP 8.2.21 apache2handler (Core, FFI, PDO, Phar, Reflection, SPL, SimpleXML, Zend OPcache, apache2handler, apcu, bz2, calendar, ctype, curl, date, dom, exif, fileinfo, filter, ftp, gd, gettext, hash, iconv, imap, intl, json, ldap, libxml, mbstring, mysqli, mysqlnd, openssl, pcre, pdo_mysql, posix, random, readline, session, shmop, snmp, soap, sockets, sodium, standard, sysvmsg, sysvsem, sysvshm, tokenizer, xml, xmlreader, xmlrpc, xmlwriter, xsl, zip, zlib) Setup: max_execution_time="120" memory_limit="128M" post_max_size="20M" safe_mode="" session.save_handler="files" upload_max_filesize="20M" disable_functions="" Software: Apache/2.4.52 (Ubuntu) (Apache/2.4.52 (Ubuntu) Server at 10.243.38.55 Port 80 ) Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/126.0.0.0 Safari/537.36 Edg/126.0.0.0 Server Software: Percona Server (GPL), Release '28', Revision '47601f19'$ Server Version: 8.0.36-28 Server SQL Mode: STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION Parameters: glpi@localhost/glpi Host info: Localhost via UNIX socket PHP version (8.2.21) 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 (8.0.36) is supported. No files from previous GLPI version detected. The log file has been created successfully. Write access to /dados/glpi/files/_cache has been validated. Write access to /dados/glpi/files/_cron has been validated. Write access to /dados/glpi/files/documents has been validated. Write access to /dados/glpi/files/_dumps has been validated. Write access to /dados/glpi/files/_graphs has been validated. Write access to /dados/glpi/files/_lock has been validated. Write access to /dados/glpi/files/_pictures has been validated. Write access to /dados/glpi/files/_plugins has been validated. Write access to /dados/glpi/files/_rss has been validated. Write access to /var/lib/glpi/files/_sessions has been validated. Write access to /dados/glpi/files/_tmp has been validated. Write access to /dados/glpi/files/_uploads has been validated. 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 /usr/share/glpi/marketplace has been validated. Timezones seems loaded in database.GLPI constants
Libraries
LDAP directories
SQL replicas
Notifications
Plugins list
fields Name: Campos adicionais Version: 1.21.9 State: Enabled Install Method: Manual behaviors Name: Comportamentos Version: 2.7.3 State: Enabled Install Method: Manual fusioninventory Name: FusionInventory Version: 10.0.6+1.1 State: Enabled Install Method: Manual datainjection Name: Importação de dados Version: 2.13.5 State: Enabled Install Method: Manual pdf Name: Imprimir em PDF Version: 3.0.0 State: Not installed Install Method: Manual moreticket Name: Mais Chamados Version: 1.7.4 State: Enabled Install Method: Manual mreporting Name: Mais Relatórios Version: 1.8.6 State: Enabled Install Method: Manual satisfaction Name: Mais satisfação Version: 1.6.2 State: Enabled Install Method: Manual trademark Name: Trademark Version: 1.4.1 State: Enabled Install Method: ManualAnything else?
No response