Magento Search error "Integrity violation" etc.
Hold on Cowboy
This blog post is pretty old. Be careful with the information you find in here. It's likely dead, dying, or wildly inaccurate.
Just an FYI, when you upgrade Magento, you may get an error for some searches. Just rebuild your search index and all should be well.