We're updating the issue view to help you get more done. 

Configuration export fails for ORDER BY clause on ca_relationship_types

Description

Configuration export fails with:

Error 250: Invalid SQL statement
Expression #1 of ORDER BY clause is not in SELECT list, references column 'providence01.ca_relationship_types.type_id' which is not in SELECT list; this is incompatible with DISTINCT (in Db->mysqli->execute())
Request halted.

Problem seems to be in app/lib/ca/ConfigurationExporter.php with query "SELECT DISTINCT table_num FROM ca_relationship_types ORDER BY type_id"

After changing "ORDER BY type_id" to "ORDER BY table_num", configuration export is successful.

Environment

None

Assignee

User known

Reporter

Paolo Martini

Labels

None

Components

Fix versions

Priority

Major
Configure