【解決】Joomla DisplayNews Error 1064當我更新Joomla 3.4.3創建更新模塊發生錯誤

7 月 22, 2015 | | 0 comments

當我更新Joomla 3.4.3時,創建的DisplayNews Module仍然是工作,但是當我嘗試創建一個新的DisplayNews Module,或是更新我舊有創建好的DisplayNews Module時候,我的網站整個掛了,得到了個錯誤訊息。

Error:

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 ') ) group by a.id ORDER BY a.created DESC LIMIT 0,1' at line 10 SQL=SELECT 'MOD_DN', a.id, a.*, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END as catslug, a.attribs, a.title, a.introtext as introtext, a.catid , a.created as created, a.images, cc.title as cat_title, cc.alias as cat_alias, cc.published as cat_published , cc.description as cat_description , cc.params as cat_params FROM fzhlib2_content AS a JOIN fzhlib2_users AS c ON c.id = a.created_by JOIN fzhlib2_categories AS cc ON cc.id = a.catid WHERE (a.state IN (1)) AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= 2015-07-22="" and="" a.publish_down="" or="">= '2015-07-22 01:45:43' ) AND (a.catid=0 OR cc.published = '1') AND (a.catid IN ( 38 ) ) AND (a.access IN ( ) ) group by a.id ORDER BY a.created DESC LIMIT 0,1

{googleads center}

如何解決DisplayNews Error 1064這個錯誤問題

在Joomla 3.4.3,你必須驗證訪問級別,這個竅門在DisplayNews論壇中被人給發現。只要依照下列說明設定,就可以恢復正常運作。

打開模組如下依序如下選項設定,將set access設定為PUBLIC級別。(詳細相關操作如下圖)

DisplayNews module  -> Tab "content selection option" -> set access =>> PUBLIC

 

影片操作教學