search

glpi-project / glpi

GLPI is a Free Asset and IT Management Software package, Data center management, ITIL Service Desk, licenses tracking and software auditing.
https://glpi-project.org
GNU General Public License v3.0
3.97k stars 1.25k forks source link

Incorrect integer value: '' for column `glpi`.`glpi_documents`.`is_recursive` at row 1 #17379

Open Cornitus opened 3 days ago

Cornitus commented 3 days ago

Code of Conduct

Is there an existing issue for this?

Version

10.0.15

Bug description

When I want to upload a document I get this error message in /var/www/glpi/files/_log/sql-errors.log:

Error: Incorrect integer value: '' for column glpi.glpi_documents.is_recursive at row 1

The part "is_recursive" does not contain a value. Neither 1 nor 0.

Backtrace : src/DBmysql.php:1380 DBmysql->doQuery() src/CommonDBTM.php:729 DBmysql->insert() src/CommonDBTM.php:1342 CommonDBTM->addToDB() front/document.form.php:58 CommonDBTM->add() public/index.php:82 require()

Relevant log output

*** MySQL query error:
  SQL: INSERT INTO `glpi_documents` (`documentcategories_id`, `entities_id`, `is_recursive`, `users_id`, `name`, `mime`, `filename`, `filepath`, `sha1sum`, `tag`, `date_creation`, `date_mod`) VALUES ('6', '0', '', '7', 'Dokument: TEST', 'text/xml', 'TEST.xml', 'XML/19/0eda921758e09f3ca50b4fde34ebaed20e8d9c.XML', '190eda921758e09f3ca50b4fde34ebaed20e8d9c', '00eeedfc-b2d8e96f-667d639d5bf511.02695448', '2024-06-27 15:05:36', '2024-06-27 15:05:36')
  Error: Incorrect integer value: '' for column `glpi`.`glpi_documents`.`is_recursive` at row 1
  Backtrace :
  src/DBmysql.php:1380                               DBmysql->doQuery()
  src/CommonDBTM.php:729                             DBmysql->insert()
  src/CommonDBTM.php:1342                            CommonDBTM->addToDB()
  front/document.form.php:58                         CommonDBTM->add()
  public/index.php:82                                require()
  {"user":"7@glpi"}

Page URL

https://glpi.domain.test/front/softwarelicense.form.php?id=17

Steps To reproduce

No response

Your GLPI setup information

No response

Anything else?

No response