Database Error on Fresh Installation

Help and support in getting the EVE-Dev Killboard to run on your site.
Post Reply
madbraces
Noob
Posts: 1
Joined: Sat Sep 26, 2020 12:49

Database Error on Fresh Installation

Post by madbraces »

Once completed the last instllation step, visiting the kb page I get this:

Database error: Expression #1 of ORDER BY clause is not in SELECT list, references column '*******.inc.inc_timestamp' which is not in SELECT list; this is incompatible with DISTINCT
SQL: SELECT DISTINCT kll_id, kll_timestamp 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_crp inc ON (inc.inc_kll_id = kll.kll_id) WHERE inc.inc_crp_id in (1 ) AND inc.inc_timestamp >= '2020-09-21 00:00:00' AND inc.inc_timestamp <= '2020-09-27 23:59:59' AND shp.shp_class not in ( 2,3,11,53 ) order by inc.inc_timestamp desc
ERROR [256] SQL error (Expression #1 of ORDER BY clause is not in SELECT list, references column '*******.inc.inc_timestamp' which is not in SELECT list; this is incompatible with DISTINCT
Error on line 46 in file /web/htdocs/www.*******.*******/home/kb/common/includes/class.dbnormalquery.php
PHP 7.3.22 (Linux), EDK 4.4.3.0 (July 2019 1.0)
File: /web/htdocs/www.*******.*******/home/kb/common/includes/class.dbnormalquery.php, line: 46, function: trigger_error
File: /web/htdocs/www.*******.*******/home/kb/common/includes/class.killlist.php, line: 602, class: DBNormalQuery, function: execute
File: /web/htdocs/www.*******.*******/home/kb/common/includes/class.killlist.php, line: 1008, class: KillList, function: execQuery
File: /web/htdocs/www.*******.*******/home/kb/common/home.php, line: 245, class: KillList, function: getCount
File: /web/htdocs/www.*******.*******/home/kb/common/includes/class.pageassembly.php, line: 72, class: pHome, function: killList
File: /web/htdocs/www.*******.*******/home/kb/common/includes/class.pageassembly.php, line: 37, class: pageAssembly, function: call
File: /web/htdocs/www.*******.*******/home/kb/common/home.php, line: 861, class: pageAssembly, function: assemble
File: /web/htdocs/www.*******.*******/home/kb/common/index.php, line: 324, function: include
File: /web/htdocs/www.*******.*******/home/kb/index.php, line: 26, function: include

The installation is on a remote server without cpanel access.
Is there a solution for this?
I'm definitely not familiar with programming and codes, so, please, don't be rude :D

Post Reply