I have found at least 2 other posts covering this issue, but none of the solutions there helped me.

These are the posts:
www.csvimproved.com/forum/2-help/9307-error_retrieving_data.html
www.csvimproved.com/forum/2-help/5377-product-export-getting-mysql- error-message.html#5433

Virtuemart: 1.1.2
CSVI: 1.9
File exported (see bottom)

Basically, all I am trying to do is export the products from a website and import them into another. When I go export the producI get the error in the post tile:
Error_Retrieving_Data

In the log, the error seems to be a collation error. However, I checked the DB and the collation is utf8_general_ci wI believe it's right.

I also used the Maintenance tool to no avail.(as suggested in the other posts).

How can I get these products out of this shop and into the new store?


Sample Log:

Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=' SQL=SELECT jos_vm_product.product_id AS main_product_id, jos_vm_product.product_sku, jos_vm_product.product_parent_id, jos_vm_product_category_xref.category_id, `product_name`, `product_s_desc`, `product_desc`, jos_vm_product_price.product_price, jos_vm_product_price.product_currency, jos_csvi_currency.currency_code, jos_csvi_currency.currency_rate, `product_full_image`, `product_thumb_image`, `product_availability`, `product_available_date`, `product_currency`, jos_vm_product_discount.amount AS product_discount, jos_vm_product_discount.is_percent AS product_discount_is_percent, jos_vm_product_discount.end_date AS product_discount_date_end, jos_vm_product_discount.start_date AS product_discount_date_start, `product_packaging`, `product_publish`, `product_special`, jos_vm_tax_rate.tax_rate, `product_url` FROM jos_vm_product LEFT JOIN jos_vm_product_price ON jos_vm_product.product_id = jos_vm_product_price.product_id LEFT JOIN jos_vm_product_mf_xref ON jos_vm_product.product_id = jos_vm_product_mf_xref.product_id LEFT JOIN jos_vm_shopper_group ON jos_vm_product_price.shopper_group_id = jos_vm_shopper_group.shopper_group_id LEFT JOIN jos_vm_product_discount ON jos_vm_product.product_discount_id = jos_vm_product_discount.discount_id LEFT JOIN jos_vm_manufacturer ON jos_vm_product_mf_xref.manufacturer_id = jos_vm_manufacturer.manufacturer_id LEFT JOIN jos_vm_tax_rate ON jos_vm_product.product_tax_id = jos_vm_tax_rate.tax_rate_id LEFT JOIN jos_vm_product_attribute ON jos_vm_product.product_id = jos_vm_product_attribute.product_id LEFT JOIN jos_vm_product_attribute_sku ON jos_vm_product.product_id = jos_vm_product_attribute_sku.product_id LEFT JOIN jos_vm_product_category_xref ON jos_vm_product.product_id = jos_vm_product_category_xref.product_id LEFT JOIN jos_vm_category ON jos_vm_product_category_xref.category_id = jos_vm_category.category_id LEFT JOIN jos_csvi_currency ON jos_vm_product_price.product_currency = jos_csvi_currency.currency_code WHERE jos_vm_product_category_xref.category_id IN ('8','6','7','9','10','11','12','13','14','15','16','17','18','19','20 ','21','22','23','31','24','25','26','27','28','29','32') GROUP BY `product_sku`, `product_name`, `product_s_desc`, `product_desc`, `product_price`, `product_full_image`, `product_thumb_image`, `product_availability`, `product_available_date`, `product_currency`, `product_discount`, `product_discount_date_end`, `product_discount_date_start`, `product_packaging`, `product_publish`, `product_special`, `product_url` ORDER BY jos_vm_product.product_sku



FILE EXPORTED:

~product_sku~^~product_parent_sku~^~category_path~^~product_name~^~pro duct_s_desc~^~product_desc~^~product_price~^~product_full_image~^~prod uct_thumb_image~^~product_availability~^~product_available_date~^~prod uct_currency~^~product_discount~^~product_discount_date_end~^~product_ discount_date_start~^~product_packaging~^~product_publish~^~product_sp ecial~^~product_tax~^~product_url~
ERROR_RETRIEVING_DATA

Hello,

The error means you still have some different collations in your database. You can give the Phoca Collations tool a go to set it all straight.

In the log, the error seems to be a collation error. However, I checked the DB and the collation is utf8_general_ci wI believe it's right.It is not only the database but every column and every table must have the same collation. In your case that is the VirtueMart tables (jos_vm_xx) and the CSVI VirtueMart tables (jos_csvivirtuemart_xx).

Thank you for your replay, indeed, I checked the columns as well as the tables. Not in the entire Virtuemart table structure but in all the tables I figured would be involved in the export.
Naturally, it's very possible I missed a few. I'll check again and I'll give the pocha tool a spin.