caller | t3lib_DB::exec_SELECTquery |
ERROR | Unknown column '3A1' in 'order clause' |
lastBuiltQuery | SELECT item.uid,item.pid,item.title,item.description,item.price,item.hot,item.images,item.brand_id,brand.title as brand,pages.title as category FROM tx_ecommerce_item item LEFT JOIN tx_ecommerce_brand brand ON (brand.uid = item.brand_id AND brand.deleted=0) LEFT JOIN pages pages ON (pages.uid = item.pid AND pages.deleted=0 AND pages.hidden=0) WHERE item.deleted=0 AND item.hidden=0 AND item.sys_language_uid=0 AND item.pid IN (347,769,833,422,778,692,420,777,702,421,428,427,440,350,434,435,855,541,708,431,433,690,534,858,857,711,809,436,439,438,843,524,735,691,530,705,729,441,442,734,698,536,473,474,732,353,445,444,836,689,443,837,838,840,839,822,354,447,823,446,448,687,453,454,455,728,699,727,355,449,785,786,841,842,867,784,696,783,781,787,379,450,733,694,380,451,714,381,452,710,865,356,825,847,848,489,357,367,456,609,458,457,529,701,779,715,766,459,461,683,672,460,462,684,669,464,528,681,465,466,844,894,697,685,467,469,470,471,475,476,478,479,845,895,480,725,679,686,482,483,484,522,671,682,738,743,745,747,849,850,851,852,371,372,821,374,607,605,606,346) ORDER BY item.title%3A1 ASC LIMIT 180,20 |
debug_backtrace | require#76 // include#446 // TSpagegen::renderContent#77 // tslib_cObj->cObjGet#332 // tslib_cObj->cObjGetSingle#444 // tslib_cObj->TEMPLATE#578 // tslib_cObj->cObjGetSingle#2473 // tslib_cObj->CONTENT#529 // tslib_cObj->cObjGetSingle#1255 // tslib_cObj->cObjGetSingle#483 // tslib_cObj->CASEFUNC#550 // tslib_cObj->cObjGetSingle#1570 // tslib_cObj->COBJ_ARRAY#502 // tslib_cObj->cObjGet#686 // tslib_cObj->cObjGetSingle#444 // tslib_cObj->CASEFUNC#550 // tslib_cObj->cObjGetSingle#1570 // tslib_cObj->cObjGetSingle#483 // tslib_cObj->USER#572 // tslib_cObj->callUserFunction#724 // call_user_func_array#5866 // tx_ecommerce_pi1->main# // tx_ecommerce_pi1->listView#135 // tx_ecommerce_pi1->readItemsDB#778 // t3lib_DB->exec_SELECTgetRows#863 // t3lib_DB->exec_SELECTquery#314 // t3lib_DB->debug#234 |
caller | t3lib_DB::exec_SELECTquery |
ERROR | Unknown column '3A1' in 'order clause' |
lastBuiltQuery | SELECT item.uid,item.pid,item.title,item.description,item.price,item.hot,item.images,item.brand_id,brand.title as brand,pages.title as category FROM tx_ecommerce_item item LEFT JOIN tx_ecommerce_brand brand ON (brand.uid = item.brand_id AND brand.deleted=0) LEFT JOIN pages pages ON (pages.uid = item.pid AND pages.deleted=0 AND pages.hidden=0) WHERE item.deleted=0 AND item.hidden=0 AND item.sys_language_uid=0 AND item.pid IN (347,769,833,422,778,692,420,777,702,421,428,427,440,350,434,435,855,541,708,431,433,690,534,858,857,711,809,436,439,438,843,524,735,691,530,705,729,441,442,734,698,536,473,474,732,353,445,444,836,689,443,837,838,840,839,822,354,447,823,446,448,687,453,454,455,728,699,727,355,449,785,786,841,842,867,784,696,783,781,787,379,450,733,694,380,451,714,381,452,710,865,356,825,847,848,489,357,367,456,609,458,457,529,701,779,715,766,459,461,683,672,460,462,684,669,464,528,681,465,466,844,894,697,685,467,469,470,471,475,476,478,479,845,895,480,725,679,686,482,483,484,522,671,682,738,743,745,747,849,850,851,852,371,372,821,374,607,605,606,346) ORDER BY item.title%3A1 ASC LIMIT 180,20 |
debug_backtrace | require#76 // include#446 // TSpagegen::renderContent#77 // tslib_cObj->cObjGet#332 // tslib_cObj->cObjGetSingle#444 // tslib_cObj->TEMPLATE#578 // tslib_cObj->cObjGetSingle#2473 // tslib_cObj->CONTENT#529 // tslib_cObj->cObjGetSingle#1255 // tslib_cObj->cObjGetSingle#483 // tslib_cObj->CASEFUNC#550 // tslib_cObj->cObjGetSingle#1570 // tslib_cObj->COBJ_ARRAY#502 // tslib_cObj->cObjGet#686 // tslib_cObj->cObjGetSingle#444 // tslib_cObj->CASEFUNC#550 // tslib_cObj->cObjGetSingle#1570 // tslib_cObj->cObjGetSingle#483 // tslib_cObj->USER#572 // tslib_cObj->callUserFunction#724 // call_user_func_array#5866 // tx_ecommerce_pi1->main# // tx_ecommerce_pi1->listView#135 // tx_ecommerce_pi1->readItemsDB#778 // t3lib_DB->exec_SELECTgetRows#863 // t3lib_DB->debug#315 |
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|