Attention, could not find currency code in the table for id = 1

[lancealot_1977]

Hi,

Everything in my setup has been going pretty smoothly; however, this so far is the only issue.

When looking at the front end, and selecting the order, I am getting this error message at the top. When scrolling down the first price is wrong, while the final item price is correct.

Appears to be only related to the front end.

[shangshunguk]

I had a similar issue and this fixed it for me (the table started with id 2, not id1)

http://forum.virtuemart.net/index.php?topic=96665.0

I solved this issue by inserting a copy of the record 144 currency id as 1 in table jml_virtuemart_currencies.  Apparently Virtuemart_currency_id 1 record is missing from the VM 2.0.6 install.

[Stonedfury]

Can I get more detail on the fix. Maybe the sql script to insert. Please

[rossm]

Hi shangshunguk,

This also fixed my problem. I copied record 144 (USD) in the myPhPAdmin dialog and set the virtuemart_currency_id to 1.  This removed my error.

Thanks!

[GJC Web Design]

http://www.gjcwebdesign.com/joomla-virtuemart-tips/766-virtuemart-2-0-attention-could-not-find-currency-code-in-the-table-for-id.html