The path for the manual fix of the cache is to be performed with KODI closed:
On Windows:
C:/Users/YOUR_USER_NAME/AppData/Roaming/KODI/userdata/Database/Addonsx.db
On Android:
sdcard/Android/data/org.xbmc.kodi/files/.kodi/userdata/