MDB2 Error: no such table
1083: _doQuery: [Error message: Could not execute statement] [Last executed query: SELECT SQL_CALC_FOUND_ROWS txttbl.`NOVINKA_DO`, txttbl.`ART_NO`, txttbl.id,DATE_FORMAT(IF(act_date IS NOT NULL AND act_date>txttbl.add_date,act_date,txttbl.add_date),"%d.%m.%Y %H:%i") AS `act_date`,txttbl.id_zadal,txttbl.user_name,txttbl.name,IF(s_text IS NOT NULL AND s_text<>'',s_text,SUBSTRING(l_text,1,100)) AS `text`,txttbl.active,txttbl.auth,IF(act_date IS NOT NULL AND act_date>txttbl.add_date,act_date,txttbl.add_date)>NOW() AS pozdeji,DOSTUPNOST ,txttbl.`KUSU` ,tbl_VYROBCE.val AS 'VYROBCE' ,txttbl.`CENA_AKCE` ,txttbl.`CENA_1` ,txttbl.`EPOCHA` ,txttbl.`MERITKO` ,tbl_OBRAZEK.val AS 'OBRAZEK' FROM (red_txt AS txttbl ,red_cats4txt AS cattxt ,cat_cache ) LEFT JOIN red_txt_classes AS tbl_OBRAZEK ON tbl_OBRAZEK.id_txt=txttbl.id AND tbl_OBRAZEK.id_class='2' LEFT JOIN red_txt_classes AS tbl_VYROBCE ON tbl_VYROBCE.id_txt=txttbl.id AND tbl_VYROBCE.id_class='1' WHERE txttbl.PRODUKT=1 AND cat_cache.id_txt=txttbl.id AND cat_cache.val_id='124' AND txttbl.auth=1 AND txttbl.active=1 AND NOW()>IF(act_date IS NOT NULL AND act_date>txttbl.add_date,act_date,txttbl.add_date) AND cattxt.id_txt=txttbl.id AND cattxt.id_cat='715' GROUP BY txttbl.id ORDER BY prior ASC ,IF(act_date IS NOT NULL AND act_date>txttbl.add_date,act_date,txttbl.add_date) DESC LIMIT 0,10 ] [Native code: 1146] [Native message: Table 'masinky.cat_cache' doesn't exist]