#573 – mySQL error @1071 in line 76

Posted in ‘Support’

This is a public ticket. Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.

Friday, 05 April 2019 11:55 CEST

antomed

Joomla! version :
PHP version :
AdsManager version :

I have a problem with startup using quistart. The script ends on line 76 with "errno #1071 Specified key was too long; max key length is 767 bytes".
Please let me know how to go ahed.

Best regards,
Antonello

Custom Fields

Joomla Version	within quistart file
PHP Version	7.2.16
Product	AdsManager
Product Version	Quistart 3.2.3

Friday, 05 April 2019 13:30 CEST

loic

Hello,

The MySQL version on your server seems to be an old one.

Could you try to update it and retry the installation ?

Best regards.

Friday, 05 April 2019 13:41 CEST

antomed

Hello,

I can't update the mySQL ver because on server we have differents websites hosted.

Is there a solution without updating mySQL? I just tried to install Joomla 3 and goes well, the problem came from quistart.

Friday, 05 April 2019 13:52 CEST

loic

Hello,

The quickstart installation cannot be made then.

You can try to install each components, then the template, once its done, you can reproduce the configuration from the demo website.
demo.joomprod.com/adsclarity/administrator

You can log with the credentials, demo/demo

Best regards.

Friday, 05 April 2019 13:53 CEST

antomed

Ok thanks I'll try soon.

Monday, 08 April 2019 14:15 CEST

loic

Hello,

I let this ticket open in the meantime.

Best regards.

Friday, 12 April 2019 22:35 CEST

antomed

I solved only upgrading the mySQL version.

Thanks

This ticket is closed, therefore read-only. You can no longer reply to it. If you need to provide more information, please open a new ticket and mention this ticket's number.