Error when trying to view a product (upgraded from SugarCRM 6.5.18 to SuiteCRM 7.4.3

The display shows an error and suggest looking at the log files which show the sql error below

12/24/15 11:43:23 [96332][b808b003-9e53-0428-2382-52bd5aaff38a][FATAL] Error running count query for AOS_Products List: Query Failed:(
SELECT count() c FROM (
SELECT
aos_quotes.
,
accounts.id AS account_id,
accounts.name AS billing_account,

				opportunity_id AS opportunity,
				billing_contact_id AS billing_contact,
				'' AS created_by_name,
				'' AS modified_by_name,
				'' AS assigned_user_name
			FROM
				aos_products

			JOIN aos_products_quotes ON aos_products_quotes.product_id = aos_products.id AND aos_products.id = N'14c99a87-6dcd-af91-17a5-567bb518ae85' AND aos_products_quotes.deleted = 0 AND aos_products.deleted = 0
			JOIN aos_quotes ON aos_quotes.id = aos_products_quotes.parent_id AND aos_quotes.stage = N'Closed Accepted' AND aos_quotes.deleted = 0
			JOIN accounts ON accounts.id = aos_quotes.billing_account_id -- AND accounts.deleted = 0

			GROUP BY accounts.id
		) AS aos_quotes

	)::: [Microsoft][SQL Server Native Client 11.0][SQL Server]Column 'aos_quotes.id' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.

I’m getting this as well. Anyone have a fix?

sorry for the spam couldn’t edit my post.

this is related to AJAX. Disabling AJAX for the products module seemed to have fixed the issue. Interestingly editing the product from the quotes page worked, but not from the products module when AJAX was active,

Admin -> System Settings -> ConfigureAJAX to disable it for PRODUCTS