php - CakePHP发现未在查询中插入正确的引号

我正在使用此代码列出按类型计算和分类的卡车类型列表。

$count['type'] = $this->Type->find('all',
        array('joins' => array(
            array(
                'table' => 'truck_has_types',
                'alias' => 'TruckHasTypes',
                'type' => 'LEFT',
                'conditions' => array(
                    'Type.id' => 'TruckHasTypes.types_id',
                )
            )
        ),
        'fields' => array(
            'Type.id',
            'Type.name',
            'COUNT(TruckHasTypes.types_id) as N'),
            'group' => 'TruckHasTypes.types_id'
        )
    );

该查询仅返回单个结果，即使认为应该有更多结果。我找到了罪魁祸首。查询看起来像这样（从sql_dump中获得了此信息）

SELECT `Type`.`id`, `Type`.`name`, COUNT(`TruckHasTypes`.`types_id`) as N FROM `douglass_cake`.`types` AS `Type` LEFT JOIN `douglass_cake`.`truck_has_types` AS `TruckHasTypes` ON (`Type`.`id` = 'TruckHasTypes.types_id') WHERE 1 = 1 GROUP BY `TruckHasTypes`.`types_id`

你可以看到

ON (`Type`.`id` = 'TruckHasTypes.types_id')

没有相同的引号

ON (`Type`.`id` = `TruckHasTypes`.`types_id`)

我已经在phpmyadmin中手动添加了这些引号，并且查询成功，但是我无法让cakephp自动生成此查询。有任何想法吗？

谢谢！
瑞安

最佳答案

这样做：

$count['type'] = $this->Type->find('all',
    array(
        'joins' => array(
            array(
                'table' => 'truck_has_types',
                'alias' => 'TruckHasTypes',
                'type' => 'LEFT',
                'conditions' => array(
                    'Type.id=TruckHasTypes.types_id',
                )
            )
        ),
        'fields' => array(
            'Type.id',
            'Type.name',
            'COUNT(TruckHasTypes.types_id) as N'
        ),
        'group' => 'TruckHasTypes.types_id'
    )
);

关于php - CakePHP发现未在查询中插入正确的引号，我们在Stack Overflow上找到一个类似的问题：https://stackoverflow.com/questions/25585860/