APS Packagelist: SQL error when using filter
When you use the "Name" or "Client" fields to filter out packages in the package list, you get the following error:
DB::query(SELECT count() AS anzahl FROM aps_instances,aps_packages WHERE aps_instances.package_id = aps_packages.id and customer_name LIKE '%ad%' ) -> mysqli_query Unknown column 'customer_name' in 'where clause'#0 db->query(SELECT count() AS anzahl FROM aps_instances,aps_packages WHERE aps_instances.package_id = aps_packages.id and customer_name LIKE '%ad%' ) called at [/usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php:126] #1 (closed) db->queryOneRecord(SELECT count(*) AS anzahl FROM aps_instances,aps_packages WHERE aps_instances.package_id = aps_packages.id and customer_name LIKE '%ad%' ) called at [/usr/local/ispconfig/interface/lib/classes/listform.inc.php:219] #2 (closed) listform->getPagingSQL( aps_instances.package_id = aps_packages.id and customer_name LIKE '%ad%' ) called at [/usr/local/ispconfig/interface/web/sites/aps_installedpackages_list.php:82] DB::query(SELECT aps_instances.id AS id, aps_instances.package_id AS package_id, aps_instances.customer_id AS customer_id, sys_group.name AS customer_name, aps_instances.instance_status AS instance_status, aps_packages.name AS package_name, aps_packages.version AS package_version, aps_packages.release AS package_release, aps_packages.package_status AS package_status, CONCAT ((SELECT value FROM aps_instances_settings WHERE name='main_domain' AND instance_id = aps_instances.id), '/', (SELECT value FROM aps_instances_settings WHERE name='main_location' AND instance_id = aps_instances.id)) AS install_location FROM aps_instances, aps_packages, sys_group WHERE sys_group.client_id = aps_instances.customer_id AND aps_instances.package_id = aps_packages.id and customer_name LIKE '%ad%' ORDER BY package_name LIMIT 0, 15) -> mysqli_query Unknown column 'customer_name' in 'where clause'#0 db->query(SELECT aps_instances.id AS id, aps_instances.package_id AS package_id, aps_instances.customer_id AS customer_id, sys_group.name AS customer_name, aps_instances.instance_status AS instance_status, aps_packages.name AS package_name, aps_packages.version AS package_version, aps_packages.release AS package_release, aps_packages.package_status AS package_status, CONCAT ((SELECT value FROM aps_instances_settings WHERE name='main_domain' AND instance_id = aps_instances.id), '/', (SELECT value FROM aps_instances_settings WHERE name='main_location' AND instance_id = aps_instances.id)) AS install_location FROM aps_instances, aps_packages, sys_group WHERE sys_group.client_id = aps_instances.customer_id AND aps_instances.package_id = aps_packages.id and customer_name LIKE '%ad%' ORDER BY package_name LIMIT 0, 15) called at [/usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php:112] #1 (closed) db->queryAllRecords(SELECT aps_instances.id AS id, aps_instances.package_id AS package_id, aps_instances.customer_id AS customer_id, sys_group.name AS customer_name, aps_instances.instance_status AS instance_status, aps_packages.name AS package_name, aps_packages.version AS package_version, aps_packages.release AS package_release, aps_packages.package_status AS package_status, CONCAT ((SELECT value FROM aps_instances_settings WHERE name='main_domain' AND instance_id = aps_instances.id), '/', (SELECT value FROM aps_instances_settings WHERE name='main_location' AND instance_id = aps_instances.id)) AS install_location FROM aps_instances, aps_packages, sys_group WHERE sys_group.client_id = aps_instances.customer_id AND aps_instances.package_id = aps_packages.id and customer_name LIKE '%ad%' ORDER BY package_name LIMIT 0, 15) called at [/usr/local/ispconfig/interface/web/sites/aps_installedpackages_list.php:111]