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

[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

[Omar_one]

answered on this post viewtopic.php?p=3853#p3853

[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.

[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!

[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.