201 -

Erreur n°201 -

Unable to execute "select distinct v.question_id from (select distinct q.question_id from wwl_interview_question_target_consult tc inner join wwl_interview_questions q using (question_id), wwl_taken_interview_target ic where q.question_type=3 and q.question_answer_type='2' and q.answer_idparent='0' and q.question_deleted='0' and q.question_type='3' and ic.interview_id= and (ic.job_id=tc.job_id or (ic.function_id=tc.function_id and ic.function_id>0) or (ic.subfunction_id=tc.subfunction_id AND ic.subfunction_id>0)) union select distinct tc2.question_id from wwl_interview_question_target_consult tc2 inner join wwl_interview_questions q using (question_id), wwl_taken_interview_target ic where q.question_type=3 and q.question_answer_type='2' and q.answer_idparent='0' and q.question_deleted='0' and q.question_type='3' and (tc2.job_id= ) ) v" query( You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'and (ic.job_id=tc.job_id or (ic.function_id=tc.function_id and ic.function_id>0)' at line 7 )

							#0 /var/www/linshee-prod/models/interview.php(145): core\spdo->query('select distinct...')
#1 /var/www/linshee-prod/models/customeruser.php(807): models\interview->getSpecificQuestionList(Array)
#2 /var/www/linshee-prod/cache/templates_c/smarty/549bb1a75c12b3db2a5c88e3b5821fe689b5751d.file.default.tpl.php(269): models\customeruser->getAllMultipleAnswerQuestionSpecificWithAnswerArray()
#3 /var/www/linshee-prod/lib/Smarty/sysplugins/smarty_internal_templatebase.php(181): content_5c138c6b01b035_32185907(Object(Smarty_Internal_Template))
#4 /var/www/linshee-prod/core/templateSMARTYSystem.php(37): Smarty_Internal_TemplateBase->fetch('controllers/pro...')
#5 /var/www/linshee-prod/core/actioncontroller.php(52): core\templateSMARTYSystem->getResult('controllers/pro...')
#6 /var/www/linshee-prod/controllers/abstractfront.php(141): core\actioncontroller->_render('default')
#7 /var/www/linshee-prod/controllers/profil.php(188): controllers\abstractfront->_render()
#8 [internal function]: controllers\profil->showcandidate('2416')
#9 /var/www/linshee-prod/core/website.php(323): call_user_func_array(Array, Array)
#10 /var/www/linshee-prod/core/website.php(62): core\website->_run()
#11 /var/www/linshee-prod/index.php(43): core\website->display()
#12 {main}