wmk

I love that PHPStorm comes with a mysql console; so if the DB is configured it also does autocomplete on sql queries

wmk

untested...

  1. UPDATE SiteTree_Localised
  2. LEFT JOIN SiteTree on SiteTree.ID = SiteTree_Localised.RecordID
  3. SET SiteTree_Localised.Sort = SiteTree.Sort

and the same for the Live tables.

wmk

get from default table, write to localised table. UPDATE JOIN SET in mysql.

pramesh

Can you explain more how to migrate the original values please? I have no idea

wmk

@pramesh well, if you add the Sort column to the localised tables you need to migrate the original value to it. This would explain the "random" order.