I’m using MySQL 5.6 on Windows Server 2008.
Before configuring openfire 3.8, when trying to import the MySQL tables from the resources file I get this:
“Error 1071 (42000) at line 57: Specified key was too long; max key lenght is 767 bytes”
It seems to be a problem with the ofRoster table creation… probably due to the JID being a varchar(1024)…
Can I change it to a varchar(255) without problems? Why does it have such a high size?