Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > Installation/Configuration

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 26th February 2013, 19:25
The-Ghost The-Ghost is offline
Member
 
Join Date: May 2009
Posts: 59
Thanks: 5
Thanked 6 Times in 5 Posts
Default Strange screen output in aps-installer installed packages

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
Reply With Quote
Sponsored Links
  #2  
Old 26th February 2013, 19:35
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,166
Thanks: 829
Thanked 5,412 Times in 4,255 Posts
Default

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?
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 26th February 2013, 19:44
The-Ghost The-Ghost is offline
Member
 
Join Date: May 2009
Posts: 59
Thanks: 5
Thanked 6 Times in 5 Posts
Default

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
Reply With Quote
  #4  
Old 26th February 2013, 20:28
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,166
Thanks: 829
Thanked 5,412 Times in 4,255 Posts
Default

Ok. Which mysql version is installed on that server?
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #5  
Old 26th February 2013, 20:34
The-Ghost The-Ghost is offline
Member
 
Join Date: May 2009
Posts: 59
Thanks: 5
Thanked 6 Times in 5 Posts
Default

The mysql is running version 5.0.95
Reply With Quote
  #6  
Old 27th February 2013, 15:01
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,741 Times in 2,575 Posts
Default

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-...does-not-exist ).
__________________
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:

Last edited by falko; 27th February 2013 at 15:04.
Reply With Quote
  #7  
Old 27th February 2013, 15:21
The-Ghost The-Ghost is offline
Member
 
Join Date: May 2009
Posts: 59
Thanks: 5
Thanked 6 Times in 5 Posts
Default

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 ]
Reply With Quote
  #8  
Old 28th February 2013, 13:22
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,741 Times in 2,575 Posts
 
Default

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.
__________________
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
How to build packages that can be installed with the ISPConfig update function. till Tips/Tricks/Mods 3 18th February 2008 13:10
installed cd version and then updated, just a blank orange screen forever aylasslingshot Installation/Configuration 2 10th June 2007 21:00
linuxmce? Chad HOWTO-Related Questions 6 3rd May 2007 05:27
Logging in to isp config Jrdgames General 43 6th March 2006 19:04
Other Packages reccomended in new installer. Spum Developers' Forum 3 25th October 2005 10:37


All times are GMT +2. The time now is 08:17.


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