Thank you so much for all of your help with this!
The problem was I had to drop the index to that field in MySQL database. Your coding was correct to begin with. I Googled the error and it said it was caused because there is an index assigned to the field. I dropped it and voila.