phpMyAdmin says MySQL returned an empty result set (i.e. zero rows).
Posted on 2012-03-09
I am unable to edit or update rows in a certain table due to this error. It appears to happen on columns that have been changed to unicode and contain special characters such as & and \. I know this because if I edit the SQL query and remove these columns I return the record. I do see escape \ but I don't think a php mysql escape string was used. I suppose the data charset could be wrong as well. I don't really know. The default for the table and database now are unicode.
How can I fix this? Any suggestions would be greatly appreciated.