It all works fine, my products, prices etc have been migrated, but it seems that when I click on "Orders" and "Store" this error appears:
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 #__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_bg_bg as pm ON o.virtuemart_paymentmethod_id = pm.virtuemart_paymentmethod_id ORDER BY created_on DESC LIMIT 0, 30
How could I fix it?
Is it possible to solve this issue if export the same row from a clean installation and replace the current?
Also, one more question - I've got almost 2k products. In the old version there was a custom field named "size". We're selling (or trying to sell :D ) male shoes (bliddyspam, nike, etc) and we've added the sizes there.
In the now version it seems that, I quote: "vmError: The field with id 9 and title Налични размери is not longer valid, please delete it from the list"
Налични размери = Available Sizes
This is reallly important for me - is it possible to make it valid? Otherwise I would have to enter it again on all 2k products...
Could you be so kind to assist me?
BTW PHP version - 5.6.
I forgot to mention that after the migration I have used this tool:
Remove old vm2 inherited customfields
Then i used this one
Update vm2 order format of customfields to vm3 format
After that I've clicked on "Restore System Defaults".
That's pretty much all of what I did.
:)))))
"In the now version it seems that, I quote: "vmError: The field with id 9 and title Налични размери is not longer valid, please delete it from the list"
Налични размери = Available Sizes"
The updater should do this for you. I think you should just try customfield String,"S"
"After that I've clicked on "Restore System Defaults"."
I fear that was wrong.
Thank you for your help, @Milbo.
What do you mean by that: "The updater should do this for you. I think you should just try customfield String,"S""
I'm afraid that I can't understand.
---------
"After that I've clicked on "Restore System Defaults"."
I fear that was wrong.
Should I re-migrate my website without doing this?
------------
Also, how could I fix this other error:
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 #__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_bg_bg as pm ON o.virtuemart_paymentmethod_id = pm.virtuemart_paymentmethod_id ORDER BY created_on DESC LIMIT 0, 30
Regards,
Kiko
Did you read the tutorials how to update?
the background to the sql error is customer_note changed ages ago from the orders (I think) to the virtuemart_order_userinfos
your table isn't up to date .. upgrading or using the table updater should fix this