カテゴリー:
エラー
閲覧数:220 配信日:2019-01-19 20:49
エラー修正内容
body を ANY_VALUE(`body`) AS body へ修正
エラー修正前
public function fetchByStateid2($state_id)
{
$sql = "
SELECT
a.id AS id,
a.category_id AS category_id,
a.state_id AS state_id,
a.body AS body,
a.created_at AS created_at,
a.modified AS modified,
topic_name,
r.body AS rbody,
r.modified AS rmodified,
u.display_name, u.site_id, c.category, s.situation, s.color,relationentrynum
FROM
status AS a
LEFT JOIN user u ON a.user_id = u.id
LEFT JOIN category c ON a.category_id = c.category_id
LEFT JOIN state s ON a.state_id = s.state_id
LEFT OUTER JOIN(
SELECT
topic_id,body, MAX(modified) AS modified, COUNT(topic_id) AS `relationentrynum`
FROM
res
GROUP BY topic_id
) AS r ON a.id = r.topic_id
WHERE a.state_id =:state_id
AND public = 1
ORDER BY created_at DESC
";
// echo $sql;
return $this->fetchAll($sql, array(
':state_id' => $state_id,
));
}
エラー修正後
public function fetchByStateid2($state_id)
{
$sql = "
SELECT
a.id AS id,
a.category_id AS category_id,
a.state_id AS state_id,
a.body AS body,
a.created_at AS created_at,
a.modified AS modified,
topic_name,
r.body AS rbody,
r.modified AS rmodified,
u.display_name, u.site_id, c.category, s.situation, s.color,relationentrynum
FROM
status AS a
LEFT JOIN user u ON a.user_id = u.id
LEFT JOIN category c ON a.category_id = c.category_id
LEFT JOIN state s ON a.state_id = s.state_id
LEFT OUTER JOIN(
SELECT
topic_id,ANY_VALUE(`body`) AS body, MAX(modified) AS modified, COUNT(topic_id) AS `relationentrynum`
FROM
res
GROUP BY topic_id
) AS r ON a.id = r.topic_id
WHERE a.state_id =:state_id
AND public = 1
ORDER BY created_at DESC
";
// echo $sql;
return $this->fetchAll($sql, array(
':state_id' => $state_id,
));
}