I got this error on Q2A upgrade to 1.8. Server Ubuntu 14.04
Question2Answer was unable to perform the installation query below. Please check the user in the config file has CREATE and ALTER permissions:
UPDATE qa_iplimits SET ip = UNHEX(HEX(CAST(ip AS UNSIGNED)))
Error 1062: Duplicate entry '\x00-L' for key 'ip'