Menu

Topic-icon SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too lo

More
2 months 1 week ago #6733 by tsmithf
Just to confirm after coming across this issue, I was able to resolve it by changing the database collation to utf8_general_ci via Akeeba Admin Tools.
Normally I install Joomla via an upload via ftp and run the installation process, this uses the correct collation for Joomla, however the issue arose when I tried the installation via the automatic option built into our Plesk server, and it automatically set the dB tables collation to utf8mb4_unicode_ci
The installation failed as the OP indicated with this collation, but succesful with utf8_general_ci
The following user(s) said Thank You: Jose

Please Log in or Create an account to join the conversation.

More
2 months 1 week ago #6734 by Jose
Hi Trevor,

Thank you very very much for sharing this. I was not able to reproduce this issue, so your reply is gold for me.

Regards,
Jose

Please Log in or Create an account to join the conversation.

Time to create page: 0.074 seconds
Powered by Kunena Forum

Login or Sign In