web design, England, Britain, UK, belgium
 
Ulti Clocks content

VirtueMart 2.0 Attention, could not find currency code in the table for id - Joomla & VirtueMart Tips & How To's

VirtueMart 2.0 - Attention, could not find currency code in the table for id

Home Joomla VirtueMart Tips VirtueMart 2.0 Attention, could not find currency code in the table for id

Thu

31

Jan

VirtueMart 2.0 Attention, could not find currency code in the table for id
attention could not find currency code in the table for id
Your happily building your Virtuemart 2.0 site and see in the administration currencies a load the listed currencies that you will never use, 163 in fact. Obvious solution is to delete the ones you don't need as there is a big delete button on the top right - job done!

Now set your default currency which is well hidden under Shop -> Vendor -> Currency - all done.

virtuemart 2.0 set default currency

Check the front end and we have "Attention, could not find currency code in the table for id = 144"  !!!
(144 is US Dollar by the way)

Two solutions:

1. Open your database via phpMyAdmin and go to jos_virtuemart_currencies.
    You will see your remaining entries and also see that the table id it's asking for isn't there.
    Simple click "copy" and name the id as the missing id.

virtuemart 2.0 copy currency database

virtuemart 2.0 copy currency database 2

virtuemart 2.0 copy currency database 3

It is safe to delete entry 1 but if you do you need to re-select the currecy in the Shop -> Vendor -> List of accepted currencies.

2. You can also manually change the vendor table jos_virtuemart_vendors -> vendor_currency and jos_virtuemart_vendors -> vendor_accepted_currencies to the entry that was left after your deleting efforts.

virtuemart 2.0 vendor currency database

Last Updated on Friday, 01 February 2013 07:21
 
VirtueMart
Your Cart is currently empty.

Latest Joomla & VirtueMart Tips

See all tips & examples



VirtueMart 2.0 Attention, could not find currency code in the table for id|Joomla & VirtueMart Tips & How To's



VirtueMart 2.0 - Attention, could not find currency code in the table for id


currencies, vendor, currency, virtuemart, jos, table, delete, entry, shop, vendors, accepted, remaining, manually, entries, change, phpmyadmin, open, efforts, deleting, database, asking, solutions, safe, list, currecy, missing, copy, isn, simple, click, select, end, fact, obvious, solution, ones, use, listed, building, site

|

We use cookies to improve our website and your experience when using it. Cookies used for the essential operation of the site have already been set.
To find out more about the cookies we use and how to delete them, see our privacy policy.

I accept cookies from this site.