Upgrade to 7.4 Error: SQLSTATE[42000]

Other discussions about CSPro
Forum rules
New release: CSPro 8.0
Post Reply
wesnich
Posts: 11
Joined: June 5th, 2019, 11:16 pm

Upgrade to 7.4 Error: SQLSTATE[42000]

Post 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?
josh
Posts: 2399
Joined: May 5th, 2014, 12:49 pm
Location: Washington DC

Re: Upgrade to 7.4 Error: SQLSTATE[42000]

Post by josh »

We have fixed that issue in the latest CSWeb 7.4 source. Please download it from here https://www.csprousers.org/downloads/
Post Reply