VM 3.0.14 upgrade to 3.0.17 database table crash

[malik0206]

Hi

I have upgraded my VM 3.0.14 store to 3.0.17 on joomla 3.5 and now i have database crash error

The whole website works apart from when trying to view product details

this is the error message i'm seeing can anyone help me restoring my store


1267 Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation 'ifnull' SQL=SELECT `u`.*,`pr`.*,`l`.`product_name`,`rv`.`vote`, IFNULL(`u`.`name`, `pr`.`customer`) AS customer FROM `#__virtuemart_rating_reviews` AS `pr` INNER JOIN `#__virtuemart_products_en_gb` AS `l` ON `l`.`virtuemart_product_id` = `pr`.`virtuemart_product_id` LEFT JOIN `#__virtuemart_rating_votes` AS `rv` on (`pr`.`virtuemart_rating_vote_id` IS NOT NULL AND `rv`.`virtuemart_rating_vote_id`=`pr`.`virtuemart_rating_vote_id` ) XOR (`pr`.`virtuemart_rating_vote_id` IS NULL AND (`rv`.`virtuemart_product_id`=`pr`.`virtuemart_product_id` and `rv`.`created_by`=`pr`.`created_by`) ) LEFT JOIN `#__users` AS `u` ON `pr`.`created_by` = `u`.`id` WHERE `pr`.`virtuemart_product_id` = "12" ORDER BY created_on DESC LIMIT 0, 3


Thanks

[jenkinhill]

See http://forum.virtuemart.net/index.php?topic=134447.msg467424#msg467424