Hi,
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.
thanks
http://community.magento.com/t5/Technical-Issues/Catalogue-price-rules-deleted-still-applying/td-p/8...
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.