CakePHP 3.1不保存简单的hasMany关系

我有两个实体，Site和SitesMetaData，我想将它们与hasMany和belongsTo关联起来。

我按照CakePHP 3.0书创建了所有内容，但由于某种原因，它没有生成或保存关联。

这是我的关系

SitesTable:

$this->hasMany('SitesMetaData', [
    'foreignKey' => 'site_id',
    'dependent' => true
]);

和SitesMetaDataTable(通过烘烤模型自动生成):

$this->belongsTo('Sites', [
    'foreignKey' => 'site_id',
    'joinType' => 'INNER'
]);

这是我的控制器功能:

    $site = $this->Sites->newEntity();
    if ($this->request->is('post')) {
        $site = $this->Sites->patchEntity($site, $this->request->data, ['associated' => ['SitesMetaData']]);
        if ($this->Sites->save($site)) {
            $this->Flash->success(__('The site has been saved.'));
            return $this->redirect(['_name' => 'admin:home']);
        } else {
            $this->Flash->error(__('The site could not be saved. Please, try again.'));
        }
    }

这里是$this->request->data和$site在patchEntity之后的转储:

 /src/Controller/Admin/SitesController.php (line 33)
[
'title' => 'test',
'alias' => 'sdfs',
'layout' => 'default',
'sort' => '3',
'sites_meta_data' => [
    (int) 0 => [
        'key' => 'keyword',
        'value' => 'test'
    ]
]
]
/src/Controller/Admin/SitesController.php (line 34)
object(App'Model'Entity'Site) {
'title' => 'test',
'alias' => 'sdfs',
'layout' => 'default',
'sort' => (int) 3,
'[new]' => true,
'[accessible]' => [
    'title' => true,
    'alias' => true,
    'layout' => true,
    'sort' => true
],
'[dirty]' => [
    'title' => true,
    'alias' => true,
    'layout' => true,
    'sort' => true
],
'[original]' => [],
'[virtual]' => [],
'[errors]' => [],
'[repository]' => 'Sites'
}

同样值得注意。我尝试使用TableRegistry::get('SitesMetaData')->newEntity和$this->request->data['sites_meta_data']创建SitesMetaData，它工作了，所以我将其设置为$site->sites_meta_data[]并将其设置为脏并尝试保存，我得到这个错误:

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'key, value, created, modified) VALUES (22, 'keyword', 'test', '2015-09-25 18:55:' at line 1

在本例中，22将是该站点创建后的ID。

尽管文档只提到需要在使用newEntity()和belongsToMany关联时这样做(据我所见)，我将sites_meta_data添加到站点实体的$_accessible属性，现在我得到上述SQL错误，即使使用$this->Sites->patchEntity($site, $this->request->data ...)，它现在正确构建SitesMetaData实体。