Pagine: [1] |   Vai gių
  Stampa  
Autore Discussione: 1054 Unknown column - VM3  (Letto 341 volte)
Gobbist
Newbie
*
Scollegato

Messaggi: 4


« inserito:: 28 Lug 2017, 14:44 »

Ciao a tutti,
sto trasferendo virtuemart dalla versione 2 con joomla 2.5 alla 3.6 con vm3.
Ho importato quasi tutto con mysql, ma la riga xxxxx_virtuemart_order_userinfos, pur essendo importata correttamente, da questo errore quando entro nella lista degli ordini:

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, sm.shipment_name AS shipment_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_it_it as pm ON o.virtuemart_paymentmethod_id = pm.virtuemart_paymentmethod_id LEFT JOIN #__virtuemart_shipmentmethods_it_it as sm ON o.virtuemart_shipmentmethod_id = sm.virtuemart_shipmentmethod_id ORDER BY created_on DESC LIMIT 0, 50

Come posso risolvere?

Joomla! 3.6.5 e Virtuemart 3.2.2

Grazie a tutti!
Registrato
Pagine: [1] |   Vai su
  Stampa  
 
Vai a:  




anything