search

fromcouch / refreak

taskfreak fork
8 stars 4 forks source link

SQL Data - tables not being cleaned up after deletes #22

Closed rbur closed 11 years ago

rbur commented 11 years ago

After having created a couple of projects and then deleting them, I notice that the Manage >>Projects screen displays shows extra members on the existing project.

I have 3 users but the display shows 5. rf11

The SQL table (RFK_USERS) correctly contains the right number of users rf12

Table RFK_USERS_GROUPS data is ok.

The RFK_PROJECTS table contains 1 deleted project rf13

The RFK_PROJECT_STATUS table contains a deleted project. rf14

The RFK_USER_PROJECT contains wrong data rf15

fromcouch commented 11 years ago

You need first normalize data in tables.