Error on database column pr.customer

[micropalla]

Hello!
I have recently updated from VM 3.0.16 to VM 3.0.18 but something is wrong.
As I click on a product I receive the following:

Code Select Expand

1054 - Unknown column 'pr.customer' in 'field list' SQL=SELECT `u`.*,`pr`.*,`l`.`product_name`,`rv`.`vote`, IFNULL(`u`.`name` COLLATE utf8mb4_unicode_ci, `pr`.`customer` COLLATE utf8_unicode_ci) AS customer FROM `#__virtuemart_rating_reviews` AS `pr` INNER JOIN `#__virtuemart_products_it_it` 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` = "289" ORDER BY created_on DESC LIMIT 0, 3

What's wrong?
Thank you for your help!!

[micropalla]

I tryed to follow this https://forum.virtuemart.net/index.php?topic=135461.0 but it seems not to work (or more probably I don't execute the correct sql query, maybe you can help me...)

[GJC Web Design]

just follow this as written

and is there a field called 'customer' in your  #__virtuemart_rating_reviews table?

If not try the vm tools table updater or just add it

customer   varchar(128)    utf8_general_ci      No    NULL

[micropalla]

I tried but something is wrong.
I added the last line as in image.

Now it says

Code Select Expand

1054 - Unknown column 'pr.virtuemart_rating_vote_id' in 'on clause' SQL=SELECT `u`.*,`pr`.*,`l`.`product_name`,`rv`.`vote`, IFNULL(`u`.`name` COLLATE utf8mb4_unicode_ci, `pr`.`customer` COLLATE utf8_unicode_ci) AS customer FROM `#__virtuemart_rating_reviews` AS `pr` INNER JOIN `#__virtuemart_products_it_it` 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` = "169" ORDER BY created_on DESC LIMIT 0, 3

[micropalla]

No one knows?

Mod edit:  Please do not bump. Instead read http://forum.virtuemart.net/index.php?topic=104795.0

[Milbo]

There is no rating_vote_id, but why does the tableupdater not work for you?

[micropalla]

It says

Code Select Expand

1060 Duplicate column name 'custom_desc' SQL=ALTER TABLE `#__virtuemart_customs` CHANGE COLUMN `custom_field_desc` `custom_desc` char(255) COMMENT 'description or unit'

Thx!!

[Milbo]

Then you should take a look there (custom table), maybe your order of columns is not the same as in the install.sql.

[micropalla]

What's wrong with it?

[micropalla]

Ok, I did it. I dropped the duplicated field and used the tableupdater. Now it is all ok!
THX!!

[Milbo]

:-) Nice. Which field was doubled?

[micropalla]

custom_field_desc!!