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.
Did this help you out? It took me a few days to piece together all this information together, I hope this saves you some time (who knows, maybe the future me will be thankful I wrote this down). Let me know your thoughts. [email protected]