Text only | Text with Images

VirtueMart Forum

VirtueMart 2 + 3 + 4 => General Questions => Topic started by: Nibiru7 on October 07, 2015, 03:35:53 AM

Title: Update a VM with 2.6.20 to 3.0.10
Post by: Nibiru7 on October 07, 2015, 03:35:53 AM
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
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
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.
Title: Re: Update a VM with 2.6.20 to 3.0.10
Post by: Nibiru7 on October 07, 2015, 03:38:57 AM
And with the opening of "In stock": -
Code Select
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
.......
Title: Re: Update a VM with 2.6.20 to 3.0.10
Post by: GJC Web Design on October 07, 2015, 10:55:01 AM
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
Title: Re: Update a VM with 2.6.20 to 3.0.10
Post by: Nibiru7 on October 07, 2015, 15:23:10 PM
No, I did not do anything. Tell me what to fix.
Title: Re: Update a VM with 2.6.20 to 3.0.10
Post by: GJC Web Design on October 07, 2015, 16:21:46 PM
??????????

have u tried in the VM Tools to update the tables and/or convert the customs?
Title: Re: Update a VM with 2.6.20 to 3.0.10
Post by: Nibiru7 on October 07, 2015, 18:07:51 PM
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.
Title: Re: Update a VM with 2.6.20 to 3.0.10
Post by: GJC Web Design on October 07, 2015, 20:01:58 PM
Try on a standard template.. prob your template isn't VM3 compatible
Title: Re: Update a VM with 2.6.20 to 3.0.10
Post by: Nibiru7 on October 08, 2015, 20:07:30 PM
In the source code
Code Select
        <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
<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
\&quot;
Where necessary to fix it? Thank you.
Title: Re: Update a VM with 2.6.20 to 3.0.10
Post by: GJC Web Design on October 08, 2015, 20:55:05 PM
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
Text only | Text with Images