Using MySQL with Umbraco version 7.11.1, I am sure I have attempted this in previous versions as well with the same error. This time I felt like it might be good to see if anyone else has had this issue?

Exception Details

MySql.Data.MySqlClient.MySqlException: You can't specify target table 'umbracoRedirectUrl' for update in FROM clause

Stacktrace

at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
   at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
   at Umbraco.Core.Persistence.PetaPocoCommandExtensions.<>c__DisplayClass2_0.

Any Help would be great =]

David