- Posts: 13
- Thank you received: 0
getting errors using sort by manufacturers
-
irtiza110
Inactive member -
Topic Author
- New Member
-
Less
More
12 years 4 months ago #23391
by irtiza110
getting errors using sort by manufacturers was created by irtiza110
•vmError: exeSortSearchListQuery Unknown column 'm.mf_name' in 'order clause' SQL=SELECT SQL_CALC_FOUND_ROWS l.`virtuemart_product_id` FROM `nwb64_virtuemart_products_en_gb` as l JOIN `nwb64_virtuemart_products` AS p using (`virtuemart_product_id`) LEFT JOIN `nwb64_virtuemart_product_categories` ON p.`virtuemart_product_id` = `nwb64_virtuemart_product_categories`.`virtuemart_product_id` LEFT JOIN `nwb64_virtuemart_categories_en_gb` as c ON c.`virtuemart_category_id` = `nwb64_virtuemart_product_categories`.`virtuemart_category_id` LEFT JOIN `nwb64_virtuemart_product_shoppergroups` ON p.`virtuemart_product_id` = `nwb64_virtuemart_product_shoppergroups`.`virtuemart_product_id` LEFT OUTER JOIN `nwb64_virtuemart_shoppergroups` as s ON s.`virtuemart_shoppergroup_id` = `nwb64_virtuemart_product_shoppergroups`.`virtuemart_shoppergroup_id` WHERE ( p.`published`="1" AND `nwb64_virtuemart_product_categories`.`virtuemart_category_id` = 1 AND ( s.`virtuemart_shoppergroup_id`= "4" OR s.`virtuemart_shoppergroup_id` IS NULL ) ) group by p.`virtuemart_product_id` ORDER BY m.mf_name ASC LIMIT 0, 9
when I click on sort by Manufacturer name I get this error.
Can anyone help me. ?
info
Info: weigth_countries _weightCond orderWeight:0 method->weight_start:0 method->weight_stop:0 result:1
Info: weigth_countries _nbproductsCond nbproducts:1 method->nbproducts_start:0 method->nbproducts_stop:0 result:1
weigth_countries _orderamountCond cart_amount:1200 method->orderamount_start:0 method->orderamount_stop:0 result:
weigth_countries _zipCond zip:0
Also when I go and checkout just to test every page is showing the above info. ?
I get this above info as well on the page when I go to checkout submit all the fields.
when I click on sort by Manufacturer name I get this error.
Can anyone help me. ?
info
Info: weigth_countries _weightCond orderWeight:0 method->weight_start:0 method->weight_stop:0 result:1
Info: weigth_countries _nbproductsCond nbproducts:1 method->nbproducts_start:0 method->nbproducts_stop:0 result:1
weigth_countries _orderamountCond cart_amount:1200 method->orderamount_start:0 method->orderamount_stop:0 result:
weigth_countries _zipCond zip:0
Also when I go and checkout just to test every page is showing the above info. ?
I get this above info as well on the page when I go to checkout submit all the fields.
Please Log in to join the conversation.
-
ivan.milic
Support Staff -
- Moderator
-
Less
More
- Posts: 14116
- Thank you received: 1639
12 years 4 months ago - 12 years 4 months ago #23406
by ivan.milic
Replied by ivan.milic on topic getting errors using sort by manufacturers
Install fresh joomla/vm some-ware someware and compare databases tables/columns.
Also before that in Extension manager under the database tab you may find button that fixes database , if you see it click it.
Last note is that you make sure joomla/vm are updated.
Also before that in Extension manager under the database tab you may find button that fixes database , if you see it click it.
Last note is that you make sure joomla/vm are updated.
Last edit: 12 years 4 months ago by ivan.milic.
Please Log in to join the conversation.
Time to create page: 0.151 seconds