修改后台配置中的多个sku合并成一个spu(会出现Mysql错误,需要更改(common/config/main-local.php文件)
加入on afterOpen (我没有重启mysql服务该配置就自动生效了,刷新网页就行)
`
// Mysql部分的配置
'db' => [
'class' => 'yii\db\Connection',
'dsn' => 'mysql:host=127.0.0.1;dbname=fecmall',
'username' => 'root',
'password' => '123456',
'charset' => 'utf8',
'on afterOpen' => function ($event) {
$event->sender->createCommand("set session sql_mode = 'NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES'")->execute();
}
],