- Posts: 71
- Thank you received: 1
How to Change currency to US $
- Stephanie Crespo
-
Topic Author
- Offline
- Senior Boarder
-
- Linh Robert
-
- Offline
- Banned
-
- Stephanie Crespo
-
Topic Author
- Offline
- Senior Boarder
-
- Stephanie Crespo
-
Topic Author
- Offline
- Senior Boarder
-
12 years 8 months ago #2044
by Stephanie Crespo
Replied by Stephanie Crespo on topic Re: How to Change currency to US $
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
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 Log in or Create an account to join the conversation.
- Linh Robert
-
- Offline
- Banned
-
12 years 8 months ago - 12 years 8 months ago #2045
by Linh Robert
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.
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
If you need to send us FTP access / host access, administrator access or any private information:
services(at)omegatheme(dot)com or drop a ticket www.omegatheme.com/member/
Replied by Linh Robert on topic Re: How to Change currency to US $
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.
Code:
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
If you need to send us FTP access / host access, administrator access or any private information:
services(at)omegatheme(dot)com or drop a ticket www.omegatheme.com/member/
Last edit: 12 years 8 months ago by Linh Robert.
Please Log in or Create an account to join the conversation.
- Stephanie Crespo
-
Topic Author
- Offline
- Senior Boarder
-
Time to create page: 0.194 seconds