VirtueMart Forum

VirtueMart 2 + 3 + 4 => Frontend Modules => Topic started by: lancealot_1977 on November 03, 2012, 01:39:55 AM

Title: Attention, could not find currency code in the table for id = 1
Post by: lancealot_1977 on November 03, 2012, 01:39:55 AM
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.
Title: Re: Attention, could not find currency code in the table for id = 1
Post by: shangshunguk on December 19, 2012, 14:35:30 PM
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

QuoteI 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.
Title: Re: Attention, could not find currency code in the table for id = 1
Post by: Stonedfury on December 27, 2012, 21:11:42 PM
Can I get more detail on the fix. Maybe the sql script to insert. Please
Title: Re: Attention, could not find currency code in the table for id = 1
Post by: rossm on February 17, 2013, 05:55:16 AM
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!
Title: Re: Attention, could not find currency code in the table for id = 1
Post by: GJC Web Design on February 17, 2013, 09:42:23 AM
http://www.gjcwebdesign.com/joomla-virtuemart-tips/766-virtuemart-2-0-attention-could-not-find-currency-code-in-the-table-for-id.html (http://www.gjcwebdesign.com/joomla-virtuemart-tips/766-virtuemart-2-0-attention-could-not-find-currency-code-in-the-table-for-id.html)