Đang Thực Hiện

Getting database errors after virtuemart update?

The site works fine, but since updating I have been getting database error messages "unknown colum" erros two I have fixed by just adding the fields in the database, but suddenly when my products are sorted by "default" the products do not show! they show when sort by "product name" or "price" they all work except for by "default"

I have a feeling the database has not updated correctly? as things seem to be going wrong since the update, can someone make sure all! is working fine and update and fix problem.

the error displays below when I try to view the page by "default" sort, i need that fixed and just if you can make sure all has been updates as I don't want to keep finding errors?

500 - JDatabaseMySQL::query: 1054 - Unknown column 'jos_vm_product_category_xref.product_list' in 'order clause' SQL=SELECT DISTINCT `jos_vm_product`.`product_id`, `product_name`, `products_per_row`, `category_browsepage`, `category_flypage`, `jos_vm_category`.`category_id`, `product_full_image`, `product_thumb_image`, `product_s_desc`, `product_parent_id`, `product_publish`, `product_in_stock`, `product_sku`, `product_url`, `product_weight`, `product_weight_uom`, `product_length`, `product_width`, `product_height`, `product_lwh_uom`, `product_available_date`, `product_availability`, `jos_vm_product`.`mdate`, `jos_vm_product`.`cdate` FROM (`jos_vm_product`, `jos_vm_category`, `jos_vm_product_category_xref`,`jos_vm_shopper_group`) LEFT JOIN `jos_vm_product_price` ON `jos_vm_product`.`product_id` = `jos_vm_product_price`.`product_id` WHERE `jos_vm_product_category_xref`.`product_id`=`jos_vm_product`.`product_id` AND `jos_vm_product_category_xref`.`category_id`=`jos_vm_category`.`category_id` AND `jos_vm_product_category_xref`.`category_id`=31 AND ((`jos_vm_product`.`product_id`=`jos_vm_product_price`.`product_id` AND `jos_vm_shopper_group`.`shopper_group_id`=`jos_vm_product_price`.`shopper_group_id`) OR `jos_vm_product_price`.`product_id` IS NULL) AND `jos_vm_shopper_group`.`default` = 1 AND `product_parent_id`=0 AND `product_publish`='Y' AND `category_publish`='Y' GROUP BY `jos_vm_product`.`product_sku` ORDER BY `jos_vm_product_category_xref`.`product_list` ASC LIMIT 0, 20

thanks

Kỹ năng: Joomla, Virtuemart

Xem thêm: fix erros, errors page, update virtuemart, null, joomla updating, errors, c errors, update database joomla, fix query, unknown database, works join, sql select order, joomla update error, 1054 unknown column select, error database problem, database fix, 1054 unknown, 1054, database updating, fix joomla database, virtuemart 500 error, limit virtuemart, updating site joomla, fix sql errors, virtuemart order page

Về Bên Thuê:
( 72 nhận xét ) Westcliff-on-Sea, United Kingdom

Mã Dự Án: #1076703