#2913 Death Date and Place report generates SQL error PHP 7.0.1 svn 7117

[vince-br549]

fill in a name on the report and hit enter.... get
Fatal error: Uncaught PDOException: SQLSTATE[42P10]: Invalid column reference: 7 ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list LINE 1: ...PLAC%' AND filter4.n_full ILIKE '%LUND%' ORDER BY filter4.n_... ^ in /var/www/html/gedview/includes/classes/class_pgv_db.php:848 Stack trace: #0 /var/www/html/gedview/includes/classes/class_pgv_db.php(848): PDOStatement->execute() #1 /var/www/html/gedview/includes/classes/class_pgv_db.php(863): PGV_DBStatement->call('execute', Array) #2 /var/www/html/gedview/includes/functions/functions_db.php(1170): PGV_DBStatement->call('fetchAll', Array) #3 /var/www/html/gedview/includes/classes/class_reportbase.php(3313): search_indis_custom(Array, Array, Array) #4 /var/www/html/gedview/includes/classes/class_reportbase.php(1438): PGVRListSHandler(Array) #5 [internal function]: startElement(Resource id #5, 'PGVRList', Array) #6 /var/www/html/gedview/reportengine.php(387): xml_parse(Resource id #5, '<?xml in /var/www/html/gedview/includes/classes/class_pgv_db.php on line 848

--
Vince

[vince-br549]

the changes report also fails:
Fatal error: Uncaught PDOException: SQLSTATE[42P10]: Invalid column reference: 7 ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list LINE 1: ...'CHAN' AND filter2.d_julianday1>=2457355 ORDER BY filter1.d_... ^ in /var/www/html/gedview/includes/classes/class_pgv_db.php:848 Stack trace: #0 /var/www/html/gedview/includes/classes/class_pgv_db.php(848): PDOStatement->execute() #1 /var/www/html/gedview/includes/classes/class_pgv_db.php(863): PGV_DBStatement->call('execute', Array) #2 /var/www/html/gedview/includes/functions/functions_db.php(1170): PGV_DBStatement->call('fetchAll', Array) #3 /var/www/html/gedview/includes/classes/class_reportbase.php(3313): search_indis_custom(Array, Array, Array) #4 /var/www/html/gedview/includes/classes/class_reportbase.php(1438): PGVRListSHandler(Array) #5 [internal function]: startElement(Resource id #5, 'PGVRList', Array) #6 /var/www/html/gedview/reportengine.php(387): xml_parse(Resource id #5, '\n\t\t in /var/www/html/gedview/includes/classes/class_pgv_db.php on line 848

[Gerry Kroll]

I'm trying to clean up the list of open bug reports.

Does this error still occur when you run the latest version (4.3.0) of PhpGedView?

[Gerry Kroll]

I'm going to close this bug report. I think the problem was fixed in version 4.3.0