Hello,
Im having some trouble when i try to see a data from products sub panel purchases.
There should be some data in where I pointed.
And if I click on any of the buttons I marked I’m getting ''database failure please refer to suitecrm.log"
Tue Apr 28 23:06:03 2020 [962207][1][FATAL] Mysqli_query failed.
Tue Apr 28 23:06:03 2020 [962207][1][FATAL] Error retrieving AOS_Products list: Query Failed: (
SELECT * 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 = '4daae69a-f2de-b3f6-6df0-5ea722561b40' 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 = 'Closed Accepted' AND aos_quotes.deleted = 0
JOIN accounts ON accounts.id = aos_quotes.billing_account_id -- AND accounts.deleted = 0
GROUP BY aos_quotes.id
) AS aos_quotes
) ORDER BY aos_quotes_cstm.ayrilmatarihisonu_c desc LIMIT 0,10: MySQL error 1054: Unknown column 'aos_quotes_cstm.ayrilmatarihisonu_c' in 'order clause'
Tue Apr 28 23:06:03 2020 [962207][1][FATAL] [ListView::processUnionBeans] . Database failure. Please refer to suitecrm.log for details.
Please help me.