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->_watchOutDBWith parameters:
| 0 | BOOLEAN: FALSE
|
| 1 | STRING(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->_fetchDataWith parameters:
| 0 | | page | INTEGER: 0
| | perpage | STRING(1): 1
| | sortcolumn | STRING(0)
| | sortdirection | STRING(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->_fetchDataWith parameters:
| 0 | | page | INTEGER: 0
| | perpage | STRING(1): 1
| | sortcolumn | STRING(0)
| | sortdirection | STRING(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->_renderWith 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