Nexus: ACP: AJAX Package list doesn't load

In the ACP for Nexus 1.1, clicking the expand button for a package group does not expand the package list. An error relating to a SELECT list column not in the GROUP BY clause is logged.

Date: Sun, 16 Jan 2011 05:02:14 +0000
 Error: 8120 - [Microsoft][SQL Server Native Client 10.0][SQL Server]Column 'nexus_packages.p_name' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.

 IP Address: REDACTED - /admin/index.php?adsess=REDACTED&app=nexus&module=ajax&section=packages&do=children&id=2
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 MSSQL query error:
SELECT *,SUM(opt_stock) as _stock FROM nexus_packages p  LEFT JOIN nexus_product_options opt ON ( opt.opt_package=p.p_id )   WHERE p_group=2 GROUP BY p_id ORDER BY p_position
 .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
 | File                                                                   	| Function                                                                  	| Line No.      	|
 |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
 | \ips_kernel\classDb.php                                                	| [db_driver_mssql].query                                                   	| 1102          	|
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | \admin\applications_addon\ips\nexus\modules_admin\ajax\packages.php    	| [admin_nexus_ajax_packages]._returnResults                                	| 237           	|
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | \admin\applications_addon\ips\nexus\modules_admin\ajax\packages.php    	| [admin_nexus_ajax_packages].getChildren                                   	| 37            	|
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | \admin\sources\base\ipsController.php                                  	| [admin_nexus_ajax_packages].doExecute                                     	| 406           	|
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | \admin\sources\base\ipsController.php                                  	| [ipsAjaxCommand].execute                                                  	| 112           	|
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Komentarze:

Brak komentarzy