安装shopware后，shopware主页显示以下错误

Question

我已经安装了商店软件完成后，不饱和前端显示下面的错误。请帮助解决此问题。

糟了！发生错误！

下面的说明应该会对你有所帮助。

执行'SELECT page.id，page.description，page.link，page.target，page.parentID，groups.key as group，mapping.key as mapping FROM s_cms_static page LEFT JOIN s_cms_static_groups groups ON groups.active =1 LEFT JOIN s_cms_static_groups mapping ON groups.mapping_id = mapping.id LEFT JOIN s_core_shop_pages shops ON groups.id = shops.group_id和shops.shop_id =？时出现异常。WHERE (groups.active = 1) AND (page.active = 1) AND (CONCAT('|'，page.grouping，'|') LIKE CONCAT('%|'，groups.key，'|%')) AND ((mapping.id IS NULL OR shops.shop_id IS NOT NULL)) AND ((mapping.id IS NULL OR mapping.active=1)) AND ((page.shop_ids IS NULL OR page.shop_ids LIKE ?))ORDER BY parentID ASC，mapping.key ASC，page.position ASC，page.description ASC‘with params 1，"%|1|%"：SQLSTATE42000:语法错误或访问冲突: 1064您的SQL语法有错误；请查看与您的MySQL服务器版本对应的手册，了解正确的语法，以便在vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php第1行的第1行使用near 'groups ON groups.active =1 LEFT JOIN s_cms_static_groups mapping ON groups.mapp

Answer 1

这个问题可能是由msql 8引起的，请看这个拉取请求：https://github.com/shopware/shopware/commit/f23aaf4ea571d4bae95b76a06bc1d673b4536931

我强烈建议使用shopware 5.5 (因为拉取请求与此版本合并)或尝试mariadb/一个较旧的mysql版本。