Skip to content
Snippets Groups Projects
New look: Off

CiviMail stopped sending email after upgrade to CiviCRM 5.43

    • Closed (moved) Issue created by lishaw1968 @lishaw1968

    CiviMail does not send test email after upgrade to CiviCRM 5.43

    Edited
    To upload designs, you'll need to enable LFS and have an admin enable hashed storage. More information

    Child items 0

    • No child items are currently assigned. Use child items to break down this issue into smaller parts.

    Activity

    • eileen
      eileen @eileen ·
      Owner

      @lishaw1968 do you have the flexmailer extension enabled?

      What are you seeing?There are log files in the 'ConfigAndLog' directory that might have a backtrace - more info on where to find the log files in

      https://docs.civicrm.org/sysadmin/en/latest/troubleshooting/

    • eileen added regression label

      added regression label

    • lishaw1968
      lishaw1968 @lishaw1968 ·
      Author Developer

      Here the log just after submit the test

      Nov 06 07:11:11 [warning] hook_civicrm_documents_entity_ref_spec should be updated to pass an array of parameter names to CRM_Utils_Hook::invoke(). Caller: CRM_Documents_Utils_HookInvoker::invoke Array ( [civi.tag] => deprecated )

      Nov 06 07:11:12 [warning] hook_civicrm_documents_entity_ref_spec should be updated to pass an array of parameter names to CRM_Utils_Hook::invoke(). Caller: CRM_Documents_Utils_HookInvoker::invoke Array ( [civi.tag] => deprecated )

      Nov 06 07:11:17 [warning] hook_civicrm_documents_entity_ref_spec should be updated to pass an array of parameter names to CRM_Utils_Hook::invoke(). Caller: CRM_Documents_Utils_HookInvoker::invoke Array ( [civi.tag] => deprecated )

      Here the drupal

      Samedi 6 novembre 2021 - 07:13
      Utilisateur admin
      Emplacement https://xxx.com/fr/civicrm/ajax/rest
      Référent https://xxx.com/fr/civicrm/a
      Message hook_civicrm_documents_entity_ref_spec should be updated to pass an array of parameter names to CRM_Utils_Hook::invoke(). Caller: CRM_Documents_Utils_HookInvoker::invoke Array ( [civi.tag] => deprecated )
      Importance Avertissement

      Here the log when job is submitted

      Nov 06 07:25:09  [debug] $backTrace = #0 /var/www/html/vendor/civicrm/civicrm-core/CRM/Core/Error.php(942): CRM_Core_Error::backtrace("backTrace", TRUE)
#1 /var/www/html/vendor/pear/pear-core-minimal/src/PEAR.php(944): CRM_Core_Error::exceptionHandler(Object(DB_Error))
#2 /var/www/html/vendor/pear/db/DB.php(997): PEAR_Error->__construct("DB Error: no such field", -19, 16, (Array:2), "SELECT `a`.`id` AS `id`, `a`.`contact_type` AS `contact_type`, `a`.`contact_s...")
#3 /var/www/html/vendor/pear/pear-core-minimal/src/PEAR.php(575): DB_Error->__construct(-19, 16, (Array:2), "SELECT `a`.`id` AS `id`, `a`.`contact_type` AS `contact_type`, `a`.`contact_s...")
#4 /var/www/html/vendor/pear/pear-core-minimal/src/PEAR.php(223): PEAR->_raiseError(Object(DB_mysqli), NULL, -19, 16, (Array:2), "SELECT `a`.`id` AS `id`, `a`.`contact_type` AS `contact_type`, `a`.`contact_s...", "DB_Error", TRUE)
#5 /var/www/html/vendor/pear/db/DB/common.php(1928): PEAR->__call("raiseError", (Array:7))
#6 /var/www/html/vendor/pear/db/DB/mysqli.php(936): DB_common->raiseError(-19, NULL, NULL, "SELECT `a`.`id` AS `id`, `a`.`contact_type` AS `contact_type`, `a`.`contact_s...", "1054 ** Unknown column 'D' in 'on clause'")
#7 /var/www/html/vendor/pear/db/DB/mysqli.php(406): DB_mysqli->mysqliRaiseError()
#8 /var/www/html/vendor/pear/db/DB/common.php(1234): DB_mysqli->simpleQuery("SELECT `a`.`id` AS `id`, `a`.`contact_type` AS `contact_type`, `a`.`contact_s...")
#9 /var/www/html/vendor/civicrm/civicrm-packages/DB/DataObject.php(2696): DB_common->query("SELECT `a`.`id` AS `id`, `a`.`contact_type` AS `contact_type`, `a`.`contact_s...")
#10 /var/www/html/vendor/civicrm/civicrm-packages/DB/DataObject.php(1829): DB_DataObject->_query("SELECT `a`.`id` AS `id`, `a`.`contact_type` AS `contact_type`, `a`.`contact_s...")
#11 /var/www/html/vendor/civicrm/civicrm-core/CRM/Core/DAO.php(468): DB_DataObject->query("SELECT `a`.`id` AS `id`, `a`.`contact_type` AS `contact_type`, `a`.`contact_s...")
#12 /var/www/html/vendor/civicrm/civicrm-core/CRM/Core/DAO.php(1619): CRM_Core_DAO->query("SELECT `a`.`id` AS `id`, `a`.`contact_type` AS `contact_type`, `a`.`contact_s...", TRUE)
#13 /var/www/html/vendor/civicrm/civicrm-core/Civi/Api4/Query/Api4SelectQuery.php(166): CRM_Core_DAO::executeQuery("SELECT `a`.`id` AS `id`, `a`.`contact_type` AS `contact_type`, `a`.`contact_s...")
#14 /var/www/html/vendor/civicrm/civicrm-core/Civi/Api4/Generic/DAOGetAction.php(111): Civi\Api4\Query\Api4SelectQuery->run()
#15 /var/www/html/vendor/civicrm/civicrm-core/Civi/Api4/Generic/DAOGetAction.php(99): Civi\Api4\Generic\DAOGetAction->getObjects(Object(Civi\Api4\Generic\Result))
#16 /var/www/html/vendor/civicrm/civicrm-core/Civi/Api4/Provider/ActionObjectProvider.php(68): Civi\Api4\Generic\DAOGetAction->_run(Object(Civi\Api4\Generic\Result))
#17 /var/www/html/vendor/civicrm/civicrm-core/Civi/API/Kernel.php(149): Civi\Api4\Provider\ActionObjectProvider->invoke(Object(Civi\Api4\Generic\DAOGetAction))
#18 /var/www/html/vendor/civicrm/civicrm-core/Civi/Api4/Generic/AbstractAction.php(234): Civi\API\Kernel->runRequest(Object(Civi\Api4\Generic\DAOGetAction))
#19 /var/www/html/vendor/civicrm/civicrm-core/CRM/Contact/Tokens.php(455): Civi\Api4\Generic\AbstractAction->execute()
#20 /var/www/html/vendor/civicrm/civicrm-core/CRM/Contact/Tokens.php(266): CRM_Contact_Tokens->getContact(1, (Array:2), TRUE)
#21 /var/www/html/vendor/symfony/event-dispatcher/EventDispatcher.php(264): CRM_Contact_Tokens->evaluateLegacyHookTokens(Object(Civi\Token\Event\TokenValueEvent), "civi.token.eval", Object(Civi\Core\CiviEventDispatcher))
#22 /var/www/html/vendor/symfony/event-dispatcher/EventDispatcher.php(239): Symfony\Component\EventDispatcher\EventDispatcher->doDispatch((Array:13), "civi.token.eval", Object(Civi\Token\Event\TokenValueEvent))
#23 /var/www/html/vendor/symfony/event-dispatcher/EventDispatcher.php(73): Symfony\Component\EventDispatcher\EventDispatcher->callListeners((Array:13), "civi.token.eval", Object(Civi\Token\Event\TokenValueEvent))
#24 /var/www/html/vendor/civicrm/civicrm-core/Civi/Core/CiviEventDispatcher.php(198): Symfony\Component\EventDispatcher\EventDispatcher->dispatch(Object(Civi\Token\Event\TokenValueEvent), Object(Civi\Token\Event\TokenValueEvent))
#25 /var/www/html/vendor/civicrm/civicrm-core/Civi/Token/TokenProcessor.php(343): Civi\Core\CiviEventDispatcher->dispatch("civi.token.eval", Object(Civi\Token\Event\TokenValueEvent))
#26 /var/www/html/vendor/civicrm/civicrm-core/ext/flexmailer/src/Listener/DefaultComposer.php(79): Civi\Token\TokenProcessor->evaluate()
#27 [internal function](): Civi\FlexMailer\Listener\DefaultComposer->onCompose(Object(Civi\FlexMailer\Event\ComposeBatchEvent), "civi.flexmailer.compose", Object(Civi\Core\CiviEventDispatcher))
#28 /var/www/html/vendor/civicrm/civicrm-core/Civi/Core/Event/ServiceListener.php(53): call_user_func_array((Array:2), (Array:3))
#29 /var/www/html/vendor/symfony/event-dispatcher/EventDispatcher.php(264): Civi\Core\Event\ServiceListener->__invoke(Object(Civi\FlexMailer\Event\ComposeBatchEvent), "civi.flexmailer.compose", Object(Civi\Core\CiviEventDispatcher))
#30 /var/www/html/vendor/symfony/event-dispatcher/EventDispatcher.php(239): Symfony\Component\EventDispatcher\EventDispatcher->doDispatch((Array:10), "civi.flexmailer.compose", Object(Civi\FlexMailer\Event\ComposeBatchEvent))
#31 /var/www/html/vendor/symfony/event-dispatcher/EventDispatcher.php(73): Symfony\Component\EventDispatcher\EventDispatcher->callListeners((Array:10), "civi.flexmailer.compose", Object(Civi\FlexMailer\Event\ComposeBatchEvent))
#32 /var/www/html/vendor/civicrm/civicrm-core/Civi/Core/CiviEventDispatcher.php(198): Symfony\Component\EventDispatcher\EventDispatcher->dispatch(Object(Civi\FlexMailer\Event\ComposeBatchEvent), Object(Civi\FlexMailer\Event\ComposeBatchEvent))
#33 /var/www/html/vendor/civicrm/civicrm-core/ext/flexmailer/src/FlexMailer.php(212): Civi\Core\CiviEventDispatcher->dispatch("civi.flexmailer.compose", Object(Civi\FlexMailer\Event\ComposeBatchEvent))
#34 /var/www/html/vendor/civicrm/civicrm-core/ext/flexmailer/src/FlexMailer.php(158): Civi\FlexMailer\FlexMailer->fireComposeBatch((Array:200))
#35 [internal function](): Civi\FlexMailer\FlexMailer->Civi\FlexMailer\{closure}((Array:200))
#36 /var/www/html/vendor/civicrm/civicrm-core/ext/flexmailer/src/Event/WalkBatchesEvent.php(55): call_user_func(Object(Closure), (Array:200))
#37 /var/www/html/vendor/civicrm/civicrm-core/ext/flexmailer/src/Listener/DefaultBatcher.php(46): Civi\FlexMailer\Event\WalkBatchesEvent->visit((Array:200))
#38 [internal function](): Civi\FlexMailer\Listener\DefaultBatcher->onWalk(Object(Civi\FlexMailer\Event\WalkBatchesEvent), "civi.flexmailer.walk", Object(Civi\Core\CiviEventDispatcher))
#39 /var/www/html/vendor/civicrm/civicrm-core/Civi/Core/Event/ServiceListener.php(53): call_user_func_array((Array:2), (Array:3))
#40 /var/www/html/vendor/symfony/event-dispatcher/EventDispatcher.php(264): Civi\Core\Event\ServiceListener->__invoke(Object(Civi\FlexMailer\Event\WalkBatchesEvent), "civi.flexmailer.walk", Object(Civi\Core\CiviEventDispatcher))
#41 /var/www/html/vendor/symfony/event-dispatcher/EventDispatcher.php(239): Symfony\Component\EventDispatcher\EventDispatcher->doDispatch((Array:1), "civi.flexmailer.walk", Object(Civi\FlexMailer\Event\WalkBatchesEvent))
#42 /var/www/html/vendor/symfony/event-dispatcher/EventDispatcher.php(73): Symfony\Component\EventDispatcher\EventDispatcher->callListeners((Array:1), "civi.flexmailer.walk", Object(Civi\FlexMailer\Event\WalkBatchesEvent))
#43 /var/www/html/vendor/civicrm/civicrm-core/Civi/Core/CiviEventDispatcher.php(198): Symfony\Component\EventDispatcher\EventDispatcher->dispatch(Object(Civi\FlexMailer\Event\WalkBatchesEvent), Object(Civi\FlexMailer\Event\WalkBatchesEvent))
#44 /var/www/html/vendor/civicrm/civicrm-core/ext/flexmailer/src/FlexMailer.php(196): Civi\Core\CiviEventDispatcher->dispatch("civi.flexmailer.walk", Object(Civi\FlexMailer\Event\WalkBatchesEvent))
#45 /var/www/html/vendor/civicrm/civicrm-core/ext/flexmailer/src/FlexMailer.php(161): Civi\FlexMailer\FlexMailer->fireWalkBatches(Object(Closure))
#46 /var/www/html/vendor/civicrm/civicrm-core/ext/flexmailer/src/FlexMailer.php(122): Civi\FlexMailer\FlexMailer->run()
#47 [internal function](): Civi\FlexMailer\FlexMailer::createAndRun(Object(CRM_Mailing_BAO_MailingJob), Object(CRM_Utils_Mail_FilteredPearMailer), NULL)
#48 /var/www/html/vendor/civicrm/civicrm-core/Civi/Core/Resolver.php(119): call_user_func_array((Array:2), (Array:3))
#49 /var/www/html/vendor/civicrm/civicrm-core/CRM/Mailing/BAO/MailingJob.php(181): Civi\Core\Resolver->call("\Civi\FlexMailer\FlexMailer::createAndRun", (Array:3))
#50 /var/www/html/vendor/civicrm/civicrm-core/CRM/Mailing/BAO/Mailing.php(2746): CRM_Mailing_BAO_MailingJob::runJobs(NULL, NULL)
#51 /var/www/html/vendor/civicrm/civicrm-core/api/v3/Job.php(341): CRM_Mailing_BAO_Mailing::processQueue()
#52 /var/www/html/vendor/civicrm/civicrm-core/Civi/API/Provider/MagicFunctionProvider.php(89): civicrm_api3_job_process_mailing((Array:1))
#53 /var/www/html/vendor/civicrm/civicrm-core/Civi/API/Kernel.php(149): Civi\API\Provider\MagicFunctionProvider->invoke((Array:8))
#54 /var/www/html/vendor/civicrm/civicrm-core/Civi/API/Kernel.php(81): Civi\API\Kernel->runRequest((Array:8))
#55 /var/www/html/vendor/civicrm/civicrm-core/api/api.php(22): Civi\API\Kernel->runSafe("Job", "process_mailing", (Array:1))
#56 /var/www/html/vendor/civicrm/civicrm-core/CRM/Core/JobManager.php(131): civicrm_api("Job", "process_mailing", (Array:1))
#57 /var/www/html/vendor/civicrm/civicrm-core/CRM/Core/JobManager.php(63): CRM_Core_JobManager->executeJob(Object(CRM_Core_ScheduledJob))
#58 /var/www/html/vendor/civicrm/civicrm-core/api/v3/Job.php(118): CRM_Core_JobManager->execute(FALSE)
#59 /var/www/html/vendor/civicrm/civicrm-core/Civi/API/Provider/MagicFunctionProvider.php(89): civicrm_api3_job_execute((Array:1))
#60 /var/www/html/vendor/civicrm/civicrm-core/Civi/API/Kernel.php(149): Civi\API\Provider\MagicFunctionProvider->invoke((Array:8))
#61 /var/www/html/vendor/civicrm/civicrm-core/Civi/API/Kernel.php(81): Civi\API\Kernel->runRequest((Array:8))
#62 /var/www/html/vendor/civicrm/civicrm-core/api/api.php(22): Civi\API\Kernel->runSafe("job", "execute", (Array:1))
#63 phar:///usr/local/bin/cv/src/Command/ApiCommand.php(74): civicrm_api("job", "execute", (Array:1))
#64 phar:///usr/local/bin/cv/vendor/symfony/console/Command/Command.php(257): Civi\Cv\Command\ApiCommand->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#65 phar:///usr/local/bin/cv/vendor/symfony/console/Application.php(850): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#66 phar:///usr/local/bin/cv/vendor/symfony/console/Application.php(193): Symfony\Component\Console\Application->doRunCommand(Object(Civi\Cv\Command\ApiCommand), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#67 phar:///usr/local/bin/cv/src/Application.php(46): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#68 phar:///usr/local/bin/cv/vendor/symfony/console/Application.php(124): Civi\Cv\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#69 phar:///usr/local/bin/cv/src/Application.php(15): Symfony\Component\Console\Application->run()
#70 phar:///usr/local/bin/cv/bin/cv(27): Civi\Cv\Application::main("phar:///usr/local/bin/cv/bin")
#71 /usr/local/bin/cv(14): require("phar:///usr/local/bin/cv/bin/cv")
#72 {main}
      Edited by bgm
    • bgm
      bgm @bgm ·
      Owner

      Thanks the trace is very helpful.

      By any chance, in the ConfigAndLog, just before this backtrace, do you see the full SQL query?

      Something like this, but longer:

      SELECT a.id AS id, a.contact_type AS contact_type, a.`contact_s...", "1054 ** Unknown column 'D' in 'on clause'")

    • lishaw1968
      lishaw1968 @lishaw1968 ·
      Author Developer

      Can this be it ?

      Nov 06 11:25:10 [error] $Fatal Error Details = Array ( [callback] => Array ( [0] => CRM_Core_Error [1] => exceptionHandler )

      [code] => -19
[message] => DB Error: no such field
[mode] => 16
[debug_info] => SELECT `a`.`id` AS `id`, `a`.`contact_type` AS `contact_type`, `a`.`contact_sub_type` AS `contact_sub_type`, `a`.`do_not_email` AS `do_not_email`, `a`.`do_not_phone` AS `do_not_phone`, `a`.`do_not_mail` AS `do_not_mail`, `a`.`do_not_sms` AS `do_not_sms`, `a`.`do_not_trade` AS `do_not_trade`, `a`.`is_opt_out` AS `is_opt_out`, `a`.`legal_identifier` AS `legal_identifier`, `a`.`external_identifier` AS `external_identifier`, `a`.`sort_name` AS `sort_name`, `a`.`display_name` AS `display_name`, `a`.`nick_name` AS `nick_name`, `a`.`legal_name` AS `legal_name`, `a`.`image_URL` AS `image_URL`, `a`.`preferred_communication_method` AS `preferred_communication_method`, `a`.`preferred_language` AS `preferred_language`, `a`.`preferred_mail_format` AS `preferred_mail_format`, `a`.`hash` AS `hash`, `a`.`api_key` AS `api_key`, `a`.`source` AS `source`, `a`.`first_name` AS `first_name`, `a`.`middle_name` AS `middle_name`, `a`.`last_name` AS `last_name`, `a`.`prefix_id` AS `prefix_id`, `a`.`suffix_id` AS `suffix_id`, `a`.`formal_title` AS `formal_title`, `a`.`communication_style_id` AS `communication_style_id`, `a`.`email_greeting_id` AS `email_greeting_id`, `a`.`email_greeting_custom` AS `email_greeting_custom`, `a`.`email_greeting_display` AS `email_greeting_display`, `a`.`postal_greeting_id` AS `postal_greeting_id`, `a`.`postal_greeting_custom` AS `postal_greeting_custom`, `a`.`postal_greeting_display` AS `postal_greeting_display`, `a`.`addressee_id` AS `addressee_id`, `a`.`addressee_custom` AS `addressee_custom`, `a`.`addressee_display` AS `addressee_display`, `a`.`job_title` AS `job_title`, `a`.`gender_id` AS `gender_id`, `a`.`birth_date` AS `birth_date`, `a`.`is_deceased` AS `is_deceased`, `a`.`deceased_date` AS `deceased_date`, `a`.`household_name` AS `household_name`, `a`.`primary_contact_id` AS `primary_contact_id`, `a`.`organization_name` AS `organization_name`, `a`.`sic_code` AS `sic_code`, `a`.`user_unique_id` AS `user_unique_id`, `a`.`employer_id` AS `employer_id`, `a`.`is_deleted` AS `is_deleted`, `a`.`created_date` AS `created_date`, `a`.`modified_date` AS `modified_date`, `D_tails_clients_1`.`client_actif_4` AS `D_tails_clients.Client_actif`, `D_tails_clients_1`.`services_avec_nous_5` AS `D_tails_clients.Services_avec_nous`, `D_tails_clients_1`.`autre_info_184` AS `D_tails_clients.Autre_info`, `D_tails_clients_1`.`derni_re_mise_jour_354` AS `D_tails_clients.DERNI_RE_MISE_JOUR`, `D_tails_clients_1`.`affinit_s_366` AS `D_tails_clients.Affinit_s`, `D_tails_clients_1`.`groupe_100_367` AS `D_tails_clients.Groupe_100`, `D_tails_clients_1`.`r_f_re_368` AS `D_tails_clients.R_f_re`, `D_tails_clients_1`.`segment_369` AS `D_tails_clients.Segment`, `IC_Planification_de_la_retraite_2`.`inflation_67` AS `IC_Planification_de_la_retraite.Inflation`, `IC_Planification_de_la_retraite_2`.`age_de_la_retraite_68` AS `IC_Planification_de_la_retraite.Age_de_la_retraite`, `IC_Planification_de_la_retraite_2`.`reer_celi_69` AS `IC_Planification_de_la_retraite.REER_CELI`, `IC_Planification_de_la_retraite_2`.`revenu_annuel_d_sir__70` AS `IC_Planification_de_la_retraite.Revenu_annuel_d_sir_`, `Situation_familiale_3`.`_tat_civil_289` AS `Situation_familiale._tat_civil`, `Situation_familiale_3`.`pr_nom_conjoint_290` AS `Situation_familiale.Pr_nom_conjoint`, `Situation_familiale_3`.`nom_conjoint_291` AS `Situation_familiale.Nom_conjoint`, `Situation_familiale_3`.`date_de_naissance_conjoint_292` AS `Situation_familiale.Date_de_naissance_conjoint`, `Situation_familiale_3`.`nombre_de_personnes_charge_293` AS `Situation_familiale.Nombre_de_personnes_charge`, `E_Divers_4`.`ch_que_sp_cimen_306` AS `E_Divers.Ch_que_sp_cimen`, `E_Divers_4`.`une_autre_personne_est_elle_auto_307` AS `E_Divers.Une_autre_personne_est_elle_autoris_e_donner_des_ordre_pour_ce_c`, `E_Divers_4`.`le_compte_est_il_exploit_dans_l__308` AS `E_Divers.Le_compte_est_il_exploit_dans_l_int_r_t_d_un_tier`, `E_Divers_4`.`num_ro_de_la_succursale_478` AS `E_Divers.Num_ro_de_la_succursale`, `E_Divers_4`.`num_ro_de_la_banque_479` AS `E_Divers.Num_ro_de_la_banque`, `E_Divers_4`.`num_ro_de_compte_480` AS `E_Divers.Num_ro_de_compte`, `E_Divers_4`.`_tes_vous_une_personne_politique_546` AS `E_Divers._tes_vous_une_personne_politiquement_vuln_rable_ou_un_dirigeant_`, `E_Divers_4`.`_tes_vous_un_r_sident_am_ricain__547` AS `E_Divers._tes_vous_un_r_sident_am_ricain_ou_un_citoyen_am_ricain_aux_fins`, `E_Divers_4`.`_tes_vous_un_r_sident_aux_fins_d_548` AS `E_Divers._tes_vous_un_r_sident_aux_fins_de_l_imp_t_d_un_autre_pays_que_le`, `H_Profil_financier_et_exp_rience_5`.`origine_du_premier_contact_310` AS `H_Profil_financier_et_exp_rience.Origine_du_premier_contact`, `H_Profil_financier_et_exp_rience_5`.`exp_rience_en_investissement_311` AS `H_Profil_financier_et_exp_rience.Exp_rience_en_investissement`, `H_Profil_financier_et_exp_rience_5`.`connaissance_en_placement_312` AS `H_Profil_financier_et_exp_rience.Connaissance_en_placement`, `I_Bilan_et_revenu_6`.`actifs_non_reer_313` AS `I_Bilan_et_revenu.Actifs_non_REER`, `I_Bilan_et_revenu_6`.`actifs_reer_ferr_cri_celi_314` AS `I_Bilan_et_revenu.Actifs_REER_FERR_CRI_CELI`, `I_Bilan_et_revenu_6`.`actif_avoir_liquide_315` AS `I_Bilan_et_revenu.Actif_Avoir_Liquide`, `I_Bilan_et_revenu_6`.`actifs_immobilier_316` AS `I_Bilan_et_revenu.Actifs_immobilier`, `I_Bilan_et_revenu_6`.`passifs_hypoth_que_317` AS `I_Bilan_et_revenu.Passifs_Hypoth_que`, `I_Bilan_et_revenu_6`.`passifs_cartes_de_cr_dit_et_autr_318` AS `I_Bilan_et_revenu.Passifs_Cartes_de_cr_dit_et_autres_dettes`, `I_Bilan_et_revenu_6`.`revenu_annuel_319` AS `I_Bilan_et_revenu.Revenu_annuel`, `I_Bilan_et_revenu_6`.`actifs_non_reer_avec_d_autres_in_505` AS `I_Bilan_et_revenu.Actifs_Non_REER_Avec_d_autres_institutions_financi_re_`, `I_Bilan_et_revenu_6`.`numeric_actifs_reer_ferr_cri_cel_506` AS `I_Bilan_et_revenu.Numeric_Actifs_REER_FERR_CRI_CELI_Avec_d_autres_institutions_fin`, `I_Bilan_et_revenu_6`.`revenu_annuel_numeric_508` AS `I_Bilan_et_revenu.Revenu_annuel_numeric`, `Int_r_ts_personnels_7`.`hobby_349` AS `Int_r_ts_personnels.Hobby`, `Int_r_ts_personnels_7`.`autre_355` AS `Int_r_ts_personnels.Autre`, `Collectif_8`.`genre_d_entreprise_371` AS `Collectif.Genre_d_entreprise`, `Collectif_8`.`date_de_constitution_372` AS `Collectif.Date_de_constitution`, `Collectif_8`.`nombre_d_employ_s_373` AS `Collectif.Nombre_d_employ_s`, `Collectif_8`.`chiffre_d_affaire_374` AS `Collectif.Chiffre_d_affaire`, `Avantages_sociaux_9`.`assurance_collective_avec_377` AS `Avantages_sociaux.Assurance_collective_avec`, `Avantages_sociaux_9`.`date_d_ch_ance_378` AS `Avantages_sociaux.Date_d_ch_ance`, `Avantages_sociaux_9`.`garantie_courte_dur_e_379` AS `Avantages_sociaux.Garantie_Courte_dur_e`, `Avantages_sociaux_9`.`garantie_longeu_dur_e_380` AS `Avantages_sociaux.Garantie_Longeu_dur_e`, `Avantages_sociaux_9`.`garantie_maladie_graves_381` AS `Avantages_sociaux.Garantie_Maladie_Graves`, `Avantages_sociaux_9`.`garantie_soins_domicile_382` AS `Avantages_sociaux.Garantie_soins_domicile`, `Avantages_sociaux_9`.`garantie_assurance_vie_383` AS `Avantages_sociaux.Garantie_assurance_vie`, `Avantages_sociaux_9`.`frais_m_dicaux_et_param_dicaux_384` AS `Avantages_sociaux.Frais_m_dicaux_et_param_dicaux`, `Avantages_sociaux_9`.`lunette_385` AS `Avantages_sociaux.Lunette`, `Avantages_sociaux_9`.`dentaire_386` AS `Avantages_sociaux.Dentaire`, `Avantages_sociaux_9`.`commentaires_387` AS `Avantages_sociaux.Commentaires`, `lcf_contact_note_10`.`note_388` AS `lcf_contact_note.contact_note`, `lcf_individual_supplier_account_details_11`.`plan_type_399` AS `lcf_individual_supplier_account_details.plan_type`, `lcf_individual_supplier_account_details_11`.`account_number_401` AS `lcf_individual_supplier_account_details.account_number`, `lcf_individual_supplier_account_details_11`.`cotisation_403` AS `lcf_individual_supplier_account_details.fee`, `lcf_individual_supplier_account_details_11`.`investment_provider_405` AS `lcf_individual_supplier_account_details.investment_provider`, `lcf_individual_supplier_account_details_11`.`investment_code_407` AS `lcf_individual_supplier_account_details.investment_code`, `lcf_individual_supplier_account_details_11`.`advisor_code_409` AS `lcf_individual_supplier_account_details.advisor_code`, `lcf_individual_supplier_account_details_11`.`fair_market_value_411` AS `lcf_individual_supplier_account_details.fair_market_value`, `lcf_individual_supplier_account_details_11`.`book_value_413` AS `lcf_individual_supplier_account_details.book_value`, `lcf_individual_supplier_account_details_11`.`intermediary_account_415` AS `lcf_individual_supplier_account_details.intermediary_account `, `lcf_individual_supplier_account_details_11`.`risk_417` AS `lcf_individual_supplier_account_details.risk`, `lcf_registration_code_12`.`registration_code_397` AS `lcf_registration_code.registration_code`, `lcf_individual_supplier_statuses_13`.`is_still_in_business__418` AS `lcf_individual_supplier_statuses.is_still_in_business`, `lcf_individual_supplier_statuses_13`.`is_we_can_sell_them__419` AS `lcf_individual_supplier_statuses.is_we_can_sell_them`, `lcf_employer_14`.`job_status_420` AS `lcf_employer.employer_status`, `lcf_employer_14`.`name_of_the_employer_421` AS `lcf_employer.employer_name`, `lcf_employer_14`.`emploi_447` AS `lcf_employer.Emploi`, `lcf_employer_14`.`employeur_448` AS `lcf_employer.Employeur`, `lcf_employer_14`.`secteur_d_activit__458` AS `lcf_employer.Secteur_d_activit_`, `lcf_employer_14`.`position_562` AS `lcf_employer.Position`, `lcf_organization_type_of_business_15`.`type_of_business_422` AS `lcf_organization_type_of_business.type_of_business`, `Phone_varefication_16`.`phone_validated_424` AS `Phone_varefication.Phone_validated`, `Impsition_client_aux_tats_unis_17`.`_tes_vous_une_personne_des_tats__445` AS `Impsition_client_aux_tats_unis._tes_vous_une_personne_des_tats_Unis_aux_fins_de_l_imp_t_sur_le_`, `Impsition_client_aux_tats_unis_17`.`si_oui_indiquez_votre_tax_indent_446` AS `Impsition_client_aux_tats_unis.Si_oui_indiquez_votre_tax_indentification_number_TIN_tats_Unis`, `Conseiller_Code_18`.`dealer_code_459` AS `Conseiller_Code.Dealer_Code`, `Conseiller_Code_18`.`rep_code_460` AS `Conseiller_Code.Rep_Code`, `Conseiller_Code_18`.`nom_du_conseiller_481` AS `Conseiller_Code.Nom_du_conseiller`, `Conseiller_Code_18`.`t_l_phone_482` AS `Conseiller_Code.T_l_phone`, `Questionnaire_de_l_investisseur_19`.`quel_nonc_d_crit_le_mieux_vos_co_564` AS `Questionnaire_de_l_investisseur.Quel_nonc_d_crit_le_mieux_vos_connaissances_en_mati_re_de_placem`, `Questionnaire_de_l_investisseur_19`.`quel_est_votre_revenu_annuel_de__565` AS `Questionnaire_de_l_investisseur.Quel_est_votre_revenu_annuel_de_toutes_les_sources_`, `Questionnaire_de_l_investisseur_19`.`vos_sources_de_revenus_actuels_e_566` AS `Questionnaire_de_l_investisseur.Vos_sources_de_revenus_actuels_et_futurs_sont_`, `Questionnaire_de_l_investisseur_19`.`comment_d_cririez_vous_votre_sit_567` AS `Questionnaire_de_l_investisseur.Comment_d_cririez_vous_votre_situation_financi_re_globale_`, `Questionnaire_de_l_investisseur_19`.`_combien_estimez_vous_votre_vale_568` AS `Questionnaire_de_l_investisseur._combien_estimez_vous_votre_valeur_nette_placements_liquidit_s_m`, `Questionnaire_de_l_investisseur_19`.`quel_pourcentage_du_total_de_vos_569` AS `Questionnaire_de_l_investisseur.Quel_pourcentage_du_total_de_vos_conomies_et_de_vos_placements_c`, `Questionnaire_de_l_investisseur_19`.`quel_est_votre_groupe_d_ge__570` AS `Questionnaire_de_l_investisseur.Quel_est_votre_groupe_d_ge_`, `Questionnaire_de_l_investisseur_19`.`question_10_571` AS `Questionnaire_de_l_investisseur.Question_10`, `Questionnaire_de_l_investisseur_19`.`questiion_11_572` AS `Questionnaire_de_l_investisseur.Questiion_11`, `Questionnaire_de_l_investisseur_19`.`question_12_573` AS `Questionnaire_de_l_investisseur.Question_12`, `Questionnaire_de_l_investisseur_19`.`question_13_574` AS `Questionnaire_de_l_investisseur.Question_13`, `Questionnaire_de_l_investisseur_19`.`question_14_575` AS `Questionnaire_de_l_investisseur.Question_14`, `Questionnaire_de_l_investisseur_19`.`question_15_576` AS `Questionnaire_de_l_investisseur.Question_15`, `a`.`prefix_id` AS `prefix_id:label`, `a`.`suffix_id` AS `suffix_id:label`, `a`.`contact_type` AS `contact_type:label`, `a`.`gender_id` AS `gender_id:label`, `a`.`communication_style_id` AS `communication_style_id:label`, `a`.`preferred_communication_method` AS `preferred_communication_method:label`, `employer_id_21`.`display_name` AS `employer_id.display_name`

      FROM civicrm_contact a LEFT JOIN civicrm_value_d_tails_clients_2 D_tails_clients_1 ON a.id = D_tails_clients_1.entity_id LEFT JOIN civicrm_value_ic_planification_de_la_retraite_12 IC_Planification_de_la_retraite_2 ON a.id = IC_Planification_de_la_retraite_2.entity_id LEFT JOIN civicrm_value_situation_familiale_48 Situation_familiale_3 ON a.id = Situation_familiale_3.entity_id LEFT JOIN civicrm_value_e_divers_54 E_Divers_4 ON a.id = E_Divers_4.entity_id LEFT JOIN civicrm_value_h_profil_financier_et_exp_rience_55 H_Profil_financier_et_exp_rience_5 ON a.id = H_Profil_financier_et_exp_rience_5.entity_id LEFT JOIN civicrm_value_i_bilan_et_revenu_56 I_Bilan_et_revenu_6 ON a.id = I_Bilan_et_revenu_6.entity_id LEFT JOIN civicrm_value_int_r_ts_personnels_68 Int_r_ts_personnels_7 ON a.id = Int_r_ts_personnels_7.entity_id LEFT JOIN civicrm_value_collectif_72 Collectif_8 ON a.id = Collectif_8.entity_id LEFT JOIN civicrm_value_avantages_soc_73 Avantages_sociaux_9 ON a.id = Avantages_sociaux_9.entity_id LEFT JOIN civicrm_value_note_74 lcf_contact_note_10 ON a.id = lcf_contact_note_10.entity_id LEFT JOIN civicrm_value_account_detai_78 lcf_individual_supplier_account_details_11 ON a.id = lcf_individual_supplier_account_details_11.entity_id LEFT JOIN civicrm_value_registration__80 lcf_registration_code_12 ON a.id = lcf_registration_code_12.entity_id LEFT JOIN civicrm_value_supplier_stat_81 lcf_individual_supplier_statuses_13 ON a.id = lcf_individual_supplier_statuses_13.entity_id LEFT JOIN civicrm_value_employeur_82 lcf_employer_14 ON a.id = lcf_employer_14.entity_id LEFT JOIN civicrm_value_type_of_busin_83 lcf_organization_type_of_business_15 ON a.id = lcf_organization_type_of_business_15.entity_id LEFT JOIN civicrm_value_phone_varefic_85 Phone_varefication_16 ON a.id = Phone_varefication_16.entity_id LEFT JOIN civicrm_value_impsition_cli_89 Impsition_client_aux_tats_unis_17 ON a.id = Impsition_client_aux_tats_unis_17.entity_id LEFT JOIN civicrm_value_conseiller_co_91 Conseiller_Code_18 ON a.id = Conseiller_Code_18.entity_id LEFT JOIN civicrm_value_questionnaire_103 Questionnaire_de_l_investisseur_19 ON a.id = Questionnaire_de_l_investisseur_19.entity_id LEFT JOIN civicrm_value_demographics D - Identification_20 ON a.id = D - Identification_20.entity_id LEFT JOIN civicrm_contact employer_id_21 ON a.employer_id = employer_id_21.id WHERE (a.id = "1") [nativecode=1054 ** Unknown column 'D' in 'on clause'] [type] => DB_Error [user_info] => SELECT a.id AS id, a.contact_type AS contact_type, a.contact_sub_type AS contact_sub_type, a.do_not_email AS do_not_email, a.do_not_phone AS do_not_phone, a.do_not_mail AS do_not_mail, a.do_not_sms AS do_not_sms, a.do_not_trade AS do_not_trade, a.is_opt_out AS is_opt_out, a.legal_identifier AS legal_identifier, a.external_identifier AS external_identifier, a.sort_name AS sort_name, a.display_name AS display_name, a.nick_name AS nick_name, a.legal_name AS legal_name, a.image_URL AS image_URL, a.preferred_communication_method AS preferred_communication_method, a.preferred_language AS preferred_language, a.preferred_mail_format AS preferred_mail_format, a.hash AS hash, a.api_key AS api_key, a.source AS source, a.first_name AS first_name, a.middle_name AS middle_name, a.last_name AS last_name, a.prefix_id AS prefix_id, a.suffix_id AS suffix_id, a.formal_title AS formal_title, a.communication_style_id AS communication_style_id, a.email_greeting_id AS email_greeting_id, a.email_greeting_custom AS email_greeting_custom, a.email_greeting_display AS email_greeting_display, a.postal_greeting_id AS postal_greeting_id, a.postal_greeting_custom AS postal_greeting_custom, a.postal_greeting_display AS postal_greeting_display, a.addressee_id AS addressee_id, a.addressee_custom AS addressee_custom, a.addressee_display AS addressee_display, a.job_title AS job_title, a.gender_id AS gender_id, a.birth_date AS birth_date, a.is_deceased AS is_deceased, a.deceased_date AS deceased_date, a.household_name AS household_name, a.primary_contact_id AS primary_contact_id, a.organization_name AS organization_name, a.sic_code AS sic_code, a.user_unique_id AS user_unique_id, a.employer_id AS employer_id, a.is_deleted AS is_deleted, a.created_date AS created_date, a.modified_date AS modified_date, D_tails_clients_1.client_actif_4 AS D_tails_clients.Client_actif, D_tails_clients_1.services_avec_nous_5 AS D_tails_clients.Services_avec_nous, D_tails_clients_1.autre_info_184 AS D_tails_clients.Autre_info, D_tails_clients_1.derni_re_mise_jour_354 AS D_tails_clients.DERNI_RE_MISE_JOUR, D_tails_clients_1.affinit_s_366 AS D_tails_clients.Affinit_s, D_tails_clients_1.groupe_100_367 AS D_tails_clients.Groupe_100, D_tails_clients_1.r_f_re_368 AS D_tails_clients.R_f_re, D_tails_clients_1.segment_369 AS D_tails_clients.Segment, IC_Planification_de_la_retraite_2.inflation_67 AS IC_Planification_de_la_retraite.Inflation, IC_Planification_de_la_retraite_2.age_de_la_retraite_68 AS IC_Planification_de_la_retraite.Age_de_la_retraite, IC_Planification_de_la_retraite_2.reer_celi_69 AS IC_Planification_de_la_retraite.REER_CELI, IC_Planification_de_la_retraite_2.revenu_annuel_d_sir__70 AS IC_Planification_de_la_retraite.Revenu_annuel_d_sir_, Situation_familiale_3._tat_civil_289 AS Situation_familiale._tat_civil, Situation_familiale_3.pr_nom_conjoint_290 AS Situation_familiale.Pr_nom_conjoint, Situation_familiale_3.nom_conjoint_291 AS Situation_familiale.Nom_conjoint, Situation_familiale_3.date_de_naissance_conjoint_292 AS Situation_familiale.Date_de_naissance_conjoint, Situation_familiale_3.nombre_de_personnes_charge_293 AS Situation_familiale.Nombre_de_personnes_charge, E_Divers_4.ch_que_sp_cimen_306 AS E_Divers.Ch_que_sp_cimen, E_Divers_4.une_autre_personne_est_elle_auto_307 AS E_Divers.Une_autre_personne_est_elle_autoris_e_donner_des_ordre_pour_ce_c, E_Divers_4.le_compte_est_il_exploit_dans_l__308 AS E_Divers.Le_compte_est_il_exploit_dans_l_int_r_t_d_un_tier, E_Divers_4.num_ro_de_la_succursale_478 AS E_Divers.Num_ro_de_la_succursale, E_Divers_4.num_ro_de_la_banque_479 AS E_Divers.Num_ro_de_la_banque, E_Divers_4.num_ro_de_compte_480 AS E_Divers.Num_ro_de_compte, E_Divers_4._tes_vous_une_personne_politique_546 AS E_Divers._tes_vous_une_personne_politiquement_vuln_rable_ou_un_dirigeant_, E_Divers_4._tes_vous_un_r_sident_am_ricain__547 AS E_Divers._tes_vous_un_r_sident_am_ricain_ou_un_citoyen_am_ricain_aux_fins, E_Divers_4._tes_vous_un_r_sident_aux_fins_d_548 AS E_Divers._tes_vous_un_r_sident_aux_fins_de_l_imp_t_d_un_autre_pays_que_le, H_Profil_financier_et_exp_rience_5.origine_du_premier_contact_310 AS H_Profil_financier_et_exp_rience.Origine_du_premier_contact, H_Profil_financier_et_exp_rience_5.exp_rience_en_investissement_311 AS H_Profil_financier_et_exp_rience.Exp_rience_en_investissement, H_Profil_financier_et_exp_rience_5.connaissance_en_placement_312 AS H_Profil_financier_et_exp_rience.Connaissance_en_placement, I_Bilan_et_revenu_6.actifs_non_reer_313 AS I_Bilan_et_revenu.Actifs_non_REER, I_Bilan_et_revenu_6.actifs_reer_ferr_cri_celi_314 AS I_Bilan_et_revenu.Actifs_REER_FERR_CRI_CELI, I_Bilan_et_revenu_6.actif_avoir_liquide_315 AS I_Bilan_et_revenu.Actif_Avoir_Liquide, I_Bilan_et_revenu_6.actifs_immobilier_316 AS I_Bilan_et_revenu.Actifs_immobilier, I_Bilan_et_revenu_6.passifs_hypoth_que_317 AS I_Bilan_et_revenu.Passifs_Hypoth_que, I_Bilan_et_revenu_6.passifs_cartes_de_cr_dit_et_autr_318 AS I_Bilan_et_revenu.Passifs_Cartes_de_cr_dit_et_autres_dettes, I_Bilan_et_revenu_6.revenu_annuel_319 AS I_Bilan_et_revenu.Revenu_annuel, I_Bilan_et_revenu_6.actifs_non_reer_avec_d_autres_in_505 AS I_Bilan_et_revenu.Actifs_Non_REER_Avec_d_autres_institutions_financi_re_, I_Bilan_et_revenu_6.numeric_actifs_reer_ferr_cri_cel_506 AS I_Bilan_et_revenu.Numeric_Actifs_REER_FERR_CRI_CELI_Avec_d_autres_institutions_fin, I_Bilan_et_revenu_6.revenu_annuel_numeric_508 AS I_Bilan_et_revenu.Revenu_annuel_numeric, Int_r_ts_personnels_7.hobby_349 AS Int_r_ts_personnels.Hobby, Int_r_ts_personnels_7.autre_355 AS Int_r_ts_personnels.Autre, Collectif_8.genre_d_entreprise_371 AS Collectif.Genre_d_entreprise, Collectif_8.date_de_constitution_372 AS Collectif.Date_de_constitution, Collectif_8.nombre_d_employ_s_373 AS Collectif.Nombre_d_employ_s, Collectif_8.chiffre_d_affaire_374 AS Collectif.Chiffre_d_affaire, Avantages_sociaux_9.assurance_collective_avec_377 AS Avantages_sociaux.Assurance_collective_avec, Avantages_sociaux_9.date_d_ch_ance_378 AS Avantages_sociaux.Date_d_ch_ance, Avantages_sociaux_9.garantie_courte_dur_e_379 AS Avantages_sociaux.Garantie_Courte_dur_e, Avantages_sociaux_9.garantie_longeu_dur_e_380 AS Avantages_sociaux.Garantie_Longeu_dur_e, Avantages_sociaux_9.garantie_maladie_graves_381 AS Avantages_sociaux.Garantie_Maladie_Graves, Avantages_sociaux_9.garantie_soins_domicile_382 AS Avantages_sociaux.Garantie_soins_domicile, Avantages_sociaux_9.garantie_assurance_vie_383 AS Avantages_sociaux.Garantie_assurance_vie, Avantages_sociaux_9.frais_m_dicaux_et_param_dicaux_384 AS Avantages_sociaux.Frais_m_dicaux_et_param_dicaux, Avantages_sociaux_9.lunette_385 AS Avantages_sociaux.Lunette, Avantages_sociaux_9.dentaire_386 AS Avantages_sociaux.Dentaire, Avantages_sociaux_9.commentaires_387 AS Avantages_sociaux.Commentaires, lcf_contact_note_10.note_388 AS lcf_contact_note.contact_note, lcf_individual_supplier_account_details_11.plan_type_399 AS lcf_individual_supplier_account_details.plan_type, lcf_individual_supplier_account_details_11.account_number_401 AS lcf_individual_supplier_account_details.account_number, lcf_individual_supplier_account_details_11.cotisation_403 AS lcf_individual_supplier_account_details.fee, lcf_individual_supplier_account_details_11.investment_provider_405 AS lcf_individual_supplier_account_details.investment_provider, lcf_individual_supplier_account_details_11.investment_code_407 AS lcf_individual_supplier_account_details.investment_code, lcf_individual_supplier_account_details_11.advisor_code_409 AS lcf_individual_supplier_account_details.advisor_code, lcf_individual_supplier_account_details_11.fair_market_value_411 AS lcf_individual_supplier_account_details.fair_market_value, lcf_individual_supplier_account_details_11.book_value_413 AS lcf_individual_supplier_account_details.book_value, lcf_individual_supplier_account_details_11.intermediary_account_415 AS lcf_individual_supplier_account_details.intermediary_account , lcf_individual_supplier_account_details_11.risk_417 AS lcf_individual_supplier_account_details.risk, lcf_registration_code_12.registration_code_397 AS lcf_registration_code.registration_code, lcf_individual_supplier_statuses_13.is_still_in_business__418 AS lcf_individual_supplier_statuses.is_still_in_business, lcf_individual_supplier_statuses_13.is_we_can_sell_them__419 AS lcf_individual_supplier_statuses.is_we_can_sell_them, lcf_employer_14.job_status_420 AS lcf_employer.employer_status, lcf_employer_14.name_of_the_employer_421 AS lcf_employer.employer_name, lcf_employer_14.emploi_447 AS lcf_employer.Emploi, lcf_employer_14.employeur_448 AS lcf_employer.Employeur, lcf_employer_14.secteur_d_activit__458 AS lcf_employer.Secteur_d_activit_, lcf_employer_14.position_562 AS lcf_employer.Position, lcf_organization_type_of_business_15.type_of_business_422 AS lcf_organization_type_of_business.type_of_business, Phone_varefication_16.phone_validated_424 AS Phone_varefication.Phone_validated, Impsition_client_aux_tats_unis_17._tes_vous_une_personne_des_tats__445 AS Impsition_client_aux_tats_unis._tes_vous_une_personne_des_tats_Unis_aux_fins_de_l_imp_t_sur_le_, Impsition_client_aux_tats_unis_17.si_oui_indiquez_votre_tax_indent_446 AS Impsition_client_aux_tats_unis.Si_oui_indiquez_votre_tax_indentification_number_TIN_tats_Unis, Conseiller_Code_18.dealer_code_459 AS Conseiller_Code.Dealer_Code, Conseiller_Code_18.rep_code_460 AS Conseiller_Code.Rep_Code, Conseiller_Code_18.nom_du_conseiller_481 AS Conseiller_Code.Nom_du_conseiller, Conseiller_Code_18.t_l_phone_482 AS Conseiller_Code.T_l_phone, Questionnaire_de_l_investisseur_19.quel_nonc_d_crit_le_mieux_vos_co_564 AS Questionnaire_de_l_investisseur.Quel_nonc_d_crit_le_mieux_vos_connaissances_en_mati_re_de_placem, Questionnaire_de_l_investisseur_19.quel_est_votre_revenu_annuel_de__565 AS Questionnaire_de_l_investisseur.Quel_est_votre_revenu_annuel_de_toutes_les_sources_, Questionnaire_de_l_investisseur_19.vos_sources_de_revenus_actuels_e_566 AS Questionnaire_de_l_investisseur.Vos_sources_de_revenus_actuels_et_futurs_sont_, Questionnaire_de_l_investisseur_19.comment_d_cririez_vous_votre_sit_567 AS Questionnaire_de_l_investisseur.Comment_d_cririez_vous_votre_situation_financi_re_globale_, Questionnaire_de_l_investisseur_19._combien_estimez_vous_votre_vale_568 AS Questionnaire_de_l_investisseur._combien_estimez_vous_votre_valeur_nette_placements_liquidit_s_m, Questionnaire_de_l_investisseur_19.quel_pourcentage_du_total_de_vos_569 AS Questionnaire_de_l_investisseur.Quel_pourcentage_du_total_de_vos_conomies_et_de_vos_placements_c, Questionnaire_de_l_investisseur_19.quel_est_votre_groupe_d_ge__570 AS Questionnaire_de_l_investisseur.Quel_est_votre_groupe_d_ge_, Questionnaire_de_l_investisseur_19.question_10_571 AS Questionnaire_de_l_investisseur.Question_10, Questionnaire_de_l_investisseur_19.questiion_11_572 AS Questionnaire_de_l_investisseur.Questiion_11, Questionnaire_de_l_investisseur_19.question_12_573 AS Questionnaire_de_l_investisseur.Question_12, Questionnaire_de_l_investisseur_19.question_13_574 AS Questionnaire_de_l_investisseur.Question_13, Questionnaire_de_l_investisseur_19.question_14_575 AS Questionnaire_de_l_investisseur.Question_14, Questionnaire_de_l_investisseur_19.question_15_576 AS Questionnaire_de_l_investisseur.Question_15, a.prefix_id AS prefix_id:label, a.suffix_id AS suffix_id:label, a.contact_type AS contact_type:label, a.gender_id AS gender_id:label, a.communication_style_id AS communication_style_id:label, a.preferred_communication_method AS preferred_communication_method:label, employer_id_21.display_name AS employer_id.display_name FROM civicrm_contact a LEFT JOIN civicrm_value_d_tails_clients_2 D_tails_clients_1 ON a.id = D_tails_clients_1.entity_id LEFT JOIN civicrm_value_ic_planification_de_la_retraite_12 IC_Planification_de_la_retraite_2 ON a.id = IC_Planification_de_la_retraite_2.entity_id LEFT JOIN civicrm_value_situation_familiale_48 Situation_familiale_3 ON a.id = Situation_familiale_3.entity_id LEFT JOIN civicrm_value_e_divers_54 E_Divers_4 ON a.id = E_Divers_4.entity_id LEFT JOIN civicrm_value_h_profil_financier_et_exp_rience_55 H_Profil_financier_et_exp_rience_5 ON a.id = H_Profil_financier_et_exp_rience_5.entity_id LEFT JOIN civicrm_value_i_bilan_et_revenu_56 I_Bilan_et_revenu_6 ON a.id = I_Bilan_et_revenu_6.entity_id LEFT JOIN civicrm_value_int_r_ts_personnels_68 Int_r_ts_personnels_7 ON a.id = Int_r_ts_personnels_7.entity_id LEFT JOIN civicrm_value_collectif_72 Collectif_8 ON a.id = Collectif_8.entity_id LEFT JOIN civicrm_value_avantages_soc_73 Avantages_sociaux_9 ON a.id = Avantages_sociaux_9.entity_id LEFT JOIN civicrm_value_note_74 lcf_contact_note_10 ON a.id = lcf_contact_note_10.entity_id LEFT JOIN civicrm_value_account_detai_78 lcf_individual_supplier_account_details_11 ON a.id = lcf_individual_supplier_account_details_11.entity_id LEFT JOIN civicrm_value_registration__80 lcf_registration_code_12 ON a.id = lcf_registration_code_12.entity_id LEFT JOIN civicrm_value_supplier_stat_81 lcf_individual_supplier_statuses_13 ON a.id = lcf_individual_supplier_statuses_13.entity_id LEFT JOIN civicrm_value_employeur_82 lcf_employer_14 ON a.id = lcf_employer_14.entity_id LEFT JOIN civicrm_value_type_of_busin_83 lcf_organization_type_of_business_15 ON a.id = lcf_organization_type_of_business_15.entity_id LEFT JOIN civicrm_value_phone_varefic_85 Phone_varefication_16 ON a.id = Phone_varefication_16.entity_id LEFT JOIN civicrm_value_impsition_cli_89 Impsition_client_aux_tats_unis_17 ON a.id = Impsition_client_aux_tats_unis_17.entity_id LEFT JOIN civicrm_value_conseiller_co_91 Conseiller_Code_18 ON a.id = Conseiller_Code_18.entity_id LEFT JOIN civicrm_value_questionnaire_103 Questionnaire_de_l_investisseur_19 ON a.id = Questionnaire_de_l_investisseur_19.entity_id LEFT JOIN civicrm_value_demographics D - Identification_20 ON a.id = D - Identification_20.entity_id LEFT JOIN civicrm_contact employer_id_21 ON a.employer_id = employer_id_21.id WHERE (a.id = "1") [nativecode=1054 ** Unknown column 'D' in 'on clause'] [to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::exceptionHandler prefix="" info="SELECT a.id AS id, a.contact_type AS contact_type, a.contact_sub_type AS contact_sub_type, a.do_not_email AS do_not_email, a.do_not_phone AS do_not_phone, a.do_not_mail AS do_not_mail, a.do_not_sms AS do_not_sms, a.do_not_trade AS do_not_trade, a.is_opt_out AS is_opt_out, a.legal_identifier AS legal_identifier, a.external_identifier AS external_identifier, a.sort_name AS sort_name, a.display_name AS display_name, a.nick_name AS nick_name, a.legal_name AS legal_name, a.image_URL AS image_URL, a.preferred_communication_method AS preferred_communication_method, a.preferred_language AS preferred_language, a.preferred_mail_format AS preferred_mail_format, a.hash AS hash, a.api_key AS api_key, a.source AS source, a.first_name AS first_name, a.middle_name AS middle_name, a.last_name AS last_name, a.prefix_id AS prefix_id, a.suffix_id AS suffix_id, a.formal_title AS formal_title, a.communication_style_id AS communication_style_id, a.email_greeting_id AS email_greeting_id, a.email_greeting_custom AS email_greeting_custom, a.email_greeting_display AS email_greeting_display, a.postal_greeting_id AS postal_greeting_id, a.postal_greeting_custom AS postal_greeting_custom, a.postal_greeting_display AS postal_greeting_display, a.addressee_id AS addressee_id, a.addressee_custom AS addressee_custom, a.addressee_display AS addressee_display, a.job_title AS job_title, a.gender_id AS gender_id, a.birth_date AS birth_date, a.is_deceased AS is_deceased, a.deceased_date AS deceased_date, a.household_name AS household_name, a.primary_contact_id AS primary_contact_id, a.organization_name AS organization_name, a.sic_code AS sic_code, a.user_unique_id AS user_unique_id, a.employer_id AS employer_id, a.is_deleted AS is_deleted, a.created_date AS created_date, a.modified_date AS modified_date, D_tails_clients_1.client_actif_4 AS D_tails_clients.Client_actif, D_tails_clients_1.services_avec_nous_5 AS D_tails_clients.Services_avec_nous, D_tails_clients_1.autre_info_184 AS D_tails_clients.Autre_info, D_tails_clients_1.derni_re_mise_jour_354 AS D_tails_clients.DERNI_RE_MISE_JOUR, D_tails_clients_1.affinit_s_366 AS D_tails_clients.Affinit_s, D_tails_clients_1.groupe_100_367 AS D_tails_clients.Groupe_100, D_tails_clients_1.r_f_re_368 AS D_tails_clients.R_f_re, D_tails_clients_1.segment_369 AS D_tails_clients.Segment, IC_Planification_de_la_retraite_2.inflation_67 AS IC_Planification_de_la_retraite.Inflation, IC_Planification_de_la_retraite_2.age_de_la_retraite_68 AS IC_Planification_de_la_retraite.Age_de_la_retraite, IC_Planification_de_la_retraite_2.reer_celi_69 AS IC_Planification_de_la_retraite.REER_CELI, IC_Planification_de_la_retraite_2.revenu_annuel_d_sir__70 AS IC_Planification_de_la_retraite.Revenu_annuel_d_sir_, Situation_familiale_3._tat_civil_289 AS Situation_familiale._tat_civil, Situation_familiale_3.pr_nom_conjoint_290 AS Situation_familiale.Pr_nom_conjoint, Situation_familiale_3.nom_conjoint_291 AS Situation_familiale.Nom_conjoint, Situation_familiale_3.date_de_naissance_conjoint_292 AS Situation_familiale.Date_de_naissance_conjoint, Situation_familiale_3.nombre_de_personnes_charge_293 AS Situation_familiale.Nombre_de_personnes_charge, E_Divers_4.ch_que_sp_cimen_306 AS E_Divers.Ch_que_sp_cimen, E_Divers_4.une_autre_personne_est_elle_auto_307 AS E_Divers.Une_autre_personne_est_elle_autoris_e_donner_des_ordre_pour_ce_c, E_Divers_4.le_compte_est_il_exploit_dans_l__308 AS E_Divers.Le_compte_est_il_exploit_dans_l_int_r_t_d_un_tier, E_Divers_4.num_ro_de_la_succursale_478 AS E_Divers.Num_ro_de_la_succursale, E_Divers_4.num_ro_de_la_banque_479 AS E_Divers.Num_ro_de_la_banque, E_Divers_4.num_ro_de_compte_480 AS E_Divers.Num_ro_de_compte, E_Divers_4._tes_vous_une_personne_politique_546 AS E_Divers._tes_vous_une_personne_politiquement_vuln_rable_ou_un_dirigeant_, E_Divers_4._tes_vous_un_r_sident_am_ricain__547 AS E_Divers._tes_vous_un_r_sident_am_ricain_ou_un_citoyen_am_ricain_aux_fins, E_Divers_4._tes_vous_un_r_sident_aux_fins_d_548 AS E_Divers._tes_vous_un_r_sident_aux_fins_de_l_imp_t_d_un_autre_pays_que_le, H_Profil_financier_et_exp_rience_5.origine_du_premier_contact_310 AS H_Profil_financier_et_exp_rience.Origine_du_premier_contact, H_Profil_financier_et_exp_rience_5.exp_rience_en_investissement_311 AS H_Profil_financier_et_exp_rience.Exp_rience_en_investissement, H_Profil_financier_et_exp_rience_5.connaissance_en_placement_312 AS H_Profil_financier_et_exp_rience.Connaissance_en_placement, I_Bilan_et_revenu_6.actifs_non_reer_313 AS I_Bilan_et_revenu.Actifs_non_REER, I_Bilan_et_revenu_6.actifs_reer_ferr_cri_celi_314 AS I_Bilan_et_revenu.Actifs_REER_FERR_CRI_CELI, I_Bilan_et_revenu_6.actif_avoir_liquide_315 AS I_Bilan_et_revenu.Actif_Avoir_Liquide, I_Bilan_et_revenu_6.actifs_immobilier_316 AS I_Bilan_et_revenu.Actifs_immobilier, I_Bilan_et_revenu_6.passifs_hypoth_que_317 AS I_Bilan_et_revenu.Passifs_Hypoth_que, I_Bilan_et_revenu_6.passifs_cartes_de_cr_dit_et_autr_318 AS I_Bilan_et_revenu.Passifs_Cartes_de_cr_dit_et_autres_dettes, I_Bilan_et_revenu_6.revenu_annuel_319 AS I_Bilan_et_revenu.Revenu_annuel, I_Bilan_et_revenu_6.actifs_non_reer_avec_d_autres_in_505 AS I_Bilan_et_revenu.Actifs_Non_REER_Avec_d_autres_institutions_financi_re_, I_Bilan_et_revenu_6.numeric_actifs_reer_ferr_cri_cel_506 AS I_Bilan_et_revenu.Numeric_Actifs_REER_FERR_CRI_CELI_Avec_d_autres_institutions_fin, I_Bilan_et_revenu_6.revenu_annuel_numeric_508 AS I_Bilan_et_revenu.Revenu_annuel_numeric, Int_r_ts_personnels_7.hobby_349 AS Int_r_ts_personnels.Hobby, Int_r_ts_personnels_7.autre_355 AS Int_r_ts_personnels.Autre, Collectif_8.genre_d_entreprise_371 AS Collectif.Genre_d_entreprise, Collectif_8.date_de_constitution_372 AS Collectif.Date_de_constitution, Collectif_8.nombre_d_employ_s_373 AS Collectif.Nombre_d_employ_s, Collectif_8.chiffre_d_affaire_374 AS Collectif.Chiffre_d_affaire, Avantages_sociaux_9.assurance_collective_avec_377 AS Avantages_sociaux.Assurance_collective_avec, Avantages_sociaux_9.date_d_ch_ance_378 AS Avantages_sociaux.Date_d_ch_ance, Avantages_sociaux_9.garantie_courte_dur_e_379 AS Avantages_sociaux.Garantie_Courte_dur_e, Avantages_sociaux_9.garantie_longeu_dur_e_380 AS Avantages_sociaux.Garantie_Longeu_dur_e, Avantages_sociaux_9.garantie_maladie_graves_381 AS Avantages_sociaux.Garantie_Maladie_Graves, Avantages_sociaux_9.garantie_soins_domicile_382 AS Avantages_sociaux.Garantie_soins_domicile, Avantages_sociaux_9.garantie_assurance_vie_383 AS Avantages_sociaux.Garantie_assurance_vie, Avantages_sociaux_9.frais_m_dicaux_et_param_dicaux_384 AS Avantages_sociaux.Frais_m_dicaux_et_param_dicaux, Avantages_sociaux_9.lunette_385 AS Avantages_sociaux.Lunette, Avantages_sociaux_9.dentaire_386 AS Avantages_sociaux.Dentaire, Avantages_sociaux_9.commentaires_387 AS Avantages_sociaux.Commentaires, lcf_contact_note_10.note_388 AS lcf_contact_note.contact_note, lcf_individual_supplier_account_details_11.plan_type_399 AS lcf_individual_supplier_account_details.plan_type, lcf_individual_supplier_account_details_11.account_number_401 AS lcf_individual_supplier_account_details.account_number, lcf_individual_supplier_account_details_11.cotisation_403 AS lcf_individual_supplier_account_details.fee, lcf_individual_supplier_account_details_11.investment_provider_405 AS lcf_individual_supplier_account_details.investment_provider, lcf_individual_supplier_account_details_11.investment_code_407 AS lcf_individual_supplier_account_details.investment_code, lcf_individual_supplier_account_details_11.advisor_code_409 AS lcf_individual_supplier_account_details.advisor_code, lcf_individual_supplier_account_details_11.fair_market_value_411 AS lcf_individual_supplier_account_details.fair_market_value, lcf_individual_supplier_account_details_11.book_value_413 AS lcf_individual_supplier_account_details.book_value, lcf_individual_supplier_account_details_11.intermediary_account_415 AS lcf_individual_supplier_account_details.intermediary_account , lcf_individual_supplier_account_details_11.risk_417 AS lcf_individual_supplier_account_details.risk, lcf_registration_code_12.registration_code_397 AS lcf_registration_code.registration_code, lcf_individual_supplier_statuses_13.is_still_in_business__418 AS lcf_individual_supplier_statuses.is_still_in_business, lcf_individual_supplier_statuses_13.is_we_can_sell_them__419 AS lcf_individual_supplier_statuses.is_we_can_sell_them, lcf_employer_14.job_status_420 AS lcf_employer.employer_status, lcf_employer_14.name_of_the_employer_421 AS lcf_employer.employer_name, lcf_employer_14.emploi_447 AS lcf_employer.Emploi, lcf_employer_14.employeur_448 AS lcf_employer.Employeur, lcf_employer_14.secteur_d_activit__458 AS lcf_employer.Secteur_d_activit_, lcf_employer_14.position_562 AS lcf_employer.Position, lcf_organization_type_of_business_15.type_of_business_422 AS lcf_organization_type_of_business.type_of_business, Phone_varefication_16.phone_validated_424 AS Phone_varefication.Phone_validated, Impsition_client_aux_tats_unis_17._tes_vous_une_personne_des_tats__445 AS Impsition_client_aux_tats_unis._tes_vous_une_personne_des_tats_Unis_aux_fins_de_l_imp_t_sur_le_, Impsition_client_aux_tats_unis_17.si_oui_indiquez_votre_tax_indent_446 AS Impsition_client_aux_tats_unis.Si_oui_indiquez_votre_tax_indentification_number_TIN_tats_Unis, Conseiller_Code_18.dealer_code_459 AS Conseiller_Code.Dealer_Code, Conseiller_Code_18.rep_code_460 AS Conseiller_Code.Rep_Code, Conseiller_Code_18.nom_du_conseiller_481 AS Conseiller_Code.Nom_du_conseiller, Conseiller_Code_18.t_l_phone_482 AS Conseiller_Code.T_l_phone, Questionnaire_de_l_investisseur_19.quel_nonc_d_crit_le_mieux_vos_co_564 AS Questionnaire_de_l_investisseur.Quel_nonc_d_crit_le_mieux_vos_connaissances_en_mati_re_de_placem, Questionnaire_de_l_investisseur_19.quel_est_votre_revenu_annuel_de__565 AS Questionnaire_de_l_investisseur.Quel_est_votre_revenu_annuel_de_toutes_les_sources_, Questionnaire_de_l_investisseur_19.vos_sources_de_revenus_actuels_e_566 AS Questionnaire_de_l_investisseur.Vos_sources_de_revenus_actuels_et_futurs_sont_, Questionnaire_de_l_investisseur_19.comment_d_cririez_vous_votre_sit_567 AS Questionnaire_de_l_investisseur.Comment_d_cririez_vous_votre_situation_financi_re_globale_, Questionnaire_de_l_investisseur_19._combien_estimez_vous_votre_vale_568 AS Questionnaire_de_l_investisseur._combien_estimez_vous_votre_valeur_nette_placements_liquidit_s_m, Questionnaire_de_l_investisseur_19.quel_pourcentage_du_total_de_vos_569 AS Questionnaire_de_l_investisseur.Quel_pourcentage_du_total_de_vos_conomies_et_de_vos_placements_c, Questionnaire_de_l_investisseur_19.quel_est_votre_groupe_d_ge__570 AS Questionnaire_de_l_investisseur.Quel_est_votre_groupe_d_ge_, Questionnaire_de_l_investisseur_19.question_10_571 AS Questionnaire_de_l_investisseur.Question_10, Questionnaire_de_l_investisseur_19.questiion_11_572 AS Questionnaire_de_l_investisseur.Questiion_11, Questionnaire_de_l_investisseur_19.question_12_573 AS Questionnaire_de_l_investisseur.Question_12, Questionnaire_de_l_investisseur_19.question_13_574 AS Questionnaire_de_l_investisseur.Question_13, Questionnaire_de_l_investisseur_19.question_14_575 AS Questionnaire_de_l_investisseur.Question_14, Questionnaire_de_l_investisseur_19.question_15_576 AS Questionnaire_de_l_investisseur.Question_15, a.prefix_id AS prefix_id:label, a.suffix_id AS suffix_id:label, a.contact_type AS contact_type:label, a.gender_id AS gender_id:label, a.communication_style_id AS communication_style_id:label, a.preferred_communication_method AS preferred_communication_method:label, employer_id_21.display_name AS employer_id.display_name FROM civicrm_contact a LEFT JOIN civicrm_value_d_tails_clients_2 D_tails_clients_1 ON a.id = D_tails_clients_1.entity_id LEFT JOIN civicrm_value_ic_planification_de_la_retraite_12 IC_Planification_de_la_retraite_2 ON a.id = IC_Planification_de_la_retraite_2.entity_id LEFT JOIN civicrm_value_situation_familiale_48 Situation_familiale_3 ON a.id = Situation_familiale_3.entity_id LEFT JOIN civicrm_value_e_divers_54 E_Divers_4 ON a.id = E_Divers_4.entity_id LEFT JOIN civicrm_value_h_profil_financier_et_exp_rience_55 H_Profil_financier_et_exp_rience_5 ON a.id = H_Profil_financier_et_exp_rience_5.entity_id LEFT JOIN civicrm_value_i_bilan_et_revenu_56 I_Bilan_et_revenu_6 ON a.id = I_Bilan_et_revenu_6.entity_id LEFT JOIN civicrm_value_int_r_ts_personnels_68 Int_r_ts_personnels_7 ON a.id = Int_r_ts_personnels_7.entity_id LEFT JOIN civicrm_value_collectif_72 Collectif_8 ON a.id = Collectif_8.entity_id LEFT JOIN civicrm_value_avantages_soc_73 Avantages_sociaux_9 ON a.id = Avantages_sociaux_9.entity_id LEFT JOIN civicrm_value_note_74 lcf_contact_note_10 ON a.id = lcf_contact_note_10.entity_id LEFT JOIN civicrm_value_account_detai_78 lcf_individual_supplier_account_details_11 ON a.id = lcf_individual_supplier_account_details_11.entity_id LEFT JOIN civicrm_value_registration__80 lcf_registration_code_12 ON a.id = lcf_registration_code_12.entity_id LEFT JOIN civicrm_value_supplier_stat_81 lcf_individual_supplier_statuses_13 ON a.id = lcf_individual_supplier_statuses_13.entity_id LEFT JOIN civicrm_value_employeur_82 lcf_employer_14 ON a.id = lcf_employer_14.entity_id LEFT JOIN civicrm_value_type_of_busin_83 lcf_organization_type_of_business_15 ON a.id = lcf_organization_type_of_business_15.entity_id LEFT JOIN civicrm_value_phone_varefic_85 Phone_varefication_16 ON a.id = Phone_varefication_16.entity_id LEFT JOIN civicrm_value_impsition_cli_89 Impsition_client_aux_tats_unis_17 ON a.id = Impsition_client_aux_tats_unis_17.entity_id LEFT JOIN civicrm_value_conseiller_co_91 Conseiller_Code_18 ON a.id = Conseiller_Code_18.entity_id LEFT JOIN civicrm_value_questionnaire_103 Questionnaire_de_l_investisseur_19 ON a.id = Questionnaire_de_l_investisseur_19.entity_id LEFT JOIN civicrm_value_demographics D - Identification_20 ON a.id = D - Identification_20.entity_id LEFT JOIN civicrm_contact employer_id_21 ON a.employer_id = employer_id_21.id WHERE (a.id = "1") [nativecode=1054 ** Unknown column 'D' in 'on clause']"] )

    • lishaw1968
      lishaw1968 @lishaw1968 ·
      Author Developer

      There is also this:

      Nov 06 11:40:19 [warning] hook_civicrm_documents_entity_ref_spec should be updated to pass an array of parameter names to CRM_Utils_Hook::invoke(). Caller: CRM_Documents_Utils_HookInvoker::invoke Array ( [civi.tag] => deprecated )

      Nov 06 11:40:21 [warning] hook_civicrm_documents_entity_ref_spec should be updated to pass an array of parameter names to CRM_Utils_Hook::invoke(). Caller: CRM_Documents_Utils_HookInvoker::invoke Array ( [civi.tag] => deprecated )

    • lishaw1968
      lishaw1968 @lishaw1968 ·
      Author Developer

      I activated the debug and here the log

      Nov 06 11:50:09 [error] $Fatal Error Details = Array ( [callback] => Array ( [0] => CRM_Core_Error [1] => exceptionHandler )

      [code] => -19
[message] => DB Error: no such field
[mode] => 16
[debug_info] => SELECT `a`.`id` AS `id`, `a`.`contact_type` AS `contact_type`, `a`.`contact_sub_type` AS `contact_sub_type`, `a`.`do_not_email` AS `do_not_email`, `a`.`do_not_phone` AS `do_not_phone`, `a`.`do_not_mail` AS `do_not_mail`, `a`.`do_not_sms` AS `do_not_sms`, `a`.`do_not_trade` AS `do_not_trade`, `a`.`is_opt_out` AS `is_opt_out`, `a`.`legal_identifier` AS `legal_identifier`, `a`.`external_identifier` AS `external_identifier`, `a`.`sort_name` AS `sort_name`, `a`.`display_name` AS `display_name`, `a`.`nick_name` AS `nick_name`, `a`.`legal_name` AS `legal_name`, `a`.`image_URL` AS `image_URL`, `a`.`preferred_communication_method` AS `preferred_communication_method`, `a`.`preferred_language` AS `preferred_language`, `a`.`preferred_mail_format` AS `preferred_mail_format`, `a`.`hash` AS `hash`, `a`.`api_key` AS `api_key`, `a`.`source` AS `source`, `a`.`first_name` AS `first_name`, `a`.`middle_name` AS `middle_name`, `a`.`last_name` AS `last_name`, `a`.`prefix_id` AS `prefix_id`, `a`.`suffix_id` AS `suffix_id`, `a`.`formal_title` AS `formal_title`, `a`.`communication_style_id` AS `communication_style_id`, `a`.`email_greeting_id` AS `email_greeting_id`, `a`.`email_greeting_custom` AS `email_greeting_custom`, `a`.`email_greeting_display` AS `email_greeting_display`, `a`.`postal_greeting_id` AS `postal_greeting_id`, `a`.`postal_greeting_custom` AS `postal_greeting_custom`, `a`.`postal_greeting_display` AS `postal_greeting_display`, `a`.`addressee_id` AS `addressee_id`, `a`.`addressee_custom` AS `addressee_custom`, `a`.`addressee_display` AS `addressee_display`, `a`.`job_title` AS `job_title`, `a`.`gender_id` AS `gender_id`, `a`.`birth_date` AS `birth_date`, `a`.`is_deceased` AS `is_deceased`, `a`.`deceased_date` AS `deceased_date`, `a`.`household_name` AS `household_name`, `a`.`primary_contact_id` AS `primary_contact_id`, `a`.`organization_name` AS `organization_name`, `a`.`sic_code` AS `sic_code`, `a`.`user_unique_id` AS `user_unique_id`, `a`.`employer_id` AS `employer_id`, `a`.`is_deleted` AS `is_deleted`, `a`.`created_date` AS `created_date`, `a`.`modified_date` AS `modified_date`, `D_tails_clients_1`.`client_actif_4` AS `D_tails_clients.Client_actif`, `D_tails_clients_1`.`services_avec_nous_5` AS `D_tails_clients.Services_avec_nous`, `D_tails_clients_1`.`autre_info_184` AS `D_tails_clients.Autre_info`, `D_tails_clients_1`.`derni_re_mise_jour_354` AS `D_tails_clients.DERNI_RE_MISE_JOUR`, `D_tails_clients_1`.`affinit_s_366` AS `D_tails_clients.Affinit_s`, `D_tails_clients_1`.`groupe_100_367` AS `D_tails_clients.Groupe_100`, `D_tails_clients_1`.`r_f_re_368` AS `D_tails_clients.R_f_re`, `D_tails_clients_1`.`segment_369` AS `D_tails_clients.Segment`, `IC_Planification_de_la_retraite_2`.`inflation_67` AS `IC_Planification_de_la_retraite.Inflation`, `IC_Planification_de_la_retraite_2`.`age_de_la_retraite_68` AS `IC_Planification_de_la_retraite.Age_de_la_retraite`, `IC_Planification_de_la_retraite_2`.`reer_celi_69` AS `IC_Planification_de_la_retraite.REER_CELI`, `IC_Planification_de_la_retraite_2`.`revenu_annuel_d_sir__70` AS `IC_Planification_de_la_retraite.Revenu_annuel_d_sir_`, `Situation_familiale_3`.`_tat_civil_289` AS `Situation_familiale._tat_civil`, `Situation_familiale_3`.`pr_nom_conjoint_290` AS `Situation_familiale.Pr_nom_conjoint`, `Situation_familiale_3`.`nom_conjoint_291` AS `Situation_familiale.Nom_conjoint`, `Situation_familiale_3`.`date_de_naissance_conjoint_292` AS `Situation_familiale.Date_de_naissance_conjoint`, `Situation_familiale_3`.`nombre_de_personnes_charge_293` AS `Situation_familiale.Nombre_de_personnes_charge`, `E_Divers_4`.`ch_que_sp_cimen_306` AS `E_Divers.Ch_que_sp_cimen`, `E_Divers_4`.`une_autre_personne_est_elle_auto_307` AS `E_Divers.Une_autre_personne_est_elle_autoris_e_donner_des_ordre_pour_ce_c`, `E_Divers_4`.`le_compte_est_il_exploit_dans_l__308` AS `E_Divers.Le_compte_est_il_exploit_dans_l_int_r_t_d_un_tier`, `E_Divers_4`.`num_ro_de_la_succursale_478` AS `E_Divers.Num_ro_de_la_succursale`, `E_Divers_4`.`num_ro_de_la_banque_479` AS `E_Divers.Num_ro_de_la_banque`, `E_Divers_4`.`num_ro_de_compte_480` AS `E_Divers.Num_ro_de_compte`, `E_Divers_4`.`_tes_vous_une_personne_politique_546` AS `E_Divers._tes_vous_une_personne_politiquement_vuln_rable_ou_un_dirigeant_`, `E_Divers_4`.`_tes_vous_un_r_sident_am_ricain__547` AS `E_Divers._tes_vous_un_r_sident_am_ricain_ou_un_citoyen_am_ricain_aux_fins`, `E_Divers_4`.`_tes_vous_un_r_sident_aux_fins_d_548` AS `E_Divers._tes_vous_un_r_sident_aux_fins_de_l_imp_t_d_un_autre_pays_que_le`, `H_Profil_financier_et_exp_rience_5`.`origine_du_premier_contact_310` AS `H_Profil_financier_et_exp_rience.Origine_du_premier_contact`, `H_Profil_financier_et_exp_rience_5`.`exp_rience_en_investissement_311` AS `H_Profil_financier_et_exp_rience.Exp_rience_en_investissement`, `H_Profil_financier_et_exp_rience_5`.`connaissance_en_placement_312` AS `H_Profil_financier_et_exp_rience.Connaissance_en_placement`, `I_Bilan_et_revenu_6`.`actifs_non_reer_313` AS `I_Bilan_et_revenu.Actifs_non_REER`, `I_Bilan_et_revenu_6`.`actifs_reer_ferr_cri_celi_314` AS `I_Bilan_et_revenu.Actifs_REER_FERR_CRI_CELI`, `I_Bilan_et_revenu_6`.`actif_avoir_liquide_315` AS `I_Bilan_et_revenu.Actif_Avoir_Liquide`, `I_Bilan_et_revenu_6`.`actifs_immobilier_316` AS `I_Bilan_et_revenu.Actifs_immobilier`, `I_Bilan_et_revenu_6`.`passifs_hypoth_que_317` AS `I_Bilan_et_revenu.Passifs_Hypoth_que`, `I_Bilan_et_revenu_6`.`passifs_cartes_de_cr_dit_et_autr_318` AS `I_Bilan_et_revenu.Passifs_Cartes_de_cr_dit_et_autres_dettes`, `I_Bilan_et_revenu_6`.`revenu_annuel_319` AS `I_Bilan_et_revenu.Revenu_annuel`, `I_Bilan_et_revenu_6`.`actifs_non_reer_avec_d_autres_in_505` AS `I_Bilan_et_revenu.Actifs_Non_REER_Avec_d_autres_institutions_financi_re_`, `I_Bilan_et_revenu_6`.`numeric_actifs_reer_ferr_cri_cel_506` AS `I_Bilan_et_revenu.Numeric_Actifs_REER_FERR_CRI_CELI_Avec_d_autres_institutions_fin`, `I_Bilan_et_revenu_6`.`revenu_annuel_numeric_508` AS `I_Bilan_et_revenu.Revenu_annuel_numeric`, `Int_r_ts_personnels_7`.`hobby_349` AS `Int_r_ts_personnels.Hobby`, `Int_r_ts_personnels_7`.`autre_355` AS `Int_r_ts_personnels.Autre`, `Collectif_8`.`genre_d_entreprise_371` AS `Collectif.Genre_d_entreprise`, `Collectif_8`.`date_de_constitution_372` AS `Collectif.Date_de_constitution`, `Collectif_8`.`nombre_d_employ_s_373` AS `Collectif.Nombre_d_employ_s`, `Collectif_8`.`chiffre_d_affaire_374` AS `Collectif.Chiffre_d_affaire`, `Avantages_sociaux_9`.`assurance_collective_avec_377` AS `Avantages_sociaux.Assurance_collective_avec`, `Avantages_sociaux_9`.`date_d_ch_ance_378` AS `Avantages_sociaux.Date_d_ch_ance`, `Avantages_sociaux_9`.`garantie_courte_dur_e_379` AS `Avantages_sociaux.Garantie_Courte_dur_e`, `Avantages_sociaux_9`.`garantie_longeu_dur_e_380` AS `Avantages_sociaux.Garantie_Longeu_dur_e`, `Avantages_sociaux_9`.`garantie_maladie_graves_381` AS `Avantages_sociaux.Garantie_Maladie_Graves`, `Avantages_sociaux_9`.`garantie_soins_domicile_382` AS `Avantages_sociaux.Garantie_soins_domicile`, `Avantages_sociaux_9`.`garantie_assurance_vie_383` AS `Avantages_sociaux.Garantie_assurance_vie`, `Avantages_sociaux_9`.`frais_m_dicaux_et_param_dicaux_384` AS `Avantages_sociaux.Frais_m_dicaux_et_param_dicaux`, `Avantages_sociaux_9`.`lunette_385` AS `Avantages_sociaux.Lunette`, `Avantages_sociaux_9`.`dentaire_386` AS `Avantages_sociaux.Dentaire`, `Avantages_sociaux_9`.`commentaires_387` AS `Avantages_sociaux.Commentaires`, `lcf_contact_note_10`.`note_388` AS `lcf_contact_note.contact_note`, `lcf_individual_supplier_account_details_11`.`plan_type_399` AS `lcf_individual_supplier_account_details.plan_type`, `lcf_individual_supplier_account_details_11`.`account_number_401` AS `lcf_individual_supplier_account_details.account_number`, `lcf_individual_supplier_account_details_11`.`cotisation_403` AS `lcf_individual_supplier_account_details.fee`, `lcf_individual_supplier_account_details_11`.`investment_provider_405` AS `lcf_individual_supplier_account_details.investment_provider`, `lcf_individual_supplier_account_details_11`.`investment_code_407` AS `lcf_individual_supplier_account_details.investment_code`, `lcf_individual_supplier_account_details_11`.`advisor_code_409` AS `lcf_individual_supplier_account_details.advisor_code`, `lcf_individual_supplier_account_details_11`.`fair_market_value_411` AS `lcf_individual_supplier_account_details.fair_market_value`, `lcf_individual_supplier_account_details_11`.`book_value_413` AS `lcf_individual_supplier_account_details.book_value`, `lcf_individual_supplier_account_details_11`.`intermediary_account_415` AS `lcf_individual_supplier_account_details.intermediary_account `, `lcf_individual_supplier_account_details_11`.`risk_417` AS `lcf_individual_supplier_account_details.risk`, `lcf_registration_code_12`.`registration_code_397` AS `lcf_registration_code.registration_code`, `lcf_individual_supplier_statuses_13`.`is_still_in_business__418` AS `lcf_individual_supplier_statuses.is_still_in_business`, `lcf_individual_supplier_statuses_13`.`is_we_can_sell_them__419` AS `lcf_individual_supplier_statuses.is_we_can_sell_them`, `lcf_employer_14`.`job_status_420` AS `lcf_employer.employer_status`, `lcf_employer_14`.`name_of_the_employer_421` AS `lcf_employer.employer_name`, `lcf_employer_14`.`emploi_447` AS `lcf_employer.Emploi`, `lcf_employer_14`.`employeur_448` AS `lcf_employer.Employeur`, `lcf_employer_14`.`secteur_d_activit__458` AS `lcf_employer.Secteur_d_activit_`, `lcf_employer_14`.`position_562` AS `lcf_employer.Position`, `lcf_organization_type_of_business_15`.`type_of_business_422` AS `lcf_organization_type_of_business.type_of_business`, `Phone_varefication_16`.`phone_validated_424` AS `Phone_varefication.Phone_validated`, `Impsition_client_aux_tats_unis_17`.`_tes_vous_une_personne_des_tats__445` AS `Impsition_client_aux_tats_unis._tes_vous_une_personne_des_tats_Unis_aux_fins_de_l_imp_t_sur_le_`, `Impsition_client_aux_tats_unis_17`.`si_oui_indiquez_votre_tax_indent_446` AS `Impsition_client_aux_tats_unis.Si_oui_indiquez_votre_tax_indentification_number_TIN_tats_Unis`, `Conseiller_Code_18`.`dealer_code_459` AS `Conseiller_Code.Dealer_Code`, `Conseiller_Code_18`.`rep_code_460` AS `Conseiller_Code.Rep_Code`, `Conseiller_Code_18`.`nom_du_conseiller_481` AS `Conseiller_Code.Nom_du_conseiller`, `Conseiller_Code_18`.`t_l_phone_482` AS `Conseiller_Code.T_l_phone`, `Questionnaire_de_l_investisseur_19`.`quel_nonc_d_crit_le_mieux_vos_co_564` AS `Questionnaire_de_l_investisseur.Quel_nonc_d_crit_le_mieux_vos_connaissances_en_mati_re_de_placem`, `Questionnaire_de_l_investisseur_19`.`quel_est_votre_revenu_annuel_de__565` AS `Questionnaire_de_l_investisseur.Quel_est_votre_revenu_annuel_de_toutes_les_sources_`, `Questionnaire_de_l_investisseur_19`.`vos_sources_de_revenus_actuels_e_566` AS `Questionnaire_de_l_investisseur.Vos_sources_de_revenus_actuels_et_futurs_sont_`, `Questionnaire_de_l_investisseur_19`.`comment_d_cririez_vous_votre_sit_567` AS `Questionnaire_de_l_investisseur.Comment_d_cririez_vous_votre_situation_financi_re_globale_`, `Questionnaire_de_l_investisseur_19`.`_combien_estimez_vous_votre_vale_568` AS `Questionnaire_de_l_investisseur._combien_estimez_vous_votre_valeur_nette_placements_liquidit_s_m`, `Questionnaire_de_l_investisseur_19`.`quel_pourcentage_du_total_de_vos_569` AS `Questionnaire_de_l_investisseur.Quel_pourcentage_du_total_de_vos_conomies_et_de_vos_placements_c`, `Questionnaire_de_l_investisseur_19`.`quel_est_votre_groupe_d_ge__570` AS `Questionnaire_de_l_investisseur.Quel_est_votre_groupe_d_ge_`, `Questionnaire_de_l_investisseur_19`.`question_10_571` AS `Questionnaire_de_l_investisseur.Question_10`, `Questionnaire_de_l_investisseur_19`.`questiion_11_572` AS `Questionnaire_de_l_investisseur.Questiion_11`, `Questionnaire_de_l_investisseur_19`.`question_12_573` AS `Questionnaire_de_l_investisseur.Question_12`, `Questionnaire_de_l_investisseur_19`.`question_13_574` AS `Questionnaire_de_l_investisseur.Question_13`, `Questionnaire_de_l_investisseur_19`.`question_14_575` AS `Questionnaire_de_l_investisseur.Question_14`, `Questionnaire_de_l_investisseur_19`.`question_15_576` AS `Questionnaire_de_l_investisseur.Question_15`, `a`.`prefix_id` AS `prefix_id:label`, `a`.`suffix_id` AS `suffix_id:label`, `a`.`contact_type` AS `contact_type:label`, `a`.`gender_id` AS `gender_id:label`, `a`.`communication_style_id` AS `communication_style_id:label`, `a`.`preferred_communication_method` AS `preferred_communication_method:label`, `employer_id_21`.`display_name` AS `employer_id.display_name`

      FROM civicrm_contact a LEFT JOIN civicrm_value_d_tails_clients_2 D_tails_clients_1 ON a.id = D_tails_clients_1.entity_id LEFT JOIN civicrm_value_ic_planification_de_la_retraite_12 IC_Planification_de_la_retraite_2 ON a.id = IC_Planification_de_la_retraite_2.entity_id LEFT JOIN civicrm_value_situation_familiale_48 Situation_familiale_3 ON a.id = Situation_familiale_3.entity_id LEFT JOIN civicrm_value_e_divers_54 E_Divers_4 ON a.id = E_Divers_4.entity_id LEFT JOIN civicrm_value_h_profil_financier_et_exp_rience_55 H_Profil_financier_et_exp_rience_5 ON a.id = H_Profil_financier_et_exp_rience_5.entity_id LEFT JOIN civicrm_value_i_bilan_et_revenu_56 I_Bilan_et_revenu_6 ON a.id = I_Bilan_et_revenu_6.entity_id LEFT JOIN civicrm_value_int_r_ts_personnels_68 Int_r_ts_personnels_7 ON a.id = Int_r_ts_personnels_7.entity_id LEFT JOIN civicrm_value_collectif_72 Collectif_8 ON a.id = Collectif_8.entity_id LEFT JOIN civicrm_value_avantages_soc_73 Avantages_sociaux_9 ON a.id = Avantages_sociaux_9.entity_id LEFT JOIN civicrm_value_note_74 lcf_contact_note_10 ON a.id = lcf_contact_note_10.entity_id LEFT JOIN civicrm_value_account_detai_78 lcf_individual_supplier_account_details_11 ON a.id = lcf_individual_supplier_account_details_11.entity_id LEFT JOIN civicrm_value_registration__80 lcf_registration_code_12 ON a.id = lcf_registration_code_12.entity_id LEFT JOIN civicrm_value_supplier_stat_81 lcf_individual_supplier_statuses_13 ON a.id = lcf_individual_supplier_statuses_13.entity_id LEFT JOIN civicrm_value_employeur_82 lcf_employer_14 ON a.id = lcf_employer_14.entity_id LEFT JOIN civicrm_value_type_of_busin_83 lcf_organization_type_of_business_15 ON a.id = lcf_organization_type_of_business_15.entity_id LEFT JOIN civicrm_value_phone_varefic_85 Phone_varefication_16 ON a.id = Phone_varefication_16.entity_id LEFT JOIN civicrm_value_impsition_cli_89 Impsition_client_aux_tats_unis_17 ON a.id = Impsition_client_aux_tats_unis_17.entity_id LEFT JOIN civicrm_value_conseiller_co_91 Conseiller_Code_18 ON a.id = Conseiller_Code_18.entity_id LEFT JOIN civicrm_value_questionnaire_103 Questionnaire_de_l_investisseur_19 ON a.id = Questionnaire_de_l_investisseur_19.entity_id LEFT JOIN civicrm_value_demographics D - Identification_20 ON a.id = D - Identification_20.entity_id LEFT JOIN civicrm_contact employer_id_21 ON a.employer_id = employer_id_21.id WHERE (a.id = "1") [nativecode=1054 ** Unknown column 'D' in 'on clause'] [type] => DB_Error [user_info] => SELECT a.id AS id, a.contact_type AS contact_type, a.contact_sub_type AS contact_sub_type, a.do_not_email AS do_not_email, a.do_not_phone AS do_not_phone, a.do_not_mail AS do_not_mail, a.do_not_sms AS do_not_sms, a.do_not_trade AS do_not_trade, a.is_opt_out AS is_opt_out, a.legal_identifier AS legal_identifier, a.external_identifier AS external_identifier, a.sort_name AS sort_name, a.display_name AS display_name, a.nick_name AS nick_name, a.legal_name AS legal_name, a.image_URL AS image_URL, a.preferred_communication_method AS preferred_communication_method, a.preferred_language AS preferred_language, a.preferred_mail_format AS preferred_mail_format, a.hash AS hash, a.api_key AS api_key, a.source AS source, a.first_name AS first_name, a.middle_name AS middle_name, a.last_name AS last_name, a.prefix_id AS prefix_id, a.suffix_id AS suffix_id, a.formal_title AS formal_title, a.communication_style_id AS communication_style_id, a.email_greeting_id AS email_greeting_id, a.email_greeting_custom AS email_greeting_custom, a.email_greeting_display AS email_greeting_display, a.postal_greeting_id AS postal_greeting_id, a.postal_greeting_custom AS postal_greeting_custom, a.postal_greeting_display AS postal_greeting_display, a.addressee_id AS addressee_id, a.addressee_custom AS addressee_custom, a.addressee_display AS addressee_display, a.job_title AS job_title, a.gender_id AS gender_id, a.birth_date AS birth_date, a.is_deceased AS is_deceased, a.deceased_date AS deceased_date, a.household_name AS household_name, a.primary_contact_id AS primary_contact_id, a.organization_name AS organization_name, a.sic_code AS sic_code, a.user_unique_id AS user_unique_id, a.employer_id AS employer_id, a.is_deleted AS is_deleted, a.created_date AS created_date, a.modified_date AS modified_date, D_tails_clients_1.client_actif_4 AS D_tails_clients.Client_actif, D_tails_clients_1.services_avec_nous_5 AS D_tails_clients.Services_avec_nous, D_tails_clients_1.autre_info_184 AS D_tails_clients.Autre_info, D_tails_clients_1.derni_re_mise_jour_354 AS D_tails_clients.DERNI_RE_MISE_JOUR, D_tails_clients_1.affinit_s_366 AS D_tails_clients.Affinit_s, D_tails_clients_1.groupe_100_367 AS D_tails_clients.Groupe_100, D_tails_clients_1.r_f_re_368 AS D_tails_clients.R_f_re, D_tails_clients_1.segment_369 AS D_tails_clients.Segment, IC_Planification_de_la_retraite_2.inflation_67 AS IC_Planification_de_la_retraite.Inflation, IC_Planification_de_la_retraite_2.age_de_la_retraite_68 AS IC_Planification_de_la_retraite.Age_de_la_retraite, IC_Planification_de_la_retraite_2.reer_celi_69 AS IC_Planification_de_la_retraite.REER_CELI, IC_Planification_de_la_retraite_2.revenu_annuel_d_sir__70 AS IC_Planification_de_la_retraite.Revenu_annuel_d_sir_, Situation_familiale_3._tat_civil_289 AS Situation_familiale._tat_civil, Situation_familiale_3.pr_nom_conjoint_290 AS Situation_familiale.Pr_nom_conjoint, Situation_familiale_3.nom_conjoint_291 AS Situation_familiale.Nom_conjoint, Situation_familiale_3.date_de_naissance_conjoint_292 AS Situation_familiale.Date_de_naissance_conjoint, Situation_familiale_3.nombre_de_personnes_charge_293 AS Situation_familiale.Nombre_de_personnes_charge, E_Divers_4.ch_que_sp_cimen_306 AS E_Divers.Ch_que_sp_cimen, E_Divers_4.une_autre_personne_est_elle_auto_307 AS E_Divers.Une_autre_personne_est_elle_autoris_e_donner_des_ordre_pour_ce_c, E_Divers_4.le_compte_est_il_exploit_dans_l__308 AS E_Divers.Le_compte_est_il_exploit_dans_l_int_r_t_d_un_tier, E_Divers_4.num_ro_de_la_succursale_478 AS E_Divers.Num_ro_de_la_succursale, E_Divers_4.num_ro_de_la_banque_479 AS E_Divers.Num_ro_de_la_banque, E_Divers_4.num_ro_de_compte_480 AS E_Divers.Num_ro_de_compte, E_Divers_4._tes_vous_une_personne_politique_546 AS E_Divers._tes_vous_une_personne_politiquement_vuln_rable_ou_un_dirigeant_, E_Divers_4._tes_vous_un_r_sident_am_ricain__547 AS E_Divers._tes_vous_un_r_sident_am_ricain_ou_un_citoyen_am_ricain_aux_fins, E_Divers_4._tes_vous_un_r_sident_aux_fins_d_548 AS E_Divers._tes_vous_un_r_sident_aux_fins_de_l_imp_t_d_un_autre_pays_que_le, H_Profil_financier_et_exp_rience_5.origine_du_premier_contact_310 AS H_Profil_financier_et_exp_rience.Origine_du_premier_contact, H_Profil_financier_et_exp_rience_5.exp_rience_en_investissement_311 AS H_Profil_financier_et_exp_rience.Exp_rience_en_investissement, H_Profil_financier_et_exp_rience_5.connaissance_en_placement_312 AS H_Profil_financier_et_exp_rience.Connaissance_en_placement, I_Bilan_et_revenu_6.actifs_non_reer_313 AS I_Bilan_et_revenu.Actifs_non_REER, I_Bilan_et_revenu_6.actifs_reer_ferr_cri_celi_314 AS I_Bilan_et_revenu.Actifs_REER_FERR_CRI_CELI, I_Bilan_et_revenu_6.actif_avoir_liquide_315 AS I_Bilan_et_revenu.Actif_Avoir_Liquide, I_Bilan_et_revenu_6.actifs_immobilier_316 AS I_Bilan_et_revenu.Actifs_immobilier, I_Bilan_et_revenu_6.passifs_hypoth_que_317 AS I_Bilan_et_revenu.Passifs_Hypoth_que, I_Bilan_et_revenu_6.passifs_cartes_de_cr_dit_et_autr_318 AS I_Bilan_et_revenu.Passifs_Cartes_de_cr_dit_et_autres_dettes, I_Bilan_et_revenu_6.revenu_annuel_319 AS I_Bilan_et_revenu.Revenu_annuel, I_Bilan_et_revenu_6.actifs_non_reer_avec_d_autres_in_505 AS I_Bilan_et_revenu.Actifs_Non_REER_Avec_d_autres_institutions_financi_re_, I_Bilan_et_revenu_6.numeric_actifs_reer_ferr_cri_cel_506 AS I_Bilan_et_revenu.Numeric_Actifs_REER_FERR_CRI_CELI_Avec_d_autres_institutions_fin, I_Bilan_et_revenu_6.revenu_annuel_numeric_508 AS I_Bilan_et_revenu.Revenu_annuel_numeric, Int_r_ts_personnels_7.hobby_349 AS Int_r_ts_personnels.Hobby, Int_r_ts_personnels_7.autre_355 AS Int_r_ts_personnels.Autre, Collectif_8.genre_d_entreprise_371 AS Collectif.Genre_d_entreprise, Collectif_8.date_de_constitution_372 AS Collectif.Date_de_constitution, Collectif_8.nombre_d_employ_s_373 AS Collectif.Nombre_d_employ_s, Collectif_8.chiffre_d_affaire_374 AS Collectif.Chiffre_d_affaire, Avantages_sociaux_9.assurance_collective_avec_377 AS Avantages_sociaux.Assurance_collective_avec, Avantages_sociaux_9.date_d_ch_ance_378 AS Avantages_sociaux.Date_d_ch_ance, Avantages_sociaux_9.garantie_courte_dur_e_379 AS Avantages_sociaux.Garantie_Courte_dur_e, Avantages_sociaux_9.garantie_longeu_dur_e_380 AS Avantages_sociaux.Garantie_Longeu_dur_e, Avantages_sociaux_9.garantie_maladie_graves_381 AS Avantages_sociaux.Garantie_Maladie_Graves, Avantages_sociaux_9.garantie_soins_domicile_382 AS Avantages_sociaux.Garantie_soins_domicile, Avantages_sociaux_9.garantie_assurance_vie_383 AS Avantages_sociaux.Garantie_assurance_vie, Avantages_sociaux_9.frais_m_dicaux_et_param_dicaux_384 AS Avantages_sociaux.Frais_m_dicaux_et_param_dicaux, Avantages_sociaux_9.lunette_385 AS Avantages_sociaux.Lunette, Avantages_sociaux_9.dentaire_386 AS Avantages_sociaux.Dentaire, Avantages_sociaux_9.commentaires_387 AS Avantages_sociaux.Commentaires, lcf_contact_note_10.note_388 AS lcf_contact_note.contact_note, lcf_individual_supplier_account_details_11.plan_type_399 AS lcf_individual_supplier_account_details.plan_type, lcf_individual_supplier_account_details_11.account_number_401 AS lcf_individual_supplier_account_details.account_number, lcf_individual_supplier_account_details_11.cotisation_403 AS lcf_individual_supplier_account_details.fee, lcf_individual_supplier_account_details_11.investment_provider_405 AS lcf_individual_supplier_account_details.investment_provider, lcf_individual_supplier_account_details_11.investment_code_407 AS lcf_individual_supplier_account_details.investment_code, lcf_individual_supplier_account_details_11.advisor_code_409 AS lcf_individual_supplier_account_details.advisor_code, lcf_individual_supplier_account_details_11.fair_market_value_411 AS lcf_individual_supplier_account_details.fair_market_value, lcf_individual_supplier_account_details_11.book_value_413 AS lcf_individual_supplier_account_details.book_value, lcf_individual_supplier_account_details_11.intermediary_account_415 AS lcf_individual_supplier_account_details.intermediary_account , lcf_individual_supplier_account_details_11.risk_417 AS lcf_individual_supplier_account_details.risk, lcf_registration_code_12.registration_code_397 AS lcf_registration_code.registration_code, lcf_individual_supplier_statuses_13.is_still_in_business__418 AS lcf_individual_supplier_statuses.is_still_in_business, lcf_individual_supplier_statuses_13.is_we_can_sell_them__419 AS lcf_individual_supplier_statuses.is_we_can_sell_them, lcf_employer_14.job_status_420 AS lcf_employer.employer_status, lcf_employer_14.name_of_the_employer_421 AS lcf_employer.employer_name, lcf_employer_14.emploi_447 AS lcf_employer.Emploi, lcf_employer_14.employeur_448 AS lcf_employer.Employeur, lcf_employer_14.secteur_d_activit__458 AS lcf_employer.Secteur_d_activit_, lcf_employer_14.position_562 AS lcf_employer.Position, lcf_organization_type_of_business_15.type_of_business_422 AS lcf_organization_type_of_business.type_of_business, Phone_varefication_16.phone_validated_424 AS Phone_varefication.Phone_validated, Impsition_client_aux_tats_unis_17._tes_vous_une_personne_des_tats__445 AS Impsition_client_aux_tats_unis._tes_vous_une_personne_des_tats_Unis_aux_fins_de_l_imp_t_sur_le_, Impsition_client_aux_tats_unis_17.si_oui_indiquez_votre_tax_indent_446 AS Impsition_client_aux_tats_unis.Si_oui_indiquez_votre_tax_indentification_number_TIN_tats_Unis, Conseiller_Code_18.dealer_code_459 AS Conseiller_Code.Dealer_Code, Conseiller_Code_18.rep_code_460 AS Conseiller_Code.Rep_Code, Conseiller_Code_18.nom_du_conseiller_481 AS Conseiller_Code.Nom_du_conseiller, Conseiller_Code_18.t_l_phone_482 AS Conseiller_Code.T_l_phone, Questionnaire_de_l_investisseur_19.quel_nonc_d_crit_le_mieux_vos_co_564 AS Questionnaire_de_l_investisseur.Quel_nonc_d_crit_le_mieux_vos_connaissances_en_mati_re_de_placem, Questionnaire_de_l_investisseur_19.quel_est_votre_revenu_annuel_de__565 AS Questionnaire_de_l_investisseur.Quel_est_votre_revenu_annuel_de_toutes_les_sources_, Questionnaire_de_l_investisseur_19.vos_sources_de_revenus_actuels_e_566 AS Questionnaire_de_l_investisseur.Vos_sources_de_revenus_actuels_et_futurs_sont_, Questionnaire_de_l_investisseur_19.comment_d_cririez_vous_votre_sit_567 AS Questionnaire_de_l_investisseur.Comment_d_cririez_vous_votre_situation_financi_re_globale_, Questionnaire_de_l_investisseur_19._combien_estimez_vous_votre_vale_568 AS Questionnaire_de_l_investisseur._combien_estimez_vous_votre_valeur_nette_placements_liquidit_s_m, Questionnaire_de_l_investisseur_19.quel_pourcentage_du_total_de_vos_569 AS Questionnaire_de_l_investisseur.Quel_pourcentage_du_total_de_vos_conomies_et_de_vos_placements_c, Questionnaire_de_l_investisseur_19.quel_est_votre_groupe_d_ge__570 AS Questionnaire_de_l_investisseur.Quel_est_votre_groupe_d_ge_, Questionnaire_de_l_investisseur_19.question_10_571 AS Questionnaire_de_l_investisseur.Question_10, Questionnaire_de_l_investisseur_19.questiion_11_572 AS Questionnaire_de_l_investisseur.Questiion_11, Questionnaire_de_l_investisseur_19.question_12_573 AS Questionnaire_de_l_investisseur.Question_12, Questionnaire_de_l_investisseur_19.question_13_574 AS Questionnaire_de_l_investisseur.Question_13, Questionnaire_de_l_investisseur_19.question_14_575 AS Questionnaire_de_l_investisseur.Question_14, Questionnaire_de_l_investisseur_19.question_15_576 AS Questionnaire_de_l_investisseur.Question_15, a.prefix_id AS prefix_id:label, a.suffix_id AS suffix_id:label, a.contact_type AS contact_type:label, a.gender_id AS gender_id:label, a.communication_style_id AS communication_style_id:label, a.preferred_communication_method AS preferred_communication_method:label, employer_id_21.display_name AS employer_id.display_name FROM civicrm_contact a LEFT JOIN civicrm_value_d_tails_clients_2 D_tails_clients_1 ON a.id = D_tails_clients_1.entity_id LEFT JOIN civicrm_value_ic_planification_de_la_retraite_12 IC_Planification_de_la_retraite_2 ON a.id = IC_Planification_de_la_retraite_2.entity_id LEFT JOIN civicrm_value_situation_familiale_48 Situation_familiale_3 ON a.id = Situation_familiale_3.entity_id LEFT JOIN civicrm_value_e_divers_54 E_Divers_4 ON a.id = E_Divers_4.entity_id LEFT JOIN civicrm_value_h_profil_financier_et_exp_rience_55 H_Profil_financier_et_exp_rience_5 ON a.id = H_Profil_financier_et_exp_rience_5.entity_id LEFT JOIN civicrm_value_i_bilan_et_revenu_56 I_Bilan_et_revenu_6 ON a.id = I_Bilan_et_revenu_6.entity_id LEFT JOIN civicrm_value_int_r_ts_personnels_68 Int_r_ts_personnels_7 ON a.id = Int_r_ts_personnels_7.entity_id LEFT JOIN civicrm_value_collectif_72 Collectif_8 ON a.id = Collectif_8.entity_id LEFT JOIN civicrm_value_avantages_soc_73 Avantages_sociaux_9 ON a.id = Avantages_sociaux_9.entity_id LEFT JOIN civicrm_value_note_74 lcf_contact_note_10 ON a.id = lcf_contact_note_10.entity_id LEFT JOIN civicrm_value_account_detai_78 lcf_individual_supplier_account_details_11 ON a.id = lcf_individual_supplier_account_details_11.entity_id LEFT JOIN civicrm_value_registration__80 lcf_registration_code_12 ON a.id = lcf_registration_code_12.entity_id LEFT JOIN civicrm_value_supplier_stat_81 lcf_individual_supplier_statuses_13 ON a.id = lcf_individual_supplier_statuses_13.entity_id LEFT JOIN civicrm_value_employeur_82 lcf_employer_14 ON a.id = lcf_employer_14.entity_id LEFT JOIN civicrm_value_type_of_busin_83 lcf_organization_type_of_business_15 ON a.id = lcf_organization_type_of_business_15.entity_id LEFT JOIN civicrm_value_phone_varefic_85 Phone_varefication_16 ON a.id = Phone_varefication_16.entity_id LEFT JOIN civicrm_value_impsition_cli_89 Impsition_client_aux_tats_unis_17 ON a.id = Impsition_client_aux_tats_unis_17.entity_id LEFT JOIN civicrm_value_conseiller_co_91 Conseiller_Code_18 ON a.id = Conseiller_Code_18.entity_id LEFT JOIN civicrm_value_questionnaire_103 Questionnaire_de_l_investisseur_19 ON a.id = Questionnaire_de_l_investisseur_19.entity_id LEFT JOIN civicrm_value_demographics D - Identification_20 ON a.id = D - Identification_20.entity_id LEFT JOIN civicrm_contact employer_id_21 ON a.employer_id = employer_id_21.id WHERE (a.id = "1") [nativecode=1054 ** Unknown column 'D' in 'on clause'] [to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::exceptionHandler prefix="" info="SELECT a.id AS id, a.contact_type AS contact_type, a.contact_sub_type AS contact_sub_type, a.do_not_email AS do_not_email, a.do_not_phone AS do_not_phone, a.do_not_mail AS do_not_mail, a.do_not_sms AS do_not_sms, a.do_not_trade AS do_not_trade, a.is_opt_out AS is_opt_out, a.legal_identifier AS legal_identifier, a.external_identifier AS external_identifier, a.sort_name AS sort_name, a.display_name AS display_name, a.nick_name AS nick_name, a.legal_name AS legal_name, a.image_URL AS image_URL, a.preferred_communication_method AS preferred_communication_method, a.preferred_language AS preferred_language, a.preferred_mail_format AS preferred_mail_format, a.hash AS hash, a.api_key AS api_key, a.source AS source, a.first_name AS first_name, a.middle_name AS middle_name, a.last_name AS last_name, a.prefix_id AS prefix_id, a.suffix_id AS suffix_id, a.formal_title AS formal_title, a.communication_style_id AS communication_style_id, a.email_greeting_id AS email_greeting_id, a.email_greeting_custom AS email_greeting_custom, a.email_greeting_display AS email_greeting_display, a.postal_greeting_id AS postal_greeting_id, a.postal_greeting_custom AS postal_greeting_custom, a.postal_greeting_display AS postal_greeting_display, a.addressee_id AS addressee_id, a.addressee_custom AS addressee_custom, a.addressee_display AS addressee_display, a.job_title AS job_title, a.gender_id AS gender_id, a.birth_date AS birth_date, a.is_deceased AS is_deceased, a.deceased_date AS deceased_date, a.household_name AS household_name, a.primary_contact_id AS primary_contact_id, a.organization_name AS organization_name, a.sic_code AS sic_code, a.user_unique_id AS user_unique_id, a.employer_id AS employer_id, a.is_deleted AS is_deleted, a.created_date AS created_date, a.modified_date AS modified_date, D_tails_clients_1.client_actif_4 AS D_tails_clients.Client_actif, D_tails_clients_1.services_avec_nous_5 AS D_tails_clients.Services_avec_nous, D_tails_clients_1.autre_info_184 AS D_tails_clients.Autre_info, D_tails_clients_1.derni_re_mise_jour_354 AS D_tails_clients.DERNI_RE_MISE_JOUR, D_tails_clients_1.affinit_s_366 AS D_tails_clients.Affinit_s, D_tails_clients_1.groupe_100_367 AS D_tails_clients.Groupe_100, D_tails_clients_1.r_f_re_368 AS D_tails_clients.R_f_re, D_tails_clients_1.segment_369 AS D_tails_clients.Segment, IC_Planification_de_la_retraite_2.inflation_67 AS IC_Planification_de_la_retraite.Inflation, IC_Planification_de_la_retraite_2.age_de_la_retraite_68 AS IC_Planification_de_la_retraite.Age_de_la_retraite, IC_Planification_de_la_retraite_2.reer_celi_69 AS IC_Planification_de_la_retraite.REER_CELI, IC_Planification_de_la_retraite_2.revenu_annuel_d_sir__70 AS IC_Planification_de_la_retraite.Revenu_annuel_d_sir_, Situation_familiale_3._tat_civil_289 AS Situation_familiale._tat_civil, Situation_familiale_3.pr_nom_conjoint_290 AS Situation_familiale.Pr_nom_conjoint, Situation_familiale_3.nom_conjoint_291 AS Situation_familiale.Nom_conjoint, Situation_familiale_3.date_de_naissance_conjoint_292 AS Situation_familiale.Date_de_naissance_conjoint, Situation_familiale_3.nombre_de_personnes_charge_293 AS Situation_familiale.Nombre_de_personnes_charge, E_Divers_4.ch_que_sp_cimen_306 AS E_Divers.Ch_que_sp_cimen, E_Divers_4.une_autre_personne_est_elle_auto_307 AS E_Divers.Une_autre_personne_est_elle_autoris_e_donner_des_ordre_pour_ce_c, E_Divers_4.le_compte_est_il_exploit_dans_l__308 AS E_Divers.Le_compte_est_il_exploit_dans_l_int_r_t_d_un_tier, E_Divers_4.num_ro_de_la_succursale_478 AS E_Divers.Num_ro_de_la_succursale, E_Divers_4.num_ro_de_la_banque_479 AS E_Divers.Num_ro_de_la_banque, E_Divers_4.num_ro_de_compte_480 AS E_Divers.Num_ro_de_compte, E_Divers_4._tes_vous_une_personne_politique_546 AS E_Divers._tes_vous_une_personne_politiquement_vuln_rable_ou_un_dirigeant_, E_Divers_4._tes_vous_un_r_sident_am_ricain__547 AS E_Divers._tes_vous_un_r_sident_am_ricain_ou_un_citoyen_am_ricain_aux_fins, E_Divers_4._tes_vous_un_r_sident_aux_fins_d_548 AS E_Divers._tes_vous_un_r_sident_aux_fins_de_l_imp_t_d_un_autre_pays_que_le, H_Profil_financier_et_exp_rience_5.origine_du_premier_contact_310 AS H_Profil_financier_et_exp_rience.Origine_du_premier_contact, H_Profil_financier_et_exp_rience_5.exp_rience_en_investissement_311 AS H_Profil_financier_et_exp_rience.Exp_rience_en_investissement, H_Profil_financier_et_exp_rience_5.connaissance_en_placement_312 AS H_Profil_financier_et_exp_rience.Connaissance_en_placement, I_Bilan_et_revenu_6.actifs_non_reer_313 AS I_Bilan_et_revenu.Actifs_non_REER, I_Bilan_et_revenu_6.actifs_reer_ferr_cri_celi_314 AS I_Bilan_et_revenu.Actifs_REER_FERR_CRI_CELI, I_Bilan_et_revenu_6.actif_avoir_liquide_315 AS I_Bilan_et_revenu.Actif_Avoir_Liquide, I_Bilan_et_revenu_6.actifs_immobilier_316 AS I_Bilan_et_revenu.Actifs_immobilier, I_Bilan_et_revenu_6.passifs_hypoth_que_317 AS I_Bilan_et_revenu.Passifs_Hypoth_que, I_Bilan_et_revenu_6.passifs_cartes_de_cr_dit_et_autr_318 AS I_Bilan_et_revenu.Passifs_Cartes_de_cr_dit_et_autres_dettes, I_Bilan_et_revenu_6.revenu_annuel_319 AS I_Bilan_et_revenu.Revenu_annuel, I_Bilan_et_revenu_6.actifs_non_reer_avec_d_autres_in_505 AS I_Bilan_et_revenu.Actifs_Non_REER_Avec_d_autres_institutions_financi_re_, I_Bilan_et_revenu_6.numeric_actifs_reer_ferr_cri_cel_506 AS I_Bilan_et_revenu.Numeric_Actifs_REER_FERR_CRI_CELI_Avec_d_autres_institutions_fin, I_Bilan_et_revenu_6.revenu_annuel_numeric_508 AS I_Bilan_et_revenu.Revenu_annuel_numeric, Int_r_ts_personnels_7.hobby_349 AS Int_r_ts_personnels.Hobby, Int_r_ts_personnels_7.autre_355 AS Int_r_ts_personnels.Autre, Collectif_8.genre_d_entreprise_371 AS Collectif.Genre_d_entreprise, Collectif_8.date_de_constitution_372 AS Collectif.Date_de_constitution, Collectif_8.nombre_d_employ_s_373 AS Collectif.Nombre_d_employ_s, Collectif_8.chiffre_d_affaire_374 AS Collectif.Chiffre_d_affaire, Avantages_sociaux_9.assurance_collective_avec_377 AS Avantages_sociaux.Assurance_collective_avec, Avantages_sociaux_9.date_d_ch_ance_378 AS Avantages_sociaux.Date_d_ch_ance, Avantages_sociaux_9.garantie_courte_dur_e_379 AS Avantages_sociaux.Garantie_Courte_dur_e, Avantages_sociaux_9.garantie_longeu_dur_e_380 AS Avantages_sociaux.Garantie_Longeu_dur_e, Avantages_sociaux_9.garantie_maladie_graves_381 AS Avantages_sociaux.Garantie_Maladie_Graves, Avantages_sociaux_9.garantie_soins_domicile_382 AS Avantages_sociaux.Garantie_soins_domicile, Avantages_sociaux_9.garantie_assurance_vie_383 AS Avantages_sociaux.Garantie_assurance_vie, Avantages_sociaux_9.frais_m_dicaux_et_param_dicaux_384 AS Avantages_sociaux.Frais_m_dicaux_et_param_dicaux, Avantages_sociaux_9.lunette_385 AS Avantages_sociaux.Lunette, Avantages_sociaux_9.dentaire_386 AS Avantages_sociaux.Dentaire, Avantages_sociaux_9.commentaires_387 AS Avantages_sociaux.Commentaires, lcf_contact_note_10.note_388 AS lcf_contact_note.contact_note, lcf_individual_supplier_account_details_11.plan_type_399 AS lcf_individual_supplier_account_details.plan_type, lcf_individual_supplier_account_details_11.account_number_401 AS lcf_individual_supplier_account_details.account_number, lcf_individual_supplier_account_details_11.cotisation_403 AS lcf_individual_supplier_account_details.fee, lcf_individual_supplier_account_details_11.investment_provider_405 AS lcf_individual_supplier_account_details.investment_provider, lcf_individual_supplier_account_details_11.investment_code_407 AS lcf_individual_supplier_account_details.investment_code, lcf_individual_supplier_account_details_11.advisor_code_409 AS lcf_individual_supplier_account_details.advisor_code, lcf_individual_supplier_account_details_11.fair_market_value_411 AS lcf_individual_supplier_account_details.fair_market_value, lcf_individual_supplier_account_details_11.book_value_413 AS lcf_individual_supplier_account_details.book_value, lcf_individual_supplier_account_details_11.intermediary_account_415 AS lcf_individual_supplier_account_details.intermediary_account , lcf_individual_supplier_account_details_11.risk_417 AS lcf_individual_supplier_account_details.risk, lcf_registration_code_12.registration_code_397 AS lcf_registration_code.registration_code, lcf_individual_supplier_statuses_13.is_still_in_business__418 AS lcf_individual_supplier_statuses.is_still_in_business, lcf_individual_supplier_statuses_13.is_we_can_sell_them__419 AS lcf_individual_supplier_statuses.is_we_can_sell_them, lcf_employer_14.job_status_420 AS lcf_employer.employer_status, lcf_employer_14.name_of_the_employer_421 AS lcf_employer.employer_name, lcf_employer_14.emploi_447 AS lcf_employer.Emploi, lcf_employer_14.employeur_448 AS lcf_employer.Employeur, lcf_employer_14.secteur_d_activit__458 AS lcf_employer.Secteur_d_activit_, lcf_employer_14.position_562 AS lcf_employer.Position, lcf_organization_type_of_business_15.type_of_business_422 AS lcf_organization_type_of_business.type_of_business, Phone_varefication_16.phone_validated_424 AS Phone_varefication.Phone_validated, Impsition_client_aux_tats_unis_17._tes_vous_une_personne_des_tats__445 AS Impsition_client_aux_tats_unis._tes_vous_une_personne_des_tats_Unis_aux_fins_de_l_imp_t_sur_le_, Impsition_client_aux_tats_unis_17.si_oui_indiquez_votre_tax_indent_446 AS Impsition_client_aux_tats_unis.Si_oui_indiquez_votre_tax_indentification_number_TIN_tats_Unis, Conseiller_Code_18.dealer_code_459 AS Conseiller_Code.Dealer_Code, Conseiller_Code_18.rep_code_460 AS Conseiller_Code.Rep_Code, Conseiller_Code_18.nom_du_conseiller_481 AS Conseiller_Code.Nom_du_conseiller, Conseiller_Code_18.t_l_phone_482 AS Conseiller_Code.T_l_phone, Questionnaire_de_l_investisseur_19.quel_nonc_d_crit_le_mieux_vos_co_564 AS Questionnaire_de_l_investisseur.Quel_nonc_d_crit_le_mieux_vos_connaissances_en_mati_re_de_placem, Questionnaire_de_l_investisseur_19.quel_est_votre_revenu_annuel_de__565 AS Questionnaire_de_l_investisseur.Quel_est_votre_revenu_annuel_de_toutes_les_sources_, Questionnaire_de_l_investisseur_19.vos_sources_de_revenus_actuels_e_566 AS Questionnaire_de_l_investisseur.Vos_sources_de_revenus_actuels_et_futurs_sont_, Questionnaire_de_l_investisseur_19.comment_d_cririez_vous_votre_sit_567 AS Questionnaire_de_l_investisseur.Comment_d_cririez_vous_votre_situation_financi_re_globale_, Questionnaire_de_l_investisseur_19._combien_estimez_vous_votre_vale_568 AS Questionnaire_de_l_investisseur._combien_estimez_vous_votre_valeur_nette_placements_liquidit_s_m, Questionnaire_de_l_investisseur_19.quel_pourcentage_du_total_de_vos_569 AS Questionnaire_de_l_investisseur.Quel_pourcentage_du_total_de_vos_conomies_et_de_vos_placements_c, Questionnaire_de_l_investisseur_19.quel_est_votre_groupe_d_ge__570 AS Questionnaire_de_l_investisseur.Quel_est_votre_groupe_d_ge_, Questionnaire_de_l_investisseur_19.question_10_571 AS Questionnaire_de_l_investisseur.Question_10, Questionnaire_de_l_investisseur_19.questiion_11_572 AS Questionnaire_de_l_investisseur.Questiion_11, Questionnaire_de_l_investisseur_19.question_12_573 AS Questionnaire_de_l_investisseur.Question_12, Questionnaire_de_l_investisseur_19.question_13_574 AS Questionnaire_de_l_investisseur.Question_13, Questionnaire_de_l_investisseur_19.question_14_575 AS Questionnaire_de_l_investisseur.Question_14, Questionnaire_de_l_investisseur_19.question_15_576 AS Questionnaire_de_l_investisseur.Question_15, a.prefix_id AS prefix_id:label, a.suffix_id AS suffix_id:label, a.contact_type AS contact_type:label, a.gender_id AS gender_id:label, a.communication_style_id AS communication_style_id:label, a.preferred_communication_method AS preferred_communication_method:label, employer_id_21.display_name AS employer_id.display_name FROM civicrm_contact a LEFT JOIN civicrm_value_d_tails_clients_2 D_tails_clients_1 ON a.id = D_tails_clients_1.entity_id LEFT JOIN civicrm_value_ic_planification_de_la_retraite_12 IC_Planification_de_la_retraite_2 ON a.id = IC_Planification_de_la_retraite_2.entity_id LEFT JOIN civicrm_value_situation_familiale_48 Situation_familiale_3 ON a.id = Situation_familiale_3.entity_id LEFT JOIN civicrm_value_e_divers_54 E_Divers_4 ON a.id = E_Divers_4.entity_id LEFT JOIN civicrm_value_h_profil_financier_et_exp_rience_55 H_Profil_financier_et_exp_rience_5 ON a.id = H_Profil_financier_et_exp_rience_5.entity_id LEFT JOIN civicrm_value_i_bilan_et_revenu_56 I_Bilan_et_revenu_6 ON a.id = I_Bilan_et_revenu_6.entity_id LEFT JOIN civicrm_value_int_r_ts_personnels_68 Int_r_ts_personnels_7 ON a.id = Int_r_ts_personnels_7.entity_id LEFT JOIN civicrm_value_collectif_72 Collectif_8 ON a.id = Collectif_8.entity_id LEFT JOIN civicrm_value_avantages_soc_73 Avantages_sociaux_9 ON a.id = Avantages_sociaux_9.entity_id LEFT JOIN civicrm_value_note_74 lcf_contact_note_10 ON a.id = lcf_contact_note_10.entity_id LEFT JOIN civicrm_value_account_detai_78 lcf_individual_supplier_account_details_11 ON a.id = lcf_individual_supplier_account_details_11.entity_id LEFT JOIN civicrm_value_registration__80 lcf_registration_code_12 ON a.id = lcf_registration_code_12.entity_id LEFT JOIN civicrm_value_supplier_stat_81 lcf_individual_supplier_statuses_13 ON a.id = lcf_individual_supplier_statuses_13.entity_id LEFT JOIN civicrm_value_employeur_82 lcf_employer_14 ON a.id = lcf_employer_14.entity_id LEFT JOIN civicrm_value_type_of_busin_83 lcf_organization_type_of_business_15 ON a.id = lcf_organization_type_of_business_15.entity_id LEFT JOIN civicrm_value_phone_varefic_85 Phone_varefication_16 ON a.id = Phone_varefication_16.entity_id LEFT JOIN civicrm_value_impsition_cli_89 Impsition_client_aux_tats_unis_17 ON a.id = Impsition_client_aux_tats_unis_17.entity_id LEFT JOIN civicrm_value_conseiller_co_91 Conseiller_Code_18 ON a.id = Conseiller_Code_18.entity_id LEFT JOIN civicrm_value_questionnaire_103 Questionnaire_de_l_investisseur_19 ON a.id = Questionnaire_de_l_investisseur_19.entity_id LEFT JOIN civicrm_value_demographics D - Identification_20 ON a.id = D - Identification_20.entity_id LEFT JOIN civicrm_contact employer_id_21 ON a.employer_id = employer_id_21.id WHERE (a.id = "1") [nativecode=1054 ** Unknown column 'D' in 'on clause']"] )

      Nov 06 11:50:09 [debug] $backTrace = #0 /var/www/html/vendor/civicrm/civicrm-core/CRM/Core/Error.php(942): CRM_Core_Error::backtrace("backTrace", TRUE) #1 (moved) /var/www/html/vendor/pear/pear-core-minimal/src/PEAR.php(944): CRM_Core_Error::exceptionHandler(Object(DB_Error)) #2 (moved) /var/www/html/vendor/pear/db/DB.php(997): PEAR_Error->__construct("DB Error: no such field", -19, 16, (Array:2), "SELECT a.id AS id, a.contact_type AS contact_type, a.contact_s...") #3 /var/www/html/vendor/pear/pear-core-minimal/src/PEAR.php(575): DB_Error->__construct(-19, 16, (Array:2), "SELECT a.idASid, a.contact_typeAScontact_type, a.contact_s...") #4 (moved) /var/www/html/vendor/pear/pear-core-minimal/src/PEAR.php(223): PEAR->_raiseError(Object(DB_mysqli), NULL, -19, 16, (Array:2), "SELECT a.id AS id, a.contact_type AS contact_type, a.contact_s...", "DB_Error", TRUE) #5 /var/www/html/vendor/pear/db/DB/common.php(1928): PEAR->__call("raiseError", (Array:7)) #6 /var/www/html/vendor/pear/db/DB/mysqli.php(936): DB_common->raiseError(-19, NULL, NULL, "SELECT a.idASid, a.contact_typeAScontact_type, a.contact_s...", "1054 ** Unknown column 'D' in 'on clause'") #7 (moved) /var/www/html/vendor/pear/db/DB/mysqli.php(406): DB_mysqli->mysqliRaiseError() #8 (moved) /var/www/html/vendor/pear/db/DB/common.php(1234): DB_mysqli->simpleQuery("SELECT a.id AS id, a.contact_type AS contact_type, a.contact_s...") #9 /var/www/html/vendor/civicrm/civicrm-packages/DB/DataObject.php(2696): DB_common->query("SELECT a.idASid, a.contact_typeAScontact_type, a.contact_s...") #10 (moved) /var/www/html/vendor/civicrm/civicrm-packages/DB/DataObject.php(1829): DB_DataObject->_query("SELECT a.id AS id, a.contact_type AS contact_type, a.contact_s...") #11 /var/www/html/vendor/civicrm/civicrm-core/CRM/Core/DAO.php(468): DB_DataObject->query("SELECT a.idASid, a.contact_typeAScontact_type, a.contact_s...") #12 (moved) /var/www/html/vendor/civicrm/civicrm-core/CRM/Core/DAO.php(1619): CRM_Core_DAO->query("SELECT a.id AS id, a.contact_type AS contact_type, a.contact_s...", TRUE) #13 /var/www/html/vendor/civicrm/civicrm-core/Civi/Api4/Query/Api4SelectQuery.php(166): CRM_Core_DAO::executeQuery("SELECT a.idASid, a.contact_typeAScontact_type, a.contact_s...") #14 (moved) /var/www/html/vendor/civicrm/civicrm-core/Civi/Api4/Generic/DAOGetAction.php(111): Civi\Api4\Query\Api4SelectQuery->run() #15 (moved) /var/www/html/vendor/civicrm/civicrm-core/Civi/Api4/Generic/DAOGetAction.php(99): Civi\Api4\Generic\DAOGetAction->getObjects(Object(Civi\Api4\Generic\Result)) #16 (moved) /var/www/html/vendor/civicrm/civicrm-core/Civi/Api4/Provider/ActionObjectProvider.php(68): Civi\Api4\Generic\DAOGetAction->_run(Object(Civi\Api4\Generic\Result)) #17 (moved) /var/www/html/vendor/civicrm/civicrm-core/Civi/API/Kernel.php(149): Civi\Api4\Provider\ActionObjectProvider->invoke(Object(Civi\Api4\Generic\DAOGetAction)) #18 (moved) /var/www/html/vendor/civicrm/civicrm-core/Civi/Api4/Generic/AbstractAction.php(234): Civi\API\Kernel->runRequest(Object(Civi\Api4\Generic\DAOGetAction)) #19 (moved) /var/www/html/vendor/civicrm/civicrm-core/CRM/Contact/Tokens.php(455): Civi\Api4\Generic\AbstractAction->execute() #20 (moved) /var/www/html/vendor/civicrm/civicrm-core/CRM/Contact/Tokens.php(266): CRM_Contact_Tokens->getContact(1, (Array:2), TRUE) #21 (moved) /var/www/html/vendor/symfony/event-dispatcher/EventDispatcher.php(264): CRM_Contact_Tokens->evaluateLegacyHookTokens(Object(Civi\Token\Event\TokenValueEvent), "civi.token.eval", Object(Civi\Core\CiviEventDispatcher)) #22 (moved) /var/www/html/vendor/symfony/event-dispatcher/EventDispatcher.php(239): Symfony\Component\EventDispatcher\EventDispatcher->doDispatch((Array:13), "civi.token.eval", Object(Civi\Token\Event\TokenValueEvent)) #23 (moved) /var/www/html/vendor/symfony/event-dispatcher/EventDispatcher.php(73): Symfony\Component\EventDispatcher\EventDispatcher->callListeners((Array:13), "civi.token.eval", Object(Civi\Token\Event\TokenValueEvent)) #24 (moved) /var/www/html/vendor/civicrm/civicrm-core/Civi/Core/CiviEventDispatcher.php(198): Symfony\Component\EventDispatcher\EventDispatcher->dispatch(Object(Civi\Token\Event\TokenValueEvent), Object(Civi\Token\Event\TokenValueEvent)) #25 (moved) /var/www/html/vendor/civicrm/civicrm-core/Civi/Token/TokenProcessor.php(343): Civi\Core\CiviEventDispatcher->dispatch("civi.token.eval", Object(Civi\Token\Event\TokenValueEvent)) #26 (moved) /var/www/html/vendor/civicrm/civicrm-core/ext/flexmailer/src/Listener/DefaultComposer.php(79): Civi\Token\TokenProcessor->evaluate() #27 (moved) internal function: Civi\FlexMailer\Listener\DefaultComposer->onCompose(Object(Civi\FlexMailer\Event\ComposeBatchEvent), "civi.flexmailer.compose", Object(Civi\Core\CiviEventDispatcher)) #28 (moved) /var/www/html/vendor/civicrm/civicrm-core/Civi/Core/Event/ServiceListener.php(53): call_user_func_array((Array:2), (Array:3)) #29 (moved) /var/www/html/vendor/symfony/event-dispatcher/EventDispatcher.php(264): Civi\Core\Event\ServiceListener->__invoke(Object(Civi\FlexMailer\Event\ComposeBatchEvent), "civi.flexmailer.compose", Object(Civi\Core\CiviEventDispatcher)) #30 (moved) /var/www/html/vendor/symfony/event-dispatcher/EventDispatcher.php(239): Symfony\Component\EventDispatcher\EventDispatcher->doDispatch((Array:10), "civi.flexmailer.compose", Object(Civi\FlexMailer\Event\ComposeBatchEvent)) #31 (moved) /var/www/html/vendor/symfony/event-dispatcher/EventDispatcher.php(73): Symfony\Component\EventDispatcher\EventDispatcher->callListeners((Array:10), "civi.flexmailer.compose", Object(Civi\FlexMailer\Event\ComposeBatchEvent)) #32 (moved) /var/www/html/vendor/civicrm/civicrm-core/Civi/Core/CiviEventDispatcher.php(198): Symfony\Component\EventDispatcher\EventDispatcher->dispatch(Object(Civi\FlexMailer\Event\ComposeBatchEvent), Object(Civi\FlexMailer\Event\ComposeBatchEvent)) #33 (moved) /var/www/html/vendor/civicrm/civicrm-core/ext/flexmailer/src/FlexMailer.php(212): Civi\Core\CiviEventDispatcher->dispatch("civi.flexmailer.compose", Object(Civi\FlexMailer\Event\ComposeBatchEvent)) #34 (moved) /var/www/html/vendor/civicrm/civicrm-core/ext/flexmailer/src/FlexMailer.php(158): Civi\FlexMailer\FlexMailer->fireComposeBatch((Array:200)) #35 (moved) internal function: Civi\FlexMailer\FlexMailer->Civi\FlexMailer{closure}((Array:200)) #36 (moved) /var/www/html/vendor/civicrm/civicrm-core/ext/flexmailer/src/Event/WalkBatchesEvent.php(55): call_user_func(Object(Closure), (Array:200)) #37 (moved) /var/www/html/vendor/civicrm/civicrm-core/ext/flexmailer/src/Listener/DefaultBatcher.php(46): Civi\FlexMailer\Event\WalkBatchesEvent->visit((Array:200)) #38 (moved) internal function: Civi\FlexMailer\Listener\DefaultBatcher->onWalk(Object(Civi\FlexMailer\Event\WalkBatchesEvent), "civi.flexmailer.walk", Object(Civi\Core\CiviEventDispatcher)) #39 (moved) /var/www/html/vendor/civicrm/civicrm-core/Civi/Core/Event/ServiceListener.php(53): call_user_func_array((Array:2), (Array:3)) #40 (moved) /var/www/html/vendor/symfony/event-dispatcher/EventDispatcher.php(264): Civi\Core\Event\ServiceListener->__invoke(Object(Civi\FlexMailer\Event\WalkBatchesEvent), "civi.flexmailer.walk", Object(Civi\Core\CiviEventDispatcher)) #41 (moved) /var/www/html/vendor/symfony/event-dispatcher/EventDispatcher.php(239): Symfony\Component\EventDispatcher\EventDispatcher->doDispatch((Array:1), "civi.flexmailer.walk", Object(Civi\FlexMailer\Event\WalkBatchesEvent)) #42 (moved) /var/www/html/vendor/symfony/event-dispatcher/EventDispatcher.php(73): Symfony\Component\EventDispatcher\EventDispatcher->callListeners((Array:1), "civi.flexmailer.walk", Object(Civi\FlexMailer\Event\WalkBatchesEvent)) #43 (moved) /var/www/html/vendor/civicrm/civicrm-core/Civi/Core/CiviEventDispatcher.php(198): Symfony\Component\EventDispatcher\EventDispatcher->dispatch(Object(Civi\FlexMailer\Event\WalkBatchesEvent), Object(Civi\FlexMailer\Event\WalkBatchesEvent)) #44 (moved) /var/www/html/vendor/civicrm/civicrm-core/ext/flexmailer/src/FlexMailer.php(196): Civi\Core\CiviEventDispatcher->dispatch("civi.flexmailer.walk", Object(Civi\FlexMailer\Event\WalkBatchesEvent)) #45 (moved) /var/www/html/vendor/civicrm/civicrm-core/ext/flexmailer/src/FlexMailer.php(161): Civi\FlexMailer\FlexMailer->fireWalkBatches(Object(Closure)) #46 (moved) /var/www/html/vendor/civicrm/civicrm-core/ext/flexmailer/src/FlexMailer.php(122): Civi\FlexMailer\FlexMailer->run() #47 (moved) internal function: Civi\FlexMailer\FlexMailer::createAndRun(Object(CRM_Mailing_BAO_MailingJob), Object(CRM_Utils_Mail_FilteredPearMailer), NULL) #48 (moved) /var/www/html/vendor/civicrm/civicrm-core/Civi/Core/Resolver.php(119): call_user_func_array((Array:2), (Array:3)) #49 (moved) /var/www/html/vendor/civicrm/civicrm-core/CRM/Mailing/BAO/MailingJob.php(181): Civi\Core\Resolver->call("\Civi\FlexMailer\FlexMailer::createAndRun", (Array:3)) #50 (moved) /var/www/html/vendor/civicrm/civicrm-core/CRM/Mailing/BAO/Mailing.php(2746): CRM_Mailing_BAO_MailingJob::runJobs(NULL, NULL) #51 (moved) /var/www/html/vendor/civicrm/civicrm-core/api/v3/Job.php(341): CRM_Mailing_BAO_Mailing::processQueue() #52 (moved) /var/www/html/vendor/civicrm/civicrm-core/Civi/API/Provider/MagicFunctionProvider.php(89): civicrm_api3_job_process_mailing((Array:1)) #53 (moved) /var/www/html/vendor/civicrm/civicrm-core/Civi/API/Kernel.php(149): Civi\API\Provider\MagicFunctionProvider->invoke((Array:8)) #54 (moved) /var/www/html/vendor/civicrm/civicrm-core/Civi/API/Kernel.php(81): Civi\API\Kernel->runRequest((Array:8)) #55 (moved) /var/www/html/vendor/civicrm/civicrm-core/api/api.php(22): Civi\API\Kernel->runSafe("Job", "process_mailing", (Array:1)) #56 (moved) /var/www/html/vendor/civicrm/civicrm-core/CRM/Core/JobManager.php(131): civicrm_api("Job", "process_mailing", (Array:1)) #57 (moved) /var/www/html/vendor/civicrm/civicrm-core/CRM/Core/JobManager.php(63): CRM_Core_JobManager->executeJob(Object(CRM_Core_ScheduledJob)) #58 (moved) /var/www/html/vendor/civicrm/civicrm-core/api/v3/Job.php(118): CRM_Core_JobManager->execute(FALSE) #59 (moved) /var/www/html/vendor/civicrm/civicrm-core/Civi/API/Provider/MagicFunctionProvider.php(89): civicrm_api3_job_execute((Array:1)) #60 (moved) /var/www/html/vendor/civicrm/civicrm-core/Civi/API/Kernel.php(149): Civi\API\Provider\MagicFunctionProvider->invoke((Array:8)) #61 (moved) /var/www/html/vendor/civicrm/civicrm-core/Civi/API/Kernel.php(81): Civi\API\Kernel->runRequest((Array:8)) #62 (moved) /var/www/html/vendor/civicrm/civicrm-core/api/api.php(22): Civi\API\Kernel->runSafe("job", "execute", (Array:1)) #63 (moved) phar:///usr/local/bin/cv/src/Command/ApiCommand.php(74): civicrm_api("job", "execute", (Array:1)) #64 (moved) phar:///usr/local/bin/cv/vendor/symfony/console/Command/Command.php(257): Civi\Cv\Command\ApiCommand->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #65 (moved) phar:///usr/local/bin/cv/vendor/symfony/console/Application.php(850): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #66 (moved) phar:///usr/local/bin/cv/vendor/symfony/console/Application.php(193): Symfony\Component\Console\Application->doRunCommand(Object(Civi\Cv\Command\ApiCommand), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #67 (moved) phar:///usr/local/bin/cv/src/Application.php(46): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #68 (moved) phar:///usr/local/bin/cv/vendor/symfony/console/Application.php(124): Civi\Cv\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #69 (moved) phar:///usr/local/bin/cv/src/Application.php(15): Symfony\Component\Console\Application->run() #70 (moved) phar:///usr/local/bin/cv/bin/cv(27): Civi\Cv\Application::main("phar:///usr/local/bin/cv/bin") #71 (moved) /usr/local/bin/cv(14): require("phar:///usr/local/bin/cv/bin/cv") #72 (moved) {main}

    • DaveD
      DaveD @DaveD ·
      Maintainer

      You have the civicrm_engage drupal module installed I think and somehow the table alias of the custom group is being generated as "D - Identification_20" for its table civicrm_value_demographics. The spaces are usually replaced by _ to avoid the problem so I'm not sure whether this is civicrm_engage doing it or some change in civi that has changed how the table alias is determined.

    • justinfreeman (Agileware) changed title from Civimal stopped working after upgrade to 5.43 to CiviMail stopped sending email after upgrade to CiviCRM 5.43

      changed title from Civimal stopped working after upgrade to 5.43 to CiviMail stopped sending email after upgrade to CiviCRM 5.43

    • justinfreeman (Agileware) changed the description

      changed the description

    • seamuslee
      seamuslee @seamuslee ·
      Owner

      I have replicated the error at least in a unit test and hoping that @colemanw can look at it, it seems to be more about APIv4 than CiviMail/Flexmailer at all.

    • colemanw
      colemanw @colemanw ·
      Owner

      I think this will fix it: https://github.com/civicrm/civicrm-core/pull/22049

    • seamuslee
      seamuslee @seamuslee ·
      Owner

      @lishaw1968 can you try applying the patch from that pull request and see if it fixes your issue?

    • colemanw
      colemanw @colemanw ·
      Owner

      PR was merged into 5.44 branch.

    • colemanw closed

      closed

    • colemanw mentioned in commit core@cbe4cc66

      mentioned in commit core@cbe4cc66

    • colemanw mentioned in commit core@8db462f5

      mentioned in commit core@8db462f5

    • lishaw1968
      lishaw1968 @lishaw1968 ·
      Author Developer

      Done and working... Very big thnk you

    • seamuslee changed milestone to %5.43.1

      changed milestone to %5.43.1

    • totten mentioned in commit core@e8c38773

      mentioned in commit core@e8c38773

    • totten mentioned in commit core@8b32c93e

      mentioned in commit core@8b32c93e

    • bgm moved to core#3561 (closed)

      moved to core#3561 (closed)

    Please register or sign in to reply