| Message | File | Line | System message | Addon |
| ER_DB_QUERY | /var/www/zveno/data/www/cl2.cairo.com.ua/usr/lib/csystem.php | 723 | Column 'ent_mod_time' in order clause is ambiguous | SELECT `entities`.`entid` FROM entities LEFT JOIN ent_content ON ent_content.entchildid=entities.entid LEFT JOIN ent_accept ON ent_content.entacid=ent_accept.entacid LEFT JOIN etype_accept ON ent_accept.etacid=etype_accept.etacid INNER JOIN `class_offer` ON `class_offer`.`entid`=`entities`.`entid` LEFT JOIN `dic_records` AS `cairo_tbl_category` ON (`class_offer`.`category`=`cairo_tbl_category`.value AND `cairo_tbl_category`.dicid = '1') LEFT JOIN `dic_records` AS `cairo_tbl_subcategory` ON (`class_offer`.`subcategory`=`cairo_tbl_subcategory`.value AND `cairo_tbl_subcategory`.dicid = '2') LEFT JOIN `entities` AS `cairo_tbl_bank` ON (`class_offer`.`bank`=`cairo_tbl_bank`.entid) INNER JOIN `class_bank` ON (`class_offer`.`bank` = `class_bank`.`entid` AND (`hide_offers` IS NULL OR `hide_offers` = 0)) WHERE 1 AND ((IF(`image` IS NULL, 1, 0) < 0 OR (IF(`image` IS NULL, 1, 0) = 0 AND (`entities`.`ent_mod_time` > '2010-03-22 21:39:29' OR (`entities`.`ent_mod_time` > '2010-03-22 21:39:29' AND `entities`.`entid` > 7430))))) AND ((entities.uid = 0 AND entities.ent_perm & 256 ) OR (entities.gid IN ('0') AND entities.ent_perm & 32 ) OR entities.ent_perm & 4 ) ORDER BY IF(`image` IS NULL, 1, 0) DESC, `ent_mod_time` ASC, `entities`.`entid` ASC |
| ER_CANT_GET_ENTITIES_LIST | /var/www/zveno/data/www/cl2.cairo.com.ua/core/centitylist.php | 749 | ||
| Can't get entity list | /var/www/zveno/data/www/zalogtorg.com.ua/usr/widgets/cfofferslist.class.php | 301 | ||
| ER_DB_QUERY | /var/www/zveno/data/www/cl2.cairo.com.ua/usr/lib/csystem.php | 723 | Column 'ent_mod_time' in order clause is ambiguous | SELECT `entities`.`entid` FROM entities LEFT JOIN ent_content ON ent_content.entchildid=entities.entid LEFT JOIN ent_accept ON ent_content.entacid=ent_accept.entacid LEFT JOIN etype_accept ON ent_accept.etacid=etype_accept.etacid INNER JOIN `class_offer` ON `class_offer`.`entid`=`entities`.`entid` LEFT JOIN `dic_records` AS `cairo_tbl_category` ON (`class_offer`.`category`=`cairo_tbl_category`.value AND `cairo_tbl_category`.dicid = '1') LEFT JOIN `dic_records` AS `cairo_tbl_subcategory` ON (`class_offer`.`subcategory`=`cairo_tbl_subcategory`.value AND `cairo_tbl_subcategory`.dicid = '2') LEFT JOIN `entities` AS `cairo_tbl_bank` ON (`class_offer`.`bank`=`cairo_tbl_bank`.entid) INNER JOIN `class_bank` ON (`class_offer`.`bank` = `class_bank`.`entid` AND (`hide_offers` IS NULL OR `hide_offers` = 0)) WHERE 1 AND ((IF(`image` IS NULL, 1, 0) > 0 OR (IF(`image` IS NULL, 1, 0) = 0 AND (`entities`.`ent_mod_time` < '2010-03-22 21:39:29' OR (`entities`.`ent_mod_time` < '2010-03-22 21:39:29' AND `entities`.`entid` < 7430))))) AND ((entities.uid = 0 AND entities.ent_perm & 256 ) OR (entities.gid IN ('0') AND entities.ent_perm & 32 ) OR entities.ent_perm & 4 ) ORDER BY IF(`image` IS NULL, 1, 0) ASC, `ent_mod_time` DESC, `entities`.`entid` DESC |
| ER_CANT_GET_ENTITIES_LIST | /var/www/zveno/data/www/cl2.cairo.com.ua/core/centitylist.php | 749 | ||
| Can't get entity list | /var/www/zveno/data/www/zalogtorg.com.ua/usr/widgets/cfofferslist.class.php | 341 |
