Здравствуйте. Joomla 3.5.1 VirtueMart 3.0.18
При заходе в панель управления VirtueMart стала появится такая ошибка:
1054 Unknown column 'first_name' in 'field list' SQL=SELECT `id` as `virtuemart_user_id`, `first_name`, `last_name`, `order_number` FROM `#__users` as `u` JOIN `#__virtuemart_vmusers` as uv ON u.id = uv.virtuemart_user_id JOIN `#__virtuemart_userinfos` as ui ON u.id = ui.virtuemart_user_id JOIN `#__virtuemart_orders` as uo ON u.id = uo.virtuemart_user_id ORDER BY uo.`created_on` DESC LIMIT 0, 5
При входе в раздел Заказы:
1054 Unknown column 'u.city' in 'field list' SQL=SELECT SQL_CALC_FOUND_ROWS o.*, CONCAT_WS(' ',u.company) AS order_name ,u.email as order_email, pm.payment_name AS payment_method, u.company AS company, u.city AS city, u.zip AS zip, u.phone_1 AS phone, st.address_type AS st_type, st.company AS st_company, st.city AS st_city, st.zip AS st_zip, u.customer_note AS customer_note FROM #__virtuemart_orders as o LEFT JOIN #__virtuemart_order_userinfos as u ON u.virtuemart_order_id = o.virtuemart_order_id AND u.address_type="BT" LEFT JOIN #__virtuemart_order_userinfos as st ON st.virtuemart_order_id = o.virtuemart_order_id AND st.address_type="ST" LEFT JOIN #__virtuemart_paymentmethods_ru_ru as pm ON o.virtuemart_paymentmethod_id = pm.virtuemart_paymentmethod_id ORDER BY created_on DESC LIMIT 0, 30
При входе в раздел Магазин:
1054 Unknown column 'u.city' in 'field list' SQL=SELECT o.*, CONCAT_WS(' ',u.company) AS order_name ,u.email as order_email, pm.payment_name AS payment_method, u.company AS company, u.city AS city, u.zip AS zip, u.phone_1 AS phone, st.address_type AS st_type, st.company AS st_company, st.city AS st_city, st.zip AS st_zip, u.customer_note AS customer_note FROM #__virtuemart_orders as o LEFT JOIN #__virtuemart_order_userinfos as u ON u.virtuemart_order_id = o.virtuemart_order_id AND u.address_type="BT" LEFT JOIN #__virtuemart_order_userinfos as st ON st.virtuemart_order_id = o.virtuemart_order_id AND st.address_type="ST" LEFT JOIN #__virtuemart_paymentmethods_ru_ru as pm ON o.virtuemart_paymentmethod_id = pm.virtuemart_paymentmethod_id WHERE ( u.virtuemart_user_id = 393 AND u.virtuemart_user_id = 393 ) order by o.modified_on DESC
Как я понял проблема в бд но как это пофиксить и где не знаю потому что я не силен в нем. Если кто знает помогите.