I am running a 9.5.1. store. I am unable to delete shipping methods in shippingmethod.aspx or shippingmethodrealtime.aspx trhough the admin. It gives an invalid column name error.
I tracked the problem down to the line in the .cs files 'delete from ShippingWeightByZone where ShippingMethodID = @ShippingMethodId' there is no column 'ShippingMethodID' in the 'ShippingWeightByZone' table. commenting out the line seems to work. I am then able to delete shipping methods. I want to make sure that everything that should be getting deleted in the various tables is? Should I be replacing this line with something else? It seems like for our store the 'ShippingWeightByZone' table is empty but I wonder if this will have an impact if we were to change shipping methods later on?
I can't run a full checkout on my dev site so I just want to make sure there are no unforeseen consequences before trying it on our live site.