Strange screen output in aps-installer installed packages

[The-Ghost]

This is what the pages is showing


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 ORDER BY package_name LIMIT 0, 15) -> mysqli_query FUNCTION dbispconfig.CONCAT does not exist#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 ORDER BY package_name LIMIT 0, 15) called at [/usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php:144] #1 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 ORDER BY package_name LIMIT 0, 15) called at [/usr/local/ispconfig/interface/web/sites/aps_installedpackages_list.php:112]
Installed packages

If you want I can also make a screen shot

Regards,
Carlo

[till]

Seems as if a field in a database table is missing on your server.

Which ispconfig version is installed?
Which ispconfig version was instaklled before or is this a new install?
Do you have aps packages installed?

[The-Ghost]

Hi

ISP 3.0.5 is installed now
Latest stable 3.0.4 stable was on this server, from that one I update to 3.0.5
Aps packages are downloaded, I didn't install one yet

Regards,
Carlo

[till]

Ok. Which mysql version is installed on that server?

[The-Ghost]

The mysql is running version 5.0.95

[falko]

Can you open phpMyAdmin and run

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 ORDER BY package_name LIMIT 0, 15

and

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 ORDER BY package_name LIMIT 0, 15

?

Does the second work? The problem seems to be the space after CONCAT (see http://biostall.com/resolving-mysql-...does-not-exist ).

[The-Ghost]

This is the output of the first query



Server: localhost Database: dbispconfig


Error

There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem
ERROR: Unknown Punctuation String @ 421
STR: =\
SQL: 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 ORDER BY package_name LIMIT 0, 15


SQL 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 ORDER BY package_name LIMIT 0, 15

MySQL said:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'main_domain\' AND instance_id = aps_instances.id), \'/\', (SELECT value FROM a' at line 1

[ Back ]

[falko]

The problem is that old MySQL versions (5.0) don't like a space after the CONCAT command.

I've fixed this in SVN, so it will be part of the next release.