Skip to content

Adapt new dB version #7175

@wolfsolver

Description

@wolfsolver

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)

Metadata

Metadata

Assignees

Type

No type

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions