Hello i have this pb:
[FATAL] Erreur d'exportationAOS_Invoices:
Have an idea
Thanks
Quentin
Hi. You are not giving us the full error message. The parts that might provide some clues are not shown…
Thu May 4 17:41:32 2023 [2240][79790303-4877-812e-309f-5c6ecc8423a2][FATAL] Erreur d'exportationAOS_Invoices:
. SELECT aos_invoices.* ,aos_invoices_cstm.pdg_c,aos_invoices_cstm.tcv_c,aos_invoices_cstm.frais_c,aos_invoices_cstm.com_c,aos_invoices_cstm.cot_annuel_c,aos_invoices_cstm.aos_products_id_c,aos_invoices_cstm.account_id_c,aos_invoices_cstm.piece_manquante_c,aos_invoices_cstm.comptant_c,aos_invoices_cstm.vehicule_c,aos_invoices_cstm.bonus_c,aos_invoices_cstm.formule_choisie_c,aos_invoices_cstm.mrh_c,aos_invoices_cstm.capital_mobilier_c,aos_invoices_cstm.option_choisie_c,aos_invoices_cstm.afn_c,aos_invoices_cstm.ct_cie_adv_c,aos_invoices_cstm.sign_elec_c,aos_invoices_cstm.part_ou_autre_be_c,aos_invoices_cstm.n_contrat_souscrit_c,aos_invoices_cstm.en_cours_c,aos_invoices_cstm.document_id_c,aos_invoices_cstm.contrat_cp_c,aos_invoices_cstm.fichier_contrat_c,aos_invoices_cstm.cp_contrat_c,aos_invoices_cstm.cp_cont_c,aos_invoices_cstm.ad_champ_c,aos_invoices_cstm.tag_c,aos_invoices_cstm.com_apporteur_c,aos_invoices_cstm.contrat_c,aos_invoices_cstm.aos_product_categories_id_c,aos_invoices_cstm.com_apporteur_mensuel_c,aos_invoices_cstm.lead_id_c,aos_invoices_cstm.justif_besoins_exigence_c,aos_invoices_cstm.contrat_pdf_c,aos_invoices_cstm.observation_c,aos_invoices_cstm.rachat_de_franchise_c,aos_invoices_cstm.att_lux_c,aos_invoices_cstm.dde_avt_c,aos_invoices_cstm.account_id1_c,aos_invoices_cstm.num_contrat_si_avt_c,aos_invoices_cstm.piece_parent_c,aos_invoices_cstm.cgipi_ref_cg_ipid_id_c,aos_invoices_cstm.cont_pdf_c , jt0.user_name modified_by_name , jt0.created_by modified_by_name_owner , ‘Users’ modified_by_name_mod , jt1.user_name created_by_name , jt1.created_by created_by_name_owner , ‘Users’ created_by_name_mod , jt2.user_name assigned_user_name , jt2.created_by assigned_user_name_owner , ‘Users’ assigned_user_name_mod, jt3.name billing_account , LTRIM(RTRIM(CONCAT(IFNULL(jt4.first_name,‘’),’ ‘,IFNULL(jt4.last_name,’‘)))) billing_contact , jt5.name type_de_contrat_c , jt6.name compagnieadv_c , jt7.document_name cp_c , jt8.name branche_c , LTRIM(RTRIM(CONCAT(IFNULL(jt9.first_name,’‘),’ ‘,IFNULL(jt9.last_name,’')))) prospect_c , jt10.name compagnie_avt_c , jt11.name cg_c FROM aos_invoices LEFT JOIN aos_invoices_cstm ON aos_invoices.id = aos_invoices_cstm.id_c LEFT JOIN users jt0 ON aos_invoices.modified_user_id=jt0.id AND jt0.deleted=0
AND jt0.deleted=0 LEFT JOIN users jt1 ON aos_invoices.created_by=jt1.id AND jt1.deleted=0
AND jt1.deleted=0 LEFT JOIN users jt2 ON aos_invoices.assigned_user_id=jt2.id AND jt2.deleted=0
AND jt2.deleted=0 LEFT JOIN accounts jt3 ON aos_invoices.billing_account_id = jt3.id AND jt3.deleted=0 LEFT JOIN contacts jt4 ON aos_invoices.billing_contact_id = jt4.id AND jt4.deleted=0 LEFT JOIN aos_products jt5 ON aos_invoices_cstm.aos_products_id_c = jt5.id AND jt5.deleted=0 LEFT JOIN accounts jt6 ON aos_invoices_cstm.account_id_c = jt6.id AND jt6.deleted=0 LEFT JOIN documents jt7 ON aos_invoices_cstm.document_id_c = jt7.id AND jt7.deleted=0 LEFT JOIN aos_product_categories jt8 ON aos_invoices_cstm.aos_product_categories_id_c = jt8.id AND jt8.deleted=0 LEFT JOIN leads jt9 ON aos_invoices_cstm.lead_id_c = jt9.id AND jt9.deleted=0 LEFT JOIN accounts jt10 ON aos_invoices_cstm.account_id1_c = jt10.id AND jt10.deleted=0 LEFT JOIN cgipi_ref_cg_ipid jt11 ON aos_invoices_cstm. = jt11.id AND jt11.deleted=0 where (aos_invoices.id in (‘ae7aaa08-c2e3-b84e-2336-5c6ebc41ce2a’,‘1f3104fe-af1b-b3e1-4731-5c6ebf0f58b2’,‘2b935843-4627-7da8-8871-5c6ebf4db54c’,‘3ee6ff7d-4544-7485-293c-5c6ebff103c4’,‘36d54f28-639a-6e58-1703-5c6ebf9e8eac’,‘4718aaf7-33dd-5108-5835-5c6ebf560c84’,‘4ca5dd93-94f7-2cca-2d65-5c6ebf268e34’,‘65cccac9-56e7-2b3d-6789-5c6ebf98af39’,‘6c796571-096c-141d-ab03-5c6ebf2d55e7’,‘72909709-4491-561b-3320-5c6ebfe30940’,‘78689693-804e-25ea-80bc-5c6ebf2e66e8’,‘7e513110-6b04-97bc-3a30-5c6ebfe10417’,‘85b750c6-be20-dd4b-9986-5c6ebf3cb66e’,‘938ed39c-a897-419f-ac14-5c6ebfb1a8be’,‘9d7a0ad8-54cc-fb6f-bbf0-5c6ebfe455ac’,‘8cdc0bd8-1fdd-e855-dd76-5c6ebf98b7bd’,‘9af658fc-1526-61ed-42a1-5c6ebfc32a21’,‘a218ff7f-864e-dd5e-6144-5c6ebf64e582’,‘bc2420a3-7920-4cc4-b162-5c6ebf0a5e33’,‘d0a12ae9-d468-3ff4-e0b8-5c6ebf50df0b’,‘db43d73d-9672-312e-541e-5c6ebfba0052’,‘e849440a-16e9-8339-f450-5c6ebf752f26’,‘ef1c2a23-2606-298d-127f-5c6ebf39fd98’,‘e9513697-8ecc-e0d0-9fe0-5c6ec71329ca’,‘f0ccc9e4-cbf3-b41d-603f-5c6ec7cccdd8’,‘1dc44f77-2a8c-bc7d-eff2-5c6ed71c4ab1’,‘8361523c-7ba8-b7ea-2cc9-5c6fc77d3f44’,‘820ce762-d062-1193-14ee-5c6fd66bf946’,‘683b7385-1bef-5765-3e9f-5c6fe9b7557c’,‘b5e86c6a-b952-d11b-3e86-5c711a510447’,‘ccc32e11-0f52-7711-481f-5c711ac15268’,‘f599088d-72a8-1545-fd83-5c7251b9c0b4’,‘79f33d21-92ce-511c-09de-5c73b157390c’,‘6addc184-0ff5-6897-4fba-5c73bd4cac4b’,‘3d1ddbb2-070d-bfc5-4922-5c754af6ea3c’,‘31d1e7ca-f492-125f-4b5c-5c754acec434’,‘412363a0-012b-2070-4fa4-5c75768e6701’,‘75637ff1-f310-5e28-5fb4-5c765ebc7739’,‘c1427150-e5c9-21f0-a461-5c76612b90e3’,‘e6e957d3-9ca3-2626-acf3-5c766381b231’,‘26f845cc-b972-f9e2-b9a6-5c77b14b3826’,‘14ed82e7-4462-74d9-757c-5c77b2d60d67’,‘dedbb651-eb4a-1f36-1a65-5c78092d7dbb’,‘14d26346-9a6f-641b-eef9-5c780a315726’,‘b6fe779c-0cd1-55ad-42aa-5c780f5f0df5’,‘4cb94f7d-d276-9e46-dbd6-5c78124593ce’,‘4322a5f9-6a49-e825-133c-5c78140dfd92’,‘49b3365f-afc2-d962-5a3b-5c781712a301’,‘9cb2fc50-39e4-28c0-a2f8-5c793d954ba7’,‘38c8699e-0de9-2a98-98cc-5c793f4573f8’,‘40fe114a-2c53-d2d6-be1d-5c7947759275’,‘e939b297-bd51-4b29-32a0-5c798a724135’,‘e54c499f-3b72-cba2-7322-5c798d428bfc’,‘57d17b42-080e-8b8b-4435-5c79922df5cd’,‘91c91a61-a083-3d4f-fb61-5c79931a0e2c’,‘4f5d0243-468e-c18f-bd54-5c7d5a6cae3f’,‘8dfa41a2-b3ea-7e4a-9a5f-5c7e97d913ab’,‘e5403738-8d15-4f9a-650a-5c7fca3f78fe’,‘eefa474c-01df-7dfb-7cf9-5c7fcef88ab8’,‘7c0d07fb-e988-d551-200b-5c812fdc5013’,‘8bf41c62-d7d1-d690-753e-5c812f94b9ea’,‘30de0092-240a-5a58-9c18-5c82200fe1a7’,‘8abc4ff5-13b5-210d-6ccb-5c8225b2406d’,‘90a56104-45a5-862a-fef9-5c829dfc06c5’,‘667a9a08-d5bc-4ba7-1a76-5c861ed1898d’,‘a6091a7d-ecf3-28c1-19f9-5c862134feac’,‘7a62b524-c588-aba6-93ed-5c8635548718’,‘27b7b918-38ee-fb97-4b7b-5c863e516d01’,‘9e7386b2-189e-ee0d-6c3d-5c863e71e61b’,‘b5e5eead-8ffe-661f-f399-5c86627f95ff’,‘14ddd1e5-60f4-102e-5642-5c8664d4cb7b’,‘7bad78ee-78de-89f4-18b8-5c86756d14f4’,‘e217ea31-0ab3-400c-83d0-5c8687ce057a’,‘7697c8e7-66e2-4f78-ed84-5c868dfb8e74’,‘54bb8bd2-ed09-b552-766c-5c869f196090’,‘a3163cd7-dfd1-038a-d031-5c86a145cfc6’,‘43ef33bf-abea-e9b1-9987-5c87baadbb75’,‘8d5b5df6-a5f1-e560-a98a-5c87dca35f45’,‘e4ffcf8f-ea05-6b55-af86-5c88ff02ad4a’,‘338c79af-d229-74e6-b14e-5c89323ecab2’,‘c708be88-7764-b2f1-b6c2-5c8940ddbe18’,‘68cd924d-553c-d153-6174-5c89ee729149’,‘36be4868-2a50-1546-1755-5c8b7f6fb54e’,‘afb70d91-9d0b-4a0a-e93f-5c8b7f019ba0’,‘229d6929-4b56-da11-1653-5c8baf679300’,‘161b040f-a2d3-5e14-2d77-5c8be7b2e16a’,‘98483e0f-39ad-91d8-864a-5c8bf2d1d0f5’,‘6d674db8-c813-7832-79ac-5c8cc4bb3911’,‘106b4e38-b5f4-1660-d578-5c8e68da62fe’,‘1002c9e3-6b1a-4bcc-491f-5c8e689a3b5b’,‘116aef16-cb82-4a90-071d-5c8e688914a2’,‘127b09cd-70ca-75e7-85e6-5c8e68325f44’,‘132ab00a-3725-c4bc-9b32-5c8e68ff4b3f’,‘135f0c72-7a4d-69d8-c080-5c8e6846a57a’,‘136fc0e2-3f69-2362-0506-5c8e687351a2’,‘1561cc1c-d3ff-103d-794b-5c8e68ee5079’,‘1596eeab-f08c-7178-a969-5c8e680a2676’,‘15e6b1ac-0c0b-7d8b-c756-5c8e68584d5f’,‘18210947-55ad-4eb0-90f6-5c8e68abceac’,‘18a8ca69-68ae-7e12-7ae6-5c8e68c0e01c’,‘18cb32a3-344f-2b99-023b-5c8e685b0aae’,‘1a17db7c-8925-1fd8-7f36-5c8e68deb38e’,‘1ab507f1-d65c-d9b5-b38c-5c8e683744de’,‘1c2a0635-ddae-44d5-2766-5c8e6848ce22’,‘1c4d4c72-2e68-eab7-51b9-5c8e68e4d9d8’,‘1dd6fbe1-a353-edd5-7398-5c8e685ef540’,‘1eb5290d-8c3f-7070-77dc-5c8e6847b6c4’,‘1f3c774d-5741-c4cc-999a-5c8e687d07f9’,‘20b2c3b3-a0e2-530c-703f-5c8e684cccce’,‘20f246c7-2227-eae8-e14c-5c8e681c0c5d’,‘2178f4b9-4baa-f7c9-ade2-5c8e68a8b582’,‘10d9133d-9b76-4cc8-fe05-5c8e68cab17d’,‘1187b062-027e-a9a0-d580-5c8e68d4ab78’,‘13f07ec5-66c9-8016-2fd6-5c8e685d93a9’,‘143dab7c-41a3-8b15-bfd6-5c8e682f599d’,‘1490f5d0-440f-dbf3-4dcb-5c8e6873520a’,‘15cf4b7c-989f-3f42-223b-5c8e68dd3be0’,‘17eda46d-69da-57f6-8f28-5c8e68350432’,‘19cfc930-1d9f-8367-6a8d-5c8e681b0776’,‘20570047-5639-1a80-cfa3-5c8e680767bf’,‘2070d61c-592f-1059-93d1-5c8e6852ad94’,‘21d00ad6-c6be-6903-ebf2-5c8e68df81c7’,‘221faf35-ff4b-5a6b-a621-5c8e6849c499’,‘189f3e93-3c9b-a78e-f77e-5c8e6893b930’,‘1b753acc-e2c1-8b9f-b7ae-5c8e683fbf18’)) AND aos_invoices.deleted=0 Query Failed: SELECT aos_invoices.* ,aos_invoices_cstm.pdg_c,aos_invoices_cstm.tcv_c,aos_invoices_cstm.frais_c,aos_invoices_cstm.com_c,aos_invoices_cstm.cot_annuel_c,aos_invoices_cstm.aos_products_id_c,aos_invoices_cstm.account_id_c,aos_invoices_cstm.piece_manquante_c,aos_invoices_cstm.comptant_c,aos_invoices_cstm.vehicule_c,aos_invoices_cstm.bonus_c,aos_invoices_cstm.formule_choisie_c,aos_invoices_cstm.mrh_c,aos_invoices_cstm.capital_mobilier_c,aos_invoices_cstm.option_choisie_c,aos_invoices_cstm.afn_c,aos_invoices_cstm.ct_cie_adv_c,aos_invoices_cstm.sign_elec_c,aos_invoices_cstm.part_ou_autre_be_c,aos_invoices_cstm.n_contrat_souscrit_c,aos_invoices_cstm.en_cours_c,aos_invoices_cstm.document_id_c,aos_invoices_cstm.contrat_cp_c,aos_invoices_cstm.fichier_contrat_c,aos_invoices_cstm.cp_contrat_c,aos_invoices_cstm.cp_cont_c,aos_invoices_cstm.ad_champ_c,aos_invoices_cstm.tag_c,aos_invoices_cstm.com_apporteur_c,aos_invoices_cstm.contrat_c,aos_invoices_cstm.aos_product_categories_id_c,aos_invoices_cstm.com_apporteur_mensuel_c,aos_invoices_cstm.lead_id_c,aos_invoices_cstm.justif_besoins_exigence_c,aos_invoices_cstm.contrat_pdf_c,aos_invoices_cstm.observation_c,aos_invoices_cstm.rachat_de_franchise_c,aos_invoices_cstm.att_lux_c,aos_invoices_cstm.dde_avt_c,aos_invoices_cstm.account_id1_c,aos_invoices_cstm.num_contrat_si_avt_c,aos_invoices_cstm.piece_parent_c,aos_invoices_cstm.cgipi_ref_cg_ipid_id_c,aos_invoices_cstm.cont_pdf_c , jt0.user_name modified_by_name , jt0.created_by modified_by_name_owner , ‘Users’ modified_by_name_mod , jt1.user_name created_by_name , jt1.created_by created_by_name_owner , ‘Users’ created_by_name_mod , jt2.user_name assigned_user_name , jt2.created_by assigned_user_name_owner , ‘Users’ assigned_user_name_mod, jt3.name billing_account , LTRIM(RTRIM(CONCAT(IFNULL(jt4.first_name,‘’),’ ‘,IFNULL(jt4.last_name,’‘)))) billing_contact , jt5.name type_de_contrat_c , jt6.name compagnieadv_c , jt7.document_name cp_c , jt8.name branche_c , LTRIM(RTRIM(CONCAT(IFNULL(jt9.first_name,’‘),’ ‘,IFNULL(jt9.last_name,’')))) prospect_c , jt10.name compagnie_avt_c , jt11.name cg_c FROM aos_invoices LEFT JOIN aos_invoices_cstm ON aos_invoices.id = aos_invoices_cstm.id_c LEFT JOIN users jt0 ON aos_invoices.modified_user_id=jt0.id AND jt0.deleted=0
AND jt0.deleted=0 LEFT JOIN users jt1 ON aos_invoices.created_by=jt1.id AND jt1.deleted=0
AND jt1.deleted=0 LEFT JOIN users jt2 ON aos_invoices.assigned_user_id=jt2.id AND jt2.deleted=0
AND jt2.deleted=0 LEFT JOIN accounts jt3 ON aos_invoices.billing_account_id = jt3.id AND jt3.deleted=0 LEFT JOIN contacts jt4 ON aos_invoices.billing_contact_id = jt4.id AND jt4.deleted=0 LEFT JOIN aos_products jt5 ON aos_invoices_cstm.aos_products_id_c = jt5.id AND jt5.deleted=0 LEFT JOIN accounts jt6 ON aos_invoices_cstm.account_id_c = jt6.id AND jt6.deleted=0 LEFT JOIN documents jt7 ON aos_invoices_cstm.document_id_c = jt7.id AND jt7.deleted=0 LEFT JOIN aos_product_categories jt8 ON aos_invoices_cstm.aos_product_categories_id_c = jt8.id AND jt8.deleted=0 LEFT JOIN leads jt9 ON aos_invoices_cstm.lead_id_c = jt9.id AND jt9.deleted=0 LEFT JOIN accounts jt10 ON aos_invoices_cstm.account_id1_c = jt10.id AND jt10.deleted=0 LEFT JOIN cgipi_ref_cg_ipid jt11 ON aos_invoices_cstm. = jt11.id AND jt11.deleted=0 where (aos_invoices.id in (‘ae7aaa08-c2e3-b84e-2336-5c6ebc41ce2a’,‘1f3104fe-af1b-b3e1-4731-5c6ebf0f58b2’,‘2b935843-4627-7da8-8871-5c6ebf4db54c’,‘3ee6ff7d-4544-7485-293c-5c6ebff103c4’,‘36d54f28-639a-6e58-1703-5c6ebf9e8eac’,‘4718aaf7-33dd-5108-5835-5c6ebf560c84’,‘4ca5dd93-94f7-2cca-2d65-5c6ebf268e34’,‘65cccac9-56e7-2b3d-6789-5c6ebf98af39’,‘6c796571-096c-141d-ab03-5c6ebf2d55e7’,‘72909709-4491-561b-3320-5c6ebfe30940’,‘78689693-804e-25ea-80bc-5c6ebf2e66e8’,‘7e513110-6b04-97bc-3a30-5c6ebfe10417’,‘85b750c6-be20-dd4b-9986-5c6ebf3cb66e’,‘938ed39c-a897-419f-ac14-5c6ebfb1a8be’,‘9d7a0ad8-54cc-fb6f-bbf0-5c6ebfe455ac’,‘8cdc0bd8-1fdd-e855-dd76-5c6ebf98b7bd’,‘9af658fc-1526-61ed-42a1-5c6ebfc32a21’,‘a218ff7f-864e-dd5e-6144-5c6ebf64e582’,‘bc2420a3-7920-4cc4-b162-5c6ebf0a5e33’,‘d0a12ae9-d468-3ff4-e0b8-5c6ebf50df0b’,‘db43d73d-9672-312e-541e-5c6ebfba0052’,‘e849440a-16e9-8339-f450-5c6ebf752f26’,‘ef1c2a23-2606-298d-127f-5c6ebf39fd98’,‘e9513697-8ecc-e0d0-9fe0-5c6ec71329ca’,‘f0ccc9e4-cbf3-b41d-603f-5c6ec7cccdd8’,‘1dc44f77-2a8c-bc7d-eff2-5c6ed71c4ab1’,‘8361523c-7ba8-b7ea-2cc9-5c6fc77d3f44’,‘820ce762-d062-1193-14ee-5c6fd66bf946’,‘683b7385-1bef-5765-3e9f-5c6fe9b7557c’,‘b5e86c6a-b952-d11b-3e86-5c711a510447’,‘ccc32e11-0f52-7711-481f-5c711ac15268’,‘f599088d-72a8-1545-fd83-5c7251b9c0b4’,‘79f33d21-92ce-511c-09de-5c73b157390c’,‘6addc184-0ff5-6897-4fba-5c73bd4cac4b’,‘3d1ddbb2-070d-bfc5-4922-5c754af6ea3c’,‘31d1e7ca-f492-125f-4b5c-5c754acec434’,‘412363a0-012b-2070-4fa4-5c75768e6701’,‘75637ff1-f310-5e28-5fb4-5c765ebc7739’,‘c1427150-e5c9-21f0-a461-5c76612b90e3’,‘e6e957d3-9ca3-2626-acf3-5c766381b231’,‘26f845cc-b972-f9e2-b9a6-5c77b14b3826’,‘14ed82e7-4462-74d9-757c-5c77b2d60d67’,‘dedbb651-eb4a-1f36-1a65-5c78092d7dbb’,‘14d26346-9a6f-641b-eef9-5c780a315726’,‘b6fe779c-0cd1-55ad-42aa-5c780f5f0df5’,‘4cb94f7d-d276-9e46-dbd6-5c78124593ce’,‘4322a5f9-6a49-e825-133c-5c78140dfd92’,‘49b3365f-afc2-d962-5a3b-5c781712a301’,‘9cb2fc50-39e4-28c0-a2f8-5c793d954ba7’,‘38c8699e-0de9-2a98-98cc-5c793f4573f8’,‘40fe114a-2c53-d2d6-be1d-5c7947759275’,‘e939b297-bd51-4b29-32a0-5c798a724135’,‘e54c499f-3b72-cba2-7322-5c798d428bfc’,‘57d17b42-080e-8b8b-4435-5c79922df5cd’,‘91c91a61-a083-3d4f-fb61-5c79931a0e2c’,‘4f5d0243-468e-c18f-bd54-5c7d5a6cae3f’,‘8dfa41a2-b3ea-7e4a-9a5f-5c7e97d913ab’,‘e5403738-8d15-4f9a-650a-5c7fca3f78fe’,‘eefa474c-01df-7dfb-7cf9-5c7fcef88ab8’,‘7c0d07fb-e988-d551-200b-5c812fdc5013’,‘8bf41c62-d7d1-d690-753e-5c812f94b9ea’,‘30de0092-240a-5a58-9c18-5c82200fe1a7’,‘8abc4ff5-13b5-210d-6ccb-5c8225b2406d’,‘90a56104-45a5-862a-fef9-5c829dfc06c5’,‘667a9a08-d5bc-4ba7-1a76-5c861ed1898d’,‘a6091a7d-ecf3-28c1-19f9-5c862134feac’,‘7a62b524-c588-aba6-93ed-5c8635548718’,‘27b7b918-38ee-fb97-4b7b-5c863e516d01’,‘9e7386b2-189e-ee0d-6c3d-5c863e71e61b’,‘b5e5eead-8ffe-661f-f399-5c86627f95ff’,‘14ddd1e5-60f4-102e-5642-5c8664d4cb7b’,‘7bad78ee-78de-89f4-18b8-5c86756d14f4’,‘e217ea31-0ab3-400c-83d0-5c8687ce057a’,‘7697c8e7-66e2-4f78-ed84-5c868dfb8e74’,‘54bb8bd2-ed09-b552-766c-5c869f196090’,‘a3163cd7-dfd1-038a-d031-5c86a145cfc6’,‘43ef33bf-abea-e9b1-9987-5c87baadbb75’,‘8d5b5df6-a5f1-e560-a98a-5c87dca35f45’,‘e4ffcf8f-ea05-6b55-af86-5c88ff02ad4a’,‘338c79af-d229-74e6-b14e-5c89323ecab2’,‘c708be88-7764-b2f1-b6c2-5c8940ddbe18’,‘68cd924d-553c-d153-6174-5c89ee729149’,‘36be4868-2a50-1546-1755-5c8b7f6fb54e’,‘afb70d91-9d0b-4a0a-e93f-5c8b7f019ba0’,‘229d6929-4b56-da11-1653-5c8baf679300’,‘161b040f-a2d3-5e14-2d77-5c8be7b2e16a’,‘98483e0f-39ad-91d8-864a-5c8bf2d1d0f5’,‘6d674db8-c813-7832-79ac-5c8cc4bb3911’,‘106b4e38-b5f4-1660-d578-5c8e68da62fe’,‘1002c9e3-6b1a-4bcc-491f-5c8e689a3b5b’,‘116aef16-cb82-4a90-071d-5c8e688914a2’,‘127b09cd-70ca-75e7-85e6-5c8e68325f44’,‘132ab00a-3725-c4bc-9b32-5c8e68ff4b3f’,‘135f0c72-7a4d-69d8-c080-5c8e6846a57a’,‘136fc0e2-3f69-2362-0506-5c8e687351a2’,‘1561cc1c-d3ff-103d-794b-5c8e68ee5079’,‘1596eeab-f08c-7178-a969-5c8e680a2676’,‘15e6b1ac-0c0b-7d8b-c756-5c8e68584d5f’,‘18210947-55ad-4eb0-90f6-5c8e68abceac’,‘18a8ca69-68ae-7e12-7ae6-5c8e68c0e01c’,‘18cb32a3-344f-2b99-023b-5c8e685b0aae’,‘1a17db7c-8925-1fd8-7f36-5c8e68deb38e’,‘1ab507f1-d65c-d9b5-b38c-5c8e683744de’,‘1c2a0635-ddae-44d5-2766-5c8e6848ce22’,‘1c4d4c72-2e68-eab7-51b9-5c8e68e4d9d8’,‘1dd6fbe1-a353-edd5-7398-5c8e685ef540’,‘1eb5290d-8c3f-7070-77dc-5c8e6847b6c4’,‘1f3c774d-5741-c4cc-999a-5c8e687d07f9’,‘20b2c3b3-a0e2-530c-703f-5c8e684cccce’,‘20f246c7-2227-eae8-e14c-5c8e681c0c5d’,‘2178f4b9-4baa-f7c9-ade2-5c8e68a8b582’,‘10d9133d-9b76-4cc8-fe05-5c8e68cab17d’,‘1187b062-027e-a9a0-d580-5c8e68d4ab78’,‘13f07ec5-66c9-8016-2fd6-5c8e685d93a9’,‘143dab7c-41a3-8b15-bfd6-5c8e682f599d’,‘1490f5d0-440f-dbf3-4dcb-5c8e6873520a’,‘15cf4b7c-989f-3f42-223b-5c8e68dd3be0’,‘17eda46d-69da-57f6-8f28-5c8e68350432’,‘19cfc930-1d9f-8367-6a8d-5c8e681b0776’,‘20570047-5639-1a80-cfa3-5c8e680767bf’,‘2070d61c-592f-1059-93d1-5c8e6852ad94’,‘21d00ad6-c6be-6903-ebf2-5c8e68df81c7’,‘221faf35-ff4b-5a6b-a621-5c8e6849c499’,‘189f3e93-3c9b-a78e-f77e-5c8e6893b930’,‘1b753acc-e2c1-8b9f-b7ae-5c8e683fbf18’)) AND aos_invoices.deleted=0: MySQL error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘= jt11.id AND jt11.deleted=0 where (aos_invoices.id in (‘ae7aaa08-c2e3-b84e-…’ at line 7
Thu May 4 17:41:32 2023 [2240][79790303-4877-812e-309f-5c6ecc8423a2][FATAL] Exception handling in /var/www/html/suitecrm/include/MVC/Controller/SugarController.php:397
Thu May 4 17:41:32 2023 [2240][79790303-4877-812e-309f-5c6ecc8423a2][FATAL] Exception in Controller: Défaillance de la base de données. Veuillez consulter suitecrm.log pour plus de détails.
Thu May 4 17:49:56 2023 [2415][79790303-4877-812e-309f-5c6ecc8423a2][FATAL] Mysqli_query failed.
Thu May 4 17:49:56 2023 [2415][79790303-4877-812e-309f-5c6ecc8423a2][FATAL] Erreur d'exportationAOS_Invoices:
. SELECT aos_invoices.* ,aos_invoices_cstm.pdg_c,aos_invoices_cstm.tcv_c,aos_invoices_cstm.frais_c,aos_invoices_cstm.com_c,aos_invoices_cstm.cot_annuel_c,aos_invoices_cstm.aos_products_id_c,aos_invoices_cstm.account_id_c,aos_invoices_cstm.piece_manquante_c,aos_invoices_cstm.comptant_c,aos_invoices_cstm.vehicule_c,aos_invoices_cstm.bonus_c,aos_invoices_cstm.formule_choisie_c,aos_invoices_cstm.mrh_c,aos_invoices_cstm.capital_mobilier_c,aos_invoices_cstm.option_choisie_c,aos_invoices_cstm.afn_c,aos_invoices_cstm.ct_cie_adv_c,aos_invoices_cstm.sign_elec_c,aos_invoices_cstm.part_ou_autre_be_c,aos_invoices_cstm.n_contrat_souscrit_c,aos_invoices_cstm.en_cours_c,aos_invoices_cstm.document_id_c,aos_invoices_cstm.contrat_cp_c,aos_invoices_cstm.fichier_contrat_c,aos_invoices_cstm.cp_contrat_c,aos_invoices_cstm.cp_cont_c,aos_invoices_cstm.ad_champ_c,aos_invoices_cstm.tag_c,aos_invoices_cstm.com_apporteur_c,aos_invoices_cstm.contrat_c,aos_invoices_cstm.aos_product_categories_id_c,aos_invoices_cstm.com_apporteur_mensuel_c,aos_invoices_cstm.lead_id_c,aos_invoices_cstm.justif_besoins_exigence_c,aos_invoices_cstm.contrat_pdf_c,aos_invoices_cstm.observation_c,aos_invoices_cstm.rachat_de_franchise_c,aos_invoices_cstm.att_lux_c,aos_invoices_cstm.dde_avt_c,aos_invoices_cstm.account_id1_c,aos_invoices_cstm.num_contrat_si_avt_c,aos_invoices_cstm.piece_parent_c,aos_invoices_cstm.cgipi_ref_cg_ipid_id_c,aos_invoices_cstm.cont_pdf_c , jt0.user_name modified_by_name , jt0.created_by modified_by_name_owner , ‘Users’ modified_by_name_mod , jt1.user_name created_by_name , jt1.created_by created_by_name_owner , ‘Users’ created_by_name_mod , jt2.user_name assigned_user_name , jt2.created_by assigned_user_name_owner , ‘Users’ assigned_user_name_mod, jt3.name billing_account , LTRIM(RTRIM(CONCAT(IFNULL(jt4.first_name,’‘),’ ‘,IFNULL(jt4.last_name,’‘)))) billing_contact , jt5.name type_de_contrat_c , jt6.name compagnieadv_c , jt7.document_name cp_c , jt8.name branche_c , LTRIM(RTRIM(CONCAT(IFNULL(jt9.first_name,’‘),’ ‘,IFNULL(jt9.last_name,’')))) prospect_c , jt10.name compagnie_avt_c , jt11.name cg_c FROM aos_invoices LEFT JOIN aos_invoices_cstm ON aos_invoices.id = aos_invoices_cstm.id_c LEFT JOIN users jt0 ON aos_invoices.modified_user_id=jt0.id AND jt0.deleted=0
AND jt0.deleted=0 LEFT JOIN users jt1 ON aos_invoices.created_by=jt1.id AND jt1.deleted=0
AND jt1.deleted=0 LEFT JOIN users jt2 ON aos_invoices.assigned_user_id=jt2.id AND jt2.deleted=0
AND jt2.deleted=0 LEFT JOIN accounts jt3 ON aos_invoices.billing_account_id = jt3.id AND jt3.deleted=0 LEFT JOIN contacts jt4 ON aos_invoices.billing_contact_id = jt4.id AND jt4.deleted=0 LEFT JOIN aos_products jt5 ON aos_invoices_cstm.aos_products_id_c = jt5.id AND jt5.deleted=0 LEFT JOIN accounts jt6 ON aos_invoices_cstm.account_id_c = jt6.id AND jt6.deleted=0 LEFT JOIN documents jt7 ON aos_invoices_cstm.document_id_c = jt7.id AND jt7.deleted=0 LEFT JOIN aos_product_categories jt8 ON aos_invoices_cstm.aos_product_categories_id_c = jt8.id AND jt8.deleted=0 LEFT JOIN leads jt9 ON aos_invoices_cstm.lead_id_c = jt9.id AND jt9.deleted=0 LEFT JOIN accounts jt10 ON aos_invoices_cstm.account_id1_c = jt10.id AND jt10.deleted=0 LEFT JOIN cgipi_ref_cg_ipid jt11 ON aos_invoices_cstm. = jt11.id AND jt11.deleted=0 where ((aos_invoices_cstm.en_cours_c like ‘1%’)) AND aos_invoices.deleted=0 Query Failed: SELECT aos_invoices.* ,aos_invoices_cstm.pdg_c,aos_invoices_cstm.tcv_c,aos_invoices_cstm.frais_c,aos_invoices_cstm.com_c,aos_invoices_cstm.cot_annuel_c,aos_invoices_cstm.aos_products_id_c,aos_invoices_cstm.account_id_c,aos_invoices_cstm.piece_manquante_c,aos_invoices_cstm.comptant_c,aos_invoices_cstm.vehicule_c,aos_invoices_cstm.bonus_c,aos_invoices_cstm.formule_choisie_c,aos_invoices_cstm.mrh_c,aos_invoices_cstm.capital_mobilier_c,aos_invoices_cstm.option_choisie_c,aos_invoices_cstm.afn_c,aos_invoices_cstm.ct_cie_adv_c,aos_invoices_cstm.sign_elec_c,aos_invoices_cstm.part_ou_autre_be_c,aos_invoices_cstm.n_contrat_souscrit_c,aos_invoices_cstm.en_cours_c,aos_invoices_cstm.document_id_c,aos_invoices_cstm.contrat_cp_c,aos_invoices_cstm.fichier_contrat_c,aos_invoices_cstm.cp_contrat_c,aos_invoices_cstm.cp_cont_c,aos_invoices_cstm.ad_champ_c,aos_invoices_cstm.tag_c,aos_invoices_cstm.com_apporteur_c,aos_invoices_cstm.contrat_c,aos_invoices_cstm.aos_product_categories_id_c,aos_invoices_cstm.com_apporteur_mensuel_c,aos_invoices_cstm.lead_id_c,aos_invoices_cstm.justif_besoins_exigence_c,aos_invoices_cstm.contrat_pdf_c,aos_invoices_cstm.observation_c,aos_invoices_cstm.rachat_de_franchise_c,aos_invoices_cstm.att_lux_c,aos_invoices_cstm.dde_avt_c,aos_invoices_cstm.account_id1_c,aos_invoices_cstm.num_contrat_si_avt_c,aos_invoices_cstm.piece_parent_c,aos_invoices_cstm.cgipi_ref_cg_ipid_id_c,aos_invoices_cstm.cont_pdf_c , jt0.user_name modified_by_name , jt0.created_by modified_by_name_owner , ‘Users’ modified_by_name_mod , jt1.user_name created_by_name , jt1.created_by created_by_name_owner , ‘Users’ created_by_name_mod , jt2.user_name assigned_user_name , jt2.created_by assigned_user_name_owner , ‘Users’ assigned_user_name_mod, jt3.name billing_account , LTRIM(RTRIM(CONCAT(IFNULL(jt4.first_name,‘’),’ ‘,IFNULL(jt4.last_name,’‘)))) billing_contact , jt5.name type_de_contrat_c , jt6.name compagnieadv_c , jt7.document_name cp_c , jt8.name branche_c , LTRIM(RTRIM(CONCAT(IFNULL(jt9.first_name,’‘),’ ‘,IFNULL(jt9.last_name,’')))) prospect_c , jt10.name compagnie_avt_c , jt11.name cg_c FROM aos_invoices LEFT JOIN aos_invoices_cstm ON aos_invoices.id = aos_invoices_cstm.id_c LEFT JOIN users jt0 ON aos_invoices.modified_user_id=jt0.id AND jt0.deleted=0
AND jt0.deleted=0 LEFT JOIN users jt1 ON aos_invoices.created_by=jt1.id AND jt1.deleted=0
AND jt1.deleted=0 LEFT JOIN users jt2 ON aos_invoices.assigned_user_id=jt2.id AND jt2.deleted=0
AND jt2.deleted=0 LEFT JOIN accounts jt3 ON aos_invoices.billing_account_id = jt3.id AND jt3.deleted=0 LEFT JOIN contacts jt4 ON aos_invoices.billing_contact_id = jt4.id AND jt4.deleted=0 LEFT JOIN aos_products jt5 ON aos_invoices_cstm.aos_products_id_c = jt5.id AND jt5.deleted=0 LEFT JOIN accounts jt6 ON aos_invoices_cstm.account_id_c = jt6.id AND jt6.deleted=0 LEFT JOIN documents jt7 ON aos_invoices_cstm.document_id_c = jt7.id AND jt7.deleted=0 LEFT JOIN aos_product_categories jt8 ON aos_invoices_cstm.aos_product_categories_id_c = jt8.id AND jt8.deleted=0 LEFT JOIN leads jt9 ON aos_invoices_cstm.lead_id_c = jt9.id AND jt9.deleted=0 LEFT JOIN accounts jt10 ON aos_invoices_cstm.account_id1_c = jt10.id AND jt10.deleted=0 LEFT JOIN cgipi_ref_cg_ipid jt11 ON aos_invoices_cstm. = jt11.id AND jt11.deleted=0 where ((aos_invoices_cstm.en_cours_c like ‘1%’)) AND aos_invoices.deleted=0: MySQL error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘= jt11.id AND jt11.deleted=0 where ((aos_invoices_cstm.en_cours_c like ‘1%’)…’ at line 7
Search these forums and (SuiteCRM Github) for
MySQL error 1064: You have an error in your SQL syntax;
and pay attention to version numbers: SuiteCRM version, PHP version, MySQL version
Hello,
I have search but nothing .
I have think it’s a reference not present in MariaDB but present in suitecrm, but no.
I have Q&R but ever nothing i have ever the same error
- Apache/2.4.6 (CentOS) OpenSSL/1.0.2k-fips PHP/7.4.33
- Version du client de base de données : libmysql - mysqlnd 7.4.33
- Extension PHP : mysqli
- Version de PHP : 7.4.33
Suitecrm 7.13.3
This part is mal-formed:
LEFT JOIN cgipi_ref_cg_ipid jt11 ON aos_invoices_cstm. = jt11.id AND jt11.deleted=0
That “_cstm.” is missing a field name.
So there might be something buggy with the code forming the query. But there might also be something wrong with your relationships - try a Repairs / Rebuild relationships
Repairs / Rebuild relationships = Ok
the rest, i don’t know where to find this .
I am sorry, but I don’t know either 