Formidable::Mayday

SQL QUERY IS NOT VALID

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND tx_dmmjobcontrol_job.mrc = tx_dmmjobcontrol_mrc.uid AND tx_dmmjobcontr' at line 29

SELECT SQL_CALC_FOUND_ROWS DISTINCT tx_dmmjobcontrol_job.uid AS uid, tx_dmmjobcontrol_job.job_title AS job_title, tx_dmmjobcontrol_job.tstamp AS tstamp, tx_dmmjobcontrol_job.endtime AS endtime, tx_dmmjobcontrol_job.job_description AS job_description, tx_dmmjobcontrol_job.job_requirements AS job_requirements, tx_dmmjobcontrol_job.experience AS experience, tx_dmmjobcontrol_job.job_benefits AS comments, tx_dmmjobcontrol_job.location AS location, tx_dmmjobcontrol_mrc.name AS mrc_name, tx_dmmjobcontrol_city.name AS city_name, tx_dmmjobcontrol_duration.name AS implication, tx_dmmjobcontrol_job.salary AS duration, tx_dmmjobcontrol_job.hours AS hours, tx_dmmjobcontrol_job.apply_information AS frequency, tx_dmmjobcontrol_job.age AS age, fe_users.name AS name, fe_users.email AS email, fe_users.www AS www, fe_users.telephone AS telephone, tx_feuserfields_telephone2 AS telephonealt, fe_users.comments AS mission, fe_users.company AS company FROM tx_dmmjobcontrol_job, fe_users, tx_dmmjobcontrol_mrc, tx_dmmjobcontrol_city, tx_dmmjobcontrol_duration WHERE tx_dmmjobcontrol_job.uid = AND tx_dmmjobcontrol_job.mrc = tx_dmmjobcontrol_mrc.uid AND tx_dmmjobcontrol_job.city = tx_dmmjobcontrol_city.uid AND tx_dmmjobcontrol_job.duration = tx_dmmjobcontrol_duration.uid AND fe_users.uid = LIMIT 0, 1

XML: /var/www/passionbenevole.ca/web/typo3conf/ext/jobcontrol_feedit/xml/detailView.xml
Formidable: v2.0.484
Total exec. time: 0.039 sec

Call stack

Call 0: /var/www/clients/client10/web12/web/typo3conf/ext/ameos_formidable/api/class.tx_ameosformidable.php:6859 | tx_ameosformidable->_watchOutDB
With parameters:
0BOOLEAN: FALSE
1STRING(1501): SELECT SQL_CALC_FOUND_ROWS DISTINCT
tx_dmmjobcontrol_job.uid AS uid,
tx_dmmjobcontrol_job.job_title AS job_title,
tx_dmmjobcontrol_job.tstamp AS tstamp,
tx_dmmjobcontrol_job.endtime AS endtime,
tx_dmmjobcontrol_job.job_description AS job_description,
tx_dmmjobcontrol_job.job_requirements AS job_requirements,
tx_dmmjobcontrol_job.experience AS experience,
tx_dmmjobcontrol_job.job_benefits AS comments,
tx_dmmjobcontrol_job.location AS location,
tx_dmmjobcontrol_mrc.name AS mrc_name,
tx_dmmjobcontrol_city.name AS city_name,
tx_dmmjobcontrol_duration.name AS implication,
tx_dmmjobcontrol_job.salary AS duration,
tx_dmmjobcontrol_job.hours AS hours,
tx_dmmjobcontrol_job.apply_information AS frequency,
tx_dmmjobcontrol_job.age AS age,

fe_users.name AS name,
fe_users.email AS email,
fe_users.www AS www,
fe_users.telephone AS telephone,
tx_feuserfields_telephone2 AS telephonealt,
fe_users.comments AS mission,
fe_users.company AS company

FROM
tx_dmmjobcontrol_job, fe_users, tx_dmmjobcontrol_mrc, tx_dmmjobcontrol_city, tx_dmmjobcontrol_duration
WHERE tx_dmmjobcontrol_job.uid = AND tx_dmmjobcontrol_job.mrc = tx_dmmjobcontrol_mrc.uid
AND tx_dmmjobcontrol_job.city = tx_dmmjobcontrol_city.uid
AND tx_dmmjobcontrol_job.duration = tx_dmmjobcontrol_duration.uid AND fe_users.uid = LIMIT 0, 1

Call -1: /var/www/clients/client10/web12/web/typo3conf/ext/ameos_formidable/api/base/ds_db/api/class.tx_dsdb.php:85 | tx_dsdb->_fetchData
With parameters:
0
pageINTEGER: 0
perpageSTRING(1): 1
sortcolumnSTRING(0)
sortdirectionSTRING(0)

Call -2: /var/www/clients/client10/web12/web/typo3conf/ext/ameos_formidable/api/base/rdt_lister/api/class.tx_rdtlister.php:582 | tx_rdtlister->_fetchData
With parameters:
0
pageINTEGER: 0
perpageSTRING(1): 1
sortcolumnSTRING(0)
sortdirectionSTRING(0)

Call -3: /var/www/clients/client10/web12/web/typo3conf/ext/ameos_formidable/api/base/rdt_lister/api/class.tx_rdtlister.php:57 | tx_rdtlister->_render
With parameters: no parameters
require#84 // tslib_fe->INTincScript#465 // tslib_fe->INTincScript_process#3223 // tslib_cObj->USER#3284 // tslib_content_User->render#922 // tslib_cObj->callUserFunction#51 // call_user_func_array#6388 // tx_jobcontrolfeedit_pi1->main# // tx_jobcontrolfeedit_pi1->displayDetail#140 // tx_ameosformidable->render#243 // tx_ameosformidable->_render#3708 // tx_ameosformidable->_renderElements#3944 // tx_ameosformidable->_renderElement#4435 // formidable_mainrenderlet->render#4459 // tx_rdtlister->_render#362 // tx_rdtlister->_fetchData#57 // tx_dsdb->_fetchData#582 // tx_ameosformidable->_watchOutDB#85 // tx_ameosformidable->mayday#6859 // t3lib_div::debug_trail#5190