stephcrespo wrote:
I accidentally deleted the Euro currency

and now i get this error in the page
Currency is not formatted! Contact the administrator, if you are one go to http://**********.com/administrator/index.php?option=com_virtuemart&view=currency&task=edit&cid[]=47
Attention, couldnt find currency code in the table for id = 47
PLEASE HELP ME
Please use phpMyAdmin to browse your database, then click to "SQL" to show the sql window, paste this sql code then submit to back to before delete sate.
INSERT INTO `PREFIX_virtuemart_currencies` (`virtuemart_currency_id`, `virtuemart_vendor_id`, `currency_name`, `currency_code_2`, `currency_code_3`, `currency_numeric_code`, `currency_exchange_rate`, `currency_symbol`, `currency_decimal_place`, `currency_decimal_symbol`, `currency_thousands`, `currency_positive_style`, `currency_negative_style`, `ordering`, `shared`, `published`, `created_on`, `created_by`, `modified_on`, `modified_by`, `locked_on`, `locked_by`) VALUES
(47, 1, 'Euro', '', 'EUR', 978, 0.00000, '€', '2', ',', '', '{number} {symbol}', '{sign}{number} {symbol}', 0, 1, 1, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 0);
UPDATE `PREFIX_virtuemart_vendors` SET `vendor_currency`=144, `created_by`=0, `modified_by`=0;
UPDATE `PREFIX_virtuemart_categories` SET `created_by`=0, `modified_by`=0;
UPDATE `PREFIX_virtuemart_products` SET `created_by`=0, `modified_by`=0;
Where PREFIX is your table prefix.
After that, please retry configure. Please remember fill all required field in Shop configuration (include
Additional Information and
General User Information) first.
Thanks