- Fixed "FUNCTION databasename.CONCAT does not exist" error for older MySQL...

ftimme

2013-02-27 f4038a2160d55a7f519a3b42be1aa96e29e9a908

- Fixed "FUNCTION databasename.CONCAT does not exist" error for older MySQL versions.

 interface/web/sites/aps_installedpackages_list.php

@@ -90,7 +90,7 @@
                 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), 
              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, client 

@@ -101,7 +101,7 @@
                 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), 
              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