-
-
Notifications
You must be signed in to change notification settings - Fork 313
Closed
Description
Description of the feature
short version
Request to add a piece of SQL in new DB version to fix inconsistent row in category due error caused by android version.
-- realign missing category
-- set as inactive with <recovery> info
UPDATE CATEGORY_V1
set active = 0,
PARENTID = -1,
CATEGNAME = CATEGNAME || " [recovered]"
where CATEGID = PARENTID;
long version
We discovered an issue on android (moneymanagerex/android-money-manager-ex#2187) that cause wrong parent assign to a category causing loopback to it self. So some record have id equal to parent id.
This rows was excluded from one_category view, so does not cause inconvenience or dump, but the are not visible.
Simple script above will make them visible (and inactive)
whalley