If someone could guide me through a solution to my error I will be happy to paypal you £20. I guess it would require running a script which I am not sure how to do.
Take a complete back-up of db and files. Install it in local. try this query
TRUNCATE `catalogrule`;TRUNCATE `catalogrule_product`;TRUNCATE `catalogrule_product_price`;
May be it helps.