Page 1 of 1

Upgrade to 7.4 Error: SQLSTATE[42000]

Posted: May 29th, 2020, 10:09 am
by wesnich
I'm trying to upgrade an existing instance of CSWeb to the new 7.4. I'm using MySql v5.6.47. I'm getting the following error after setting the configuration info:

CSWeb: Upgrade Database
Upgrading to version 4...

Error: SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes


Any ideas what is causing this and the best way to handle it?

Re: Upgrade to 7.4 Error: SQLSTATE[42000]

Posted: May 29th, 2020, 11:21 am
by josh
We have fixed that issue in the latest CSWeb 7.4 source. Please download it from here https://www.csprousers.org/downloads/