I have recently move my website from an old server to a new one and seem to be getting the above error when trying to add, update or duplicate products. Although at first they were still being published to the site they now are not showing at all.
I have tried the following:
1) Cleared Cache - no joy
2) Reindex Data - no joy but the Category Flat Data and Product Flat Data is constantly reindexing and I can not reindex (this could be the issue)??
3) Deleted the LOCK files in /var/locks folder - no joy
I am really in a pickle here and would really love some help please.