I'm setting up a new killboard for my alliance and am getting this error after a successful install:
Database error: Expression #1 of ORDER BY clause is not in SELECT list, references column 'alliance_kb.ina.ina_timestamp' which is not in SELECT list; this is incompatible with DISTINCT
SQL: SELECT DISTINCT kll_id FROM kb3_kills kll STRAIGHT_JOIN kb3_ships shp ON ( shp.shp_id = kll.kll_ship_id ) STRAIGHT_JOIN kb3_ship_classes scl ON ( scl.scl_id = shp.shp_class ) INNER JOIN kb3_inv_all ina ON (ina.ina_kll_id = kll.kll_id) WHERE ina.ina_all_id in (1 ) AND ina.ina_timestamp >= '2017-09-11 00:00:00' AND ina.ina_timestamp <= '2017-09-17 23:59:59' AND shp.shp_class not in ( 2,3,11,53 ) order by ina.ina_timestamp desc
I'm setting up a new killboard for my alliance and am getting this error after a successful install:
Database error: Expression #1 of ORDER BY clause is not in SELECT list, references column 'alliance_kb.ina.ina_timestamp' which is not in SELECT list; this is incompatible with DISTINCT SQL: SELECT DISTINCT kll_id FROM kb3_kills kll STRAIGHT_JOIN kb3_ships shp ON ( shp.shp_id = kll.kll_ship_id ) STRAIGHT_JOIN kb3_ship_classes scl ON ( scl.scl_id = shp.shp_class ) INNER JOIN kb3_inv_all ina ON (ina.ina_kll_id = kll.kll_id) WHERE ina.ina_all_id in (1 ) AND ina.ina_timestamp >= '2017-09-11 00:00:00' AND ina.ina_timestamp <= '2017-09-17 23:59:59' AND shp.shp_class not in ( 2,3,11,53 ) order by ina.ina_timestamp desc