I have a few products in my database where a long time ago the unit of measure was changed from unit to meter. There are stock moves with both uom categories.

Now I run into problems when trying to use openupgrade to upgrade to newer odoo versions. Actually my database is incosistent as there are different UoM for one product in the database. I can't delete the stock moves as they are already in 'done' state.

Is there any way to solve this problems? I think deleting from database could induce other problems. Updating the ancient stock moves from unit to m would be fine for me, as I actually don't need them.

I think, some SQL magic could help. Years ago I worked with SQL but never with database structure of openerp. Could anybody help me with correct sql syntax on how to update inventory moves from one uom to another? are there any other issues expected (like on old invoices or purchase orders)? What is the best way to restore consistency of my database?