Utility/Structure Changes Required

Desmanthus · August 2010

No matter how many times I run index.php?p=/dashboard/utility/structure/all

"The following structure changes are required for your database."

update GDN_Permission p2
   inner join GDN_Category c
    on c.CategoryID = p2.JunctionID
       and p2.JunctionTable = 'Category'
      and c.Name = 'General'
   inner join GDN_Permission p
     on p.RoleID = p2.RoleID
       and p.JunctionTable is null
   set
      p.`Vanilla.Discussions.Add` = p2.`Vanilla.Discussions.Add`,
      p.`Vanilla.Discussions.Edit` = p2.`Vanilla.Discussions.Edit`,
      p.`Vanilla.Discussions.Announce` = p2.`Vanilla.Discussions.Announce`,
      p.`Vanilla.Discussions.Sink` = p2.`Vanilla.Discussions.Sink`,
      p.`Vanilla.Discussions.Close` = p2.`Vanilla.Discussions.Sink`,
      p.`Vanilla.Discussions.Delete` = p2.`Vanilla.Discussions.Sink`,
      p.`Vanilla.Discussions.View` = p2.`Vanilla.Discussions.Sink`,
      p.`Vanilla.Comments.Add` = p2.`Vanilla.Discussions.Sink`,
      p.`Vanilla.Comments.Edit` = p2.`Vanilla.Discussions.Sink`,
      p.`Vanilla.Comments.Delete` = p2.`Vanilla.Discussions.Sink`
   where p.RoleID <> 0;

Is this something anyone else has experienced? What does it mean?

basb · August 2010

same problem here:
http://vanillaforums.org/discussion/12492/utilitystructure-nothing-gets-changed/#Item_2

Desmanthus · August 2010

Any ideas on this?

zodiacdm · August 2010

Was this forum imported? it seems that this has to do with converting user permissions...

Desmanthus · August 2010

Yes imported from V1

zodiacdm · August 2010

Well, then I believe this question would be @Todd, though I would suggest creating a github issue for it.