Friday 21 June 2013

Joomla 2.5 Virtuemart transfer issue


UPDATE j25_virtuemart_category SET category_description = replace(category_description,"Â"," ");

UPDATE j25_virtuemart_category SET category_description = replace(category_description,"”","\"");

UPDATE j25_virtuemart_category SET category_description = replace(category_description,"–","-");

UPDATE j25_virtuemart_category SET category_description = replace(category_description,"…",";");



UPDATE j25_virtuemart_categories_en_gb SET category_description = replace(category_description,"Â"," ");

UPDATE j25_virtuemart_categories_en_gb SET category_description = replace(category_description,"”","\"");

UPDATE j25_virtuemart_categories_en_gb SET category_description = replace(category_description,"–","-");

UPDATE j25_virtuemart_categories_en_gb SET category_description = replace(category_description,"…",";");



UPDATE j25_virtuemart_products_en_gb SET product_s_desc = replace(product_s_desc,"Â"," ");

UPDATE j25_virtuemart_products_en_gb SET product_s_desc = replace(product_s_desc,"”","\"");

UPDATE j25_virtuemart_products_en_gb SET product_s_desc = replace(product_s_desc,"–","-");

UPDATE j25_virtuemart_products_en_gb SET product_s_desc = replace(product_s_desc,"…",";");

UPDATE j25_virtuemart_products_en_gb SET product_desc = replace(product_s_desc,"Â"," ");

UPDATE j25_virtuemart_products_en_gb SET product_desc = replace(product_s_desc,"”","\"");

UPDATE j25_virtuemart_products_en_gb SET product_desc = replace(product_s_desc,"–","-");

UPDATE j25_virtuemart_products_en_gb SET product_desc = replace(product_s_desc,"…",";");

UPDATE j25_virtuemart_currencies_en_gb SET currency_symbol = replace(currency_symbol,"Â"," ");



No comments: