Database Structure Upgrades

phreak

Hi all,

I recently did the Upgrade from RC3 to Vanilla 2.0.0 and tried to run the "Database Structure Upgrade" trought the URL ~/utility/structure/all.

I then pressed the button "Run structure & data scripts" which seemed to work > "The structure was successfully executed."

BUT, if i hit the Rescan Button, i get the same information like before and it shows me the same MySQL executes that should be done. Is this a loop?

The code Vanilla comes up with is following. Can i just execute this SQL in my 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;

Can i upgrade to 2.0.1?

Thanx
p*

Todd

That is actually a bit of SQL that gets executed every time the structure is run and isn't harmful at all. Go ahead and update.