Skip to content

GLPI PDF Plugin #89

Description

@nimek20

I have GLPI version 11.0.7.
I'm having a problem with the PDF plugin.
I'm using the latest version of the PDF plugin, version 4.1.4.

The PDF plugin works correctly when generating items such as computer, operating systems, and components.

The problem occurs when generating software (Item_SoftwareVersion$1) - regardless of the number of software versions.

In debug mode, I get the error:

.MySQL query warnings: SQL: SELECT glpi_softwarelicenses.*, glpi_softwares.name AS softname, glpi_softwareversions.name AS version, glpi_states.name AS state FROM glpi_softwarelicenses LEFT JOIN glpi_items_softwarelicenses ON (glpi_items_softwarelicenses.softwarelicenses_id = glpi_softwarelicenses.id AND glpi_items_softwarelicenses.itemtype = 'Computer') LEFT JOIN glpi_softwareversions ON (glpi_softwarelicenses.softwareversions_id_use = glpi_softwareversions.id OR glpi_softwarelicenses.softwareversions_id_use = '0' AND glpi_softwarelicenses.softwareversions_id_buy = 'glpi_softwareversions.id') LEFT JOIN glpi_states ON (glpi_states.id = glpi_softwareversions.states_id) INNER JOIN glpi_softwares ON (glpi_softwarelicenses.softwares_id = glpi_softwares.id) WHERE glpi_items_softwarelicenses.items_id = '39' AND glpi_softwarelicenses.id NOT IN (163) Warnings: 1292: Truncated incorrect DECIMAL value: 'glpi_softwareversions.id' at DBmysql.php line 444 in ./src/DBmysql.php at line 444

Error: Maximum execution time of 120 seconds exceeded
In ./vendor/tecnickcom/tcpdf/tcpdf.php(4199)
#0 {main}

Please help

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions