automateks
20-12-2015, 12:36
Po aktualizacji VIRTUEMART z wersji 2.6 do 3.0.12 nie mogę wejść w ustawienia.:
[*=1]Virtuemart -> Zamówienia
[*=1]Virtuemart -> Sklep
Gdy wejdę w te opcje pojawia się komunikat.:
Nieznany błąd
1054 Unknown column 'u.customer_note' in 'field list' SQL=SELECT SQL_CALC_FOUND_ROWS o.*, CONCAT_WS(' ',u.company,u.first_name,u.middle_name,u.last_name ) 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 fxwvh_virtuemart_orders as o LEFT JOIN fxwvh_virtuemart_order_userinfos as u ON u.virtuemart_order_id = o.virtuemart_order_id AND u.address_type="BT" LEFT JOIN fxwvh_virtuemart_order_userinfos as st ON st.virtuemart_order_id = o.virtuemart_order_id AND st.address_type="ST" LEFT JOIN fxwvh_virtuemart_paymentmethods_pl_pl as pm ON o.virtuemart_paymentmethod_id = pm.virtuemart_paymentmethod_id WHERE ( o.virtuemart_vendor_id = "1" ) ORDER BY created_on DESC LIMIT 0, 20
Inne opcje w komponencie Virtuemart działają poprawnie.
Proszę pomóżcie.
mail zamowienia.automatyka@gmail.com
[*=1]Virtuemart -> Zamówienia
[*=1]Virtuemart -> Sklep
Gdy wejdę w te opcje pojawia się komunikat.:
Nieznany błąd
1054 Unknown column 'u.customer_note' in 'field list' SQL=SELECT SQL_CALC_FOUND_ROWS o.*, CONCAT_WS(' ',u.company,u.first_name,u.middle_name,u.last_name ) 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 fxwvh_virtuemart_orders as o LEFT JOIN fxwvh_virtuemart_order_userinfos as u ON u.virtuemart_order_id = o.virtuemart_order_id AND u.address_type="BT" LEFT JOIN fxwvh_virtuemart_order_userinfos as st ON st.virtuemart_order_id = o.virtuemart_order_id AND st.address_type="ST" LEFT JOIN fxwvh_virtuemart_paymentmethods_pl_pl as pm ON o.virtuemart_paymentmethod_id = pm.virtuemart_paymentmethod_id WHERE ( o.virtuemart_vendor_id = "1" ) ORDER BY created_on DESC LIMIT 0, 20
Inne opcje w komponencie Virtuemart działają poprawnie.
Proszę pomóżcie.
mail zamowienia.automatyka@gmail.com