Error: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens
Error Code : HY093
SELECT
p.post_id,
p.image,
p.date_created as date,
p.views,
pd.name,
pd.description,
a.username,
a.firstname,
a.lastname,
a.email,
(
SELECT count(*)
FROM `oc_journal3_blog_comments` bc
WHERE
bc.status = 1
AND bc.post_id = p.post_id
AND bc.parent_id = 0
) as comments
FROM
`oc_journal3_blog_post` p
LEFT JOIN
`oc_journal3_blog_post_description` pd ON p.post_id = pd.post_id
LEFT JOIN
`oc_journal3_blog_post_to_store` p2s ON p.post_id = p2s.post_id
LEFT JOIN
`oc_user` a ON p.author_id = a.user_id
WHERE
pd.language_id = '1'
AND p2s.store_id = '0'
AND p.date_created <= NOW()
AND pd.tags LIKE '%:0%' AND p.status = 1 GROUP BY p.post_id ORDER BY p.date_created DESC LIMIT 0, 12: in /www/wwwroot/opencart.1jian.vip/system/library/db/pdo.php on line 90Error: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens
Error Code : HY093
REPLACE INTO `oc_session` SET `session_id` = :1, `data` = :2, `expire` = :3: in /www/wwwroot/opencart.1jian.vip/system/library/db/pdo.php on line 90Error: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens
Error Code : HY093
DELETE FROM `oc_session` WHERE `expire` < :4: in /www/wwwroot/opencart.1jian.vip/system/library/db/pdo.php on line 90