Database error: Unknown column 'comm.id' in 'field list'
SQL: select kll.kll_id, kll.kll_timestamp, kll.kll_points, kll.kll_involved, kll.kll_club_status, kll.kll_dmgtaken, plt.plt_id, plt.plt_name, plt.plt_externalid, plt.plt_member, crp.crp_name, crp.crp_id, ali.all_name, ali.all_id, fct.fct_name, fct.fct_id, shp.shp_id, shp.shp_name, shp.shp_externalid, shp.shp_baseprice, shp.custom_price AS shp_price, scl.scl_id, scl.scl_class, scl.scl_value, scl.scl_points, sys.sys_id, sys.sys_name, (CASE WHEN sys.sys_sec < 0.05 AND sys.sys_sec > 0 THEN 0.1 ELSE sys.sys_sec END) AS sys_sec, cons.con_name, region.reg_name, fbplt.plt_id as fbplt_id, fbplt.plt_externalid as fbplt_externalid, fbplt.plt_name as fbplt_name, fbcrp.crp_id as fbcrp_id, fbcrp.crp_name as fbcrp_name, fballi.all_id as fballi_id, fballi.all_name as fballi_name, fbfct.fct_id as fbfct_id, fbfct.fct_name as fbfct_name, count(distinct comm.id) as comment_count from kb3_kills kll inner join kb3_inv_all ina on (ina.ina_all_id in (269) and kll.kll_id = ina.ina_kll_id and ina.ina_all_id != kll.kll_all_id) inner join kb3_ships shp on ( shp.shp_id = kll.kll_ship_id ) inner join kb3_ship_classes scl on ( scl.scl_id = shp.shp_class ) left join kb3_comments comm on (kll.kll_id = comm.kll_id) inner join kb3_pilots plt on (plt.plt_id = kll.kll_victim_id) inner join kb3_corps crp on (crp.crp_id = kll.kll_crp_id) inner join kb3_alliances ali on (ali.all_id = kll.kll_all_id) inner join kb3_factions fct FORCE KEY (PRIMARY) on (fct.fct_id = kll.kll_fct_id) inner join kb3_pilots fbplt on (fbplt.plt_id = kll.kll_fb_plt_id) inner join kb3_corps fbcrp on (fbcrp.crp_id = kll.kll_fb_crp_id) inner join kb3_alliances fballi on (fballi.all_id = kll.kll_fb_all_id) inner join kb3_factions fbfct FORCE KEY (PRIMARY) on (fbfct.fct_id = kll.kll_fb_fct_id) inner join kb3_systems sys on (sys.sys_id = kll.kll_system_id) inner join kb3_constellations cons on (cons.con_id = sys.sys_con_id) inner join kb3_regions region on (region.reg_id = cons.con_reg_id) where 1 = 1 and kll.kll_all_id not in (269) and scl.scl_id not in (3,11,38) AND kll.date_kill >= '2010-03-08' and kll.date_kill <= '2010-04-09' group by kll.kll_id order by kll_timestamp desc limit 0, 100
Stack backtrace:
QueryResultCheck in /home6/abyssnet/public_html/kb.ds-alliance.com/common/includes/class.db_mysqli.php 235
execute in
call_user_func_array in /home6/abyssnet/public_html/kb.ds-alliance.com/common/includes/class.db_mysqli.php 71
__call in
execute in /home6/abyssnet/public_html/kb.ds-alliance.com/common/includes/class.killlist.php 420
execQuery in /home6/abyssnet/public_html/kb.ds-alliance.com/common/includes/class.killlist.php 431
getRow in /home6/abyssnet/public_html/kb.ds-alliance.com/common/includes/class.killlist.php 459
getKill in /home6/abyssnet/public_html/kb.ds-alliance.com/common/includes/class.killlisttable.php 303
generate in /home6/abyssnet/public_html/kb.ds-alliance.com/common/kills.php 41
include in /home6/abyssnet/public_html/kb.ds-alliance.com/common/index.php 208
include in /home6/abyssnet/public_html/kb.ds-alliance.com/index.php 16
борда упала
