Author Topic: Attention, could not find currency code in the table for id = 1  (Read 5718 times)

lancealot_1977

  • Beginner
  • *
  • Posts: 1
Attention, could not find currency code in the table for id = 1
« 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.

shangshunguk

  • Beginner
  • *
  • Posts: 2
Re: Attention, could not find currency code in the table for id = 1
« Reply #1 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

Quote
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

  • Jr. Member
  • **
  • Posts: 266
    • Stonedfury
  • Skype Name: Stonedfury
  • VirtueMart Version: 2.0.24
Re: Attention, could not find currency code in the table for id = 1
« Reply #2 on: December 27, 2012, 21:11:42 pm »
Can I get more detail on the fix. Maybe the sql script to insert. Please
No such thing as a stupid question, only a stupid answer. I won't ask if I know the answer or found it using the search as you suggested.

rossm

  • Beginner
  • *
  • Posts: 4
Re: Attention, could not find currency code in the table for id = 1
« Reply #3 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!

GJC Web Design

  • 3rd party VirtueMart Developer
  • Super Hero
  • *
  • Posts: 9245
  • Virtuemart, Joomla & php developer
    • GJC Web Design
  • VirtueMart Version: 3.6.8
GJC Web Design
VirtueMart and Joomla Developers - php developers http://www.gjcwebdesign.com
VM3 AusPost Shipping Plugin - e-go Shipping Plugin - VM3 Postcode Shipping Plugin - Radius Shipping Plugin - VM3 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
http://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation