是否 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
  1. A Database Error Occurred

  2. Error Number: 1064

  3. 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

  4. 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

  5. Filename: models/Nps1_model.php

  6. Line Number: 153
複製代碼

是否 MySQL Server 的 errors?

Source:
toylet 發表於 2019-10-31 20:39


WHERE cate.id = AND

TOP

最尾個 "AND" 是多咗出來!

本帖最後由 toylet 於 2019-10-31 23:05 編輯
WHERE cate.id = AND
max918 發表於 31/10/2019 21:19

Thanks!!! 似乎是 bug.... 現在無事了! 有片睇!
有無攪錯.... 最尾個 "AND" 是多咗出來!
有無 大大 i-Cable 做 programming 的? 要 report bug!!!  
極可能是 stored procedure 砌錯 SQL command???

TOP

Thanks!!! 似乎是 bug.... 現在無事了! 有片睇!
有無攪錯.... 最尾個 "AND" 是多咗出來!  
有無  ...
toylet 發表於 2019-10-31 23:03


web site development隨時只係外判, 未必係i-cable自己寫
通常D公司都係搵web development公司寫code, 自己只做內容更新

TOP