Update a VM with 2.6.20 to 3.0.10

[Nibiru7]

Good day! Updated VM 2.6.20 to 3.0.10, Joomla! 2.5.28. Now when you open any product in the administration panel, then there red color wrote:

Code Select Expand

vmError: getCustomEmbeddedProductCustomFields error in query Unknown column 'c.custom_desc' in 'field list' SQL=SELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`, c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`, field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`ordering` FROM `herbal_virtuemart_customs` AS c LEFT JOIN `herbal_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE `virtuemart_product_id` IN (240) ORDER BY field.`ordering`,`virtuemart_custom_id` ASC
Custom Fields:

Code Select Expand

vmError: The field with id 26 and title Вкус is not longer valid, please delete it from the list
vmError: The field with id 25 and title Выберите размер is not longer valid, please delete it from the list
vmError: The field with id 24 and title Тип кожи лица is not longer valid, please delete it from the list
vmError: The field with id 19 and title Выбор аромата is not longer valid, please delete it from the list

In the list of of goods, when the cursor is on any item in the tool bar displays the name of the first line is normal in the Russian, and the second reads "Change" and then unreadable.
What should be changed or what requests should be sent to the database?
P.S. Sorry for my bad English.

[Nibiru7]

And with the opening of "In stock": -

Code Select Expand

vmError: getCustomEmbeddedProductCustomFields error in query Unknown column 'c.custom_desc' in 'field list' SQL=SELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`, c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`, field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`ordering` FROM `herbal_virtuemart_customs` AS c LEFT JOIN `herbal_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE `virtuemart_product_id` IN (178) ORDER BY field.`ordering`,`virtuemart_custom_id` ASC
vmError: getCustomEmbeddedProductCustomFields error in query Unknown column 'c.custom_desc' in 'field list' SQL=SELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`, c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`, field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`ordering` FROM `herbal_virtuemart_customs` AS c LEFT JOIN `herbal_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE `virtuemart_product_id` IN (95) ORDER BY field.`ordering`,`virtuemart_custom_id` ASC
vmError: getCustomEmbeddedProductCustomFields error in query Unknown column 'c.custom_desc' in 'field list' SQL=SELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`, c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`, field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`ordering` FROM `herbal_virtuemart_customs` AS c LEFT JOIN `herbal_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE `virtuemart_product_id` IN (135) ORDER BY field.`ordering`,`virtuemart_custom_id` ASC
vmError: getCustomEmbeddedProductCustomFields error in query Unknown column 'c.custom_desc' in 'field list' SQL=SELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`, c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`, field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`ordering` FROM `herbal_virtuemart_customs` AS c LEFT JOIN `herbal_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE `virtuemart_product_id` IN (90) ORDER BY field.`ordering`,`virtuemart_custom_id` ASC
vmError: getCustomEmbeddedProductCustomFields error in query Unknown column 'c.custom_desc' in 'field list' SQL=SELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`, c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`, field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`ordering` FROM `herbal_virtuemart_customs` AS c LEFT JOIN `herbal_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE `virtuemart_product_id` IN (49) ORDER BY field.`ordering`,`virtuemart_custom_id` ASC
vmError: getCustomEmbeddedProductCustomFields error in query Unknown column 'c.custom_desc' in 'field list' SQL=SELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`, c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`, field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`ordering` FROM `herbal_virtuemart_customs` AS c LEFT JOIN `herbal_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE `virtuemart_product_id` IN (38) ORDER BY field.`ordering`,`virtuemart_custom_id` ASC
vmError: getCustomEmbeddedProductCustomFields error in query Unknown column 'c.custom_desc' in 'field list' SQL=SELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`, c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`, field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`ordering` FROM `herbal_virtuemart_customs` AS c LEFT JOIN `herbal_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE `virtuemart_product_id` IN (71) ORDER BY field.`ordering`,`virtuemart_custom_id` ASC
vmError: getCustomEmbeddedProductCustomFields error in query Unknown column 'c.custom_desc' in 'field list' SQL=SELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`, c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`, field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`ordering` FROM `herbal_virtuemart_customs` AS c LEFT JOIN `herbal_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE `virtuemart_product_id` IN (167) ORDER BY field.`ordering`,`virtuemart_custom_id` ASC
vmError: getCustomEmbeddedProductCustomFields error in query Unknown column 'c.custom_desc' in 'field list' SQL=SELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`, c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`, field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`ordering` FROM `herbal_virtuemart_customs` AS c LEFT JOIN `herbal_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE `virtuemart_product_id` IN (98) ORDER BY field.`ordering`,`virtuemart_custom_id` ASC
vmError: getCustomEmbeddedProductCustomFields error in query Unknown column 'c.custom_desc' in 'field list' SQL=SELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`, c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`, field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`ordering` FROM `herbal_virtuemart_customs` AS c LEFT JOIN `herbal_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE `virtuemart_product_id` IN (105) ORDER BY field.`ordering`,`virtuemart_custom_id` ASC
vmError: getCustomEmbeddedProductCustomFields error in query Unknown column 'c.custom_desc' in 'field list' SQL=SELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`, c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`, field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`ordering` FROM `herbal_virtuemart_customs` AS c LEFT JOIN `herbal_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE `virtuemart_product_id` IN (106) ORDER BY field.`ordering`,`virtuemart_custom_id` ASC
.......

[GJC Web Design]

have u tried in the VM Tools to update the tables and/or convert the customs?

Your using old field names..   custom_desc is now  custom_field_desc

[Nibiru7]

No, I did not do anything. Tell me what to fix.

[GJC Web Design]

?

have u tried in the VM Tools to update the tables and/or convert the customs?

[Nibiru7]

I updated the table. Updated format of arbitrary fields Order component 'VM2' on the format 'VM3. Red labels are gone. Custom fields do not appear on the site. By clicking "ask a question about this product" a window pops up with a shop and form of the question is absent.

[GJC Web Design]

Try on a standard template.. prob your template isn't VM3 compatible

[Nibiru7]

In the source code

Code Select Expand

        <div class="ask-a-question">
        <a class="ask-a-question" href="/" >Ask a question about this product</a>
        <!--<a class="ask-a-question modal" rel="{handler: 'iframe', size: {x: 700, y: 550}}" href="/">Ask a question about this product</a>-->
    </div>
It is seen that leads to the home page of the store. It used to be all right:

Code Select Expand

<div class="ask-a-question">
        <a class="ask-a-question" href="/[i]link[/i]-detail/askquestion?tmpl=component" >Ask a question about this product</a>
        <!--<a class="ask-a-question modal" rel="{handler: 'iframe', size: {x: 700, y: 550}}" href="/[i]link[/i]-detail/askquestion?tmpl=component">Ask a question about this product</a>-->
    </div>
What needs to change in the template?

And another:
When writing a product description, add links or other, pressing to save wherever there is a quotation marks in front of them appears insert

Code Select Expand

\"
Where necessary to fix it? Thank you.

[GJC Web Design]

Who can say?
obviously your template isn't VM3 compatible so you need to compare yours with the stock ones in components/com_virtuemart/views/... etc
and see where the differences are