installation with mysql error
i have this error when install with mysql:
Checking the database schema Can't load schema: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE INDEX part_of_user_id ON tig_users (user_id(255))' at line 1
Checking whether the database needs conversion Something wrong, the schema still is not loaded...
Loading socks5 component schema Can't load socks5 schema: Specified key was too long; max key length is 767 bytes
who can help me?
Added by Artur Hefczyc over 4 years ago
The scripts are not bugged for sure. We use them all the time.
Before we can help you with anything, please provide some more details:
What version of the Tigase server are you trying to install?
What version of MySQL do you use?
How do you install Tigase?
Where do you see the above errors - logs, console....
What operating system do you use?
Added by Costantino Riko87 over 4 years ago
i follow this tutorial to build last version: http://www.tigase.org/content/tigase-xmpp-server-520-and-later-compilation-and-generating-distribution-packages
i'm using MySQL Community Server 5.6.19 on Ubuntu/Debian 14.04 LTS (GNU/Linux 3.13.0-24-generic x86_64)