بعد از نصب با ارور مواجه شدم

[maralweb 7]

بعد از نصب کامپوننت ارسال فاکتور با خطای زیر مواجه شدم

1054 Unknown column 'i.type' in 'where clause' SQL=SELECT i.*, u.name as username, co.name as contact_name, co.user_id as joomla_user_id, SUM(DISTINCT pa.payment_amount) AS total_paid, SUM(DISTINCT pa2.payment_amount) AS total_unpaid, SUM(DISTINCT pa3.payment_amount) AS total_unpaid_ontime, COUNT(DISTINCT pa.id) AS paid_payments, COUNT(DISTINCT pa2.id) AS unpaid_payments, COUNT(DISTINCT pa3.id) AS unpaid_payments_ontime FROM w9zmr_invoices_invoices as i LEFT JOIN w9zmr_invoices_contacts as co ON co.id = i.user_id LEFT JOIN w9zmr_invoices_payments as pa ON (pa.invoice_id = i.id AND pa.payment_status = 1) LEFT JOIN w9zmr_invoices_payments as pa2 ON (pa2.invoice_id = i.id AND pa2.payment_status = 0) LEFT JOIN w9zmr_invoices_payments as pa3 ON (pa3.invoice_id = i.id AND pa3.payment_status = 0 AND (pa3.payment_duedate > NOW() OR pa3.payment_duedate = "0000-00-00 00:00:00")) LEFT JOIN w9zmr_users as u ON u.id = co.user_id WHERE i.type = 1 GROUP BY i.id ORDER BY i.id DESC

چرا؟

[saber 208]

چک کنید افزونه ای که نصب کردید با نسخه جوملای شما سازگار باشه

[maralweb 7]

قبلا رو همین جوملا نصب کرده بودم بعد اینکه هاستم عوض کردم با این خطا مواجه شدم

[mrsz 21]

به هاست تیکت بزنید رفع میکنه براتون