Strange screen output in aps-installer installed packages

Discussion in 'Installation/Configuration' started by The-Ghost, Feb 26, 2013.

  1. The-Ghost

    The-Ghost New Member

    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
     
  2. till

    till Super Moderator

    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?
     
  3. The-Ghost

    The-Ghost New Member

    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
     
  4. till

    till Super Moderator

    Ok. Which mysql version is installed on that server?
     
  5. The-Ghost

    The-Ghost New Member

    The mysql is running version 5.0.95
     
  6. falko

    falko Super Moderator

    Can you open phpMyAdmin and run

    Code:
    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

    Code:
    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-error-function-concat-does-not-exist ).
     
    Last edited: Feb 27, 2013
  7. The-Ghost

    The-Ghost New Member

    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 ]
     
  8. falko

    falko Super Moderator

    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.
     

Share This Page