Upgrade to 1.4.0 problems

Solutions for problems user may encounter during the upgrade to MMEX v1.4.0

Table of contents

• Windows protected your PC
• UNIQUE constraint failed: CURRENCYFORMATS_V1_NEW.CURRENCY_SYMBOL
• Translation cannot be loaded

Windows protected your PC

Symptom

Windows don't allow to run MMEX executable displaying following pop-up:

Solution

Read TechRepublic article Built-in SmartScreen technology provides extra protection in Windows 8 for details how to configure SmartScreen to allow run non-signed applications in Windows 8 & 10.

UNIQUE constraint failed: CURRENCYFORMATS_V1_NEW.CURRENCY_SYMBOL

Symptom

Upgrade fails with following message:

Solution

1. Start MMEX version v1.3.3

2. Open your database file. If you tried to open it with v1.4.0 earlier you should use backup copy with _upgrade_v7_ in the filename.

3. Download empty_symbol_in_used_curr.mmdbg

4. Run empty_symbol_in_used_curr.mmdbg script using Tools→Database→Database Debug menu command

5. If there are any currencies listed at the end of debug window:

   

   1. Open Tools→Organize Currency... dialog
   2. Find listed currency in left panel and select list entry
   3. Double clik (or press Edit button)
   4. Enter right currency symbol (like USD, EUR etc.) into Currency Symbol then press OK button. You can find right currency symbol at ISO 4217 Maintenance Agency website in xls or XML lists here or here.
   5. Repeat from step 4 above to verify all currencies are fixed

6. Download duplicated_symbol_in_used_curr.mmdbg

7. Run duplicated_symbol_in_used_curr.mmdbg script using Tools→Database→Database Debug menu command

8. If there are any accounts listed at the end of debug window:

   

   1. Open Accounts→Edit Account menu command, select account listed in debug window and press OK
   2. Press Currency button to change currency
   3. You must select only one currency for your all accounts using the same currency symbol like USD or EUR. You cannot use i.ex. EURO, My euro and EURO-ITALY in your accounts configuration if they use same EUR symbol. You should use only one of them and leave the rest unused.
   4. Press Select button after selecting right list item in the left panel
   5. Press OK button to close Edit Account dialog
   6. Repeat from step 7 above to verify all currencies are fixed

9. Download remove_all_unused_curr_history.mmdbg

10. Run remove_all_unused_curr_history.mmdbg script using Tools→Database→Database Debug menu command. It's OK if this fails with no such table: CURRENCYHISTORY_V1 error

11. Download remove_all_unused_curr.mmdbg

12. Run remove_all_unused_curr.mmdbg script using Tools→Database→Database Debug menu command

13. Exit from MMEX

14. Open your database with MMEX v1.4.0. If you tried to open it with v1.4.0 earlier you should use backup copy with _upgrade_v7_ in the filename. Your database should be upgraded to new version without errors now.

15. Download currencies_update_patch.mmdbg

16. Run currencies_update_patch.mmdbg script using Tools→Database→Database Debug menu command

Translation cannot be loaded

Symptom

Previously used language cannot be loaded and MMEX is started in different (i.e. English) language. Language selection option cannot be found in the Options settings.

Solution

Use View→Switch Application Language menu to select the preferred UI language then restart MMEX.