[Resolved] Look-See Security Scanner: MySQL error on table creation
I did install Look-See Security Scanner on a fresh wordpress 3.5.1 install, that I host myself.
I use MySQL 5.5.29-0ubuntu0.12.04.2 with MySQL charset: UTF-8 Unicode (utf8) , and tables in InnoDB format.
When I first ran Look-See Security Scanner, it asked my to install definition files, then again and again.
The apache logs state:
MySQL error: Specified key was too long; max key length is 767 for the table creation.
As a workaround, in wp-content/plugins/look-see-security-scanner/index.php I removed in the SQL table creation the line
UNIQUE KEY file2 (file,file_hash),
as the resulting key file2 is too long for my MySQL configuration (InnoDB).
See Prefix limitations on the MySQL documentation.
I’m sure there’s a better fix 🙂
- The topic ‘[Resolved] Look-See Security Scanner: MySQL error on table creation’ is closed to new replies.