Page 1 of 1

Forum Search and Install Error "Specified key was too long; max key length is 1000 bytes"

Posted: Thu Apr 01, 2021 5:52 pm
by Cary
Hi All,

Maybe I missed it but I can't seem to locate a search feature for the forum. Just hoping not to repeat a question/issue already addressed.

Trying to setup new shop (1.0.8.1) and migrate from 2.3.4. I'm getting an error using the New Installation for the database with MySQL 5.7.33 and PHP 7.4.16. Error "Specified key was too long; max key length is 1000 bytes". Same response with or without import sample data. Am I using the wrong MySQL or PHP or some other setting?

thanks,
Cary

Re: Forum Search and Install Error "Specified key was too long; max key length is 1000 bytes"

Posted: Thu Apr 01, 2021 6:02 pm
by Omar_one
answered on this post viewtopic.php?p=3853#p3853

Re: Forum Search and Install Error "Specified key was too long; max key length is 1000 bytes"

Posted: Thu Apr 01, 2021 6:04 pm
by ecartz
It's the box that says "Search this topic..." -- there's one on this page (look below the title). Or there's one that just says, "Search..." in the upper right. It doesn't seem that good with multiple words. Searching for 1000 finds viewtopic.php?p=3845#p3845 among others.

I.e. change your default tables from MyISAM to InnoDB. Or edit the affected columns from 255 to 250.

Re: Forum Search and Install Error "Specified key was too long; max key length is 1000 bytes"

Posted: Thu Apr 01, 2021 10:51 pm
by Cary
Thank you for the replies! Changing the default table storage engine from MyISAM to InnoDB with the server MySQL config file fixed the issue. The configuration file "/etc/my.conf" the line changed was to "default-storage-engine=InnoDB".

Regarding the search box, I still don't see it and I'm not seeing images posted by other users. Maybe just my current user level as a newbie in this forum.

Thanks Again for the prompt replies!

Re: Forum Search and Install Error "Specified key was too long; max key length is 1000 bytes"

Posted: Fri Apr 02, 2021 2:30 am
by ecartz
I see it if I switch to a different browser where I'm logged off:
Screenshot_20210401.png
Right hand side just below Register and Login. When logged in, I see Notifications, Private Messages, and my user name there. I suppose it's possible that a logged off user has more rights than a new user.