#1  
Old 11th March 2013, 01:00
Toucan Toucan is offline
Senior Member
 
Join Date: Dec 2009
Posts: 479
Thanks: 78
Thanked 40 Times in 34 Posts
Default APS Installer

I'm running 3.0.5.1 on debian lenny - 1 master 1 slave.

When using the aps installer, I just get the follow output from the control panel:
Code:
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:157] #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]
This is the case when attempting to install drupal.

This seems to be the same when installing on both master and slave servers and when checking the file system, it doesn't seem to have installed tha app. Any ideas please?

David

Last edited by Toucan; 11th March 2013 at 01:04.
Reply With Quote
Sponsored Links
  #2  
Old 11th March 2013, 12:43
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,402
Thanks: 834
Thanked 5,494 Times in 4,325 Posts
Default

Thats a bug in the mysql version insalled on your server, mysql does not understand whitespaces between concat and ( in your version while it works in newer mysql releases. A workaround for older mysql versions has been implemented in ISPconfig svn 3.0.5 stable branch.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 15th March 2013, 21:55
Toucan Toucan is offline
Senior Member
 
Join Date: Dec 2009
Posts: 479
Thanks: 78
Thanked 40 Times in 34 Posts
Default

Thanks -- so it's just a case of waiting for it to be released in the next update?
Reply With Quote
  #4  
Old 16th March 2013, 10:59
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,743 Times in 2,577 Posts
 
Default

Yes, that's right.
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
APS Installer - version? sageman General 4 22nd July 2013 11:10
APS Installer in mirror setup diablo666 Installation/Configuration 0 4th March 2013 16:50
APS Installer Available packages (0) scorpious General 3 3rd January 2013 22:00
APS Installer SupuS Developers' Forum 9 6th October 2012 12:17
ISPConfig APS installer/ Billing Karnith General 1 2nd June 2009 13:05


All times are GMT +2. The time now is 16:57.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.