| caller | t3lib_DB::sql_query |
| ERROR | Unknown column 'Infos' in 'order clause' |
| lastBuiltQuery | SELECT SQL_CALC_FOUND_ROWS t1.uid as uid_etab,t1.nom as nometab,t1.rue,t1.no,t1.cp as codepost, t1.boite,t1.fax,t1.site_web, t1.contact_courriel as email,t1.contact_telephone as telephone, t2.uid as uid_salle, t2.pid,t2.id_etablissement,t2.id_type_salle, t2.nom_batiment,t2.nom_salle as nomsalle, t2.nom_lieu as nomlieu,t2.surface as surface,t2.scene_largeur as ouvert, t2.scene_profondeur as profond,t2.scene_hauteur as haut, t2.equipement_son as audio,t2.equipement_eclairage as lumiere, t2.equipement_eclairage_desc,t2.public_jauge_assis as assis, t2.public_jauge_debout as debout,t2.equipement_multimedia as multimedia, t2.acces_gratuit as location,t3.uid as uid_typsal, t3.libelle as typesalle,t3.pid,t4.uid as uid_serv,t4.pid, t4.acces_handicape as accesHandicap,t5.uid as uid_dispo, t6.commune as localite from tx_espaceculture_etablissement t1, tx_espaceculture_type_salle t3, tx_espaceculture_services_conditions t4, tx_cpetcommunes_localisation t6, tx_espaceculture_salle t2 left outer join tx_espaceculture_disponibilite t5 on t5.id_salle = t2.uid and t5.deleted=0 and t5.hidden=0 WHERE t1.deleted=0 and t1.hidden=0 and t2.deleted=0 and t2.hidden=0 and t3.deleted=0 and t3.hidden=0 and t4.deleted=0 and t4.hidden=0 and t1.uid = t2.id_etablissement and t1.uid = t4.id_etablissement and t2.id_type_salle = t3.uid and t6.deleted=0 and t6.hidden=0 and t1.cp = t6.code_postal and t6.commune = (select t7.commune from tx_cpetcommunes_localisation t7 where t6.code_postal = t7.code_postal and t7.commune = t1.localite and t7.deleted = 0 and t7.hidden = 0) ORDER BY +Infos ASC LIMIT 0, 10 |
| debug_backtrace | require#80 // tslib_fe->INTincScript#470 // tslib_fe->INTincScript_process#3018 // tslib_cObj->USER#3092 // tslib_cObj->callUserFunction#724 // call_user_func_array#5885 // tx_cfwbform_pi1->main# // tx_cfwbform_pi1->display#88 // tx_ameosformidable->render#168 // tx_ameosformidable->_render#3110 // tx_ameosformidable->_renderElements#3286 // tx_ameosformidable->_renderElement#3574 // formidable_mainrenderlet->render#3599 // tx_rdtbox->_renderReadOnly#126 // tx_rdtbox->_render#197 // formidable_mainrenderlet->renderChildsBag#65 // tx_ameosformidable->_renderElement#1181 // formidable_mainrenderlet->render#3599 // tx_rdtlister->_render#129 // tx_rdtlister->_fetchData#34 // tx_rdtsearchform->_fetchData#379 // tx_dsdb->_fetchData#239 // t3lib_DB->sql_query#30 // t3lib_DB->debug#771 |
| 0 | BOOLEAN: FALSE |
| 1 | STRING(2050): SELECT SQL_CALC_FOUND_ROWS t1.uid as uid_etab,t1.nom as nometab,t1.rue,t1.no,t1.cp as codepost, t1.boite,t1.fax,t1.site_web, t1.contact_courriel as email,t1.contact_telephone as telephone, t2.uid as uid_salle, t2.pid,t2.id_etablissement,t2.id_type_salle, t2.nom_batiment,t2.nom_salle as nomsalle, t2.nom_lieu as nomlieu,t2.surface as surface,t2.scene_largeur as ouvert, t2.scene_profondeur as profond,t2.scene_hauteur as haut, t2.equipement_son as audio,t2.equipement_eclairage as lumiere, t2.equipement_eclairage_desc,t2.public_jauge_assis as assis, t2.public_jauge_debout as debout,t2.equipement_multimedia as multimedia, t2.acces_gratuit as location,t3.uid as uid_typsal, t3.libelle as typesalle,t3.pid,t4.uid as uid_serv,t4.pid, t4.acces_handicape as accesHandicap,t5.uid as uid_dispo, t6.commune as localite from tx_espaceculture_etablissement t1, tx_espaceculture_type_salle t3, tx_espaceculture_services_conditions t4, tx_cpetcommunes_localisation t6, tx_espaceculture_salle t2 left outer join tx_espaceculture_disponibilite t5 on t5.id_salle = t2.uid and t5.deleted=0 and t5.hidden=0 WHERE t1.deleted=0 and t1.hidden=0 and t2.deleted=0 and t2.hidden=0 and t3.deleted=0 and t3.hidden=0 and t4.deleted=0 and t4.hidden=0 and t1.uid = t2.id_etablissement and t1.uid = t4.id_etablissement and t2.id_type_salle = t3.uid and t6.deleted=0 and t6.hidden=0 and t1.cp = t6.code_postal and t6.commune = (select t7.commune from tx_cpetcommunes_localisation t7 where t6.code_postal = t7.code_postal and t7.commune = t1.localite and t7.deleted = 0 and t7.hidden = 0) ORDER BY +Infos ASC LIMIT 0, 10 |
| 0 |
| ||||||||
| 1 |
|
| 0 |
|
| 0 |
|