Đ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


Kĩ năng: Joomla, Virtuemart

Xem nhiều hơn: jos_vm_product_category_xref product_list, virtuemart error unknown column product_name, fix erros, errors on page fix, errors on page, update virtuemart, null, joomla updating, errors, c++ 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

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

ID dự án: #1076703