We are transitioning over to a new forum platform. Please post new issues there. Existing threads will be dealt with here unless you choose to move them over. Visit the new forum
Missing columns in shop_currencies
I have installed the Shop App on Perch Runway.
By default, GBP is the only enabled currency. Looking at the 'Formatting' fields, the 'Decimal point character' and the 'Thousands character' are empty even though they are required.
When I tried to enable another currency I filled those fields (needed to since they're required), but there was a small problem:
 SELECT * FROM perch2_shop_currencies WHERE currencyID='26' LIMIT 1 Using template: \addons\apps\perch_shop\templates\shop\currencies\currency.html UPDATE perch2_shop_currencies SET currencyCode='CAD', currencyTitle='Canadian dollar', currencySymbol='$', currencyDecimals='2', currencyRate='1.0000', currencyActive='1', currencySymbolPosition='before', currencyDecimalSeparator='.', currencyThousandsSeparator=',', currencyDynamicFields='' WHERE currencyID='26' Invalid query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'currencyDecimalSeparator' in 'field list'
I looked through the perch2_shop_currencies and couldn't find currencyDecimalSeparator or currencyThousandsSeparator, so I had to add them manually.
This is not a question; just reporting the missing columns (not sure whether posting a thread is the ideal way of reporting).
Want to reply to this thread?Login with Perch