Magento Search error "Integrity violation" etc.

This blog post is pretty old. Be careful with the information you find in here. The Times They Are A-Changin'

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.