Database Error | |
---|---|
Message: | MySQL Query fail: SELECT @rn:=@rn+1 AS rank, news_id, news_typeid, news_title, news_content, news_is_top, news_is_show, news_start_time, news_end_time, news_create_time, newstype_id, newstype_name, newstype_background_color FROM ( SELECT news_id, news_typeid, news_title, news_content, news_is_top, news_is_show, news_start_time, news_end_time, news_create_time, newstype_id, newstype_name, newstype_background_color FROM rabbit_news LEFT JOIN rabbit_newstype ON news_typeid = newstype_id WHERE news_is_show = 1 AND ((news_start_time = '0000-00-00' OR news_start_time <= '2024-03-28') AND (news_end_time = '0000-00-00' OR news_end_time >= '2024-03-28')) ORDER BY news_is_top DESC, news_create_time DESC ) t1, (SELECT @rn:=0) t2 |
MySQL Error: | 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 'rank, news_id, news_typeid, news_title, news_content, news_is_top, news_is_show,' at line 1 |
Date: | Thursday, March 28, 2024 at 5:27:15 PM |
Script: | /board.html?page=3 |
Referer: | http://demo.rabbit1.com.tw/board.html?page=3 |
Database Error | |
---|---|
Message: | MySQL Query fail: SELECT @rn:=@rn+1 AS rank, news_id, news_typeid, news_title, news_content, news_is_top, news_is_show, news_start_time, news_end_time, news_create_time, newstype_id, newstype_name, newstype_background_color FROM ( SELECT news_id, news_typeid, news_title, news_content, news_is_top, news_is_show, news_start_time, news_end_time, news_create_time, newstype_id, newstype_name, newstype_background_color FROM rabbit_news LEFT JOIN rabbit_newstype ON news_typeid = newstype_id WHERE news_is_show = 1 AND ((news_start_time = '0000-00-00' OR news_start_time <= '2024-03-28') AND (news_end_time = '0000-00-00' OR news_end_time >= '2024-03-28')) ORDER BY news_is_top DESC, news_create_time DESC ) t1, (SELECT @rn:=0) t2 LIMIT 0,15 |
MySQL Error: | 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 'rank, news_id, news_typeid, news_title, news_content, news_is_top, news_is_show,' at line 1 |
Date: | Thursday, March 28, 2024 at 5:27:15 PM |
Script: | /board.html?page=3 |
Referer: | http://demo.rabbit1.com.tw/board.html?page=3 |