News:

Support the VirtueMart project and become a member

Main Menu

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

Started by lancealot_1977, November 03, 2012, 01:39:55 AM

Previous topic - Next topic

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

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.

Stonedfury

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

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

GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 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
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation