是否 MySQL Server 的 errors?

本帖最後由 toylet 於 2019-10-31 21:19 編輯

是否 MySQL Server 的 errors?

Source:
高院頒禁制令禁網上教唆暴力言論
http://cablenews.i-cable.com/ci/ ... B%E8%A8%80%E8%AB%96

A Database Error Occurred
Error Number: 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 'AND cna.`status` = 1 ' at line 21
SELECT cate.id AS cate_id, cate.name_cn AS cate_name, cna.id, cna.title, cna.lead AS `content_desc`, cna.picture AS pic_url, cna.vb AS video_url, cna.duration, cna.`status` AS `status`, cna.reference AS related, DATE_FORMAT(cna.mod_date, '%Y/%m/%d %H:%i') AS display_date, DATE_FORMAT(cna.crt_date, '%Y/%m/%d %H:%i') AS upload_date, DATE_FORMAT(cna.mod_date, '%Y/%m/%d %H:%i') AS last_update FROM cabNewsAll cna INNER JOIN vacStatus vs ON vs.inews_id = cna.id INNER JOIN category cate ON cate.id = cna.category WHERE cate.id = AND cna.`status` = 1 AND cate.`status` = 1 AND cna.vb != '' AND vs.web != 000 GROUP BY cna.mod_date DESC LIMIT 0, 12
Filename: models/Nps1_model.php
Line Number: 153