En cours

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


Compétences : Joomla, Virtuemart

en voir plus : 500 jdatabasemysql jos_vm_product, fix erros, errors on page fix, errors on page, database virtuemart update, update virtuemart, 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, 1054 unknown, 1054, database updating, fix joomla database, virtuemart 500 error, limit virtuemart, updating site joomla

Concernant l'employeur :
( 4 commentaires ) Sebnitz, Spain

Nº du projet : #1680580