#!/usr/bin/env php
***** create_invoice.php (1.7) *****
Dolibarr has detected a technical error.
This information can be useful for diagnostic purposes (you can set option $dolibarr_main_prod to '1' to hide sensitive information):
Date: 20260816235654
Dolibarr: 22.0.2 - https://www.dolibarr.org
Level of features: 0
Login: admin
PHP: 8.3.33
Server: LiteSpeed
OS: Linux sc-europe144.banahosting.com 4.18.0-553.144.1.lve.el8.x86_64 #1 SMP Thu Jul 16 08:31:06 UTC 2026 x86_64
User Agent: Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Requested URL: /dolibarr/dev/examples/code/create_invoice.php
Referer:
Menu manager:
Modules/Applications: user, societe, ticket, agenda, categorie, ecm, projet, recruitment, cron, webportal, workflow, export, fckeditor, knowledgemanagement, eventorganization, import, hrm, holiday, expensereport, geoipmaxmind, emailcollector
Database type manager: mysqli
Latest database access request error: INSERT INTO llx_facture ( ref, entity, ref_ext, type, subtype, fk_soc, datec, datef, date_pointoftax, note_private, note_public, ref_client, fk_account, module_source, pos_source, fk_fac_rec_source, fk_facture_source, fk_user_author, fk_projet, fk_cond_reglement, fk_mode_reglement, date_lim_reglement, model_pdf, fk_input_reason, situation_cycle_ref, situation_counter, situation_final, fk_incoterms, location_incoterms, fk_multicurrency, multicurrency_code, multicurrency_tx, retained_warranty, retained_warranty_date_limit, retained_warranty_fk_cond_reglement) VALUES ('(PROV)', 1, null, '0', null, 4, '2026-08-16 23:56:54', '2026-08-16 23:56:54', null, 'A private comment', 'A public comment', null, NULL, null, null, null, null, 1, null, 1, 0, '2026-08-17 23:56:54', null, null, null, null, 0, 0, '', 0, 'EUR', 1, 0, NULL, 0)
Return code for latest database access request error: DB_ERROR_1452
Information for latest database access request error: Cannot add or update a child row: a foreign key constraint fails (`pvtbaqfh_dolibarr`.`llx_facture`, CONSTRAINT `fk_facture_fk_soc` FOREIGN KEY (`fk_soc`) REFERENCES `llx_societe` (`rowid`))
Message: Cannot add or update a child row: a foreign key constraint fails (`pvtbaqfh_dolibarr`.`llx_facture`, CONSTRAINT `fk_facture_fk_soc` FOREIGN KEY (`fk_soc`) REFERENCES `llx_societe` (`rowid`))
--- end error code=1