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,"Â"," ");
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment