Magento安装-标识符名称太长 [英] Magento Install - Identifier name is too long

问题描述

尝试使用Softaculous安装Magento时出现此错误.

I am getting this error while trying to install Magento using Softaculous.

Could not make the query numbered : 17
MySQL Error No : 1059
MySQL Error : Identifier name 'UNQ_60450534796045053479API2_ACL_RULE_ROLE_ID_RESOURCE_ID_PRIVILEGE' is too long

以前曾提出过这个问题，但没有答案，只是警告说mySQL的字符数不能超过64个.

This question has been raised before, but with no answers, just the admonition that mySQL has a limit of 64 characters.

如何让安装程序使用较小的标识符，或更笼统地说，我应该放弃Softaculous并尝试手动安装吗?

How do I get the installer to use a smaller identifier, or more generally, should I abandon Softaculous and try a manual install?

推荐答案

最新答案，但是如果其他人得到此答案，请在安装时在Softaculous Advanced设置中检查表前缀的长度，您可能会发现Softaculous已经做了一些事情就像"fhfhgsfdg_"一样.将其更改为仅四个字符，即"fhfh_"，您可能会发现它可以正常工作！

Late answer, but if anyone else gets this, In Softaculous Advanced settings when installing, check the length of the table prefix, you may find that Softaculous has done something long like "fhfhgsfdg_". Change it to four characters only, i.e. "fhfh_" and you may find it works!

这篇关于Magento安装-标识符名称太长的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！